Introduction

Bulk Payments are a quick and easy way to automate supplier payment runs, saving you time and reducing the risk of payment errors.

Benefits of automating supplier payments include:

• Delivery of operational efficiencies allowing Accounts Payable agents to focus on business-critical tasks.
• Improvement of supplier relationships by eliminating late or missed payments.
• Delivery of real-time insights into supplier spending and the invoicing lifecycle.
• Reduction of fraud risk with approval and reviewing supplier bank details.

Which Payments can be included in a Bulk Payment?

The payments that are made available for a Bulk Payment are determined by several factors. Check the following in the Supplier Master Record.

Account Details tab:

• Active: Tick this to make the Account active.
• Bank GL Account: The bank the Supplier gets paid from must be the chosen Bank Account for the payment run.
• Account On Hold: This must be set to "Not On Hold".

Finance Settings tab:

• Credit Terms: This is regardless of whether their account is in Debit or Credit. View Credit Terms in the Supplier Master Record and control their coding via Codes Maintenance.
• Payment Method: This must correspond to the Bulk Payment method, either Cheque or Online Bank Transfer. If you have set the Supplier (Vendor) up as ONL you must also include details of their pay-in Bank Account.

Other criteria include:

• Accounts with outstanding Invoices will be included even if the Account is in Credit.
• Accounts with no outstanding Invoices or where the Balance is zero will be excluded.
• Unapproved invoices will be excluded.

See:

 Supplier Bulk Payments Introduction (4.9) - AIQ Academy  

 Bulk Payment Setup (6A.2) - AIQ Academy

 New Supplier Bulk Payment

 Process Foreign Supplier Payments using TransferMate‍ 

 How to use Supplier Bulk Payment Approval‍ 

Setting up a Bank Account‍ 

Creating a Bulk Payment

Step One: Complete the Header details

Go to Purchases > Bulk Payments > New Bulk Payment and complete the following:

• Bank GL/Name: Select the bank account that you want to make the payment from. Only transactions from suppliers with the selected bank account will appear in the results. 
• Payment Type: Select Offline or Online.
• Payment Method: The dropdown will be prepopulated with the last used method. If using multiple suppliers that use different payment methods, select as many methods as needed. For TransferMate accounts, the payment method will always be ONL. 
• Payment Date: Select the date that you want to include transactions up until. This defaults to today's date.
• Bulk Payment Number: This comes pre-populated. Edit if necessary.

Step Two: Select Transactions for the Bulk Payment

1. Select transactions as follows:
   • Click Select All Due Transactions to quickly pay everything due up to and including the due date. 
   • Use the header checkbox to select all transactions listed on the screen against a supplier and the transaction checkboxes to select individual transactions.
     
     
2. If any transactions require your attention, a warning icon will appear next to them. Make any changes needed.
3. If any of the suppliers selected have changed their bank details, a link will appear to view these changes.
   
   
   
   
4. Click Save. This lets you add more transactions or process the payments later. Alternatively, if the payment was started in error, click Discard Draft.
5. The Bulk Payment will appear in the Bulk Payments grid with its current status, ready for further processing if needed.
   
   

Processing a Bulk Payment without Approval

The following details bulk payment processing without approval. For the approval and processing process, see Using Bulk Payment Approval.‍ 

1. Once the Bulk Payment has the status of ‍"Ready to Process", a Process Payment option will be visible in the Actions dropdown.
   
   
2. Click Process Payment. In the message that appears, click Continue to proceed.
3. The Bulk Payment will disappear from the "Open Bulk Payments" in the listing grid and its status will change to "Completed".

Processing a Bulk Payment with Approval 

System Approval

For full instructions on using Bulk Payment Approval, see Using Bulk Payment Approval.‍ If you are using Bulk Payment Approval, Bulk Payments need to be reviewed by a nominated approver before the payment can be processed. If you are using a TransferMate‍ Bank Account, approval is mandatory. 

Email notification is automatically sent to the approver to let them know their action is needed to avoid any delays to payment. Approvers can review and edit the Bulk Payment or send it back to the creator if many changes are needed.  

If the approver is out of the office, users can select a different approver of their choice, triggering an email to the new approver - letting them know there is a bulk Payment waiting for their approval. Full details of the approval actions taken by different users are added to the Bulk Payment history.

Non-System Approval

If your approvals are managed outside of the system, navigate to Reports > Report Manager > Purchase Reports, to run the Bulk Payments Report.

See:

 Using Bulk Payment Approval‍ 

Processing Foreign Supplier Payments using TransferMate‍ 

Advanced Features

Build a Bulk Payment your way

• Click Edit Columns to add/remove columns from the New Bulk Payment and include the data that you need to build your Bulk Payment. For example, if you want to use payment methods or control accounts, or check that the supplier bank details are correct before downloading a payment file, add these columns to the grid. By saving the view the same columns will be displayed each time you create a new Bulk Payment. 
• You can sort and filter any of the columns in the grid and select all filtered items with a single click.

Part Pay an invoice

Select the invoice using the checkbox, then enter the amount you want to pay in the Payment Amount column. Note that you can't pay over the invoice amount via Bulk Payments. If you want to do this, you need to create a manual payment for the supplier.

View Bulk Payment History

Click Bulk Payment History to get a summary of the bulk payment process from creation through to approval.

Export Bulk Payment to CSV

Use the Export function to download your Bulk Payment to a CSV file.

Auto Allocate credits while making a payment

All unallocated transactions (including Purchase Payments and Debit Notes) linked to suppliers are highlighted to help you ensure you don't over or underpay any suppliers while processing a Bulk Payment. For an explanation, click on the warning icon.

If you use Select All Due Transactions, all transactions (debits and credits) will be selected as part of the Bulk Payment. You can review this and add or remove the transactions as required. Similar to partial payments, the system will not allow you to pay any supplier more than they are owed.

Foreign Currency Payments 

Make payments from banks in any currency to suppliers in any currency.

1. If you include foreign currency payments to suppliers in a Bulk Payment, the Edit Payment Exchange Rates link will be available.
    
   
   
2. Click the link to check and update the exchange rate for each currency included in the Bulk Payment (the exchange rate will default to today's rate).
   
   

   
   

3. When you process the payments, the payment will be created in the supplier currency and the associated Currency Fluctuation transaction will be automatically posted to realise the difference between the FX amount in the invoice and the payment.

See:

Bulk Payment Actions, Payment Files, and Remittances

Once a Bulk Payment has been created, approved (if using), and processed:

1. Go to Purchases > Bulk Payments.
2. In the Actions dropdown for the relevant Bulk Payment, you can:
   • Download the bank payment file.
   • Send remittances to suppliers. (see below)
   • Mark a Bulk Payment as completed to show that all tasks are completed and start a new Bulk Payment for the same bank account.
   • View a Bulk Payment report.
     

Download Payment File

Our Bank File Formats

We have a large number of bank file formats‍  for a wide range of UK and Irish banking institutions and payment types. 

• If your bank account is supported this will allow you to download a payment file to upload to your online banking platform, saving you time and avoiding any human error processing the payments.
• If your bank account is not supported, you can still save time by using Bulk Payments to create your payment run, then use the payment report to process the payments manually with your bank.

Downloading the Bank File

1. Create a Bulk Payment as described earlier, noting the following:
   • Use the date when the Supplier expects to be paid by their bank. This does not affect any of the posted payment transactions, instead, it updates the date in the download bank file used by the bank. If you enter the wrong date in this field, update it and download a new version of the file.
   • If there are errors in the Bulk Payment, you will be alerted. Follow the instructions to correct them. For security reasons, only admin users can update Supplier Bank Details.
2. Under Actions, select Download Payment File and save the file.
   
    
   Delete

   Info

   An improvement has been made to the Barclays.net payment file, allowing a custom reference per supplier. Enter the reference in the E-Payment Ref field in the supplier record. This reference will be populated in the payment file.

   
   

3. Under Actions, select Mark as complete. Your bank will inform you, through their system, of any mismatches and anomalies that you may have to examine.

Send Remittance

The Send Remittances option will only be available after the Bulk Payment has been processed or, approved and processed if workflow approval is enabled.

1. Under Actions, select Send Remittance.
   ​
   
2. In "Confirm Selected Remittances":
   • The Reply To email address will default to the address from the Supplier Business Contacts or, if set, from the primary contact in the Supplier Master Record. 
   • Check the recipient email addresses and click Remove where necessary. Any incorrectly formatted addresses will be highlighted. You can add more recipients by separating them with a comma or semi-colon.
   • Click Next.

     
     

     

     
     

3. In "Compose Email": 
   • Enter a subject and body text for the email. This will automatically be saved for next time.
   • Click Send. All batch emails will go into a queue and will be sent in the background. You will receive a confirmation email when the Bulk Payment has been completed.
4. Click Done to view the email log. The Email Log displays the status of all emails sent from the company. 
   • The grid does not update automatically. Click Refresh Grid. 
   • To view remittances, filter by Document Sent and Status. If any emails were not sent, hover over the status column to see details of the failure and how to resolve any issues.

Remittances are also available in the Report Manager:

• Go to Reports > Report Manager > Purchase Reports > Supplier Remittance Batch Payment Print. 

Printing Cheques

1. Prepare and process a bulk payment run as described above (selecting suppliers that use the cheques payment method).
2. Go to General > Transaction Browser. Modify the grid in the following manner and save your customization:
   • Include the Paymt. Batch No. field in the grid. 
   • Make sure that you have the Summarise Transactions flag switched on.
3. Find payments included in the latest payment run by entering the bulk payment number into the Paymt. Batch No. field.
4. Edit the Ext. Ref. field by entering the cheque number into the field.
   
   
   
5. Go to Reports > Report Manager > Purchase Reports. 
6. Run the “Supplier Bulk Cheque Remittance Print” report to print your cheques.