I want to know if anyone had bulk posted from excel to Turbo Cash. For example, download bank statements to excel and just add posting codes and period and imported to Turbo Cash.

Help anyone. Thanks

Views: 198

Comment by Philip Copeman on January 4, 2015 at 11:58

Yes I do that. I manage 18 Bnaks acocutns with a Turbover of $10 M in TurboCASH doing just that. Doanload the bank statments, reform in Open Office an importinto TurboCASH.

If this si too mcuh fro you rthere are a numebr of vendors of Bank plugins that wil lautomate thsi fro you.

Comment by Retief Kotze on January 19, 2015 at 21:17

Yes, I've written my own Excel-file with macro to open the bank-export (csv), and reformat into correct columns for batch import (via Process-button / Import delimited file).

The layout you need is as follows: (TAB-delimited)

Refernce !  Date(dd/mm/yyyy)  !  Decscription  !  MainAccCode  ! Contr-acc  !  TaxAccount  ! Amount(Inclusive)  !  FALSE


  • Date has to be in format of "dd/mmm/yyyy". Watch the format when exporting from Excel, as Excel can display (format) differently for underlying value.
  • MainAccCode: This is the account-code for the account where the amount is going to, e.g. expense or Creditor or Debtor.  Code is started with 'G' for General Ledger, 'D' for Debtors and 'C' for Creditors, followed by the number-system you have,e.g. G302-000 for "Bank charges (direct expense), or D100-000 for Debtor account.
    • If you're posting a 'Purchase journal', this will be the Creditor account
    • If you're posting a 'Sales journal', this will be the Debtor's accountcode
  • Contra-Acc will be the bank-account you're posting for, and will be the same for all trs in this batch.
    • If you're posting a 'Purchase journal', this will be the expense or stock acc.
    • If you're posting a 'Sales journal' this will be the income-acc (I advise sales to be done via the Documents-invoices route - there is less chance of things going wrong on a regular basis.....
  • TaxAccount: This will be your VAT/GST code, depending whether the transaction falls within the ambit of the VAT/GST legislation, otherwise leave empty.  Taxcode to be differentiated between Input or Output where applicable.
  • Amount: Positive = Debit, negative = Credit
  • Last field: contains the value 'FALSE' - never been able to figure out what the field is used for. I always just put a 'FALSE' in and proceed.  (on all exports of batches in my research to figure out the layout, the output was always 'False' in this field....)

The macro then assigns the correct (?) account-code and tax-account, based on the description in the transaction provided by the bank.

Now you can import the batch-file, peruse it it before posting to correct any mistakes, and then 'post'.

I've personally struggled over the years with the various bank-imports and activation thereof, and SA-banks don't seem to export the the same OXF-format that the european banks do, and therefor the import that Pieter wrote for osFinancials sisn't seem to work for me (last checked 18 to 20 moths ago).  Even between SA_banks there is difference in OXF(?)-layout.

I therfore adapt my excel-file to each bank, and make it personally applicable to each client (or separate bank-account).

Next challenge is to have client payments allocated on basis of invoice-nr or client-code given in description-field....not always the same as clients can put in anything while paying me....

Comment by Philip Copeman on January 20, 2015 at 12:32

This is interesting to me, because I also come up against this. David Lees has written a plugin that does the same for SA Banks, but I am not sure that these programs actually shorten this process.

I would prefer this process to be part of the mainstream of open source TurboCASH.

Add a Comment

You need to be a member of turbocash to add comments!

Join turbocash

Blog Posts

There Are As Various Kinds Of Grass As Flowers

Posted by Kirsten Sue on December 19, 2016 at 17:50 0 Comments

CSA is Community Supported Agriculture, that is far more fresh produce. It is actually opportunity to participate a great environment that provides sustainably grown manufacture and to ascertain additional concerning the community and ecology that provides these merchandise for u . s citizens.

Your first phase to having an excellent six packs diet is counting your calorie absorption. You can download an excellent calorie counter on the online world. Once you do this…


TurboCASH Subscription December

Posted by Philip Copeman on December 7, 2016 at 0:04 0 Comments

If you would like to get the maximum out of TurboCASH Accounting and your Windows 10 PC, sign on for the TurboCASH 5 subscription at $60 per year. The new version makes it a whole lot easier to run a paperless office using PDF filing, Accounting Made Easy is included. Spend a few hours on improving your understanding of finance this month and start the new year with a boost.

Buy N…


How Trump beat his taxes.

Posted by Philip Copeman on November 15, 2016 at 11:30 4 Comments

 Unless you have been under a rock for the last 6 months, you must have followed how President Elect Donald Trump avoided income tax over the last few years. He did this by using Depreciation!

Its all legal of course and most Governments offer you this…


Interesting Facts About Reviews of Essay Writing Service

Posted by JamesDegarmo on November 2, 2016 at 12:05 0 Comments

An essay paper is an impression of one's identity. It gives a knowledge into an individual's capacity to express. It gives the readers a thought regarding the individual's disposition, inclination and vision. The knowledge about essay composition is an important parameter as it measures the understanding levels of the writer; more so in case of based on fact topics. There are several professional writers and their explanation…




  • Add Videos
  • View All

© 2017   Created by Philip Copeman.   Powered by

Badges  |  Report an Issue  |  Terms of Service