Bookkeeping Spreadsheet Google Sheets & Excel, Small Business Profit and Loss, 1099 Contractor Tracker, 2026 Schedule C, Estimated Tax

Seller's description

This bookkeeping spreadsheet is built for one-owner service businesses. One transaction list becomes a 12-month profit and loss and a 2026 Schedule C. It tracks 1099-NEC contractors and estimated tax payments. Monthly bank reconciliation shows whether your books match the bank. Invoices with aging are included. It works in Google Sheets and Excel.

WHAT'S INCLUDED
Bookkeeping + P&L workbook (Excel + Google Sheets), 14 tabs:
- Dashboard: income, profit, Schedule C line 31, overdue invoices, 1099s to file, next estimated tax payment and amount, statements off, and things to fix.
- Setup: business, tax year, terms, last year's tax, federal and state rates, W-2 wages, home office sq ft, and up to 5 accounts.
- Rates: 2025 and 2026 1099-NEC thresholds ($600 / $2,000), Social Security wage base, estimated tax due dates, 1099 due date and home-office rate. Add a row for a new year; nothing is typed into formulas.
- Categories (40): each points to a 2026 Schedule C line (including new 16b vehicle loan interest) or to Not on P&L. Meals are taken at 50%.
- Transactions (1,500 rows): date, account, payee, amounts in or out, category, client, invoice #, cleared date. The Check column flags dates outside the year, a missing category, money in and out on one row, an unknown invoice #, payees missing from Contractors, and large purchases to review.
- Invoices (300): due date, paid, open balance, days overdue and status.
- Clients (50): invoiced, received, open, overdue, share of income, with a warning when one client is 40% or more.
- Contractors (30): what counts for 1099-NEC (card and payment-app payments are left out), the corporation exemption with the attorney exception, W-9/TIN checks, a 24% backup-withholding warning, a near-threshold warning, the due date, and the Schedule C I/J answers.
- Reconcile: statement balance vs books by account and month, matching or off by how much.
- P&L: every category by month and for the year, with net income and margin.
- Schedule C: lines 1 to 31, 44a-c, Part V other expenses, the simplified home office on line 30, and a books-to-Schedule-C check that agrees with line 31.
- Estimated Tax: SE tax (92.35%, 12.4% up to the wage base after W-2 wages, 2.9%), the safe harbor (the lower of 90% of this year and 100% or 110% of last year), and each quarter's required, paid, still to pay and status, plus a state set-aside.
- Sources: 9 IRS and SSA links.
Start Here PDF with your Google copy link.

TESTED
18 automated tests check every calculated cell (13,569) against an independent model. They cover the 2026 and 2025 rules, 110% safe harbor with W-2 wages, a loss year, a year with no Rates row, a cleared file, and a full file of 1,500 transactions. Google Sheets matched the Excel version cell by cell (4,068 cells, 0 differences).

HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download the zip. Etsy also emails you a link.
2. Open Bookkeeping-PL-START-HERE.pdf. Click the link and choose "Make a copy" for Google, or open the .xlsx in Excel.
3. Look at the sample, clear it, fill in Setup and start adding transactions.

GOOD TO KNOW, PLEASE READ
- Not tax or legal advice. The estimate is a planning figure using one federal rate you enter. It has no QBI deduction, brackets, credits or other income. Rules come from IRS and SSA pages cited in the file (checked October 2026). Check with a tax professional.
- For U.S. sole proprietors and single-member LLCs filing Schedule C, on a cash basis. It isn't double-entry accounting and has no balance sheet, inventory, payroll, sales tax or bank sync (paste your bank CSV). Not for S corps or partnerships.
- It doesn't file 1099s or tax returns. No charts, and sheets aren't locked (formula cells are grey).
- Compatible with Google Sheets (free Google account) and Excel 2010 or newer, on Windows or Mac. Not designed for Apple Numbers.
- This is a digital download. Nothing physical will be shipped. Because it's a digital file, returns aren't accepted. If something isn't working, send me a message and I'll help.
- For your own business use. Please don't resell or share the files or links.

HOW THIS WAS MADE
I designed this workbook with help from AI tools, which assisted with the formulas, layout and text. I chose the features after comparing the bookkeeping and tax templates already available. I checked the rules against the IRS and SSA pages cited in the file, and tested every calculation against an independent check (18 tests) before listing.