Share this content
0
1373

Absolute Excel VAT Filer

Has anyone used or is using the Excel VAT filer by Absolute ?

We have a taxi firm currently using speadsheets whom we had intended on moving onto a cloud software. However, based on how the output VAT on their rentals paid by drivers is calculated, it's looking like a potential nightmare to enter onto bookkeeping software.

On the face of it, it appears to look far simpler to use Absolute's VAT filer.

Any thoughts from users please ?

Thanks.

Replies

Please login or register to join the discussion.

17th Dec 2018 10:34

It looks very much like the solution my firm will be using for Excel clients. Also would appear ideal for clients with legacy Sage versions, as it appears as simple as exporting the VAT return from Sage into Excel and then using the Absolute VAT filer to map the 9 boxes.

Thanks (1)
17th Dec 2018 10:52

Shop around though, depending on the number of clients you have to whom this may apply, there are cheaper options than Absolute which do the same thing.

Thanks (0)
avatar
to Duggimon
17th Dec 2018 11:35

Duggimon wrote:

Shop around though, depending on the number of clients you have to whom this may apply, there are cheaper options than Absolute which do the same thing.

Yes there are alternatives but at present you're only talking £40+vat with Absolute.

I'm after users experience before I tell client to keep using spreadsheets instead of switching to cloud.

Thanks (0)
to BlackBriar
17th Dec 2018 12:01

£40 per ten clients and no discount for more. For us that meant £400 per annum which puts them in the expensive end.

For 100 clients, Taxfiler's spreadsheet filer would do the same job at half the price.

Thanks (0)
avatar
to Duggimon
17th Dec 2018 12:08

Duggimon wrote:

£40 per ten clients and no discount for more. For us that meant £400 per annum which puts them in the expensive end.

For 100 clients, Taxfiler's spreadsheet filer would do the same job at half the price.

Do you mean Taxcalc ?

Thanks (0)
to BlackBriar
18th Dec 2018 12:12

I did mean Taxcalc!

Thanks (1)
avatar
to Duggimon
17th Dec 2018 12:35

may i suggest that if you have that many a fundamental rethink on how they keep their books is required

Thanks (1)
to carnmores
18th Dec 2018 12:20

For most, their books are perfectly good and accurate, I would be extremely reluctant to throw a digital cat among the pigeons for the sake of HMRC's new idiotic scheme.

Digital record keeping will introduce errors that aren't there now, I'd rather keep it simple and the best way to do that is Excel filing.

There's a simple 1-1 correlation between paper books (for those who keep them) and a spreadsheet that isn't present in bookkeeping software like Sage or the cloud solutions out there. For others who keep records in Excel already, what is the point in changing?

Thanks (1)
avatar
to Duggimon
18th Dec 2018 14:19

Duggimon wrote:

For most, their books are perfectly good and accurate, I would be extremely reluctant to throw a digital cat among the pigeons for the sake of HMRC's new idiotic scheme.

Digital record keeping will introduce errors that aren't there now, I'd rather keep it simple and the best way to do that is Excel filing.

There's a simple 1-1 correlation between paper books (for those who keep them) and a spreadsheet that isn't present in bookkeeping software like Sage or the cloud solutions out there. For others who keep records in Excel already, what is the point in changing?

I'm beginning to think the same. We have moved quite a few clients onto cloud software but for others it simply isn't suitable and/or creates additional problems rather than solving them.

If that then means moving their paper ledgers onto spreadsheets and using bridging software to make submissions then so be it.

Thanks (0)
avatar
to Duggimon
17th Dec 2018 16:36

Agree, look around. We found free VAT bridging software. It is called VitalTax. I used it to submit VAT return a week ago, seems to be simple to use. Good support also.

Thanks (3)
to norwichaccountant
17th Dec 2018 23:43

norwichaccountant wrote:

Agree, look around. We found free VAT bridging software. It is called VitalTax. I used it to submit VAT return a week ago, seems to be simple to use. Good support also.

No it’s a scam. Don’t touch it.

Thanks (0)
avatar
to Tim Vane
20th Feb 2019 15:15

Care to elaborate? It does look to do everything that's required.

Thanks (0)
avatar
17th Dec 2018 18:10

We’ll probably be using TaxCalc’s add-on for the (v small) handful of Excel clients we have. I know it’s not the cheapest (we’ll be in the £75 for 12 category), but it seems way easier than some (ie it should be idiot proof in terms of linking the wrong boxes).

Thanks (0)
avatar
05th Jan 2019 17:39

We use excel and are reluctant to pay for something just to please HMRC.
One workaround we are testing is using free online accountancy software that supports MTD VAT returns. What we do then is type in the figures from our excel VAT return into this software, it means we create one 'artificial' sale and one 'artificial' invoice per quarter these figures all seem to stack up so far.

Thanks (0)
avatar
to SledgeHammer
05th Jan 2019 18:14

If your taking figures from a digital record (Excel) and typing them into another (free online software), then it fails MTD.

You want a separate CSV spreadsheet to formulate a journal from your workings, then input that to the software.

Or just use a bridging software. As far as I can work out (not used it yet) TaxCalc’s offering allows you to upload your spreadsheet and it will workout which boxes are which, you just click to confirm. Whereas all the others involve you downloading something, doing some mapping in your Excel before uploading.

Thanks (1)
avatar
to atleastisoundknowledgable...
05th Jan 2019 21:24

I don't see what you mean that is fails MTD, how would HMRC know as they only receive the VAT Return data? If you mean that it fails the principle behind MTD I completely agree, I'd even say its a ridiculous situation to be in but its free and appears to work. The software I was looking at was only free for a low number of transactions which is why my suggestion works as there would only be 8 transactions per year.

I'll take a look at TaxCalc's offering, is it free? I don't think people will be too bothered about downloading something, re-mapping VAT Return fields or outputting a CSV file as much of this is a fairly simple process with Excel Functions/Macro's. My preference would be free bridging or submission software.

Thanks (0)
avatar
to SledgeHammer
06th Jan 2019 12:50

There are quite a few MTD bridging providers offering a free service (at least initially) hence if you are doing pilot submissions there are lots of ways of trying this out for free (real submissions).

My service can be found here:
https://www.vat.direct

Thanks (0)
Share this content