Blog · Finance metrics and formulas · Finance and FP&A teams
Reconcile income tax expense, deferred tax and current tax payable to recorded cash taxes paid. Follow a worked payable rollforward with spreadsheet formulas and a payment-register check.
Income tax paid on the cash flow statement under the indirect method comes from current tax expense and the movement in current tax balances, checked against recorded payments. Total income tax expense is the wrong starting amount until you separate deferred tax. The payable rollforward then explains why the expense and cash differ.
For a company with one current tax payable account and no other movements:
Current tax expense = Total income tax expense − Deferred tax expense
Net cash taxes paid = Current tax expense + Opening current tax payable − Closing current tax payable
A deferred tax benefit is negative in the first formula. Where the company has current tax receivables, acquisitions, currency movements or amounts recorded outside earnings, extend the rollforward instead of forcing those movements through cash paid.
The distinction follows the SEC's explanation of indirect cash-flow reporting: operating cash flow adjusts net income for noncash items and changes in operating assets and liabilities. The broader cash flow statement example sets out the full statement; this worksheet isolates the tax bridge.
Use the same reporting period and entity scope for the tax provision schedule, general ledger and bank-cleared payment register. You need total tax expense, its current and deferred components, opening and closing current tax balances, and each payment or refund with its posting reference.
Retain tax jurisdiction and currency in the source rows even if the reporting worksheet aggregates them. Income taxes need their own account mapping: payroll withholding, sales tax and property tax do not belong in this bridge. If the business has separate tax receivables, reconcile those accounts separately before combining their cash effects.
Payments need not follow the expense recognition date. The IRS's estimated-tax guidance explains that corporations generally make estimated payments when they expect tax to be due. A provision schedule measures accounting expense; a payment register records cash settling tax obligations.
Consider fictional US manufacturer Hawthorn Components for the year ended December 31, 2025. All figures below are USD, with no rounding. There are no acquisition, currency, receivable or other tax-account movements in this example.
Put the labels in column A and amounts in column B, with headers in row 1:
| Spreadsheet row | Worksheet line | Amount (USD) |
|---|---|---|
| 2 | Total income tax expense | 225,000 |
| 3 | Deferred tax expense | 45,000 |
| 4 | Current tax expense | 180,000 |
| 5 | Opening current tax payable | 60,000 |
| 6 | Closing current tax payable | 95,000 |
| 7 | Net cash taxes paid, derived | 145,000 |
| 8 | Cash refunds received | 10,000 |
| 9 | Gross tax payments, derived | 155,000 |
Enter these formulas:
B4 =B2-B3
B7 =B4+B5-B6
B9 =B7+B8
Current tax expense is 225,000 − 45,000 = $180,000. The payable rises by 95,000 − 60,000 = $35,000, so net cash taxes paid are 180,000 − 35,000 = $145,000. Gross payments are 145,000 + 10,000 = $155,000 because the company also received a refund.
For the separate treatment of the noncash component, see deferred tax on the cash flow statement. Do not substitute the change in the deferred tax balance for deferred expense without reconciling movements outside earnings.
Hawthorn's payment register has these cleared transactions. Enter payments as positive amounts and refunds in their own positive column.
| Register row | Transaction | Payments (USD) | Refunds (USD) |
|---|---|---|---|
| 2 | Federal estimated payments | 120,000 | 0 |
| 3 | State estimated payments | 35,000 | 0 |
| 4 | Prior-period tax refund | 0 | 10,000 |
| Total | 155,000 | 10,000 |
With that register on a sheet named Payments, and payment and refund amounts in columns C and D:
=SUM(Payments!C2:C4)-SUM(Payments!D2:D4)
The result is $145,000. Compare it with worksheet B7; the difference must be zero. The payable itself also has to close:
=B5+B4-SUM(Payments!C2:C4)+SUM(Payments!D2:D4)-B6
That returns zero: 60,000 + 180,000 − 155,000 + 10,000 − 95,000 = 0. Investigate a difference by transaction reference before adjusting any cash-flow line.
Suppose Hawthorn has pretax income of $900,000. Its tax-only bridge is:
| Step | Calculation | Amount (USD) |
|---|---|---|
| Pretax income | Supplied P&L amount | 900,000 |
| Income tax expense | Supplied provision | −225,000 |
| Net income | 900,000 − 225,000 | 675,000 |
| Deferred tax add-back | Noncash expense | 45,000 |
| Increase in tax payable | 95,000 − 60,000 | 35,000 |
| Subtotal before other operating adjustments | 675,000 + 45,000 + 35,000 | 755,000 |
The proof is 900,000 − 145,000 = $755,000. This is a tax-only subtotal, not total operating cash flow. Other noncash expenses and working-capital movements still belong in the full reconciliation.
The distinction is the same accrual-versus-cash timing issue that appears elsewhere in monthly reporting. Cash taxes paid may also appear as supplemental information; do not subtract that disclosed amount again after completing the indirect reconciliation.
Upload a file containing your provision schedule, current tax balance rollforward and payment register. Covirage maps the columns; its tools compute and check the supplied movements, while the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for finance teams for the reporting context.
An increase caused by current tax expense exceeding cash payments is added back in the indirect reconciliation. It means expense reduced net income before the associated cash left. Acquisition balances, currency changes and other noncash movements must be removed before applying that shortcut.
Deferred tax expense reflects tax effects recognized in a different accounting period from the related taxable amounts. It is not itself a cash payment. An indirect cash-flow reconciliation reverses the relevant noncash deferred tax expense or benefit included in net income.
Yes. Keep gross payments and refunds in separate columns, then calculate net cash taxes paid when that is the reporting basis. Match the refund to its tax receivable or payable account so that receiving it does not create an unexplained balance movement.