Please enable JavaScript to view this site.

thankQ Help

Navigation: FINANCE > BPAY > Create BPay Batch

Upload Excel spreadsheet for BPay Payments

Scroll Prev Top Next More

A template can be created using Admin>Create New Excel Load Template on the Batch Information form if required.

1.Click on the Finance module.

2.Click on Batch Information icon.

BPay_img65

3.Click New on the tool bar.

4.Enter or Select BPay as the Batch Type.

5.Enter a Batch Description.

6.Select an Account.

7.Click OK.

BPay_img66

8.Click Excel Load in the Workflow window.

BPay_img67

9.Select the template to use for this load.

BPay_img68

10.Select the relevant fields, making sure the BPay Ref is added to this spreadsheet.

11.Copy and Paste the spreadsheet from the Bank Statement into this spreadsheet.

12.Click on line 5 to select the column headers.

BPay_img69

Not all the columns of the bank statement need to be selected for the import into thankQ.

Below are the mandatory fields required.

If this is to pay a Pledge the ID should be entered.

If the receipt number is supplied and you do not want to use thankQ’s this can be entered also.

Delete the line that has the Bank’s column headers so only the thankQ headers remain.

 

BPay_img70

13.Click Log in thankQ button.

14.Click Yes to Message to load into the batch.

BPay_img71

15.Click OK.

BPay_img72

16.Click Submit for Checking under Workflow.

BPay_img73

17.Click Set Payments as Successful.

18.Click Yes to set All payments as successful.

BPay_img74

19.Enter a Result for these payments.

20.Click OK.

BPay_img75

21.Click Approve Batch under Workflow.

22.Click Yes to confirm.

BPay_img76

23.Click Log as Posted to Accounts under Workflow.

24.Click Yes to continue.

BPay_img77