Divorce financial disclosure: three years of bank statements

Three years of statements for a current account, a joint account, a savings account and a credit card comes to well over a hundred separate statement documents. Your lawyer has asked for all of them. The financial schedule you also have to complete asks for something entirely different: income for the year, average monthly outgoings, the balance on a stated date, money moved between accounts. Nobody fills in that form by reading a hundred documents in order and keeping a running total in their head.

So the honest answer to whether divorce financial disclosure needs bank statements in a spreadsheet comes in two parts. The disclosure itself normally wants the statement documents, exactly as the bank issued them. The spreadsheet is not the disclosure. It is how you and your lawyer read what you are about to disclose, and how you produce figures that will still stand up when the other side checks them against the same documents.

Two different things travel under the word disclosure

One is the production of documents. What that has to cover, which accounts, how far back, in what form, is set by the order or the rules in force in your case, and those differ by country, state or province and sometimes by the individual court. Some regimes prescribe a form, a period and the exact accounts; others leave more to the parties. What disclosure is generally trying to establish is the same wherever you are: a full and accurate picture of your financial position, produced in a form the other side can test. Ask your lawyer what your order requires, and follow that over any general description, this one included.

Within whatever scope applies, a partial document is the thing to avoid. A statement handed over with pages removed invites an argument about what was on them, and pages carrying no transactions, the summary page and the small print at the back cost nothing to include.

Alongside the documents sits a schedule or affidavit of means. It is a form, and it wants figures: income for the year, monthly spending, the balance on each account at a stated date, assets and liabilities. Those figures have to survive being checked against the documents you just handed over, because checking them is the first thing the other side's lawyer will do.

Producing the documents does not produce those figures. Nothing does except working them out, and that is the job a converted workbook takes on.

What the schedule asks that a statement cannot answer

A statement reports one account, one month, in the order things happened. The schedule asks questions that cut across months and across accounts.

• Income for the year from a named source. Twenty-four salary deposits of 3,250.00 come to 78,000.00. Four freelance deposits of 1,200.00, 1,750.00, 900.00 and 1,550.00 add 5,400.00. The figure the schedule wants is 83,400.00, and it appears on no single statement.
• Average monthly spending, by category. Thirty-six months of grocery, fuel and childcare entries have to be grouped before they can be averaged, which means every row needs to be sortable and filterable rather than printed.
• Movements between your own accounts. A 4,000.00 debit on the current account and a 4,000.00 credit on the savings account are one movement. Counted separately they inflate both your outgoings and your income, and a schedule built that way falls apart the moment anyone traces the transfers between accounts.
• A balance on a specific date that falls mid-statement, which means reading the running balance on the right line rather than the closing figure on the front page.

Every one of these is a query over rows. Rows are what a conversion produces.

Checking the set before it leaves your hands

Before anyone reads a figure, a converted set lets you test whether the run hangs together. Statements chain: the closing balance of one month is the opening balance of the next for the same account.

Take an account ending 4471:

January closes at 3,947.15 and February opens at 3,947.15. February closes at 5,120.88 and March opens there. The chain holds across all four months, which tells you the statements you are holding join up. If April had opened at 4,908.71 instead of 4,663.02, something between March and April would be unaccounted for, and you would know to ask the bank for it before disclosure rather than after opposing counsel spots the gap.

Be exact about what that does not tell you. A closing-to-opening chain is strong evidence of continuity across the statements you have. It is not proof of completeness. It cannot show that a statement was never issued for a period you never obtained, and a quiet month whose closing balance equals its opening balance chains cleanly onto a neighbour that is not really its neighbour. So read the period printed on the front of each statement as well, and confirm the periods form an unbroken calendar with no gap between one period's end and the next period's start, across the whole disclosure period. Running both checks across three years and four accounts by eye is the part that goes wrong; running them over converted rows is arithmetic and a sort.

Converting three years without losing the trail

1. 1

   Collect every account, not just the busy ones

   Include dormant accounts, closed accounts, joint accounts and credit cards. An account you forgot is the one you will be asked about.
2. 2

   Download complete statement documents

   Take the full statement for each period rather than a filtered transaction export, so the period dates and the opening and closing balances the checks depend on are present.
3. 3

   Convert each statement to rows

   Run the statement documents through conversion so every month lands with the same columns: date, description, debit, credit, running balance, and an account identifier. Converting a batch this way is the same discipline as converting a year of statements into one spreadsheet.
4. 4

   Verify each month against its own document

   Confirm the converted closing balance matches the figure printed on the source statement, then check every row rather than stopping there: each recalculated running balance has to equal the balance printed beside that row. The closing figure on its own can be right while the rows underneath it are not, because a line lost from one month and a line of the same value duplicated in another cancel inside it. The row-level version puts a misread digit on a named line, which is the form your answer has to take if the entry is ever put to you. It reads no dates and no descriptions, so sample those fields against the pages yourself.
5. 5

   Chain the months, then check the calendar

   Check closing to opening across every consecutive pair, per account, and confirm the statement periods run end to end with no gap. Only then start categorising.
6. 6

   File the workbook with the originals

   Store each converted file next to the statement document it came from, named so the pairing is obvious to someone who has never seen your folders.

What the spreadsheet is, and what it is not

The converted workbook is a derivative. The statement document is the record. That distinction matters more in a family case than almost anywhere else, because disclosure is adversarial and the other side is entitled to test what you produced. The same rule governs financial records produced in litigation discovery: the original file stays untouched, the derived spreadsheet carries the analysis, and both are retained.

That has consequences you have to live with from the first file onwards.

• Never edit the source. If a converted row needs correcting, correct it in the workbook and note that you did. Editing the statement document itself is the one move that turns a formatting problem into a credibility problem.
• Keep a record of how the workbook was made. Which files went in, what produced the rows, and which rows you touched by hand. If the accuracy of your figures is questioned, the answer is a method someone else can repeat, which is the substance of keeping a converted record defensible.
• Do not treat a category label as a fact about the payment. A row labelled "childcare" is your characterisation of a bank entry. A statement proves that money moved on a date to a named counterparty; it does not prove what the money was for. Where purpose matters, the supporting invoice or receipt does the work, not the row.

The parts of this that a converted file will not solve

Cash is invisible. Money withdrawn at an ATM and spent in cash appears once, as a withdrawal, and the statement has nothing further to say about it. Payments made from an account you do not hold, on a card in someone else's name, or through a payment platform that settles in batches will not resolve into individual transactions on the bank record either. A platform payout of 2,140.00 covering nine separate sales appears as one line, and the breakdown lives in the platform's own report.

Those are limits of the underlying record rather than of the conversion, and they are worth flagging to your lawyer early. What the converted set does give you is an arithmetically checked spine for every account you have statements for, ready to be queried and cross-referenced. Everything else in the disclosure hangs off that spine, and building it correctly at the start is cheaper than rebuilding it after a figure has been challenged.