cancel
Showing results for 
Search instead for 
Did you mean: 
donnam1
Level 1

The number of payments does not equal the register for bank reconcili ation purposes. can i drill down on that number?

the top of the bank rec screen, under the payments and deposits is a nu not equal whats in the register OR bank statement
4 Comments 4
Mark_R
Moderator

The number of payments does not equal the register for bank reconcili ation purposes. can i drill down on that number?

Thank you for posting here in the Community, @donnam1.

 

Allow me to provide some insights about the transactions from the bank register and reconciliation page in QuickBooks Online (QBO).

 

Firstly, what you see from the bank register are all transactions that were already cleared or reconciled. While on the reconciliation page are transactions that you're going to reconcile. You might want to read this article to know more about the bank register: What are accounts register in QuickBooks Online?

 

Then, to ensure your transactions under the payment and deposit column matches your bank statement, you'll want to compare the two transactions from the reconciliation page and to your bank statement. If they match, make sure there's a checkmark next to the amount in QuickBooks. However, if a transaction doesn't appear on your statement, don't mark it as reconciled.

 

I'm adding this article to learn more about reconciling in QBO: Reconcile an account in QuickBooks Online.

 

If you need any additional assistance while managing your bank transactions, you can leave a comment below. I'll be sure to get back to you.

Mark_R
Moderator

The number of payments does not equal the register for bank reconcili ation purposes. can i drill down on that number?

I'm back to make sure everything is clear, @donnam1.

Did the information I shared above answer your question? If you need further assistance with this, you're welcome to post again or leave a reply below. We're always here to help you.

Wishing you and your business continued success.

s_carlton
Level 1

The number of payments does not equal the register for bank reconcili ation purposes. can i drill down on that number?

I have a similar question.  While reconciling my account for a specified date range in QBO, I've marked all the transactions in the bank register that match my bank statement.  Each transaction on my bank statement is on the bank register in QBO, and there are no additional transactions on the QBO register that haven't been checked.  The number of payments and their amount matches.  However, QBO says there are 4 more deposits than my bank statement shows (though nothing has been left unchecked, and when I filter the transactions to look only at the deposits, the number of deposits matches my bank statement, not the number QBO is reporting.). Additionally, there is a discrepancy in the ending balances.  How can I resolve this issue?

DivinaMercy_N
Moderator

The number of payments does not equal the register for bank reconcili ation purposes. can i drill down on that number?

Hi there, @s_carlton. I want to ensure you'll be able to fix the reconciliation discrepancy.

 

The first step is to ensure you have the correct opening and beginning balances. Once verified, proceed to the steps below:

  1. Select Edit info in the Reconciliation window.
  2. Then, review the Ending balance and Ending date.
  3. Check your bank statement. Make edits as needed.
  4. Once done, select Save.

 

If you still see a difference, follow Steps 3 to 7 of this article: Fix issues at the end of a reconciliation in QuickBooks Online.

 

For more guidance in reconciling your account, please visit our Reconciliation hub. 

 

You can also run a reconciliation report to review your beginning and ending balances and to get a list of cleared and uncleared transactions.

 

Don't hesitate to post again here if you have any other concerns about reconciliation. I'm always around to help. Have a good one. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us