CRS Content Team
Import your bank transactions if you don't use Bank Feeds
If you enter transactions from your bank statements, you can save time by downloading your transactions from your bank and importing them directly into Cashmanager RURAL.
When can you import bank transactions?
It doesn't matter if you use the automated bank feed or manually download transactions from your bank website, and how often you do it is up to you.
Invoice Basis GST
We don't recommend you import bank transactions if you are registered as Invoice Basis for GST, as you will end up with duplicate transactions and the risk of double claiming items in your GST returns.
If you use the Cashmanager Direct Credit function for batch payments to your bank
You can still import bank transactions to bring in income, automatic payments, direct debits and bank fees. Just make sure the transaction date and amount initially entered into Cashmanager for expense items reflects what actually happened at the bank, this will help to minimise duplicate transactions.
REMEMBER: If you bank with ANZ, ASB, Rabobank or Westpac you can sign up for our automated Bank Feeds today. Find out more.
Set up Online Banking in your database
You only need to follow this step once, when you initially set up your online banking option.
From the transaction screen select Setup > Online Banking. This will make the Configure Online Banking box appear:
- Select your bank from the dropdown list.
- Choose to use the note from the bank or the default note from Cashmanager codes.
- Click OK.
TIP: The note imported from the bank includes information you entered such as the reference when making the payment.
Download your transactions from your bank
From your bank, you will be able to download your transaction file. This will be in a .csv or .qif file format. Ask your bank if you need help with downloading your transaction file.
NOTE: If you are an ANZ customer and previously used Direct Access to retrieve your transactions, have a look at our topic How to export transactions from ANZ.
Import transactions into your database
From the transaction screen select Import and then your bank.
This will bring up the Import screen. Search for the bank transaction file you saved to your computer by clicking on Browse.
Once you have selected the file, click Ok to move the transactions into the Load Bank Transaction screen.
The Load Bank Transaction Screen
- You can edit Other Party.
- You’ll need to code the transactions.
- If the transaction is for Stock it’s important to add Quantities.
- The note can be from the bank, as shown here, or a default code note.
Coding your bank transactions
Once you have imported the bank transactions, you can edit and add transaction details in the Load Bank Transaction screen. You will need to code all of the transactions before they can be moved into your transaction screen. Autocoding is a fast way to do this.
Want to know more?