Integrated Contractor’s Administration and Accounting Tool in Excel

Our client for this project is a specialised accounting firm providing comprehensive professional services to freelance contractors and small companies. We were asked to create a comprehensive application that deals with all backoffice activities and automates as much as possible all the individual tasks related to their business. This resulted in a highly bespoke collection of applications, where a number of technologies were used. Is is mostly developed using Excel as the front end and Microsoft SQL server databases as the database.


  • Includes invoicing, accounting, VAT returns, cash book, debtor management and preparation of year end accounts
  • designed to handle thousands of contractors
  • Fully integrated, no double entries
  • Developed in Microsoft Excel (Excel VBA), using a variety of additional technologies
  • Microsoft SQL server databases using merge replication
  • Multiple reports
  • Password protection with different user levels
  • Multi – user and multi – site
  • Interfaces to and from other external systems
  • Integration with custom built CRM system
  • Automated accounts production
  • Linked with website for all client documents
  • Automated production of documents

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

Excel Software Solutions