Net Worth Method of Proving Income: Build the Schedule in Excel From Bank Statement PDFs

A net worth computation stands or falls on the account data behind each asset and liability. BankXLSX converts years of bank, brokerage, and loan statement PDFs into Excel or CSV with date, description, amount, and running balance in their own columns, so every year-end balance and every personal expenditure traces back to a printed line. Start free, no credit card.

Year-end balances traced to statement rows
Living expenses pulled from real withdrawals
Batch several accounts and years at once

Last updated July 2026

PDF, JPG, PNG, BMP, HEIC, TIFF, MT940

Upload your bank statement

Extract:

What is the net worth method of proving income?

The net worth method is an indirect way of proving income used when a taxpayer has no adequate books. It measures the change in net worth over a year, then adds back nondeductible living expenses and subtracts nontaxable income. The formula is net worth at year end minus net worth at year start, plus nondeductible personal expenditures, minus nontaxable receipts, equals taxable income. The IRS sets it out in IRM 4.10.4.6.7, and its logic is that an unexplained increase in what you own, plus what you spent to live, has to have been funded by income. Every figure in the schedule traces to an account balance or a transaction, which is why the underlying work is a bank statement extraction.

Why the Net Worth Schedule Is Mostly Data Entry

The formula is one line of arithmetic. Building a defensible balance sheet for each year-end, and a personal living-expense figure that holds up, is where the days go.

Year-End Balances Live in PDFs

Each asset needs its December 31 balance for every year in the period. That balance sits on one statement page per account per year, and there can be a dozen accounts.

Living Expenses Come From Withdrawals

The personal expenditures line is built from real spending: card payments, checks, cash withdrawals, and transfers out. Reconstructing it means reading every debit, not guessing a number.

Loan Balances Move the Answer

Net worth is assets minus liabilities. Miss a mortgage or line of credit balance at year-end and the increase in net worth is overstated, which overstates income.

A Missing Statement Breaks a Year

If one account has a gap at a year boundary, that year-end column is incomplete and the whole comparison between two years is unreliable.

Nontaxable Sources Have to Be Traced

A gift, an inheritance, a loan draw, or a sold asset funds net worth without being income. Each has to be found in the statements and pulled out of the computation.

Consistency Across Years Is Hard by Hand

The same asset has to be valued the same way every year or the change is an artifact of the method, not real income. Retyped figures rarely stay consistent.

How BankXLSX Builds the Asset and Expense Side

Upload the statements and get the structured rows a net worth schedule is built on.

Year-End Balances You Can Point To

Each row keeps the printed running balance, so the December 31 figure for every account is a statement line, not a reconstruction.

Every Debit for Living Expenses

Withdrawals, card payments, checks, and cash come out as dated rows, so the personal expenditures line is built from actual spending.

All Accounts, One Workbook

Bank, brokerage, and loan statements land with identical columns, so assets and liabilities stack into one sheet per year-end.

Reads Scanned Statements

Older paper statements are usually image-only. OCR tuned for statement layouts reads them instead of returning blank rows.

Pivot Ready by Year

Dates parse as real dates, so a balance-by-year and expenses-by-year pivot is one table instead of a manual tally.

Sensitive Data Handled Carefully

256-bit encryption in transit, deletion on your schedule, and no reselling or sharing of uploaded financial data.

Build a Net Worth Computation in 3 Steps

Nothing to install and no credit card to start.

1

Convert Every Account, Every Year

Upload bank, brokerage, and loan statements for each account across the whole period, including the year before the first audit year so you have a starting point.

Tip: The base year sets the opening net worth. Without a clean starting balance the first year of income is unprovable.

2

Build a Balance Sheet per Year-End

Pull each account December 31 balance into an assets column and a liabilities column, then add non-account assets like real estate and vehicles at cost.

Tip: Value each asset the same way every year so the change reflects income, not a change in method.

3

Add Expenses, Remove Nontaxable Funds

Total personal living expenses from the withdrawals, then subtract gifts, inheritances, loan proceeds, and asset sales you can document, and compare the result to reported income.

Tip: Document the source of every nontaxable adjustment while the statement row is still in front of you.

Who Uses the Net Worth Method

Anyone who has to reconstruct income where the books are missing or not believed.

Tax Attorneys

Rebuild the government net worth computation to find the base-year error, the double-counted asset, or the nontaxable source the agent left out.

Forensic Accountants

Quantify hidden income in fraud, divorce, and shareholder disputes by showing that lifestyle and asset growth outran reported earnings.

Criminal Tax Defense

Test a special agent net worth case line by line, since the method is a staple of criminal tax proof and a base-year weakness can undo it.

CPAs and EAs in Controversy

Reconstruct income for a client with destroyed records, or check the examiner figures before conceding a deficiency.

Common Search Terms

net worth method net worth method of proving income net worth method irs net worth analysis method indirect method of proving income net worth computation unreported income net worth

Transaction Types We Handle

Year-end account balances
Loan and mortgage balances
Cash withdrawals and card payments
Checks written for living expenses
Transfers between owned accounts
Deposits from asset sales
Gift and inheritance receipts
Loan and line of credit draws

The net worth method formula

The computation itself is short. The work is assembling a believable balance sheet for two or more year-ends and a personal expenditures figure that traces to spending.

LineItemWhere it comes from
1Net worth at end of yearTotal assets minus total liabilities at December 31.
2Less net worth at start of yearThe same balance sheet one year earlier.
3Equals increase in net worthThe change the method has to explain.
4Plus nondeductible living expensesPersonal spending funded during the year.
5Less nontaxable receiptsGifts, inheritances, loan proceeds, nontaxable asset sales.
6Equals corrected taxable incomeCompared against income reported on the return.

IRM 4.10.4.6.7 describes the examiner version, and 4.10.4.6.7.3 gives the formula. The theory is simple: an increase in what you own, plus what you spent to live, minus money that came from a nontaxable source, must have been funded by income. The document you actually build is a balance sheet for each year-end and a schedule of personal expenditures, and both are spreadsheets of statement figures.

Net worth method versus the bank deposits method

These are the two indirect methods practitioners meet most often, and they answer different weaknesses in the records.

Net worth methodBank deposits method
Measures the change in assets less liabilitiesMeasures money flowing through the bank
Needs a clean base-year balance sheetNeeds every deposit for the period
Works when income was spent or invested, not bankedWorks when most income passed through accounts
Strong for asset accumulation and lifestyle casesStrong for service and cash-deposit businesses

Examiners often run both and reconcile them. If you are answering one, you usually have to be ready to answer the other, and both draw on the same converted statement data.

Where net worth cases are won and lost

The defense is almost always in the details of the schedule, not the arithmetic.

  • The base year. If opening net worth is understated, every later year of income is overstated. A cash hoard or an asset the agent missed at the start collapses the whole case.
  • Nontaxable sources. A documented gift, inheritance, loan draw, or sale of an asset funds net worth without being income. Each one you can prove comes straight off line 5.
  • Double counting. An asset bought with a bank withdrawal that is already reflected in a lower cash balance must not be added again, or growth is counted twice.
  • Living expenses. An inflated personal expenditure figure inflates income. Building it from actual withdrawals, rather than a national average, keeps it defensible.

Where the net worth schedule connects

Once the balances and expenses are rows, the rest is ordinary spreadsheet work. Many engagements run this alongside the deposit side, the bank deposit analysis, and reconcile the two. If the matter is an IRS collection or examination, the same data feeds the bank statement converter for tax resolution and Form 433. In fraud and marital cases, pair it with forensic accounting bank statement analysis and divorce financial disclosure. Start from the source documents with the bank statement converter, use running balance extraction for year-end tie-outs, and speed the spending build with transaction categorization.

After the computation is built

Firms that run these engagements repeatedly automate the intake rather than the analysis. Once the figures are reconciled you can turn them into presentation-ready financial statements without rekeying, and teams handling the rest of a client document set at volume extract it with enterprise document OCR.

Why Practitioners Use BankXLSX for Net Worth Work

Year-end
balances traced to a statement row
Every
debit available for the expense line
Balance
tie-out proves each year is complete

Security & Privacy

  • 256-bit encryption on every upload
  • Delete your files at any time
  • No reselling or sharing of your financial data
  • Runs in your browser, nothing to install

Net Worth Method: Common Questions

It is an indirect method that measures the change in a taxpayer net worth over a year, then adds nondeductible living expenses and subtracts nontaxable income. An unexplained increase in assets over liabilities, plus what was spent to live, is treated as income unless a nontaxable source explains it.

Net worth at year end minus net worth at year start equals the increase in net worth. Add nondeductible personal living expenses, then subtract nontaxable receipts such as gifts, inheritances, and loan proceeds. The result is corrected taxable income, compared against the income reported on the return.

The net worth method fits when income was spent or invested rather than run through a bank, or when assets grew faster than reported income. The bank deposits method fits when most receipts passed through accounts. Examiners frequently develop both and reconcile them.

The starting net worth sets the floor for every later year. If opening assets are understated, for example by missing a cash hoard or an existing account, the increase in net worth is overstated and so is income for every year that follows. Attacking the base year is a core defense.

Gifts, inheritances, life insurance proceeds, loan and line of credit draws, and the nontaxable portion of an asset sale all increase net worth or fund spending without being income. Each one you can document comes off the computation, so tracing them in the statements is the heart of the defense.

At least the base year plus each year under examination, so a three-year case needs four year-ends of data. Because balances at a single date drive the schedule, you need statements that cover every account at each December 31 in the period, plus the year before it starts.

No. It converts bank, brokerage, and loan statement PDFs into accurate Excel or CSV rows with dates, descriptions, amounts, and running balances so the balance sheets and expense schedules can be built and defended. Valuing assets, classifying receipts, and reaching conclusions remain the work of the CPA, EA, or attorney.

Yes. It is one of the classic methods of proof in criminal tax investigations, and courts have upheld convictions built on it. That is exactly why the base-year balance, the treatment of nontaxable sources, and the living-expense figure are litigated so closely.

Related Resources

Other Bank Statement Converters

ICICI Bank JPMorgan Chase Bank of America Citigroup Wells Fargo Goldman Sachs Morgan Stanley U.S. Bancorp PNC Financial Services Truist Capital One TD Bank Charles Schwab Fidelity Vanguard E*TRADE TD Ameritrade Bank of New York Mellon State Street BMO USA Ally Financial Regions Fifth Third Bank Huntington KeyBank Citizens Financial Group First Citizens Synchrony Financial M&T Bank First Horizon Cathay Bank USAA Navy Federal Comerica Zions Bank East West Bank First National of Nebraska Frost Bank BOK Financial Fulton Financial Associated Banc-Corp Valley National Wintrust Financial First Midwest Bancorp Commerce Bancshares UMB Financial Pinnacle Bank Webster Bank Cadence Bank Old National First Interstate BancSystem Umpqua Bank First Hawaiian Bank Prosperity Bank SouthState First Merchants First Bank Holding Glacier Bank First Financial Bancorp Independent Bank Columbia Banking System Western Alliance Pacific Premier Bancorp Bank OZK United Community Banks Customers Bank Texas Capital SVB Financial Group Signature Bank First Republic Bank New York Community Bancorp Sterling Bancorp First Bank Bank United First Commonwealth Financial Flagstar Bank Synovus Bank Santander Bank Commonwealth Bank (CommBank) ANZ Bank Westpac NAB ServisFirst Bancshares Renasant Corporation Simmons First National Trustmark Corporation First Busey Community Bank System First Mid Bancshares Ameris Bancorp Hancock Whitney First BanCorp Third Coast Bancshares Home Bancshares Byline Bancorp Simmons Bank United Bankshares Peoples United Financial American Express HSBC Bank USA

From the same family of tools