What the IRS says about estimated tax
According to the IRS page on estimated taxes, individuals, including sole proprietors, partners and S corporation shareholders, generally must make estimated tax payments if they expect to owe $1,000 or more when they file. The page says individuals generally use Form 1040-ES, and that you estimate your expected adjusted gross income, taxable income, taxes, deductions and credits for the year. It adds that your prior-year return can serve as a starting point, and that you should adjust the estimate if your situation changes.
The same page says estimated tax covers income such as interest, dividends, self-employment income, capital gains, and prizes and awards, as well as taxes such as self-employment tax. It also notes that if income arrives unevenly, you may be able to lower a penalty by annualizing income on Form 2210.
This is general information, not tax, legal or financial advice. Thresholds and rules change, so check the linked IRS pages and ask a qualified tax professional about your own situation.
What the IRS says about business income records
IRS Publication 583 says everyone in business must keep records, and that records help you monitor the business, prepare financial statements and tax returns, and support items reported on returns. It says that, except in a few cases, you can use any system that clearly shows your income and expenses.
For income, the publication lists documents that show gross receipts, including bank deposit slips, receipt books, invoices, credit card charge slips and Forms 1099-MISC and 1099-NEC. It says you should keep deposit slips and note the source of each deposit.
The publication also recommends keeping a business checking account separate from a personal one, and reconciling it each month. Those are recommendations from the IRS publication, not rules we are adding.
Turning statements into an income and payments log
Converting a statement to a spreadsheet gives you one row per transaction. Add a "Source" column for each deposit, as Publication 583 suggests noting, and a "Type" column that separates client income, estimated tax payments, refunds and transfers between your own accounts. A synthetic example:
Date Description Amount Source Type
02/03/2026 Deposit - Example Client A 2,400.00 Client A inv 101 Business income
02/10/2026 Transfer from savings 500.00 Own account Transfer (not income)
04/14/2026 Tax payment - IRS -900.00 Quarterly Estimated tax paid
04/22/2026 Deposit - Example Client B 1,800.00 Client B inv 102 Business incomeA SUMIFS or pivot table can then total income by month or quarter, which makes it easier to compare against the estimate you are working from. Keeping transfers in a separate type stops them from being counted as income by mistake.
Payments to the IRS often appear on a statement, so you can list them alongside the income. The IRS page says payments made through your online account show payment history, so that is the place to confirm what was recorded. A bank line is a starting point, not the IRS record of the payment.
Limits of a bank-statement spreadsheet
A deposit does not say whether it is taxable income, a refund, a loan or a personal transfer. The spreadsheet records what moved, and you still need the invoice or other document to know what it was. Publication 583 also says that proof of payment, by itself, does not establish that you are entitled to a deduction, so expenses need supporting documents too.
The spreadsheet is a working summary. We are not claiming it satisfies any recordkeeping requirement, so keep the original statements and documents. Publication 583 lists how long records generally need to be kept, depending on the situation, and gives a general 3-year period for the case where no longer period applies. Check it for your circumstances. PDFtoRow can convert statement PDFs to Excel or CSV as a starting point for the log.
Convert Bank Statement PDFs Cleanly with PDFtoRow
Tired of fixing broken columns, corrupted dates, and numbers stored as text? PDFtoRow extracts transaction tables directly from digital PDF vector layers, preserving check numbers and outputting true numeric amounts. Statements up to 5 pages are free once per email every 24 hours. Check the 10-row preview before you download.
Frequently Asked Questions
According to the IRS, individuals, including sole proprietors, partners and S corporation shareholders, generally must pay estimated tax if they expect to owe $1,000 or more when they file. Check the IRS page for exceptions.
Publication 583 lists bank deposit slips among documents that show gross receipts and says you should keep them and note the source of each deposit. It also says you can use any system that clearly shows your income and expenses.
Publication 583 lists account statements among expense records but warns that proof of payment, by itself, does not establish that you are entitled to a deduction. You also need documents showing the cost was for the business.
Primary Evidence & Official References
- Estimated taxes — irs.gov (Verified 2026-10-29). Official source documentation →
- Publication 583, Starting a Business and Keeping Records — irs.gov (Verified 2026-10-29). Official source documentation →