Lifestyle Analysis in Divorce Cases From PDF Bank Statements

Convert a PDF bank statement to a QuickBooks file

Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.

A lifestyle analysis in a divorce case totals what the household actually spent, by category and by month, over a look back period before separation, usually from every bank account and credit card that paid household bills. The reliable way to build one from PDF statements is to convert each statement to a .qbo file, load all accounts into one QuickBooks file, remove the double counting between accounts, and report the remaining spending by category as a monthly average.

Below is a full worked example with two years of statements from five accounts, the adjustments that separate a defensible figure from an inflated one, and what the conversion step has to get right. If the production is already on your desk, the converter on our PDF to QBO page for forensic accountants takes the first statement now.

Why the statements carry the case

Support arguments turn on the marital standard of living, and memories of that standard differ sharply between spouses. One remembers modest groceries and a single vacation a year, the other remembers weekly dinners out and a club membership. Statements settle the argument because a bank produced them, not either party. A lifestyle analysis is the schedule that turns several hundred pages of statements into a handful of numbers a judge or mediator can use.

Practitioners commonly look back two or three years before separation, long enough to smooth out one unusual year and short enough to reflect the household as it was. That means every month of every account in the window: joint checking, any savings account, each credit card, and any business account that paid personal costs. A missing account is the most common reason a lifestyle figure is too low.

A worked lifestyle analysis from five accounts

Here is a couple with a joint checking account, a savings account, a Visa card, an Amex card, and a business checking account the husband controls. The look back is 24 months, so the production is 120 statements. The figures are an example, but every adjustment below is one that comes up in real matters.

Step one, raw outflows before adjustment

Source24 month totalNotes
Joint checking, all withdrawals$312,480.0024 converted statements
Visa card, all charges$86,940.0024 converted statements
Amex card, all charges$64,320.0024 converted statements
Business checking, personal items only$27,600.00Club dues, a family car lease, restaurant charges
Raw outflows$491,340.00

The savings account shows no outflows to the household in this example, only transfers in from checking, so it adds nothing on this side. It still has to be converted, because those transfers are what prove the checking withdrawals were saved rather than spent.

Step two, take out what is not spending

AdjustmentAmountWhy it comes out
Card payments from checking($150,000.00)The charges are already counted on the card statements
Transfers from checking to savings($24,000.00)Money saved, matched to deposits on the savings statements
Federal and state estimated tax payments($21,600.00)Income taxes are handled separately in support calculations
Roof replacement, one time($18,400.00)Nonrecurring, shown on its own line rather than averaged in
Total adjustments($214,000.00)

That leaves $277,340.00 of household spending over 24 months, or $11,555.83 a month. The card payment line is the one that matters most. The $150,000.00 of payments is made up of $86,100.00 to Visa and $63,900.00 to Amex, each payment matched to the credit on the card statement. Skip that step and the household appears to spend more than $17,800 a month, a figure the other side's expert will dismantle in minutes.

Step three, spending by category

Category24 month totalMonthly average
Mortgage and property tax$86,400.00$3,600.00
Children, tuition and activities$43,200.00$1,800.00
Vehicles, payments, lease, fuel, insurance$31,200.00$1,300.00
Groceries and household supplies$26,880.00$1,120.00
Travel and vacations$22,560.00$940.00
Health costs and insurance premiums$15,600.00$650.00
Dining out$14,640.00$610.00
Utilities and phones$12,960.00$540.00
Clothing and personal care$9,840.00$410.00
Club membership and recreation$7,200.00$300.00
Other, including ATM cash$6,860.00$285.83
Total household spending$277,340.00$11,555.83

Of that total, $27,600.00 came through the business account: the $7,200.00 club line, $14,400.00 of the vehicle line for the family car lease, and $6,000.00 of the dining line. Those are $1,150.00 a month of lifestyle that would vanish from a schedule built only from the joint accounts. Finding them is often the single most valuable result of the whole exercise, and it only works when the business statements sit in the same file as the personal ones.

Building it in QuickBooks from the PDFs

A spreadsheet works for one account and falls apart at five, because matching transfers and card payments across accounts by hand is where hours and errors pile up. A QuickBooks file built for the matter does the matching for you.

  1. Index the production. List every account and every month in the window, and mark the gaps. Ask for missing months before you start, not after the report is drafted.
  2. Convert each statement. Upload each PDF and check that the converted rows add up to the closing balance printed on the statement, then download the .qbo file. Each month's opening balance should equal the prior month's close.
  3. One QuickBooks account per real account. Create a bank register for each checking and savings account and a credit card account for each card, with an opening balance as of the day before the first statement. Import each file into its own account.
  4. Match transfers and card payments. Record each card payment as a transfer from checking to the card account and each savings deposit as a transfer from checking. Matched pairs drop out of spending automatically.
  5. Code everything else to a lifestyle category. Use a short category list like the one above and bank rules for recurring payees. Flag business account items you treat as personal with a class so the schedule can show them separately.
  6. Run the report. A profit and loss by month, or an expense report by category over the 24 months, is your schedule. Divide by the number of months for the averages.

Productions often mix downloaded PDFs with photocopies. The scanned statement converter handles the copies, and the batch converter page covers working through a hundred or more files without merging them.

Mistakes that inflate or shrink the number

  • Counting card spending twice. Charges on the card plus the payment from checking. This is the largest and most common error.
  • Treating transfers as spending. Money moved to savings or a brokerage account was not consumed. Match every transfer to its deposit.
  • Averaging in one time costs. A roof, a wedding or a legal retainer distorts the monthly figure. Show them separately and let the attorney argue whether they recur.
  • Ignoring the business account. Personal costs paid by a closely held business are part of the lifestyle, and leaving them out understates the standard of living.
  • Losing the cash. ATM withdrawals leave no trail beyond the statement. Total them and present them as cash, with no assumed use.
  • Typos in the source rows. One misread amount found on cross examination casts doubt on every other line. A per statement balance check is the defense.

Brokerage statements deserve a note of their own. A lifestyle analysis tracks spending, but brokerage accounts show where savings went, and a sudden concentrated position in a single stock can raise questions about hidden value. When a ticker on the statement means nothing to anyone in the room, a structured research summary of that company is a fast way to understand what the position is before deciding whether a valuation expert is needed.

What the conversion step has to get right

RequirementWhy it matters in a lifestyle analysis
Closing balance check on every statementProves no row was dropped or misread before the numbers reach your report
Bank and credit card statementsCards usually carry most discretionary spending
Scanned and photocopied PDFsProductions are rarely all clean downloads
Original dates, payees and amountsEach line on the schedule must point back to a statement
QBO output for QuickBooks Online or DesktopLets transfers and card payments match across accounts

On our plans one statement PDF is one document. The 120 statements in this example fit one month of Plus, 200 documents for $149, or three months of Starter at 50 a month for $147. Larger matters with several years and business accounts are covered on the forensic accountants page, and current terms are on the pricing page. Against roughly 27 hours of keying 120 statements at 40 lines each, the conversion is a small line on the invoice.

When the schedule goes to court as a summary of voluminous records, keep the PDFs and the converted files together so the underlying statements can be produced on request. The AICPA's forensic and valuation services resources are a good reference for documentation standards in litigation work. If the same matter raises questions about unreported income, the deposit side is covered in our guide to bank deposit analysis from PDF statements.

Frequently asked questions

How far back does a lifestyle analysis go in a divorce?

Usually two or three years before the date of separation. That period is long enough to smooth out one unusual year and recent enough to reflect how the household actually lived. The attorney sets the window, and the expert requests every account statement covering it, including cards and any business account paying personal costs.

Who prepares a lifestyle analysis?

Typically a forensic accountant or a divorce financial analyst retained by one party or jointly. They collect the statements produced in discovery, categorize every transaction, remove transfers and double counting, and present monthly averages by category. The analysis is often used in mediation and can be presented in court as expert evidence.

How much does a forensic accountant cost for a divorce?

Most bill hourly, so cost tracks the volume of records and the number of questions. Data entry from statements is often the largest block of hours in a lifestyle analysis. Converting statements automatically instead of keying them cuts that block sharply, which leaves more of the retainer for analysis and testimony.

Can a lifestyle analysis find hidden income?

It can point to it. When documented spending clearly exceeds reported income and there is no debt or savings drawdown to explain the gap, money is coming from somewhere. That finding usually leads to a deposit analysis of every account to identify the source.

Skip the manual entry

Upload a PDF bank statement and get a QBO or IIF file ready to import into QuickBooks.

Convert a Statement