Skip to main content
December 22, 2019
Question

How do I match 2 banking entries against 1 payroll entry? An employee had an advance on their wages.

  • December 22, 2019
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

Jen_D
December 22, 2019

It's my pleasure to have you here, @anicklin,

 

At the moment, matching an expense to multiple downloaded bank transactions is currently not an option in QuickBooks Online. You must exclude the banking entry then manually clear the payroll check in the register.

 

This way, the total amount in your bank still matches with what's inside QuickBooks. To exclude online banking transactions:

 

  1. Go to the Banking menu from the navigation panel.
  2. On the Banking page, tap the For Review tab.
  3. Mark the box next to the transactions to exclude.
  4. From the Batch actions drop-down, choose Exclude Selected.

To manually update the paycheque status:

 

  1. Click on Accounting from the left toolbar.
  2. Select Chart of Accounts.
  3. Look for the account where the cheque was added, and click Account History.
  4. Find the transaction that needs to be cleared.
  5. Tap to highlight the transaction.
  6. Tick status field in between the Deposit and VAT columns. Continually click to get the cleared (C) status.

 

  • C - Cleared
  • - Reconciled
  • Blank - Not cleared or reconciled
  1. Hit Save when done.

Here's how it looks like in QBO:

 

 

See this article to learn more about manually reconciling an account: Undo and remove transactions from reconciliations in QuickBooks Online.

 

If you have any more concerns with QuickBooks, let me know in the comment section below. I'll be more than happy to share additional insights and assistance whenever you need one. Have a great day!