# BankIT Process

<span class="ts15"><span class="ts0">The Bankit bank feed intelligence assist users to allocate general ledger accounts automatically before creating a cashbook.</span></span>

<span style="color: rgb(45, 194, 107);">**<span class="ts15">General Ledger&gt;Activity&gt;</span><span class="ts15">BankIt</span>**</span>

#### <span class="ts0">BankIT Flow chart</span>

<span class="ts0">Below is a chart of the process to complete bank transactions to cash book processing</span>

<span class="ts0"> </span>

![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3853).png)

---

#### <span class="ts0">BankIT Search</span>

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-01/scaled-1680-/cUNimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-01/cUNimage.png)

#### <span class="ts0">Buttons explained</span>

<table border="1" id="bkmrk-search-search-to-see" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 22.9836%;"></col><col style="width: 76.9917%;"></col></colgroup><tbody><tr><td>**Search**</td><td><span class="ts0">Search to see bank transactions (this is based on date and whether processed or not - default is No)</span></td></tr><tr><td>**<span class="ts0">Delete Bankit line</span>**</td><td><span class="ts0">This does not actually delete the line. The line is marked as deleted and records date and time the line was deleted and by whom. (use this to remove a duplicate imported bank line)</span></td></tr><tr><td>**<span class="ts0">Show Deleted Lines</span>**</td><td><span class="ts0">When ticked, the result of the search will only display the deleted lines for the selected bank, bank account and date range</span></td></tr><tr><td>**<span class="ts0">Import bank statement</span>**</td><td><span class="ts0">Import the bank statement from your bank</span></td></tr><tr><td>**<span class="ts0">Intelligence setup</span>**</td><td><span class="ts0">view all the bank intelligence rules setup including system and manual</span></td></tr><tr><td>**<span class="ts0">Apply intelligence to statement data</span>**</td><td><span class="ts0">run this utility to assign intelligence to the imported data</span></td></tr><tr><td>**<span class="ts0">Delete intelligence on this line</span>**</td><td><span class="ts0">if intelligence was incorrectly applied, delete the intelligence and re-apply</span></td></tr><tr><td>**<span class="ts0">Change bank account</span>**</td><td><span class="ts0">if you have imported the bank lines into the wrong bank account, select records and change to another bank account</span></td></tr></tbody></table>

![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(2777).png)

<table border="1" id="bkmrk-view-applied-intelli" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 24.4704%;"></col><col style="width: 75.5048%;"></col></colgroup><tbody><tr><td>**<span class="ts0">View Applied intelligence</span>**</td><td><span class="ts0">view the what intelligence was applied to the line. Change applied intelligence</span></td></tr><tr><td>**<span class="ts0">Export Bankit grid</span>**</td><td><span class="ts0">export all the data view on the grid to Excel</span></td></tr><tr><td>**<span class="ts0">Create cash book</span>**</td><td><span class="ts0">once the intelligence is applied, run the final step of creating a cash book</span></td></tr><tr><td>**<span class="ts0">Calc</span>**</td><td><span class="ts0">View the balances of bank imported data and cash book balance to give final total - match with actual bank statement balance</span></td></tr></tbody></table>

---

#### BankIt Import

<span class="ts0">After you have downloaded your bank statement into a CSV file, the data needs to be imported into the system</span>

<span class="ts0">The positive feature of Bankit is that the system remembers the original bank file format. This means that you can view past bank statement information.</span>

<table border="1" id="bkmrk-bank-select-your-ban" style="border-collapse: collapse; width: 100%; height: 59.2px;"><colgroup><col style="width: 21.2518%;"></col><col style="width: 78.7235%;"></col></colgroup><tbody><tr style="height: 29.6px;"><td style="height: 29.6px;">**Bank**</td><td style="height: 29.6px;"><span class="ts0">Select your bank</span></td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">**<span class="ts0">General Ledger bank accounts</span>**</td><td style="height: 29.6px;"><span class="ts0">select your bank account that you are importing</span></td></tr><tr><td>**<span class="ts0">File</span>**</td><td><span class="ts0">Find your file you downloaded.</span></td></tr></tbody></table>

<span class="ts0">Process will be to Upload file and then Import file.</span>

<p class="callout warning"><span class="ts0">NOTE: it is important to import into the correct GL bank account</span></p>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(747).png)

<span class="ts0">After import, data will be displayed</span>

<span class="ts0">Next step is to Apply Intelligence to statement data</span>

![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(748).png)

---

#### <span class="ts2">Apply Intelligence to the Bank Statement Data</span>

<span class="ts0">This is the screen where all the Rules that have been created are applied to the bank statement data.</span>

<span class="ts0">Click on Start to get the process going.</span>

<span class="ts0">Once the process had finished and the message appears "Completed Automatic Intelligence Allocation."</span>

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-05/scaled-1680-/b3simage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-05/b3simage.png)

<span class="ts0">Click on Ok and the grid will be populated with all the records that were not processed by the automatic intelligence allocation. Either double click on a selected line or click on the line and click on the Add Intelligence button. The Bank Rules Maintenance screen will appear.</span>

<span class="ts0">You can now apply a specific rule for this line using one of the four options and the appropriate parameter to ensure that in future this line will be satisfied by the rule that is being created.</span>

<span class="ts0">Select the applicable GL Account, and if the GL Account happens to be either the Debtors Control or Creditors Control then either a Debtor or Creditor must be selected in the appropriate dropdown.</span>

<span class="ts0">Enter the transaction description that will be used when these lines are promoted to a cash book.</span>

<span class="ts0">Once satisfied that the rule will handle this line click on Save / Save and Close. This rule will immediately be applied to the line on the grid and that line will disappear from the grid.</span>

<span class="ts0">If there are addition lines still on the grid that this new rule will apply to, Do Not Create another rule for the same condition. Simply click on Start button again and the process will run through the Apply Intelligence Process again and apply this rule to any lines to which it applies.</span>

<span class="ts0">This process should be repeated until all the lines have been satisfied with a rule and next time when new bank statement lines have been imported all these rules will be applied to the new lines.</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(750).png)

<span class="ts0">If there are lines on the grid that are a once off transaction and creating a rule for them would be a waste then these lines can be handled in one of two ways.</span>

<table border="1" id="bkmrk-1-either-use-the-def" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 6.09881%;"></col><col style="width: 94%;"></col></colgroup><tbody><tr><td>**1**</td><td><span class="ts0">Either use the default GL Account that is offered when the Create Cash Book button is clicked and there is a debit or credit GL Account to be selected there. These lines can then be edited again in the cash book to apply a different GL Account to it.</span></td></tr><tr><td>**2**</td><td><span class="ts0">Exit this screen to the Main BankIt screen click in the tick box Show Unapplied Lines and click on Search. This will display only those lines that were not satisfied by the </span><span class="ts0">Apply Intelligence Process</span></td></tr></tbody></table>

<span class="ts0">Either double click on a selected line or select a line and click on the View Applied Intelligence button. A screen will appear where a specific rule can be entered for this line i.e. GL Account, Debtor / Creditor (if applicable), Transaction, Region, Division and Project. This rule is not saved in the Rules Setup and is only ever applicable to this line.</span>

---

#### <span class="ts0">Manual Intelligence</span>

<span class="ts0">Check the intelligence applied, double click online to check intelligence and correct.</span>

<span class="ts0">or double click to add a manual intelligence WITHOUT adding to the intelligence rules.</span>

<span class="ts0">This could be a once off transaction which does not require a rule to be setup.</span>

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-05/scaled-1680-/3odimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-05/3odimage.png)

---

#### Blank lines intelligence

<span class="ts0">One does not have to allocate every line for Bankit, you can leave it blank.</span>

<span class="ts0">The system will automatically allocate to the default general account when processing to the cash book.</span>

<span class="ts0">This can be fixed at cash book level or will need to be fixed with a journal later on as it is allocated to a suspense account.</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(752).png)

---

#### Bank Payment information

<span class="ts0">Once Intelligence has been applied to the bank statement data.</span>

<span class="ts0">One can update the payment information that was setup against the creditor and payment ledger accounts.</span>

<span class="ts0">Payment information can be applied to both processed bank data and not processed data as long as intelligence has been applied.</span>

<span class="ts0">This information added, helps for reporting for BankIT Payments out.</span>

<span class="ts0">There are three functions that can be done on the lines</span>

<table border="1" id="bkmrk-1-update-payment-inf" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 5.68682%;"></col><col style="width: 94.2885%;"></col></colgroup><tbody><tr><td>**1**</td><td><span class="ts0">Update Payment information - This will check the bank statement line and if intelligence has been applied to the Creditor or GL account, it will update the default information that was setup in Creditors setup and GL accounts setup.</span></td></tr><tr><td>**2**</td><td><span class="ts0">Update CB Reference - Update Cashbook Reference on lines, Bulk update bank lines with the Cashbook reference. Future work will be to use this Cashbook reference to update actual cashbook</span></td></tr><tr><td>**3**</td><td><span class="ts0">Edit line after Intelligence and update payment information actions have run.</span></td></tr></tbody></table>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3852).png)

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-05/scaled-1680-/q2Aimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-05/q2Aimage.png)

---

#### Cashbook process from BankIt

<span class="ts0">When all intelligence has being applied, process the data to the cash book</span>

<span class="ts0">There are a couple of defaults that will populate the cash book screen so that you don't have to fill this in all the time.</span>

<span class="ts0">These defaults are found under the <span style="color: rgb(45, 194, 107);">**System Configuration Module &gt; Administration &gt; Defaults**</span></span>

<span class="ts0">The Cash book Name, description and reference will pick up from the last created cash book from the BankIt.</span>

<span class="ts0">Remember to change these when creating a new cash book</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(754).png)

<span class="ts0"> </span><span class="ts0">Defaults from System Configuration</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(755).png)

<p class="callout info">Cancelling a Cashbook will revert all BankIt information as unprocessed and will appear in your next process to cashbook function</p>