EDC Reconciliation
Matches the money charged through EDC card terminals against the payments recorded on sales invoices, per date and per payment method. The Difference column must be zero; bold rows need checking.
Questions Answered
- Does today's total charged on the EDC terminal equal the card payments recorded on invoices?
- Which EDC transactions are still unfinished (Sent or Unknown)?
- Was any customer's card charged without an invoice to show for it?
Filters
| Filter | Meaning |
|---|---|
| Date | Required. EDC transaction dates and invoice dates are compared on the same day. |
| Payment Type | Only payment methods with Use EDC Terminal on. Empty means all. |
Reading the Results
One row per date and payment method. A is the terminal record held by Acosys (EDC Transaction Log); C is the payment recorded on sales invoices.
| Column | Meaning |
|---|---|
| Terminal | The EDC terminal of that payment method. |
| Terminal Trx, Terminal Amount (A) | Count and value of sales transactions in the EDC log with status Approved or Reconciled. |
| Payment Trx, Payment Amount (C) | Count and value of sales invoice payment lines using that payment method (debit - credit + fee). |
| Difference (A-C) | Must be zero. Positive means the terminal charged more than the invoices record. |
| Unfinished | Transactions in Sent or Unknown status. Not counted in A. |
| Declined | Declined transactions. Not counted in A. |
Below a problem row, its transactions are listed: Issue, Time, ECR Ref., Status, Approval Code, Card, Invoice, and Amount. The issue is one of two:
- Unfinished: the transaction is still Sent or Unknown. Resolve it from the POS screen or its payment form (Re-check, Manual Entry, or Mark declined).
- Approved without invoice: money was charged, but the linked invoice is empty or cannot be found. Investigate these first.
Match column A against the EDC terminal's settlement slip.
Why the Numbers Can Differ
- C only counts sales invoice payments. EDC charges from Sales Order down payments, Accounts Receivable Collection, Student Payment, or Rental Return are still counted in A, so the Difference turns positive for that day.
- A is dated by when the command was sent to the terminal, C by the invoice date. Transactions around midnight or back-dated invoices create matching differences on two dates.
- Terminal transactions are tied to payment methods through the EDC Terminal field. If two payment methods share one terminal (for example Debit and QRIS on the same machine), every transaction on that terminal is counted on both rows.
- Only Sales-type transactions are counted in A. Voids, settlements, and inquiries are excluded.
Menu Location
- Sales & POS / Sales Reports / EDC Reconciliation
/report/edcreconciliation