Skip to main content
W
WCB1
March 8, 2023
Question

VAT cash accounting and deposits in advance

  • March 8, 2023
  • 1 reply
  • 0 views

Hi,

Our client receives approximately 10% of the full order quoted as a payment on account. The order is often not fulfilled for 8-10 weeks after due to the nature of the product and at this point they invoice the customer. I have Quickbooks set to cash accounting for VAT, but my problem is that, say the QE 28.02.23, they received a payment, deposit, or full payment, in February but the invoice was not raised until mid-March, Quickbooks is not recognising the payment received until the (later) invoice date and is therefore not accounting for VAT on the payment received in the correct quarter. How do we get around this? I can't believe Quickbooks is not recognising sales payments received per the receipt date when set to cash accounting rather than the invoice date.

1 reply

A
Ashleigh1
March 8, 2023

Hello WCB1, Thanks for posting on the Community page, you should use the second set of steps, numbered 1-5 to record the prepayments in a way that will show on the VAT return on the payment date. On this help article How to record Customer prepayments for Products or Services 

W
WCB1Author
March 8, 2023

Hi,

We have literally hundreds of prepayments as almost every customer makes a small deposit to secure their order. The invoices (when created) get transferred from Blind Matrix software directly into Quickbooks so there would be no option to add a line at the end of each invoice to match off to a prepayment amount. These customer balances need to be tracked through individual customer ledgers so I do not think your suggestion would be practical and would lead to much more admin. Is there no way for Quickbooks to recognise the VAT on cash accounting according to the date the cash was received after it is matched to an invoice, rather than the date of the invoice (which will be later)?

DivinaMercy_N
DivinaMercy_N
March 8, 2023

Hi there, @WCB1. I want to ensure this will be taken care of. 

 

Thanks for getting back here. In QBO, you'll have to create an invoice first before applying for its payment. VAT cannot be accumulated if there's no invoice created upon receiving payment. 

 

To fix this, you can track the prepayments against a current liability account to ensure VAT is reported to HMRC when the payments are received. Here's how:

 

  1. To start, create a current liability account to track prepayments (you can name it a Prepayments account). For the detailed steps, check out this link: Create a Current Liability account.
  2. Next, create a service item, name it as Pre-Payments (or anything you preferred that can be found easily), and select the Current Liability Account in the Income Account field.
  3. After that, enter Sales Receipts for each pre-payments for the invoices and post them to the service item.
  4. Select the correct customer name, payment date, and bank account.
  5. In the PRODUCT/SERVICE field, choose the Prepayments account and enter the amount received
  6. Ensure to select the VAT Code and click Save and close when done. 

 

Once done, create an invoice, ensuring the prepayments are taken into account. Let me guide you on how.

 

  1. Go to the + New button and choose Invoice.
  2. Input the customer's details as normal, with line items including the services provided, and select the relevant VAT code(s).
  3. On the last line item, select the customer prepayments item created.
  4. Then, input the amount of the prepayments as a Negative value, and select the VAT Code used.

 

Then, pay the balance if there's a balance due after the prepayment is applied. 

 

For reference, please read this article: How to record Customer prepayments for Products or Services. I also recommend reaching out to your accountant for additional guidance in managing the prepayments of your customer. They can also help you in making sure the program will account for the VAT on the date payment is received. If you're not affiliated with one, you can use our Find an Accountant Tool to look for one near you. 

 

I'll include this helpful resource that you can use as a guide in helping you handle VAT in QBO: Manage VAT payments in QuickBooks Online.

 

I'm always here ready to lend additional guidance in making sure you account for your invoices correctly. Please don't hesitate to leave a reply below. Have a good one and stay safe. 

Terms & ConditionsAccessibility statement