{"id":3545,"date":"2019-11-12T07:36:30","date_gmt":"2019-11-12T12:06:30","guid":{"rendered":"https:\/\/www.apps4rent.com\/blog\/?p=3545"},"modified":"2023-08-09T12:06:40","modified_gmt":"2023-08-09T16:36:40","slug":"how-to-reconcile-in-quickbooks","status":"publish","type":"post","link":"https:\/\/www.apps4rent.com\/blog\/how-to-reconcile-in-quickbooks\/","title":{"rendered":"How to Reconcile in QuickBooks?"},"content":{"rendered":"\n<p>Businesses\nranging from small ventures to large enterprises undertake several\ntransactions, often in thousands, making it difficult to keep track of all of\nthem. They require comprehensive bookkeeping practices to ensure that their\nrecords tally with those of the bank account and credit card account to which\nthe businesses have been linked. QuickBooks Desktop provides efficient tools to\nkeep track of the list of transactions and tally them with the right accounts.\nThis process called reconciliation of transactions in QuickBooks can be\nautomated. In this blog, we will see how to reconcile in QuickBooks.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Need for Reconciliation in QuickBooks <\/strong><\/h2>\n\n\n\n<p>While\nthe obvious necessity of reconciliation is to ensure that account statements\nwith various stakeholders\u2019 tally with the actual income and spending, it is how\nwell the information is captured that makes all the difference.<\/p>\n\n\n\n<p>Very often, businesses tend to overlook small amounts that are accrued through interest earned and service charges apart from bank charges. QuickBooks provides efficient methods to capture these details as well.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Things to Do Before Bank Reconciliation on QuickBooks<\/strong><\/h3>\n\n\n\n<p>Before we can understand <a href=\"https:\/\/www.apps4rent.com\/blog\/how-to-reconcile-in-quickbooks\">how to reconcile in QuickBooks<\/a>, let us run through the broad measures to be taken before reconciling a bank account on QuickBooks.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Take backups of your company file on QuickBooks.<\/li>\n\n\n\n<li>Select the account you want to reconcile and ensure that the beginning balance is correct.<\/li>\n\n\n\n<li>Enter the transactions that have not yet been cleared.<\/li>\n\n\n\n<li>Generate copies of the bank statement\/ credit card statement and generate the reconciliation report.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>How to Reconcile in QuickBooks &#8211; Explained<\/strong><\/h3>\n\n\n\n<p>There\nare two important screens to note during the reconciliation process in\nQuickBooks.<\/p>\n\n\n\n<p><em><strong>Begin reconciling<\/strong><\/em><\/p>\n\n\n\n<p>The first screen is where users begin the reconciliation process. It is here that they ensure that the data entered is complete and accurate. Users will reach this screen from the Settings drop-down menu under Tools.&nbsp;<\/p>\n\n\n\n<p>It\nis in the reconcile window that you have to select the account you want to\nreconcile and then enter the Ending Balance. The Statement end date is\npre-populated with 30 or 31 days after the last reconciliation. The date field\ncan be edited if needed. Similarly, the Beginning Balance is calculated as the\nsum of all previously cleared transactions.<\/p>\n\n\n\n<p>The\nreconciliation window also allows users to manually enter any Service Charge\nand Interest Earned that may have been unaccounted. Select<strong>&nbsp;Locate\nDiscrepancies<\/strong>&nbsp;to identify records that don&#8217;t match. The other\noption,&nbsp;<strong>Undo Last Reconciliation<\/strong>&nbsp;can be used if discrepancies\ncannot be tracked or the date of the opening balance has to be changed. On\nclicking the button, all previously reconciled transactions will be reverted.<\/p>\n\n\n\n<p>Click\non&nbsp;<strong>Continue&nbsp;<\/strong>if the information is correct.<\/p>\n\n\n\n<p><em><strong>Confirm reconciliation<\/strong><\/em><\/p>\n\n\n\n<p>The\nnext screen is where you will see more granular statement information where\ntransactions can be cleared. Ideally, the difference between the total\nappearing in this window and the bank statement should be zero. You can confirm\nthat the records tally by clicking on&nbsp;<strong>Reconcile<\/strong>.&nbsp;<\/p>\n\n\n\n<p>This\nscreen has buttons for performing other actions too.&nbsp;<\/p>\n\n\n\n<p>If\nyou are late reconciling the records, you can hide the transactions that have\noccurred after the statement period for which you are reconciling the records.\nIf there are still too many transactions, they can be resorted by clicking on\nthe title\/ header of the column.<\/p>\n\n\n\n<p>The&nbsp;<strong>Mark\nAll\/ Unmark All<\/strong>&nbsp;button selects or deselects all transactions.\nSelecting all transactions saves time when several balances have to be cleared\nat a time.&nbsp;<\/p>\n\n\n\n<p>The&nbsp;<strong>Go\nTo<\/strong>&nbsp;button allows you to find and edit specific transactions before you\nreconcile.<\/p>\n\n\n\n<p>You\ncan specify the visible columns on the screen using the&nbsp;<strong>Columns to\nDisplay<\/strong>&nbsp;button.<\/p>\n\n\n\n<p>Any\ninformation that has to be corrected can be done so using the&nbsp;<strong>Modify&nbsp;<\/strong>button.<\/p>\n\n\n\n<p>Under\nexceptional circumstances, when you may have to abandon your reconciliation,\nclick on&nbsp;<strong>Leave.&nbsp;<\/strong>Doing so will result in an asterisk (*) being\ndisplayed against the column of transactions.<\/p>\n\n\n\n<p>The\nlast button is&nbsp;<strong>Reconcile Now<\/strong>. Click on this button to confirm that\nyou have cross-checked your data.<\/p>\n\n\n\n<p>However,\nif there are any discrepancies, use the Reconciliation Discrepancy Report to\nadjust.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Why QuickBooks Desktop is Best for Bookkeeping<\/strong>?<\/h4>\n\n\n\n<p>Now that you know how to reconcile in QuickBooks, it is not difficult to comprehend why QuickBooks Desktop is the best software for bookkeeping. QuickBooks reduces mundane transactions cross-checking tasks to simple button clicks. Filing taxes couldn&#8217;t have been made simpler. If you plan to migrate to QuickBooks Desktop, <a href=\"https:\/\/www.apps4rent.com\/\">Apps4Rent<\/a> is your perfect partner to bring you the power of <a href=\"https:\/\/www.apps4rent.com\/quickbooks-cloud-hosting\/\">QuickBooks on the cloud<\/a>. Contact us to know more.<\/p>\n\n\n<style>.stick_popup{margin-top: -190px !important;}@media only screen and (min-width:99px) and (max-width:767px){.popup1 {display: none;}.stick_popup{width: 100% !important;margin-left: -188px !important;}}<\/style>\n<link rel=\"stylesheet\" type=\"text\/css\" href=\"https:\/\/www.clouddesktoponline.com\/blog\/wp-content\/themes\/apps4rentoffice\/popup\/stick-to-me.css\"\/><script src=\"https:\/\/www.clouddesktoponline.com\/blog\/wp-content\/themes\/apps4rentoffice\/popup\/stick-to-me.js\"><\/script><script>$(document).ready(function(){$.stickToMe({layer:'#stickLayer'});});<\/script>\n<p><\/p>\n<div class=\"jquery-script-ads\" align=\"center\"><\/div>\n<div id=\"stickLayer\" style=\"display:none;max-width:1000px;height:auto; width:800px;background:#fff;\" class=\"stick_popup\">\n<div class=\"stick_close\" onclick=\"$.stick_close()\">X<\/div>\n<div class=\"stick_content\" style=\"padding-left: 0px;padding-top: 0px;padding-bottom: 0px;\">\n<div class=\"col-md-6 popup1\" style=\"background: #f1ab4f;color: white;padding-right: 0px;padding-left: 0px;background: -webkit-linear-gradient(rgb(255 255 255), #70b545);height: 650px\"><img decoding=\"async\" src=\"https:\/\/www.apps4rent.com\/blog\/wp-content\/uploads\/2021\/01\/quickbooks-promotions.png\" alt=\"QuickBooks Promotion\"\/><\/div>\n<div class=\"col-md-6\">\n<p style=\"color: #289e0c;font-weight: 700;font-size: 27px;margin-bottom: 20px;\">Request for price promotions<\/p>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f5478-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"5478\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/blog\/wp-json\/wp\/v2\/posts\/3545#wpcf7-f5478-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"5478\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.5\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f5478-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_group_fields\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_visible_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_repeaters\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_steps\" value=\"{}\" \/><input type=\"hidden\" name=\"_wpcf7cf_options\" value=\"{&quot;form_id&quot;:5478,&quot;conditions&quot;:[],&quot;settings&quot;:{&quot;animation&quot;:&quot;yes&quot;,&quot;animation_intime&quot;:200,&quot;animation_outtime&quot;:200,&quot;conditions_ui&quot;:&quot;normal&quot;,&quot;notice_dismissed&quot;:false,&quot;notice_dismissed_rollback-cf7-5.9.5&quot;:true}}\" \/>\n<\/fieldset>\n<style>.inputf{font: 16px 'Roboto';font-family: sans-serif; font-weight: normal;font-style: normal;line-height: 25px;color:#666 !important; padding: 5px 20px !important;font-size: 16px;border: #9d9fa0 1px solid !important;margin-bottom:20px !important;box-sizing: border-box;border-radius: 3px !important;width: 100%;}.inputf2{font: 16px 'Roboto';font-family: sans-serif; font-weight: normal;font-style: normal;line-height: 25px;color:#666 !important; padding: 8px 20px !important;font-size: 16px;border: #9d9fa0 1px solid !important;margin-bottom:20px !important;box-sizing: border-box;border-radius: 3px !important;width: 100%;}\n.cf7-style div.wpcf7-response-output{width: fit-content !important;margin: 0px;padding: 5px !important;}\n.button1 {padding: 15px 20px;font-size: 22px !important;background: #ff9307 !important;border: 1px solid #ff9307 !important;font-family: sans-serif;color: #fff;border: #9dbfff 2px solid;box-shadow: none;font-weight: bold;margin-bottom:0px !important;width: 100% !important;}\n<\/style>\n<style>@media only screen and (min-width:99px) and (max-width:767px){#content{margin-left:0px auto;}.sec {width:100% !important;float: none !important;}.html input[type=\"button\"], input[type=\"reset\"], input[type=\"submit\"]{font-size:16px !important;}}\n<\/style>\n<div style=\"padding-left: 15px;padding-right: 15px;padding-top: 15px;padding-bottom: 0px;\">\n\t<div style=\"float: left;width: 100%;margin-right: 15px;\" class=\"sec\">\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"Name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required inputf\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Name*\" value=\"\" type=\"text\" name=\"Name\" \/><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div style=\"float: left;width: 100%;margin-right: 15px;\" class=\"sec\">\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"contact\"><input size=\"40\" maxlength=\"10\" minlength=\"6\" class=\"wpcf7-form-control wpcf7-tel wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-tel inputf\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Contact Number*\" value=\"\" type=\"tel\" name=\"contact\" \/><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div style=\"float: left;width: 100%;\" class=\"sec\">\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"email\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email inputf\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Email ID*\" value=\"\" type=\"email\" name=\"email\" \/><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div style=\"float: left;width: 100%;margin-right: 15px;\" class=\"sec\">\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"desktop\"><input size=\"40\" maxlength=\"5\" minlength=\"1\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required inputf\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Number of Users*\" value=\"\" type=\"text\" name=\"desktop\" \/><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div style=\"float: left;width: 100%;margin-right: 15px;\" class=\"sec\">\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"lookingfor\"><select class=\"wpcf7-form-control wpcf7-select inputf2\" aria-invalid=\"false\" name=\"lookingfor\"><option value=\"Licenses or Hosting\">Licenses or Hosting<\/option><option value=\"Licenses Only\">Licenses Only<\/option><option value=\"Hosting Only\">Hosting Only<\/option><option value=\"Licenses + Hosting\">Licenses + Hosting<\/option><\/select><\/span>\n\t\t<\/p>\n\t<\/div>\n\t<div style=\"float: left;width: 100%;margin-bottom:20px;\" class=\"sec\">\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"msg\"><textarea cols=\"40\" rows=\"3\" maxlength=\"250\" minlength=\"2\" class=\"wpcf7-form-control wpcf7-textarea inputf\" aria-invalid=\"false\" placeholder=\"Message\" name=\"msg\"><\/textarea><\/span>\n\t\t<input class=\"wpcf7-form-control wpcf7-hidden\" value=\"\" type=\"hidden\" name=\"timezone\" \/>\n\t\t<input class=\"wpcf7-form-control wpcf7-hidden\" value=\"\" type=\"hidden\" name=\"user_time\" \/>\n\t\t<\/p>\n\t<\/div>\n\t<div>\n\t\t<p><input type=\"submit\" class=\"button1\" onclick=\"this.form.submit();this.disabled = true;\" value=\"SUBMIT REQUEST\" \/>\n\t\t<\/p>\n\t<\/div>\n<\/div><p style=\"display: none !important;\" class=\"akismet-fields-container\" data-prefix=\"_wpcf7_ak_\"><label>&#916;<textarea name=\"_wpcf7_ak_hp_textarea\" cols=\"45\" rows=\"8\" maxlength=\"100\"><\/textarea><\/label><input type=\"hidden\" id=\"ak_js_1\" name=\"_wpcf7_ak_js\" value=\"78\"\/><script>document.getElementById( \"ak_js_1\" ).setAttribute( \"value\", ( new Date() ).getTime() );<\/script><\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Businesses ranging from small ventures to large enterprises undertake several transactions, often in thousands, making it difficult to keep track of all of them. They require comprehensive bookkeeping practices to ensure that their records tally with those of the bank account and credit card account to which the businesses have been linked. QuickBooks Desktop provides [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":3547,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[541],"tags":[],"class_list":["post-3545","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-quickbooks"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/posts\/3545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/comments?post=3545"}],"version-history":[{"count":2,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/posts\/3545\/revisions"}],"predecessor-version":[{"id":8049,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/posts\/3545\/revisions\/8049"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/media\/3547"}],"wp:attachment":[{"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/media?parent=3545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/categories?post=3545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.apps4rent.com\/blog\/wp-json\/wp\/v2\/tags?post=3545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}