Reconciling Stored Value ACH Transactions

You can reconcile your Stored Value program by confirming that all applicable transactions, such as purchases, add value, redemptions, and cash back are in the ACH transaction file.

How to reconcile your ACH Transaction report to your Stored Value transactions:

1.	Generate an Stored Value ACH Transaction Status report on Aloha Insight and locate the following on the report:

•	Merchant Account — Used by Worldpay to determine the bank account to receive the deposit / withdrawal. You can associate a merchant account with a single store or a group of stores.

•	Transaction ID — A unique number generated by Insight, which corresponds to the Reference Number on the bank statement; however, not all banks support the reference number on their statement.

2.	On Aloha Insight, generate an Stored Value ACH Reconciliation report, which you create in Aloha Insight.

When you generate an Stored Value ACH Reconciliation report and select your stores:

•	If you assign the Merchant Number to a single restaurant, select the appropriate restaurant.

•	If you assign the Merchant Number to multiple restaurants, select the appropriate store group.

Generate an Stored Value ACH Reconciliation report and select a date prior to the date that appears on the Stored Value ACH Transaction Status report. The date on the Stored Value ACH Transaction Status report appears as DD/MM/YYYY Transmitted Totals.

3.	Locate the Total on the Stored Value ACH Reconciliation report.

4.	Confirm the Total matches the Net amount on the ACH Transaction Status report.

5.	If these amounts match, no further reconciliation is required.

If these amounts do not match, perform the troubleshooting steps below.