This free balance sheet tool locates the days that the balance sheet in QuickBooks is out of balance.

Does QuickBooks tell you that your balance sheet is out of balance? You can find out where it goes out of balance by totaling the report by year to find the first year it goes out of balance. Then run a balance sheet for that year totaled by month to find the first month it goes out of balance. Finally run a balance sheet report for that month totaled by day to locate the first day it is out of balance.

What happens when the problem is caused by multiple transactions on different days? Well, you can keep repeating the same process to find each day where the balance sheet is out of balance or you can use this free tool to locate all days that the balance sheet is out of balance with one click of a button.

This free tool can help you quickly locate the dates that the balance sheet goes out of balance. If you are running reports on an accrual basis then the tool can go even further and locate the actual transactions causing the issue. If you are running reports on a cash basis then you may use the dates and amounts provided by this tool to run a cash based transaction detail by account report to search for the offending transactions. Either way, the tool reduces the time it takes to locate the transactions that need to be corrected.

Before running the balance sheet tool please make sure that the file passes the verify procedure in QuickBooks. You can do this by opening the file in QuickBooks and clicking on file->utilities->verify data. Then also make sure that the text *overflow* does not appear anywhere a number should appear on the balance sheet report in QuickBooks by running the balance sheet report for all dates and looking at the total at the bottom to make sure it is actually a number.

Once you have done that you can run the tool simply by opening the file in QB, starting the balance sheet tool and then clicking the “Check balance sheet of the file open in QB” button.

Balance sheet tool for QuickBooks files

The balance sheet tool will not make any modifications to the transactions in your file. It will run a balance sheet report for all dates totaled by year to look for all years that are out of balance. For each year that is out of balance, it will then run a balance sheet report totaled by month to determine which months are out of balance. Then it will look for individual days that are out of balance. Finally, if you are running reports on an accrual basis the tool will run journal reports on those days to locate the individual transactions that are out of balance. Upon completion of its analysis, the tool will then open a text log file with its findings in notepad for your reference.

Please make sure that the verify procedure in QB (File->utilities->verify data) completes without error and that the text *overflow* does not appear on the balance sheet in QuickBooks before you run this tool. It is not designed to be run on files that do not pass verify or when the balance sheet displays totals that are not actual numbers.

Testimonials

Click here to add your own Testimonial

  • Great service. I was very happy that all my data was recovered.

    ★ ★ ★ ★ ★

  • Thanks for the prompt turnaround on the files, I appreciate it.  

  • excellent honest service, had a crazy Qbooks issue, quickbooks was NO help tried to make ,e spend 400 for upgrade and then another 300 plus for repair that they said the upgrade would fix These guys are fast and great resolved my issue for way less then rip off intuit

    Joe
  • Worked perfectly to remove the admin password on my Quickbooks 2003. It took less than a second. No problems whatsoever. I am very, very happy!  

  • I'm so impressed with the service we received.  All our QB data problems were solved in just a few hours.  Previously I spent hours and hours on the phone with Intuit who finally told me they couldn't fix our data file.  Our emails were answered quickly and the help to upload our file was great!  Thanks QuickBooks Repair!

  • Excellent service! Responded to my email inquiries within minutes. I had 2 QuickBooks files to convert from Enterprise to Premier and it only took about 4 hours from the time I uploaded them.

    ★ ★ ★ ★ ★

  • My QuickBooks file was converted from Enterprise 14 to Pro 19. The conversion was handled flawlessly overnight.  

  • Thank you for the quick turnaround on this conversion. I got this file back to my client and everything was just as it was before in the Enterprise version of the file. Thanks again for your help, I will definitely use your services again in the future.

    ★ ★ ★ ★ ★

  • Service was fantastic. Lead time was faster than quoted. They resolved my issue with no lost data and were pretty quick emails.

    ★ ★ ★ ★ ★

  • We had a perfect experience, with excellent results!!!  QB told us our file was too corrupt and there was nothing they could do.  So we did some research and luckily found quickbooksrepair.com.  We feel so fortunate to have found you.  You truly saved us from a very troubling situation!!

    Tim
  • We needed to get a very old QB Enterprise Solutions file converted to the current QB Accountant Edition 2019 file. The staff are very courteous and swift to help with any issues, and most importantly performed their service exactly as promised and on time. I would heartily recommend QuickBooksRepair.com to any one who needs their services. Rusty, CPA

    Rusty
  • I can't thank you enough.  This appears to have worked flawlessly and you saved me tons of money.

    ★ ★ ★ ★ ★

  • Thanks you guys did an awesome job. Everything exactly as promised!

  • i should have gone to you first instead of wasting my money on other "data file transfer utilities".
    THANKS SO MUCH - you saved me hours of time.
  • ITS ABSOLUTELY COOL!

    ★ ★ ★ ★ ★

  • I have been stressed out for years about the prospect of downgrading my Quickbooks from Enterprise (which I had purchased in 2015) and going to the lower and more affordable Pro version. I had been told by my bookkeeper and my accounting software support person that I should just keep buying Enterprise at an exorbitant price because they were worried that not all my info would transfer over. But yesterday, in one fell swoop - I got a boost of courage, purchased Pro 2020 and after an email with Mark at Quickbooksrepair.com - I sent him my QB file late last night and crossed my fingers. And this morning I woke up to an email that the conversion was complete. Wow, amazing. All of my notes and templates are there, everything looks the same, and I now have a new version of Quickbooks. This was completely painless. Mark's emails with me were professional and informative and alleviated my concerns... and everything worked out the way he said it would. I am starting my day today with less stress, and a new Quickbooks file. Zero downtime. I wish I could hire this company for other things in my business lol!

    Lindsay
  • I loaded both converted backup files into QB Premier 2015. I then ran BS and P&L (since inception) reports on the Premier software and on the Enterprise software and both verified.
    Great news.
    Thanks for your help.
    Terrific!
  • Your service is extremely easy to use - both uploading and then pulling your converted file into QB. And your turn around time is AWESOME.  I use Coral Qbox for a lot of my clients and I love them BUT they are not easy to get the file where it should be. I have never used a company to convert a file before but you are on the top of my list if any of my clients need your type of services.  

  • Just wanted to let you know that all the files transferred over perfectly. So far, everything seems to be working great. I had no problems at all and more importantly had no 'down time'. I am very pleased with your service. Thank you very much.

  • They appear to only communicate by email but turnaround time was great ... and the job was done successfully.

    ★ ★ ★ ★ ★

  • The files look great. It’s frustrating that we had to spend the money for something that Intuit should provide automatically, but given that it must be done your service is fantastic.

    ★ ★ ★ ★ ★

  • The best and easy to deal with!

    ★ ★ ★ ★ ★

  • Thank you so much for returning our file so quickly. You must be some kinda genius! Everything is working perfectly now. We are a returning customer (thanks to Intuit). I highly recommend your company to anyone having data issues with QuickBooks!

  • Overall, an excellent service. The webpage seems kind of out-dated and the uploading process didn't work the first time. You can only upload 1 file at a time, though the site indicates otherwise. However, they converted my files perfectly. I will use them again in the future.

    ★ ★ ★ ★ ★

  • Just wanted to say thanks money well spent! This will reduce our cost by a bunch on yearly updates getting away from QuickBooks Enterprise.  We were talked into Enterpise version some years ago found out it was not necessary then found out you could not convert file back through QuickBooks what a con job! Converted file works flawlessly couldn't be happier would recommend this team highly!

  • QuickBooksRepair service rocks. They were able to assist me with my QuickBooks problem straight away. Thanks for the assistance.  

  • Intuit wanted $2090 / year to continue using Enterprise. Intuit also claims there was no way to convert back to Pro. I am so happy this service was available from QuickbooksRepair.com. I was able to purchase Quickbooks Pro from Intuit for $500, which will be good for three years, no subscription. All that I have to do is renew a payroll subscription each year. This is going to save my company about $4k over the next three years!   I will be recommending your service to any of my clients that have Quickbooks issues.   THANK YOU QUICKBOOKSREPAIR.COM!!!!!  

  • Fantastic work!

  • The service was so quick, I was amazed, and all work out very well. I would definitely use this service again, thank you so very much!

    ★ ★ ★ ★ ★

  • I just want to say how impressed I am with the service. I was expecting I’d have the data but still need to do all the setup of quickbooks. Wrong, everything was there ready to run! This was such an easy process and will save me a bunch of money. I can’t believe how Intuit treats their customers not allowing this to be done ‘in-house’. I went to Enterprise several years ago at the bad recommendation of their tech support. I estimate I’ve spent at least $10k unnecessarily over the years. Your service ROCKS!

  • Thank you so much for your assistance and prompt response and ability to recover our file. My team and I are extremely appreciative and will highly recommend you to other businesses.

  • Mark is amazing at quick responses and overall success...he saved our corrupt file (where even our balance sheet was out of balance) and our file is now 100% good to go!  We owe a lot of time and headache to quickbooksrepair.com for helping us out with what was, an awful and very stressful situation!!!  
    Thank you again,
    Tim U. 
    Berkeley, CA

    Tim U.
  • Truly amazing , it works great Thanks so much for your help and patience

  • thanks for all your help. The file converted with NO problems. Wow!!! Couldn't have been easier.
  • Great experience! Fixed by QB file in less the 8 hours on a day before a holiday! What a life saver! Worth every penny!

    ★ ★ ★ ★ ★

  • Good service

    ★ ★ ★ ★ ★

  • Thank you so much!
    We think it's good to go, upgraded to 2013 no problem as well 🙂
  • I was a bit reluctant at first to pay for the service, having been given guarantees from other services that they could do the conversion and not be able to. I was particularly concerned as the file used multi-currency. Everything came over exactly as it left. This was well worth the money spent and saved me a LOT of stress trying to export and re-import data. I will be using this service every time going forward when I have clients that have issues like these. Thank you, thank you, thank you!

  • We wanted to downgrade from Enterprise to Pro as it was just more than we needed and was more cost effective for us to use. We contacted thus company. After getting our questions answered and making our payment we heard back from them and within 24 hours we had our converted files back and we were up and running on our Pro version with no errors to be found. Everything was there and worked perfectly. Thanks again for prompt and courteous service.

    ★ ★ ★ ★ ☆

  • Everything went well. Thanks so much for your quick service and I will recommend you to anyone that needed that conversion in the future.

    ★ ★ ★ ★ ★

  • QuickBooksRepair just saved us hundreds, potentially thousands, of dollars and hours of work. They delivered exactly what was promised in the time frame that was promised. 10/10 would hire again.

  • Great service. Very fast. Would definitely use and refer.

    ★ ★ ★ ★ ☆

Don’t send your file to some other company to have them “try” and fix it.
Cut
out the middleman and save time and money!

QuickBooksRepair.com experienced technicians do the work – no subcontractors!
We offer
you the highest quality, the fastest service AND the lowest prices available.
Check
our rates against the competition and see for yourself.

0