Ramp reconciliation software for card spend and your bank
Reconciles is Ramp reconciliation software for finance teams whose Ramp statement, bank account and ledger never agree on the same day. You export card transactions, statements or reimbursements from Ramp, upload them with your bank statement, and Reconciles matches each card payment and settlement to the bank line and the ledger entry, then lists what does not agree. Controllers on QuickBooks, Xero or NetSuite get exceptions and journal entries to review instead of a spreadsheet to build. If you also run processors and marketplaces, see our credit card reconciliation software page.
Your files are processed in your browser and never stored. No card needed.
Why Ramp, your bank and your ledger drift apart
Ramp codes spend as it happens, but your bank sees something different. Card purchases post when they clear, the statement balance is paid in one or a few payments, and reimbursements go out in separate batches. The ledger, meanwhile, holds whatever was synced and approved.
- One bank payment to Ramp covers hundreds of card transactions.
- Reimbursements and bill payments leave the bank on different days from the entries.
- Refunds and returns land weeks after the original purchase.
- Spend posted on the last day of the month is paid in the next month.
- Transactions are edited or recoded after they have synced to the ledger.
A close that starts with "why does the Ramp liability not match the bank" costs a controller hours in every cycle.
How to reconcile Ramp with Reconciles, step by step
-
01 Export from Ramp
Download the card transactions or statement report for the period, and the reimbursements report if you use it, as CSV. Download your bank statement for the same dates in CSV, OFX, QFX, MT940 or CAMT.053.
-
02 Upload both files
Drop the bank statement in the first slot and the Ramp export in the second. Reconciles reads columns by content, so you do not map a template. It picks up the date, merchant, amount and statement period of every line.
-
03 Review matches and exceptions
Statement payments are matched to the bank lines with the reason "statement payment, sum of transactions". Differences, duplicates, missing payments and refunds that never returned go to the exceptions queue with the exact amount shown.
-
04 Export entries to your ledger
Export a reconciliation report or journal entries for QuickBooks, Xero or NetSuite after review, so the card liability and cash accounts agree before the books close.
What the Ramp export gives Reconciles
- Transaction date and posting date, used to place spend in the right period.
- Merchant, amount and card holder, shown beside every match.
- Statement period and balance, matched against the bank payment.
- Reimbursement batches, matched against the bank lines that paid them.
If a column is missing from your export, Reconciles falls back on amount and date windows and tells you so in the match reason.
Ramp next to your other sources
Few companies run on one card. On Growth and Scale, Ramp sits next to Stripe, PayPal, Square and Shopify in the same workspace, each tied to the same bank accounts. See payment reconciliation software, Stripe reconciliation and bank reconciliation software.
A Ramp statement payment, line by line
Say $48,320 leaves your bank on the 10th as a payment to Ramp. The Ramp export shows the statement closed at $48,320 across 412 transactions, with $1,210 of refunds already netted. Reconciles adds the lines, confirms they equal the bank line and marks the match as "statement payment, sum of transactions". If the lines added to $48,290 instead, the payment would go to the exceptions queue as a $30 difference, with the candidate transactions listed.
Ramp reconciliation questions
The card transactions or statement report for the period, exported as CSV. Add the reimbursements report if employees are repaid through Ramp. Any export with the date, amount and statement period of each line gives the best results.
No connector is needed. Reconciles reads CSV and XLSX exports, so you download the report from Ramp and upload it. The same flow works for other card and spend platforms.
Yes. Upload your bank statement and the Ramp export, then compare against the ledger export. Differences are listed as exceptions, and you can export journal entries to correct them.
Yes. Starter covers your bank, your invoices and one other source, which can be Ramp. Growth covers all processors and spend platforms.
Reconcile a month of Ramp spend
Upload your bank statement and the Ramp export. The first matched payments appear before you create an account. See pricing for plan limits.