Mudford, Yeovil, Somerset Telephone icon 01935 850807

image of computer screenExample of Excel/Visual Basic for Applications Projectimage of computer screen
Small Business Accounting Tool

Four Elms Bookkeeping's Small Business Accounting Tool is an Excel workbook whose standard functionality has been extended by incorporating thirty different Visual Basic for Applications (VBA) code modules and interactive forms. Each module providers an element of a dual entry bookkeeping system which includes the key functions and interfaces you would expect from a commercial accounts package. It was designed to avoids the need to purchase commercial software licences when preparing accounts for customers whose accounting transactions are relatively straightforward. The suite of VBA modules can connect to free open source database software for storing, backing up or retrieving accounting data as often as required.

Although its basis is a Microsoft Excel workbook no numbers are entered by the user into worksheet cells. Instead a series of buttons embedded in the worksheets activate input forms and run software modules written in the Visual Basic for Applications (VBA) programming language. The VBA code checks data input by the user for common errors before the software processes and posts them to the accounts. The Excel worksheets function mainly as displays for accounting data.

The accounting tool can be used with any of the following versions of Microsoft Excel: Excel 1997/2003, Excel 2007 or Excel 2010 and can be run with the Windows 7 and Windows 10 operating systems. The Visual Basic code behind the Excel worksheets applies a standard double entry bookkeeping system.

The VBA enhanced workbook provides the following features:

If your organisation could benefit from customised Excel workbooks, Visual Basic macros or other coded calculation tools, please contact Four Elms Bookkeeping to discuss your requirements.

Contact details

Example of another Excel/Visual Basic Project

Four Elms Bookkeeping home page

Proprietor: Richard Waggett B.Sc., Ph.D., MICB, CBDip.,Dip.PM

© 2016 Four Elms Bookkeeping