Direct answer
Track merchant cash advance payments by listing every active advance, its total payback amount, expected daily or weekly debit, payment start date, cleared payments, missed payments, fees, and remaining balance. Reconcile your bank debits every business day against the expected schedule so you can catch double debits, over-debits, missed credits, and payoff timing before cash flow breaks.
Key takeaways
- Use total payback, not the funded amount, as the starting balance.
- Track expected payments and actual bank debits in separate columns.
- Reconcile every business day for daily ACH advances and every debit day for weekly advances.
- Show both remaining dollars and percent paid so renewal and payoff conversations are grounded in the same numbers.
The fields every MCA tracker should include
A merchant cash advance tracker needs enough detail to explain today's cash impact and tomorrow's payoff risk. The goal is not a perfect accounting system. The goal is a daily operating view that tells you which funder pulled money, whether the amount was expected, and how much of the purchased receivables balance remains.
Start with the deal terms from the signed contract, then add live payment activity from your bank account. Keep the original contract numbers separate from the actual debit history so you can see where the funder changed a payment amount or applied a fee.
Daily tracking workflow
- Enter each active MCA from the contract: funder, funded amount, factor rate, total payback, payment amount, frequency, start date, and expected end date.
- Create an expected payment schedule based on the payment frequency. Daily ACH schedules usually run on business days; weekly advances debit on the weekday named in the contract.
- Check the bank account after debits settle and record the actual debit amount, date, and bank description.
- Match each actual debit to the expected payment for that funder.
- Flag any missing debit, double debit, amount mismatch, returned payment, fee, or debit from a funder you did not expect.
- Update remaining balance and percent paid after each cleared payment.
- Important: If the funder debits a different amount than the schedule, do not overwrite the expected payment. Keep expected and actual separate so you can prove the variance later.
Simple remaining balance formula
For most fixed-payment MCAs, the working balance formula is: remaining balance = total payback - cleared payments + unpaid fees or returned-payment charges. If your contract has a reconciliation or true-up clause, keep a separate adjustment column so the original payback math stays visible.
When to contact the funder
- A debit posts twice on the same day.
- The debit amount is higher than the contract schedule.
- A payment posted in your bank account but is missing from the funder's portal.
- The funder continues debiting after your tracker shows the balance is paid off.
- You need a payoff letter for consolidation, refinance, or settlement review.
Common questions
- Should I track the funded amount or the total payback? Track both, but use total payback as the balance you are paying down. The funded amount shows what you received; total payback shows what the funder is entitled to collect.
- How often should I reconcile MCA payments? For daily ACH advances, reconcile every business day. For weekly advances, reconcile on the debit day and again the next day to catch late-posting transactions.
- Can FundingTracker track MCA payments automatically? Yes. FundingTracker can track active advances, expected payments, actual debits, remaining balance, payoff timing, and unusual payment activity in one dashboard.