Using Excel for Bookkeeping

Posted by:

Excel is part of Microsoft Office’s productivity suite, a line of software that also includes programs such as Word, PowBook keepingerPoint and Outlook. Microsoft released its most recent version of Office — and Excel — in 2010. The Excel program gives you access to spreadsheets and all the tools you need to make computations therein. Excel’s spreadsheets are a good fit for bookkeepers looking for an easy-to-use software program for keeping track of their individual or a company’s finances.

We have prepared a Book keeping template that is really easy to use and calculates VAT and generates easy to understand and printable VAT Reports.
VAT Reports some full Annual Return of Trading details  and simple monthly summary.

Why not check out our Excel Book Keeping Spreadsheet.

  • Features
    • Can be easily adjusted for any future changes in VAT rates!!
    • No bookkeeping experience required, simply record sales, bankings & payments/expenses
    • VAT page will automatically calculate the VAT due for each quarter
    • The layout, formulas & also the ‘predictive text’ feature of Excel will help reduce the time you need to spend on record-keeping
    • Drop-down menus makes categorising expenses very quick & straightforward
    • No licence required – use year after year
    • Provides you with a cumulative detailed trading profit & loss account
    • Easy-to-use accounts spreadsheets includes instructions

Add a Comment

You must be logged in to post a comment.