Understand loan principal, interest and escrow in reports
Compare a mortgage payment with profit and loss, operating cash flow and the actual loan records without counting the same cost twice.
On this page
Check existing loan-payment activity before adding or correcting an entry. A report view does not change the original payment, move money or update the lender balance.
Step 1: Check each payment part
Compare the total paid with the lender statement. Principal repays the amount borrowed. Interest is a separate borrowing cost. A contribution to mortgage escrow funds money held for later bills; the later tax or insurance payment is another event. Keep fees and any extra principal separate according to the actual statement.
Step 2: Review the P&L source and scope
Choose Open Reports below, then Profit and loss (P&L). Review Dates and Property. To check the basis, choose Advanced options and inspect Report source. Payments made and posted deductions differs from Recorded ledger, including unpaid entries. Keep Output on Review on screen, then choose Run report when the dates, property and source are correct.
Step 3: Review cash flow with the intended CapEx choice
Return to Reports and choose Operating cash flow. Review its period and property, then read Cash flow details: Loan interest, Loan principal, Escrow contributions and Escrow withdrawals are separate lines. For report settings, choose More filters, set Report view to By property or By time period, check Date range and Portfolio/property, then set Include fixed asset purchases (CapEx) to the view you intend and choose Run.
Step 4: Trace a difference to its original record
Compare the same payment dates, property and report basis with the lender statement and original loan activity. Distinguish an escrow contribution from an actual bill paid by the servicer. If a component is missing or duplicated, review the detailed loan-payment or escrow guide before correcting it. Do not create another expense solely to make two report totals agree.
Escrow funding and an escrow-paid bill are different
Monthly escrow funding moves money into the lender-held balance. The amount later paid for insurance or property tax may differ from the monthly contribution. Use the servicer’s disbursement details to identify the actual payee, amount and date.
Before recording an escrow-paid bill, check whether it is already in the books. The dedicated escrow workflow records the expense and the reduction of escrow; the contribution itself is not a second tax or insurance expense. Review the linked escrow guide for the supported recording and journal/report boundaries.
When a report still looks wrong
Check the payment or posted date, the selected property, any book filter and the report source. A narrower property view can omit shared activity, and an unbooked bank import is different from an already recorded payment. Unpaid entries and noncash adjustments also differ between profit and cash-flow views.
Read the result or error before rerunning. Correct the filter or source that caused the mismatch; changing report options does not correct a saved payment. Use the loan-payment recovery guide for an actual reversal or corrected record. An accounting reversal does not undo a bank transfer.
Keep tax treatment separate from report presentation. Rental use, loan use and the timing or type of a cost can affect a deduction. Give the lender statement and supporting bills to the professional responsible for your return.
Check the result
- You can explain why a mortgage withdrawal differs from P&L expenses and locate the separate cash-flow components.
- You have compared consistent dates, property, source and CapEx settings before deciding whether an original record needs correction.
FAQs
Why are principal and escrow funding missing from ordinary P&L expenses?
Principal reduces debt, and escrow funding sets money aside for later bills. They are different from interest or a genuine tax or insurance expense. Review Cash flow details and the actual loan activity instead of changing them to expense categories to force a total.
Does changing a loan’s suggested payment update past transactions?
No. A suggestion is not a correction to posted history. Review each actual payment against the lender statement. Report filters also change only what is displayed; use the detailed recovery guide if an existing payment needs correction.