Bank Online
From TurboCASH Wiki
Contents |
Introduction
BankOnline is a Plugin that will enable a connection between TurboCASH and your Online Banking system. It uses the OFX and OFC Statements formats. It will import these into a file "bank.db" and this will enable you to import the Bank Transactions into TurboCASH batches. It simplifies take-on of your Bank Data.
To order this Plugin for R 300 ($50) go here:
http://www.turbocashtraining.co.za/os/
To get the email order form for the Plugin
http://www.turbocash.co.za/philip/tcashemailer/BankOnline.html
BankOnline should work with any Bank capable of generating OFC or OFX downloads for you. We confirm the following Banks work, and show you how to do it. For specific help on your Banking system, use these links:
| South Africa
|
 |
Minimum Requirements for Installation
- You must have TurboCASH 3.74.98, download or later installed.
- You must have the TurboCASH Online Banking Plugin installed into ..\tcash\plugins.
- This will happen automatically if you follow the default installation
- This will happen automatically if you follow the default installation
If you have the program properly installed it will appear under the tools menu.
If you are having problems getting to this point, please contact Razak Accounting. They will help you (at a charge) to configure your system. Please do not contact them unless you are happy to pay for the consultation.
Importing Your Data
- Download the OFC or OFX file from your Internet Banking System. Preferably into a subdirectory under your TurboCASH Books data.
- Run the plugin from the Tools Menu, you will get the screen below.
- Use the "Import option"
- If you have multiple bank accounts, make sure that it is correctly set. See the input box at the bottom of the screen.
- There is no need to save the data. Once you can see it on your screen, you already have it in TurboCASH.
Importing the Bank Data into Batches
- Open your Recon Screen
- Use the Show Statement Option to show your Bank Details
- Use Process > Transfer Transactions to Batches. All unreconciled items will be transferred to the Payments and Receipts batch. They will be marked as reconciled.
Tutorial
- Create a New Set of Books -Called BankTest
- Copy ..Bin\SAEngTutorial\HANDYMANB-SA
- Open BankTest
- Tools>Plugins>BankOnline
- Import the statement - browse ..\TCASH3\Bin\SAENGTutorial\Handybank.ofc
- Close the PLugin and Return the the Recon
- In the Recon click the upper Button "Show Statement"
- Reconcile Items
- Process>Transfer Unreconciled to Batches
- Leave Recon and go to Input> Batch Entry > Receipts or Payments
Correct Batches should be there.
Features wanted
- Move "Change Bank Account" into Left Hand Menu.
- Introduce themes into the system - It should be better to move the whole thing into Ettiene's new Framework - is that going to cause problems?
- Need a way to view the whole Bank file - highlight and filter and delete items. This should be based on Pieter's style of data view.
- We should compare bank and Ledger vertically.
- Current screen edit is weak. Need to be able to manually place an entry into the Bank file
- Reconcile Unreconcile is also weak should be a grid
- Reports should carry balance for the Bank file
- Should have black totals on the top like Pieter's system.
