
Chart of Accounts Template
Sheets + Excel6 tabs
Free6 templates

Sheets + Excel6 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
FreeA bookkeeping template records where a small business's money came from and went, in a form an accountant can pick up. These sheets cover the chart of accounts, journal entries, a trial balance, an income and expense ledger, month-end close steps, a fixed asset register, prepaid and accrued expenses, loans, receivables aging, customer statements and a few ratio calculators.
Cover a chart of accounts with consistent names, the date, payee and category of each transaction, a column for the source document, such as an invoice number, monthly totals by category, a close checklist with an owner and date, and a check that debits equal credits, where double entry is used.
Schedule the December 2026 close for Monday, January 4, 2027, and put the checklist dates in the sheet now. Ask your accountant or the IRS or CRA how long you must keep records.
Compare Chart of Accounts Template, Fixed Asset Register, and Income and Expense Ledger, all 5 to 6 pages long, then pick the closest match and replace the sample text with your own.
A bookkeeping template records where a small business's money came from and went, in a form an accountant can pick up. These sheets cover the chart of accounts, journal entries, a trial balance, an income and expense ledger, month-end close steps, a fixed asset register, prepaid and accrued expenses, loans, receivables aging, customer statements and a few ratio calculators.
Include a chart of accounts with consistent names, the date, payee and category of each transaction, a column for the source document, such as an invoice number, monthly totals by category, a close checklist with an owner and date, and a check that debits equal credits, where double entry is used. Schedule the December 2026 close for Monday, January 4, 2027, and put the checklist dates in the sheet now. Ask your accountant or the IRS or CRA how long you must keep records.
Yes, for a small business with few transactions, a ledger sheet works well. As volume grows, many owners move to accounting software, and a clean spreadsheet history makes that switch easier.
Cash accounting records income and expenses when money moves. Accrual records them when they are earned or owed, which is why accrued expense and receivable sheets exist. Ask an accountant which method suits your business and tax filings.
A trial balance lists every account with its debit or credit balance. The two columns should match; if they do not, an entry is missing or posted wrong.
Start with Chart of Accounts Template: Coded accounts by type with normal side, opening balances and a check that debits equal credits. If that is not the right fit, compare it with Fixed Asset Register.
The templates here are 5 to 6 pages long. Cut any section you do not need; each template explains what its sections are for.
Yes. These bookkeeping templates work in Google Sheets and Microsoft Excel. All 6 templates are free, with no account or email needed.