Skip to main content
J
JD01234
October 3, 2022
Solved

Advanced payroll & lack of journals

  • October 3, 2022
  • 1 reply
  • 0 views

Please could someone help?

 

I upgraded to Advance payroll and imported the accounts from standard payroll. After running payroll, I have one journal which shows the pay run as a whole.  Each member of staff has been paid, but in the banking feed, there are no journals to match the payments.  What am I doing wrong?

 

I tried to speak to customer support, but after  96 minutes on the QB chat; he decided to end the session without telling me as he couldn't fathom what was wrong.

 

Thank you for your time.

Best answer by Ashleigh1

Hello JD01234, thanks for coming back to us here, So in advanced payroll it doesn’t generate individual journals for each employee on the pay run,  the only thing that you can do is create each employee as a sub location of the primary location, assign these to the employees, then go to the payroll settings > chart of accounts > default accounts and select split payment account by location you may have to delete the payrun and re-run it to show the journals split by location and therefore the individual amounts can be matched up to the bank.

1 reply

M
Mark_R
October 3, 2022

Hi there, @JD01234.

 

I'm here to help ensure you can match the journals created by QuickBooks when upgrading to the Advanced version.

 

Matching the bank payments to the journals depends on the payment account used in the journal. You can go to the Payroll settings and check the default accounts used. This is separate from the Wage Expenses account and is used to account for the wages paid to employees. The usual default for this is Payroll Clearing which is a liability account.

 

If it's the account used in the journals, you can record an expense transaction manually for each employee which will then allow you to match to the individual transactions in the bank feeds. Here's how:

 

  1. Sign in to your QBO account.
  2. Click the + New button, then select Expense.
  3. Select the employee from the Payee drop-down.
  4. Then, enter the date when it was paid and choose the appropriate bank account.
  5. Select the Payroll Clearing account from the Category drop-down.
  6. Enter the necessary information.
  7. Click Save and close.

 

Once done, you can now match each transaction to the payments. If you need more guidance about matching transactions, feel free to check out this article: Categorise and match online bank transactions in QuickBooks Online.

 

Come back to this post and let me know how it goes, @JD01234. I want to make sure you're taken care of.

 

Once you're ready to reconcile your bank account, you can read this article for the detailed steps: Reconcile an account in QuickBooks Online. This will help make sure your QuickBooks transactions match your bank statement.

 

Have a good one!

J
JD01234Author
October 4, 2022

Thank you, Mark_R, for your advice

 

Am I  correct in thinking that Advance Payroll does not generate individual journals for each employee on the pay run, and you have to create either an expense or Journal manually to match to the banking feed?  

 

The chart of accounts is set up correctly; it was just the lack of journals I was concerned with.  I'm not sure I like the idea of having to post an expense for each employee manually 😮 

A
Ashleigh1Answer
October 4, 2022

Hello JD01234, thanks for coming back to us here, So in advanced payroll it doesn’t generate individual journals for each employee on the pay run,  the only thing that you can do is create each employee as a sub location of the primary location, assign these to the employees, then go to the payroll settings > chart of accounts > default accounts and select split payment account by location you may have to delete the payrun and re-run it to show the journals split by location and therefore the individual amounts can be matched up to the bank.

Terms & ConditionsAccessibility statement