Users who operate a shop with multiple suppliers (hub users) often ask us for the quickest way to forward payments that they receive from customers, to their suppliers. For example, you may stock products from 20 producers in your hub shop. After you receive customer orders and payments, you want a quick way to work out how much you need to transfer to each supplier and then quickly make payment.
This page describes a couple of ways that users can pay their suppliers.
You can use Reports to get a breakdown of the value of goods sold from each supplier. The Order Cycle Supplier Totals report gives the total value of goods sold from each supplier. Alternatively you can download the Order Cycle Customer Totals report and create some pivot tables to extract the data you need.
Once you have the dollar values that you need to pay to each supplier, the next step is often to enter these amounts into your online banking system, to do a bank transfer to each supplier. This can be time consuming for those with numerous suppliers.
At the moment OFN doesn't have an automated system for calculating what is owed to suppliers and automatically forwarding payments to them.
An alternative for Australian users is to create an ABA file. An ABA file is an file type like an excel spreadsheet, which can be uploaded into most Australian bank's online banking systems, as a way to pay multiple people without entering their individual payments manually.
There's a couple of ways to create an ABA file.
1) Use your accounting package to generate an ABA file
If you use an accounting package such as MYOB, Quickbooks or Xero, it's likely that the package will have an 'ABA generation' tool. These tools vary, but generally they'll allow you to enter the amounts you wish to pay each supplier, along with their banking details (BSB, account number, name etc) and then the ABA file will be generated. You can then upload this file into your bank and the payments will be made en mass.
2) Use an online ABA file generator
Cemtaxaba is an online ABA file generator which can turn an excel file into an ABA file. There are fees associated with the tool, check their website for details - https://www.cemtexaba.com/
The process for using this tool is as follows.
1) Download the CemtexABA template CSV file.
2) Enter details into the correct columns.They ask for the bank details of the payee and the amount you want to transfer.
3) Upload the CSV into the Cemtexaba website. They'll ask you for your bank details (the 'payer' information), and then they'll provide you with an ABA file
4) Upload the ABA file into your online banking system to do the bulk payment.