Log in Register

Login to your account

Username *
Password *
Remember Me

Create an account

Fields marked with an asterisk (*) are required.
Name *
Username *
Password *
Verify password *
Email *
Verify email *
Captcha *

Bank Reconciliations Plugin

Article Index

Page 1 of 12

 Introduction to the Bank Import Plugin

Using this Bank Import Plug-in, you may import a valid bank statement file (downloaded from your online banking) saved on your system into a Bank Account (Cash-book).

This Bank Import Plugin will save you time, since you do not need to physically enter the transactions manually in the Payments Journal and Receipts Journal.

This plug-in uses Bank references to automatically allocate or link payments and deposits, receipts, other debits. credits, etc. to the correct accounts. 

It further supports the bank accounts of your debtors (customers / clients) to use the automatic receipts for debit orders, etc. 

It further supports the bank accounts of your creditors (suppliers) to use the automatic payments to manage the payments to suppliers, etc.

You may download bank statements for more than one bank account; credit card statements; etc.; provided that:

  • You are registered for online banking at your bank or financial institution.
  • Have a created separate Bank, Credit Card accounts, etc. which is linked to its own Payments and Receipt Journals).

Once you have imported your bank statement (downloaded and saved on your system), the transactions on your bank statement will be imported (by a few mouse clicks) into the Payments and Receipts batch of your bank account as follows:

  1. Debit transactions (payments, bank charges, interest payed, debit orders, electronic payments, etc.).
  2. Credit transactions (receipts, interest received, electronic payments (receipts), debit orders, etc.).

Once this is done; you need to do the following simple process:

  1. Select the Account code and Tax account; if applicable to a payments transaction.
  2. Select the Account code and Tax account; if applicable to a receipts transaction.

You may also use the Context menu to locate select and search for a specific transaction, debtor (customer), creditor (supplier), or a general ledger account.

If any debtor (customer), creditor (supplier), or a general ledger account is set as an open item account, you may link specific debit transactions to specific credit transactions (and vice versa); e.g.:

  1. Payment transactions – link to specific credit transactions (e.g. Purchase documents, Purchase Journal, etc.).
  2. Receipt transactions – link to specific debit transactions (e.g. Invoices, Sales Journal, etc.).

This will display the Outstanding amount for each transaction, etc.

You may also select and link a part of a payment / receipt and / or one payment / receipt to more than one outstanding transactions.

You may also link an account to a specific debtor (customer), creditor (supplier) or a general ledger account to allow the correct automatic linking (allocation (selection of accounts)) during the next bank statement import.

Purchase and Register the Plugin

Commercial - One time fee - or combined in a bundle of multi plug-ins.

Order trial of full version of then bankimport plug in

The Plugin is included in the TurboCASH / osFinancials installation file. Once the Plugin is purchased, n e-mail with the registration (activation) codes and instructions will be forwarded to you.

This Plug-in needs to be separately purchased and registered. Unregistered versions only allows a specific number of transactions to be imported and processed.