General ledger template
A general ledger is the full record of every transaction in your books, by account, with debits, credits and a running balance. This free template gives you the standard columns and keeps the balance for you. It suits a very small business keeping its books by hand, or anyone learning how double-entry works.
Updated November 2026
What does the template look like?
Type one row per entry. Totals add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Date | Reference | Description | Debit | Credit | Balance |
|---|---|---|---|---|---|
| 2026-04-01 | Open | Opening balance, checking | $12,400.00 | ||
| 2026-04-02 | Dep 118 | Customer payment, invoice 1031 | $2,850.00 | $15,250.00 | |
| 2026-04-05 | Chk 2211 | Rent, April | $2,000.00 | $13,250.00 | |
| 2026-04-09 | Card | Card processor deposit | $1,740.25 | $14,990.25 | |
| 2026-04-15 | ACH | Payroll, first half April | $4,310.80 | $10,679.45 | |
| Total | $4,590.25 | $6,310.80 |
What is a general ledger?
Every transaction in double-entry bookkeeping is recorded twice: a debit to one account and a credit to another. The general ledger holds those entries, grouped by account, so you can see each account's activity and balance. Add up every account and you get the trial balance, and from that the profit and loss and balance sheet.
Do I need one if I use software?
No. QuickBooks Online and Xero keep the ledger for you and you can run the General Ledger report at any time. A spreadsheet ledger works for a very small or brand new business, but it gets slow once you have more than a few dozen transactions a month, or employees, or sales tax.
How do debits and credits work?
Debits raise asset and expense accounts. Credits raise liability, equity and income accounts. So a customer payment is a debit to cash and a credit to income, or to accounts receivable if you invoiced first. Use the chart of accounts template to keep account names consistent.
Sources
General information, not tax advice for your situation.
Want your books off your plate?
One accountant keeps them current, every month.
See our bookkeeping serviceWhat is the difference between a general ledger and a general journal?
The journal lists entries in date order as they happen. The ledger sorts the same entries by account.
How long should I keep the general ledger?
As long as it supports a tax return, usually at least three years after filing, and seven for some records. Many owners keep it for good.
Can I switch from a spreadsheet to QuickBooks later?
Yes. Start the software with your opening balances on a month end, and keep the spreadsheet as history.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.