Bank Feeds
- Julie Hanlon
About
Bank feeds for Jiwa are implemented via a plugin. This plugin is provided here by Jiwa Financials free of charge. The bank feed relies on an active Xero subscription, which has been configured with your bank accounts. The base level Xero subscription is all that’s necessary. At the time of publication the base subscription is called ‘Ignite’ for $35 per month. If you have an existing/higher subscription, say for your payroll, that can be used for the Bank Feed. You don’t need to create a new Xero subscription in that case.
The plugin simply adds a tool button to the Cash Book Receipts and Payments forms "Bank Feed". Clicking this tool button will retrieve transactions from the Xero Bank Statement report into the current Cash Book batch.
Once transactions are imported, the user will select the debtor, creditor or general ledger account associated with the transaction based on the reference, date and amount of the transaction - and if desired allocate the transaction to an existing debtor or creditor transaction as appropriate.
The Jiwa Bank Feed reduces the effort required to key transactions and will eliminate some keying errors, making the task of performing cash book entries more efficient and accurate.
Configuring Xero
The following steps need to be followed to configure Xero in preparation for integration with Jiwa.
Add Bank Account
From the Bank Accounts within Xero, select "Add Bank Account"
Then follow the prompts to add the Bank Account
Configuring Jiwa
Import Plugin
Import the "Bank Feed" Plugin.
Remove previous versions
If you have imported an older version of the Bank Feed plugin which used OAuth 1.0 - whether it was named "Xero Cashbook Import" or "Bank Feeds" then you must delete that plugin before importing the current one.
Plugin for 07.02.01
Plugin for 08.00.00 or later
Microsoft Edge WebView 2 runtime
Note: This plugin requires the Microsoft Edge WebView2 runtime, version 97.0.1072.76. Some machines may have this pre-requisite already installed, some may not.
In an RDP setting, make sure you install with elevated credentials (ie, Run as administrator) so that it applies to all users, not just the logged in user.
Obtain the Microsoft Edge WebView2 runtime from https://developer.microsoft.com/en-us/microsoft-edge/webview2/ if you experience issues.
Configure System Settings
The Bank Feed plugin requires a ClientID from a Xero API App. Please log a ticket with the Jiwa Help Desk and you will be provided with a ClientID.
Save the plugin, and exit Jiwa and log back in. Open the System configuration form and select the "Bank Feeds" tab. Enter the Client Id as provided by Jiwa and Redirect URI http://localhost:8888/callback
Set Bank Account Information
In order for Jiwa to be able to associate a Jiwa Bank ledger with the bank account in Xero, the BSBN and Account Number needs to be set for Bank accounts via the Bank Details dialog of the Creditor Cheque/EFT Payments form. The Creditor Cheque/EFT Payments form is not used in the Xero bank feed integration, but this form is the only place where the bank BSBN and Account numbers can be set.
Open the Creditor Cheque/EFT Payments form
Select the Utilities Tab
In the Other group, select the Other drop-down and choose Set Bank Details
In the Bank Details dialog, set the BSBN and Account Number of the desired bank accounts. For credit card, we’ve entered the last 4 digits of the card which is all that appears in Xero
Using the Bank Feed
As Xero only fetches transactions from your bank once per day, it may take up to 24 hours for any transactions to be available for import.
The times feeds are fetched by Xero for each bank or other financial institution can be found on the Xero Direct Feeds page.
The Cash Book Receipts and Cash Book Payments from will have a new tool in the Actions group of the Main tab - "Bank Feed"
You can only use this tool on unactivated cash book batches once the Bank ledger is chosen. When pressed, a dialog will appear prompting a date range to be entered.
The From Date is automatically set to the most recent Cash book transaction date for that bank account and batch type (receipt or payment). The To Date will always be set to the current day.
Pressing the OK button on the dialog will cause a dialog to open with an embedded web browser to authenticate and approve the access from Jiwa to the Xero API. Login (if required - will depend on browser cookies and if any previous login was attempted and successful), and then press the Allow access button to continue.
After allowing access, the bank transactions within the date range will be imported, excluding any transactions imported on the current or previous batches, and a completion summary dialog shown.
Transactions will be ignored if there is a previous Cash Book batch of the same type (Receipt or Payment) for the same bank account, with the same date, amount and reference.
At the conclusion of the import, the user should set either the Debtor, Creditor or general ledger account for each Cash Book Transaction. Also, if desired the user - in the case of debtor or creditor transactions - can allocate the amount to the debtor invoice or creditor invoice.
Transactions imported will have the following fields set:
Xero Bank Statement Field | Jiwa Cash Book Transaction Field |
|---|---|
Date | Date |
Payee | Reference |
Spend / Received | Home Amount |