Payroll operations are crucial operations for every business, and QuickBooks is the most popular software for managing it. At times, however, you can find QuickBooks payroll check transactions not matching. When this happens, you cannot generate financial reports with accurate data.
Furthermore, you can experience other challenges, such as imprecise tax filings and incorrect audit processes. All of this can cause significant disruption in your business operations.
The comforting fact is that you can implement simple hacks to resolve this problem. Let’s jump into the article to swiftly understand why are payroll check transactions not matching and learn how to fix it.
If you want prompt technical help regarding payroll check transactions not matching in QuickBooks, dial 1(800) 780-3064 to connect with a QB professional.
Why is Payroll Not Matching With Bank Transactions in QB?
The following list includes all the reasons why are payroll check transactions not matching in QuickBooks and can also be a reason why QuickBooks payroll not calculating taxes.
- Invalid payroll data and inaccurate paycheck amounts.
- Timing difference between payroll checks and bank transactions.
- Bank reconciliation problems.
- Duplicate bank transaction entries.
- Imprecise setup of payroll items.
Now that we understand all the reasons behind this problem let’s move to the following section to find some easy solutions. Before troubleshooting, it is important to import bank transactions into QuickBooks.
Quick Hacks to Match Payroll Check Transactions in QB
Before we look at detailed troubleshooting tactics, let’s review some quick fixes that can help you instantly resolve the issue. However, if you are unable to access the check register in QuickBooks, you need to get that resolved first.
Common Error Cause | Appropriate Resolution |
Invalid Payroll Items. | Review your payroll items section and make the necessary changes. |
Bank Reconciliation Issues. | Check the ending balance in the bank statement and review outstanding transactions. |
Discrepancy in Payroll Transactions. | Run the payroll summary report. |
Incorrect Payroll Liabilities. | Review and adjust payroll liabilities. |
Defective or obsolete web browser application. | Utilize a new web browser application. |
Let’s now move to the next section to explore detailed solutions for this issue.
6 Things to Do If QB Payroll Check Transactions Not Matching
Before using any resolution for payroll check transactions not matching in QuickBooks, you need to do the following:
- Install the newest QuickBooks application updates. This will effectively allow you to obtain fresh tools, features, and bug fixes for the troubleshooting process.
- Ensure that you have imported bank transactions in QuickBooks. If you get an error when importing bank transactions in QB, you need to fix it instantly.
Now, you can utilize all the troubleshooting tactics described below.
1. Edit the Paycheck Amount
The incorrect amount mentioned in the paycheck can prevent matching with QuickBooks bank feeds. It is essential to ensure accurate check transactions for seamless audit processes. Here’s how you can edit the paycheck amount:
- Open your QuickBooks Online account and choose Payroll.
- Now, select Employees, after which you need to choose the Paycheck List tab.
- At this point, you should select the relevant paycheck from the list.
- Tap Edit and click Yes. After that, make necessary changes to the paycheck amount.
- Finally, tap Save, after which the paycheck amount will match your bank transaction data. If you notice that QB reports are not showing memo or description when printing bank transactions, you need to fix it instantly.
Are payroll check transactions not matching even now? If that’s the case, try implementing the following solution.
2. Utilize the Find Match Tool
The Find Match tool can help you match bank transactions to existing QuickBooks records.
Here’s how you can run the Find Match tool:
- Firstly, you need to open your QB Online account to select the Banking menu.
- Choose the Bank Transactions tab, after which you should identify the relevant transaction.
- Now, click the Transaction and choose Find Match.
- You will see various options on the window. Once you review all the options, you should mark the box beside the relevant transaction to match.
- There is also a Filter option through which you can select a specific list of entries.
- At this point, click Resolve and fill out all the fields as per your requirement.
- Type the appropriate amount in the Amount field.
- Tap Save, after which all payroll check transactions will match your QuickBooks records. If you still find QuickBooks payroll not deducting taxes, you need to resolve it immediately.
Are payroll checks not matching to transactions in QuickBooks? If so, consider removing duplicate transactions as described below.
You May Also Like to Read: 7 Solutions for QuickBooks Payroll Liabilities Not Showing
3. Exclude Duplicate Bank Transactions
Sometimes, bank transactions automatically update in QuickBooks even when you have already uploaded them. As a result, QuickBooks records include duplicate transactions. These transactions won’t match with payroll checks. Here’s how you should remove duplicate transactions:
- Open the QuickBooks Online account and quickly choose the Transactions menu.
- Now, select Bank Transactions, after which you should choose the For Review tab.
- Review each transaction shown on the window. Moreover, you have to mark the checkbox of all those transactions that you want to exclude.
- At this point, click the Exclude button.
- All the excluded transactions will shift to the Excluded tab. These transactions will never be downloaded again.
If payroll check transactions are not matching in QuickBooks even now, consider reviewing the paycheck mapping to the bank account as detailed below.
4. Check the Paycheck Connection With the Bank Account
Sometimes, paychecks are posted to an incorrect bank account. As a result, paycheck data do not match the required bank transactions registered in QuickBooks. Here’s the process to verify the paycheck mapping to the bank account:
Step I: Find the Bank Account Used in the Paycheck
- Open the QB Online account and choose the Payroll menu.
- You should select Employees, after which you need to right-click the Paycheck List icon.
- Access the Filter section and change the date.
- Locate the relevant paycheck in the list and click the appropriate transaction.
- At this point, you should note the bank account shown in the Paid From section.
- Now, tap Delete to erase the relevant paycheck.
- Tap Yes to confirm the deletion of the selected paycheck.
Now, you should assign a valid bank account in your payroll settings, as detailed below.
Step II: Allot a Correct Bank Account in Payroll
- Choose the Gear icon located on the QB Online window.
- Click the Payroll Settings tab, after which you should use the drop-down option to choose Accounting.
- Now, click Edit and move to the Bank Account section.
- At this point, you have to choose the appropriate bank from the list.
- Tap Continue, after which you should click Done. You have now assigned the correct bank account in payroll.
Let’s recreate the relevant paycheck, as discussed in the next step.
Step III: Recreate the Appropriate Paycheck
- Open QuickBooks Online and swiftly choose Payroll.
- Now, you have to select Employees, after which you need to click Run Payroll.
- Tap Continue, after which you should check the Pay Period and Pay Date.
- At this point, choose the relevant employee, after which you should tap the Actions tab.
- Click Edit Paycheck and type all the pay details.
- Tap Preview Payroll and check the Bank Account assigned to track your payroll.
- Finally, click Submit Payroll, after which you should tap Close.
Are payroll check transactions not matching in QB Online even now? If so, try running your browser in incognito mode, as detailed below.
You May Also Like to Read: 3 Easy Steps For QuickBooks Payroll Subscription Renewal
5. Open the Web Browser in Incognito Mode If Payroll Check Transactions Not Matching
The accumulation of too much historical data, cache, and cookies in the browser can cause multiple problems. The solution is to run your browser in incognito mode.
Here’s the table that describes the shortcut keys necessary for opening the incognito window depending on the browser you use.
Web Browser Application | Shortcut Keys |
Google Chrome | Ctrl + Shift + N |
Safari | Command + Shift + N |
Mozilla Firefox | Ctrl + Shift + P |
If you continue to notice payroll check transactions not matching, consider utilizing a different web browser, as discussed in the following solution.
6. Use a Different Web Browser Application
You can effortlessly ensure precise matching of payroll checks to QB records by using a new web browser. Here’s the table that illustrates all the browsers that are recommended to access QB Online:
Web Browser Application | Suitable Version |
Google Chrome | 78 or Newer |
Microsoft Edge | 79 or Newer |
Opera | 68 or Newer |
Mozilla Firefox | 76 or Newer |
Safari | 12 or Newer (Mac Only) |
Samsung | 10 or Newer |
Note: All the web browsers listed above are suitable for use on both web and mobile devices.
Once you have matched all the payroll check transactions by using a new web browser application, you can seamlessly manage all financial reports and audit processes.
Winding Up
In this article, we have explored the verified resolutions for payroll check transactions not matching in QuickBooks. Hopefully, you can now make sure that all the payroll checks match QB records seamlessly. If, however, you are still experiencing various challenges or have a query, you can connect with a QB professional for immediate assistance.
For other issues with QuickBooks and payroll, you can always check the A2 Autocare knowledge base.
Common Queries On QB Payroll Check Transactions
Why do payroll check transactions not match in QuickBooks?
The common reasons behind payroll check transactions not matching in QuickBooks are invalid paycheck amount and imprecise mapping of bank accounts with paychecks. In addition, cache data in the browser can trigger this problem.
What should I do when payroll checks do not match the amount on payroll?
You should verify the paycheck amount and ensure proper mapping of bank accounts to the paycheck. Furthermore, you can shift to a new web browser application to access QB Online.
Can duplicate transactions also provoke the payroll check mismatching issue in QB Online?
Yes, duplicate transactions can cause payroll check mismatching very frequently. The solution is to erase duplicate paychecks from QuickBooks records. Furthermore, you can delete multiple transactions in QuickBooks Desktop.
Gabby Taylor, combines financial expertise with literary prowess. With over a decade in finance, she crafts insightful narratives on navigating fiscal complexities