Skip to main content
April 15, 2021
Solved

Historic Bank Transactions for Pay not giving the option of Match to Journal Entry. Help! Do I need to delete Payrol Runs and start over?

  • April 15, 2021
  • 1 reply
  • 0 views
I have messed up, and I can't remember how or why! Basically, I have net salary payments coming through in Banking that are not allowing me to Match to the Journal Entries. I am wondering if I need to delete the Payroll Runs and start again so it comes through on Banking as Match to Journal. Also, mid-way through the year, I started paying our employee on the Friday of the working week rather than a week in arrears. My journal dates still show a week in arrears so doesn't match the pay date through the bank - does that matter? Please help. I can't get anything to match up!
Best answer by JoesemM

I thank you for sharing the troubleshooting steps you've performed and their results, @Gary Cruse.

 

Linking the manual journal entry to your payroll system is unavailable. As a workaround, you'll have to recreate the payroll from the Workers menu so it will appear correctly. Let me show you how.

 

To delete your pay run:

 

  1. Go to the Employees or Payroll menu.
  2. In the Payroll History section, select the most recent period.
  3. On the Payroll details page, click Actions and select Delete Payroll.
  4. Type Yes in the box, then click Delete.
  5. Repeat for any additional pay runs you require.

 

To recreate the paycheck.

 

  1. Go to Workers and select Employees.
  2. Select Run Payroll.
  3. Choose the employees you'd like to pay then enter the hours and memos based on the deleted ones.
  4. Select Save and review to see a summary of this payroll.
  5. Select Confirm and submit to create the pay run in QuickBooks.

I've got these articles for additional information on how to create and edit paycheck in QuickBooks

 

 

Also, to make sure the amounts are accurate, you can run a payroll report (Payroll Summary, Payroll Summary by Employee, or Payroll Details) for reference. To know more about the Payroll reports that you can run in QuickBooks, see the below articles:

 

If you wish to personalize them, browse this resource for detailed instructions. To ensure you save the current customization settings, you can simply memorize them. 

 

If you have follow-up questions on this or any QuickBooks concerns, don't hesitate to let me know. I'll be here to help you further. Take good care.

1 reply

April 15, 2021

Hi there, Gary Cruse.

 

Welcome back to QuickBooks Community. I'll make sure to provide details on how banking transactions work in QuickBooks Onlne.

 

QuickBooks will automatically match your transactions once it detects entries with similar amounts and details. Since the net salary payments from the Banking are not allowing to match the journal entries, I suggest making sure that the JE created by the payroll are categorized to the correct Bank account. To do that, you can run the Journal report and find the created one to review the details.

 

Here's how:

 

  1. Click the Reports menu on the left panel.
  2. Choose Journal in the search bar.
  3. Click the Customise button. Then, go to the Filters drop-down arrow.
  4. Checkmark the Transaction Type box and select Journal Entry.
  5. Hit Run report.

 

For additional details on how you can customise reports to show specific accounts or customers, or format the layout so the right data shows up in the right place, you can click this article: Customise reports in QuickBooks Online.

 

Please refer to this article to see different details on how to review downloaded bank and credit card transactions by matching and adding them and how it goes: Categorise and match online bank transactions in QuickBooks Online.

 

I'm always here if you need more help with your transactions. Let me know in the Reply section below. Take care and have a wonderful day!

April 15, 2021

They are definitely matched to correct bank account. Basically I think I unmatched them on the journal entry (can't remember why) and now they are coming through on Banking with odd expense categories such as Travelling Expenses!! Could I create a new matching journal entry, then delete the original one and see if they come through correctly on banking (with Match to Journal)?