A spreadsheet is where a lot of business owners keep their first set of books, and Google Sheets is a fine place to start. The tool is free, it lives in the cloud, and you can build a working ledger in an afternoon.
The catch is that a template is only as good as the way you set it up. Get the columns and one formula right and you have a tidy record of every dollar in and out.
Below, you get the columns a bookkeeping template needs, the exact formula that keeps your running balance correct, and the point where a spreadsheet stops being enough.
TL;DR: How Do You Make a Bookkeeping Template in Google Sheets?
Open a blank Google Sheet and add columns for the date, a description, a category, income, expense, and a running balance. Put a simple formula in the balance column so it updates itself as you type, then log every transaction and reconcile against your bank each month. Keep it on one accounting method and the sheet stays a reliable record you can hand to a bookkeeper or your CPA.
- ●Six columns. Date, description, category, income, expense, running balance.
- ●One formula. The balance cell adds income and subtracts expenses from the row above.
- ●Reconcile monthly. Match the sheet to your bank statement so errors never pile up.
Why Use Google Sheets for Bookkeeping
Google Sheets works for early bookkeeping because it removes the usual barriers. Anyone with a free Google account can open one, from any device, with nothing to install. Several people can work in the same file at once, and every edit saves on its own.
You also control who sees what. As the owner you decide who can view, comment, or edit, so your numbers stay private while your bookkeeper or partner gets the access they need. For the basics of setting up a system, our guide to bookkeeping 101 covers the ground.
Google Sheets has real limits, though, and most growing businesses outgrow a spreadsheet. Knowing the ceiling up front helps you decide how far to build before you hand the books off.
What Goes in a Bookkeeping Template
A bookkeeping template is really just a transaction ledger: one row per transaction, one column per detail you want to track. Start with these columns and add more only when you need them.
| Column | What It Holds |
|---|---|
| Date | The date of each transaction. |
| Description | A short note on what it was for. |
| Category | The income or expense type, from your chart of accounts. |
| Income | Money in, entered as a positive number. |
| Expense | Money out, kept in its own column. |
| Balance | A running total that updates after every row. |
Separating income and expense into their own columns beats a single amount column, because it makes your month-end totals a one-cell formula. Your category column is where a sample chart of accounts pays off, since consistent categories are what make your reports readable later.
Pick one accounting method, cash or accrual, and record every transaction the same way. The IRS rules on accounting methods explain the difference, and which one you use for taxes is worth a quick word with your CPA.
How to Set Up Your Bookkeeping Template in Google Sheets
You can build the whole thing in a few minutes. Here is the order that keeps it simple.
- 1Open a new sheet. Start a blank file in Google Sheets and name it for your business and the year.
- 2Label your columns. Put the six columns across the top row: Date, Description, Category, Income, Expense, and Balance. Freeze that row so it stays visible as you scroll.
- 3Enter your opening balance. In the first Balance cell, type your starting bank balance so the running total has somewhere to begin.
- 4Add the running-balance formula. In the next Balance row, enter =F2+D3-E3, which takes the balance above, adds that row’s income, and subtracts its expense. Copy it down the column and every new row updates itself.
- 5Total each column. At the bottom, use =SUM(D2:D100) to total income and the same across the expense column, so you always see the period at a glance.
- 6Reconcile against your bank. Once a month, match the sheet to your bank statement. The IRS expects you to keep records of your income and expenses, and a monthly check keeps the two in step.
Make It Less Manual
Once the ledger works, a couple of add-ons cut the typing. A Google Form is the simplest: build a short form for transactions and each submission drops a new row into your sheet, which is handy for collecting receipts from a team.
When your volume grows, most accounting tools export to a spreadsheet or connect directly, so you can pull transactions in instead of keying them. That is usually the sign you are ready for real software, or for someone to run the books for you.
Where Spreadsheet Bookkeeping Goes Wrong
A spreadsheet is a great start, and also easy to break. Watch for these.
- ●Typos and manual entry. Hand-keyed data invites mistakes, and one wrong number quietly skews every report. Use data validation to limit what each column accepts.
- ●Broken formulas. A formula that points at the wrong cell gives you confident, wrong answers. Double-check that your balance formula references the row above before you trust it.
- ●Weak security. Sheets has no built-in encryption, so guard access carefully. Share with named people only, use a strong password, and turn on two-factor authentication for your Google account.
- ●Outgrowing the sheet. Once you are tracking hundreds of transactions, invoices, and categories, a spreadsheet starts to strain. A simple bookkeeping template buys you time, but plan to graduate to software or a bookkeeper.
Frequently Asked Questions
Below are the questions owners ask most about running their books in Google Sheets.
Keep Your Books Current as You Grow
A bookkeeping template in Google Sheets is a smart first step. Six columns, one running-balance formula, and a monthly reconciliation give you a clear record of where your money goes, without paying for software before you need it.
The honest truth is that a spreadsheet has a ceiling. As the transactions pile up and you would rather be running the business than reconciling rows, that is the moment to hand the books off. If you would rather skip the spreadsheet entirely, our online bookkeeping service keeps your records current and your reports on time each month.
Whichever way you go, the goal is the same: numbers you can trust, ready when you need to make a decision. Start simple, stay consistent, and upgrade when the sheet starts holding you back.
Clean books. On time. Every month.
