Setting up bank feeds in Jobpac for NAB

This article explains how to set up an automated bank feed from NAB into Jobpac so that bank statement data can be imported automatically for reconciliation.

Overview of the bank feed setup

Jobpac supports bank feeds using secure file transfer. For NAB, this is done through NAB Connect and a secure file transfer protocol (SFTP) connection.

The setup involves:

• asking NAB to configure your bank account for automated reporting via SFTP
• providing NAB with the required secure file transfer details
• notifying Jobpac when NAB has completed their configuration
• providing Jobpac with key WorkID, account and contact information so the import can be scheduled

Step 1 – Contact NAB to request a bank feed

First, contact your NAB bank representative and let them know that your business wants to automate the download of bank statement data for use with Jobpac.

Key points for this step:

• explain that you need automated reporting via SFTP for bank statement files
• if the bank representative is not familiar with Jobpac, ask them to involve a transaction banking specialist and NAB Connect support
• tell them the feed will be used by your accounting system to import statement data

If you want assistance when speaking with NAB or working through their forms, you can log a professional services request so a Jobpac consultant can guide you through the process.

Step 2 – NAB configuration and SFTP details

NAB will confirm whether your company is set up in your NAB Connect facility and whether it can receive reports through financial file transfer. They will then request additional information needed for the secure file transfer setup.

Typical information NAB may request includes:

• SFTP connection details
• file format and delivery options for the statement files
• company and account identifiers used in NAB Connect

If you have not engaged a Jobpac consultant and NAB asks for details you are unsure about, log a support ticket with Jobpac and include the list of requested information so support can assist.

Step 3 – NAB completes their setup

After NAB has the required information, they will complete the configuration on their side. When this is finished, NAB will send you an email confirming that your company has been set up for automated reporting.

Once you receive this confirmation:

• reply to your open Jobpac case or contact Jobpac support
• let them know that the NAB configuration is complete and you are ready for the Jobpac side of the setup

Jobpac will then complete the remaining configuration needed to accept the bank files via SFTP.

Step 4 – Provide Jobpac with WorkID, account and contact details

Once the link between NAB and Jobpac has been established, Jobpac support will need specific information to schedule the import of bank data.

Provide the following details to Jobpac:

• WorkID and bank account – confirm which WorkID and which cash account in Jobpac should receive the bank feed. You can find this in the cash account maintenance screen.
• Notification contact – confirm who should receive the daily bank statement email and any future error notifications, along with the correct email address.
• Start date for importing data – specify the date when automatic imports should begin. Make sure bank reconciliations are complete up to the day before this start date.

Clear information at this step helps Jobpac set up the import correctly for your environment.

Ongoing use and reconciliation

After the bank feed is configured and scheduled:

• daily bank statement files will be imported into Jobpac according to the agreed schedule
• the nominated contact will receive the daily statement notifications and any error messages
• you can use the imported bank data in bank reconciliation functions to match transactions and keep cash accounts up to date

Continue to reconcile regularly and investigate any errors or missing data promptly to keep your bank balances accurate.

Getting help

If you need help at any stage of the bank feed setup, you can:

• log a support ticket with Jobpac and include any information requested by NAB
• request professional services assistance if you want a consultant to manage the end to end setup with NAB and Jobpac

This ensures that both the NAB configuration and the Jobpac configuration are completed correctly and that your bank feed operates reliably.