How to Calculate Quarterly Estimated Taxes From Bank Statements
Jul 21, 2026
Convert your bank statement to Excel now
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Last updated July 2026.
To calculate quarterly estimated taxes from bank statements, total your business deposits for the quarter, subtract your categorized deductible expenses to get net profit, then apply your income tax rate plus the 15.3% self-employment tax. Pay that amount by each 1040-ES deadline. If your income swings month to month, the simpler route is the safe harbor: pay 100% of last year's total tax (110% if your prior-year AGI was over $150,000) and you avoid the penalty regardless of how this year turns out.
Freelancers and 1099 contractors rarely have a tidy income figure to work from mid-year, so the business checking account becomes the running record of what came in and went out. Turn those statements into numbers and the estimate is arithmetic. If your statements are PDFs, convert them to a spreadsheet so you can total deposits and expenses per quarter.
Why estimated taxes come from your bank statements
When no employer withholds tax for you, the IRS expects you to prepay in four installments as you earn. To size each payment you need two numbers for the quarter: how much business income you received and how much you spent on deductible expenses. Both live in your bank statement. Deposits show the income; checks, ACH, and card payments show the expenses once you have sorted the business ones from personal spending and owner transfers.
The one trap is treating every deposit as income. Transfers from your own savings, a loan advance, a refund, or a capital contribution are not taxable income, so they have to come out before you calculate. That is why the estimate starts with a clean, categorized statement rather than a raw account balance.
The four 2026 payment deadlines
Estimated tax is due four times a year. The periods are uneven, so a strong Q2 or Q3 can push a payment higher than you expect.
| Payment | Income period | Due date |
|---|---|---|
| Q1 | January 1 to March 31, 2026 | April 15, 2026 |
| Q2 | April 1 to May 31, 2026 | June 15, 2026 |
| Q3 | June 1 to August 31, 2026 | September 15, 2026 |
| Q4 | September 1 to December 31, 2026 | January 15, 2027 |
You generally must pay estimated tax if you expect to owe at least $1,000 for the year after withholding and credits.
How to calculate the number, step by step
- Total the quarter's business income. Sum the deposits on your business statement for the period, then remove anything that is not income: owner transfers, loans, refunds, and money moved between your own accounts.
- Subtract categorized business expenses. Total the deductible spending for the same quarter. Sorting the statement into expense categories first makes this a single SUMIF rather than a hunt.
- That difference is your net profit. Income minus expenses is the number both taxes are built on.
- Add self-employment tax. Self-employment tax is 15.3% (12.4% Social Security up to the annual wage cap, plus 2.9% Medicare) applied to 92.35% of net profit. Half of it is deductible when you figure income tax.
- Add income tax at your bracket. Apply your marginal federal rate (and state rate, if any) to net profit after the SE-tax deduction. Add the two taxes, divide the year's total across the remaining quarters, and pay with Form 1040-ES.
A common shortcut for people who do not want to run the full worksheet each quarter is to set aside 25% to 30% of net profit as it lands. Keeping a running tally of business income as it comes in makes that discipline far easier than reconstructing it every three months.
Use the safe harbor to avoid the penalty
You can skip the quarter-by-quarter forecasting entirely and still avoid an underpayment penalty. The safe harbor says your withholding plus estimated payments only need to cover the smaller of two targets:
| Safe-harbor target | What you pay | Who it fits |
|---|---|---|
| 90% rule | 90% of this year's tax | Income roughly flat or falling |
| 100% rule | 100% of last year's tax | Prior-year AGI $150,000 or less |
| 110% rule | 110% of last year's tax | Prior-year AGI over $150,000 |
The prior-year targets are the easy ones because last year's total tax is a fixed, known number. Divide it by four, pay that each quarter, and you are covered even if this year's income spikes. You settle any remaining balance when you file.
How do I calculate quarterly taxes if I am self-employed?
Total your business income for the quarter, subtract deductible expenses to get net profit, then apply 15.3% self-employment tax to 92.35% of that profit and add your income tax bracket. Bank statements give you the income and expense totals once you convert them to a spreadsheet and categorize the rows.
What percentage should I set aside for quarterly taxes?
Most self-employed people set aside 25% to 30% of net profit for combined federal income and self-employment tax, with more if they owe state tax or sit in a higher bracket. Moving that share into a separate account each time a client pays keeps the quarterly payment funded without a scramble at the deadline.
What happens if I do not pay quarterly estimated taxes?
The IRS charges an underpayment penalty, calculated like interest on the amount you should have paid for each period you were short. It is not a flat fine, so paying late or partially is better than not paying. Meeting a safe-harbor target, 100% or 110% of last year's tax, removes the penalty entirely.
Do I have to pay estimated taxes if I also have a W-2 job?
Not always. If the withholding from your W-2 job covers a safe-harbor target, you can let it do the work and skip estimated payments on your side income. You can also raise your W-2 withholding to cover the freelance tax instead of writing quarterly checks, since withholding counts as paid evenly across the year.
Build the quarterly worksheet from your statements
Every number here comes from one categorized spreadsheet of the quarter's activity. Start by turning the statement PDFs into rows with the bank statement converter, then categorize the transactions so income and each expense group total on their own. The same data drives a profit and loss report, and if you need to prove the income figure to a lender or the IRS, the method for calculating self-employed income from bank statements uses the same totals.
Ready to convert your bank statement?
Upload a PDF and get clean Excel or CSV in seconds. Works with statements from any bank.
Convert to Excel nowFree to try, no credit card required