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 was designed for use with Microsoft Office as an accounting solution which avoids the need for special commercial software. It can connect to free open source database software for storing, backing up or retrieving accounting data as often as required.

Although accessed as 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 associated software written in the Visual Basic for Applications (VBA) programming language. This enables numbers input by the user to be checked for common errors before the software processes and posts them to the accounts. The user has minimal interaction with the Excel worksheets which function mainly as displays for accounting data.

The accounting tool uses one of the following versions of Microsoft Excel: Excel 1997/2003, Excel 2007 or Excel 2010. The Visual Basic code behind the Excel worksheets creates a standard double entry bookkeeping system.

The accounts tool includes the following:

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