{"product_id":"bookkeeping-kit-en","title":"Complete Bookkeeping Kit","description":"\u003cp\u003eOne 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.\u003c\/p\u003e\n\u003ch3\u003eFeatures\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eIncludes everything in the Income, Expense \u0026amp; Monthly P\u0026amp;L Workbook, the Business Mileage Log, and the Invoice \u0026amp; Payment Tracker, plus a Payout Reconciliation tab, combined in a single workbook.\u003c\/li\u003e\n\u003cli\u003eIncome 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.\u003c\/li\u003e\n\u003cli\u003eThe Monthly P\u0026amp;L tab shows 12 months plus a year total, including net profit and profit margin, all calculated by formula.\u003c\/li\u003e\n\u003cli\u003eThe 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.\u003c\/li\u003e\n\u003cli\u003ePayout 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.\u003c\/li\u003e\n\u003cli\u003eA 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.\u003c\/li\u003e\n\u003cli\u003eMade 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.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eWhat's in the download\u003c\/h3\u003e\n\u003cp\u003eOne .zip file, bookkeeping-kit-en-v1.0.zip, containing:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ebookkeeping-kit-en-v1.0.xlsx (blank workbook)\u003c\/li\u003e\n\u003cli\u003ebookkeeping-kit-en-v1.0-EXAMPLE.xlsx (the same workbook filled with fictional sample data for a made-up business, \"Sample Studio\")\u003c\/li\u003e\n\u003cli\u003eQuick-Start-EN.pdf (1 page: how to open the file in Excel, how to open it in Google Sheets, and the first 3 steps)\u003c\/li\u003e\n\u003cli\u003eLICENSE.txt\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eWorkbook tabs: Start Here, Setup, Income, Expenses, Monthly P\u0026amp;L, Annual Summary, Payout Reconciliation, Mileage Log, Invoice Tracker.\u003c\/p\u003e\n\u003cp\u003eThis is the English edition. Also available in Spanish as a separate product at the same price: \u003ca href=\"\/products\/kit-contabilidad-es\"\u003eKit Completo de Contabilidad\u003c\/a\u003e. The Bilingual Bookkeeping Kit (English and Spanish) includes both. Amounts are in US dollars and dates use the MM\/DD\/YYYY format.\u003c\/p\u003e\n\u003cp\u003eOrganizational template only. Not tax, legal, or accounting advice. Consult a qualified tax professional.\u003c\/p\u003e\n\u003cp\u003eLicense: Single business, personal use. Do not resell, share, or redistribute the files.\u003c\/p\u003e\n\u003cp\u003eThis is a digital download; nothing is shipped. Please read our refund policy before you buy.\u003c\/p\u003e\n\u003cp\u003eCreated with Grok\u003c\/p\u003e","brand":"Dooner Designs","offers":[{"title":"Default Title","offer_id":51818107273462,"sku":null,"price":22.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0821\/6775\/9094\/files\/bookkeeping-kit-en-01-hero.png?v=1791583844","url":"https:\/\/doonerdesigns.myshopify.com\/products\/bookkeeping-kit-en","provider":"Dooner Designs","version":"1.0","type":"link"}