Gateway Data
Gateway Data bridges your online payment providers and your accounts. It tracks what customers paid digitally, what the provider deducted in fees, and what actually landed in the bank — the three figures that rarely match and have to be reconciled against each other.
Where to find it
Go to Banking > Gateway Data.
Filter & Search Header
| Filter | What it does |
|---|---|
| Gateway | Restrict to one payment provider. |
| Date range | The period to report on. |
| Status | Filter by whether a transaction succeeded, failed or is pending. |
| Reference | Find a specific transaction. |
Gateway Transaction Table
| Column | Description |
|---|---|
| Gateway | Which provider processed the payment. |
| Reference | The provider's transaction identifier — what you quote when querying with them. |
| Date | When the payment was taken. |
| Customer | Who paid. |
| Gross Amount | What the customer was charged. |
| Fee | What the provider deducted. |
| Net Amount | What reached your bank. |
| Status | Succeeded, failed or pending. |
Gross, fee and net are the whole point of this screen. The customer's invoice is settled at the gross figure, your bank receives the net, and the difference is a cost that has to be recorded — otherwise the bank will never reconcile.
Reconciling gateway settlements
Providers usually settle in batches, so several payments arrive as one deposit. Match the batch total against the bank line, and post the fees to your charges account so the two sides agree.
Related pages
- Gateways Settings — activating and configuring providers
- Reconcile — matching settlements to the statement
- Customer Payment — allocating what was collected
- Bank Inquiry — the account settlements land in