Complete Bookkeeping Kit

One spreadsheet workbook for a small business's day-to-day books: income, expenses, monthly profit, payout reconciliation, mileage, and invoices, all in one place. Totals calculate from what you enter, and a one-page Annual Summary is ready to print for your tax preparer.

Features

• Includes everything in the Income, Expense & Monthly P&L Workbook, the Business Mileage Log, and the Invoice & Payment Tracker, plus a Payout Reconciliation tab, combined in a single workbook.
• Income and expense logs with room for 1,000 entries each. Choose categories and payment methods from lists you set up yourself, and the net amount on each income entry calculates for you.
• The Monthly P&L tab shows 12 months plus a year total, including net profit and profit margin, all calculated by formula.
• The Annual Summary tab brings together year totals by category, your top 5 expense categories, net profit, total business miles, the number of open invoices, and the open and overdue balances on one printable Letter-size page.
• Payout Reconciliation: paste rows from your Shopify Payments or Etsy payouts (date, gross, fees, refunds, net deposit). The sheet compares them with the income you logged for each month and flags differences over $1.00.
• A mileage log with room for 500 trips and a per-mile rate cell that you fill in yourself, plus an invoice tracker with room for 300 invoices and status (Paid, Partial, Open, Overdue) set by formula.
• Made to open in Excel 2016 or later (Windows and Mac), Excel for the web, and Google Sheets (upload the file to Google Drive and open it with Sheets). No macros or scripts. Formula cells are locked with no password, so you can turn off the protection if you want to customize.

What's in the download

One .zip file, bookkeeping-kit-en-v1.0.zip, containing:

• bookkeeping-kit-en-v1.0.xlsx (blank workbook)
• bookkeeping-kit-en-v1.0-EXAMPLE.xlsx (the same workbook filled with fictional sample data for a made-up business, "Sample Studio")
• Quick-Start-EN.pdf (1 page: how to open the file in Excel, how to open it in Google Sheets, and the first 3 steps)
• LICENSE.txt

Workbook tabs: Start Here, Setup, Income, Expenses, Monthly P&L, Annual Summary, Payout Reconciliation, Mileage Log, Invoice Tracker.

This is the English edition. Also available in Spanish as a separate product at the same price: Kit Completo de Contabilidad. The Bilingual Bookkeeping Kit (English and Spanish) includes both. Amounts are in US dollars and dates use the MM/DD/YYYY format.

Organizational template only. Not tax, legal, or accounting advice. Consult a qualified tax professional.

License: Single business, personal use. Do not resell, share, or redistribute the files.

This is a digital download; nothing is shipped. Please read our refund policy before you buy.

Created with Grok