Sample General Ledger format in Excel sheet available as example for accounts department of companies, factories, import, and export offices, small offices, production units to record the payments of customers, and clients.
Efficiently Manage Your Office Calculations With Our Advanced Calculators.
Usage Instructions:
Please download the ledger file in excel format, and put your company, and client information in the header of the general ledger. In the below section we have few entries as example for your understanding. Please remove those entries, and put your client transaction information into the ledger entries area. Any amount you receive will be placed in Credit and any amount remaining for payment you will post in into Debit section accordingly.
Sample General Ledger Example
| General Ledger: TopDocuments | ||||||||
| Semi Corp | ||||||||
| London | ||||||||
| Party Name & Address: | TopDocuments, Leeds, UK | |||||||
| Date | Description | Bill # | Qty. | Rate | Value | Debit | Credit | Balance |
| 12,980 Dr | ||||||||
| 10-Oct-10 | Big White Sticker Hanger | 721 | 5500 Pcs | 0.9 | 4,950 | 4,950 | 17,930 Dr | |
| 19-Oct-10 | 14,000 | 3,930 Dr | ||||||
| 5-Nov-10 | Big White Sticker Hanger | 767 | 55200 Pcs | 0.9 | 49,680 | 49,680 | 53,610 Dr | |
Image View of the Ledger Example in Excel
Download Links: