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
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.
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
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....
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
Sign Upor Sign In
Posted by Philip Copeman on May 28, 2018 at 16:30
New releases for Accounting Made Easy with TurboCASH 5
This 400 page comprehensive Tutorial for TurbCASH 5 c overs basic accounting, TurboCASH features as well as a step by step tutorial to help you implement your accounting.
Posted by Philip Copeman on May 7, 2018 at 13:24
The Tax authorities may impose changes in the VAT (GST/Sales tax) rates. For example, in South Africa, the South African Revenue Services (SARS), changed the VAT rate from 14% to 15% on 1 April 2018.
Posted by Philip Copeman on April 21, 2018 at 19:27
Posted by Philip Copeman on December 30, 2017 at 8:41
You just want to make invoices and collect you money. Why are we so excited about bloackchain here at the TurboCASH Project?
If you are confused by all the terms and don't know what the fuss is about.try this simple explanation in a browser.
Added by Philip Copeman
© 2018 Created by Philip Copeman.
Report an Issue |
Terms of Service
Please check your browser settings or contact your system administrator.