Small Business Bookkeeping Spreadsheet, Income and Expense Tracker for Google Sheets & Excel, Profit and Tax Set Aside Tracker

Know your profit without the headache. This Small Business Bookkeeping spreadsheet keeps your money in and money out in one simple file and answers the questions that matter, big and clear: How much did I make? How much did I spend? What's my profit? How much should I set aside for tax? Log each sale and each cost, and everything else adds up by itself. It works in Google Sheets and Microsoft Excel, and it's an instant digital download.

A note on how it's made: this spreadsheet was designed with the help of AI tools, then built, formatted and tested by hand. The math was checked against an independent calculation in 34 real-life scenarios. These included a full year of 500 sales and 1,000 costs, shop fees, refunds, missing receipts, renamed categories, lines from another year, a loss year, a tax % typed as 25 or 25%, text typed where a number goes, and a cleared copy.

✿ MADE FOR SMALL BUSINESS OWNERS, NOT ACCOUNTANTS
• Just 4 tabs, and you only type in the blush-colored cells
• Plain English: "Money in", "Money out", "To set aside", "What to do next"
• Every line checks itself and says "Counted" or tells you, in plain words, what to fix
• New to bookkeeping? The first tab has five short tips and a Common Questions box
• Formulas are locked in Excel so nothing breaks by accident (in Google Sheets, just type in the blush cells)

✿ WHAT'S INSIDE: 4 SIMPLE TABS

1. START HERE: 3 easy steps, a "How to Keep Your Books Simple" box and a Common Questions box. Add your business name, the year and your tax %. Your profit, tax set-aside and a "What to do next" line show right here.

2. DASHBOARD: Money in, money out, profit and tax to set aside, for the year and this month. A month-by-month table and chart. A Tax to Set Aside table for each quarter with the US pay-by dates, and the next date marked for you. Money in and money out by category, with each one's share of the total. It prints on one page.

3. MY INCOME: Room for 500 sales or payments a year. Type the date, who paid, the category, the amount and any shop or card fees. Net fills in by itself. 5 ready income categories you can edit or add to.

4. MY EXPENSES: Room for 1,000 costs a year. Type the date, who you paid, the category and the amount, and mark Yes or No for the receipt. 16 ready expense categories you can edit or add to.

✿ SMART LITTLE TOUCHES
• Fees come off your sales for you, so you don't log them twice
• Refunds? Just type a minus, like -25
• A built-in receipt tracker. The Dashboard tells you how many receipts are still missing
• The "What to do next" line tells you the next tax date, about how much to have set aside, and anything to fix
• Lines dated in another year are flagged and left out, so your totals stay right
• Undated: pick any year, so it works for 2026, 2027 and beyond
• Works great with our Zero-Based Budget Planner and Savings Tracker

✿ WHAT YOU RECEIVE
• Neatly_Planned_Bookkeeping_BLANK.xlsx: ready for your business
• Neatly_Planned_Bookkeeping_SAMPLE.xlsx: a filled-in example to explore
• How_To_Use_Bookkeeping.pdf: a 2-page setup guide

✿ WORKS WITH
• Google Sheets (free) and Microsoft Excel for Windows and Mac (Excel 2016 or newer, or Microsoft 365)
• Log a sale or a cost on your phone in the free Google Sheets or Excel app
• No macros, add-ins or subscriptions

✿ HOW TO USE IT
Google Sheets: open Google Drive, click New › File upload and choose the BLANK file. Open it, then click File › Save as Google Sheets.
Excel: double-click the file. If you see "Enable Editing," click it.
Then follow the 3 steps on the Start Here tab.

✿ GOOD TO KNOW
• This is an INSTANT DIGITAL DOWNLOAD. No physical item will be shipped.
• Your files are available right after purchase from your Etsy Purchases page (You › Purchases and reviews).
• The tax set-aside is a simple guide using your own tax %, with US quarterly dates. It is not tax or accounting advice. A tax professional can give you exact amounts.
• The business and numbers in the SAMPLE file are made up for illustration.
• Each file holds one year. For a new year, save a fresh copy.
• For use in your own business. Please don't share, resell or redistribute the file.

✿ RETURNS & REFUNDS
Because this is a digital file you get instantly, we can't accept returns, exchanges or cancellations. If anything isn't working, please message us through Etsy and we'll make it right.

Designed with the help of AI tools, and built and tested by hand by Neatly Planned Sheets.