Using Bank Statements for Tax Preparation: A Checklist

TL;DR: For tax season, collect a full year of statements for every account (plus the months either side), convert them into one categorized spreadsheet, separate business from personal, tag transfers, flag large or unusual deposits with explanations, and hand your preparer both the summary and the original PDFs. This is general information, not tax advice; your preparer decides how things are treated.

Every tax preparer has a version of the same story: a client arrives with a shoebox, or a folder of PDFs with no labels, or a bank login and a hopeful smile. The preparation itself can't start until someone works out what happened during the year, and bank statements are where that story is written.

This guide is for anyone getting their records ready for a preparer: sole proprietors, freelancers, landlords with a rental or two, small business owners without a bookkeeper, and households with more going on than a single paycheck. It's about organizing information. It isn't tax advice, and we'll point out the places where you should ask a professional rather than decide for yourself.

Why bank statements matter at tax time

For many small businesses and self-employed people, bank and card statements are the most complete record of income and expenses they have. Invoices may be scattered, receipts incomplete, and accounting software either absent or half-updated. The statements, though, show every deposit and every payment.

That makes them useful for:

• Building or checking a list of income received.
• Building a list of expenses by category.
• Finding things you forgot: subscriptions, bank fees, equipment bought mid-year.
• Answering a preparer's questions about specific amounts.
• Supporting your records if questions come up later.

Questions to ask your preparer before you start

A five-minute conversation before you organize anything can save hours. We'd suggest asking:

1. Which accounts do you need statements for, and for what date range?
2. Do you have a category list or organizer you'd like me to use?
3. Would you prefer a spreadsheet, a summary, original PDFs, or all three?
4. How do you want me to handle mixed business and personal accounts?
5. Do you need processor or platform reports in addition to bank statements?
6. How should I send files securely?
7. What's your deadline for receiving everything?

Their answers shape the whole job. A preparer who wants their own organizer filled in will find a beautifully formatted spreadsheet in a different layout less helpful than you'd hope. Ask first, then build what they'll actually use.

Step 1: collect the right statements

For every account involved, collect:

• All twelve months of the tax year.
• The month before and the month after, which help with items that cross the year boundary.

"Every account" means more than people expect:

• Business checking and savings.
• Personal accounts if any business money passed through them.
• Every credit card used for business, even occasionally.
• Payment apps and processors (PayPal, Stripe, Square, Venmo for business, and so on); their own reports, not just bank deposits.
• Loan statements for business loans or vehicles, which show interest separately from principal.
• Brokerage or investment accounts if your preparer handles those; these come with their own tax forms.

Download PDFs from online banking where possible. Name them consistently by account and month.

Step 2: convert and verify

Convert every statement into rows. A converter like SheetStatement does this and checks that each statement balances, so you know you're not missing transactions. Then check continuity: each month's opening balance should equal the previous month's closing balance. A gap means a missing statement.

This step is where most of the time savings come from. Retyping a year of statements is slow and error-prone; converting and verifying is fast.

Step 3: combine into one table

One table for everything, with these columns:

Column	Purpose
Date	Transaction date
Account	Which account or card
Description	Original bank text
Amount	Signed (money in positive, money out negative)
Category	Your label
Business/Personal	B or P
Notes	Explanations for anything unusual
Statement	Source file, for traceability

Step 4: tag transfers

Before categorizing, find money moving between your own accounts: checking to savings, card payments, processor payouts, owner contributions and withdrawals between business and personal. Tag them as Transfer.

Transfers aren't income or expenses. Counting a transfer from savings to checking as income, or a card payment as an expense, overstates both sides. This is the single most common error we see in self-prepared summaries.

Step 5: separate business and personal

If any account mixes business and personal spending, mark each transaction B or P. Be honest and consistent. If you're unsure whether something is business, mark it and add a note rather than guessing. Your preparer can make the call; that's their job, and the rules depend on your circumstances.

Going forward, a separate business account and card make next year far easier. It's one of the most useful things a small business owner can do for their bookkeeping.

Step 6: categorize

Use categories that match how your preparer works. Ask them for their list or their organizer template if they have one. If they don't, the expense lines on the relevant tax form for your business type are a sensible guide. Common examples:

• Advertising and marketing
• Bank and card fees
• Contract labor
• Insurance
• Interest
• Meals
• Office expenses and supplies
• Professional fees (legal, accounting)
• Rent or lease
• Repairs and maintenance
• Software and subscriptions
• Travel
• Utilities and phone
• Vehicle expenses
• Equipment (flag larger purchases separately)

Our guide on categorizing business expenses from bank statements and the Excel formulas for categorizing transactions post explain how to do this quickly with a rules table.

Items to flag rather than categorize

Some transactions need your preparer's judgment. Put them in a "Preparer review" category with a note:

• Large equipment or vehicle purchases.
• Payments to family members.
• Loan proceeds and repayments (the loan itself isn't income; the repayment's principal isn't an expense; interest may be treated differently).
• Owner contributions and draws.
• Estimated tax payments you made during the year.
• Anything that might be personal.
• Refunds and chargebacks.
• Insurance claims or other unusual receipts.

Step 7: explain your income

Deposits aren't all income, and preparers need to know which are. For every deposit, decide:

• Customer or client payment: income.
• Processor payout: income, but usually net of fees and refunds. Provide the processor's annual summary as well, since it shows gross amounts and fees.
• Transfer from your own account: not income.
• Loan proceeds: not income.
• Owner contribution: not income for the business.
• Refund from a supplier: reduces an expense rather than adding income.
• Something else: explain it.

Sort deposits by amount and work down from the largest. Large unexplained deposits are the items preparers ask about most, so having an answer ready saves a round of emails.

Step 8: build the summary

A pivot table from your combined table:

• Rows: Category.
• Columns: optionally Month or Quarter.
• Values: Sum of Amount.
• Filters: exclude Transfer; show Business only.

Add a short cover note listing:

• Every account included, with last four digits.
• Anything missing (a statement you couldn't get, a month with incomplete receipts).
• The items in "Preparer review," with your notes.
• Any assumptions you made.

Step 9: hand over the right files

Give your preparer:

1. The summary (pivot) and the full transaction table, in Excel.
2. The original PDF statements, organized by account and month.
3. Processor and platform annual reports.
4. Tax forms you received (1099s or your country's equivalents, loan interest statements, and so on).
5. Your cover note.

Ask your preparer how they'd like to receive files. Many have secure client portals; use them rather than email where possible.

Landlords with a rental property or two

If you own a rental, the same process applies with a few rental-specific twists. Ideally, rent comes into and expenses go out of a dedicated account; if not, mark every rental transaction in your shared accounts.

Useful categories to discuss with your preparer include rent received, deposits held, repairs, maintenance, property management fees, insurance, property taxes, mortgage payments, utilities you pay, and advertising for tenants. Two items commonly need a professional's eye: security deposits (often not income when received, depending on how they're handled and returned) and mortgage payments, where the interest portion and the principal portion are treated differently. Your bank statement shows the total mortgage payment; the lender's year-end statement shows the split. Give your preparer the lender's statement as well.

If you have more than one property, add a Property column so each one can be summarized separately.

Households with more going on

Even without a business, statements help at tax time if you have:

• Side income, such as freelance gigs, sales on marketplaces or tutoring.
• Charitable donations made by card or bank transfer.
• Medical or childcare expenses that may be relevant where you live.
• Education costs.
• Home office expenses if you work from home for an employer or yourself.

The approach is the same in miniature: convert, tag transfers, mark the relevant transactions, and hand your preparer a short list with the PDFs. Whether any of these items affect your return depends on your jurisdiction and circumstances; your job is to make sure the preparer knows they exist.

Starting earlier next year

Most of the pain of tax-time organizing comes from doing twelve months at once. A light monthly routine makes February painless: convert the month's statements, tag transfers, categorize, and note anything unusual while you still remember it. Our expense tracking guide describes a system that takes about twenty minutes a month. By the end of the year, the summary is already built.

A worked example

A freelance photographer gets ready for her preparer in February.

• Accounts: one business checking, one personal checking (some business expenses slipped through), one credit card used for both, a payment processor.
• Collection: 14 statements for each bank account and the card (December through January), plus the processor's annual summary.
• Conversion: all statements convert and balance. One personal checking statement for July is missing; continuity check reveals it. She downloads it.
• Transfers: card payments, processor payouts and transfers from business to personal (owner draws) are tagged.
• Business/personal: on the shared card, 62% of transactions are personal. She marks each one.
• Categories: 19 business categories based on her preparer's organizer.
• Preparer review: a new camera body and lens, a car repair (she uses the car for shoots), and three payments to her brother for assisting at weddings.
• Income: client payments direct to checking, plus processor payouts. She includes the processor summary showing gross bookings, fees and refunds.

Her preparer receives a two-tab workbook, the PDFs and a one-page note. The follow-up questions fit in one email.

Common mistakes

Counting transfers as income. Tag them first.

Using net processor payouts as gross income. Provide the processor's summary.

Mixing business and personal without marking. Mark every line in shared accounts.

Silently deciding grey areas. Flag them for the preparer.

Missing accounts. Ask yourself where else business money went.

Not keeping the PDFs. The spreadsheet is your summary; the statements are the record.

Keeping a clean audit trail

If questions ever come up about your return, the ability to trace a number back to its source is what makes them quick to answer. Three habits help. Keep the Statement column populated on every row so each transaction points to a specific PDF. Don't edit original descriptions; add notes in a separate column instead. And save the version of the workbook you gave your preparer, unchanged, alongside the PDFs. If you keep working in the file afterward, save a copy under a new name so the handed-over version stays intact.

How long to keep the records

Retention requirements depend on where you live and your situation, and they can be longer than people assume, especially where assets or carryforwards are involved. Ask your preparer what applies to you. Keeping the PDF statements and your workbook together, organized by year, makes any retention period easy to meet.

Our take

Tax preparation goes faster and costs less when the preparer gets organized, verified information instead of raw piles. Bank statements already contain most of what's needed. Convert them, tag transfers, separate business from personal, flag the judgment calls, and explain your deposits. Leave the tax decisions to the professional, and give them clean data to make those decisions with.

Troubleshooting common tax-season problems

A statement is missing for one month. Download it now, or request it from the bank. A gap in January or December is especially awkward because it affects the year's totals.

Income on the statements doesn't match your 1099s or equivalent forms. Timing (a payment sent in December that arrived in January), processor fees, and income received into a different account are the usual reasons. List the differences for your preparer.

Business and personal mixed in one account. Tag each transaction as business or personal before handing anything over. It's the single most time-consuming thing for a preparer to untangle.

Large transfers you can't remember. Search both accounts for the matching amount. Most "mystery" transfers are moves between your own accounts.

Refunds and reimbursements. These aren't income. Tag them so they don't inflate your income totals.

A mini checklist to send your preparer

1. Statements for every account, January to December, every page.
2. A spreadsheet with all transactions, tagged business or personal.
3. Income summary by source.
4. Expense summary by category, for business or deductible items.
5. Notes on large or unusual transactions.
6. Processor reports, if you sell through one.

A second worked example: a side business

An employee with a weekend craft business sells through an online marketplace. Her bank statements show marketplace payouts, supply purchases and personal spending in one account. She converts the year's statements, tags payouts as business income, supplies and shipping as business expenses, and everything else as personal. She downloads the marketplace's annual sales report to show gross sales and fees. Her preparer gets a one-page summary and the supporting files, instead of a shoebox of PDFs. As always, what's deductible is the preparer's call; the bank data just makes the facts clear.

FAQ

What bank statements do I need for my tax preparer?

Typically all twelve months for every account used for business or income, plus the months before and after the tax year. Include credit cards and payment processor reports. Ask your preparer what they need for your situation.

Do I give my preparer the PDFs or a spreadsheet?

Both, if you can. A categorized spreadsheet saves time; the PDFs are the original records your preparer may want to check.

Are all deposits on my bank statement taxable income?

No. Transfers between your accounts, loan proceeds, owner contributions and supplier refunds are examples of deposits that usually aren't income. Explain each significant deposit and let your preparer decide.

How should I handle a shared business and personal card?

Mark each transaction as business or personal, add notes for anything unclear, and consider separate cards going forward.

Can bank statements replace receipts?

They show that a payment happened, but often not what was bought. Whether statements alone are sufficient depends on your situation and local rules, so ask your preparer. Keeping receipts for business expenses is a good practice.

Is this tax advice?

No. This is general information about organizing records. A qualified tax professional should advise on how specific items are treated.