# Bank Statements to Excel for Family Law Disclosures

- Author: Schema Law (https://www.schemalaw.com/)
- Published: 2023-08-18T07:42:06Z
- Updated: 2026-10-11T19:22:20Z
- Category: Practice areas
- Canonical: https://www.schemalaw.com/blog/bank-statements-to-excel-for-family-law

> Get scanned bank statements into Excel for a family law disclosure: convert each statement, reconcile the balances, combine accounts and sort spending.

To get scanned bank statements into Excel for a family law matter, upload each statement, export a workbook, turn the amounts into numbers, and prove every statement by reconciling its opening balance, transactions and closing balance. Then combine the accounts on one sheet, with a source page recorded beside every row.

Do the reconciliation before any analysis. A spreadsheet of transactions that has not been tied to the bank's own balances is a list of guesses, and it will be read by someone whose job is to find the wrong one.

Once the balances reconcile, search the transaction descriptions for deposits that bear on child support and for transfers you are sorting for equitable distribution. Mark money moving between accounts the papers treat as community property. Open the statement image for each large amount before that row reaches a disclosure in the divorce.

## Why do family law matters need statements in a spreadsheet?

Family law matters need statements in a spreadsheet because the questions asked of them are arithmetic: what came in, what went out, to whom, and what was left on a given day. A stack of scanned pages can show one transaction. Only rows and columns can total a year of them.

Financial disclosure sits at the center of most divorce and support cases, and the forms ask for totals, not paper. California's Income and Expense Declaration, for example, is described by the state's courts as the form you use to [give your financial information to the court and to your spouse or domestic partner](https://selfhelp.courts.ca.gov/jcc-form/FL-150), which the court then uses in deciding support and fees. Other states have their own forms and their own rules on what must be exchanged and when. Check the requirements of your court.

Whatever the form, the figures on it have to come from somewhere, and bank statements are the usual source. With the transactions in a spreadsheet you can:

- average monthly income and spending over twelve months for a disclosure form;
- total what was paid for housing, childcare, insurance and schooling;
- find transfers to accounts that were not disclosed;
- list cash withdrawals and large or unusual payments in a period you choose;
- follow a deposit from one account into another;
- give a forensic accountant data in a form they can use on day one.

The statements you receive are rarely in a helpful form. A client brings paper from a drawer. The other side produces PDFs printed and rescanned. A bank answers a subpoena with images. None of it can be sorted or summed until it is converted.

## Converting scanned statements to Excel

Convert scanned statements to Excel by uploading one statement per file, checking the parsed pages, exporting the workbook, stacking the page tables into a single ledger, and converting the text to numbers and dates. Keep each statement separate until it has been reconciled.

1. **Sort and name the statements.** One file per statement period, named by institution, the last four digits of the account and the period end: `FirstNational_4471_2025-03.pdf`. Year first, so the files sort by date.
2. **List what you have.** Before converting, write down every month for every account and mark the gaps. A missing statement is a finding in its own right.
3. **Upload.** Schema Law accepts PDF, PNG or JPEG files up to 20 MB. Excel export is included on every plan. The free plan takes one document a day of up to three pages, so it can show you a workbook from a short statement but not from a year of them. A monthly statement often runs four to eight pages, so three years of one account can come to 150 to 300 pages, well within the 1,000 pages a month of the Solo plan. See the [pricing page](https://www.schemalaw.com/pricing) for the limits.
4. **Check the parsed pages.** Compare one transaction page with the scan. You want one transaction per row, with the date, description and amount each in its own column.
5. **Export Excel.** Each table found on each page becomes its own sheet, named with a running number and the page, such as `Table 3 (p2)`. A sheet called `Text` holds everything outside the tables, with page numbers.
6. **Stack the sheets.** A statement's transaction list continues from page to page, so it arrives as several sheets. Copy them, in page order, onto one sheet. Add a column for the page each row came from as you go. The guide to [tables that span several pages](https://www.schemalaw.com/blog/scanned-pdf-to-excel#tables-that-span-several-pages) covers repeated header rows and broken rows.
7. **Convert text to values.** Exported cells hold text exactly as it was read. Amounts need their dollar signs and commas removed and must become numbers. Dates must become real dates. Nothing will sum or sort correctly until this is done.

How the software finds a table on a page, and why columns sometimes shift, is explained in the guide to [getting a scanned PDF into Excel](https://www.schemalaw.com/blog/scanned-pdf-to-excel). If an accountant's software wants a flat file, the post on [converting a scanned PDF to CSV](https://www.schemalaw.com/blog/scanned-pdf-to-csv) covers that export.

### Rows that wrap

Watch for descriptions that run onto a second line. A card purchase may print the merchant on one line and the city and reference number on the next. In the export, the second line can appear as its own row with no date and no amount. Merge it into the row above. Do not delete it, because the reference may be what identifies the payee.

## What should you reconcile after conversion?

Reconcile each converted statement to the bank's own figures: the opening balance, plus deposits, less withdrawals, must equal the closing balance printed on the statement. If it does, every amount was read correctly or the errors cancel. If it does not, the size of the difference points to the error.

Run four tests, in this order.

| Test | How | What a failure means |
| --- | --- | --- |
| Balance equation | Opening balance + credits - debits = closing balance | A misread amount, a missing row, a duplicated row or a wrong sign |
| Summary totals | Your total deposits and total withdrawals against the statement's summary box | Tells you which side the error is on |
| Item counts | Your number of deposits, checks and withdrawals against the counts the statement prints, if it prints them | A row was dropped or split |
| Continuity | This statement's closing balance against the next statement's opening balance | A statement is missing, or pages are out of order |

A worked example with invented figures. The statement prints an opening balance of 4,218.37, total deposits of 9,650.00, total withdrawals of 8,904.12 and a closing balance of 4,964.25. Check: 4,218.37 plus 9,650.00 less 8,904.12 is 4,964.25, so the bank's own figures agree. Your converted rows give deposits of 9,650.00 and withdrawals of 8,254.12. The difference is 650.00.

Read the difference for clues before you search line by line.

- **A round or recognizable amount,** such as 650.00, suggests one missing row. Look for a withdrawal of that size on the scan.
- **A difference divisible by 9** often means two digits were swapped, such as 1,540 read as 1,450.
- **A difference that is a multiple of a power of ten,** such as 500.00 or 5,000.00, suggests one misread digit: a 3 read as an 8 shifts that place by 5.
- **A difference of exactly twice one transaction** means its sign is wrong, a deposit entered as a withdrawal or the reverse.
- **A very large difference** can mean a lost decimal point, where 1,250.00 became 125,000.

If the statement shows a running balance after each transaction, use it. Compute your own running balance down the sheet and find the first row where the two part. The error is on that row.

One warning: a statement that balances can still hold errors in dates, descriptions and check numbers, because none of those enter the arithmetic. Read those columns against the scan for every transaction you intend to rely on. The post on [why OCR output is full of errors](https://www.schemalaw.com/blog/why-is-ocr-output-full-of-errors) lists the character confusions to look for.

## Statements from different banks in one workbook

Put statements from different banks in one workbook by mapping each bank's layout to a single set of columns on a master sheet. Keep the reconciled sheet for each statement unchanged as the record. Banks lay the same facts out differently, and the master sheet is where those differences are removed.

The same raw-sheets-plus-master pattern serves any multi-source schedule. The guide to [putting medical bills from several providers in one workbook](https://www.schemalaw.com/blog/how-to-convert-medical-records-to-a-spreadsheet#bills-from-several-providers-in-one-workbook) uses it for damages.

A master layout that works for most matters:

| Column | Notes |
| --- | --- |
| Date | Full date with year |
| Institution | Bank or card issuer |
| Account | Last four digits only |
| Account holder | As printed on the statement |
| Description | As printed, unedited |
| Check no. | Text, blank if none |
| Amount | One signed column: deposits positive, withdrawals negative |
| Category | Filled in later |
| Source | File name and page |

Differences you will have to resolve:

- **One amount column or two.** Some banks print separate withdrawal and deposit columns. Others print one column and mark debits with a minus sign, parentheses or "DR". Convert all of them to one signed amount.
- **Dates without a year.** Many statements print only month and day. Add the year from the statement period. Take care with a period that runs from December into January.
- **Credit cards reverse the sense.** On a card statement, a purchase increases the balance and a payment reduces it. Decide how the master sheet treats cards, write the rule on a notes tab, and apply it to every card.
- **Sections in different orders.** Deposits, checks, card purchases and fees may be listed in separate blocks, each sorted by date. After combining, sort the master sheet by date.
- **Checks listed by number only.** A check row often shows a number and an amount with no payee. The payee is on the check image, covered below.

Keep the account number short in the workbook. The last four digits identify the account for your purposes. Check your own court's rules on redacting account numbers before anything is filed.

## Categorizing transactions for a disclosure

Categorize transactions by adding a category column to the master sheet, assigning each row to one of a short fixed list, and totalling by category and month with a pivot table. Choose categories that match the lines of the disclosure form your court uses, so that the totals carry straight across.

1. **Write the category list first.** Take it from the form: housing, utilities, food, childcare, education, health, insurance, transport, and so on. Add working categories the form lacks: transfer between own accounts, cash withdrawal, payment to a card, unknown.
2. **Assign by keyword, then by hand.** Sort or filter by description and label recurring payees in bulk. The mortgage servicer, the utility and the school will account for much of the list. Then go through what is left one row at a time.
3. **Leave "unknown" as unknown.** A row you cannot identify stays in that category with a note. Ask the client. Do not guess.
4. **Build the pivot.** Categories down the side, months across the top, sum of amount in the body. Divide each row total by the number of months for a monthly average.

Three points keep the totals from misleading.

- **Transfers between a party's own accounts are not income or spending.** Match each one to its other half in the other account, by date and amount, and exclude both from the totals. A transfer with no matching half is worth a closer look: it went to an account you do not have.
- **Card payments are not a category of spending.** The spending is on the card statement. If you have converted the card statements, exclude the payments from the bank account. If you have not, the payment is all you know, and the category should say so.
- **Cash is a category of its own.** A cash withdrawal says nothing about what the money bought.

Then use filters for the questions the case raises: every transaction over a threshold, every payment to a named person, everything in the six months before separation. How a court treats a given transfer or expense, and what counts as separate or shared property, depends on the law of your jurisdiction. The spreadsheet only arranges the facts. It does not characterize them, and this post does not give legal advice.

## Check images and deposit slips

Check images and deposit slips are pictures, not tables, and they hold the facts the transaction list leaves out: who a check was paid to, what the memo line says, who signed it, and what made up a deposit. Expect to read them by eye and type what you need.

Statements often print reduced images of cancelled checks, six or more to a page. Each is small, usually handwritten, and overprinted with processing marks. Recognition may return scraps of text from them, or nothing useful. Whether a table export includes anything from those pages depends on what the software finds there, so open the `Text` sheet and the scan together. The post on [what OCR can do with handwritten notes](https://www.schemalaw.com/blog/ocr-handwritten-notes) explains why handwriting at that size is unreliable.

A practical routine:

1. Filter the master sheet to rows with a check number.
2. For each, find the image by check number and amount.
3. Type the payee and memo into two added columns, reading from the image.
4. Record the page of the image in the source column, next to the page of the transaction line.

Do this for every check above an amount you choose, and for every check to a person instead of a business.

Deposits need similar work. A statement line reading "Deposit 6,400.00" does not say where the money came from. If the production includes deposit slips or images of the deposited items, list each item under the deposit with its payer and amount, and confirm that the items add up to the deposit. If it does not include them, note that the source of the deposit is unknown and consider asking for the deposit detail.

Other pages in a statement that will not convert into rows include the summary page, fee schedules, notices and the standard terms printed at the back. They need no conversion. Leave them in the scan.

Finally, bank statements carry account numbers, balances and a record of daily life, often for a person who is not your client. Before uploading them to any online service, consider your confidentiality duties and any protective order in the case. Schema Law's stated position is in the [commitments on its homepage](https://www.schemalaw.com/#security). The post on [whether it is safe to upload client documents to an OCR tool](https://www.schemalaw.com/blog/is-it-safe-to-upload-client-documents-to-an-ocr-tool) sets out questions to ask of any vendor.

## Try it on a real document

Upload a scanned PDF and export it as Word, a searchable PDF or plain text on the free plan. Your documents are never used to train an AI model. [Start free](https://www.schemalaw.com/api/auth/google)