How to Fix an Unbalanced Balance Sheet in QuickBooks
First try Rebuilding the file (File > Utilities > Rebuild Data). If you’re lucky, that’s all you’ll need.
If that doesn’t fix it, try searching for the amount you’re off. If there’s just one transaction causing the problem, this is usually the easiest way to find it.
If there are more than one causing the problem, you’ll need to do more research. Start by pulling a Balance Sheet report for All Dates and then select Month for Columns. Find the first month that it doesn’t balance, then change the dates to that month and select Day for Columns to find out what day doesn’t balance.
Then create a Custom Transaction Detail report for that day. If you Total the report by Account, it might be easier to identify the problem. Once you find the corrupted transactions, delete and re-enter them.
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA





Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter
How to Enter Notes on a Sale in QuickBooks Point of Sale 10.0
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA





Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter
How to Enter Multiple Sales Tax Rates on an Invoice in QuickBooks

This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA





Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter
How to Add On-Hand Quantity to the Make a Sale Window in QuickBooks Point of Sale
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA





Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter



Recent Comments