Importing bank transactions into Vega allows you to reconcile payments received through your bank account with existing payments or create new payment records.

During the import process, Vega attempts to automatically match each transaction to an existing contact or payment, helping reduce manual data entry and streamline reconciliation.

Important: Every imported transaction must be matched to an existing contact in Vega before it can be processed.

 

Supported Bank File Formats

Vega supports importing transaction files from the following banks:

• ANZ
• ASB
• BNZ
• Westpac

Note: ANZ Dishonour Files are imported using a separate process. Refer to Import ANZ Direct Debit Dishonours for further information.

Import a Bank File

1. Go to Money > Bank Transactions.

2. Click Import.

3. Select your bank from the Import Type drop-down list.
4. Click Import Transactions.

5. Browse to and select your bank transaction file.

If the selected file does not match the expected format for the chosen bank, Vega will display an error and the file will not be imported.

Review Imported Transactions

After the file has been uploaded, Vega displays each transaction in the Import view.

The screen identifies:

• Transactions that have been automatically matched.
• Contacts that have been matched.
• Transactions requiring manual matching.
• Existing payments that can be updated.

Review all unmatched transactions before creating a batch.

How Vega Matches Transactions

Vega automatically attempts to match imported transactions using one or more of the following:

• The payer's name from the bank file.
• The bank reference field.
• A Vega Contact ID stored in the bank reference.
• Previously saved Cross References.

If a transaction cannot be matched automatically, you can manually select the correct contact.

Tip: When you manually match a transaction, you can save the Cross Reference. Future imports containing the same bank details will then be matched automatically, reducing ongoing manual work.

Create a Batch

Once all required transactions have been matched:

1. Select the transactions you wish to process.
2. Clear the checkbox beside any transactions you do not want to include in the current batch.
3. Click Create Batch From Selected Transactions.

You can create multiple batches if different transactions require different financial coding.

Post the Batch

In the Create Batch window:

1. Select an existing Unposted Batch, or choose New to create a new batch.
2. Enter a Batch Code if creating a new batch.
3. Select the required:
   • Pay Type
   • GL Code
   • Campaign
   • Receipt Document
   • Send By
4. Click Post to Batch.

These settings will be applied to any new payments created during the import.

Note: If an imported transaction has been matched to an existing Vega payment, Vega will only update the Amount and Payment Date if they differ from the imported values. No new payment will be created.

If an existing payment belongs to a different unposted batch, Vega will move it to the batch selected during the import.

Complete Additional Imports

After posting the batch, any remaining transactions stay in the Import view.

This allows you to:

• Create additional batches.
• Apply different financial coding.

• Process the remaining transactions separately.