Small Business Bookkeeping in Google Sheets: A Guide

Bookkeeping in Google Sheets comes down to four tabs: a Transactions ledger with one row per sale or cost, a Categories list that feeds dropdowns, a Stock tab if you sell products, and a monthly profit and loss built with SUMIFS. For a sole trader or a small shop, that's a complete set of books with no software subscription. This guide builds each tab and explains when to stop using a spreadsheet.

This guide is general information, not tax or accounting advice. Check what records you need to keep with an accountant or your tax authority, such as the IRS guide to small business recordkeeping.

Who spreadsheet bookkeeping is for

A spreadsheet is a good fit when the business is simple enough that you can see all of it at once:

• Sole traders and freelancers who invoice a handful of clients.
• Small shops, market stalls and makers with one till and a few dozen products.
• Side businesses that need clean records for a tax return, not a finance department.
• New businesses that aren't ready to pick accounting software yet and want to learn where the money goes first.

It's a poor fit if you already run payroll, sell on credit to many customers, or have an accountant who works only in one software package. The last section covers those signs in detail.

How do you do bookkeeping in Google Sheets?

Set up one spreadsheet per business per year with these tabs:

1. Transactions: every sale and every cost, one row each.
2. Categories: your income and expense categories, used for dropdowns.
3. Stock (optional): stock movements and quantities on hand.
4. P&L: a monthly profit and loss that totals itself from the Transactions tab.

Then follow one rule: record each transaction on the day it happens. Everything else in this guide is structure that makes that rule easy to keep.

The Transactions tab

This is your ledger. Every number in the P&L comes from here, so keep its columns fixed:

Two habits keep this tab reliable. Enter amounts as positive numbers and let the Type column decide whether they add or subtract, so a stray minus sign can't flip your profit. And never leave a row without a category: an "Uncategorized" pile is where bookkeeping quietly falls apart.

The Categories tab

List income categories in column A and expense categories in column B. Then select Transactions!C2:C and use Insert → Dropdown → Dropdown (from a range) pointing at the Categories columns. Our guide to tracking expenses in Google Sheets walks through dropdowns and data validation step by step.

Record income and expenses

Most small businesses need fewer categories than they think. A practical starting list:

In the US, a sole proprietor's accountant will map these to Schedule C lines, so ask them whether they want any split differently (Schedule C on IRS.gov). Freelancers with client-billable costs can borrow the extra columns from our freelancer expense tracking system.

A few rules that save arguments at year end:

• Record card-processor payouts gross, not net. If a payment provider deposits 970 after a 30 fee on 1,000 of sales, log 1,000 as Sales income and 30 as Bank and payment fees.
• Log owner money separately. Money you put in or take out for yourself isn't income or an expense. Add "Owner contribution" and "Owner drawings" as their own Types so they stay out of the P&L.
• Keep sales tax or VAT you collect visible. If you charge it, add a Tax column so you know how much of each sale isn't really yours.

The hard part is never the columns. It's entering rows while you still remember what they were. On a laptop, type into the sheet. On a phone, use whatever gets a row in fastest. Voice Sheet builds a form from your sheet's columns for free, and with Premium you can say "50 shipping boxes 40 dollars, stock purchases, business card" and get the row filled in. It doesn't scan receipts or pull in bank transactions, so receipts go into a Drive folder and every row is one you entered. For fixed costs like rent, recurring reminders prompt you with a pre-filled entry each month.

Track stock in the same file

If you sell physical products, add a Stock tab with these columns: Date, Item, Movement (Stock In or Stock Out), Qty and Unit cost.

Log a row when a delivery arrives and when items sell or are written off. On a separate Items tab, list each product in column A and calculate what's on hand in column B:

=SUMIFS(Stock!D:D, Stock!B:B, A2, Stock!C:C, "Stock In")
 - SUMIFS(Stock!D:D, Stock!B:B, A2, Stock!C:C, "Stock Out")

Multiply on-hand quantity by unit cost for a rough stock value. Count physically at least once a year and add an adjustment row for any difference.

Keep money and quantities apart. The cash you pay for stock goes into Transactions as an expense. The boxes themselves go into Stock as a movement. Your accountant may need to adjust for unsold stock at year end, which is easy when the stock count is sitting in its own tab. Voice Sheet's free Inventory template (Items, Stock Movements and a Summary tab) is one of the Google Sheets templates you can start from.

Build a monthly P&L formula

The P&L tab turns the ledger into the number you actually care about: did the business make money this month?

1. In P&L!A3 downwards, list every income category, then a Total income row, then every expense category, then Total expenses and Net profit.
2. In B1, enter the first day of your first month, for example 1/1/2026. In C1, enter =EDATE(B1, 1) and drag it right to M1 for twelve months.
3. In B3 (the first category under the first month), enter:

=SUMIFS(Transactions!$E:$E,
  Transactions!$C:$C, $A3,
  Transactions!$A:$A, ">="&B$1,
  Transactions!$A:$A, "<"&EDATE(B$1, 1))

4. Copy that formula across all months and down all category rows. The $ signs keep the columns and header row fixed while the category and month change.
5. Use =SUM() for Total income and Total expenses, then subtract Total expenses from Total income for Net profit (for example =B8-B20, using your own row numbers).

Format the month headers as "Jan 2026" (Format → Number → Custom date and time) and add a Year column in N with =SUM(B3:M3) for annual totals. If the SUMIFS date logic is new to you, our SUMIFS by month guide explains each argument with examples.

This gives you a cash-basis P&L: income counts when it's received and costs when they're paid. That's how most sole traders and very small businesses report, but check with your accountant if you invoice on credit or hold a lot of stock.

A 20-minute month-end routine

On the first working day of the month:

1. Compare against bank and card statements. Add any business transaction missing from the sheet. Tick each statement line as you match it.
2. Chase missing receipts. Filter the Receipt column for blanks.
3. Read the P&L. Look for a category that jumped, a subscription that crept up or a month that lost money.
4. Update stock. Spot-count your fastest-selling items and add adjustment rows.
5. Share, don't send. Give your bookkeeper or accountant Viewer or Commenter access to the file and the receipts folder, so they always see current records.

At year end, make a copy of the file for the new year, clear the Transactions and Stock rows, and keep the old file. The IRS explains how long to keep records; other countries set their own rules.

When to move to accounting software

Bookkeeping in Google Sheets stops being enough when the business needs things a ledger can't do on its own. Common signs:

None of these mean the spreadsheet was a mistake. A year of clean, categorized rows makes the switch easy: most accounting packages import a CSV, and you'll already know your categories. Many owners keep a sheet afterwards for the things accounting software does badly, like stock counts, job notes and a quick daily cash log.

Start with one tab

You don't need all four tabs on day one. Start with Transactions, log every sale and cost for a month, then add the P&L when you want to see the total. If you'd rather start from columns that already work, the free Google Sheets expense tracker template is a good base. Add the Type and Payment method columns from this guide.

If you'd like to keep your business bank account out of yet another app, this whole system works without bank linking. For how Voice Sheet fits a shop or trade, see our small business expense tracker page.