It's Big Awesome Savings time
75% OFF FOR 6 MONTHS*
Need help choosing a plan?
Created with Sketch. 1800 917 771 Schedule a call
Need help?
We're here for you.
Schedule call
Created with Sketch.
Payroll

Saving You Time with ABA Files (an Electronic Payment File)

Did you know that by using QuickBooks Online you can pay your suppliers and employees electronically? This can be done by generating an automatic ABA (Australian Bankers’ Association) file. This file contains the data in an electronic file, which is then uploaded directly to your banking system online. Paying multiple bills and suppliers all in the same bulk payment in QuickBooks Online has never been easier.

 

With ABA, there is normally a nine-digit number assigned to a bank, which is used to identify the bank you are uploading your electronic file to. All electronic payment files are prepared using the ABA file format.

So let’s walk through how we would set this up right through to uploading to your bank for payments.

Step 1: Setting up the bank account that payments will be processed in

From the Gear Icon under Settings, click on Chart of Accounts. Now choose the bank account you will be making payment from. On the right-hand side, click on the down arrow and choose Edit.

2016-04-14_11-25-17

At the bottom of the screen that pops up, select the box next to ‘I create batch payments for this account’.

2016-04-14_11-26-57


New fields will appear, so enter BSB, Account Number, Bank Code. Depending on the bank you deal with, you might need to add a bank ‘Direct Entry User ID’.

 

One thing to be mindful of is that some banks require a self-balancing transaction batch within the file. If so, ensure you select the bottom box. If not sure of the information required, call your bank for numbers required. Click Save.

Step 2: Setting up suppliers to pay through an ABA file

Choose your suppliers that will be paid through an ABA file (this is a once-only set up for each supplier), and then once in your supplier card click on Edit.

 

A pop-up window with all the supplier details will appear, and on the bottom right-hand corner you will see an option to select ‘I create batch payments to pay this supplier’. Select this box, and complete the BSB and Account Name, Account Numbers and payment details in Statement Text. Click Save.

2016-04-14_11-35-12

Grow Your Business with QuickBooks

Step 3: Preparing the ABA electronic file

Now that the set up in the bank and suppliers have been completed, let’s prepare to pay a batch of bills. To pay bills, go to the Quick Create button (+) on the middle top part of screen. Then under Suppliers, click on Pay Bills.

2016-04-14_11-53-36

Choose from the left top corner the Bank Account that the ABA file will be paid from by clicking on the up/down arrow.

 

Note: When doing this, the bottom right-hand corner bar will change from a Save button to a Create batch payment button.

2016-04-14_12-45-37

To make payments simply:

  • Add a tick to the left of the bill entry – this will populate the invoice amount on the far right under the Total Amount column.
  • If the payment is only a partial amount, you can amend it under the column Payment second from the right – see the below example (top row Harvey Norman invoice amount is $2750, we are only paying $1000).


2016-04-14_12-48-25

Note: If supplier has not been set up for payments via a batch payment you will get an error for this supplier to be fixed.

2016-04-14_12-51-15

You are ready now for the bulk payment to be made. Click on the bottom right-hand corner bar, Create batch payment. The ABA file seen on the left-hand corner of the window will appear once payment has been created. Also, the bills that have just been selected to be paid are no longer listed for payment.

2016-04-14_12-54-56

Save this ABA file where it will be easily found on your computer, ready for upload to your bank for payment.

2016-04-14_12-57-03

What happens if something goes wrong and how do you fix this?

There are occasions when the payment does not go through to the bank on the same day that the ABA file was created or when an amount needs to be adjusted after you have created the ABA file.

 

This means you will need to void the bill payment. From your left-hand side navigation bar under Transactions, click into Expenses. In the Expense Transactions window, click on the down arrow of the Filter button on the top left and choose Bill Payments. Click on Apply.

2016-04-14_13-04-33

This will give you a list of all bill payments in the specified period. Locate the bill payment that needs to be voided and choose the transactions that relate to this payment by ticking on the box next to the supplier name. Click on Batch actions and choose Void transactions. A window will pop up with ‘Are you sure you want to void selected transactions?’ Click on Yes. 

 

These bills will be located in the Pay Bills window ready to go for the next ABA file to be created.

2016-04-14_13-08-16

If a supplier’s details are set up incorrectly, the bank will return this amount back into your bank account. This amount needs to be reversed. So, following the above instructions under batch actions, click on Reverse bill payment, as this feature will allow reconciliation of tracking money back into the bank account. 

So why not begin using an ABA file next time you’re making payments? The set up is once only, and then you’re ready to go. It could save you time when making multiple payments. It can also help with making accurate payments and eliminating errors when paying a supplier, causing you to wait for payment to come back to you from your supplier. I’ve seen that happen more than once. So go ahead, you lose nothing by trying it out.

How QuickBooks Can Help You Save Time

QuickBooks can help you save time by automating various tasks and simplifying your financial management. Here are some key ways QuickBooks can assist you:

  1. Automatic Transaction Tracking: QuickBooks automatically tracks your income and expenses, eliminating the need for manual data entry.
  2. Invoice Creation and Sending: QuickBooks allows you to create and send invoices to your clients, streamlining the invoicing process.
  3. Reporting: QuickBooks generates reports on your income, expenses, and taxes, providing you with a clear overview of your financial performance.
  4. Single Touch Payroll (STP2) Compliance: QuickBooks Payroll powered by Employment Hero helps you navigate STP2 reporting requirements, ensuring compliance and reducing the risk of penalties.
  5. ABA File Payments: QuickBooks enables you to pay suppliers and employees electronically through ABA file generation, saving time and reducing errors in bulk payments.

By leveraging QuickBooks, you can streamline your financial processes, save time, and focus on growing your business.


Related Articles

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

Help Me Choose

Use our product selector to find the best accounting software for you.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.

Stay up-to-date with the latest small business insights and trends!


Sign up for our quarterly newsletter and receive educational and interesting content straight to your inbox.

Want more? Visit our tools and templates!

By signing up you are agreeing to our terms and privacy policy.

A person is smiling and holding a laptop.