This software ensures the general ledger will sort all transactions through the proper accounts to create accurate financial records. With QuickBooks for Small Businesses you can connect all of your business accounts seamlessly and track all expenses in one place. In financial accounting, a company’s main accounting record is its general ledger.

However, you must still be able to comprehend your company’s financial data to properly make strategic business decisions. The set of 3-financial statements is the backbone of accounting, as discussed in our Accounting Fundamentals Course. A subsidiary ledger (sub-ledger) is a sub-account related to a GL account that traces the transactions corresponding to a specific company, purchase, property, etc. Sub-ledgers within each account provide details behind the entries documented in account ledgers, such as if they are debited or credited by cash, accounts payable, accounts receivable, etc. Yes, you can download QuickBooks’ free general ledger template for Excel to track your financial transactions and maintain accurate records of your business’s financial activities.

It provides a quick overview of which accounts have credit and debit balances to ensure that the general ledger is balanced faster than combing through every page of the general ledger. Consider the following example where a company receives a $1,000 payment from a client for its services. The accountant would then increase the asset column by $1,000 and subtract $1,000 from accounts receivable. The equation remains in balance, as the equivalent increase and decrease affect one side—the asset side—of the accounting equation. The account details can then be posted to the cash subsidiary ledger for management to analyze before it gets posted to the general ledger for reporting purposes. Subsidiary ledgers include selective accounts unlike the all-encompassing general ledger.

Controlling Accounts vs. Subsidiary ledger

It does not contain detailed information related to such an account, so you need to refer to a related subsidiary ledger in order to get details of such a control account. You may choose to conduct an internal audit or get your accounts audited by an accounting professional, so your general ledger acts as an important financial record. This is because your general ledger accounts record transactions under various account heads, providing detailed information on such accounts. As discussed before, the financial entries are first recorded in a general journal. For example, goods purchased with cash will be recorded in the the general journal as a journal entry.

Bookkeeping

A general ledger is the second most important book of entry after the Journal, because you record transactions under specific account heads in Ledger. In this instance, a subsidiary ledger records detailed information of the related control account. Having a general ledger may help the audit run smoothly, because you can easily verify information if various accounting items are classified and recorded accurately. As a result, general ledger accounting also helps you to spot material misstatements with regard to various accounts. A general ledger contains all the ledger accounts outside of the sales and purchases accounts. Therefore, you need to prepare various sub-ledgers providing the requisite details to prepare a general ledger.

These accounts help in organizing the general ledger accounts properly and recording transactions quickly. If you identify errors or misstatements, you can then take the requisite actions to make good the errors. If you are preparing the journal or ledger manually, you or your accountant will need to go through each of the accounts individually.

How do you fill out an accounting ledger template?

1. It’s the same order in which you’d encounter them if you were to read through the balance sheet and income statement.
2. A general ledger summarizes all the transactions entered through the double-entry bookkeeping method.
3. View transactions in a month-by-month, quarterly, or annual view for easy and accurate financial reporting.
4. The business updates the ledger by copying each of the entries in the books of prime entry to the appropriate account in the ledger.
5. The general ledger is one of the cornerstones of the double-entry accounting system.
6. So, if you want to know the amount a customer is expected to pay on a particular date, you’ll need to refer to your Customer’s Account in your general ledger.

You can prepare financial statements once you have verified the accuracy of your ledger accounts. Income statement accounts, like operating and non-operating income, and expenses start afresh with every accounting period. So, at the beginning of the accounting period, these accounts must have a NIL balance. In a general ledger, you can easily find information like a sales transaction, purchase transaction, etc. Needless to say, General Ledger is one of the primary books of entry and it forms the basis of your financial statements and helps you in evaluating the financial affairs of your firm. The accounting professional auditing your company accounts may also ask for things like sales receipts, purchase invoices, in order to check if proper amounts were charged.

Use this template to ensure an accurate record of all line-item transactions for any journal entry or transaction type. Save this accounting general ledger template as a one-off file, or share it as a template with your accounting team to standardize financial reporting practices. In accounting software, a general ledger sorts all transaction information through the accounts. Also, it is the primary source for generating the company’s trial balance and financial statements. The ledger’s accuracy is validated by a trial balance, which confirms that the sum of all debit accounts is equal to the sum of all credit accounts. To correctly record an increase or decrease to an account within your business, you will need to use debit and credit for the double-entry bookkeeping method.

General Ledger with Budget Comparison Template

That is, at any point in time, the resources or the assets of your business must equate to the claims of owners and outsiders. This is because owners and the outsiders are the ones who go in for providing such resources. In other words, you record the relevant transactions under the individual general ledger accounts, which are recorded based on the Duality Principle of Accounting. Here’s an example of a journal entry to record the purchase bom meaning of $500 of office supplies using the funds in your cash account. Debiting an asset or expense account increases its current balance, while crediting them decreases it. Conversely, crediting a revenue, liability, or equity account increases its current balance, and debiting them increases it.

I don’t pay for much with checks anymore, but when I do write one to pay rent every month, I always write down the check number and the amount in the little paper ledger at the front of my checkbook. Shaun Conrad is a Certified Public Accountant and CPA exam expert with a passion for teaching. After almost a decade of experience in public accounting, he created MyAccountingCourse.com to help people learn accounting & finance, pass the CPA exam, and start their career.

You also match general ledger account balances to source documents to see if the accounts are accurate. However, with online accounting software like QuickBooks, general ledger reconciliation has become a lot easier. As a result, you what is an invoice and how do i make one do not record details of each sales transaction undertaken with your customers in the accounts receivable control account. But, you can refer to the related subsidiary account if you need to check any detail regarding the sales made to a specific customer. Now, each of your transactions will follow a procedure before they are entered in the final books of accounts. First, the transactions are recorded in the original book of entry, known as the journal.

Additional Resources

Of course, your general ledger’s appearance will ultimately depend on your personal preference and choice of software. For example, it may also contain details like a reference number or activity type for each transaction. See our collection of Excel accounting templates for additional accounting resources. As the business grows and the number of accounting staff increases it is impractical to have only one ledger. In these circumstances it is common to split off sections of the main ledger into separate subledgers. The next line shows the headings used for each of the ledger accounting transaction entries.