Overview:
- Set up bank feeds for your bank account in Wiise
- Set up your bank account in Wiise
- Set up reconciliation frequency for your linked bank accounts
Note: Users assigned a Business Manager role or Accountant role can see the Bank Account cue card in the Wiise Insights section in the Wiise landing page.
You must be set up as a Banking Officer to use Wiise Bank Feeds.
Reach out to your IT Service Provider or Solutions Partner to enable your access.
Why set up bank feeds?
A bank feed is a list of transactions from your bank account that links directly into Wiise through a data feed. By setting up automated bank feeds, you no longer need to manually download bank statements from your online banking and import them into Wiise.
Wiise relies on ACSISS Data Services (ACSISS) a third-party data aggregator, to collect transaction data from many Australian financial institutions and make it available to Wiise.
Bank feeds include all transactions, including payments, cash receipts, fees & interest. These transactions are automatically downloaded into Wiise each day. You can set up a Bank Account Reconciliation or Payment Reconciliation Journal for matching, posting and reconciling your bank accounts.
Note: Bank transaction feeds are updated each morning at 9am with data from the previous day. There is a second check at 1pm for any delayed data that missed the 9am feed.
Which bank accounts support bank feeds?
- As many as twelve Australian financial institutions currently support bank feeds.
- If your account isn't eligible for direct feed, manually import your bank statements.
If you’re unsure whether you can set up a bank feed from your bank, reach out to Wiise Support and we’ll check for you. You'll find more details about eligibility at the ACSISS website.
Note: The list of all supported bank transaction feeds are updated each morning at 9am with data from the previous day. There is a second check at 1pm for any delayed data that missed the 9am feed.
Note: Credit Cards are not supported by SISS. These will need to be manually imported.
How to set up bank feeds?
The process to register your bank feed should take between 5-10 business days. Here’s what you need to do to get started:
- Select Bank Accounts from your landing page menu or search for it using the search at the top right-hand corner.
- Select the bank account from the list page by selecting the hyperlinked row in the No. Column to edit the bank account. Alternatively, select the vertical three dots on the row of your bank account between the No. column and Name column.
- Then, select Edit in the drop-down menu.
- You’d need to set up a bank account if the bank account is not available in your bank account list.
How to set up a new bank account?
- First, select Bank Accounts from your landing page menu or search for it using the search at the top right-hand corner.
- Select New and a new Bank Account Card will be opened. There are 5 sections (FastTabs) on this bank account card.
Tip: You can select Show more at the top right-hand corner of the general section to see all the fields. - Under the General section, complete all the details of the new bank account that you are setting up.
- General section: The No. field is mandatory and will populate automatically as you start to fill out the Name of the bank account. It is a reference for your bank account. Fill in the other necessary fields.
- The Bank Branch No. field is required for keeping records and when you set up your bank feeds.
- The Bank Account No. field is required with your Bank Branch No. field for keeping records and when you set up your bank feeds.
- The Blocked toggle is to be left unselected to allow post transactions to take place. Hover over the field to read the description.
- To make the bank account the default for sales and service documents, turn on the Use as Default for Currency toggle. This helps you save time on data entry.
- General section: The No. field is mandatory and will populate automatically as you start to fill out the Name of the bank account. It is a reference for your bank account. Fill in the other necessary fields.
- The Bank Statement Service section is used when a bank feed is registered with the bank account. Set up your bank feeds refers to how to register your bank account for automated bank feeds.
- The Communication section is used to record the contact details of the bank account.
- The Posting section is important to update when you’re posting transactions for the bank account.
- The Currency Code field refers to the type of currency you select for the bank account. If all transactions in the bank account are in the local currency (LCY) for the current company, leave the currency code blank. If not, specify a currency code by selecting the drop-down arrow on the currency code field.
- The Bank Acc. Posting Group field is a setup that determines the G/L account into which the bank transactions will be posted for this bank account.
- By selecting the drop-down arrow, you can select the pre-populated posting group. To see the full list, select the link ‘Select from full list’.
- The Last Statement No. and Last Payment Statement No fields will automatically populate when a payment reconciliation or bank reconciliation process is run.
Note: When you create a new bank account, you can reuse an existing bank posting group. Bank transactions will be posted to the same general ledger accounts as other bank accounts sharing that bank posting group.
- The Transfer section relates to the import and export of bank feeds and files.
- Your bank account has been set up now. You can use your bank accounts to keep track of your banking transactions.
Note: To process EFT payments, you’ll need to set up your bank accounts in Wiise. You’ll need to set up your bank account details, payment settings, vendor remittance information, and EFT export format details.
Note: You'll need to set up a Direct Debit facility with your bank before you can process Direct Debit payments. Direct Debit lets you collect money directly from your customers' nominated bank accounts.
Continue with the set up of your bank feeds
- Select the Bank Statement Service menu and from the drop down, select Register Account.
Note: If the Register Account menu item doesn’t appear then your Bank Branch No. (BSB) isn’t supported for bank feeds. Re-check your bank details to make sure your BSB and Bank Account No. are correct.
Note: If you have any issues at this point, please reach out to Wiise Support so we can check with ACSISS for you. - Once you’ve selected the Register Account, a partially completed PDF form will be generated for you to download and save it to your PC. The form would have partially completed details from the creation of your bank account.
- The registration process varies by bank. For some, you’ll need to complete and sign the PDF form and return it to ACSISS, while with some banks you can complete an online process to activate your feed.
- SISS will contact your bank to set up the data feed and check the authority on the account.
Note: Please make sure to include the signatures of all signatories who are registered for the business bank accounts on the registration form. It's important to ensure that all necessary parties have authorised the registration process. - When ACSISS registers your data feed successfully, your Bank Feed Status will show an Active status and transaction data should start showing on the Bank Feed Entries screen within 24 hours.
- Go to your Bank Account Card and select Bank Statement Service.
- Select Bank Feed Entries. You’ll see a list of transactions imported from SISS for this bank account.
Note: During the bank feed registration process, you can check the Bank Feed status of your bank account to track the progress. - Go to your Bank Account Card and select Bank Statement Service.
- You’re done. If you see the Bank Feed Status of your bank account as Active, you’ll be able to see your active daily bank feed entries in Wiise within 24 hours.
How to link your bank accounts to use Wiise bank feeds?
- Select Linked Bank Accounts from the menu on your Wiise landing page.
Note: The bank feeds that are linked to a bank account in Wiise will display a bank account code in the Wiise Bank Account column. - Select Edit List to update the fields.
- Select the row you want to link the bank account.
- Then, select the field Wiise Bank Account and use the drop-down to select the bank account code.
Note: If the bank account does not exist, set up a new bank account before you can link the bank feed. - Select the drop-down menu in Reconciliation Type. Here are the options:
- Bank Reconciliation: when you select this option, imported transactions are linked with a Bank Account Reconciliation. This is the default option.
- Payment Reconciliation: when you select this option, imported transactions are linked with Payment Reconciliation Journals.
- Select the drop-down menu in Reconciliation Frequency. Here are the options:
- Automatic Daily: imported transactions are added to a new reconciliation for processing each day.
Note: You may end up with multiple outstanding reconciliations if you don't process imported transactions daily. - Automatic Single Reconciliation: imported transactions are added to an existing open reconciliation. If none exists, a new one is created.
- Manual Import: no reconciliations will be created automatically, and transactions will not be linked.
Note: By default, when you first set up your bank account feed, your reconciliation frequency is set to Manual Import. You'll need to import bank transactions of your unposted reconciliations by selecting Import Wiise Bank Feeds on the Linked Bank Accounts page.
Note: If you want to see a history of all imported linked bank transactions, select Transactions on the Linked Bank Accounts page.
- Automatic Daily: imported transactions are added to a new reconciliation for processing each day.
- You’ve now linked your bank account to your Wiise bank feeds.
What's next?
Now you know how bank feeds work, you’re ready to reconcile your bank account via the bank account reconciliation or payment reconciliation journals.
Need more help?
No problem, that's what we're here for. Reach out to support@wiise.com anytime you can't find what you're looking for.