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

Matching payroll payments

I am having a problem with my payroll entries. I run my standard payroll through quickbooks and that creates a journal entry for each of my employees each month. When the employee wages shows up in the banking transactions (the bank account is linked to quickbooks) I normally just match the transaction to the journal entry.

 

Now I cannot find a match, I have also checked the journal mapping for payroll and the fields are blank?

 

6 REPLIES 6
Monty250
Level 2

Matching payroll payments

I've found the issue, it has used the Bank (cash in hand) not the business account!

Monty250
Level 2

Matching payroll payments

I can now match the wage anounts and HMRC contributions but not the Nest pension amounts?

 

Rea_M
Moderator

Matching payroll payments

Hello there, @Monty250.

 

Let's go to your Payroll Settings and update your Journal Mapping for the Nest pension so you can match your payroll payments in QuickBooks Online (QBO) accordingly.

 

There are cases where some of the transactions can’t find their match from existing records. Based on your description, I can tell that your bank account for the Nest Pension payment is not the same as the one where the match is located. That's why you'll have to correct your journal mapping. To do this, here's how:

 

  1. Go to the Payroll menu and select the Overview tab.
  2. Select Settings in the Shortcuts section.
  3. Go to the Journal Mapping section and Edit.
  4. Make sure to select the appropriate account for your Nest Pension.
  5. Click Save.

 

Once you're done, go back to the Banking menu, review your downloaded Nest Pension transaction, and put it in the correct account. Then, you can go ahead and match it to your existing payroll entry. You can refer to this article's Review and categorise downloaded transactions section for the complete guide: Categorise and match online bank transactions in QuickBooks Online.

 

Moreover, I encourage you to reconcile your accounts in QBO regularly (every month). This helps monitor your income and expense transactions and detect any possible errors accordingly. You can refer to this article to guide you in doing and fixing reconciliation in QBO: Learn the reconcile workflow in QuickBooks.

 

Also, you may want to check out this article as your reference to guide you in completing your payroll tasks using Standard Payroll in QBO: Standard Payroll hub.

 

Let me know if you have other banking concerns or questions about managing payroll payments in QBO. I'll gladly help. Take care, and have a great day, @Monty250.

Monty250
Level 2

Matching payroll payments

I have not altered any of the mapping and it was working fine until now. I have also noticed I'm unable to match the HMRC payments.

 

it seems that the payroll payments are no longer being posted to the expense accounts?

 

 

ChristieAnn
QuickBooks Team

Matching payroll payments

I appreciate you for coming back to the thread and adding further details about your concern, Monty250. With this, I'll ensure to share additional details on how payroll entries are being posted and make sure you're able to match your transactions.

 

QuickBooks Online Payroll automatically creates default accounts where your payroll liabilities and expenses are recorded. However, you can customize and manage your payroll accounting settings to track your payroll transactions. 

 

I suggest going to the Payroll settings to review the affected accounts for your payroll entries like wages and HMRC payments. Then, update if needed to ensure that transactions are posted to the correct accounts and able to match them in the Banking menu.

 

Here's how:

 

  1. Click the Gear icon at the upper right corner and choose Payroll Settings.
  2. Click Chart of Accounts in the left panel.
  3. Select Default Accounts and check the setup. Then, change the account under Wages Expenses Account or other accounts.
  4. Click Save.

 

If the issue persists, I recommend contacting our QuickBooks Support. They have the tools to pull up your account which is needed in investigating the cause of why you're unable to match payroll transactions.

 

Here's how to contact them:

 

  1. Sign in to your QuickBooks Online company.
  2. Choose Help (?).
  3. Enter the topic you need help with in QB Assistant. You can also enter questions.
  4. Select Contact Us to connect with a live support agent.
  5. Choose a way to connect with us.

 

Lastly, you may refer to this article to provide you with various details about your payroll tasks and to stay on top of your compliance regulations with HMRC: Standard Payroll hub | QuickBooks Online.

 

Please let me know if you should have any questions about payroll entries or QuickBooks-related topics. I'm always here to help and have a good one, Monty250.

Monty250
Level 2

Matching payroll payments

I have checked the posting from the latest payroll journal and they are posted to the same accounts as previously, they are all to the default accounts (except the bank as been changed to business account) 

Need to get in touch?

Contact us