Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am using QBO + QBO Payroll. We have a 401k retirement plan. During each payroll cycle, the employee's contribution is tracked in a payroll liabilities account ("employee contribution liability"), and the company match is tracked as a payroll expense ("company contribution expense"). The 401k administration debits the full amount of both of those in a single transaction.
When the bank transaction shows up in QBO banking, how do I categorize it?
If it were 2 separate transactions, 1 would go into the liabilities account to offset the liability, and the other should match to the existing expense transaction. However, QBO doesn't allow these separately when splitting the transaction.
I'm willing to offer my time to help achieve your goal, @greg. Let me help you categorize your banking and payroll transactions in QuickBooks Online.
I understand you want to split the banking and payroll transaction under the Banking section. In your case, we can match the transaction directly to avoid duplicate transactions since it has existing payroll transactions.
Here's how:
Since QuickBooks automatically suggests expense accounts, we can click the Add option from the right side. Once done, it goes to the Categorise tab and is ready for reconciling process.
Nonetheless, did you receive any specific error while splitting the transaction? It w be a great help if you provide us with more details.
Furthermore, you can still unmatch the transaction if you discover that categorized to the wrong account. Refer to this page: Unmatch downloaded bank transactions or move them to another account.
I'm happy to share more steps with categorizing and reconciling topics in QuickBooks Online. Have a great day ahead.
@ChristineJoieR Thanks, but that was not a good solution for this issue. I'd suggest deleting it to avoid causing more issues for others that may find this post.
"3. Go to the Reviewed tab." -- There are options for "For Review" and "Categorized", not what you suggest.
"4. Select the Add column." -- This just adds the transaction as "uncategorized" which is the last thing I want.
We appreciate you getting back in on this thread, itsGreghere. Let's work together and ensure categorizing your banking and payroll transactions will get resolved.
As shared by my colleague, matching these entries will help us avoid duplicates in your account. Since there are existing payroll transactions, you may consider finding their match from the banking section and resolving their difference to offset and make the balance of your transaction accurate. Then, you may categorise them by manually choosing the right category if the suggested expense account option isn't associated with the transaction. To do this:
Also, I'd recommend consulting your accounting professional to guide you further in performing this process and what account would best fit when cateogrising them.
Moreover, you can check out this article to guide you in reconciling the accounts: Reconcile an account in QuickBooks Online.
We'll gladly back you up and provide further assistance for any additional questions about categorising transactions. Feel free to keep us posted so we can get you covered. Have a good one!
This does not work either. When selecting "find match" for the transaction, I only see a very short list of bills that I've entered that haven't been paid yet. Show "All" is selected. There are no payroll liabilities in the list at all (even though transactions often "match" automatically to various liabilities accounts).
Hello there, @itsGreghere. I appreciate you taking the time to perform the steps provided by my colleague above.
I have here details to share about your concern. Payroll liabilities don't usually show in the Find match section, instead, you'll only be able to see cheques. Note that you'll have to pay for the liabilities first before having them match in QuickBooks Online (QBO) Payroll.
To ensure you'll get to match your transactions, I suggest manually creating a cheque to pay your payroll liabilities in QBO. Here's how:
For detailed steps, kindly visit: Create and record cheques in QuickBooks Online.
Once done recording the payments, you can then match them in the Banking section.
Moreover, you also have the option to perform the steps in resolving differences to make the balance of your transactions accurate.
Additionally, you might want to check out this article to learn what to do if QuickBooks doesn't match your bank statement at the end of a reconciliation: Fix issues at the end of a reconciliation in QuickBooks Online.
I'm looking forward to having this sorted out. Feel free to leave a reply if you require further assistance with matching transactions in QBO. I'm always around to help. Keep safe.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here