We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
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

MissHester
Posts: 1 Newbie
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
Can anyone recommend and simple spreadsheet that I can access for free to work from?
Thanks
MissHester
0
Comments
-
http://www.openoffice.org/
Like Microsoft software, but free, and also includes capability to convert to pdf if necessary.
S&S xI'm a nutter :j0 -
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.0 -
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.
HTHWarning ..... I'm a peri-menopausal axe-wielding maniac0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

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