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

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

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…

Continue

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…

Continue

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…

Continue

Events

Videos

  • Add Videos
  • View All

© 2017   Created by Philip Copeman.   Powered by

Badges  |  Report an Issue  |  Terms of Service