Hi John, I’m having terrible trouble trying to extract the information I need for the VAT RTD from my Bullet accounts. I’ve been working at this over a week and I am in a panic. The main issue is the amount of 13.5 % and 23% vat and EU purchases. For example, I purchase stock from the UK occasionally and charge vat at both 13.5 % and 23%. All Bullet shows me in the reports is the overall vat total and suppliers that I paid sterling show up as converted euro but 0% vat. Besides dragging out boxes of receipts and doing everything by hand over the next couple of weeks and then cross referencing it with all Bullet figures, is there anything I’m missing where I can easily obtain this info in Bullet somewhere? I have had the VAT amount ready on time but am now well overdue because I was unaware of this RTD requirement. Can you please help?

Vote Up
0
Vote Down

Hi John,
I’m having terrible trouble trying to extract the information I need for the VAT RTD from my Bullet accounts.
I’ve been working at this over a week and I am in a panic.
The main issue is the amount of 13.5 % and 23% vat and EU purchases.
For example, I purchase stock from the UK occasionally and charge vat at both 13.5 % and 23%.
All Bullet shows me in the reports is the overall vat total and suppliers that I paid sterling show up as converted euro but 0% vat.
Besides dragging out boxes of receipts and doing everything by hand over the next couple of weeks and then cross referencing it with all Bullet figures, is there anything I’m missing where I can easily obtain this info in Bullet somewhere?
I have had the VAT amount ready on time but am now well overdue because I was unaware of this RTD requirement.
Can you please help?

1 answer

Vote Up
0
Vote Down
Peter Connor ⋅ Staff February 12, 2016
Public

Hi,
Pete here, you updated an old message that has been closed. So John didn’t get the notice. 
I’m afraid we don’t have a RTD report. We also don’t have an report/export that breaks down VAT per line item. 

The best thing is to group the suppliers who are import/export and click on each invoice/bill in Bullet to see which might have multiple vat amounts. Those that DON’T then you can go with the total in the export those that do you can just add a line in the spreadsheet. 

Tks

Pete

#answer-2744
  1. Rober15 February 12, 2016
    Hi Peter, Thanks for your reply. The main problem is, we are computer repairs, sales and service. Most of our invoices have a mix of 23% and 13.5%. The revenue require me to break this down in the RTD. What do other users of Bullet do in this case? Thanks, Rob
  2. Peter Connor February 12, 2016
    Very good.
    Anyone doing an RTD.
    Revenue have ignored RTD till now.
    Tks P
  3. Rober15 February 12, 2016
    Invoices we send. Not receive. Tks
  4. Peter Connor February 12, 2016
    Cool. You'll just need to add them into the rows and manually calculate.
    Thanks P
  5. Rober15 February 12, 2016
    I'm not sure what you mean
  6. Rober15 February 12, 2016
    Is there a way I can export my own invoices where they show the different vat rates. As far as I can see, the just show the vat total
  7. Peter Connor February 12, 2016
    We don't do RTD reports and we don't break down the invoices/bills export by line item.
    Well look to make this easier.
  8. Rober15 February 12, 2016
    Other than opening every invoice for the last year (over 200) and manually typing each vat rate into an excel sheet and running a calculation, I can't figure out any other way. I must be missing something, sorry. I'm still finding my way around on Bullet.
  9. Rober15 February 12, 2016
    I understand you don't do RTD. But the information I need to do the RDT manually doesn't seem to be available to me either.
  10. Rober15 February 12, 2016
    It's all locked away within the data I enetered into Bullet. I just need to get at it..
  11. Peter Connor February 12, 2016
    Revenue only started forcing RTD returns.
    We don't export, create or list anything bar the actual invoice/bill that lists the different vat rates per line items.
    If you've 200 invoices affected by RTD then you'll need to manually checks them.
    Pete
  12. Rober15 February 12, 2016
    Ok, I see now. i didn't get that from the previous communications. Suppose I've no choice but to knuckle down for the next while. Do you guys plan to implement RTD to your system? Or at least a address accessibility to vat breakdowns etc? Tks, Rob
  13. Peter Connor February 12, 2016
    Hi Rob.
    We spent 3mts working on VAT RTD about 2 years ago and stopes for two reasons
    1) People had never heard of it nor did it.
    2) 1) would mean it wasn't adding value.
    So we stopped. If it was easy to semi easy to do it would done.
    It's not as easy at it sounds.
    Saying that well probably add the line items to the invoice/bills export.
    The return will still need to be done manually but gathering the info will be easier.
    Well also force the county when creating supplier/client.
    Well do that over the next couple of months.
    Sorry for the hassle Rob but it's a complex return to automate.
    You should add a temp account to your bullet account and outsource the work. It will probably cost 30USD
  14. Rober15 February 12, 2016
    Thanks Pete. I understand it's not straight forward. I'll manage manually, just a pain. I just wasn't sure if I was missing a type of export or something. Yeah, if you develop an export option for the vat breakdowns and countries, that would be good enough. I'm sure I won't have to worry for another year :) Thanks for your prompt replies. As always, support is top notch. You're a late worker like myself. Thanks again, Rob
  15. Peter Connor February 12, 2016
    There's this fella called Rob who keeps me awake
  16. Rober15 February 12, 2016
    :-)

Please login or Register to Submit Answer