{"product_id":"small-business-bookkeeping-spreadsheet-small-business-expense-tracker","title":"Small Business Bookkeeping Spreadsheet, Small Business Expense Tracker, Income and Expense Tracker Excel, Google Sheets Bookkeeping Template","description":"\u003cp\u003eSmall Business Bookkeeping Spreadsheet and expense tracker for Excel and Google Sheets - track income and expenses, see your profit, and get an automatic quarterly estimated tax figure for all four IRS periods. 9 tabs, 1,200+ built-in formulas, instant download.\u003c\/p\u003e\u003cp\u003eStop guessing what you owe.\u003c\/p\u003e\u003cp\u003eMost small business owners find out what they owe in April, and by then it is too late to do anything about it. This bookkeeping spreadsheet flips that around. You log income as it arrives and expenses as you spend, and the workbook does the rest:\u003c\/p\u003e\u003cp\u003eprofit, margin, category totals, mileage deduction, and a running quarterly tax estimate that updates every time you add a row.\u003c\/p\u003e\u003cp\u003eNine tabs. Nothing to set up beyond your own tax rates. No subscription.\u003c\/p\u003e\u003cul\u003e\u003cli\u003e* * WHAT\u0026amp;#39;S INSIDE THE SPREADSHEET * * *\u003c\/li\u003e\u003c\/ul\u003e\u003cp\u003eDASHBOARD\u003c\/p\u003e\u003cp\u003eYour whole business on one screen. Total income, deductible expenses, net profit, profit margin, estimated tax, what you have already paid, what is still to set aside, profit after tax, and how much clients still owe you. Two live charts.\u003c\/p\u003e\u003cp\u003eNothing on this tab is typed - it all calculates.\u003c\/p\u003e\u003cp\u003eSETUP\u003c\/p\u003e\u003cp\u003eBusiness name, tax year, and your own tax rates. Also holds the income and expense category lists that feed every dropdown in the workbook. Rename or add categories to match your business in seconds.\u003c\/p\u003e\u003cp\u003eINCOME LOG - 500 ROWS\u003c\/p\u003e\u003cp\u003eDate, invoice number, client, description, category, payment method, amount, and a paid \/ unpaid flag. Unpaid invoices turn red and roll straight up to the Dashboard, so nothing you are owed gets forgotten.\u003c\/p\u003e\u003cp\u003eEXPENSE LOG - 500 ROWS\u003c\/p\u003e\u003cp\u003eEvery business cost, with a Deductible % column. Claim 60% of a phone bill, 50% of a business meal, 25% of home electricity. Type the percentage and the spreadsheet works out the deductible amount for you. Receipt tracking built in.\u003c\/p\u003e\u003cp\u003eMONTHLY SUMMARY\u003c\/p\u003e\u003cp\u003eTwelve months of income, expenses, net profit, profit margin, running profit and tax set-aside, with a live income versus expenses chart.\u003c\/p\u003e\u003cp\u003eCATEGORY BREAKDOWN\u003c\/p\u003e\u003cp\u003eAll 24 expense categories ranked by spend, each one mapped to its US Schedule C line, with monthly averages. This is the tab where you find the subscription quietly costing you $600 a year.\u003c\/p\u003e\u003cp\u003eQUARTERLY TAX ESTIMATOR\u003c\/p\u003e\u003cp\u003eThe four real IRS estimated tax periods with their due dates. Self-employment tax, federal income tax, state tax and a safety buffer, worked out per quarter. Enter what you actually pay and the balance turns green.\u003c\/p\u003e\u003cp\u003eMILEAGE LOG - 200 ROWS\u003c\/p\u003e\u003cp\u003eDate, purpose, from, to and miles, at whatever mileage rate you set.\u003c\/p\u003e\u003cp\u003eSTART HERE\u003c\/p\u003e\u003cp\u003eThe setup instructions, kept inside the workbook so you never lose them.\u003c\/p\u003e\u003cul\u003e\u003cli\u003e* * WHY THIS ONE AND NOT A FREE TEMPLATE * * *\u003c\/li\u003e\u003c\/ul\u003e\u003cp\u003eIRS estimated tax quarters are NOT equal calendar quarters. Q2 covers two months and Q4 covers four. Most bookkeeping templates split the year into four even chunks and quietly get your estimate wrong. This one uses the real periods and the real deadlines.\u003c\/p\u003e\u003cp\u003ePartial deductions are built in, not bolted on. If a cost is only 40% business, you should only claim 40% - and you should not have to reach for a calculator to do it.\u003c\/p\u003e\u003cp\u003eEvery expense category is mapped to a Schedule C line, so filing season turns into a copy job instead of an archaeology project.\u003c\/p\u003e\u003cp\u003eSample data is included so you can see a filled-in workbook working before you clear it and start your own. No guessing what goes where.\u003c\/p\u003e\u003cul\u003e\u003cli\u003e* * WHAT YOU GET - INSTANT DIGITAL DOWNLOAD * * *\u003c\/li\u003e\u003c\/ul\u003e\u003cp\u003e1. Small Business Bookkeeping Spreadsheet (.xlsx) - 9 tabs, 1,200+ formulas\u003c\/p\u003e\u003cp\u003e2. Printable Bookkeeping Pack - US Letter (.pdf) - 10 undated pages\u003c\/p\u003e\u003cp\u003e3. Printable Bookkeeping Pack - A4 (.pdf) - the same 10 pages, A4 sized\u003c\/p\u003e\u003cp\u003e4. START HERE setup guide (.pdf) - 2 pages, up and running in five minutes\u003c\/p\u003e\u003cp\u003eThe printable pack includes a monthly income log, monthly expense log, business mileage log, quarterly tax worksheet, monthly summary sheet, year at a glance, receipt and deduction checklist, client and invoice tracker, and an expense category reference. Undated, so print them as many times as you like, every year.\u003c\/p\u003e\u003cp\u003eFiles are available the moment your payment clears. Nothing ships.\u003c\/p\u003e\u003cul\u003e\u003cli\u003e* * WORKS WITH * * *\u003c\/li\u003e\u003c\/ul\u003e\u003cp\u003eMicrosoft Excel (Windows and Mac)\u003c\/p\u003e\u003cp\u003eGoogle Sheets (free, works in any browser)\u003c\/p\u003e\u003cp\u003eApple Numbers (Mac and iPad)\u003c\/p\u003e\u003cp\u003eLibreOffice Calc (free, any computer)\u003c\/p\u003e\u003cp\u003eUsing Google Sheets? File \u0026amp;gt; Import \u0026amp;gt; Upload, then choose \u0026amp;quot;Replace spreadsheet\u0026amp;quot;.\u003c\/p\u003e\u003cp\u003eFormulas, dropdowns and charts all carry across.\u003c\/p\u003e\u003cp\u003eNo subscription. No account to create. No add-ons to install. Bookkeeping software costs $20 to $70 every single month - this is a one-time download you own outright.\u003c\/p\u003e\u003cp\u003eSave a fresh copy,  clear the rows, change the tax year, and reuse it\u003c\/p\u003e\u003cp\u003efor as many years as you like.\u003c\/p\u003e\u003cul\u003e\u003cli\u003e* * WHO IT\u0026amp;#39;S FOR * * *\u003c\/li\u003e\u003c\/ul\u003e\u003cp\u003eFreelancers and consultants\u003c\/p\u003e\u003cp\u003eEtsy, Shopify and Amazon sellers\u003c\/p\u003e\u003cp\u003eCoaches, therapists and service providers\u003c\/p\u003e\u003cp\u003ePhotographers, designers and creatives\u003c\/p\u003e\u003cp\u003eTrades, contractors and mobile businesses\u003c\/p\u003e\u003cp\u003eAnyone self-employed filing a Schedule C\u003c\/p\u003e\u003cp\u003eIf you are running a business from a shoebox of receipts and a bank app, this is the\u003c\/p\u003e","brand":"ClearToolsCo","offers":[{"title":"Default Title","offer_id":67640781668630,"sku":"ETSY-4556286493","price":11.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1014\/1407\/6694\/files\/il_fullxfull.8570040523_g9fc.jpg?v=1791034978","url":"https:\/\/cleartoolsco.myshopify.com\/products\/small-business-bookkeeping-spreadsheet-small-business-expense-tracker","provider":"CleartoolsCo","version":"1.0","type":"link"}