DataDear

Discussion in 'Accounts & Finance' started by sniper74, Sep 11, 2019.

  1. sniper74

    sniper74 UKBF Newcomer Free Member

    19 1
    Hi all. Does anybody use DataDear, the free MTD software linked to their Excel spreadsheet to submit their VAT returns?
     
    Posted: Sep 11, 2019 By: sniper74 Member since: Apr 30, 2018
    #1
  2. NickGrogan

    NickGrogan UKBF Ace Full Member

    2,355 554
    yes, why?
     
    Posted: Sep 11, 2019 By: NickGrogan Member since: Nov 15, 2012
    #2
  3. sniper74

    sniper74 UKBF Newcomer Free Member

    19 1
    Hi. Thank you for your reply. Is it ok to use? I have done the VAT returns for our company for years but now the business has to comply with the MTD ruling I was looking into either subscribing to Sage or QuickBooks but then came across DataDear.
    Have just submitted this quarter via our accountant - I did most of the work and they just submitted it but then hit us with a bill for £40 for doing it!
    Do you link your excel spreadsheet that you work on day to day or export it to DataDears spreadsheet that's in the download then submit it?
    Wanted to have a play with it but afraid to in case its all 'live' and no going back!
     
    Posted: Sep 11, 2019 By: sniper74 Member since: Apr 30, 2018
    #3
  4. NickGrogan

    NickGrogan UKBF Ace Full Member

    2,355 554
    I downloaded their spreadsheet, calculated the figures separately, added them in and clicked submit.

    Took about 2 minutes, maybe less.
     
    Posted: Sep 11, 2019 By: NickGrogan Member since: Nov 15, 2012
    #4
  5. sniper74

    sniper74 UKBF Newcomer Free Member

    19 1
    Ok, thank you. When you submit it sends just the part of the spreadsheet VAT Returns Form and not the Invoices (Sales) and Bills (Purchases) part? Meaning you can just enter the figures required from your original day-to-day spreadsheet?
     
    Posted: Sep 11, 2019 By: sniper74 Member since: Apr 30, 2018
    #5
  6. NickGrogan

    NickGrogan UKBF Ace Full Member

    2,355 554
    yes, exactly.
     
    Posted: Sep 11, 2019 By: NickGrogan Member since: Nov 15, 2012
    #6
  7. sniper74

    sniper74 UKBF Newcomer Free Member

    19 1
    Thank you for your help :)
     
    Posted: Sep 11, 2019 By: sniper74 Member since: Apr 30, 2018
    #7
  8. MyAccountantOnline

    MyAccountantOnline UKBF Legend Full Member

    12,946 2,406
    I know its not what you asked but it might be a good time to consider replacing your Excel sheets with an online system which will deal with MTD.

    You may well find your time savings exceed the monthly cost and you may also find you save on accountancy fees too.

    Don't just look at Sage and QuickBooks, you have lots of choice.

    I personally like Accounts Portal which is just £6 plus VAT for my firms clients.
     
    Posted: Sep 11, 2019 By: MyAccountantOnline Member since: Sep 24, 2008
    #8
  9. justintime

    justintime UKBF Regular Free Member

    550 76
    Apologies if I have misconstrued what you said, but are you just typing the totals from your excel sheets into the DataDear VAT return template? Strictly speaking, that isn't the correct way to do it, although during the soft landing period HMRC are unlikely to get into a strop about it.

    What you should be doing is linking DataDear to your excel sheet totals, which in turn will "import" the figures into the relevant VAT boxes.
     
    Posted: Sep 16, 2019 By: justintime Member since: Apr 12, 2009
    #9
  10. sniper74

    sniper74 UKBF Newcomer Free Member

    19 1
    Happy New Year to you all!
    I am wondering if anyone can point me in the right direction with submitting VAT returns using DataDear?
    I have created an account and added the organisation. I then thought that by clicking on the Templates library and HMRC Direct - Making Tax Digital which then brings up a VAT submission form and DataDear spreadsheets but have then discovered that's a read only file.
    Have then clicked on Download and install DataDear add-in but it doesn't matter if I run or save the program it says the wizard has completed it but I cannot find it anywhere?
    Does this program not work with the standard excel or am I missing something completely here?!
    Thank you in advance for any help.
     
    Posted: Jan 2, 2020 By: sniper74 Member since: Apr 30, 2018
    #10
  11. Scalloway

    Scalloway UKBF Legend Free Member

    15,691 3,314
    Posted: Jan 2, 2020 By: Scalloway Member since: Jun 6, 2010
    #11
  12. sniper74

    sniper74 UKBF Newcomer Free Member

    19 1
    I have! Although cannot get past the Download Add On as I cannot find it and it doesn't open automatically after the download? I am really confused. Is it because I am using 2007 Excel that is on my laptop and not through an Office 365?
     
    Posted: Jan 2, 2020 By: sniper74 Member since: Apr 30, 2018
    #12
  13. Scalloway

    Scalloway UKBF Legend Free Member

    15,691 3,314
    There FAQ section at the bottom says "The only requirement is Microsoft Excel (Office 365 recommended)" so you could be right.
     
    Posted: Jan 2, 2020 By: Scalloway Member since: Jun 6, 2010
    #13