VAT Reporting Anomilies?

Following reconciliation of accounts, our Bookkeeper has concluded we have more money in our Bank Account than Actinic is reporting. What she has done is done is simply taken moneys from WorldPay and my Actinic VAT reports and the result shows that WorldPay has paid us considerably more than Actinic reports.

Being this appears to be a month on month issue, one theory we have is that Actinc is not reporting invoces that are VAT exclusive. The reason is that Actinc reports sales and VAT being 17.5% though we know this cannot be right as some 15% of sales will be non-vatable items. We have looked at supplier invocies and see that their sales to us are typically between 11% and 14%. So, something is amiss.

My question is, when one runs the Actinc sales/VAT report, can I assume it includes *all* sales, be they vataable or non-vatable?

Obviously this is not a good predicament as we cannot account for sales input, especially for VAT.

Can any one shed any light and I will be trying to further analise the reports by individual invoice this sunny Sunday

Cheers,
Mark

[cdicken]

I take it that the Worldpay figures are net - i.e. they include any refunds/chargebacks? Just a thought.

[m@rk.to]

Hi Chris,

Yes. Both Actinic and Worldpay are showing gross figures including VAT and refunds where applicable.

One issue I am also aware of and indeed, this is to do with refunds. It appears that when you make a refund with Actinic, it *amends* the original order and the date of the original order. I am told this is an incorrect accounting practice and has caused confusion in the past, beit Worldpay will reflect the change _today_, while Actinic reports the refund in the past. Of course, when one closes a month, one needs to run another sales report for last month, being the refunds.

I did wonder if this was the problem, but as error represents some 8% of sales, it can't be refunds.

I'm still confused.

[cdicken]

I'm still confused.

You and me both. I'm afraid I know almost nothing about tax and reporting in Actinic so I can't really help. Unless there are some reporting experts out here somewhere (Jan?) I suggest you refer this question to our email support team at http://www.actinic.co.uk/support/register.htm

[m@rk.to]

Our VAT inspection went well today. What was highlighted is that in our past 4 quarterly returns, we have paid 100% VAT. The problem is, in the two previous quaters, it was more like 92% which would be correct, being that some of our sales are zero rated. Thinking aloud, was there a version upgrade or change some 15 months ago which may have changed the reporting?

[cdicken]

No - there has not been a change in this area for a few years now. Has there been any change to the tax settings in your copy of Actinic e.g. switching from 'Simple' to 'Advanced' or taking away tax exemption for EU countries etc.

[PAULNEEDHAM]

Mark,

I'd like to compare notes on a few Actinic/VAT issues, would you mind forwarding your email address to me ?

paul@pazyryk.co.uk

Thanks,

Paul

[Jan]

I can't help out with this one because the tax report uses preprocessed data that is generated by the application when the report is run - I have checked the report and both pending and completed orders are included, the totals seem to be correct, changes are taken into advance.

Have you purged any orders? If you have then they wouldn't be included in the summary report, also check the dates that you are using, the report work on the date the the order was placed (I think) which might be different to the date that you processed the order.

Regards,