Blog · Finance metrics and formulas · Banking
Compare business financial statements with tax-return schedules without confusing book income and taxable income. Follow a documented reconciliation, reproduce the spreadsheet formulas, and identify the questions a commercial credit reviewer should resolve.
Analyzing business financial statements and tax returns starts with a documented bridge between the same company's book income and its tax-return income for the same period. Match the reporting scope before comparing amounts, then explain every reconciling item from the supplied schedules. A lower tax figure does not, by itself, prove weaker operating performance.
For a commercial credit review, write down the legal entity, fiscal year, statement basis, return type, and whether each document is final or amended. A consolidated financial statement and a single-entity return can both be correct while covering different businesses. Resolve that scope difference before calculating a variance.
The example below uses a fictional US C corporation's completed annual statements and supplied Form 1120 schedules. Other business return types have different layouts; use their actual reconciliation rather than transferring these line references unchanged.
The IRS Form 1120 instructions describe Schedule L as balance sheets per books and Schedule M-1 as a reconciliation of book income to income per return. Some corporations instead supply Schedule M-3, subject to the applicable instructions. Request the reconciliation actually used with the return.
Keep operating performance analysis separate from the bridge. The monthly financial report template covers statement structure; this review explains why two reporting bases differ.
Use a spreadsheet with one row per adjustment. Retain the source filename, schedule reference, amount, sign, explanation, and reviewer status. Keep open questions visible rather than entering a balancing adjustment to make the total agree.
Reconciled return income = Book net income + Documented additions − Documented subtractions
Unexplained difference = Reconciled return income − Supplied return control amount
Positive adjustments increase the book starting figure toward the return basis; negative adjustments decrease it. This sign convention is for the bridge, so a positive number does not mean the borrower earned more cash.
Classify each item as permanent, timing, or unresolved based on the preparer's documentation. A timing item concerns recognition in different periods; keep its reversal support. A permanent item does not reverse merely because another reporting year arrives.
Check the accounting method as well. IRS Publication 538 explains that cash and accrual methods recognize income and expenses differently. If the supplied documents use different methods, obtain the documented conversion; do not assume receivables or payables can simply be added to income without reviewing the related movements.
Prairie Components Inc. supplies the following approved figures for the year ended December 31, 2025. Its preparer identifies the expenses and income below as already included in book net income. The return control is income before the net operating loss deduction and special deductions, matching the supplied reconciliation endpoint.
| Source row | Supplied amount (USD) | Supporting document |
|---|---|---|
| Book net income after federal income tax expense | 480,000 | Final income statement |
| Federal income tax expense in book income | 120,000 | Tax expense account schedule |
| Expenses identified as nondeductible | 18,000 | Preparer's permanent-difference schedule |
| Tax-exempt interest in book income | 12,000 | Interest reconciliation |
| Book depreciation expense | 90,000 | Book fixed-asset schedule |
| Tax depreciation deduction | 160,000 | Supplied tax depreciation schedule |
| Return income before specified deductions | 536,000 | Return reconciliation control |
All amounts are whole dollars. This example accepts the preparer's classifications; it does not determine deductibility or calculate a tax liability. In particular, the federal tax expense is a supplied book amount, not a tax rate applied by the reviewer.
Set up columns A through E as follows, with the first data row in row 2. A dash means the column is inapplicable for that row.
| A: Bridge line | B: Book input (USD) | C: Tax input (USD) | D: Signed amount (USD) | E: Running income (USD) |
|---|---|---|---|---|
| Starting book net income | 480,000 | — | 480,000 | 480,000 |
| Federal income tax expense | 120,000 | 0 | 120,000 | 600,000 |
| Nondeductible expenses | 18,000 | 0 | 18,000 | 618,000 |
| Tax-exempt interest | 12,000 | 0 | -12,000 | 606,000 |
| Depreciation difference | 90,000 | 160,000 | -70,000 | 536,000 |
In D2 enter =B2. In D3 enter this expense adjustment formula and copy it to D4:
=B3-C3
In D5, reverse the expense convention to remove interest income already included in the books:
=C5-B5
In D6, calculate the depreciation difference:
=B6-C6
For the running total, enter =D2 in E2. In E3 enter the formula below and fill it through E6:
=SUM($D$2:D3)
The depreciation adjustment is 90,000 − 160,000 = -70,000. Total additions are 120,000 + 18,000 = $138,000; total subtractions are 12,000 + 70,000 = $82,000. The net adjustment is $56,000, and 480,000 + 56,000 = $536,000.
Put the supplied return control of 536000 in H2. The following independent total and residual checks should produce $536,000 and zero respectively:
=SUM(D2:D6)
=E6-H2
A zero residual proves arithmetic agreement with the selected endpoint. It does not prove that a classification is correct or that every supporting document is complete. Trace the starting figure to the final statements and the control figure to the exact return line.
The credit reviewer can now explain the gap: documented book-to-tax items account for the entire $56,000 difference. Whether any adjustment belongs in a separate repayment-capacity calculation depends on the bank's underwriting policy and the supporting facts. Do not treat every tax add-back as recurring cash available to service debt.
For industry-specific statement questions, see analyzing construction company financial statements. For producing the underlying reporting pack, financial reporting software addresses the separate reporting workflow.
Bring a file containing the statement totals, return controls, and documented signed adjustments. Covirage maps the columns; its tools compute and check the reconciliation, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See Covirage for commercial banking for the banking context.
They can differ because book accounting and tax reporting recognize some income and expenses differently. Compare the specific return line with its book starting point and reconciliation schedules. A supported difference can be appropriate even when the amounts are materially different.
Request the financial statements, corresponding business return, applicable book-to-tax reconciliation, and supporting schedules for material differences. Confirm the entity, period, reporting basis, and document version. Ask the borrower or preparer to explain unresolved items before relying on the comparison.
It explains differences between reported income bases. It does not by itself measure cash available for debt service. The reviewer still needs cash flow, debt obligations, distributions, and the bank's approved underwriting definitions to assess repayment capacity.