General Ledger Format in Excel Free Download

Sample General Ledger format in Excel sheet available as an example for accounts department of companies, factories, import, and export offices, small offices, and production units to record the payments of customers, and clients.

Perfect Example of General Ledger Format

A general ledger format typically consists of several columns that organize accounting transactions for a business. The columns may include:

1. Date: The date the transaction occurred.
2. Account: The name of the account that was affected by the transaction.
3. Description: A brief description of the transaction.
4. Debit: The amount of money that was debited from the account.
5. Credit: The amount of money that was credited to the account.
6. Balance: The running balance of the account after each transaction.

Here is an example of a general ledger format:

Date	Account	Description	Debit	Credit	Balance
1/1/2023	Cash	Initial balance	$10,000.00		$10,000.00
1/2/2023	Accounts Receivable	Sale of product X		$500.00	$9,500.00
1/5/2023	Rent Expense	Rent for January	$1,000.00		$8,500.00
1/10/2023	Cash	Payment for sale of product X	$500.00		$9,000.00
1/15/2023	Accounts Payable	Purchase of inventory	$2,000.00		$7,000.00
1/20/2023	Cash	Payment for rent		$1,000.00	$8,000.00

In this example, the general ledger tracks various transactions such as the sale of a product, payment of rent and utilities, and the purchase of inventory. The ledger also keeps track of the account balances as they change with each transaction. This format allows businesses to easily monitor their financial transactions and maintain accurate records.

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 a few entries as examples 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 the 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:

• General Ledger in Excel Free Download