How to Track Merchant Cash Advance Payments
Build a clean MCA payment tracker that shows what was debited, what should have been debited, and what balance is still outstanding.
Short 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.
Related search terms covered
This guide directly answers the primary query and includes the related MCA contract, payoff, balance, consolidation, payment tracking, and reconciliation terms below.
- How to track merchant cash advance payments
- How to Track Merchant Cash Advance Payments
- how to track merchant cash advance payments
- merchant cash advance payment tracker
- MCA payment tracking
- track MCA debits
- MCA payment reconciliation
- Payment Tracking merchant cash advance guide
- Payment Tracking MCA checklist
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.
| Field | Why it matters |
|---|---|
| Funder name | Identifies which company is pulling the debit. |
| Funded amount | Shows how much cash you received before fees. |
| Factor rate | Explains how total payback was calculated. |
| Total payback / RTR | The balance you are actually paying down. |
| Payment frequency | Daily, weekly, or percentage-of-sales. |
| Expected payment | Baseline for spotting over-debits or under-debits. |
| Actual debit | What cleared the bank account. |
| Remaining balance | Total payback minus cleared principal-style payments. |
| Percent paid | Useful for payoff, renewal, and consolidation conversations. |
Daily tracking workflow
- 1Enter each active MCA from the contract: funder, funded amount, factor rate, total payback, payment amount, frequency, start date, and expected end date.
- 2Create 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.
- 3Check the bank account after debits settle and record the actual debit amount, date, and bank description.
- 4Match each actual debit to the expected payment for that funder.
- 5Flag any missing debit, double debit, amount mismatch, returned payment, fee, or debit from a funder you did not expect.
- 6Update 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.
| Example | Amount |
|---|---|
| Funded amount | $50,000 |
| Factor rate | 1.35 |
| Total payback | $67,500 |
| Cleared payments | $27,000 |
| Returned-payment fees | $150 |
| Estimated remaining balance | $40,650 |
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.
MCA payment tracker setup checklist
- Collect the signed contract for every active MCA.
- Enter funded amount, factor rate, total payback, payment amount, frequency, and start date.
- Build an expected payment schedule for each funder.
- Connect or import bank transactions from the debit account.
- Match each actual debit to a funder and expected payment.
- Review unmatched debits every business day.
- Save payoff letters, renewal notices, and balance confirmations with the deal.
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.
Keep your MCA details in one place
FundingTracker organizes contracts, expected payments, actual bank debits, balances, documents, payoff dates, and cash-flow alerts across every active advance.