Quarterly Tax Spreadsheet 1099 Self Employed, Estimated Tax Calculator, Set Aside Payment Tracker, Excel Google Sheets Template

Quarterly tax spreadsheet 1099 and self-employed filers can trust, in XLSX format, built on the real IRS periods rather than four even quarters.

The periods are uneven and always have been: Jan 1 to Mar 31, Apr 1 to May 31, Jun 1 to Aug 31, Sep 1 to Dec 31. Split the year into four even quarters, as most templates quietly do, and you underpay in June and overpay in January — and the penalty is charged per period, so a big January payment does not undo a short June one. Every window here is the real one.

You type in one tab and everything else fills itself in: one row per payment in, one row per expense out.

WHAT’S INSIDE — 4 TABS

1. ✓ Money In and Out — 400 rows with dropdowns for income or expense and eleven categories. The only tab you touch day to day.
2. ✓ Quarterly Estimate — the four real periods side by side: income, expenses, net profit, self-employment tax, income tax, what to send, the due date, what you paid, the balance owing.
3. ✓ Payments — every payment and its confirmation number, matched back to the period it covers.
4. ✓ Read Me First — profit so far, the year’s estimated tax, and what share of every dollar to set aside.

KEY FEATURES ✓ The set-aside number, from your own figures, so you move the money the day a payment lands. ✓ A loss period sends nothing — a zero, never a negative. ✓ No tax rate is printed in the file. The self-employment rate, the net earnings factor, your federal estimate and your state rate are four cells you set, with a pointer to irs.gov. ✓ Locked formulas. Grey cells are protected, yellow cells are yours, no password is set. ✓ 5-page quickstart PDF with the period table and due dates.

PERFECT FOR freelancers, 1099 contractors, sole proprietors and side-business owners paying estimated tax.

PLEASE NOTE. Digital download; nothing ships. An estimating tool, not tax advice — it knows nothing of a spouse’s withholding, your deductions or the safe-harbour rules.

The listing images use demonstration names and numbers. The download is the reusable template, with entry rows ready for your own work.

WORKS WITH XLSX format. Excel and Google Sheets behavior has not been independently verified. Google Sheets: import the .xlsx with File > Import > Upload. This conversion has not been independently verified; keep the original as a backup and spot-check key totals and times. Use a larger screen when reviewing full tables.

HOW TO DOWNLOAD

1. Buy. Delivery is instant — nothing ships.
2. Open the marketplace download page after checkout. Account buyers can also reopen the order from their purchases or library; guest buyers use the receipt-email link. If the app shows no download button, use a browser.
3. Download the workbook and the 5-page quickstart PDF.
4. Fill in the yellow cells. You are running.

SUPPORT. The address currently monitored for Lark Paper questions is [email protected].

Not what you expected? Message us within 30 days.

AI DISCLOSURE. AI tools helped build the formulas, layout and wording.

Add to cart and start tonight.