|Table of Contents|
Bank feeds for Jiwa are implemented via a plugin. The bank feed relies on an active Xero subscription, which has been configured with your bank accounts.
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, it expected 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.
Whilst not completely automated, it does reduce the effort required to key transactions and will eliminate some keying errors, making the task of performing cash book entries more efficient and accurate.
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
Add API App
From the Xero developer portal, select the "My Apps" tab, then OAuth 2.0 apps then select the "New App" button:
The Add new App dialog then appears - Enter a name (eg: "Jiwa 7 Bank Feed") and select the Mobile or desktop app integration type:
Scroll down the dialog and enter the Company or application URL (this can be anything) and a OAuth 2.0 redirect URI - use http://localhost:8888/callback. The port can be changed, but it must be localhost and not https - if you change this value you will need to note this for entry later into a system setting. Check the "I have read and agree to the..." checkbox and press the Create App button.
Once the App is created, the App Details dialog appears
The Client id and OAuth 2.0 redirect URI will be need to be provided in some System Settings in Jiwa once the Jiwa plugin is imported.
Import the "Bank Feed" Plugin.
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
Configure System Settings
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, Redirect URI from the Xero App Details
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 Set Bank Details dialog (erroneously captioned "Cheque Numbers"), set the BSBN and Account Number of the desired bank accounts
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.
Note the From and To date when not within the same general ledger period will cause the activation of the cash book batch to either produce an errored journal set, or abort the activation.
It is advised to set the To date to be within the same general ledger period of the From date.
Pressing the OK button on the dialog will cause a browser to open 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.
The user should check that no transactions have been duplicated or omitted on a regular basis until they are comfortable with the accuracy of the import. At this time when importing to Cash Book Payments, there is no check to ignore transactions created on a Creditor EFT/Cheque payment batch - so these transactions may appear when importing to the Cash Book Payment batch, and should be removed from the batch by deleting them.
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|
|Spend / Received||Home Amount|