cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
Kirstyc
Level 1

HMRC paid after

I have payroll & accounting- we pay HMRC / pensions on the 5th of the following month so for example for June I have all payroll costs in and the amounts for pension and HMRC on the bank transactions won’t match because they are for last months payroll. I was going to do a reversing accrual for the variance but I was told if I reverse it next month it will then change the PNL. Please help 

5 REPLIES 5
Bryan_M
QuickBooks Team

HMRC paid after

Thank you for posting in the Community space, @Kirstyc.

 

Let me guide you on how to handle your HMRC/Pension transactions on your bank feeds that don't match.

 

Since you're unable to match the transactions, however it shows in your bank feeds, we can exclude this to avoid changing your Profit and Loss (P&L) report for the next month. 

 

Also, this won't affect any of your financial records. Here's how:

 

  1. Select Bank transactions from the Transactions tab.
  2. Pick For Review tab.
  3. Choose the checkbox of the transactions to exclude.
  4. Click Exclude.

 

Check out this article for more info: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Additionally, if you want to categorise your bank transactions, you can read this article: Set up bank rules to categorise online banking transactions in QuickBooks Online.

 

For additional questions about matching your bank transactions in QBO, click the Reply button below. We'll be willing to help. Keep safe, and have a good one.

Kirstyc
Level 1

HMRC paid after

If i exclude it then surely I would need to add the nest payment manually as we would still  need to show how much pension costs in the month. Secondly if i exclude these wont my reconciliation be out?

GeorgiaC
QuickBooks Team

HMRC paid after

Hi Kirstyc, thanks for getting back in touch 

 

Excluding the transaction won't impact your reconciliation if the transaction has already been recorded elsewhere in QuickBooks. 

 

When recording payments to HMRC or your pension provider, it is recommended to enter these as an Expense in QuickBooks. The date entered on the expense should be the date that the payment was made, allowing you to match to the downloaded bank transaction.

 

For example, in QuickBooks Online Core Payroll, payroll liabilities are posted under several sub-accounts. The relevant sub-account would be entered in the Category field of the Expense. Once saved, this will reduce the liability amount owing in that account. 

 

We hope this helps to clarify your query. If you do need any additional assistance, please don't hesitate to get back in touch.

Kirstyc
Level 1

HMRC paid after

Regarding excluding it, it will be in QuickBooks but for the prior month? So surely there will be a difference in the reconciliation 

 

 

GeorgiaC
QuickBooks Team

HMRC paid after

Hi Kirstyc, if you are reconciling until the month end (May) then that's correct, there would be a discrepancy between the QuickBooks balance and actual bank balance. 

 

Were the transactions entered in QuickBooks manually (e.g. as an expense) or on an automated payroll journal? 

 

Additionally, please confirm which version of QuickBooks Online Payroll you're using: Standard, Core, or Advanced. Thank you!

Need to get in touch?

Contact us