Every Collection Information Statement means the same grind: three or more months of bank statements per account, keyed line by line to average the client's income and expenses. Upload the statements and BankXLSX returns clean Excel or CSV rows with dates, descriptions, amounts, and running balances, so an enrolled agent or tax attorney can compute average monthly income and average balances for Form 433 in minutes. Built for tax resolution firms, EAs, CPAs, and tax attorneys representing clients before the IRS. 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...
Convert every statement in the case to a spreadsheet, then average the monthly deposits and expenses so the Collection Information Statement rests on data instead of guesswork. The IRS asks for at least the most recent three months of statements for every account on Form 433-A and 433-F, and the OIC package on Form 433-A(OIC) wants the same. Upload each statement to BankXLSX and it writes every transaction into dated rows with the running balance intact, so you can total deposits to find average monthly income, group the debits into the expense lines the form uses, and cite figures that match the statements the IRS reviewer is holding.
The representation is the expertise. Retyping a client's statements to average income and expenses is not, and it is where these engagements lose their first hours.
Form 433-F and 433-A each want the most recent three months of statements for every account, and a client with checking, savings, and a business account turns that into a stack of PDFs to reconcile.
The Collection Information Statement runs on average monthly income and expenses, so you cannot just copy a balance. You have to total and divide across months, which means the data has to be in a spreadsheet first.
Copy a statement into Excel and the columns jam into one cell, so building the income and expense averages by hand means retyping every deposit and debit.
The IRS treats deposits as potential income unless shown otherwise, so you need every deposit in a row to identify transfers, loans, and non-income items before the numbers go on the form.
Clients photograph or rescan statements, leaving image-only PDFs you cannot select, which stalls the whole file until someone keys them in.
Collection deadlines, CSED math, and OIC timelines all run against the clock, and the data-entry step is the one that quietly pushes a filing late.
Upload the statements for every account, and the converter writes each transaction into spreadsheet columns you can total, average, and drop into the income and expense lines of Form 433.
Each line becomes a row with date, description, amount, and running balance, so every deposit and debit is ready to total and average across the months.
With deposits in a column, average monthly income is a sum divided by the number of months, not an afternoon of adding by hand.
Sort the debits so housing, utilities, and other categories on the form roll up cleanly, matching the way the Collection Information Statement is laid out.
OCR pulls the numbers off image-only statements a client photographed or rescanned, so a photocopied file still becomes rows you can work with.
The statement balance carries through every row, so the account balances you report on the form tie back to the statements the IRS is holding.
256-bit encryption in transit and you can delete uploads whenever you want, which matters for a client file full of names, account numbers, and balances.
No software to install and no credit card to start.
Get the most recent three months of statements for every account, personal and business, from the client or online banking.
Tip: OIC cases and older collection matters may call for more than three months.
Drag the statements into the box above. The converter reads each one, scans included, and writes every transaction to a row.
Tip: Upload all accounts at once to average income across the whole picture.
Save the result as XLSX or CSV, then total deposits for average monthly income and group debits into the expense lines the form uses.
Tip: Flag transfers and loan proceeds so they are not counted as income.
Anyone building a Collection Information Statement or an Offer in Compromise works from months of client statements, so the people converting them are the professionals who represent taxpayers before the IRS.
EAs handling installment agreements and OICs convert client statements to average income and expenses for Form 433 without keying every line.
Attorneys negotiating collection matters turn a client's statements into a defensible income and expense schedule that ties to the documents in the file.
Firms running many cases at once convert statements in bulk so staff spend their time on strategy, not data entry.
CPAs representing clients in collections build the CIS from converted statements and reconcile the reported balances back to the PDFs.
At least the most recent three months for every account. Form 433-F and Form 433-A both ask for the last three months of statements for all checking, savings, and investment accounts, and the Offer in Compromise version, Form 433-A(OIC), asks for the same three-month window. Older collection matters, business cases, or a reviewer who spots gaps can push that to six months or more. Whatever the count, the task is identical: convert each statement to rows, average the income and expenses, and report figures that match the PDFs the IRS is holding.
Total the deposits across the statement period and divide by the number of months, after removing anything that is not income. Transfers between the client's own accounts, loan proceeds, credit card cash advances, and one-time reimbursements are deposits but not income, so they come out before you average. With every deposit sitting in a spreadsheet column this is a sum, a few subtractions, and a division, instead of a manual read of three or six PDFs. The table below shows which deposits count.
| Deposit on the statement | Counts as income for the 433? |
|---|---|
| Payroll or self-employment payment | Yes |
| Transfer from the client's own savings | No, it is a transfer |
| Loan or line-of-credit advance | No, it is borrowed funds |
| Refund or reimbursement | Usually no, confirm the source |
Sort the debits so they roll into the categories the form uses: housing and utilities, transportation, health care, taxes, and the rest. With the transactions in a spreadsheet you filter the description column and total each group, then compare against the IRS Collection Financial Standards where those caps apply. Once the debits are in rows, categorizing the transactions does most of the grouping for you, and you carry the monthly averages onto the form.
An accepted installment agreement or Offer in Compromise only holds if the client stays current going forward, which means clean books from here on. For a self-employed client, converting each new statement and building a profit and loss keeps the income visible, and an expense management tool that reads and sorts receipts automatically helps the client hold the spending discipline the agreement assumes. To close out the historical cleanup fast, the catch-up bookkeeping converter turns a backlog of statements into books in one pass.
BankXLSX converts documents to spreadsheets. It does not give tax or legal advice and does not represent anyone before the IRS. Follow the current IRS instructions for your form, or consult a licensed tax professional.
At least the most recent three months for every account. Form 433-F, Form 433-A, and the Offer in Compromise version 433-A(OIC) all ask for the last three months of statements for checking, savings, and investment accounts. Older or business cases may need six months or more, so follow the current instructions for your form.
Total the income deposits across the statement period and divide by the number of months, after removing transfers, loan proceeds, and reimbursements that are not income. Converting the statements to a spreadsheet turns this into a sum and a division instead of adding deposits by hand across several PDFs.
Yes. OCR pulls the numbers off image-only statements a client photographed or rescanned, so a photocopied file still becomes rows you can total and average for the form.
Put every deposit in a row, then flag the ones that are transfers between the client's own accounts, loan advances, or reimbursements, and exclude them before averaging. Working from a spreadsheet makes those easy to spot and remove, which keeps the reported income accurate.
Yes. The running balance is preserved on every row, so the account balances you report on the form reconcile to the same statements the IRS reviewer is holding, which is the tie-out that keeps the filing defensible.
Uploads use 256-bit encryption in transit, you can delete files at any time, and data is never resold or shared. The conversion runs without installing anything, which matters for a client file that lists names, account numbers, and balances.
No. BankXLSX converts statement PDFs to spreadsheets and nothing more. It does not give tax or legal advice and does not represent anyone before the IRS. For what your filing requires, follow the current IRS instructions or consult a licensed tax professional.
Answer an examination built on the deposit method.
Tie reported balances back to the statements.
Convert any US bank statement PDF to Excel.
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 |
