Skip to main content
R
ronc
April 8, 2020
Solved

VAT - how to get MTD VAT to recognise the invoice date, not payment date

  • April 8, 2020
  • 2 replies
  • 0 views

Hi

 

I am working on submitting my VAT return. On my VAT return, the "tax point" for all my sales and purchases is the date of the invoice, not the date on which I pay the invoice or receive payment. I am on the most basic quickbooks online and it seems I can only record expenses that have been paid. How do I get MTD VAT on quickbooks to recognise the invoice date of expenses rather than the payment date so that the expenses full within the correct VAT return period?

 

Thanks

 

Best answer by GeorgiaC

Hi ronc,

 

Thanks for getting back to us here.

 

Just to correct my original post, you would need the VAT settings (Taxes > Edit VAT > Edit settings) to be set to Standard to account for the VAT on the transaction date, not the payment date. 

 

As there is no option to enter a payment date on an expense, you would need to raise the bill first, and then match this to your transactions in the bank.

 

If you created all of the expenses by adding from the bank feed, you can undo these and then raise the bill, and then match. 

 

If you have multiple similar bills, you can use the copy function (More > Copy on the toolbar in the transaction) to create a copy of this, then edit any details needed.

 

Thank you

2 replies

G
GeorgiaC
April 8, 2020

Hi ronc,

 

Thanks for joining us on the Community. 

 

As the expense can only have one date assigned and needs to reflect the date this was actually paid from your bank account, you would have to upgrade to Essentials to enter bills where you can enter a bill date and payment date, and ensure you are using the setting for cash VAT. This way the transactions will post to your VAT return when you mark them as paid/payment received. 

 

Please get back to us below if you have any queries!

R
roncAuthor
April 8, 2020

Thanks for your response. 

 

I have upgraded to Essentials now - is there a way to transfer transactions on my bank account to bills? I know I can transfer transactions on my bank account to expenses, but can't seem to make bills out of the same information from a bank transaction. I am just trying to find a quick way to create a bill for every expense paid - I understand this is what I need to do now if I want to ensure that it is the invoice date that is captured for an expense for VAT purposes. 

 

Thanks

JasroV
JasroV
April 8, 2020

I appreciate you for upgrading your QuickBooks Online (QBO) account, @ronc.

 

You'll just have to match the invoices recorded in your QBO to your bank transactions to ensure the invoice date is captured for your expense. Let me guide you how.

 

In your QBO account:

  1. Go to the Banking or Transactions menu.
  2. Select the bank account.
  3. Go the For Review tab.
  4. Click the transaction
  5. Select Find match. 
  6. And select the corresponding bill and click Save.

Here's an article you can read for more details in matching your bank transactions: Add and match downloaded bank transactions [Video].

 
You might also want to check these great resources that can guide on how to categorise your downloaded transactions and accurately reconcile them:
 

Let me know if there's anything I can help you with. I'm more than happy to help and get you back in working order. Have a beautiful day and always stay healthy.

G
GeorgiaCAnswer
April 9, 2020

Hi ronc,

 

Thanks for getting back to us here.

 

Just to correct my original post, you would need the VAT settings (Taxes > Edit VAT > Edit settings) to be set to Standard to account for the VAT on the transaction date, not the payment date. 

 

As there is no option to enter a payment date on an expense, you would need to raise the bill first, and then match this to your transactions in the bank.

 

If you created all of the expenses by adding from the bank feed, you can undo these and then raise the bill, and then match. 

 

If you have multiple similar bills, you can use the copy function (More > Copy on the toolbar in the transaction) to create a copy of this, then edit any details needed.

 

Thank you

Terms & ConditionsAccessibility statement