The Credit Card Reconciliation report lists card receipts and refunds that have been reconciled against bank deposits, including the amount received, commission deducted, and the user who reconciled each transaction.
Â
Overview
The Credit Card Reconciliation report is a CSV export that shows every Credit Card receipt and refund reconciled through the Credit Card Reconciliation utility for a chosen date range. It is used by accounting staff to compare RMS receipts against the bank's settlement deposits, identify any variance between the amount taken and the amount received from the bank, and audit the merchant commission applied to each transaction.
The report can only be Exported to CSV.
Â
Use Cases
- End-of-month reconciliation audit - the accounts team runs the report at month end to confirm every card receipt for the period has been reconciled to a bank deposit.
- Investigate a missing deposit - when the bank statement total does not match the expected card takings, run the report for the period to identify which receipts were and were not reconciled and the commission deducted from each.
- Review merchant commission - run the report over a longer period (a quarter or year) to review the commission column across card types and identify any unexpected charges.
Report Options
The report has two options. Both must be set before clicking Export to CSV.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Property | Multi-select | Current property | Limits the report to the selected properties. Visible to users with access to more than one property. |
| Reconciled Between | Date range | Today | Filters the report to transactions where the Date Reconciled falls inside the selected range. |
Â
How to Access
In the side menu of RMS, go to Reports > Accounting > Credit Card Reconciliation.
Guide
In the side menu of RMS, go to Reports > Accounting > Credit Card Reconciliation.
- Select the Reconciled Between date range.
- Select Export to CSV.
Â
Column Headers
The columns below appear in the exported CSV file in this order.
| Column | Description | Source / Calculation |
|---|---|---|
| Property | The property the receipt or refund was processed against. | Receipt / refund record |
| Date Reconciled | The date the transaction was marked as reconciled in the Credit Card Reconciliation utility. | Reconciliation record |
| Receipt/Refund No | The receipt or refund number generated by RMS for the transaction. | Receipt / refund record |
| Transaction Type | Indicates whether the transaction is a Receipt or a Refund. | Receipt / refund record |
| Account No | The account the receipt or refund was applied to. | Receipt / refund record |
| Card Type | The card type used for the transaction (for example Visa, Mastercard, Amex), as configured in Setup > Accounting > Credit Cards. | Card Setup |
| Batch No | The batch reference recorded against the reconciliation. | Reconciliation record |
| Description | The description recorded against the receipt or refund. | Receipt / refund record |
| Amount | The original receipt or refund amount in RMS. | Receipt / refund record |
| Received from Bank | The amount confirmed as received from the bank for the transaction, as entered during reconciliation. | Reconciliation record |
| Commission | The merchant commission or fee deducted by the bank or payment processor for the transaction. | Reconciliation record |
| Comment | Any free-text comment recorded against the reconciliation. | Reconciliation record |
| User | The RMS user who reconciled the transaction. | Reconciliation record |
| Property | Limits the report to the selected properties. Shown on multi-property (Enterprise) databases only. | Â |
Â
Data Sources & Calculations
Reconciliation source
Only receipts and refunds that have been reconciled through the Credit Card Reconciliation utility (Accounting > Credit Card Reconciliation) appear on this report. A card receipt that has been taken but not reconciled will not appear, even if it falls inside the selected date range.
Â
Card setup prerequisite
For a Credit Card type to appear on this report, its Pay To setting in Setup > Accounting > Credit Cards must be set to Bank. Card types set to a different Pay To destination will not be reconciled through the Credit Card Reconciliation utility and therefore will not be included in this report.
Â
Related Reports
- Cash Transaction Report - shows all receipts and refunds (cash and card) by transaction date.
- Daily Cash Report - breaks down daily revenue by payment method.
- Cash Allocation Report - shows how receipts have been allocated to charges, including suspense movement.
- Report on Credit Card Transaction Fees - uses the Audit Trail report to summarise credit card transaction fees by General Ledger Account Code.
Â
Related Articles
- Credit Card Setup - configure card types, transaction fees, and the Pay To setting required for reconciliation.
- Credit Card Receipt - how card receipts are processed in RMS.
Â
Â
Comments
0 comments
Please sign in to leave a comment.