Financial Reporting
Overview
In this guide we will give a detailed analysis of both the Reconciliation and Settlement report. These reports can be accessed from the Financials menu within the Hub.
Reconciliation report
Overview
The Acquired.com Reconciliation Report is a powerful tool used to pinpoint each transaction, the amount you were charged by the card schemes (i.e. Visa and MasterCard) and the fees paid to your acquiring partner. View the gross amount you processed, the commissions and fees that are deducted, and the net amount you collect for each transaction.
Use the filters to define what data is returned within your report. When selecting your date range, you can use the toggle to determine whether the report is exported in a combined or daily view. Once you have confirmed your data, run the report by clicking on the Export icon in the Action column.
Report parameters
View the parameters returned in the report below:
| Parameter | Description |
|---|---|
| Transaction_id | The unique reference assigned by Acquired.com for the transaction. |
| Date | The date the transaction was processed. |
| Company Name | The company name. |
| Company_id | The unique ID assigned by Acquired.com for the company. |
| MID | The unique ID assigned by Acquired.com for the MID. |
| ARN | The Acquirer Reference Number (ARN) is the unique reference that is used within the banking network to identify the transaction. |
| Order ID | The unique reference that is assigned by you in the payment request. |
| Card Type | The scheme that the card belongs to (Visa/Mastercard/AMEX). |
| Type | The type of transaction (sale, refund etc). |
| Bank | The acquiring bank. |
| Bank_id | The MID issued by the acquiring bank. |
| Currency | The currency that the transaction was processed in. |
| Amount | The transaction amount that was collected. |
| Commission | The amount that is deducted by the acquiring bank and any potential fees that may be applied. |
| Settled Amount | The settled amount of each transaction that will be credited to your account. |
| Region | The region the transaction was made in. |
| Payment Method | The payment method used for the transaction, i.e. card, Apple Pay, Google Pay. |
Note
The order ID value is an important aspect of the report as it is the unique identifier within your system. We recommend using this value to confirm when a specific customer has completed a payment, the date the payment was taken and the amount that was collected.
Settlement report
Overview
The settlement report is a summarised version of the reconciliation report. We provide a clear, easy-to-read summary of the payments you have received along with all the possible clearing types affecting your end of day settlement.
View an opening balance, the revenue collected from sales, any refunds that were processed via your account, all disputes and related fees and lastly, any miscellaneous activities.
The report provides a quick snap-shot allowing for quick reconciliation to take place. However, you will still need to track the payments you receive into your bank account ensuring that all transactions processed match what you receive.
Report parameters
View the parameters returned in the report below:
| Parameter | Description |
|---|---|
| Date | The date the report was created. |
| Opening Balance | The current balance on your merchant account |
| Sales | The successful payments you processed (this information is provided on a count and amount basis). |
| Refunds | Any refunds that have been processed (this information is provided on a count and amount basis). |
| Disputes | All the newly raised disputes and/or the recovered disputes displayed on a count and amount basis. |
| Fees | Any fees relating to any disputes your account has incurred. |
| Misc | Any other fees that will impact the settlement amount. |
| Reserve | The rolling reserve value that has been credited / debited from your account - only applicable to certain merchants. |
| Net Amount | The amount of each batch that will be credited to your account. |
Updated about 2 months ago