Accounts receivable templatesAutomate remittance matching in QuickBooks
Customers often pay several invoices at once and explain it in a remittance email. Modern reads those remittances, splits the payment across the right QuickBooks invoices and applies it once you approve.
TriggerWhen a remittance lands in ar@
Steps4 steps, from trigger to sign-off
ControlAR lead approves every split before it is applied
Free to start. No card needed.
When a remittance lands in ar@The instruction
“When a remittance advice arrives in ar@ in Outlook, read the email and any PDF or spreadsheet attached. Find each invoice it lists in QuickBooks and the matching deposit. Split the payment across those invoices, note any deductions or short payments, and ask the AR lead to approve before applying it.”
Works with every major ERP
- +100 more
How it runs
4 steps from trigger to sign-off
- 01
Watch the AR inbox
Picks up remittance emails, PDFs and spreadsheets from customers and their banks.
Outlook - 02
Read the remittance
Extracts invoice numbers, amounts paid, deductions and the payment date.
Modern - 03
Find the deposit
Matches the remittance to the deposit and open invoices in QuickBooks.
QuickBooks - 04
Apply the payment
The AR lead approves the split, then Modern applies the payment to each invoice.
QuickBooks
Related templates
More AR automations
- Replaces Chaser
Weekdays at 9:00Accounts receivable
Chase overdue invoices on a cadence
Sends reminders at 1, 7 and 14 days overdue from your own inbox, reads replies and stops chasing as soon as the invoice is paid.
5 stepsUse template → - Daily at 8:00
Accounts receivable
Send reminders before invoices fall due
Emails a friendly heads-up three days before each QuickBooks invoice is due, with the invoice and a payment link attached.
5 stepsUse template → - Replaces ChaserWhen a customer replies to ar@
Accounts receivable
Log promises to pay from customer replies
Reads replies to your reminders, captures promise dates and disputes, and logs them against the right NetSuite invoice.
5 stepsUse template →
FAQs
Apply remittance advice to invoices: FAQs
Can’t find what you’re looking for? Send us a message and a person on the team will answer.
Email bodies, PDFs, spreadsheets and portal notifications. If a customer sends a remittance as an image, Modern reads that too.
Modern notes the difference, such as a deduction or bank fee, and asks the AR lead how to treat it before applying anything.
Yes. Modern applies remittances in Xero, NetSuite, Sage or QuickBooks, and reads them from Outlook or Gmail.