State auditors tie your deposits to your returns. Do it first. BankXLSX converts three or four years of business bank statement PDFs into Excel or CSV with date, description, amount, and running balance in separate columns, so you can total deposits by month, remove what is not a sale, and see the variance before the audit conference. Start free, no credit card.
Last updated July 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
State auditors use bank deposits as an independent measure of gross sales. They reconcile the sales reported on your returns against the general ledger, the federal income tax return, and total bank deposits, and any gap becomes the starting point for an assessment. Deposits are attractive to an auditor because they come from a third party and are hard to alter. The defense is not to withhold them, it is to reconcile them yourself first and be able to explain every non-sale deposit with a document.
Most businesses can produce the returns and the ledger quickly. Turning several years of statements into something that reconciles is where the audit stalls.
A typical lookback is three to four years, and longer where returns were never filed. That is forty to fifty statements per account before any tie-out starts.
The deposit includes the tax you charged the customer. Comparing gross deposits to taxable sales without backing out collected tax manufactures a variance that is not real.
Owner contributions, loan proceeds, insurance settlements, refunds from vendors, and transfers between accounts all sit in the deposit column and none of them are taxable receipts.
Processors deposit gross sales less fees and chargebacks, so bank deposits read lower than sales. Auditors know this, but you have to evidence the reconciling amount.
Resale, wholesale, and exempt customer sales are in the same deposit stream as taxable retail sales. Without transaction level data you cannot show the split.
Many states assess from a sample period and project it across the audit period, so one misclassified month can move the assessment by a multiple.
Upload the statements and get the structured, sortable rows the reconciliation schedule needs.
Each credit becomes a row with its date, description, and amount, so you can tag sales, transfers, loans, and refunds separately.
Dates parse as dates, so deposits roll up to the same filing periods as your returns with one pivot table.
Every month ties to the printed closing balance, which is how you demonstrate the schedule is complete and no period was left out.
Output columns stay identical across banks, so multi location or multi entity operators can stack accounts into one workbook.
Older years are often paper scans pulled from a closed account. OCR built for statement layouts reads them.
256-bit encryption in transit, deletion on your schedule, and no reselling or sharing of uploaded financial data.
No software to install and no credit card to start.
Upload every business account for the full period the notice covers, plus any account that received sales proceeds or transfers.
Tip: Pull statements for closed accounts early; banks can take a week or more to produce them.
Tag each deposit as taxable sale, exempt sale, sales tax collected, transfer, loan, capital contribution, refund, or other, and note the document that supports each subtraction.
Tip: Keep the support note in the same row as the deposit so the workpaper stands alone.
Roll adjusted sales up to your filing periods, compare to the gross and taxable sales reported, and write one line of explanation for each remaining difference.
Tip: Do this before the opening conference so you control the narrative on any variance.
Cash and card intensive businesses draw the most deposit scrutiny, and the professionals defending them need the data in a spreadsheet.
Reconcile POS sales, card settlements, and cash deposits to reported taxable sales when an auditor questions the cash ratio.
Total deposits by location and period, and separate exempt and resale sales from taxable retail sales.
Split taxable materials and repair receipts from nontaxable labor or real property improvement work.
Build a client reconciliation schedule in hours instead of weeks and challenge the auditor deposit analysis on specific rows.
The records request differs by state but the core list is remarkably consistent: filed sales tax returns for the period, the general ledger and sales journal, federal income tax returns, exemption and resale certificates, POS or invoice detail, and bank statements. Texas, for example, publishes a request that pairs the general ledger and sales journals with bank statements and federal returns. The reason all four appear together is that the auditor intends to cross-check them against one another.
| Record | What the auditor tests with it |
|---|---|
| Filed sales tax returns | The reported baseline every other record is compared against. |
| Bank statements | Independent third party evidence of what was actually collected. |
| Federal income tax return | Gross receipts reported to the IRS versus gross sales reported to the state. |
| General ledger and sales journal | Whether the books support the returns and agree to the bank. |
| Exemption and resale certificates | Whether claimed exempt sales are documented. Missing certificates are a common assessment. |
| POS or invoice detail | Transaction level support for the split between taxable and exempt sales. |
Most states run a three year lookback from the date a return was due or filed, and several use four. That window stretches in three situations. A substantial understatement, commonly defined as more than 25 percent of the tax due, extends many states to six years. Returns that were never filed usually carry no limitation at all, so the state can reach back indefinitely for those periods. Suspected fraud also removes the limit in most states. Confirm the rule for your own state, because the specifics vary and an extension you sign, often called a waiver, will lengthen the period further.
The schedule the auditor will build looks like this, so build it first and know the answer.
Auditors see the same false positives constantly, and every one of them is fixable with data rather than argument.
The whole exercise depends on having deposit level data. Convert the statements with the bank statement converter, keep the completeness control by using running balance extraction, and speed up the tagging step with transaction categorization. The arithmetic on the deposit side is the same procedure covered on the bank deposit analysis page. If the same books are also being examined federally, the bank statement converter for tax resolution covers the IRS side, and restaurants and retailers can start from the persona pages for restaurants and ecommerce sellers. Card heavy businesses will also want the Square statement converter or the Stripe statement converter to evidence the fee adjustment.
Businesses that get assessed once usually tighten two things: monthly reconciliation of deposits to reported sales, and a real system for collecting exemption certificates. Keeping an ongoing register of compliance obligations and controls makes the next records request a retrieval exercise rather than a reconstruction project.
In most states the auditor can request bank records, and refusing usually leads to a subpoena or to an assessment estimated from whatever information the state does have. The practical approach is to provide the periods requested and hand over your own reconciliation schedule at the same time so the deposits are already explained.
Most states use a three or four year lookback from the return due date or filing date. It extends to about six years where the understatement is substantial, often defined as more than 25 percent, and there is generally no limit for periods where no return was filed or where fraud is alleged.
Usually for legitimate reasons: the deposits include sales tax you collected, transfers from other accounts, loan proceeds, owner contributions, vendor refunds, and non-sales income. Each has to be identified and documented. What remains after those subtractions is the number the auditor should be comparing to your returns.
Total deposits by filing period, subtract non-sale deposits such as transfers and loans, add back card processing fees if settlements arrive net, back out the sales tax collected inside the deposits, split taxable from exempt sales using invoice detail, then compare the result to the sales reported on each return.
Filed returns for the audit period, the general ledger and sales journal, federal income tax returns, bank statements, exemption and resale certificates, purchase invoices, and POS or invoice level sales detail. The auditor cross-checks the four summary sources against each other before testing transactions.
Many states test a sample period or a block of transactions and project the error rate across the whole audit period. That is why a single misclassified month matters so much. Review the sample selection and the projection method as carefully as the underlying transactions.
For a small, clean, single state audit an experienced bookkeeper and a good reconciliation may be enough. Bring in a state and local tax specialist or an audit defense firm when the exposure is large, the state is projecting from a sample, nexus or taxability is contested, or the lookback goes beyond the normal statute.
No. It converts your bank statement PDFs into accurate Excel or CSV rows so you or your representative can build the reconciliation quickly. Classification decisions, taxability positions, and any representation before the state stay with you and your tax professional.
The deposit method arithmetic in detail.
The federal side of the same problem.
Built for cash and card heavy operators.
Tag deposits by source in bulk.
From the same family of tools
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
