To set up a bookkeeping template in Google Sheets, make four tabs: Transactions, Categories, Monthly summary, and a month-end checklist. Enter each payment on the Transactions tab with a type and category, let a formula total each category by month, and compare your ending balance to your bank statement.
What is a bookkeeping template in Google Sheets?
A bookkeeping template in Google Sheets is a spreadsheet that records your business income and expenses, sorts each transaction into a category, and totals the results by month. Because it lives in Google Sheets, you open it in a web browser on any device, and you can share it with an accountant by sending a link instead of emailing a file.
What tabs does a small business bookkeeping sheet need?
You need four tabs. Everything else is optional.
- Transactions. One row for every payment you receive or make, with the date, a short description, the amount, the type, the category, and the account.
- Categories. A short list of the categories you use, so every transaction gets the same name every time. If you are a US sole proprietor, start with the Schedule C expense categories so your totals line up with your tax return.
- Monthly summary. Totals by category for each month, plus income, expenses, and profit.
- Month-end checklist. A short list of steps you repeat every month, such as matching your totals to your bank statement. See the monthly close-out workflow for an example.
How do you set up a bookkeeping spreadsheet in Google Sheets?
- Create a new Google Sheet and name the first tab "Transactions." In row 1, type these headings: Date, Description, Amount, Type, Category, Account, Notes.
- Add a second tab named "Categories." List your categories in column A, one per row.
- Add dropdowns so you pick instead of type. Select the Category column, add a dropdown (the menu is under Insert or Data, depending on your version of Sheets), and point it at the list on your Categories tab. Add a second dropdown to the Type column with three choices: Income, Expense, and Transfer.
- Enter your transactions. The fastest way is to download a CSV file of your bank or card activity, open it with File, then Import, and copy the rows into the Transactions tab. Then fill in Type and Category for each row.
- Add a tab named "Monthly summary." Put the first day of each month across row 1 (for example, 1/1/2026 in B1, 2/1/2026 in C1), and put your categories down column A. In B2, use a formula like the one below, then copy it across and down.
=SUMIFS(Transactions!$C:$C, Transactions!$E:$E, $A2, Transactions!$A:$A, ">="&B$1, Transactions!$A:$A, "<"&EDATE(B$1,1))- Add two rows at the bottom: total income and total expenses. Profit is income minus expenses.
- At the end of each month, compare your ending balance in the sheet to the ending balance on your bank statement. If the two numbers match, the month is done.
The formula adds up the Amount column (C) for rows where the Category column (E) matches the category in column A and the date falls inside that month. If your columns are in a different order, change the letters to match. For the total income and total expense rows, use the same formula but match the Type column (D) to the word "Income" or "Expense" instead of matching a category.
What mistakes should you avoid?
- Counting transfers as income or expenses. Moving money between your own accounts is not income and not an expense. Give it the Transfer type so it stays out of your profit.
- Mixing personal and business spending. It makes every month harder to sort. Read how to separate business and personal expenses if you already have a mix.
- Leaving the category blank. A blank category means that transaction is missing from your summary. Use a category named "Needs review" for anything you are unsure about, and clear it out at month-end.
- Throwing away records. Keep a receipt, invoice, or statement for each expense you plan to deduct. See which receipts to keep.
Should you build your own sheet or use a ready-made template?
Building your own is free and teaches you how your numbers work, but it takes an afternoon to set up and test. A ready-made bookkeeping template saves that setup time and usually comes with categories and a dashboard already built. Either way, a spreadsheet is a good fit for a sole proprietor with a modest number of transactions. If you need invoicing, payroll, or automatic bank feeds, compare it with accounting software first. The spreadsheet versus QuickBooks guide walks through that decision.
Want the setup done for you? The Bookkeeping Rescue Kit is a bookkeeping spreadsheet for small business owners with five connected tabs, Schedule C categories, and a monthly close-out checklist. It comes in Excel and Google Sheets. $9.99, one-time purchase. No subscription.
Get the Kit →Frequently asked questions
Yes, for a sole proprietor or small business with a modest number of transactions. Google Sheets tracks income and expenses, sorts them into categories, and totals profit by month. It is not double-entry accounting software, and it does not import bank transactions automatically, so you add them by hand or by pasting a CSV file.
You can, if you only need to record income and expenses and see your monthly profit. If you need invoicing, payroll, automatic bank feeds, or reports built for a lender, accounting software is a better fit.
Yes. Use the Share button and add your accountant's email address, or send a link. You choose whether they can view, comment, or edit.
Download a CSV file of your account activity from your bank or card issuer. In Google Sheets, choose File, then Import, and upload the file. Then copy the rows into your Transactions tab and add a type and category to each one.
Weekly works well for most small businesses, and monthly is the minimum. Updating more often means fewer transactions to sort at once and fewer receipts to hunt down.