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:

DateAccountDescriptionDebitCreditBalance
1/1/2023CashInitial balance$10,000.00$10,000.00
1/2/2023Accounts ReceivableSale of product X$500.00$9,500.00
1/5/2023Rent ExpenseRent for January$1,000.00$8,500.00
1/10/2023CashPayment for sale of product X$500.00$9,000.00
1/15/2023Accounts PayablePurchase of inventory$2,000.00$7,000.00
1/20/2023CashPayment 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    
         
DateDescriptionBill #Qty.RateValueDebitCreditBalance
        12,980  Dr
10-Oct-10Big White Sticker Hanger7215500 Pcs0.94,9504,950 17,930  Dr
19-Oct-10      14,0003,930  Dr
5-Nov-10Big White Sticker Hanger76755200 Pcs0.949,68049,680 53,610  Dr

Image View of the Ledger Example in Excel

General Ledger in Excel Free Download
General Ledger in Excel Free Download

Download Links:

Author: David Beckham

I am a content creator and entrepreneur. I am a university graduate with a business degree, and I started writing content for students first and later for working professionals. Now we are adding a lot more content for businesses. We provide free content for our visitors, and your support is a smile for us.

Please Ask Questions?