We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Excel Accounts spreadsheet

Options
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

Comments

  • http://www.openoffice.org/

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

    S&S x
    I'm a nutter :j
  • Pennywise
    Pennywise Posts: 13,468 Forumite
    Part of the Furniture 10,000 Posts Name Dropper
    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.
  • 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
    Warning ..... I'm a peri-menopausal axe-wielding maniac ;)
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.8K Banking & Borrowing
  • 253K Reduce Debt & Boost Income
  • 453.5K Spending & Discounts
  • 243.8K Work, Benefits & Business
  • 598.6K Mortgages, Homes & Bills
  • 176.8K Life & Family
  • 257.1K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.