Anyone have ideas on implementing multi currency in TurboCASH Accounting?

Each time I look at this it becomes more complex. I have been fight "bloat" in TurboCASH for 30 years. The last thing we want is more complexity.

The best I have so far is keeping a separate set of books for each currency and making journal entries when required!

This problem is going to get more complex as we try to deal with crypto currencies and hyper ledger. We have some time to breath at the moment, but if we stand still this will engulf us.

If you have strong ideas on solving this please join the group

http://turbocash.ning.com/group/consultants

All contributions welcome.

Views: 26

Replies to This Discussion

I haven't used TurboCASH in a while but have administered/implemented multi-currency accounting
systems in the distant past and as a result the following are just some initial thoughts. Apologies for any non-TurboCASH terms used.

Whilst I appreciate the desire to avoid more complexity. Moving from single currency to multi-currency adds complexity by it's nature. The choice is between absorbing the complexity within
the system or loading it on to the user. The more currencies used and the greater frequency of
transactions with different currencies then the more desirable it is that the system handles it.

A key requirement is the ability to record transactions in a number of currencies whilst enabling
reporting to be made in a reporting currency. Typically purchases could be made in a number of
currencies dependent on the national diversity of the supply chain whilst sales are likely to be
made in a smaller number of currencies. So the Purchase Ledger staff may want to see the creditors on
a real-time basis in the currency owed whist the Accounting staff might well want to see the total
value of the creditors in the 'reporting' currency at the end of the period.

Each transaction, therefore, has a 'Transaction Currency' and a 'System Currency' and corresponding
values. The system needs to hold different Transaction Currencies and an exchange rate between each
Transaction Currency and the System Currency applicable on a particular date. Local purchases would
have the same currency and values for both Transaction and System.

It wouldn't be practical to update the exchange rates on a real-time basis and so a more manageable
practice could be to use the exchange rates at the close of business on the final day of the accounting period. These exchange rates could be used for the following month's transactions. At the end of the period it would be necessary to revalue all currency items to the new rate to recognise the new value of the asset or liability. The other side of the transaction would be to an account that holds 'unrealised' currency revaluation adjustments. Differences in values received/paid on the liquidation of assets and liabilities would be to an account to hold 'realised currency adjustments'.

I've only skated the surface and what detail included is for illustration purposes.

Thanks for the answer.

TurboCASH has a really simply export and import of transactions, so this could easily be implemented in two or  sets of books running simultaneosly over the same periods.

This is how I currently run these situations and like you said it gets complicated.

This way allows those that don't have multi currecy problems to use TurboCASH without ever having to worry about it.

1) The books carry the same chart of accounts.

2) bank accounts, debtors and creditors are grouped  by currency. in each set of books.

3) at what ever period required for reporting the batches are exported, multiplied by the exchange rate of choice and reposted.

4) Any  cross currency transactions - invoices in one currency, received in another are - corrected with a n journal to gain or loss on forex.

The question is do we bring it directly into TurboCASH or not? The data base is designed to accept multi currency, but structuring the reports would be really complex.

RSS

Blog Posts

Blockchain Explained

Posted by Philip Copeman on December 30, 2017 at 8:41 1 Comment

Why blockchaine?

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.

https://anders.com/blockchain/…

Continue

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…

Continue

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.…

Continue

A glimpse of the future

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

Events

Videos

  • Add Videos
  • View All

© 2018   Created by Philip Copeman.   Powered by

Badges  |  Report an Issue  |  Terms of Service