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

Categorizing Employee Wages

Hi All,

 

I have been using QB Online advanced payroll now for around a two months, I noticed the other day in my dashboard that I had two lots of PAYE payments showing as expenses. On investigation a journal entry has been being created each time I run payroll, I had also created an account called "Wages Expenses" and had been logging the payments coming out of the bank account under this category. I can tell this is wrong as it was doubling my wage expenses.

Is there a way to match the bank transaction to the journal entry to balance the account?

 

Hope this makes sense, I am relatively new to bookkeeping/payroll so any help would be really appreciated.

 

Thanks in advance!

8 REPLIES 8
EmmaM
QuickBooks Team

Categorizing Employee Wages

Hello Lex2021, Can you go to banking transactions and then on the line of the expense click the mouse and go to find a match. If the expenses are per employee what you may need to do is edit the journal to show the amount for the wage expense(net wages) in separate lines for each employee and then it will find a match. The alternative would be to exclude the transaction in the banking. There is a way to set up set each employee up as a sub-location of the primary location, and then change the primary location within the employee to the sub-location, in the default chart of accounts within the payroll settings and split by location the payment account, if you have this as your bank account then the payroll journal will show as individual amounts so then in future it will match the bank however that will not go back historically and do that so in those cases it would be editing the journal to individual lines or excluding in banking. We appreciate this is a lot, we can go into more detail on any of this if you would like.

Lex2021
Level 1

Categorizing Employee Wages

Hi Emma,

 

Thanks for your reply,

Tried to find a match per transaction line but it wasn't able to match to the journal.
I think the easiest thing for me to do would be to exclude from the banking, am I right in thinking as long as the journal entries are correct our records will be also if I am excluding the transactions?

There are only three of us on payroll currently so fairly easy to keep track of.

 

Thanks again,

Lex

 

RoseJillB
QuickBooks Team

Categorizing Employee Wages

Thank you for your prompt reply, @Lex2021. Let me address your concern about excluding your bank transactions.

 

Yes, but make sure that your journal entry is correct to avoid having any challenges with your records.

 

I included these article to help you on how to:

 

 

I’m happy to answer your concern about removing your bank transactions to fix your records. If you need further assistance, just hit the "Reply" button. Have a great day!

tombalky
Level 1

Categorizing Employee Wages

Hi Emma,

 

I still cannot find an Expense entry for wages. There is one called "wages and salary control" but this is mis-classifying wage expenses as a current liability. 
Can you please point me to the right category from the drop down menu for wages?
Thank you,
Tom

trianglet
Level 2

Categorizing Employee Wages

Did you figure this out Tom?

Been trying to get a straight answer out of Quickbooks, and they don't seem to want to engage.

GeorgiaC
QuickBooks Team

Categorizing Employee Wages

Hi Tom, are you able to post a screenshot of a full payroll journal (you can cover any personal info and leave the account names showing) so that we can point you in the right direction to categorise the expenses? 

Hi trianglet, thanks for joining this thread - are you using the QB Standard or Advanced version of payroll? 

trianglet
Level 2

Categorizing Employee Wages

I'm using standard

GeorgiaC
QuickBooks Team

Categorizing Employee Wages

Thanks trianglet, do you have a 'wages' account with the detail type 'payroll expenses' listed in your Chart of Accounts? 

Need to get in touch?

Contact us