Banks place this on checks they issue to help sort them and aid in reconciling bank statements

Bank Reconciliations

  1. Bank reconciliations are an essential internal control tool and are necessary in preventing and detecting fraud.  They also help identify accounting and bank errors by providing explanations of the differences between the accounting record’s cash balances and the bank balance position per the bank statement.

    The bank reconciliation ensures that all transactions that have gone through the bank statements have been reviewed and checked, thus reducing the probabilities of errors in the data used to prepare accounts.  Bank statements also ensure completeness by helping to ensure that all payments and receipts that have gone through the bank account have also been recorded in the accounting records.  Any differences are identified and explained.  (An example is below.)

    This function requires a segregation of duties, which means that the person who performs the bank reconciliations should not also have access to the recording of transactions in the accounting records or processing of cash disbursements or receipts.  Any differences identified between the accounting records and the bank statements should be adjusted by a person other than the one doing the reconciliations.

    A daily review and posting of bank transactions is done within the accounting department by separate accounting personnel to ensure all wires, ACH deposits and withdrawals, returned checks, and any other electronic items are recorded each day.  A full bank reconciliation of all bank accounts is done on a monthly basis, to be completed no later than the 25th day of the following month, and then approved by the Controller.

    All reconciling differences should be identified and any necessary journal entries to resolve the differences should be posted no later than 90 days after the reconciliation is done.  The bank should be contacted concerning any bank errors which should also be resolved within 90 days.

    Adjust cash account in general ledger (Section 1)
    Balance per cash account in general ledger ___
     
    Adjustments to cash account (based on bank statement):
      Add: Bank interest ___
        Credit / wire transfers ___
      Subtract: Bank charges ___
        Standing orders ___
        Direct debits / ACH ___
        Dishonoured checks ___
      Add/Subtract: Errors  
    Adjusted cash account in general ledger X
           
    Adjust balance on bank statement (Section 2)
    Balance per bank statement ___
           
    Adjustments to bank statement balance (based on accounting records):
      Add: Deposits in transit ___
      Subtract: Checks issued, but have not cleared bank ___
      Add/Subtract: Bank errors  
    Adjusted balance per bank statement Y
           
    Compare adjusted balances (Section 3)
    Adjusted cash account in general ledger X
    Adjusted balance per bank statement Y
    Difference Z
           
    Reconciling items  
      Item a – short description ___
      Item b – short description ___
       
    Total reconciling items (= Difference) Z
           

    Prepared by:_______________________________________ Date___________

    Approved by:_______________________________________ Date__________

Reconciliation discrepancy

Uncheck "hide transactions after statement date" , sort transactions by amount. That should help you find the one future item that was marked cleared 

Reconciliation discrepancy

Thank you! This really helped!

Reconciliation discrepancy

Glad to help, I have had the same thing happen to me

Reconciliation discrepancy

So I'm having this exact same issue, but all of the Uncleared Checks and Payments after 2017 (I'm working on Reconciling 2018) don't match up to the "Difference" amount on the Reconcile page. I know for a fact that there is an extra payment of $300.00. I can't sort the list by amounts on the Reconciliation Summary. 

Reconciliation discrepancy

Thanks for joining this thread, HHHInc.

I'm here to help you resolve the reconciliation differences.

First, let's sort the transactions by amount. I'll show you how:

  1. On the Reconcile page, click the Payment column twice.
  2. Double-click the Deposit column.

Please refer to the screenshot below.

As for your main concern, there are a few reasons why the difference amount won't match up on the Reconcile page. It's possible that there are missing transactions, incorrect opening or ending balance.

To make sure the beginning balance of the reconciliation is correct, please follow the steps below:

  1. On the Reconcile page, click the Edit info button.
  2. In the Edit the information from your statement screens, verify that the Ending balance and Ending date information matches the information from your statement (refer to the screenshot below).
  3. Make any necessary changes to the Ending balance and Ending date.
  4. Click Save.

This article will provide you more troubleshooting about reconciliation: How to resolve reconciliation differences.

That should do it. Let me know how this turns out. I'm happy to help some more if you have questions in QuickBooks Online. Have a good one.

Reconciliation discrepancy

So the Beginning and Ending Balance are correct. The number of transactions for the month of January 2018 are correct. I've printed out the Bank statement and the January transactions to Reconcile and went through them line by line and everything matches up. Just getting an extra payment amount of $300.00 but I can't seem to be be able to figure out where it came from. Could it be possible that the data is corrupted somehow?

Reconciliation discrepancy

Hello, @HHHInc.

Allow me to step in and help share additional information about where this payment came from.

This might be a duplicate payment. To check this out, you'll need to open this extra payment and check if the date and amount match with your bank statement. If it shows up, check your Bank Register in QuickBooks to see if this is a duplicate transaction. If it is, you'll need to delete the extra payment.

Keep me posted how it goes. I'll be here to help if you have other questions about your reconciliation discrepancy.

Reconciliation discrepancy

Now how would I be able to open this extra payment? I printed out the list of transactions from the Reconcile screen and my Bank Statement and went line by line checking them off. I can't seem to find it, and QBO doesn't make it easy to find said extra payment. 

Reconciliation discrepancy

Thanks for sharing a screenshot and keeping us updated, HHHInc.

Let me help you fix the reconciliation difference.

It looks like the difference between your bank statement and QuickBooks Online is a single transaction amount. If so, filter the list to search for a transaction of that amount.

Let me show you how:

  1. Click the Filter (funnel icon) button.
  2. Enter the amount of the difference in the Find field.
  3. Select Apply.

The screenshot below shows these steps as well.

Let's still give this a try, and see if the steps above will work. I'd like to make sure that you're able to resolve this concern, so please let me know how it goes by posting a comment below. Best regards. 

Reconciliation discrepancy

Nope, same thing. Could there be an issue with the data imported in from the bank stream?

Reconciliation discrepancy

Thanks for coming back to the Community, HHHInc.

I can share another troubleshooting that will help us determine the reason of the difference amount.

This issue may be caused by a transaction that was manually reconciled in your register. Since we don't currently have an option to review which transaction was manually reconciled, please undo the entire reconciliation. To do this, you must edit each transaction.

Let me show you how:

  1. Click the Gear icon at the top.
  2. Choose Chart of Accounts.
  3. Locate the appropriate account for the transaction, and click View Register.
  4. Identify the transaction to edit.
  5. In the reconcile status column (indicated by a check mark), repeatedly select the top line of the transaction to change the status of the transaction.
  6. Codes indicate the status of the transaction (refer to the screenshot below):
  • C - Cleared
  • R - Reconciled
  • Blank - Not cleared or reconciled

             7. Select Save.

If you have too many transactions to edit and you're connected to an accountant in QuickBooks Online, you can ask them to undo the reconciliation for you.

Once done, please check your register if there is still a reconciled transaction. In most cases, that's the reason for the difference amount. If it's a duplicate transaction, then you can delete it.

Lastly, reconcile your account again.

I'd like to make sure that you're able to resolve your reconciliation, so please let me know how it goes by posting a comment below. Best regards. 

Reconciliation discrepancy

Good Morning,

Thank you for helping me. I would like to know how to fix a reconciliation discrepancy on a credit card. I have a 4,352 $ reconiliation discrepancy on a credit card and don't know how to deal whit it.

Thank You

Reginald 

Reconciliation discrepancy

Good morning,

Thank you for helping me, Until today I am trying to fix a reconciliation discrepancy that hapened on a credit card in February and don't know how to proceed. All the answers I could find are for checks but never for credit card reconciliation.

Regards,

RBilly

Reconciliation discrepancy

Sending good vibes to you, RBilly.

Let me help you fix your reconciliation discrepancy for credit card account in QuickBooks.

Editing the transactions can cause a discrepancy in your previous reconciliation. If you already reconciled the following month after February, you'll need to undo all the transactions that were reconciled and manually check each transaction for changes made.

If you decide to undo the last reconciliation you can follow the detailed steps provided by my peer above. Also, the assistance of an accountant is a must. Your accountant can provide you expert ways of dealing with this situation.

To know more about reconciliation in QuickBooks Online, check these out:

  • Reconcile hub.
  • How to unreconcile a transaction or undo a reconciliation.
  • Fix Reconciliation Discrepancies.

For account discussion, feel free to reach out to our QuickBooks Online Support. To reach us, please follow these steps:

  1. Sign into your QuickBooks Online Company.
  2. Click (?) Help at the upper right corner.
  3. Select Contact US on the pop-up.
  4. Enter a brief description of your concern then hit Continue.
  5. Click Get a callback.
  6. Enter your contact information.
  7. Select Call me.

You stay connected with me if you have more questions about reconciliation in QuickBooks Online. Have a nice day.

Reconciliation discrepancy

I'm having the same issue!!

I have counted the number of payments on the statement 209, I have gone through the quarter and ticked each one off, one by one and quickbooks counts 212 payments.

I'm not sure where the extra three are hiding but I've repeated this 4 times.  There is definitely 209 on the statement and going through one by one by one we somehow arrive at 212.

I've started by clearing all ticks and it starts at 0 and at some point 3 hidden transitions arrive on the tally and there is a discrepancy of $1,877.50.  I'm really confused! Please help.

Reconciliation discrepancy

Reconciliation discrepancy

I found three transactions for some reason were marked with a “C” in the register that tallied to $1,877.50.  I reconciled in register and marked them with an “R"

It then said the beginning balance is off, as they were from a previous reconciliation.  I then realised they were in fact duplicates.

What was confusing was that I was selecting the period 30/12/20 to 30/3/20 and these 3 payments were showing in the tally of the total payments.  It would have been nice if it was highlighted that the three hidden transactions were from the previous period. 

I have also realised why I was getting duplicates in the first place.  I had been using a third party plugin to scan receipts and these weren't always matching what was in the banking tab.  Maybe safer to add and match transactions in the banking tab in future.

Reconciliation discrepancy

Hi, I've spend so much time trying to solve this problem i decided to ask for help.  I'm reconciling my credit card account and it was working fine all the months prior.  I'm working on september 2019 and i now get a message saying "your account isn't ready to reconcile yet" beginning balance is off (see attached) i can't figured out why but i do know the difference is $1255.88 which on my statement is the payment i made.  What is wrong? 

Reconciliation discrepancy

Thanks for joining us here, test32.

It's possible that there are transactions that are unreconclied, modified or deleted. This can be the reason why the beginning balance is off. 

Depending on the reason why the amount is off, we have several troubleshooting steps to recommend. Instructions and additional details are discussed in this Help article: Fix beginning balance issues if you've reconciled the account in the past QuickBooks Online.

Keep us posted if you still need help with your reconciliation. We're always ready to jump in and offer our help again. 

Reconciliation discrepancy

Still no luck.  the screen where the items that are making the reconciliation off is empty hence, not sure where to look.  see attach

Reconciliation discrepancy

Thanks for the screenshot, @test32.

Before you can resume reconciling your account, you'll have to find the discrepancies in the reconciliation. In the red box, Your account isn't ready to reconcile yet, you can press on the blue hyperlink We can help you fix it to see the transactions that are causing the discrepancies. 

You can also run a Reconciliation Report to view previous reconciliations to see if everything has balanced out, as well as see what transactions were recorded. Here's how to run the report:

  1. Go to Reports.
  2. Type Reconciliation Report in the Find report by name search bar.
  3. Select Reconciliation Reports.
  4. Choose the Account for the reconciliation report you want to view.
  5. From the Report period drop-down arrow, pick the reconcile period.
  6. Hit View Report.

I'd like to provide you with a couple of Community Articles that you may find useful:

  • Fix beginning balance discrepancies
  • Reconcile an account in QuickBooks Online

If you need further assistance, please don't hesitate and reach back out to me! I'm just a Reply away.

**Say "Thanks" by clicking the thumb icon in a post
**Mark the post that answers your question by clicking on "Accept as solution"

Reconciliation discrepancy

Thank you so much, this enabled me found the error in the ending balance I entered. God bless you.

Reconciliation discrepancy

Hi John, where is the "hide transactions after statement date" found?

Reconciliation discrepancy

Hello there, Anonymous-1. 

I can show you where to find the option Hide transactions after the statement's end date option.

If you're using QuickBooks Desktop, you can see it in the Reconcile window. Here's how: 

  1. Click the Banking menu and click Reconcile.
  2. Enter the information in the Begin Reconciliation window and click Continue.
  3. At the upper-right of the Reconcile window, you can see the Hide transactions after the statement's end date checkbox.

If you're using QuickBooks Online the system will automatically hide transactions that are beyond the ending date you entered.

For more details in the reconciliation process, you can visit this link: Learn the reconcile workflow in QuickBooks.

Should you have any other questions about your accounts please don't hesitate to mention me in your reply. Take care!