What is bulk transacting?

Bulk transacting helps you efficiently collect funds, make bulk payments and make multi BPAY® payments from your client's Cash Management Account (CMA). 

What authority is required for bulk transacting?

To obtain authorisation for bulk transacting as an adviser, you’ll need to undergo a successful registration process through a Business Development Manager (BDM). In addition to being registered for bulk transacting, your client will need to complete a third party authority form to provide you with access to debit their account.

The authority levels are:

  • General withdrawal authority - enables you to make withdrawals for any purpose including withdrawing fees, making tax payments to the Australian Taxation Office (ATO) or investment payments. Please note General Withdrawal Authority is only available to select firms that meet specific eligibility criteria.
  • Financial services debit authority - enables you to withdraw from your client's cash account to an account held in the name of, or controlled by, your company or firm through which you are licensed to provide financial services.
  • Tax payment authority - enables you to make payments from your client's Macquarie CMA to the ATO (with the Tax payment template).  

For more information see Understanding Third Party Authority for FSPs and FSCs.

How do I make a bulk transaction?

To make a bulk payment from your client’s CMA:

  1. Log in to Adviser Online
  2. Click Payments and select Bulk payments from the left-hand menu
  3. Check you aren't exceeding your client-granted authority for any of your clients when bulk transacting
  4. Download the applicable template via the Download templates button. Please make sure you use the correct template (e.g. only include financial services payments in a ‘Financial services payment’ template).
  5. Complete the details of your transactions, taking note of the form guidelines found by holding your mouse over the red arrows. Ensure the file details are correct.
  6. You may notice text stating ‘END OF FILE’. Please leave this text.
  7. Once complete, save the template as a CSV file. Note: The CSV file may differ for Apple users.
  8. Select Upload file to submit your completed template
  9. Enter the processing date and select Proceed to review
  10. Confirm the transaction details are correct
  11. Enter the password generated by your online security token and select Authorise. Note: Depending on the level of authority granted, some bulk transactions require dual authorisation.
  12. If the details are incorrect, select Back to upload a new file or start again. 

A confirmation screen will then appear to show the file has been uploaded successfully. 

We recommend you upload files before 2pm (Sydney time) for successful payments to be received in the destination account overnight. 

For ‘Financial services payment’ files, the funds will be received in the end account as one consolidated amount.

Please note: If using the ’Financial services payment (Debit file)’ template, the payment will only be successful if the bank account details entered match the nominated fee bank account provided at the time of registration.

What bulk transacting files should I use for Accelerator accounts?

When a client appoints you to have Accelerator Account Transfer Authority on an account, they’re authorising this adviser to have access to information about their account.

Accelerator Account Transfer Authority means you can also transfer funds interchangeably between their Macquarie CMA and their Accelerator accounts using bulk transacting provided you are a registered user.

Depending on the authority and the direction of the transfer, you may need to complete specific bulk transacting files. Please see the table below for the correct file to use.

CMA AuthorityAccelerator AuthorityFile to use for transfers from CMA ro AcceleratorFile to use for transfers from Accelerator to CMA
General withdrawal authorityAccelerator Account Transfer AuthorityExternal multiAccelerator to nominated account
No authorityAccelerator Account Transfer AuthorityExternal multi – provided it is used by the Accelerator’s primary dealerAccelerator to nominated account
General withdrawal authorityNo authorityExternal multiNot available

Financial Services Companies can now also be appointed with Accelerator Account Transfer Authority on a client’s Accelerator account via a Macquarie Third Party Authority form. You can find this form on Adviser Tools.

Your clients can also transfer funds themselves via our online and mobile banking services.

How do I check the status of a bulk transaction?

After submitting a payment file for bulk transacting, you can obtain a status update by following these steps: 

  1. Log in to Adviser Online
  2. Select Payments  and click Bulk payments from the left-hand menu
  3. Select the Complete tab and choose to view per admin office or all at once
  4. Click View under actions, select the report type and format
  5. Click Generate.

 

What are the different statuses for bulk transactions?

  • Full – file has been successful. All transactions have been processed. 
  • Errors – some transactions in the file were unsuccessful. Only those transactions containing errors will be withheld from processing, all other transactions will be processed as requested. 
  • File failed – the complete file has been unsuccessful. No transactions have been processed. 

When downloading an error file, only the errored accounts will fail and the rest of the file will be paid successfully. 

Please note the Australian Taxation Office (ATO) imposes an incoming crediting amount of $99,999.99. Any amount greater than this will generate an "amount missing or invalid" error message. 

You can get around this by adding multiple lines to debit the same account up to an amount of $99,999.99. 

® Registered to BPAY Pty Ltd ABN 69 079 137 518

Why is bulk transaction not working?

Occasionally there may be an issue with your bulk transacting.

There are two types of errors for bulk transacting:

We’ve also provided some troubleshooting tips for the most common issues with uploading files or processing.

Uploading file error

File type: Make sure you check the file before saving as a CSV (Comma Delimited) file. Don’t re-open the file after saving as it may cause the file formatting to alter, resulting in an upload file error.

Corrupted files: Download a new version of your chosen template type for each new bulk transacting file you create. Avoid downloading and re-using a template saved on your computer.  

Duplication of files: The system will detect files containing the same number of transactions and total value submitted on the same day to prevent a file accidentally being processed twice. If a match is detected an error message display advising the "file has already been processed" you can either: 

  • split the file into two smaller files, ensuring the two new files have different total amounts, and upload these two new files
  • increase the amount of the sample row so the total file value is different to the previous one, or
  • upload the file the next business day. You’ll also need to advance the date in the file. 

Processing of yesterday’s file in error: A check is in place to prevent users uploading past files in error. If the date on the file doesn’t equal today’s date, the system will reject the file. You can then either upload the correct file, or update the date to today’s date and resubmit. 

Invalid account number error: If the account number is invalid or incomplete, make sure you: 

  • save the file as a CSV file
  • ensure the cells are aligned right
  • change the cell format to either number or text
  • prefix the account number with 0 to make a 10-digit account number.

“0” (zero) dropping off in the BSB or account number and/or The heading in line one is invalid: Either the file hasn’t been loaded as CSV, or the file has been saved as a CSV but reopened resulting in the file being converted to Excel format. Please re-save the file as a CSV.  

Amount missing or invalid: The Australian Taxation Office (ATO) imposes an incoming crediting amount of $99,999.99. Any amount greater than this will generate an "amount missing or invalid" error message. 

Please note, you can get around this by adding multiple lines to debit the same account up to an amount of $99,999.99.

File processed with errors

Insufficient debit authority: You’re attempting to debit an account you don’t have debiting authority on, or you don’t hold the required level of authority for the type of transaction you’re trying to perform. 

If you believe you hold the appropriate authority, please contact us for further review.

Insufficient client funds: The client has insufficient funds to cover the withdrawal requested. 

Invalid client account status: The CMA’s status is not open. If you require further information on why the account is not on open status, please contact us.

Invalid destination account: When submitting a financial services payment file, the bank details the uploaded file is trying to sweep fees to don’t match the details registered on file for your bulk transacting facility. Simply, the destination account submitted in the file isn’t an authorised destination account. 

If you want to have an additional financial services account added to your bulk transacting facility, please contact us.

Amount outside of allowable limit: This limit is related to the receiving BPAY entity. This means the biller has placed a maximum limit on funds they receive via BPAY – this maximum will usually be noted on the bill. 

No CHI clearing account exists: This error appears when attempting to debit an Accelerator account, which is not supported for certain CBT file types.

To contact us, please use live chat to speak with an adviser consultant Monday to Friday, 8am to 7pm Sydney time.

Troubleshooting tips for bulk transacting

  • Make sure the file doesn’t contain a special character such as a comma
  • Tax payment files have a maximum amount per transaction of $99,999.99 (ATO guidelines). All other transactions are $999,999,999.99.
  • You can transfer up to 3,000 withdrawals per file
  • When building the file, save the file to a local drive (desktop) as .xlsx so formatting will remain when reopening
  • Transfers from one CMA to another appear in crediting account same day. A crediting reference can’t be used to appear on crediting account.
  • We recommend users close their file before proceeding to upload. When uploading the file, the file type must be saved as a CSV.
  • It takes approximately 20 minutes for transactions to be processed. We’ll send you an email to confirm the process is complete.
  • There is a forward dating function available, up to 10 days (the nominated date must be a business day). The date on the file should match the date entered in the upload. If processing the file after 3:59 PM (Sydney time), you must use a future date. The file will then be processed on that date.
  • Payee bank accounts must be between minimum 6 and maximum 9 digits in length. If you’re payee account number has fewer than 6 digits, please add zeroes to the start of the number to make it equal to 6 digits.

Can I make bulk payments to ASIC?

Advisers can make bulk transactions to ASIC when they hold General Withdrawal Authority on the client’s account. Advisers with General Withdrawal Authority can also use the External multi payments template successfully to make payments to ASIC.

Tips for making payments to ASIC

  • The ASIC account details must be entered exactly as shown on the ASIC invoice
  • The ASIC EFT reference must be entered in the ‘Receivers Description’ field. Please note the template cell reference and validation currently show this field as optional. 
  • The EFT reference won’t be validated by the system to ensure it is a valid ASIC payee reference, so please take care when completing this field
  • Once created, the CSV file shouldn’t be re-opened in Excel as this will cause re-formatting issues with the ASIC payee reference number. The payment will still be sent to ASIC if all other validations are successful, but the payee reference will be incorrect, and may result in ASIC not recognising the payment. 

® Registered to BPAY Pty Ltd ABN 69 079 137 518

Chat to us on Adviser Online

Chat in real-time with an adviser consultant Monday to Friday, 8am to 7pm Sydney time (excluding public holidays).

Resolve a complaint

Everyone at Macquarie is commited to providing our clients with the highest standard of products and services available. If you have feedback we would like you to tell us about it. 

Talk to us today

To speak to a specialist complete this form and we'll be in touch.