Source and Application of Funds Method: Build the Schedule in Excel From Bank Statement PDFs

A source and application analysis compares every dollar a taxpayer spent against every dollar they can show came from a known source. 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 both sides of the schedule trace to a printed line. Start free, no credit card.

Applications built from real spending
Sources traced to deposits and draws
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 source and application of funds method?

The source and application of funds method is an indirect way of proving income. It totals every application of funds during a year, meaning money spent, assets bought, and debts paid down, then totals every source of funds, meaning reported income, assets sold, loans taken, and documented nontaxable receipts. When applications exceed sources, the excess had to be funded by income that was not reported. The IRS describes it in IRM 4.10.4.5.3, and courts have upheld it under IRC 446. It is the mirror image of a cash-flow statement, and every line traces to a bank, brokerage, or loan statement, which is why the underlying work is a statement extraction.

Why the Schedule Is Mostly Statement Reading

The arithmetic is one subtraction. Assembling a complete list of what was spent and a defensible list of where the money came from is where the days go.

Applications Are Buried in Debits

The uses side is built from real outflows: card payments, checks, cash withdrawals, asset purchases, and loan principal. Reconstructing it means reading every debit across every account, not estimating.

Sources Have to Be Proven, Not Assumed

Every dollar on the sources side needs a document: a paycheck deposit, a loan draw, an asset sale, a gift. Anything you cannot tie to a statement line is treated as unreported income.

Transfers Look Like Both Sides

Money moved between a taxpayer own accounts is neither a source nor an application, but it appears as a debit in one account and a credit in another. Missing the match double counts the flow.

A Missing Statement Breaks the Total

The method depends on completeness. One account with a gap leaves either an application or a source understated, and the difference between the two sides becomes unreliable.

Asset and Loan Balances Move the Answer

An asset bought is an application; the same asset sold is a source. A new loan is a source; principal repaid is an application. Balance changes at each end of the year have to be read off the statements.

Consistency Across Accounts Is Hard by Hand

The schedule only works if every account is captured the same way for the same period. Retyping figures from a dozen statements rarely stays consistent enough to foot.

How BankXLSX Builds Both Sides of the Schedule

Upload the statements and get the structured rows a source and application analysis is built on.

Every Debit for the Uses Side

Withdrawals, card payments, checks, and cash come out as dated rows, so the applications total is built from actual spending rather than an estimate.

Every Credit for the Sources Side

Deposits, loan draws, and asset-sale proceeds land as dated rows, so each source is a statement line you can point to.

All Accounts, One Workbook

Bank, brokerage, and loan statements land with identical columns, so applications and sources stack into one sheet for the whole period.

Reads Scanned Statements

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

Transfers Easy to Match

Because dates, amounts, and descriptions stay intact, a debit in one account matches its credit in another so internal transfers can be netted out.

Sensitive Data Handled Carefully

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

Build a Source and Application Schedule in 3 Steps

Nothing to install and no credit card to start.

1

Convert Every Account for the Period

Upload bank, brokerage, and loan statements for each account across the whole year or years under review so no outflow or receipt is missed.

Tip: Capture loan statements too. Principal paid is an application and a new draw is a source, and both change the answer.

2

Total the Applications, Then the Sources

Sum every dollar spent, invested, or used to pay down debt on the uses side, then sum reported income, asset sales, loan proceeds, and documented nontaxable receipts on the sources side.

Tip: Net out transfers between the taxpayer own accounts before totaling either side, or the flow is counted twice.

3

Compare the Two Sides

Subtract total sources from total applications. A positive difference is spending the known sources do not explain, which the method treats as unreported income unless a nontaxable source accounts for it.

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

Who Uses the Source and Application Method

Anyone who has to test whether spending outran the income a taxpayer can prove.

Tax Attorneys

Rebuild the government schedule to find the source the agent left off, the double-counted transfer, or the nontaxable receipt that closes the gap.

Forensic Accountants

Show that lifestyle and purchases outran documented income in fraud, divorce, and partnership disputes, or prove they did not.

Criminal Tax Defense

Test a special agent expenditures case line by line, since an unproven application or an ignored source can undo the whole computation.

CPAs and EAs in Controversy

Check the examiner figures before conceding, or reconstruct income for a client whose records are incomplete.

Common Search Terms

source and application of funds method source and application of funds application of funds method expenditures method irs indirect method of proving income sources and uses of funds analysis unreported income expenditures

Transaction Types We Handle

Cash withdrawals and card payments
Checks written for expenses
Asset purchases and down payments
Loan principal repaid
Wage and business deposits
Loan and line of credit draws
Proceeds from asset sales
Gift and inheritance receipts

The source and application of funds formula

The method sets everything a taxpayer did with money against everything they can show funded it. If the uses are larger than the proven sources, the difference is treated as income that was left off the return.

SideItemWhere it comes from
ApplicationsPersonal living expensesCard, check, and cash outflows for the year.
ApplicationsIncreases in assetsProperty, vehicles, and investments bought.
ApplicationsDecreases in liabilitiesLoan and card principal paid down.
SourcesReported incomeWages and business receipts already declared.
SourcesDecreases in assetsProceeds from assets sold during the year.
SourcesIncreases in liabilities and nontaxable receiptsNew loans, gifts, inheritances, and loan draws.
ResultApplications minus sourcesA positive figure is unexplained, so it is treated as unreported income.

IRM 4.10.4.5.3 sets out the examiner version, and the courts have accepted it under IRC 446 in both civil and criminal cases. The theory is that money cannot be spent twice: whatever left the accounts had to come from somewhere, and any use the known sources do not cover points to income that was not declared.

Source and application versus the other indirect methods

Examiners choose among four related tools depending on how the records fail. They often run more than one and reconcile the results.

MethodWhat it measuresBest fit
Source and applicationUses of funds against proven sourcesSpending outran documented income
Net worthChange in assets minus liabilitiesWealth grew faster than income
Bank depositsMoney flowing through accountsMost receipts passed through a bank
Cash-T and markupCash in against cash out, or cost grossed upCash business holding back receipts

The source and application method is close kin to the net worth method. Net worth looks at balances at two dates; source and application looks at the flows in between. They should reconcile, and an examiner who builds one often checks it against the other.

Where these cases are won and lost

The defense is almost always in the completeness of the sources side, not the arithmetic.

  • Unproven applications. An estimated living-expense figure inflates the uses side. Building it from actual withdrawals keeps the number defensible.
  • Missed sources. A loan draw, a gift, an inheritance, or an asset sale funds spending without being income. Each one you can document reduces the difference dollar for dollar.
  • Transfers counted twice. Money shuffled between the taxpayer own accounts is neither a source nor a use. Netting it out before totaling is essential.
  • Cash on hand at the start. A documented cash hoard held before the period is a source that funds later spending, the same base-year issue that decides net worth cases.

Where the schedule connects

Once the outflows and receipts are rows, the rest is ordinary spreadsheet work. Many engagements run this alongside the balance side, the net worth method, and reconcile the two. The deposit total often comes straight from a bank deposit analysis, and cash businesses pair it with a cash intensive business audit workup. If the matter is IRS collection or examination, the same data feeds the bank statement converter for tax resolution and Form 433. Start from the source documents with the bank statement converter, use running balance extraction for period tie-outs, and speed the build with transaction categorization.

After the schedule is built

Firms that run these engagements repeatedly automate the intake rather than the analysis. Once the two sides reconcile you can turn the figures 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 Source and Application Work

Every
debit available for the applications side
Every
credit traced for the sources side
Both
sides foot from the same statement data

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

Source and Application of Funds Method: Common Questions

It is an indirect method of proving income that totals every use of funds during a period, such as spending, asset purchases, and debt repayment, then totals every proven source, such as reported income, loans, and asset sales. When applications exceed sources, the unexplained excess is treated as income that was not reported.

The net worth method compares assets minus liabilities at two dates and measures the change. The source and application method looks at the flows in between, setting money spent against money proven to have come in. They measure the same thing from two angles and should reconcile, which is why examiners often build both.

Reported wages and business income, proceeds from selling an asset, new loan and line of credit draws, and documented nontaxable receipts such as gifts and inheritances all count as sources. Cash the taxpayer can prove they held before the period also counts. Anything you cannot tie to a document is not treated as a source.

A transfer between a taxpayer own accounts is neither a source nor an application. It shows up as a debit in one account and a credit in another, so if it is not matched and removed it inflates both sides of the schedule and distorts the difference. Netting transfers out is one of the first steps.

You need every bank, brokerage, credit card, and loan statement for the whole period, for every account the taxpayer controlled. The method depends on completeness, so a single missing month can understate an application or a source and make the comparison unreliable.

No. It converts statement PDFs into accurate Excel or CSV rows with dates, descriptions, amounts, and running balances so the applications and sources can be totaled and defended. Classifying each flow and reaching conclusions remains the work of the CPA, EA, or attorney.

Yes. The expenditures and source and application approach is one of the accepted methods of proof in criminal tax investigations, and convictions have been upheld on it. That is why proving every legitimate source and avoiding double-counted transfers is so central to the defense.

At least every year under examination, with every account captured for each year. Because the method sums flows rather than balances at a single date, you need continuous statement coverage across the period, plus documentation of any cash or assets held going into it.

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