How to Add Vat

[PaulB]

Hi All,

I purchased one of Peters business plan products and have found it really good. Have come a little un-stuck on the spreadsheets though and wondered if anyone could help. I completed the forecasts etc and everything looked ok but the people who are evaluating the plan sent it back because I had allowed for VAT. But this is what I'm stuck on, the P&l produces the figures for the cashflow forecast, obviously I don't include Vat in the P&L figures so how does the Cashflow forecast update to allow for VAT. Surely if I go in and manually update the figures in Cashflow it throws everything out. Can't afford an accountant to do this for me so I need to get my head around it. Hope someone can help.

Paul

[PaulB]

Sorry that should have said "hadn't allowed for VAT"

PaUL

[peterjhale]

What did these people say ?

The VAT is automatically calculated.

It's worked out - excluded from the P&L because it shouldnt be there and paid each quarter. There'll be a creditor in the Balance Sheet for those months you are accruing to pay it.

If you're not registered for VAT, simply make the VAT amount (where it is 17.5%) as zero

[PaulB]

Hi Peter,

Many thanks for your reply but still can't see it. In the cashflow forecast I have there are no formulas that work this out on a quarterly basis or monthly. For instance, the total cost cell for each month in the P&L is the total costs nett of VAT. So in my case the figure in month one is £5558, if I look at the cashflow forecast figure for that month "costs instant" it pulls in this figure, but this is not the amount from a cashflow point of view that I am actually paying out because some things like stationary and advertising will have VAT added on, so the cashflow is only reflecting the amount in the P&l. Also I see no formulas the quarterly payment etc.

Paul