1040-ES Payment Log Excel - Free Template

1. Open the Payment Log tab and enter each estimated tax payment as soon as you make it. Put the actual payment date, quarter, amount, and a short note such as EFTPS, check, or direct pay.
2. Check the Tax Summary tab after each entry. Use it to see how much you have paid so far and whether you still need to cover the next quarter.
3. Match the due dates to the 1040-ES schedule. For 2026, the four payment dates are April 15, June 15, September 15, and January 15.
4. Keep your bank confirmation or EFTPS receipt with the workbook. That gives you a second source if you ever need to prove a payment.
5. Update the log whenever your income changes. A $3,000 quarter and a $12,000 quarter should not be treated the same when you estimate the next payment.
6. Review the Instructions tab once before your first entry, then use the workbook as your standing quarterly checklist.

This workbook fits the people who actually make quarterly tax payments in real life: a sole proprietor on Schedule C, a single-member LLC, a freelancer with no payroll withholding, or a couple with two income streams and no extra W-4 withholding. The log is most useful when cash flow is uneven and you need to see exactly what has been paid before the next deadline.

A contractor with four employees may run payroll every two weeks, but still owe personal estimated taxes on business profit. If that owner sets aside $1,500 from each strong month and makes a $4,500 quarterly payment, the log shows whether the cash is there before the next Form 1040-ES date.

Quarterly Deadlines Matter

The need spikes around April 15, June 15, September 15, and January 15, when the next payment is due. If you wait until the day before the deadline, a clean worksheet saves you from guessing whether you already paid $875 or $1,875.

Useful For Simple And Mixed Income

This is also a good fit for someone who gets a 1099 side gig on top of wage income. A household with $90,000 of W-2 wages and $18,000 of freelance profit can use the log to separate what the employer withheld from what still needs to be sent with 1040-ES.

The IRS expects you to keep proof of each payment, the date it was made, and the amount applied to the correct tax year. For most recordkeeping, the practical standard is at least 3 years, and longer if you have items that affect later filings.

For self-employment income, the payment log supports the numbers that ultimately flow into Form 1040, Schedule C, and Schedule SE. The point is not to guess your tax; it is to document the quarterly deposits so you can match them to the return at year-end.

Use The Due Dates, Not Your Memory

For 2026 estimated taxes, the four federal deadlines are April 15, June 15, September 15, and January 15. If your income is steady and you owe $10,000 for the year, that usually means roughly $2,500 per quarter unless your numbers change.

Keep The Paper Trail Simple

If you pay through EFTPS or IRS Direct Pay, the confirmation number belongs in the note field. That gives you a clean audit trail when you compare your worksheet to the bank feed or your year-end tax organizer.

The most common failure is not the tax math; it is the missing record. If you make four payments of $2,000 each and forget to log one of them, you can overpay by $2,000 when you do your year-end estimate or, just as bad, think you are covered when you are not.

I have seen taxpayers miss one quarterly payment, then scramble in January and still face an underpayment penalty because the payment landed after the cutoff. That penalty may be small on one return, but a repeated miss can cost real money and force a time-consuming IRS notice response.

Bank Statements Are Not Enough By Themselves

Bank feeds can drop descriptions or split transactions in ways that make tax review harder. If you paid $1,250 through a direct transfer and later need to prove which quarter it covered, a dated log is faster than digging through months of statements.

Bad Quarter Labels Create Bad Decisions

Another mistake is mixing the tax year with the payment year. A January 15 payment may be the fourth installment for the prior year, and if you label it wrong you can distort your estimated taxes calculation by an entire quarter.

The way to make this spreadsheet stick is to tie it to the same day you already do money work. Most people update it right after payroll, after the month-end close, or when they send the Form 1040-ES payment online.

Use A Fixed Routine

• Enter the payment the same day you send it, not later in the week.
• Review the Tax Summary when you close the books each month.
• Copy the prior quarter’s note style so your records stay consistent.

Use The Sheet Until It Stops Being Enough

If you have one business and four quarterly payments, a spreadsheet is usually enough. Once you are managing multiple entities, payroll, sales tax, and cash-flow forecasting across several accounts, move the payment tracking into a bookkeeping system like QuickBooks and keep the spreadsheet only as a review copy.

A simple habit beats a perfect template that sits unused. If you spend 5 minutes after each payment and 10 minutes each quarter reviewing the totals, you can stay ahead of the deadline instead of rebuilding the year from scratch.