How to manually import transactions from a CSV file

If you’re unable to connect your bank account directly to the Good Numbers app, you may still be able to import your transactions manually using CSV files downloaded from your bank.

This doesn’t mean you’ll always need to import transactions manually. If your bank becomes available for direct connection later, we can help transition your organisation from manual imports to automatic bank feeds.

Before you begin

Manual transaction importing isn’t turned on by default.

Please contact the Good Numbers team if you’d like us to enable manual imports for your organisation.

You’ll also need to download a CSV file containing your transactions from your bank.

Step 1: Check which dates you need to export

Before downloading your CSV file, check the most recent transaction already showing in Good Numbers.

Go to the Transactions page and find the date of the newest transaction. Newest transactions are always shown at the top. Note: you may need to filter by Account if you have more than one.

When exporting your transactions from your bank:

• Set the from date to the day after the most recent transaction in Good Numbers.
• Set the to date to today.

For example, if the most recent transaction in Good Numbers is dated 20 June, export transactions beginning from 21 June. This helps prevent you from importing the same transactions twice.

Step 2: Start your import

Go to the Transactions page and click the purple Import Transactions button.

Select the bank you’re importing transactions from, then attach the CSV file you downloaded from your bank.

You can attach multiple CSV files for different bank accounts in one import. However, while you’re getting familiar with the process, we recommend importing:

• one file at a time; and
• one bank account at a time.

This makes it easier to understand where any duplicate transactions have come from.

Once you’ve selected your bank and attached your file, click Next.

Step 3: Review the import checks

Good Numbers will now run a few checks in the background.

The app will check:

• whether we already know about the bank account in the file; and
• whether any transactions in the file appear to already be in Good Numbers.

If duplicate transactions are found

Good Numbers will show you the transactions that appear to be duplicates.

In the example below, two duplicate transactions have been detected. Import without duplicates is selected so they won’t be imported again.

You can:

• Import potential duplicates, if you’re confident they aren’t duplicates; or
• Import without duplicates, and import the remaining transactions; or
• Cancel the import.

Take care when choosing to import possible duplicates. Once a transaction has been imported into Good Numbers, you can’t delete it yourself. This is intentional and helps protect the accuracy of your organisation’s financial records.

If you accidentally import a transaction, contact the Good Numbers team and we can remove it for you.

If no duplicates are found

You’ll see a confirmation showing how many transactions are ready to be imported.

Review the total and click Import.

Step 4: Update your bank balance

Once your transactions have been successfully imported, Good Numbers will ask whether you’d like to update the account balance.

Select Yes only when you’re importing the most recent transactions for the bank account.

Select No when you’re importing historical transactions. A balance you enter now wouldn’t represent the balance at the historical date of those transactions.

Once you’ve made your selection, the import is complete.

How Good Numbers calculates your bank balance

Not every bank includes a closing balance in its exported CSV files.

Where a closing balance isn’t available, Good Numbers attempts to calculate the balance using:

• the most recent balance recorded for the account; and
• the transactions you’ve imported.

If the balance shown in Good Numbers doesn’t match your internet banking, please contact the Good Numbers team and we’ll help get it sorted.

Step 5: Import complete

The import is now complete. Close this tab to return to the Good Numbers app. You will need to refresh the transactions page in the Good Numbers app to see your newly imported transactions.

Newly imported transactions will not have any suggested categories. Suggested categories are generated on a regular basis by the app. Come back later to see the suggested categories for these newly imported transactions, or assign the categories manually.

Importing a new bank account

Good Numbers will detect when you’re importing transactions for a bank account that hasn’t previously been added to your organisation.

In most cases, we identify the account number using information included in the CSV file:

• ASB and BNZ include the bank account number inside the CSV file.
• ANZ includes the bank account number in the CSV filename. Please don’t rename the file before importing it.
• Nelson Building Society doesn’t include the account number in its CSV file. Good Numbers will ask you to enter the account number during the import process.

You’ll need to add the new bank account before the import can continue.

If you’re prompted to add a new bank account but believe the account is already in Good Numbers, cancel the import. Contact the Good Numbers team and we’ll help you work out what has happened.