Go to Reports and then select Reconciliation Summary.
The Reconciliation Summary report summarizes all your merchant’s net deposits, adjustments, reserves, and fee items posted to their depository account on a given day. The default date filter on the report is the last ACH post date. Click on the filter to change the date. Either navigate from the summary report or select the magnifying glass icon to view the Reconciliation Lookup for everyone or a specific merchant. If the merchant processes multiple currencies, you will see a row per currency for each post date.
The Reconciliation Summary report displays the following fields.
| Field | Description |
|---|---|
| ID | We support a reporting hierarchy for you and your merchants. The hierarchy node is a number assigned to the application and appears in the Application Overview of the Application Detail. |
| Name | We support a reporting hierarchy for you and your merchants. The hierarchy name is assigned to the application and appears in the Application Overview of the Application Detail. |
| Batch Count | Enter the batch count associated with the ACH post date to look for matching merchants in the specified period. |
| Funded Count | Count of Transactions in a batch that is being funding. The difference between the Transaction Count and Funded Count is whether the merchant processes American Express transactions through a direct relationship with American Express. If so, American Express will be responsible for funding you for their associated transactions. |
| Funded Amount | The funded amount includes batches processed in different currencies and details the amount funded in USD. The difference between the Total Amount and the Funded Amount is whether the merchant processes American Express transactions through a direct relationship with American Express. If so, American Express will be responsible for funding the merchant for their associated transactions. |
| Daily Fees | Daily Fees apply to accounts set up for net settlement. Daily fees are the discount % applied to each credit card transaction. They will vary based on the type of credit card and the type of the transaction ( i.e., Card Present, Card-not-Present). |
| Reserve | The dollar amount that is applied to the account's reserve balance. Only for accounts approved with the condition of a reserve requirement. The amount held towards the merchant's reserve. |
| Adjustments | The adjustment total of debits and credits associated with disputes. |
| Calculated Deposit | This field shows the calculated value of your deposit (Deposit - Daily Fees - Reserves +/- Adjustments). |
| Actual Deposit | This field shows the net of deposit items posted to the merchant’s deposit account. |
| Variance | There will be a variance if there is a difference between the Calculated Deposit and the Actual Deposit. |
