--- title: 3-Way Reconciliation for Happy Numbers | SoftPro Blog description: What if a customer ledger had a negative balance for months? Or a mortgage payoff never cleared? Here are the risks of overlooked financial discrepancies. image: https://blog.softprocorp.com/hubfs/Reconciliation_sm.jpg --- **800-848-0143** Request a Demo [Contact Us](http://softprocorp.flywheelsites.com/contact-us/)[Blog](https://blog.softprocorp.com/?__hstc=190569908.2565e5b7b5a67b3a02e01a942807fecd.1514783189296.1514783189296.1514788403894.2&__hssc=190569908.1.1514788403894&__hsfp=2437171227)[Careers](http://softprocorp.flywheelsites.com/about/careers/) Search [MySoftPro Login](https://my.softprocorp.com/?__hstc=190569908.2565e5b7b5a67b3a02e01a942807fecd.1514783189296.1514783189296.1514788403894.2&__hssc=190569908.1.1514788403894&__hsfp=2437171227) SEARCH BLOGS SEARCH ALL [![softpro logoMain](https://blog.softprocorp.com/hubfs/softpro-logo.svg)](https://softprocorp.com/) - [Products](https://www.softprocorp.com/real-estate-software-solutions/) - [Overview](https://www.softprocorp.com/real-estate-software-solutions/) - [Standard](https://www.softprocorp.com/real-estate-software-solutions/softpro-standard/) - [Select](https://www.softprocorp.com/real-estate-software-solutions/softpro-select/) - [Hosted](https://www.softprocorp.com/real-estate-software-solutions/softpro-hosted-software/) - [SoftPro 360 Integrations](https://www.softprocorp.com/real-estate-software-solutions/softpro-360-data-integration/) - [ClosingsLIVE](https://www.softprocorp.com/closingslive) - [SoftPro Sign](https://www.softprocorp.com/real-estate-software-solutions/softpro-sign/) - [SoftPro Banking](https://www.softprocorp.com/real-estate-software-solutions/softpro-banking/) - [Eclosings](https://www.softprocorp.com/real-estate-software-solutions/eclosings/) - [Product Quiz](https://www.softprocorp.com/product-quiz/) - [Services](https://www.softprocorp.com/about/#) - [Overview](https://www.softprocorp.com/software-services/) - [Maintenance](https://www.softprocorp.com/software-services/software-maintenance/) - [SoftPro Protect](https://www.softprocorp.com/real-estate-software-solutions/softpro-protect/) - [SoftPro Consulting](https://www.softprocorp.com/software-services/softpro-consulting/) - [Reconciliation Reports & Services](https://www.softprocorp.com/software-services/reconciliation-services/) - [Development](https://www.softprocorp.com/software-services/custom-development/) - [Reports & Docs](https://www.softprocorp.com/software-services/custom-reports-and-docs/) - [Regulatory & Compliance](https://www.softprocorp.com/software-services/regulatory-and-compliance/) - [Training](https://www.softprocorp.com/about/#) - [Overview](https://www.softprocorp.com/softpro-training/) - [Web-Based](https://www.softprocorp.com/softpro-training/web-based-training/) - [Onsite](https://www.softprocorp.com/softpro-training/onsite-training/) - [Training Seminars](https://www.softprocorp.com/softpro-training/training-seminars/) - [Free Trainings](https://blog.softprocorp.com/webinars) - [Saved You a Seat](https://www.softprocorp.com/softpro-training/saved-you-a-seat/) - [Support](https://www.softprocorp.com/about/#) - [Overview](https://www.softprocorp.com/softpro-support/) - [Underwriter Documents & Downloads](https://www.softprocorp.com/resources/underwriting-documents/) - [Remote Support](https://www.softprocorp.com/softpro-online-support/) - [About](https://www.softprocorp.com/about/#) - [Contact Us](https://www.softprocorp.com/contact-us/) - [Overview](https://www.softprocorp.com/about/) - [Leadership](https://www.softprocorp.com/about/management-team/) - [Corporate Citizenship & Social Responsibility](https://www.softprocorp.com/about/corporate-citizenship/) - [Careers](https://www.softprocorp.com/about/careers/) - [History](https://www.softprocorp.com/about/history/) - [Blog](https://blog.softprocorp.com/?__hstc=190569908.2565e5b7b5a67b3a02e01a942807fecd.1514783189296.1514788403894.1514795107582.3&__hssc=190569908.3.1514795107582&__hsfp=2437171227) - [Testimonials](https://www.softprocorp.com/about/case-studies-testimonials/) [![softpro logoMain](https://blog.softprocorp.com/hubfs/softpro-logo.svg)](https://softprocorp.com/) **800-848-0143** Request a Demo Search SEARCH BLOGS SEARCH ALL Search - [Products](https://www.softprocorp.com/real-estate-software-solutions/) - [Overview](https://www.softprocorp.com/real-estate-software-solutions/) - [Standard](https://www.softprocorp.com/real-estate-software-solutions/softpro-standard/) - [Select](https://www.softprocorp.com/real-estate-software-solutions/softpro-select/) - [Hosted](https://www.softprocorp.com/real-estate-software-solutions/softpro-hosted-software/) - [SoftPro 360 Integrations](https://www.softprocorp.com/real-estate-software-solutions/softpro-360-data-integration/) - [ClosingsLIVE](https://www.softprocorp.com/closingslive) - [SoftPro Sign](https://www.softprocorp.com/real-estate-software-solutions/softpro-sign/) - [SoftPro Banking](https://www.softprocorp.com/real-estate-software-solutions/softpro-banking/) - [Eclosings](https://www.softprocorp.com/real-estate-software-solutions/eclosings/) - [Services](https://www.softprocorp.com/about/#) - [Overview](https://www.softprocorp.com/software-services/) - [Maintenance](https://www.softprocorp.com/software-services/software-maintenance/) - [SoftPro Protect](https://www.softprocorp.com/real-estate-software-solutions/softpro-protect/) - [SoftPro Consulting](https://www.softprocorp.com/software-services/softpro-consulting/) - [Reconciliation Reports & Services](https://www.softprocorp.com/software-services/reconciliation-services/) - [Development](https://www.softprocorp.com/software-services/custom-development/) - [Reports & Docs](https://www.softprocorp.com/software-services/custom-reports-and-docs/) - [Regulatory & Compliance](https://www.softprocorp.com/software-services/regulatory-and-compliance/) - [Training](https://www.softprocorp.com/about/#) - [Overview](https://www.softprocorp.com/softpro-training/) - [Web-Based](https://www.softprocorp.com/softpro-training/web-based-training/) - [Onsite](https://www.softprocorp.com/softpro-training/onsite-training/) - [Training Seminars](https://www.softprocorp.com/softpro-training/training-seminars/) - [Free Trainings](https://blog.softprocorp.com/webinars) - [Saved You a Seat](https://www.softprocorp.com/softpro-training/saved-you-a-seat/) - [Support](https://www.softprocorp.com/about/#) - [Overview](https://www.softprocorp.com/softpro-support/) - [Underwriter Documents & Downloads](https://www.softprocorp.com/resources/underwriting-documents/) - [Remote Support](https://www.softprocorp.com/softpro-online-support/) - [About](https://www.softprocorp.com/about/#) - [Contact Us](https://www.softprocorp.com/contact-us/) - [Overview](https://www.softprocorp.com/about/) - [Leadership](https://www.softprocorp.com/about/management-team/) - [Corporate Citizenship & Social Responsibility](https://www.softprocorp.com/about/corporate-citizenship/) - [Careers](https://www.softprocorp.com/about/careers/) - [History](https://www.softprocorp.com/about/history/) - [Blog](https://blog.softprocorp.com/?__hstc=190569908.2565e5b7b5a67b3a02e01a942807fecd.1514783189296.1514788403894.1514795107582.3&__hssc=190569908.3.1514795107582&__hsfp=2437171227) - [Testimonials](https://www.softprocorp.com/about/case-studies-testimonials/) - [Contact Us](https://www.softprocorp.com/contact-us/) - [Blog](https://blog.softprocorp.com/) - [Careers](https://www.softprocorp.com/about/careers/) - [MySoftPro Login](https://my.softprocorp.com/Login?ReturnUrl=%2F%3F__hstc%3D190569908.2565e5b7b5a67b3a02e01a942807fecd.1514783189296.1514864755853.1514869798011.8%26__hssc%3D190569908.1.1514869798011%26__hsfp%3D2437171227&__hstc=190569908.2565e5b7b5a67b3a02e01a942807fecd.1514783189296.1514864755853.1514869798011.8&__hssc=190569908.1.1514869798011&__hsfp=2437171227) [![softpro](https://blog.softprocorp.com/hs-fs/hubfs/Softprocorp%20Jan2018%20January2018%20Theme/images/logoMain.png?width=186&height=72&name=logoMain.png "logoMain.png")](http://softprocorp.flywheelsites.com/) ##### Request A Demo × Close ##### Contact Sales × Close # SoftPro Blog [Back to Blog](https://blog.softprocorp.com/) 8/29/18, 10:00 AM # How a 3-way reconciliation can help you get happy with the numbers Posted by [Mike McCloskey](https://blog.softprocorp.com/author/mike-mccloskey) on 8/29/18, 10:00 AM ![Mike McCloskey](https://blog.softprocorp.com/hubfs/Mike%20McCloskey.jpg) Find me on: [LinkedIn](https://www.linkedin.com/in/mcmccloskey/) - [Tweet](https://twitter.com/share) What would happen if one of your customer ledgers had a negative balance that went undetected for several months or if a mortgage payoff never cleared the bank? Or maybe one of your closers forgot to issue a check for taxes or a receipt that you were supposed to collect was never received? These are just a few of the examples of where a regular reconciliation of your trust accounts can help identify problems, enabling you to take the appropriate corrective actions. However, completing a reconciliation is only the first step. Because reconciliation reports contain a large amount of valuable and important information, it is recommended that managers of settlement service companies review and analyze reconciliation reports, at minimum, on a monthly basis, regardless of whether these reports are prepared internally or by a third-party service.  The best way to identify any potential issues with your trust account is to perform a 3-way reconciliation, where you need to reconcile trial balance, book and escrow bank balances to make sure they all agree. In addition, you will need to look at each supporting report, that comes with a 3-way reconciliation report, to see any details behind the numbers. My former boss always used to say, "You gotta get happy with the numbers!"  If you don't understand what the numbers are telling you, you can't be happy with the numbers. ![Reconciliation\_sm](https://blog.softprocorp.com/hs-fs/hubfs/Reconciliation_sm.jpg?width=800&name=Reconciliation_sm.jpg) In addition to reviewing an escrow reconciliation report, you should also review the following supporting reports for even greater insight and peace of mind: - **Trial Balance** that provides the balance of every file with both positive and negative balances  - **Outstanding Receipts and Disbursements** which you have booked, but have not yet cleared the bank - **Book Balance Report,** containing the details of the receipts and disbursements that have been posted to the book during the period - **Statement Proofing Register,** providing the list of all receipts and disbursements that have cleared the bank during the period. In most cases, they should agree with your bank statement. Having been an Auditor for a National Underwriter at one point in my career, I can tell you, without a doubt, that these reports will disclose some potential red flags, such as: - Files with negative balances - File balances of $10,000 or more that are over 10 days old - File balances of any amount over 120 days - Outstanding checks over 180 days old - Outstanding mortgage payoffs over 10 days old - Deposits in transit over 90 days old Each of these situations is a potential indicator of an even bigger problem. The good news is that a regular review of your 3-way reconciliation reports will disclose all of these issues and even more. My recommendation is spend at least half an hour each month to "get happy with the numbers" and involve a third-party reconciliation service to provide better segregation of duties and extra set of eyes on your customers' accounts. > #### Want to learn more about ways to get happy with your numbers and keep your accounts in balance?   > > [![LEARN MORE](https://no-cache.hubspot.com/cta/default/2938668/1612b7a8-3c8d-4259-8478-07159f208d86.png)](https://cta-redirect.hubspot.com/cta/redirect/2938668/1612b7a8-3c8d-4259-8478-07159f208d86) Topics: [Reconciliation](https://blog.softprocorp.com/topic/reconciliation) #### Stay up-to-date on the information about industry regulatory requirements, events, customer successes, company updates, and more! ### Subscribe to Email Updates ### Recent Posts [see all](https://blog.softprocorp.com/)   ### Posts by Topic - [Regulatory and Compliance (243)](https://blog.softprocorp.com/topic/regulatory-and-compliance) - [Integrations (82)](https://blog.softprocorp.com/topic/integrations) - [Saved You a Seat Webinars (74)](https://blog.softprocorp.com/topic/saved-you-a-seat-webinars) - [Guides & E-books (67)](https://blog.softprocorp.com/topic/guides-e-books) - [Testimonials & Case Studies (66)](https://blog.softprocorp.com/topic/testimonials-case-studies) - [Best Practices (61)](https://blog.softprocorp.com/topic/best-practices) - [Webinars (61)](https://blog.softprocorp.com/topic/webinars) - [Company News (55)](https://blog.softprocorp.com/topic/company-news) - [Events (40)](https://blog.softprocorp.com/topic/events) - [Technology (21)](https://blog.softprocorp.com/topic/technology) - [Reconciliation (16)](https://blog.softprocorp.com/topic/reconciliation) - [1099 (11)](https://blog.softprocorp.com/topic/1099) - [FinCEN (9)](https://blog.softprocorp.com/topic/fincen) - [SoftPro Select (7)](https://blog.softprocorp.com/topic/softpro-select) - [ClosingsLIVE (5)](https://blog.softprocorp.com/topic/closingslive) - [Commercial (1)](https://blog.softprocorp.com/topic/commercial) see all ## Ready to streamline your closing, title and escrow process? Contact Sales or call us at 800.848.0143 ![softpro logoMain](https://blog.softprocorp.com/hs-fs/hubfs/Softprocorp%20Jan2018%20January2018%20Theme/images/softpro%20logoMain.png?width=185&height=72&name=softpro%20logoMain.png) © 2026 ### Contact 800.848.0143 4800 Falls of Neuse Rd Suite 600 Raleigh, NC 27609 [Directions](http://softprocorp.flywheelsites.com/contact/) ### Email [General](mailto:connect@softprocorp.com) [Sales](mailto:sales@softprocorp.com) [Support](mailto:support@softprocorp.com) [Training](mailto:trainingadmin@softprocorp.com) [Consulting](mailto:consulting@softprocorp.com) ### Connect ### Sign up to stay in touch ### Quick Links - [Products](http://www.softprocorp.com/real-estate-software-solutions/) - [Software Services](http://www.softprocorp.com/software-services/) - [Training Solutions](http://www.softprocorp.com/softpro-training/) - [SoftPro Support](http://www.softprocorp.com/softpro-support/) - [Underwriter Documents & Downloads](http://www.softprocorp.com/resources/underwriting-documents/) - [About](http://www.softprocorp.com/about/) - [Careers](http://www.softprocorp.com/about/careers/) - [Blog](https://blog.softprocorp.com/?__hstc=190569908.2565e5b7b5a67b3a02e01a942807fecd.1514783189296.1514795107582.1514798595244.4&__hssc=190569908.10.1514798595244&__hsfp=2437171227) - [Privacy Notice](https://fnf.com/privacy-and-security/) - [Terms of Service](https://fnf.com/terms-of-use) - [Accessibility](http://www.softprocorp.com/accessibility/) - [California Privacy Policy](https://fnf.com/CaliforniaPrivacy)   [Website design & development](http://www.everest-agency.com) by [Everest Agency](http://www.everest-agency.com) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Mike McCloskey", "url" : "https://blog.softprocorp.com/author/mike-mccloskey" }, "dateModified" : "2024-02-29T05:16:14.664Z", "datePublished" : "2018-08-29T14:00:00.000Z", "headline" : "3-Way Reconciliation for Happy Numbers | SoftPro Blog", "image" : [ "https://blog.softprocorp.com/hubfs/Reconciliation_sm.jpg" ], "mainEntityOfPage" : { "@id" : "https://blog.softprocorp.com/how-regular-reconciliation-can-help-you-keep-your-accounts-in-balance", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.softprocorp.com/hubfs/SoftPro_nosubtext-1.png" }, "name" : "SoftPro" } } ``` ```json { "@context" : "http://schema.org", "@type" : "Article", "articleBody" : "A discussion on the importance of regular reconciliation of trust accounts to identify and correct issues, and the value of reviewing reconciliation reports monthly.", "author" : { "@type" : "Organization", "name" : "SoftPro" }, "datePublished" : "2018-08-29", "headline" : "How Regular Reconciliation Can Help You Keep Your Accounts in Balance", "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.softprocorp.com/hs-fs/hubfs/SoftPro-40th-Anniversary-Logo-Full-Color-Low-cropped.png?width=110&height=72&name=SoftPro-40th-Anniversary-Logo-Full-Color-Low-cropped.png" }, "name" : "SoftPro" } } ``` ```json { "@context" : "http://schema.org", "@type" : "FAQPage", "mainEntity" : [ { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "Regular reconciliation helps identify problems such as negative balances or uncleared transactions, enabling corrective actions to keep accounts in balance." }, "name" : "Why is regular reconciliation important for trust accounts?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "A 3-way reconciliation involves reconciling trial balance, book, and escrow bank balances to ensure they all agree, along with reviewing supporting reports for detailed insights." }, "name" : "What is a 3-way reconciliation?" } ] } ``` ```json { "@context" : "http://schema.org", "@type" : "Service", "description" : "SoftPro's reconciliation services help keep your trust accounts in balance with regular, detailed reviews and 3-way reconciliation reports.", "provider" : { "@type" : "Organization", "name" : "SoftPro", "url" : "https://www.softprocorp.com/" }, "serviceType" : "Reconciliation Services" } ``` ```json { "@context" : "http://schema.org", "@type" : "BreadcrumbList", "itemListElement" : [ { "@type" : "ListItem", "item" : "https://www.softprocorp.com/", "name" : "Home", "position" : 1 }, { "@type" : "ListItem", "item" : "https://blog.softprocorp.com/", "name" : "Blog", "position" : 2 }, { "@type" : "ListItem", "item" : "https://blog.softprocorp.com/how-regular-reconciliation-can-help-you-keep-your-accounts-in-balance", "name" : "How Regular Reconciliation Can Help You Keep Your Accounts in Balance", "position" : 3 } ] } ```