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

Reconciliation Payroll Deposits

I'm confused...!!!

I've reconciled the bank which included payments going out of the bank for payroll. The bank reconciled no problem. But a was left with a number of unreconciled transactions for the period.

When I looked in the account history all these unreconciled transactions where payroll bank deposits, everytime a payroll payment had been made a deposit entry for the identical amount is listed in the 'account history'. Obviously these trasnactions aren't on my bank statements so weren't included in any reconciliation and aren't marked with a 'C' or 'R' but if I try to delete them it changes the account balance and throws out my previous reconciliations.

Any help would be appreciated.

5 REPLIES 5
DivinaMercy_N
Moderator

Reconciliation Payroll Deposits

Hello there, @info910. I'm here to ensure you'll get the right support in fixing the reconciliation of your account.

 

Since you've mentioned that your account reconciliation is already correct and you can see transactions aren't included on your bank statement, I recommend reaching out to our Technical support team to further investigate these payroll bank deposits. They use specific tools to pull up your account in a secure place and guide you on what action you need to take. 

 

Also, in case you'll want to reconcile those unreconciled or uncleared transactions, you can do it manually by continuously clicking the Reconciliation status column to display the R (reconciled) sign.

 

For more information about reconciling your account in QuickBooks Online (QBO), feel free to visit this article: Reconcile an account in QuickBooks Online.

 

In QBO, it's easy to generate a handy copy of your reconciliations by pulling up a Reconciliation Report. This can serve as your reference guide in the future to avoid reconciliation issues. You can also either print or export it and save it on your desktop folder. 

 

I'm always here to help you if you need further assistance in reconciling your account in QBO. Don't hesitate to post your reply below. Have a good one. 

info910
Level 1

Reconciliation Payroll Deposits

Many thanks for your advice.

Before I contact technical support I want to reinstate the deleted deposit enteries so the bank account reconciliations are correct again.

How do I do this, as the transaction type is an 'Expense', the account is the 'Bank Account' but its a deposit?

Thanks again.

 

SarahannC
Moderator

Reconciliation Payroll Deposits

Hello there, @info910.

 

The transactions that will download in QuickBooks will depend on the financial data shared from your bank. We're unable to edit the deposits from your bank showing on your Bank Feeds. What we can do is exclude the expenses showing as deposits on the For Review tab.

 

The steps below will help you complete the task:

 

  1. Go to the Banking menu.
  2. Within the Banking tab, choose an account.
  3. Go to the For Review tab.
  4. Put a check mark beside the transactions.
  5. Click the drop-down arrow next to Batch actions.
  6. Select Exclude Selected.

 

Once done, manually enter the transaction. Here's how:

 

  1. Go to Accounting.
  2. Within the Chart of Account tab, select the correct account.
  3. Select Expense when adding a transaction.
  4. Hit Save and close.

 

You can also use this reference for the steps in case you need further information about balancing your bank account register: How to reconcile your accounts so they always match your bank and credit card statements?

 

If you have other questions about correcting the type of transactions being entered or showing in your QuickBooks Online, please let me know. I'll be here to assist. Take care and stay safe info910. 

info910
Level 1

Reconciliation Payroll Deposits

Hi, many thanks for your reply.

The deposit transactions I'm trying to delete aren't physically in the bank, so aren't being pulled down on the bank feed. [see attached image] Every payroll payment made to an employee, a second entry is appearing in the 'Chart of Accounts / Bank Account / Account History' for exactly the same amount but as a deposit. As these aren't physically in the bank, I don't need them to reconcile but if I try and delete them after I've reconciled that period I get a warning that the reconciliation balance has changed, even though these transactions havn't been included in the reconciliation.

EmmaM
QuickBooks Team

Reconciliation Payroll Deposits

Hello Info910, can you send us a screenshot of the expense itself? If the example you gave is one expense transaction, the only reason it would create a contra entry where one transaction is increasing the expense and one decreasing it is if in the expense category>category details the bank account has been selected as well as being selected in the payment account section. As long as the category relates to the payroll expense then that should be fine and mean the contra entry disappears.

Need to get in touch?

Contact us