Organize your bank statements for tax preparation

Organize a year of statements, step by step

1. Gather every account. Business checking and savings, every credit card used for business, and any personal card that paid business costs. Include the statement after year end: a statement closing on January 5 still holds late-December transactions.
2. Upload them together. PDFs, scans, phone photos and bank CSV files all work. Each statement is checked: opening balance + money in − money out = closing balance.
3. Set your categories to the lines your preparer uses — for a US sole proprietor, the Schedule C expense lines below.
4. Review and correct. Fix wrong categories, mark transfers and owner draws, and save corrections as rules.
5. Export the tax year. Select all statements and export one Excel file limited to January 1 – December 31 (or your fiscal year).

Match categories to Schedule C lines

If you file Schedule C, naming your categories after its expense lines means the Summary sheet already lines up with the form. Common ones, from the IRS instructions for Schedule C:

This is an organizing aid, not tax advice. Which costs are deductible, and how much, is your preparer's call. Outside the US, use your own tax form's categories instead — see business expense categories.

Find deductible expenses in your statements

Sort the year by payee and the recurring costs jump out: software, hosting, phone, subscriptions. Then go through the personal accounts and cards for business costs paid from the wrong account — they are easy to miss, so list them for your preparer.

Keep in mind what a statement can't tell you. It proves you paid, not what you bought or why; the IRS lists account statements alongside receipts and invoices and notes that a combination of documents may be needed. Keep receipts for meals, travel and large purchases.

Not every line is income or an expense

• Transfers between your own accounts and credit card payments are neither — the card purchases are the expenses
• Owner draws and contributions move money between you and the business
• Loan proceeds aren't income, and loan principal repayments aren't expenses; only the interest goes on the return
• Refunds reduce the original expense rather than adding income
• Equipment and other assets may need to be depreciated rather than expensed — flag them for your preparer
• Deposits should roughly match your sales records and any 1099-K or 1099-NEC forms you received

What to hand your tax preparer

One Excel file per business: the Transactions sheet with every categorized line, and the Summary sheet with totals by category and by month. Add the original statements and a short list of open questions (asset purchases, loans, home office). Preparers can then check a total against the transactions behind it instead of rebuilding the year.

If you prepare returns for clients, the same steps give you one organized export per client and year. For larger catch-up work, see bank statement conversion for accountants and bookkeepers.

What it costs

Pages with transactions count; cover pages and blank pages don't. A year of statements at up to eight pages a month fits in a 100-page pack for $12, which never expires. Statements that don't balance are free. See pricing.

Questions