Accounts receivable templatesAutomate cash application in NetSuite
Modern reads incoming payments from your bank every morning, matches each one to open invoices in NetSuite using the reference, amount and payer, and records the payment once you approve it.
TriggerDaily at 7:00
Steps5 steps, from trigger to sign-off
ControlAR lead approves each Record payment
Free to start. No card needed.
Daily at 7:00The instruction
“Every morning at 7:00, read incoming payments from the previous day in our Chase operating account. Match each one to open invoices in NetSuite by reference, amount and customer name, including part payments and single payments that cover several invoices. Propose a Record payment for each match and send anything you are less sure of to the AR lead with your best guess.”
Works with every major ERP
- +100 more
How it runs
5 steps from trigger to sign-off
- 01
Read incoming payments
Pulls credits from the previous day with payer names, amounts and references.
Chase - 02
Find the invoices
Searches open invoices by number, amount, customer and remittance details.
NetSuite - 03
Propose the match
Handles part payments, combined payments and small short-pays, with a note explaining each match.
Modern - 04
Approve the Record payment
The AR lead approves each payment in one click, and Modern records it against the invoices in NetSuite.
NetSuite - 05
Flag what is left
Posts unmatched payments to Slack with the closest candidates so nothing sits unapplied.
Slack
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
Match customer payments to open invoices: FAQs
Can’t find what you’re looking for? Send us a message and a person on the team will answer.
Yes. It matches one payment to several invoices, or several payments to one invoice, and records short payments with a note for you to review.
Modern uses the payer name, amount and open balances to suggest the most likely invoices, and sends the match to a person when it is not sure.
Yes. Modern reads payments from Chase, accounts connected through Plaid or your bank feed, and records them in NetSuite, Xero, QuickBooks or Sage.