FOUR ELMS BOOKKEEPING

Examples of Excel/Visual Basic Coding Projects

Small Business Accounts Tool

Accounting tool for small businesses. Includes a general ledger, profit and loss account, balance sheet sales ledger and purchase ledger as well as calculating the figures for VAT returns.

Payroll Calculation Tool for Small Businesses

This payroll utility was designed for a small business with fewer than 10 employees who use HMRC's Basic PAYE tool to submit PAYE data to HMRC. This tool calculates monthly or weekly wages, National Insurance, PAYE tax, student loan and other deductions as well as statutory benefits. Payslip data is generated for each employee.

Creation of Report running Utility for a large SQL Server Database

This utility came with over 300 bespoke SQL reports written specially for the database.

Provision of a form based input system for a Library loans system.

Included in the utility were several bespoke forms for user input which included a variety of data validation.