Blog · Finance metrics and formulas · Finance and FP&A teams
Reconcile interest expense, accrued interest and cash payments under US reporting conventions. Work from a debt schedule and bank export, then check that the indirect cash-flow adjustment includes each movement once.
Interest payable on the cash flow statement under the indirect method is an operating accrual adjustment: add an increase and subtract a decrease, after removing movements unrelated to operating cash. Interest expense has already reduced net income, so the adjustment recognizes the difference between the expense and the amount actually paid.
Interest expense belongs to the period in which borrowing costs are recognized. Interest payable is the unpaid liability at a reporting date. Cash interest paid is the amount that left the bank, which can settle both current-period expense and an opening accrual.
US GAAP generally puts ordinary interest payments in operating activities. Principal repayments belong in financing activities; the fact that both amounts go to the same lender does not combine their classifications. ASC 230's operating cash-flow guidance, reproduced by Deloitte, identifies payments to lenders for interest as operating outflows. This walkthrough covers expensed interest on ordinary borrowings, without capitalized interest or unusual settlement terms.
The cash-flow statement example supplies the full statement layout. Here the job is narrower: prove the interest component before it enters that layout. The distinction between an expense and a payment also underlies accrual versus cash accounting.
Use the general ledger's interest expense and accrued-interest accounts, the debt schedule and the bank payment detail. Keep facility ID, posting date, payment date, document reference, currency and amount. Export opening and closing liabilities using the same account mapping.
Ask the controller which expense components never enter interest payable. Debt-issuance-cost amortization, for example, can be included in interest expense but credited to a separate debt-cost account. Isolate it before deriving cash payments. The deferred financing costs reconciliation covers that schedule in detail.
Use positive amounts for expenses, balances and payments in the workbook below. A positive payment becomes a negative outflow when placed on the cash-flow statement. Leave missing amounts unresolved until the schedule owner confirms them; a blank opening accrual is not evidence of a zero balance.
For this defined scope, with no acquisitions, currency effects, reclassifications or other noncash payable movements:
Cash interest paid = Interest expense - Noncash amortization included in expense + Opening interest payable - Closing interest payable
An illustrative US manufacturer, Cedar Assembly Inc., prepares its September 2026 close. All figures below are whole USD; no rounding is required. The noncash column contains only financing-cost amortization already included in interest expense.
| Borrowing (A) | Opening payable (USD, B) | Interest expense (USD, C) | Noncash amortization (USD, D) | Closing payable (USD, E) | Derived cash paid (USD, F) |
|---|---|---|---|---|---|
| Term loan | 18,000 | 90,000 | 6,000 | 25,000 | 77,000 |
| Revolver | 5,000 | 30,000 | 0 | 2,000 | 33,000 |
| Total | 23,000 | 120,000 | 6,000 | 27,000 | 110,000 |
With headers in row 1, enter this in F2 and fill down through F3 in Excel:
=C2-D2+B2-E2
The term loan produces 90,000 - 6,000 + 18,000 - 25,000 = $77,000. The revolver produces 30,000 - 0 + 5,000 - 2,000 = $33,000. The revolver's payable decreased, so its cash payment exceeds its expense.
Calculate the total independently:
=SUM(C2:C3)-SUM(D2:D3)+SUM(B2:B3)-SUM(E2:E3)
That result must equal =SUM(F2:F3). Agreement proves the summation, although it does not yet prove that the inputs match the bank.
Build a separate sheet named Payments with these columns. Each amount is the interest component of a settled payment, after separating any principal.
| Payment date (A) | Borrowing (B) | Category (C) | Payment (USD, D) |
|---|---|---|---|
| September 4, 2026 | Term loan | Interest | 30,000 |
| September 18, 2026 | Term loan | Interest | 47,000 |
| September 11, 2026 | Revolver | Interest | 18,000 |
| September 25, 2026 | Revolver | Interest | 15,000 |
In G2 on the debt summary, sum the bank rows for the borrowing in A2:
=SUMIFS(Payments!$D$2:$D$5,Payments!$B$2:$B$5,A2,Payments!$C$2:$C$5,"Interest")
Microsoft documents SUMIFS as adding amounts that meet multiple criteria. Here those criteria prevent another borrowing or a principal payment from entering the interest total. Covirage is not affiliated with Microsoft.
Fill G2 down to G3. Enter =F2-G2 in H2 and fill down. Both differences must be zero: the bank sums are $77,000 and $33,000, totaling $110,000. Investigate differences by document reference rather than inserting a balancing adjustment.
The liability provides a second proof: 23,000 + 120,000 - 6,000 - 110,000 = $27,000. This reconstructs the closing payable from the opening balance, accrual-generating expense and payments.
The following simplified bridge ignores income taxes and every other accrual. Its starting earnings amount is an illustrative input already equal to cash before interest.
| Bridge line | Calculation | Amount (USD) |
|---|---|---|
| Earnings and cash before interest | Input | 500,000 |
| Interest expense | From debt summary | -120,000 |
| Net income | 500,000 - 120,000 | 380,000 |
| Add noncash amortization | From debt summary | 6,000 |
| Add increase in interest payable | 27,000 - 23,000 | 4,000 |
| Operating cash after interest | 380,000 + 6,000 + 4,000 | 390,000 |
The direct check is 500,000 - 110,000 = $390,000. Do not subtract the $110,000 again underneath the indirect adjustments. Deloitte's discussion of supplemental disclosures explains why interest paid is also disclosed when using the indirect method; a disclosure is not another deduction.
Upload your debt schedule and ledger or bank export to Covirage; it maps the columns, and its tools compute and check the expense, payable and payment reconciliation using your established classifications. 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 wider reporting context.
It means some interest recognized as expense remains unpaid. Net income already includes that expense, so adding the operating increase in the payable removes its unpaid portion. The adjustment changes the reconciliation; it does not mean the company received cash.
Ordinary interest paid to lenders is generally an operating cash outflow under US GAAP, while loan principal repayments are financing outflows. Interest capitalized into productive assets requires separate consideration. Split principal and interest before mapping a combined bank payment.
No. When the reconciliation starts with net income after interest expense, the payable adjustment and relevant noncash adjustments already convert the expense to cash. Deducting the full cash payment again would count the interest outflow twice.