{"id":26736,"date":"2024-07-24T17:47:44","date_gmt":"2024-07-24T17:47:44","guid":{"rendered":"https:\/\/synder.com\/blog\/?p=26736"},"modified":"2024-10-04T07:11:29","modified_gmt":"2024-10-04T07:11:29","slug":"how-to-fix-reconciliation-discrepancies","status":"publish","type":"post","link":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/","title":{"rendered":"How to Fix Reconciliation Discrepancies in QuickBooks Online? QuickBooks Online Essentials"},"content":{"rendered":"\n

Imagine that you open your QuickBooks Online ledger and find a transfer recorded several times. You removed one entry, thinking that the one you deleted hadn’t been processed yet. However, upon getting down to reconcile your accounts, you found that the opening balance wasn\u2019t correct.<\/p>\n\n\n\n

Sounds familiar? Then you’ve landed on the right page, because here, we’re going to dig into ways of fixing reconciliation discrepancies.<\/p>\n\n\n\n

\n\n\n\n

Key takeaways:<\/strong><\/h2>\n\n\n\n
    \n
  1. To resolve reconciliation discrepancies, review QuickBooks Online balances, run reports of transactions to compare with bank statements and edit transactions.<\/li>\n\n\n\n
  2. You should use automation aid to sync and categorize the data, update your records in real-time, and flag any discrepancies.<\/li>\n\n\n\n
  3. Regular reconciliation ensures you have accurate financial records for your business and the rationale to make better decisions in your business.<\/li>\n<\/ol>\n\n\n\n
    \n\n\n\n

    <\/p>\n\n\n\n

    Contents:<\/b><\/h3><\/p>\n

    1. What are QuickBooks Online reconciliation discrepancies?<\/a><\/p>\n

    2. How to fix reconciliation issues in QuickBooks Online?<\/a><\/p>\n

    3. How automation prevents QuickBooks account discrepancies<\/a><\/p>\n\n\n\n

    <\/p>\n\n\n\n

    What are QuickBooks Online reconciliation discrepancies?<\/strong><\/span><\/h2>\n\n\n\n

    QuickBooks reconciliation differences are all those differences between what\u2019s in your records in QuickBooks and what\u2019s on the bank statement you find while reconciling accounts<\/a>. <\/p>\n\n\n\n

    There may be different sources of QuickBooks reconciliation problems such as the ones in the image below.<\/p>\n\n\n\n

    <\/p>\n\n\n

    \n
    \"\"<\/figure>\n<\/div>\n\n\n

    <\/p>\n\n\n\n

    Let\u2019s now take a closer look at them.<\/p>\n\n\n\n

    1. Missing transactions<\/strong><\/h3>\n\n\n\n

    These are transactions that are on your bank statement but not in QuickBooks, either because you\u2019ve missed recording a transaction or sometimes the bank makes some error. For instance, when a payment of $150 to any supplier is on your bank statement but wasn\u2019t recorded in QuickBooks, that presents a disparity.<\/p>\n\n\n\n

    2. Duplicate entries<\/strong><\/h3>\n\n\n\n

    This would involve the occurrence of a duplicate journal entry where some transaction has been recorded more than once in QuickBooks. It usually is the result of input errors such as several entries of the same transaction or importation of multiple transactions without cross-checking. For example, if you record a $200 sale twice, your income will wrongly increase.<\/p>\n\n\n\n

    3. Wrong amounts<\/strong><\/h3>\n\n\n\n

    Different amounts occur when a transaction is recorded in QuickBooks with a different amount from that shown on the bank statement. Examples may include entry errors or currency conversion problems, etc. Suppose you receive a payment of $500 but put it by mistake into QuickBooks as $50; this discrepancy will then lead to inaccuracies. To correct such errors, you may need to create a journal entry for reconciliation discrepancy<\/a> to adjust the figures and ensure your financial records reflect the correct transaction amount.<\/p>\n\n\n\n

    4. Different dates<\/strong><\/h3>\n\n\n\n

    Date mismatches refer to situations when the date applied to any transaction in QuickBooks fails to correspond to a bank statement date due to delays in processing time, differences in the dates of entry, or even human error during data entry. For example, a check dated and entered into QuickBooks on the date that it was written wouldn\u2019t show on the bank statement until the date on which it was cleared.<\/p>\n\n\n\n

    5. Cleared items <\/strong><\/h3>\n\n\n\n

    These are items that have previously been marked as cleared in QuickBooks but have never truly been cleared through the bank, or items that did clear the bank but were never reconciled or marked as cleared within QuickBooks. This could be because of a timing difference in data, data entry error, or just an oversight part of the reconciliation process. For instance, the $500 check that was marked as cleared in QuickBooks because you thought it would clear but was never actually processed by the bank because of insufficient funds leads to a discrepancy. Or a $200 payment drawn on the bank for which there was never an actual check in QuickBooks is also a mismatch.<\/p>\n\n\n\n

    All these differences must be reconciled so that your QuickBooks financial records show your proper bank balance. And it’s time now to talk about fixing reconciliation errors in your QuickBooks Online ledger.<\/p>\n\n\n\n

    How to fix reconciliation issues in QuickBooks Online?<\/strong><\/span><\/h2>\n\n\n\n

    For better experience, follow these steps to fix reconciliation discrepancies in QuickBooks Online:<\/p>\n\n\n\n

    <\/p>\n\n\n

    \n
    \"\"<\/figure>\n<\/div>\n\n\n

    <\/p>\n\n\n\n

    And here are some details of the fixing process:<\/p>\n\n\n\n

    Step 1. Review opening balance<\/strong><\/h3>\n\n\n\n
      \n
    1. Go to Accounting <\/em>and select the Chart of Accounts<\/em>.<\/li>\n\n\n\n
    2. Locate the account you want to reconcile and choose the View <\/em>register.<\/li>\n\n\n\n
    3. Scroll to the very top to the opening balance and ensure it’s the same as your bank statement. If it isn’t, click in the field beside Opening Balance<\/em> and update it.<\/li>\n<\/ol>\n\n\n\n

       Step 2. Run a Reconciliation Discrepancy report   <\/strong>  <\/h3>\n\n\n\n
        \n
      1. Click Reports<\/em>.<\/li>\n\n\n\n
      2. In the Search for reports<\/em> field type Reconciliation Discrepancy<\/em>.<\/li>\n\n\n\n
      3. Click on the Reconciliation Discrepancy report<\/em>.<\/li>\n\n\n\n
      4. Select the appropriate account you\u2019d like to reconcile.<\/li>\n<\/ol>\n\n\n\n

        The report must be checked for irregularities, such as modified, deleted, or added transactions.<\/p>\n\n\n\n

        Step 3. Check missing or duplicate transactions<\/strong><\/h3>\n\n\n\n
          \n
        1. Click on the Accounting <\/em>menu and then hit Reconcile<\/em>.<\/li>\n\n\n\n
        2. From the dropdown list of the accounts that have to reconcile, choose the proper account.<\/li>\n\n\n\n
        3. Using your bank statement, compare all of the transactions listed in QuickBooks to make sure all exist and there are no duplicates.<\/li>\n<\/ol>\n\n\n\n

          Step 4. Check the cleared status<\/strong><\/h3>\n\n\n\n
            \n
          1. Check the transactions for the cleared status in the Reconcile <\/em>window.<\/li>\n\n\n\n
          2. Make sure the transactions marked as cleared in QuickBooks’ Cleared <\/em>column match those marked as cleared on your bank statement.<\/li>\n<\/ol>\n\n\n\n

            Step 5. Adjust the transactions if needed<\/strong><\/h3>\n\n\n\n
              \n
            1. If the transactions don’t match, then click on a transaction to open and edit it.<\/li>\n\n\n\n
            2. Change the transaction amount, date or account as necessary to match the bank statement.<\/li>\n<\/ol>\n\n\n\n

              Step 6. Undo last reconciliation if necessary<\/strong><\/h3>\n\n\n\n

              If you’re not able to find the problem, you may have to undo the last reconciliation.<\/p>\n\n\n\n

                \n
              1. From the Accounting <\/em>menu, click Reconcile.<\/em><\/li>\n\n\n\n
              2. Select the account being reconciled.<\/li>\n\n\n\n
              3. Click the History by account<\/em> link and see all previous reconciliations.\u00a0<\/li>\n\n\n\n
              4. Select the newest reconciliation and then click the View report<\/em> link.<\/li>\n\n\n\n
              5. Click the Undo <\/em>button and redo the reconciliation from scratch.<\/li>\n<\/ol>\n\n\n\n

                If you still can’t find the difference, you may want to contact QuickBooks support or your accountant for further steps in resolution.<\/p>\n\n\n\n

                How automation prevents QuickBooks account discrepancies<\/strong><\/span><\/h2>\n\n\n\n

                An automation app like Synder makes reconciliation in QuickBooks Online much easier by synchronizing data from payment processors and sales channels, saving tons of time.<\/p>\n\n\n\n

                Synder Sync aggregates transaction data from over 30 payment platforms like Stripe or PayPal and sales channels such as Amazon or Shopify, and transfers it into your QuickBooks Clearing account, then pulling the correct amounts to your Checking account. When your bank statement is released, Synder will suggest matches for one-click reconciliation and flag mismatches if detected. With Synder, you get accurate financial records and detailed financial statements. <\/p>\n\n\n\n

                Wrapping up<\/strong><\/h2>\n\n\n\n

                The general steps to be taken in resolving reconciliation variances in QuickBooks Online are reconciling the opening balance, generating a Reconciliation Discrepancy report, looking for missing or duplicate transactions, checking the status of cleared items, and then introducing allowable adjustments. Finally, you need to make sure that all transactions match the bank statement and re-run the reconciliation report for confirmation.<\/p>\n\n\n\n

                Use an automation app like Synder to ensure a better experience of automatic synchronization and categorization of data from multiple sources into your books, have those records automatically updated in real time with potential reconciliation flags, making the process easier and more proper.<\/p>\n\n\n\n

                Share your thoughts<\/em><\/strong><\/h2>\n\n\n\n

                Have you encountered similar issues in your accounting process? What strategies or tools have you found effective in resolving these discrepancies? Share your experiences and tips with us!<\/em><\/p>\n\n\n\n

                <\/p>\n","protected":false},"excerpt":{"rendered":"Imagine that you open your QuickBooks Online ledger and find a transfer recorded several times. You removed one…\n","protected":false},"author":2254,"featured_media":26742,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"csco_singular_sidebar":"","csco_page_header_type":"","csco_page_load_nextpost":"","csco_post_video_location":[],"csco_post_video_url":"","csco_post_video_bg_start_time":0,"csco_post_video_bg_end_time":0,"footnotes":"","_ppma_block_editor_authors":""},"categories":[43,45,326],"tags":[255,57],"ppma_author":[391],"class_list":["post-26736","post","type-post","status-publish","format-standard","has-post-thumbnail","category-accounting","category-business-management","category-how-to-do-your-accounting","tag-business-owner","tag-quickbooks","cs-entry","cs-video-wrap"],"yoast_head":"\nHow to Fix Reconciliation Discrepancies in QuickBooks Online? The ABC of QuickBooks Online<\/title>\n<meta name=\"description\" content=\"Struggling with reconciliation discrepancies in QuickBooks Online? This guide helps resolve issues like missing transactions, duplicate entries, incorrect amounts, and data mismatches.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Fix Reconciliation Discrepancies in QuickBooks Online? The ABC of QuickBooks Online\" \/>\n<meta property=\"og:description\" content=\"Struggling with reconciliation discrepancies in QuickBooks Online? This guide helps resolve issues like missing transactions, duplicate entries, incorrect amounts, and data mismatches.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/\" \/>\n<meta property=\"og:site_name\" content=\"Synder blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SynderHQ\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-24T17:47:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-04T07:11:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/reconciliation-discrepancies-in-quickbooks-online.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"803\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Helga Vasilevsky\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Helga Vasilevsky\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Fix Reconciliation Discrepancies in QuickBooks Online? The ABC of QuickBooks Online","description":"Struggling with reconciliation discrepancies in QuickBooks Online? This guide helps resolve issues like missing transactions, duplicate entries, incorrect amounts, and data mismatches.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/","og_locale":"en_US","og_type":"article","og_title":"How to Fix Reconciliation Discrepancies in QuickBooks Online? The ABC of QuickBooks Online","og_description":"Struggling with reconciliation discrepancies in QuickBooks Online? This guide helps resolve issues like missing transactions, duplicate entries, incorrect amounts, and data mismatches.","og_url":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/","og_site_name":"Synder blog","article_publisher":"https:\/\/www.facebook.com\/SynderHQ\/","article_published_time":"2024-07-24T17:47:44+00:00","article_modified_time":"2024-10-04T07:11:29+00:00","og_image":[{"width":2560,"height":803,"url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/reconciliation-discrepancies-in-quickbooks-online.png","type":"image\/png"}],"author":"Helga Vasilevsky","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Helga Vasilevsky","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/#article","isPartOf":{"@id":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/"},"author":{"name":"Helga Vasilevsky","@id":"https:\/\/synder.com\/blog\/#\/schema\/person\/92b8d5f9f740c4e8f088f96f3194f67d"},"headline":"How to Fix Reconciliation Discrepancies in QuickBooks Online? QuickBooks Online Essentials","datePublished":"2024-07-24T17:47:44+00:00","dateModified":"2024-10-04T07:11:29+00:00","mainEntityOfPage":{"@id":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/"},"wordCount":1231,"commentCount":0,"publisher":{"@id":"https:\/\/synder.com\/blog\/#organization"},"image":{"@id":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/#primaryimage"},"thumbnailUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/reconciliation-discrepancies-in-quickbooks-online.png","keywords":["Business Owner","QuickBooks"],"articleSection":["Accounting","Business","How to Do Your Accounting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/","url":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/","name":"How to Fix Reconciliation Discrepancies in QuickBooks Online? The ABC of QuickBooks Online","isPartOf":{"@id":"https:\/\/synder.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/#primaryimage"},"image":{"@id":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/#primaryimage"},"thumbnailUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/reconciliation-discrepancies-in-quickbooks-online.png","datePublished":"2024-07-24T17:47:44+00:00","dateModified":"2024-10-04T07:11:29+00:00","description":"Struggling with reconciliation discrepancies in QuickBooks Online? This guide helps resolve issues like missing transactions, duplicate entries, incorrect amounts, and data mismatches.","breadcrumb":{"@id":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/#primaryimage","url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/reconciliation-discrepancies-in-quickbooks-online.png","contentUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/reconciliation-discrepancies-in-quickbooks-online.png","width":2560,"height":803,"caption":"How to Fix Reconciliation Discrepancies in QuickBooks Online? QuickBooks Online Essentials"},{"@type":"BreadcrumbList","@id":"https:\/\/synder.com\/blog\/how-to-fix-reconciliation-discrepancies\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/synder.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Business","item":"https:\/\/synder.com\/blog\/category\/business-management\/"},{"@type":"ListItem","position":3,"name":"How to Fix Reconciliation Discrepancies in QuickBooks Online? QuickBooks Online Essentials"}]},{"@type":"WebSite","@id":"https:\/\/synder.com\/blog\/#website","url":"https:\/\/synder.com\/blog\/","name":"Synder blog","description":"Business Hacks & Accounting Automation Use Cases","publisher":{"@id":"https:\/\/synder.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/synder.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/synder.com\/blog\/#organization","name":"Synder","url":"https:\/\/synder.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/LOG.svg","contentUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2024\/07\/LOG.svg","width":303,"height":332,"caption":"Synder"},"image":{"@id":"https:\/\/synder.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SynderHQ\/"]},{"@type":"Person","@id":"https:\/\/synder.com\/blog\/#\/schema\/person\/92b8d5f9f740c4e8f088f96f3194f67d","name":"Helga Vasilevsky","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2023\/02\/IMG_1865.jpg4617e45e979af54d7b8f72c03ef8f67b","url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2023\/02\/IMG_1865.jpg","contentUrl":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2023\/02\/IMG_1865.jpg","caption":"Helga Vasilevsky"},"description":"Helga is a FinTech writer at Synder, where she covers topics at the intersection of accounting, ecommerce and SaaS. After going through Synder\u2019s internal accounting training, she set out to explain financial processes, like reconciliation, tax automation, and multi-platform syncing, in a way that resonates with both accountants and business owners. Her articles are grounded in real user questions and crafted in collaboration with Synder\u2019s support and product teams.","sameAs":["https:\/\/www.linkedin.com\/in\/olga-vasilevaskaya-65b455102\/"],"url":"https:\/\/synder.com\/blog\/author\/olgavasilevskaya\/"}]}},"authors":[{"term_id":391,"user_id":2254,"is_guest":0,"slug":"olgavasilevskaya","display_name":"Helga Vasilevsky","avatar_url":"https:\/\/synder.com\/blog\/wp-content\/uploads\/sites\/5\/2023\/02\/IMG_1865.jpg","author_category":"","first_name":"Helga","last_name":"Vasilevsky","user_url":"","job_title":"","description":"Helga is a FinTech writer at Synder, where she covers topics at the intersection of accounting, ecommerce and SaaS. After going through Synder\u2019s internal accounting training, she set out to explain financial processes, like reconciliation, tax automation, and multi-platform syncing, in a way that resonates with both accountants and business owners. Her articles are grounded in real user questions and crafted in collaboration with Synder\u2019s support and product teams."}],"_links":{"self":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts\/26736","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/users\/2254"}],"replies":[{"embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/comments?post=26736"}],"version-history":[{"count":1,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts\/26736\/revisions"}],"predecessor-version":[{"id":27692,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/posts\/26736\/revisions\/27692"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/media\/26742"}],"wp:attachment":[{"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/media?parent=26736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/categories?post=26736"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/tags?post=26736"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/synder.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=26736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}