The Macquarie Bank Limited technical team confirms the design implemented by Insol 6 allows for compliance with the file size, transaction number and upload limits for Macquarie active banking which are:
- No file larger 20,000 line items or 2.33mb in size.
- No more than 50 files (of max. 20,000 line items) to be uploaded in a 5 minute period.
For example, if you have 100,000 transaction items to upload, by entering 5,000 transactions per file in the upload process, the upload will generate 20 separate files each having 5,000 transactions.
By processing batches of 25,000 transactions split over 5 ABA files (5,000 entries per ABA for efficiency purposes) a large volume of transactions can be processed within a short period.
Why would you have 1 transaction per file?
The advantage of having one transaction per file is the every transaction is represented on your bank statement and each transaction file description contains the payee (which can make approvals online convenient. If you have more than 1 transaction per file, then you need to enter the description for the file.
To extrapolate, the software is capable of processing 300,000 transactions in 1 hour. Consult your Macquarie business banking manager for confirmation of the above.
The above however is only the first part of the process. Once files have been uploaded authorisation is the next stage, to ensure a smooth process it is best to:
- Authorise in batches 5 to 6 files at a time leaving 5 minutes between batches (so not all at once, this is only an issue if you are planning to upload all 300,000 transactions at once).
- Authorise payments outside of peak times 2pm to 6.30pm AEST.
For added comfort if clients provide Macquarie Bank with notification of when the files are going to be authorised, the active banking team can monitor this process to ensure that these large payments go out to market.
For larger volumes, completing the payment upload process over a week, would ensure authorisation limits and file limits are not exceeded along with being able to avoid peak processing times.
Consult your Macquarie business banking manager for any questions or arrange a meeting to discuss your needs in more detail.