Multi-Currency Cash Book in Excel

The client, an midsized English engineering group, asked us to develop a multi currency cash book for their group of companies.

Features:

  • The application should replace a number of paper based manual cash books.
  • We developed the application using only Excel VBA.
  • Within the tool the use is able to store and account for all cash transactions.
  • We have built an interface to the existing accounting system to get up-to-date customer and supplier references and chart of accounts.
  • we have provided the client with an easy to use Bank reconciliation facility.
  • Intercompany transactions played a significant role and we were able to automatically do inter company transactions in both ledgers without double entry.
  • Reconciled months can be locked.
  • On client’s request, we designed miscellaneous reports and look up facilities.
  • We only used Excel tables as databases.
  • The application is password protected and can be used by multiple users.

If interested in our services, please contact us for a free quote.

Excel Software Solutions