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

How to reconcile historic VAT payments in quickbooks online?

I recently transferred my data to Quickbooks online and would like to record the past vat payments. However, only the latest VAT return appears in Taxes menu. Could anyone help me with recording historic VAT payments in Quickbooks online?

Solved
Best answer November 11, 2021

Accepted Solutions
Rea_M
Moderator

How to reconcile historic VAT payments in quickbooks online?

I'll make sure you can record your historic VAT payments in QuickBooks Online (QBO), @mkhalilpour. This way, your total current liabilities in your company's balance sheet will show an accurate amount and keep your financial data updated.

 

When you've filed VAT returns outside QuickBooks, you can create an expense transaction to record your payments to HMRC. To do this, you'll first have to create an expense account to track your VAT payments. Make sure to select the appropriate information in the Account (i.e., Expenses) and Detail Type (i.e., Taxes Paid) fields. Please see the screenshot below for your reference.

 

 

Once you're done, record an Expense transaction from the + New button. You'll have to make sure to select the VAT agency name from the Payee drop-down, then choose the expense account (i.e., Taxes Paid) and all other payment details in the Category details section.

 

 

Since you've already imported the last 2 years' worth of transactions to your current bank account (including the VAT payments), you'll need to match the expenses you've created in QBO. This way, you can keep your books accurate. For the step-by-step guide, you can refer to this article: Categorise online bank transactions in QuickBooks Online.

 

To know more about filing VAT returns and recording payments in QBO, I'd recommend checking out this article: File your VAT return and record tax payment in QuickBooks Online.

 

Then, pull up the Balance Sheet report to make sure the data you've entered are recorded accordingly. To do this, go to the Business overview section from the Reports menu's Standard tab.

 

Also, to further guide you in managing your VAT payments and submitting returns to HMRC, I'd recommend checking out these articles:

 

 

Keep me posted on how it goes in the comments below. If you have other concerns about managing VAT payments in QBO, I'll gladly help. Take care, and I wish you continued success, @mkhalilpour.

View solution in original post

5 REPLIES 5
MaryLandT
Moderator

How to reconcile historic VAT payments in quickbooks online?

Let me help you record the previous VAT payments, mkhalilpour.

 

Before we proceed, you need import transactions that are included within the VAT return period. Then, change the effective date of the VAT setup to retrieve previous returns. Then, record the historical payment.

 

Here's how: 

 

  1. Go to the Taxes menu and click VAT
  2. At the upper-right, click Edit VAT,  then Edit settings
  3. Change the Effective date for a new scheme to the date you filed the return. 
  4. Click Save
  5. Under the Filed returns section, the reports will then show up.
  6. Click Record payment.
  7. Once done, click Save

 

Once done, you can start paying your current tax liability. I'm adding these articles to guide you through the process:

 

​​

Keep me posted if you have additional concerns about recording historical tax payments. I'll be right here to help you.

mkhalilpour
Level 2

How to reconcile historic VAT payments in quickbooks online?

Hi MaryLandT

 

Thank you for the guidance. I have already imported the last 2 years transactions of my current bank account (including the vat payments). However, when going to Taxes\ Edit VAT\ Edit settings\, there is no option for changing the "Effective date". Please see the attached screen grab from my Quickbooks VAT page.

Ryan_M
Moderator

How to reconcile historic VAT payments in quickbooks online?

Thank you for the prompt reply, as well as for sharing a screenshot of your VAT settings, @mkhalilpour. I'll take care of this concern for you.

 

The first thing I can suggest is to open your browser's private window. It isolates cache, which is the common cause of unusual behaviors in browsers. 

 

  • Google Chrome: Ctrl + Shift + N
  • Microsoft Edge: Ctrl + Shift + P
  • Firefox: Ctrl + Shift + P
  • Safari: Command + Shift + N

 

If that works, go back to your regular browser and clear its cache. Otherwise, open an alternative browser that's available for you. 

 

In case you continue to experience the same issue, contact our Technical Support team for further assistance. Please refer to this article for the steps: QuickBooks Online Support. It includes their operating hours, so you know when they're available. 

 

Tag me in a comment below if you have other questions about VAT in QuickBooks Online. I'll be sure to get back to you. Have a nice day!

mkhalilpour
Level 2

How to reconcile historic VAT payments in quickbooks online?

Hi There

 

I still have problem with recording VAT payments in QB. As a result, the Total Current Liabilities in my company's balance sheet is much higher that it should be. I wonder if anybody have a solution for this problem?

Rea_M
Moderator

How to reconcile historic VAT payments in quickbooks online?

I'll make sure you can record your historic VAT payments in QuickBooks Online (QBO), @mkhalilpour. This way, your total current liabilities in your company's balance sheet will show an accurate amount and keep your financial data updated.

 

When you've filed VAT returns outside QuickBooks, you can create an expense transaction to record your payments to HMRC. To do this, you'll first have to create an expense account to track your VAT payments. Make sure to select the appropriate information in the Account (i.e., Expenses) and Detail Type (i.e., Taxes Paid) fields. Please see the screenshot below for your reference.

 

 

Once you're done, record an Expense transaction from the + New button. You'll have to make sure to select the VAT agency name from the Payee drop-down, then choose the expense account (i.e., Taxes Paid) and all other payment details in the Category details section.

 

 

Since you've already imported the last 2 years' worth of transactions to your current bank account (including the VAT payments), you'll need to match the expenses you've created in QBO. This way, you can keep your books accurate. For the step-by-step guide, you can refer to this article: Categorise online bank transactions in QuickBooks Online.

 

To know more about filing VAT returns and recording payments in QBO, I'd recommend checking out this article: File your VAT return and record tax payment in QuickBooks Online.

 

Then, pull up the Balance Sheet report to make sure the data you've entered are recorded accordingly. To do this, go to the Business overview section from the Reports menu's Standard tab.

 

Also, to further guide you in managing your VAT payments and submitting returns to HMRC, I'd recommend checking out these articles:

 

 

Keep me posted on how it goes in the comments below. If you have other concerns about managing VAT payments in QBO, I'll gladly help. Take care, and I wish you continued success, @mkhalilpour.

Need to get in touch?

Contact us