Hi

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

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

Comments:

  • 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

Multi Currency Accounting

Posted by Philip Copeman on September 12, 2018 at 14:26 0 Comments

Is there a simple way to implement Multi Currency accounting?

Getting the best solution depends on your business conditions. Solutions vary from running multiple sets of books for each currency to using a single set f book with one reporting currency and converting every transaction at entry.

If you are confused, here is a good starting point by Peter Selinger…

Continue

Accounting Made Easy New Releases

Posted by Philip Copeman on May 28, 2018 at 16:30 0 Comments

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.

English…

Continue

VAT change from 14% to 15%

Posted by Philip Copeman on May 7, 2018 at 13:24 0 Comments

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.

PDF Explanation

TC-2018-VAT-CHANGE-OVER-Revision1.pdf…

Continue

I have a farm in Africa

Posted by Philip Copeman on April 21, 2018 at 19:27 0 Comments

... and then they want to take the land back without compensation? The idea is preposterous.
Land only has value if you can keep another African off it. Land only has value if you have complete tenure, right down to the freedom to dispose of the asset.
Naive attempts to directly tax the ownership of Land…
Continue

Events

Videos

  • Add Videos
  • View All

© 2018   Created by Philip Copeman.   Powered by

Badges  |  Report an Issue  |  Terms of Service