Payroll

Hi there, @Lee0409.

When you use the bank feed in QuickBooks Online, you'll be able to add or match your transactions to ensure QuickBooks Online matches what's in your real-life bank account. I'll explain more about how it works.

To clarify, did you select Add instead of Match? Duplicates occur when you add downloaded transactions that you manually entered into the program. QuickBooks will create a new entry for you using the info from your bank. To avoid this, you have to match them.

 Here's how:

1. Navigate to the Banking menu and select Banking.
2. Select the tile for the account you use for payroll.
3. Go to the For Review tab.
4. Find the payment and click it to expand the details. If there's a similar record found, click the link(s) next to each to get more info. If the match is correct, click Match to accept it. If it’s not, select Find other matches button. Otherwise, if there's no match found, click the Find Match option.
   
5. You can use filters/search to locate the payroll expense. Then, hit Save.

Once done, QuickBooks marks the transaction on your register as "C," which means cleared. When you next reconcile your bank account, they're already selected, speeding up the bank reconciliation process.

Keep me posted if you need further assistance with this process and find new discoveries along the way! I'd love to chat about it. 

I have tried the match function and the system doesn't find any match so all my payroll entries are showing twice on the tax return function.

How do I correct this so my wages entry is correct without causing errors somewhere else?

Hello Vickilsloan, thanks for reaching out to the Community. We'd like to take a look further into this. Are you adding the transaction when it does not find a match in banking? Are you amending the payroll journal? Thanks

Hi

Thanks for coming back to me.

I run payroll monthly through quickbooks.

On banking I add it as it only comes out as a transaction once as they pay goes out the business account to the employee.

This is the first employee we ever had so I didn't know it would duplicate.

It does it as the net payment through banking and then the HMRC, Pension etc are also on banking so then on the cost of labour/wages on the tax return I have the full pay amounts listed monthly along with seperate payments for the above so everything is doubled.

I hope that makes sense.

Vicki

Hi Vicki, it's correct that Advanced Payroll doesn't create individual payment lines on the journal entry and we do recommend excluding the bank transaction if the JE is already posting to the bank account. 

You can manage which accounts the journal posts to in the Payroll settings > Chart of accounts. 

Any duplicate payments already added can be removed by navigating to Transactions > Banking > Categorised > Search and select Undo beside the transaction. The transaction(s) will then move back to the For review tab where they can be excluded. 

If you have any further queries, please get back to us below. :)