
The HELOC Payoff Spreadsheet, Decoded
For CPAs: the one page that answers the line-of-credit payoff spreadsheet, covering where the savings come from, the hidden risk and the deduction problem.
Get the guideA lender does not treat every write-off the same way. Some get added back; others quietly shrink the income a client can use. This map shows which is which, before the return is final.
Who it is for: CPAs. Keep it by your desk through filing season, so you can flag an issue in February instead of explaining it in June.
Prefer to talk? Call 732-686-9999
When we review a self-employed borrower, we start from the income left after the write-offs, then make two kinds of adjustments. The difference between them decides loans.
A few items surprise even experienced preparers, including how business mileage and pass-through income are read, and how a lighter recent year can outweigh a stronger one. You see the return a year before the lender does.
The honest part. General information on how lenders read a return, not tax advice.
Fill in the short form and choose email or text. We confirm your mobile number with a text code, then send you The Add-Back Map.
Tell us who you are and where to send it. We confirm your mobile number with a text code first.
This form needs JavaScript. You can also call us at 732-686-9999 and we will send the guide.
Thank you, .
Your guide is ready.
Open the guide (PDF) (opens in a new tab)
We are also sending it to you by email and by text message. It comes from Fidelity Residential. To make sure our emails reach you, add [email protected] to your contacts or safe senders. If you do not see it, check your spam or junk folder.
Questions? Call us at 732-686-9999.
Please call us at 732-686-9999 and we will send you The Add-Back Map.
We use these details to send what you asked for and to follow up about it. See our Privacy Policy.
Here is a plain summary of the main points in The Add-Back Map, written for CPAs who prepare returns for self-employed clients. It covers how a lender turns a return into the income it can count, which write-offs come back and which do not, and why the order of the years matters. It is general information on how lenders read a return, not advice on how to file. That judgment stays with you.
When a lender reviews a self-employed borrower on tax returns, it does not start from gross receipts. It starts from the income left after the write-offs, averages recent years, and then makes two kinds of adjustment. Some items are added back because no cash left the business. Others stay subtracted because the cash really was spent. The difference between the two can decide whether a file works.
Non-cash items generally come back into the income the lender counts. Depreciation is the familiar one, and depletion, amortization and casualty losses are treated the same way on most programs. They lower taxable income without reflecting cash the business spent to run that year, so the lender gives them back. A client with large depreciation may have more usable income than the bottom line of the return suggests.
Real cash that left the business generally stays out. That includes operating expenses that recur from year to year, and meals, travel and supplies that were actually paid for: anything that genuinely reduced cash flow. A large deduction of that kind lowers the tax bill and the income a lender can use at the same time, which is the trade a client should understand before the return is final.
Business mileage. When a client deducts business mileage at the standard rate, part of that rate stands for wear on the vehicle, a depreciation element. Lenders often add that part back, so heavy business mileage can raise the income the lender counts. Few clients know it is there.
Pass-through income. Profit from an S corporation or a partnership, reported on a K-1, is often usable only to the extent it was actually paid out to the borrower, or the business can show it has the cash to pay it. Earnings the client is taxed on but that stay in the business may not count toward the loan at all.
Lenders usually average recent years, so a strong year cannot fully make up for a weak one. And when the latest year is the lighter one, some programs use that lower figure on its own rather than the average. The order of a good year and a soft year can matter as much as the totals, and it is something you can see coming long before a lender does.
If a client may buy or refinance soon, the most useful step is to bring the lender in before the return is final, not after it is filed. You see the return long before the lender does. A short conversation in filing season can show how the return will read in a file while there is still time to understand the tradeoffs. The borderline items, such as a deduction that is a one-off for one client and a habit for another, are judgment calls. That is where your view and the lender’s are most useful together, and how to file always stays your decision.
An illustration, in words. In February, a business owner mentions to her CPA that she hopes to buy a home in the spring. Before the return is final, the CPA calls a loan officer, and together they look at how the draft return will read in a file: which deductions come back, which stay subtracted, and how this year compares with the last. One large recurring expense turns out to matter more than anyone expected, and the client learns it before she signs a purchase contract, not at the closing table. How to file is still the CPA’s call; the client simply has no surprise. An illustration only: not tax advice or a loan decision.
When a client’s returns show less than the business really earns, there are other ways to document income: bank statement loans, profit and loss loans prepared by a tax professional, and 1099 loans for contractors. Each page sets out how the income is counted and the documents to gather.
On a loan documented with tax returns, the lender starts from the income left after write-offs, averages recent years, then adds back non-cash items such as depreciation. Cash expenses that really left the business stay subtracted.
Generally non-cash items: depreciation, and on most programs depletion, amortization and casualty losses. Part of a business mileage deduction, the part that stands for wear on the vehicle, is often added back too. Real cash expenses stay subtracted.
Often only to the extent it was actually paid out to the borrower, or the business can show it has the cash to pay it. Earnings the owner is taxed on but that stay in the business may not count toward the loan.
Lenders usually average recent years, so a strong year cannot fully make up for a weak one. When the latest year is the lower one, some programs use that lower figure on its own rather than the average.
Before the return is final, if the client may buy or refinance soon. A lender can then show how the return will read in a file while there is still time to understand it. How to file stays the CPA’s decision; this is general information, not tax advice.

For CPAs: the one page that answers the line-of-credit payoff spreadsheet, covering where the savings come from, the hidden risk and the deduction problem.
Get the guide
Why investors stop scaling, how reserves stack across properties, and the three ways to own the next one.
Get the guide
What a lender counts as self-employed income, the documents that move a file, and the options most lenders never mention.
Get the guideSend them our way. We give clients a straight answer, and we keep you in the loop.
This page is general information, not a commitment to lend. Programs, terms and eligibility depend on credit, income, property and underwriting review and are subject to change without notice. The guide is general information for CPAs on how lenders read a return, not tax or individualized financial advice.
Last reviewed: