Bookkeeping Spreadsheet System — Income, Expense & Profit Tracker with Quarterly Tax Planner

Imagine opening one spreadsheet and seeing your entire business already adding itself up.

Your income, your expenses, your profit by month, your quarterly tax set-aside — all connected, all calculating for you, all in one beautiful bookkeeping spreadsheet built for small business owners who sell online.

You already know the shoebox feeling: payouts scattered across platforms, receipts you meant to log back in April, and that quiet dread every time someone says the word "taxes." As you set up this system, something shifts — the moment you type a sale, it flows into your monthly profit, your dashboard, your quarterly tax estimate, everywhere it needs to go. You never do the math again.

That's because this isn't a stack of printable ledger pages. It's a fully automated Bookkeeping Spreadsheet System built by Gram and Me Printables, with real formulas working behind every tab.

What's inside your Bookkeeping Spreadsheet

• Easy Setup — Enter your business name, your selling platforms (Etsy, Shopify, anywhere), and your expense categories once. The whole system follows your rules, right down to the tax rate you choose from a simple dropdown.
• Income Tracker — Log each payout with a date, a platform dropdown, the gross amount, and the fees they kept. Your net income calculates live as you type, with room for 120 entries. Typo protection built in: if a fee is ever bigger than the sale, the cell turns red so you catch it instantly.
• Expense Tracker — One row per purchase with dropdown categories that keep everything sortable. 150 entries, 15 custom categories, zero guesswork.
• Automatic Profit & Loss Dashboard — This is where sellers fall in love. Revenue, fees, expenses, and profit calculate themselves month by month. Watch your spending sort itself by category, see your best and toughest months called out for you, and track running year-to-date profit without touching a single formula. Ever.
• Quarterly Tax Planner — Each quarter's profit totals itself, multiplies by your chosen set-aside rate, and shows your estimated payment due dates. Flip "Paid?" to Yes and the row turns a satisfying green. No more January panic.
• Start Here Tab — A warm, step-by-step getting-started guide, so even if spreadsheets aren't your thing, you'll be set up before your coffee cools.

Why online sellers choose this bookkeeping template

Because bookkeeping time is your creating time. When your profit and loss dashboard does the math, you get your evenings back. When quarterly taxes total themselves, tax season stops being a scramble. And when your accountant asks for your numbers, you'll pull up one clean, color-coded spreadsheet and feel completely prepared. Picture yourself next January — calm, coffee in hand, opening a finished year of books, because the system did the heavy lifting all along.

Perfect for

Etsy sellers and printables shops • digital product creators and course sellers • handmade and print-on-demand businesses • side hustlers and mompreneurs • freelancers and virtual assistants • anyone starting a small business who wants their money organized from day one.

How it works

• Buy once and get instant access — no waiting, no shipping.
• You'll receive a one-page PDF with a private link to copy the spreadsheet into your own Google Drive.
• Prefer Excel? From Google Sheets you can download your copy as an .xlsx file.
• Open the Start Here tab, enter your platforms and categories, and start tracking.

Details

• Instant digital access — delivered as a Google Sheet you copy to your own Drive (also works in Excel)
• A full year of sample data included so you can see exactly how everything works, then clear it and make it yours
• Cheerful purple, turquoise, and green design that makes bookkeeping feel like a treat
• Reusable year after year — just start a fresh copy each January

The tax planner is a savings estimate, not tax or financial advice. Please confirm your numbers with a tax professional.

This is a digital product. No physical item will be shipped. Due to the instant nature of digital downloads, all sales are final. Personal use only.

From our family to your business — Gram and Me Printables ♥