Excel Accounts spreadsheet

MissHester

I have recently become self employed and I need to create an income and expenses spread sheet for my accountant.

Can anyone recommend and simple spreadsheet that I can access for free to work from?

Thanks
MissHester

skintandsad

http://www.openoffice.org/

Like Microsoft software, but free, and also includes capability to convert to pdf if necessary.

S&S x

Pennywise

Has your accountant asked you to do your books on a spreadsheet? Have they told you exactly what format, i.e. what columns, how much detail, etc? Most accountants have their own "templates" and hand them out to clients to fill in. There's no point in trying to write your own only to find that you're not giving the accountant the information they need in the right format.

You should really be asking the accountant this question otherwise you could end up wasting a lot of time, and then paying higher accountancy fees if you've not done it right as your accountant will take longer to sort it out.

Debt_Free_Chick

Ideally, you need a cash book analysis so that each row refers to one item (receipt or payment) and then the columns split (or "analyse") the item between VAT and the type e.g. if a payment for electricity, the analysis would show the VAT in the VAT column and the net charge for electricity under the "Heat, Light & Power" column. The columns you need are derived from the headings on your Profit & Loss account and your Balance Sheet.

If you simply want "tax" accounts to do your tax return, look at the Self Assessment form for the self employed and use the HMRC headings for your cashbook analysis.

HTH