Skip to main content
M
mattymoo
May 27, 2020
Solved

How to record VAT element on AP Journal Entry

  • May 27, 2020
  • 1 reply
  • 0 views
We have just set up QBO. Originally I entered customer balance as an opening balance, but that was showing as sales in our profit & loss, which have already been recorded in our old system. So on the advice of my accountant I have done journal entries for the accounts payable by our customers, but I cannot get the VAT to record correctly and the amount owed by the customer is showing as the net amount of 2644.78 instead of the gross amount of 3173.74. What am i doing wrong?
Best answer by MirriamM

Hello again, mattymoo. Thanks for getting back and providing detailed information about the help you need.

 

If you're creating a Journal entry, you'll need to put the VAT in the paired account with Accounts Receivable (A/R). 

 

As for the Customer's Balance, A/R is the impacted account which appears in the Debit column of the transaction journal. It means that the customer still owes you money and will stay in A/R until the invoice is paid. However, if you'd not want the sales account, then you can use a different account and put a VAT code in that line item. 

 

Moreover, since every business has a different structure, and it typically goes to the posting accounts used for transactions. For this reason, I still recommend reaching out to your accountant to help determine the different account you'll use.

 

Moreover, I don’t like to leave you empty-handed, you may consider reading this article to know more about entering outstanding balances for customers: How to enter outstanding balances for customers and vendors.

 

If you need additional assistance, please let me know. I’ll be right here to help. Have a great day!

1 reply

katherinejoyceO
katherinejoyceO
May 27, 2020

Hi there, @mattymoo.

 

I can see that you posted a similar question in the Intuit Community forum. Please refer to the response posted by my peer, @MaryJoyD. Here's a direct link to access it: https://quickbooks.intuit.com/learn-support/en-uk/reports-and-accounting/how-do-i-record-vat-correctly-on-an-a-p-journal-entry/00/578965.

 

You may want to visit our QuickBooks Help article hub to find topics and discussion which may be similar to your concerns that were answered by our Community team and all-star contributor.  

 

Feel free to message again if you have additional concern. We're always delighted to assist.

M
mattymooAuthor
May 27, 2020

I seem to have a blank reply here, but on doing some more digging, I think I am asking the wrong question, but still need some help!  Also I think I posted twice in error..

 

I initially imported all my customer opening balances, but they were reporting as sales and that didn't look correct as I have already accounted for the sales in our previous software.  That's when my accountant suggested the above journal & the VAT messed up.

 

However, on reflection, I think the right thing to do is import the customer outstanding balances as opening balances, but how do I import them so they don't report as sales and get double counted?

M
MirriamMAnswer
May 27, 2020

Hello again, mattymoo. Thanks for getting back and providing detailed information about the help you need.

 

If you're creating a Journal entry, you'll need to put the VAT in the paired account with Accounts Receivable (A/R). 

 

As for the Customer's Balance, A/R is the impacted account which appears in the Debit column of the transaction journal. It means that the customer still owes you money and will stay in A/R until the invoice is paid. However, if you'd not want the sales account, then you can use a different account and put a VAT code in that line item. 

 

Moreover, since every business has a different structure, and it typically goes to the posting accounts used for transactions. For this reason, I still recommend reaching out to your accountant to help determine the different account you'll use.

 

Moreover, I don’t like to leave you empty-handed, you may consider reading this article to know more about entering outstanding balances for customers: How to enter outstanding balances for customers and vendors.

 

If you need additional assistance, please let me know. I’ll be right here to help. Have a great day!

Terms & ConditionsAccessibility statement