The client, an midsized English engineering group, asked us to develop a multi currency cash book for their group of companies.
- 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
- Data Mapping Tool
- Day Trader Analysis Tool
- Integrated Contractor’s Administration and Accounting Tool in Excel
- Investment Portfolio Recommendation Tool
- Management Reporting Tool
- Payroll and Personnel Costs Planning Tool
- Quotation Tool using Excel VBA
- Sales Forecasting Tool
- Upgrade to New Excel Versions
- Workflow Automation For Personnel Planning