Excel Spreadsheet for VAT Accounting?

Question

Hello,

I am setting up a VAT registered business. Can anyone help with finding a spreadsheet for me to do my basic accounts with?
I don't want to invest in Sage until I feel I need it.

Thanks in advance
Steve

EDIT: I know excel like the back of my hand, perhaps should have made that clear. Would just like somewhere where I can download a pre-formatted spreadsheet to use with excel.

Finances mean keeping away from anything with a price tag is essential.

Answer 1

I personally would recommend quickbooks, it's inexpensive and user friendly. All my clients using computerised systems use quickbooks. Or if you don't like the system there's some new software out called mind your own business that's quite straight forward, also excel, if you are familiar with the programme you won't need to use anything else.

I prefer manual accounts to be honest, get yourself a ledger book and a pen and away you go!!

Answer 2

I as a book keeper use Sage & Excell - for small business who are VAT Registered i set up spreadsheets on excell - 1 for all payments splitting them into colums with headings as a tax return shows what you claim for and VAT - 2 for all receipts net & VAT - and then a top one showing the overall figures - allmy clients are very happy with this and it makes the filling in of the tax returns easy. Hope this helps contact me if you want more help.

Answer 3

First invest in a basic Accounting Book or get it from the library Frank Woods is a very good author.
Then if you haven't already got a spreadsheet download open office its free and good enough for 99% of businesses.

Answer 4

If your operation is that small, all you need is a spreadsheet with with three columns to record income (positives) and expenditure (negatives):
Goods , Tax ,Total.
Then you can go in for analysis columns to any extent you feel like.
This can be refined to have income and expenditure in separate columns or on separate sheets, but you need to maintain it as a cashbook in order to reconcile to your bank statements.
You don't need to be an expert in excel to achieve this, it can be as extremely basic or as extensive as you feel like.
In any event, proper record keeping for Inland Revenue purposes is essential. Take proper professional advice before proceeding.

Answer 5

If you are in the UK, I would recommend getting in touch with Business Link: http://www.businesslink.gov.uk/bdotg/action/home?r.l1=1073858808&r.s=m Business Link is designed to help and give advice to small businesses for free.

Answer 6

In Excel, the overall function ignores clean cells. i'm not particular about Open workplace. you may attempt with the help of putting 2 in A1 and four in A3, and use the formula =average(A1:A100). If the reply is 3, then Open workplace ignores clean cells also. you may then in simple terms use the formula =average(E2:E14). edited to characteristic: attempt this formula (with somewhat of luck this is going to paintings with Open workplace) =AVERAGEIF(A1:A13;"<>"&"")