This guide will help reconcile the billing Credit Card items on your monthly invoice
How to Filter and Reconcile Each Code
CCPAMEX – Reconcile AMEX Transactions
Goal: Identify all settled and successful AMEX transactions for the invoice period.
Date Range: 1/31 – 2/27 (Use Received Date)
Filters to apply in Excel:
Status: Filter by “Successful – Settled”
Method: Filter by “AMEX”
Transaction Type: Filter by “Refund”
Change all refund values to negative numbers (e.g., $25 becomes -$25) to ensure proper balancing.
After modifying the refund values, remove filter from Column L to show all transactions.
CCPItem – Reconcile Per Item Fees (All Cards)
Goal: Capture all received transactions billed on a per-item basis.
- Date Range: 1/31 – 2/27 (Use Received Date)
CCPercent – Reconcile Percentage-Based Card Fees (Visa, Mastercard, Discover)
Goal: Track settled transactions charged as a percentage of the sale.
Date Range: 1/31 – 2/27 (Use Received Date)
Filters:
Status: “Successful – Settled”
Method: Filter for Visa, Mastercard, Discover
Tip: If the totals don’t match during reconciliation, consider the troubleshooting steps below.
CCPBPS – Reconcile Processor Fees (Visa, Mastercard, Discover)
Goal: Capture all successful processor service fees during the billing cycle.
Date Range: 1/31 – 2/27 (Use Received Date)
Filters:
Status: “Successful – Settled”
Method: Visa, Mastercard, Discover
Troubleshooting Tips for Reconciliation Issues
If your totals don’t match expected values, here’s what to check:
1. Chargebacks
Chargebacks may shift the Settlement Date (Column V) to the date of the chargeback instead of the original transaction date.
These may fall outside your date range, so check Column T for the chargeback code COO.
To reconcile properly, consider the Received Date of those chargebacks instead.
2. Interchange Fee Issues
There may be inconsistencies if there were problems applying interchange fees (fees paid to card networks).
Confirm with the Accounting team to check for any known issues during the period.
3. Still Not Balancing?
If none of the above resolves the discrepancy, escalate by submitting a Dev-Ops or QA ticket for support.
More Guides:
- Invoice Reconciliation - Deposit Detail Report
- Download Billing Invoice
- Credit Card Invoice Reconciliation
- Billing and Invoice