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.

Example rows
DateReferenceDescriptionDebitCreditBalance
2026-04-01OpenOpening balance, checking$12,400.00
2026-04-02Dep 118Customer payment, invoice 1031$2,850.00$15,250.00
2026-04-05Chk 2211Rent, April$2,000.00$13,250.00
2026-04-09CardCard processor deposit$1,740.25$14,990.25
2026-04-15ACHPayroll, 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 service
Questions

Still wondering?

Ask anything else on a free 30-minute call.

Book a call
What 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.

Get started

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.

Get a free quote

Your name, plus an email or a phone number, whichever you prefer.

A sentence or two is plenty. Please don't include Social Security numbers, bank or card numbers, or tax documents here.

Thanks. This is a design preview, so nothing was sent.