Reconciling the Bank Statement

To confirm an ACH transaction, reconcile your bank deposits and withdrawals against the Stored Value ACH Transaction Status report. Before beginning the reconciliation process, obtain a copy of the bank statement for the account you are reconciling, and generate an Stored Value ACH Transaction Status report for the dates of your bank statement.

How to reconcile your bank activity against the Stored Value ACH Transaction Status report:

1.	Obtain and review your bank statement and denote the following to compare against the Stored Value ACH Transaction Status report:

•	Reference Number

•	Deposit/Withdrawal Amount

•	Transaction Date

‘Stored Value ACH’ denotes an Stored Value ACH transaction on your bank statement, and enables you to identify Stored Value ACH transactions on the bank statement.

2.

Generate an Stored Value Transaction Status report for the dates of your bank statement. Most ACH files process within two banking days of transmission; however, you may need to allow for an additional range of one to five days from the transaction date to allow for processing delays. For more information on generating a report in Reports Viewer, refer to Reports Viewer Online Help. After generating the report, denote the following:

•	Merchant Account ID — Worldpay provided number used to determine the bank account that receives the deposit / withdrawal. You can associate a merchant account ID with a single store or a group of stores.

•	Group ID — Worldpay provided number that determines which central funds pool bank account is used.

•	Transaction ID — Aloha Insight generated number that corresponds to the reference number on the bank statement.

3.	For every transaction on the bank statement denoted with ‘Stored Value ACH’ locate the corresponding transaction ID on the Stored Value Transaction Status report.

4.	Confirm the bank deposit/withdrawal amount matches the credit/debit amount on the report. If these amounts match, the ACH transaction was successful.