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: 229

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

The Case against Bitcoin

Posted by Philip Copeman on December 5, 2017 at 16:44 0 Comments

Will blockchain be enduring? – of course. Will Bitcoin be enduring? - not likely.

Unless you are familiar with the terminology of blockchain, having an argument about its future is like arguing with a physicist about the Big Bang. Right now the myopia caused by ignorance centres the crpyto discussion on Bitcoin, store of value and speculative demand. The real delivery of money, the medium of exchange and the unit of account that blockchain brings to anything from IOT…


Crypto Currencies

Posted by Philip Copeman on October 25, 2017 at 11:53 3 Comments

Economist Dawie Roodt takes the typical neoliberal line on Crypto Currencies. This would be the expected response of an economist who's salary depends on pleasing his big business bosses.

Dawie, Crypto Currencies are not some parochial kids idea, they stand somewhere between a new internet protocol and a digital pitch fork revolution.…


A glimpse of the future

Posted by Philip Copeman on September 7, 2017 at 15:30 0 Comments

Open source software and economic inequality

Posted by Philip Copeman on May 4, 2017 at 14:00 1 Comment

Open source software offers Governments the opportunities to build the knowledge economy and built it inclusively.

The World Economic Forum roadshow is back in town again. Economic experts on sponsored trips with generous expense accounts check into the beach front hotels amid fan fair and flashing cameras. They are offering us more advice than President Trump gets. Exotic terms like “inclusi…




  • Add Videos
  • View All

© 2017   Created by Philip Copeman.   Powered by

Badges  |  Report an Issue  |  Terms of Service