General Ledger + Converter in one subscription.

See pricing
Skip to content
  1. Home
  2. AI bookkeeping
  3. Year-end bank statement organization

GUIDE · YEAR-END

Organize a year of bank statements,
with no month missing and nothing to explain.

To organize bank statements for year-end, download every monthly PDF for every account, name each file year-month-account so they sort, then check that each statement opens at last month’s closing balance. A break means a missing month. Add January’s card statement if its cycle crosses December 31. ZeraBooks AI bookkeeping flags those gaps automatically.

7-day trial · card required, nothing charged for 7 days · then $79/month billed annually or $149 monthly

The Reconciliations timeline: one row per account and one dot per month, showing months that tie, months that need a look, coverage gaps and finalized months.

NAME THE FILES

How should you name bank statement files?

Banks name downloads things like “Statement_0412.pdf”, which tells nobody anything. Rename each file so a folder sorts itself in date order and the account is obvious:

PartWhyExample
Year and month first, YYYY-MMSorts by date in any folder or email2026-03
Account type and last four digitsTwo checking accounts at one bank stay apartChecking 2051
Bank nameHelps when the accountant sees several banksHarbor Bank
Whole file nameOne statement, one file2026-03 Checking 2051 Harbor Bank.pdf

Keep one folder per account and one subfolder per year. Don’t merge twelve PDFs into one file: a single missing month is easy to spot in a list of twelve files and almost impossible inside a 60-page PDF. Card statements follow the same rule, named by the month the statement closes.

We set you up and catch up your past months for free. Then ZeraBooks keeps your books done.

WORKED EXAMPLE

How do you check for missing bank statements?

Use the balance chain: every statement’s opening balance must equal the previous statement’s closing balance. Marigold Yoga Studio is a fictional business. Here is its 2026 checking folder with the two balances off each PDF:

FileOpeningClosingChain
2026-01 Checking 205114,206.4015,118.75Starts the year
2026-02 Checking 205115,118.7513,902.10Holds
2026-03 Checking 205113,902.1016,447.85Holds
2026-04 Checking 205116,447.8517,030.20Holds
2026-05 Checking 205117,030.2015,876.45Holds
2026-06 Checking 205115,876.4518,214.90Holds
2026-07 Checking 205118,214.9019,602.35Holds
2026-09 Checking 205118,955.6020,381.05Breaks: July closed 19,602.35
2026-10 Checking 205120,381.0521,140.70Holds
2026-11 Checking 205121,140.7020,512.95Holds
2026-12 Checking 205120,512.9522,684.30Holds
Year (with August added)14,206.4022,684.30Net 8,477.90

Eleven files, and the break gives the gap away: September opens at 18,955.60 but July closed at 19,602.35, so 18,955.60 − 19,602.35 = −646.75 happened in a month nobody has. That is August. Once the August PDF is downloaded, it should open at 19,602.35 and close at 18,955.60. Counting files would have found this too; the chain also catches a file saved under the wrong month or a statement from the wrong account.

WHAT GETS MISSED

Which year-end statements do people forget?

The same handful, every January.

  • The card statement that crosses December 31

    Marigold’s card statement closes on the 18th. Charges from December 19 to 31 are on the statement that closes January 18, 2027, so that one belongs in the 2026 set.

  • Accounts opened or closed during the year

    A savings account closed in May still needs January to May. Its last statement should show a zero closing balance and the transfer out.

  • Accounts nobody thinks of as banks

    PayPal, payment processor balances, a loan’s year-end statement showing interest paid, and any business card in an employee’s name.

  • Older months that left online banking

    Most U.S. banks keep 2 to 7 years of statements online and card issuers often fewer. Download the year now rather than when your accountant asks in three years.

  • The CSV instead of the statement

    An activity export usually has no opening or closing balance, so it can’t prove anything is missing. Send the PDF statements.

HOW LONG TO KEEP THEM

How long should you keep bank statements for taxes?

Bank statements support the figures on your return, so they follow the tax record rules. Checked October 22, 2026 on irs.gov and canada.ca:

SituationIRS (U.S.)CRA (Canada)
Usual rule3 years, when none of the cases below apply6 years from the end of the last tax year they relate to
Return filed late6 years from the date the return was filed
Income left off over 25% of gross6 years
Bad debt or worthless securities claimed7 years
Employment tax recordsAt least 4 years after the tax is due or paid, whichever is later
No return filed, or a fraudulent oneKeep indefinitely
Destroying them earlyOnly with written CRA permission (Form T137 or a written request)

A simple habit: keep each year’s statements for seven years after the return is filed. That covers every IRS period above except property records (kept until the limitation period ends for the year you sell the property) and the indefinite cases, and it covers the CRA’s usual six years. CRA records generally have to be kept in Canada. This is a summary, not tax advice; your preparer decides what applies to you.

WHAT TO SEND

What bank statements does an accountant need at year-end?

Send this as one shared folder, or one email per account, in January.

  1. 1

    Every statement for every account

    Twelve per bank account and card, named and sorted, plus the January statements for cycles that cross December 31.

  2. 2

    A one-line list of accounts

    Bank, type, last four digits, opened or closed dates. The accountant ticks it against last year’s.

  3. 3

    The December 31 balance for each

    From the statements. If your books show a different cash balance, say so; the difference is the year-end reconciliation, not a mystery.

  4. 4

    Outstanding checks and deposits at year-end

    Checks written in December that cleared in January, and late-December deposits that landed after the 31st.

  5. 5

    Loan and line of credit year-end statements

    They show the principal left and the interest paid, which the books need to split.

  6. 6

    Anything odd, in a sentence

    A refund that went to a personal account, a transfer between businesses, a bounced payment. Two lines from you save an email chain later.

WITH ZERABOOKS

Let the books find the missing month.

Doing this by hand once a year is fine. Doing it every month is what keeps January short.

THE GAP CHECK, AUTOMATIC

A warning where a month is missing.

In ZeraBooks every uploaded statement is checked against the one before it. When there is no statement for a month between two months that are covered, Reconciliations shows an orange warning triangle on that month with an Upload statement button, so August is caught in September instead of in January. Each month that ties also has the ledger agreeing with the closing balance. More on bank reconciliation software.

How reconciliation works
The Reconciliations timeline: one row per account and one dot per month, showing months that tie, months that need a look, coverage gaps and finalized months.

OR HAND IT OVER

Send the folder; get a finished year back.

If you’d rather not do the year at all, ZeraBooks year-end bookkeeping takes the statements, reconciles every account to December and hands your accountant a trial balance. A year that was never kept is catch-up bookkeeping, quoted on its own.

The upload portal after a client sent more than a year of bank and card statements, bills and invoices at once, every file marked Received.

QUESTIONS

Year-end bank statement organization: common questions

Ask Damin directly
What if a month is missing at year end?

The balances give it away: see how to find a missing bank statement.

Should I keep paper or PDF bank statements?

PDFs from the bank are fine and easier to search. Keep them in two places, such as your computer and a cloud folder. In Canada, the CRA generally wants records kept in Canada and only allows electronic records held abroad with permission. How long to keep them is covered in how long to keep bank statements.

Can I combine a year of statements into one spreadsheet?

Yes, for analysis, but keep the PDFs too. A converted spreadsheet is a copy; the statement is the record. See combine bank statements for the month-to-month check on a combined file.

What if the bank no longer has an old statement online?

Ask the bank for a copy of the statement itself. Don’t rebuild the month from a CSV export, which usually has no balances to prove it.

Do I need statements for accounts with no activity?

Yes. A statement with no transactions still proves the balance didn’t change, and the chain check needs it.

Does ZeraBooks keep my statements for seven years?

Keep your own copy of every statement. ZeraBooks uses uploaded statements to keep the books, but your retention obligations are yours, so a folder you control is the safe record.

How much does ZeraBooks cost?

The software is $79 a month billed annually or $149 monthly after a 7-day trial. See ZeraBooks pricing.

Damin Mutti, founder of ZeraBooks

About the author

Damin Mutti

Founder of ZeraBooks, Vancouver

Damin founded ZeraBooks in 2025 and still talks to the bookkeepers, firms and owners who use it every week. He writes about what he sees in their statements and ledgers, and every page here is checked against the live product before it goes up.

FREE SETUP + CATCH-UP

Upload the year’s statements.
See which month is missing.

ZeraBooks checks every statement against the one before it and against the ledger. 7-day trial, then $79 a month billed annually. Or have our bookkeeping services team organize the year and keep the books.

Book a call with Damin

Our founder. 30 minutes on Google Meet. Pick a time on the next screen.

About: Have us do your books