Day Book

Design and implementation of bookkeeping package in Excel to manage client sole trader accounts and VAT returns.

Client did not wish to purchase off the shelf financial software; I therefore developed a very simple easy to use bookkeeping package within Excel. Client wished to manage their own books and VAT returns within package, this was extended to produce P&L and Balance Sheet and Self Assessment Individual Tax Return. Client very positive with package, information reviewed quarterly to ensure correct VAT treatment of supplier invoices. Package now used by other  sole trader clients, whom I tutor in the use of Excel. Feedback has been very positive.

“Excellent, simple and easy to use. It is so straight forward that I was comfortable using the file immediately.”