How to Set Up Bookkeeping in Google Sheets for a Small Business

If you're a sole proprietor, single-member LLC, freelancer, or small business owner on cash-basis accounting, you don't need QuickBooks. You need a spreadsheet that doesn't lie to you and a way to get your bank data into it without manual entry.

This is that setup.

Who This Is For

This works well if you:

• File on cash-basis (record income when received, expenses when paid)
• Have one or two business bank accounts or credit cards
• Don't have employees on payroll (or use a separate payroll service)
• Want something your accountant can open without installing anything

If you're tracking receivables, running payroll inside your accounting system, or on accrual accounting, you'll want dedicated software. More on that at the end.

Why Sheets Instead of QuickBooks

QuickBooks has a Free plan, but it covers one bank connection; the paid plans start at $38/month and climb fast, up to $340. It locks your data in a proprietary format, the UI changes without warning, and the feature set is aimed at businesses far more complex than most small operations actually are.

Google Sheets is free, you own the file, and your accountant already knows how to use it. The only real gap has been getting transaction data in, which is what SheetLink solves. Connect your business bank account, sync transactions to a Sheet, and you have a bookkeeping foundation that costs nothing and goes wherever you do.

The Core Setup: Four Sheets

You need four tabs:

1. Transactions: raw data from SheetLink (don't edit this tab)
2. Chart of Accounts: your income and expense categories
3. P&L: monthly summary built with SUMIFS
4. Notes: year-end memos, one-off adjustments, context for your accountant

Start with this structure. You can add complexity later; you can't easily subtract it.

Step 1: Connect Your Business Bank Account

Install SheetLink, connect your business checking account (and business credit card if you have one), and link a Google Sheet. Run a sync. You'll have a Transactions sheet with all Plaid transaction fields, including date, description_raw, merchant_name, amount, category_primary, and more.

Add one column to your Transactions sheet: Line Item. This is the only column you'll fill in manually. It maps each transaction to a category in your chart of accounts.

Step 2: Build Your Chart of Accounts

Keep it simple. More categories means more work every month with diminishing returns for most small businesses.

Income

• Client Revenue / Services
• Product Sales
• Other Income

Cost of Goods Sold (skip if you're a pure service business)

• Contractor Payments
• Direct Materials

Operating Expenses

• Advertising & Marketing
• Software & Subscriptions
• Travel & Transportation
• Meals & Entertainment
• Office & Supplies
• Professional Services (lawyers, accountants, consultants)
• Bank & Payment Fees
• Other Expenses

Put these in your Chart of Accounts tab with a column for the label and a column for the type (Income / COGS / Expense). Your P&L will reference this list.

Step 3: Build the P&L

In your P&L tab, put months across the top (columns B through M for Jan–Dec) and line items down the left. Use SUMIFS with MATCH to find the right columns by header name:

=SUMIFS(
  INDEX(Transactions!$A:$AJ, 0, MATCH("amount", Transactions!$1:$1, 0)),
  INDEX(Transactions!$A:$AJ, 0, MATCH("Line Item", Transactions!$1:$1, 0)), $A5,
  INDEX(Transactions!$A:$AJ, 0, MATCH("date", Transactions!$1:$1, 0)), TEXT(B$2, "yyyy-mm") & "*"
)

Where $A5 is the line item label and B$2 is the first day of the month. SheetLink writes dates as text (YYYY-MM-DD), so the formula matches the month as text (TEXT(B$2, "yyyy-mm") & "*") rather than comparing dates. Amounts follow Plaid's sign convention: positive is money out, negative is money in. So for your Income line items, put a minus sign in front of the formula (=-SUMIFS(...)) so revenue shows as a positive number. Add total rows for Revenue, COGS, Gross Profit, Total Expenses, and Net Profit.

For a more detailed walkthrough of the P&L formula setup, see How to Build a P&L in Google Sheets Using Live Bank Transactions.

The Monthly Close Routine (10 Minutes)

Once the structure is built, keeping it current takes almost no time:

1. Open SheetLink → Sync Now (10–30 seconds)
2. Scroll through new transactions in the Transactions tab and fill in any missing Line Item values (most recurring merchants will be recognizable)
3. Spot-check your P&L totals look reasonable
4. Done

That's the whole routine. No reconciliation wizard, no bank feeds to approve, no subscription to log into.

What to Send Your Accountant at Year End

At year end, share the Google Sheet (view access is fine) and call out:

• The P&L tab: annual totals by line item
• The Notes tab: any one-off items that need context (equipment purchases, owner draws, unusual expenses)
• Any transactions you left uncategorized that you weren't sure about

Most accountants are comfortable with Sheets. If yours prefers a CSV or Excel file, use File → Download. No special exports, no software handoffs.

When to Upgrade to Real Accounting Software

This setup works well until it doesn't. Move to QuickBooks, Xero, or similar when you genuinely need:

• Accounts receivable: you invoice clients and need to track what's been paid vs. outstanding
• Accounts payable: you have vendor bills to track and pay on terms
• Payroll: you're running payroll through your accounting system (not a separate service like Gusto)
• Accrual accounting: your CPA requires it, or your business has grown to a scale where cash-basis no longer reflects reality
• Multi-entity or multi-currency: things have gotten complicated

For the majority of small businesses and independents, that day is further off than the accounting software industry would like you to believe.

Questions