A general ledger template is a structured spreadsheet or form where you record every business transaction by account, using columns for the date, account, description, debit, and credit. Set up correctly, it keeps your books balanced through double-entry bookkeeping and gives you a traceable history the IRS will accept. Setup takes under an hour; the discipline is in how you use it afterward.
What the Template Needs
Every functional ledger has the same core columns. A date column keeps entries in chronological order so you can tie them to bank statements, invoices, and receipts. An account name or number column links the entry to your chart of accounts. A description gives context: “payment to ABC Supply for office chairs” is far more useful during an audit than a bare dollar amount.
The two columns that do the real work are debits and credits. Every transaction hits at least two accounts, one debited and one credited, and the amounts must offset. That is double-entry bookkeeping, and it enforces the accounting equation: assets equal liabilities plus owner’s equity. If total debits don’t match total credits, something is wrong, and the mismatch ripples into every statement you produce downstream. A reference column for invoice or check numbers finishes the template and makes it much easier to trace an entry back to its source document.
Build a Chart of Accounts First
Don’t open a template before you have a chart of accounts. This is the numbering system that tells your ledger where each transaction belongs. Every account falls into one of five categories: assets, liabilities, equity, revenue, and expenses. The standard convention numbers assets from 1000, liabilities from 2000, equity from 3000, revenue from 4000, and expenses from 5000. You aren’t required to use those exact numbers, but the convention makes life easier if you later migrate to accounting software or hand the books to a professional.
A simple service business might need only 15 to 20 accounts: checking account, accounts receivable, accounts payable, owner’s equity, service revenue, rent expense, and so on. A retail operation tracking inventory, cost of goods sold, and sales tax payable will need more. Start lean. You can always add accounts later, but consolidating a bloated chart after a year of entries is painful. Each account gets its own section in the ledger, so every account you create is another running balance to maintain.
Where to Get the Template
Microsoft Excel includes pre-built general ledger templates in its template gallery. Open Excel, search for “general ledger,” and you’ll find basic grid structures with built-in formulas that auto-calculate running balances. Google Sheets offers similar options through its template gallery, with the added benefit of cloud-based collaboration if multiple people need access. Both are free and work well for a manageable transaction volume.
If your volume is high enough that manual entry becomes a bottleneck, accounting software like QuickBooks or Xero generates the ledger automatically from the transactions you record. The software handles double-entry mechanics behind the scenes, so you enter a sale once and the system posts debits and credits to the correct accounts. Subscription fees typically run $15 to $75 per month, but for businesses processing hundreds of transactions monthly, the time savings and reduced error rate justify the cost. Free downloadable templates from accounting education sites fill the middle ground between a blank spreadsheet and full software.
How to Record a Transaction
Start with the transaction date, then identify which accounts are affected. Say you pay $1,200 in rent by check. You debit Rent Expense for $1,200 (expenses increase with debits) and credit Cash for $1,200 (assets decrease with credits). Both entries share the same date and description, and the amounts match. That is the core mechanic for every entry you’ll ever make.
A few rules keep the process clean. Enter transactions as they happen or at least weekly; letting a month of receipts pile up is where errors creep in. After each session, sum total debits and total credits across all accounts. If they don’t match, stop and find the discrepancy before entering anything else. Common culprits are transposed digits, entries posted to the wrong account, and one-sided entries where you recorded the debit but forgot the credit. Catching these early takes minutes. Finding them at year-end can take hours.
Cash Basis or Accrual Basis
Your accounting method changes when you record a transaction, which directly affects how you use the template. Under cash basis, you record revenue when cash hits your bank account and expenses when you actually pay them. Under accrual basis, you record revenue when you earn it and expenses when you incur them, regardless of when money changes hands. If you invoice a client in December but don’t get paid until January, cash basis puts the revenue in January; accrual basis puts it in December.
Most small businesses start with cash basis because it is simpler and matches what they see on their bank statements. The IRS allows cash basis for most small businesses, though businesses with inventory or average annual gross receipts above $30 million over the prior three years generally must use accrual. Whichever method you choose, apply it consistently. Switching mid-year creates a mess that is difficult to untangle and may require IRS approval.
Adjusting Entries at Period End
Raw transaction entries don’t tell the whole story. At the end of each accounting period, you’ll need adjusting entries for transactions that have occurred economically but haven’t been recorded yet. These fall into a few standard categories.
- Accrued expenses: bills you owe but haven’t paid yet, like utilities consumed in December but billed in January. Debit the expense account, credit accounts payable.
- Accrued revenue: work you’ve completed but haven’t invoiced. Debit accounts receivable, credit revenue.
- Deferred expenses: costs paid in advance, like a 12-month insurance premium. Record the full payment as a prepaid asset, then expense one-twelfth each month.
- Deferred revenue: payments received before you deliver the goods or service. The cash sits in a liability account until you earn it.
- Depreciation: spreading the cost of equipment, vehicles, or furniture over their useful life. Debit depreciation expense, credit accumulated depreciation. You’ll need the asset’s original cost, estimated useful life, and salvage value to calculate the amount.
Adjusting entries follow the same double-entry rules as regular transactions. They just tend to involve accounts that don’t show up in day-to-day bookkeeping, like accumulated depreciation or prepaid insurance. If you’re on cash basis, you’ll skip most of these; they are primarily an accrual basis requirement.
Closing the Books at Year End
At the end of your fiscal year, close temporary accounts (revenue, expenses, and drawing or dividend accounts) by zeroing them out and transferring their net balance into retained earnings for corporations or owner’s equity for sole proprietors and partnerships. This resets income and expense accounts for the new year while preserving cumulative profit or loss in a permanent equity account.
The closing process works in steps. Transfer all revenue account balances to an income summary account. Then transfer all expense balances to the same income summary. The net difference (your profit or loss) moves from income summary into retained earnings or owner’s equity. After closing, run a post-closing trial balance that lists only permanent accounts: assets, liabilities, and equity. If total debits equal total credits on that report, your books are clean and ready for the new period. If they don’t, there is an error in the closing entries that needs to be tracked down before you move on.
What the IRS Expects You to Keep
The IRS doesn’t prescribe a specific recordkeeping format. A spreadsheet, accounting software, or paper ledger all work, provided your system clearly shows your gross income, deductions, and credits. Beyond the ledger entries themselves, retain the supporting documents that back up each transaction: sales slips, invoices, receipts, deposit slips, canceled checks, and bank statements. Those documents are what prove your entries are real if the IRS comes asking.1Internal Revenue Service. Publication 583 – Starting a Business and Keeping Records
Electronic records meet the same standard as paper ones. If you keep your ledger in Excel or accounting software, the IRS requires that the system be able to index, store, preserve, retrieve, and reproduce records in a legible format.1Internal Revenue Service. Publication 583 – Starting a Business and Keeping Records In practice, that means regular backups and a file-naming system that lets you find the right document quickly. A shoebox of receipts scanned to one unlabeled folder doesn’t cut it.
How long to keep records depends on what the document supports. The general rule is to keep records as long as they are needed to prove income or deductions on a tax return. Employment tax records must be kept for at least four years after the tax becomes due or is paid, whichever is later.2Internal Revenue Service. Recordkeeping For most other business records, three years from the filing date covers the standard audit window. The IRS can look back six years if gross income is understated by more than 25 percent, and seven years applies if you claim a deduction for worthless securities. When in doubt, keep records longer rather than shorter. Storage is cheap; reconstructing lost records during an audit is not.
Where those numbers land on your return depends on entity type. Sole proprietors report business income and expenses on Schedule C of Form 1040.3Internal Revenue Service. Instructions for Schedule C (Form 1040) Corporations report the same information on Form 1120.4Internal Revenue Service. About Form 1120, U.S. Corporation Income Tax Return Both start from a ledger. If the ledger is wrong, the return is wrong.
There is no standalone IRS penalty for “bad recordkeeping,” but the practical consequence is harsh. If you can’t substantiate deductions or income during an examination, the IRS can disallow those deductions or reconstruct your income using its own estimates. The resulting tax bill, plus accuracy-related penalties of 20 percent on the underpayment, tends to dwarf whatever the recordkeeping would have cost.
Protecting the File
A ledger sitting on a shared drive with no access restrictions is an invitation for errors and fraud. Limit editing access to the people who actually record transactions. If you’re using a spreadsheet, password-protect the file and lock cells containing formulas so no one accidentally overwrites your running balance calculations. Cloud-based tools like Google Sheets let you set permissions by user and maintain a version history showing who changed what and when.
The owner should review the ledger monthly and reconcile it against bank and credit card statements. Look for entries without supporting documents and any account balance that moved in an unexpected direction. Back up the file regularly to a separate location. A corrupted spreadsheet or crashed hard drive with no backup means reconstructing your financial history from source documents, which is expensive to hire out and agonizing to do yourself. Automated cloud backups through Google Drive, OneDrive, or Dropbox solve this with minimal effort.