/
IRS Bank Deposit Analysis From PDF Statements in QuickBooks
Convert a PDF bank statement to a QuickBooks file
Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.
An IRS bank deposit analysis adds up every deposit into every account the taxpayer controls, takes out the deposits that are not income, and compares what is left with the gross receipts on the return. The fastest way to prepare your own version before the examiner does is to convert the client's PDF statements to .qbo files, import them into QuickBooks, give every deposit a category, and print a schedule that reconciles to the return to the cent.
This article walks through that reconciliation with one full worked example, the categories that matter, the mistakes that make clean clients look like they underreported, and what the conversion step has to get right. If you have the statements in hand already, the converter on our PDF to QBO page for enrolled agents takes the first one now.
How the IRS runs the analysis
The Internal Revenue Manual section on examination of income treats a bank and financial account analysis as one of the minimum income probes for an individual business return. The reasoning is simple: statements are produced by a third party, so they are the hardest records to argue with. The examiner totals deposits for the year across business and personal accounts, then asks the taxpayer or representative about nontaxable sources such as loans, gifts and transfers. Whatever cannot be explained is a candidate for unreported income.
The burden in practice sits with the taxpayer. A deposit with no explanation is treated as income until someone shows otherwise, which is why the representative who arrives with a categorized schedule controls the conversation. The examiner can still test it, but they are testing your numbers rather than building theirs.
A worked reconciliation from two accounts
Here is a sole proprietor with a business checking account and a personal savings account, under exam for one year. The Schedule C reported gross receipts of $128,900.00. The figures are an example, but the shape is typical of the exams we see representatives prepare for.
| Line | Amount | Source |
|---|---|---|
| Deposits to business checking | $171,340.18 | 12 converted statements |
| Deposits to personal savings | $24,500.00 | 12 converted statements |
| Gross deposits, both accounts | $195,840.18 | |
| Less transfers from savings to checking | ($18,000.00) | Matching withdrawals on savings |
| Less transfers from checking to savings | ($9,000.00) | Matching withdrawals on checking |
| Less equipment loan proceeds | ($12,000.00) | Loan agreement and lender statement |
| Less spouse's W-2 wages deposited to savings | ($15,500.00) | Form W-2, already on the return |
| Less gift from a parent | ($5,000.00) | Gift letter and the parent's cancelled check |
| Less insurance reimbursement for a damaged vehicle | ($3,450.18) | Insurer's settlement letter |
| Less prior year tax refund | ($2,140.00) | Treasury deposit on the statement |
| Less customer check returned and redeposited | ($1,850.00) | Returned item and second deposit |
| Net deposits from business | $128,900.00 | |
| Gross receipts on Schedule C | $128,900.00 | The return |
| Unexplained difference | $0.00 |
Before any adjustments, gross deposits run $66,940.18 above reported receipts. That is a 52 percent gap, and a schedule that stops at gross deposits invites a deficiency in that amount. Every adjustment below it is ordinary, and every one is easy to prove once the deposits sit in a ledger with dates and amounts that point to a statement line. It is hard to prove when the only record is a highlighter on 24 PDFs.
The two items that cause most of the gap
Transfers between the client's own accounts are the biggest single trap. Money moved from savings to checking is a deposit on the checking statement, and money moved back is a deposit on the savings statement, so the same dollars can be counted twice in one year. In the example, $27,000 of deposits are just the client's money moving around. You can only remove them confidently when both accounts are converted and each transfer pairs with a matching withdrawal on the other side. That is why the account inventory comes first, and why our guide to importing multiple bank accounts into QuickBooks keeps one file per account.
The second is money that was income to someone else or already taxed. Wages reported on a W-2, a tax refund and an insurance reimbursement all land as deposits and none of them belong in gross receipts. Representatives who miss these do the examiner's work for them.
Building the schedule in QuickBooks
- Inventory every account for the years at issue. Business and personal checking, savings, credit cards, payment apps, brokerage. A transfer to an account you never converted cannot be paired, so it stays in gross deposits.
- Convert each monthly statement to .qbo. Check the converted total against the printed closing balance before you download. A missing deposit understates your gross figure and an extra one overstates it, and either one undermines the whole schedule.
- Import into a client file, one account at a time. Set each account's opening balance as of the day before the first statement. Our guide to a full year of client statements converted to QBO shows the month by month chain check that proves nothing is missing.
- Categorize every deposit. Use income accounts for sales and service receipts, and separate accounts for transfers, loan proceeds, owner contributions, gifts, refunds, reimbursements and redeposits. Match transfers between accounts so each pair nets to zero.
- Run a deposit detail report by category for each year. Its totals are the lines of the reconciliation table above. Export it, attach the supporting documents for each nontaxable line, and you have the schedule you hand over.
For a client with several accounts and several years, the stack gets large quickly. Two accounts over three years is 72 statements. The batch PDF to QBO converter covers working through that many files in one sitting, and older paper statements that the client scanned go through the scanned bank statement converter.
Mistakes that make a clean client look short
- Counting the redeposit twice. A customer check that bounced and was deposited again appears twice in deposits and once in receipts. Pair the returned item with the second deposit.
- Using statement totals instead of rows. The summary box shows total credits, which often include interest and reversals. Build the figure from individual rows so every credit has a category.
- Ignoring the year boundary. A statement running December 17 to January 16 holds two tax years. Converted rows must carry their real dates, or a December deposit drifts into the wrong year's schedule.
- Leaving out cash spent before deposit. If the client paid expenses in cash from receipts that never reached the bank, deposits understate income. The IRM pairs the bank deposits method with cash expenditures for that reason, so ask about it before the examiner does.
- Typing the amounts. A transposed digit in a deposit is exactly the kind of difference an examiner will find, and it costs credibility on every other line.
What the conversion step has to get right
| Requirement | Why it matters in an exam |
|---|---|
| Closing balance check per statement | Proves no deposit was dropped or doubled before the schedule is built |
| Editable review of every row | A misread amount is fixed before it reaches the ledger |
| Real transaction dates | Keeps deposits in the correct tax year at the boundaries |
| Closed and old accounts | Reads the PDF itself, no live bank connection needed |
| Scanned statement support | Older years often exist only on paper |
| QBO and IIF output | Works with whatever QuickBooks version the client file uses |
On our plans one statement PDF is one document. A one-year exam with two accounts is 24 documents and fits the Starter plan's 50 a month for $49. Three years of two accounts is 72, which fits two months of Starter for $98 or one month of Plus for $149. Current terms are on the pricing page. Against roughly 16 hours of keying for those 72 statements, the conversion cost is a rounding error on the engagement fee.
Keep the converted files and the PDFs together in the client file after the exam closes. The IRS guidance on how long to keep records sets three years as the general period and six years when unreported income exceeds 25 percent of the gross income shown, so the same statements may be needed again.
Frequently asked questions
Does the IRS look at all bank deposits?
Yes. In a bank deposits analysis the examiner totals deposits to every account the taxpayer controls, business and personal, including savings and brokerage. Deposits are then reduced for nontaxable sources the taxpayer can document, such as transfers, loans and gifts, and the remainder is compared with reported income.
Are transfers between my own accounts counted as income?
They should not be, but they will be unless you show them. A transfer appears as a deposit on the receiving account, so both accounts need to be on the schedule with each transfer matched to its withdrawal. Unmatched transfers stay in gross deposits and look like unreported receipts.
How far back can the IRS look at bank statements?
Generally three years from filing, the normal assessment period. The IRS says to keep records for six years if unreported income is more than 25 percent of the gross income shown on the return, and there is no limit for fraud or unfiled returns. Have every statement for the open years.
What deposits are not taxable income?
Common nontaxable deposits are transfers between your own accounts, loan proceeds, gifts and inheritances, tax refunds, insurance reimbursements up to your loss, returned and redeposited checks, and income already reported elsewhere on the return, such as W-2 wages. Each needs a document behind it, not just a note.
The same deposit logic applies outside tax exams. For a six month worked example that removes transfers from revenue, see bank statement analysis software for PDF statements.
Skip the manual entry
Upload a PDF bank statement and get a QBO or IIF file ready to import into QuickBooks.
Convert a Statement