Get General Ledger Spreadsheet

1. Open Microsoft Excel, click the File tab, and then choose the New link. When the Available Templates window appears, type ledger into the search box, and then click the arrow button. Excel does not have a button on the Available Templates window for its collection of ledger templates, but it does offer them.

1. Open Microsoft Excel, click the File tab, and then choose the New link. When the Available Templates window appears, type ledger into the search box, and then click the arrow button. Excel does not have a button on the Available Templates window for its collection of ledger templates, but it does offer them.

Key Takeaways. A general ledger is a record of all of the accounts in a business and their transactions. Balancing a general ledger involves subtracting the total debits from the total credits. ... Credits increase liability, revenue, and equity accounts, while debits decrease them.

The general ledger contains the accounts used to sort and store a company's transactions. ... Balance sheet accounts: assets, liabilities, stockholders' equity. Income statement accounts: operating revenues, operating expenses, other revenues and gains, other expenses and losses.

Single-Entry Excel Bookkeeping. Step 2: Customize the chart of accounts within your template. Step 3: Customize the income statement sheet. Add a sheet for tracking invoices. Add a sheet for projecting cash flow. Inputting and Categorizing Transactions. Generating Income Statements.

A general ledger represents the record-keeping system for a company's financial data with debit and credit account records validated by a trial balance. The general ledger provides a record of each financial transaction that takes place during the life of an operating company.

When creating a general ledger, divide each account (e.g., asset account) into two columns. The left column should contain your debits while the right side contains your credits. Put your assets and expenses on the left side of the ledger. Your liabilities, equity, and revenue go on the right side.

General ledgers contain four parts: the chart of accounts, financial transactions, account balances and accounting periods. Generally, accountants refer to the accounts from the chart of accounts as general ledger accounts.

Using Excel Use a blank Excel worksheet to create a trial balance sheet. In row A, add the titles for each column: Account Name/Title, in column A, Debit, in column B and Credit in column C. Under Account Name/Title, list each of the accounts in your ledger.