Reconciliation templatesAutomate credit card reconciliation in QuickBooks
Modern pulls company card transactions through Plaid, matches each one to an expense and receipt in QuickBooks, suggests coding for the rest and ties the total to the monthly statement.
TriggerFridays, and on statement day
Steps5 steps, from trigger to sign-off
ControlBookkeeper approves coding and the statement tie-out
Free to start. No card needed.
Fridays, and on statement dayThe instruction
“Every Friday, and on the day each card statement closes, pull card transactions through Plaid. Match each one to an expense in QuickBooks by amount, date and merchant, and attach the receipt if we have it. Suggest an account and class for anything unmatched based on past coding. At statement close, confirm the QuickBooks balance equals the statement and ask the bookkeeper to approve the coding.”
Works with every major ERP
- +100 more
How it runs
5 steps from trigger to sign-off
- 01
Pull transactions
Reads card transactions for every connected card account through Plaid.
Plaid - 02
Match expenses
Finds the matching expense and receipt in QuickBooks by amount, date and merchant.
QuickBooks - 03
Suggest coding
Proposes an account and class for unmatched lines based on how similar spend was coded.
Modern - 04
Tie to the statement
Checks the card balance in QuickBooks equals the statement balance.
Modern - 05
Approve and reconcile
The bookkeeper approves the coding, then Modern reconciles the card account.
QuickBooks
Replaces bill and bank statement capture software
Still paying for bill and bank statement capture?
This template does the job of AutoEntry inside Modern. Run the stack audit to see what you could cancel across your whole finance stack.
Related templates
More reconciliation automations
Daily at 6:00Reconciliation
Propose bank reconciliation matches daily
Matches each bank transaction to NetSuite entries every morning, explains each match and leaves only true exceptions for review.
5 stepsUse template →
Monthly, working day 3Reconciliation
Reconcile intercompany balances at month end
Compares intercompany balances across every NetSuite subsidiary on working day 3, explains differences and builds the rec in Excel.
5 stepsUse template →- Monthly, working day 2
Reconciliation
Recharge intercompany costs automatically
Finds shared costs paid by one NetSuite subsidiary, applies your recharge rules and drafts matching intercompany invoices and bills.
4 stepsUse template →
FAQs
Match card statements to QuickBooks: FAQs
Can’t find what you’re looking for? Send us a message and a person on the team will answer.
Modern can read transactions from any card account Plaid connects to, or from a statement file if your card issuer is not supported.
It looks at how similar merchants were coded in QuickBooks before and suggests the same account and class. You approve or correct every suggestion.
Yes. Modern matches card transactions in Xero, NetSuite, Sage or QuickBooks.