Payments
      Back to home
      2. Payables
      3. Payments

      Payments - Internet Banking Export File

      How to create an Internet Banking Export File

      Overview:

      Create a file of payments that can be uploaded to your internet banking system

      Steps: 

      Starting from the main screen 

      1.     Navigate to ACCOUNTING > General Ledger > General Ledger Accounts 

      Knowledge Base Template (16)-1

      2.     Select the Account No 

      Large Knowledge Base Template (5)-Feb-09-2023-05-08-56-6673-PM

      3.     Select Banking Details 

      Large Knowledge Base Template (6)-Feb-09-2023-05-11-07-1064-PM

      4.     Enter the following details 

      Large Knowledge Base Template (7)-Feb-09-2023-05-18-12-1248-PM

        Banking Details  Description
      a Bank Code  An alpha code that identifies your bank
      b Bank User Name  This will be the company name or the name of the account for this bank account
      c Bank Remitter Name  Shortened version of the BANK USER NAME - maximum 16 characters
      d Bank User ID no  For ABA files this is a code provided
      e Bank No  For ABA files this is referred to as the BSB file
      f Bank Account Number  This is the actual account no of the bank account
      g Bank Tax ID  Bank Tax ID 
      h Default Payment Ref This is an abbreviation of the company name
      i Internet Banking Payment File Type  Choose from the drop down menu to select the relevant Bank Payment File Type eg. ABA

      If migrating to AccountAbility from another finance system,  the details to be entered will likely be the same as the existing bank file setup and will vary depending on the file type of the internet banking file

       

      5.     Select SAVE or SAVE & CLOSE 

      Knowledge Base Template (17)

      Users can include a reference code or detail that will appear on the payees bank account, when an internet payment is made to them by navigating to MASTER FILES > Suppliers > Enter the reference code or detail in the SUPPLIER ACCOUNT NO field.

       

      Before creating the payments to be uploaded to the internet banking system, the bank account details of the Suppliers must be entered

      Steps: 

      Starting from the main screen 

      1.     Navigate to MASTER FILES > Suppliers 

      Knowledge Base Template (2)-Mar-02-2023-05-39-38-6414-PM

      2.     Select the SUPPLIER CODE hyperlink 

      Large Knowledge Base Template (5)-Mar-02-2023-05-54-55-0156-PM

      3.     Select the Supplier Bank Account Details hyperlink 

      Knowledge Base Template (6)-Mar-02-2023-07-34-16-5266-PM

      4.     Enter the information needed 

      Knowledge Base Template (7)-Mar-02-2023-07-36-27-2588-PM

      5.     Select SAVE or SAVE & CLOSE 

      Knowledge Base Template (9)-Mar-02-2023-07-38-48-2896-PM

      How to create the internet banking export file:

      Steps: 

      Starting from the main screen

      1.     Navigate to ACCOUNTING > Payables > Payments

      Knowledge Base Template (11)-Mar-02-2023-08-15-54-5114-PM

      2.     Select the Payment No hyperlink that the internet banking payments are to be              created for 

      Large Knowledge Base Template -Mar-03-2023-01-30-13-8920-PM

      3.     Select the Internet Banking Export hyperlink

      Large Knowledge Base Template (1)-Mar-03-2023-01-31-24-4527-PM

      4.     There are two options to view the Internet Banking Export files 

      a.     As is 

      b.     Mark Payments as Approved 

      Export As is 

      a1.     Confirm the internet banking detail information is correct 

      Large Knowledge Base Template (4)-Mar-03-2023-01-42-39-2585-PM

      a2.     Select CREATE FILE 

      Large Knowledge Base Template (5)-Mar-03-2023-01-51-25-4290-PM

      a3.     The Internet Banking File will be exported 

      Large Knowledge Base Template (6)-Mar-03-2023-01-55-00-9851-PM

      Export As Mark Payments As Approved 

      b1.     Confirm the internet banking detail information is correct

      Large Knowledge Base Template (4)-Mar-03-2023-01-42-39-2585-PM

      b2.     Select the MARK PAYMENTS AS APPROVED box 

      Large Knowledge Base Template (7)-Mar-03-2023-02-01-39-2372-PM

      MARK PAYMENTS AS PRESENTED – Users can select this option so that the payments included in the file will be automatically marked as APPROVED in AccountAbility 

      b3.     Enter the BANK RECONCILIATION PRESENTED DATE

      Large Knowledge Base Template (8)-Mar-03-2023-02-03-35-2515-PM

      BANK RECONCILIATION PRESENTED DATE - Enter a date to assign the payments included in the file as ‘Presented’ in the AccountAbility Bank Reconciliation on that date

      b4.     Select CREATE FILE

      Large Knowledge Base Template (3)-Mar-03-2023-01-36-59-9702-PM

      b5.     The Internet Banking File will be exported 

      Large Knowledge Base Template (9)-Mar-03-2023-02-11-23-7940-PM

      5.     Save the File to the computer and upload to the banks Internet banking system 

      Screenshot 2023-03-03 at 9.13.59 AM​