Troubleshoot a loan payment record
Check a missing suggestion or incorrect payment against the lender statement.
On this page
Have the payment date, total, lender statement and payment account. Check the original imported withdrawal and loan activity before adding another record.
Step 1: Compare the statement and activity
Open Accounting > Loans. Choose Payment activity for the loan, or View loan and review Loan activity. Compare the date, total, principal, interest, lender escrow, additional principal and balance with the lender statement.
Step 2: Check a missing match
Open Edit for the loan. Check Monthly payment, which includes escrow, Payment account and Suggest matching loan payments for review. A different withdrawal amount or account can prevent a match. Multiple loans with the same matching amount can also leave the withdrawal without a loan suggestion. Review unresolved duplicate checks first. A missing suggestion does not mean the bank payment failed.
Step 3: Fix input or balance errors
In Record a loan payment, Principal, Interest, Lender escrow and Additional principal must equal Total payment. Check Statement principal balance before payment and Balance as of against the saved balance and date. Use a Payment date on or after the loan start and balance date, and no later than today. If balances disagree, find missing or incorrect activity first. For an expired session or changed loan/source message, check current activity and reopen the form before another attempt.
Step 4: Correct the complete recording
In Payment activity, only the latest unchanged payment offers Reverse. If it is the wrong record, choose Reverse, enter Reason and type REVERSE LOAN PAYMENT, then choose Reverse payment. Check the restored balance and retained reversed activity. Review a corrected payment separately. If reversal is refused because of later payments or linked records, resolve that history before continuing.
Check the result
- You can identify why a suggestion or payment record needs review and use the permitted correction path without duplicating a withdrawal.
FAQs
Does Reverse payment refund the lender withdrawal?
No. It reverses the complete bookkeeping record. For a linked imported withdrawal, it returns the source to Unbooked when reversal is permitted. Contact the lender or bank about actual money movement.
Can I fix only the interest line?
Use the whole loan payment correction. Its principal, interest, escrow and additional principal belong to one reviewed payment; do not add a separate adjustment just to hide the difference.
Why is an older estimated payment missing from exact payment activity?
Older estimated bookings are not rebuilt into statement-backed components. Review those records separately. A current suggestion does not verify earlier amounts.
What if this is an interest-only, HELOC, daily-interest or multi-property loan?
Use the actual statement split instead of the payment forecast. Check whether the saved Portfolio/property scope fits the record. This workflow does not automatically divide one payment across multiple properties; resolve an allocation separately before recording it.
Is the current balance the same as the opening balance?
The current dated balance tracks principal before the next payment. The opening record establishes debt and escrow at the start of tracking. Use the loan setup guide; do not overwrite protected current history to make them agree.