How do I activate my bank account in Accounts Hosted to create an ABA file for bulk payments?

Pam Franz
Pam Franz Member Posts: 1
edited July 2019 in Accounts Hosted

Comments

  • Luke
    Luke Moderator, Reckon Staff Posts: 221 Moderator Moderator
    edited July 2019
    Hi Pam,

    The first step is to setup your bank account for online account access.

    To do this go to your chart of accounts, right-click on your bank account and select edit account. Click on the 'Online Bank Details' tab, tick the box 'Online Account Access' and fill out the details.

    See below what needs to be filled out:

    image

    You will not need to fill out the APCA number. Once all the details are filled out click on Save & Close.

    If the ABA file you are creating is for employees, please follow the below steps:
    1. Double-click on each employee
    2. Go to the Payroll and Compensation Info tab and ensure the Pay Method is set to Bank (Online):

    image

    3. Click on Direct Deposit and fill out the details

    image

    If the ABA file is for your suppliers, follow the steps below:
    1. Double-click on each supplier record
    2. Go to the Bank Details tab and fill out the details:

    imageimage

    3. When you go to make a payment on a bill you need to ensure the payment method is select on Bank Online:

    image

    Once a bill and/or an employee paycheque is created go to Banking > Online Banking Centre:

    image

    This is where you can preview and create the ABA files:

    imageimage


    I hope this helps.

    Luke.
  • Jacqui Allen
    Jacqui Allen Member Posts: 238 ✭✭
    edited February 2017
    You will need the APCA number for most Banks without it it is generally rejected at upload.
  • Adrian_6974554
    Adrian_6974554 Member Posts: 191 ✭✭
    edited February 2017
    Hello Pam

    You may wish to set up a separate bank account in Reckon for creating the ABA files.

    We call it "Electronic Clearing Account".

    Other than it being a separate account in Reckon the setup is exactly as instructed above.

    If you process the ABA  through you main bank account via paying the bills, wages etc. you end up with separate transactions in the bank account that total one amount on the bank reconciliation.

    By processing through a clearing account. all the separate bill payments go to this account.

    You then process one Cheque from your main bank account to the clearing account.

    The clearing account comes back to zero and you have one transaction in the main bank account to reconcile to.

    The APCA number this is what I have been told

    CBA 301500
    WBC 037819
    ANZ and NAB is any 6 digit number, unless using ANZ Transactive or NAB Connect require your own user specific number, that you obtain from the bank.


  • Jacqui Allen
    Jacqui Allen Member Posts: 238 ✭✭
    edited February 2017
    Some banks process bulk payments differently and some have the option to record as a single line entry.
  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited February 2017
    Hi Everyone,

    You do need to make an arrangement with your Bank to allow you to upload payment files (ABA files) to the Bank's business portal.  They will give you an APCA number which is unique to you that the Bank's computer system uses to identify you.

    Enter the APCA number you are given in the APCA field of the Online Bank Details tab on your bank ledger account setup.

    image



    If you are using BankData and a Bank Clearing Account please take note of the KB:  Handling Online Banking and BankData configurations in the one company file.


    regards,
    John

  • Caz S
    Caz S Member Posts: 3
    edited July 2019
    Hi, 
    I would like to configure 2 accounts for online access ie: cheque (bill payments etc) & payroll clearing (payroll).
    Where can I select between each option? The screen shot page above will only let me have 1 option, therefore I cant switch between either depending on what I want to upload... 
    Thanks