cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
accounts306
Level 2

Sales invoices payments not showing in sales VAT part or VAT100

Hi all,

I’m currently in the process of submitting my VAT but can not figure out what I’m doing wrong.

Im an electrician, self employed on standard CIS at 20% but also VAT registered so have been uploading any fuel receipts and have linked my business bank to track payments.

Ive organised and submitted the purchases for materials etc and that seems to be working ok and is showing in the VAT section. However once I receive payment for outstanding  invoices, I record that payment as received and then add it but it’s not showing up in the sales part of the VAT?

I’ve tried changing all sorts and experimenting with it but had no luck. Is there something I’m doing wrong?

Also when I go into the vat100 form, box 1 and 2 are empty which isn’t right as it should be calculating the sales output.

The purchases are showing as they should so I’m a bit confused and seeing if anyone can figure out what I’m doing wrong.

Thanks

Solved
Best answer September 16, 2020

Accepted Solutions
accounts306
Level 2

Sales invoices payments not showing in sales VAT part or VAT100

Thanks for all the help,

Just to let you know the outcome in case anyone in the future has the same issue.

I had an online chat with an expert and they figured what I was doing wrong.. I had VAT selected in the drop-down box when sending my invoices but it should have been 20% sales. Not sure why VAT at 20% isn't the same thing but maybe because QuickBooks does not recognise this as 'sales' so it was not showing in my sales part of the VAT.

 

View solution in original post

10 REPLIES 10
John C
QuickBooks Team

Sales invoices payments not showing in sales VAT part or VAT100

Hi accounts306 What are the dates of the open VAT return, what are the dates of the payments you receive, what VAT code are you using on the invoice and are you using the accrual or cash method?

accounts306
Level 2

Sales invoices payments not showing in sales VAT part or VAT100

Hi the dates are the current quarter
May- July which is due in today.

Payments received are various from late April when I went VAT registered but I’ve set the quarter to match my VAT quarter.

VAT code I’m using standard VAT @ 20% selected from the drop down box built into QuickBooks.

I was set to accrual but I’ve tried both just to see whether it changes much.

Thanks 

GeorgiaC
QuickBooks Team

Sales invoices payments not showing in sales VAT part or VAT100

Hi accounts306, 

 

Thanks for getting back to us with that info. 

 

If this is your first return on QuickBooks, you'll need to set the date on any sales which you need to be included within your return to be dated within the May - July quarter, as the system is unable to pick up any exceptions for the first filing.  

 

Can you check that the date of the sale itself falls within the return period?

 

Thanks :smiling_face_with_smiling_eyes:

accounts306
Level 2

Sales invoices payments not showing in sales VAT part or VAT100

Thanks for your reply

Yes all invoices are dated and also the payments received are within that quarter

I do however understand that 'cash' will work better for me as a small business rather than accrual so i have amended this in my settings. But still no luck.

MaryLandT
Moderator

Sales invoices payments not showing in sales VAT part or VAT100

Thanks for the update, accounts306,

 

Let's check to see if the rate is still active. It won't show up when it has been inactivated.

 

Here's how:

  1. Go to Taxes on the left-hand side of the Dashboard.
  2. Click the Edit Vat drop list.
  3. Select Edit rates.
  4. See if the rates are active. If not, click the Gear icon in the VAT Rates section and place a check mark in the Include Inactive checkbox.
  5. Turn on the inactive rates that you use.

It the rate is showing active, you can perform the basic browser troubleshooting steps. This will help check if it could be a browser-related issue.

 

Check out this link for instructions and detailed steps: Clear cache and cookies to fix issues when using QuickBooks Online. Also, don't forget to use a supported browser to get the best out of your QuickBooks experience.

 

Stay in touch with me how the solution works for you. I'm always around to help.

accounts306
Level 2

Sales invoices payments not showing in sales VAT part or VAT100

Ok so I've followed your advice and the VAT @ 20% is set to ON.

The invoices are showing in my VAT100 form and quickbooks gives me the total for each company but the sales on the VAT section are still blank

 
accounts306
Level 2

Sales invoices payments not showing in sales VAT part or VAT100

So basically my screen looks like this 

accounts306
Level 2

Sales invoices payments not showing in sales VAT part or VAT100

Would it be a good idea to maybe this time adjust and input the figures myself manually for box 1 on my VAT return as the deadline is today.?

Thanks

MaryLandT
Moderator

Sales invoices payments not showing in sales VAT part or VAT100

Hello again, and thank you for the screenshot, accounts306.

 

I've deeply looked into this issue and found out that there's an open investigation. The workaround provided by our Product Team is to use the record prepayments process in QuickBooks.

 

Also, I recommend contacting our QuickBooks Online Team so they can add your account to the investigation (INV-46357). This way, you'll receive updates via email about the issue.

 

Here's how to contact them:

  1. Sign in to your QuickBooks Online company.
  2. Select Help (?) at the top right.
  3. Click Contact Us.
  4. Enter a brief discussion of your concern, then click Let's talk.
  5. Choose Chat to connect with a live support agent.

Stay in touch if there's anything else you need. I'm always right here to help.

accounts306
Level 2

Sales invoices payments not showing in sales VAT part or VAT100

Thanks for all the help,

Just to let you know the outcome in case anyone in the future has the same issue.

I had an online chat with an expert and they figured what I was doing wrong.. I had VAT selected in the drop-down box when sending my invoices but it should have been 20% sales. Not sure why VAT at 20% isn't the same thing but maybe because QuickBooks does not recognise this as 'sales' so it was not showing in my sales part of the VAT.

 

Need to get in touch?

Contact us