Bookkeeping Template

About this download

NEW: Now includes a native Google Sheets version

• Bookkeeping that adds itself up, with no spreadsheet skills required.

This is a done-for-you bookkeeping spreadsheet: just type your numbers and every total calculates automatically. Income, expenses, profit by month, mileage, inventory value, and a live Dashboard with a chart, all updating as you go. No formulas to build, nothing to break, no accounting degree needed. Prefer paper? It's set up to print cleanly, so you can print blank pages and fill them in by hand.

𝗪𝗛𝗬 𝗬𝗢𝗨'𝗟𝗟 𝗟𝗢𝗩𝗘 𝗜𝗧

• TRULY AUTOMATIC TOTALS: type and it adds up, on computer or phone. No manual math.
• A LIVE DASHBOARD: income vs. expenses by month, net profit, profit margin, total miles + deduction estimate, and inventory value.
• PRINTABLE TOO: clean print setup with repeating headers and page numbers; print blank to fill by hand.
• MADE FOR MAKERS: sales channels, order tracking, materials with reorder flags, mileage, and a tax-prep category list built in.

WHAT'S INSIDE (9 tabs)

Start Here Dashboard (auto totals, KPIs & chart) Income log Expense log Order / sales tracker Inventory (auto value on hand) Materials (auto reorder flag) Mileage (auto miles + deduction estimate) Categories (editable list powering the expense dropdown).

𝗛𝗢𝗪 𝗜𝗧 𝗪𝗢𝗥𝗞𝗦

1. Buy & download: instant; you get one .xlsx workbook.
2. Upload to Google Drive and choose "Open with Google Sheets."
3. Just type your numbers: totals and the dashboard update live. Reuse every year.

PERFECT FOR: Etsy & handmade sellers, craft-fair and market vendors, and small side-hustle owners who want tidy, self-totaling books at tax time, without wrestling formulas.

FILE NOTE: DIGITAL DOWNLOAD, no physical item. One .xlsx workbook. Google Sheets: drive.google.com, New, File upload, Open with Google Sheets (totals carry over). All sales final due to instant download. Message me if anything's off. For general organization only; not tax, legal, or accounting advice.

𝗦𝗘𝗘 𝗔𝗟𝗦𝗢

• Track travel agent commissions too? Travel Agent Business Tracker: https://www.etsy.com/listing/4606588603

Designed by me, created using AI tools.

The Etsy listing is the final source for what is included. See it on Etsy.