thankQ Help

The following day, you will receive an email from dailyreports@securepay.com.au with a subject heading of Daily Transaction Report CSV. Attached to this email will be a .CSV file that details the payments that succeeded and those that failed.

1.Click on Create DD Result File under the Finance Module.

2.In the Select Excel Load Template dialog box, select the SecurePay-DD file or your relevant gateway file and click Open.

A Batch Result Load Excel template will open and appear on screen.

3.Return to the email from your Gateway and open the .CSV attachment.

4.Select All the data (ie columns A to Q and all rows containing data.), then Copy (Ctrl-C).

5.Switch to the Batch Result Load template, and place your cursor in cell A6.

6.Press (Ctrl-V) to Paste the contents of the .CSV file into the Batch Result Load file.

7.To enable thankQ to read the Item / Receipt Numbers, these need to be changed from text to a number format.  Click on the Column A heading.  This will select the whole column.

8.Right click within column A and choose Format Cells.

9.In the Format Cells dialog box, set the Category to Number.  Then set the Decimals Places to 0.  You MUST set these two values correctly for the import to be successful. Click OK.

The values in column A should now be displayed in full with no decimal places.

10.Click the Log in thankQ button.

11.A confirmation dialog box will appear, click Yes.

12.When the load has finished, the following message box will appear. Click OK.