Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowClient sent Mac QB file back up which we restored to Accountant 2019 version and when running cash basis balance sheet, we have two different figures. Client file has an extra 56.89 in Owners Equity account and when we run it, we have a zero balance and can't see any transactions in that account. Client can't see any transactions on her version either. We also have a .14 out of balance issue (on both versions, same file) as well but the accrual basis balance sheets are in balance. Any thoughts would be greatly appreciated!
Solved! Go to Solution.
Thank you for keeping us updated, @SSPANGLER.
I'll walk you through some troubleshooting procedures to fix your Balance Sheet report balance.
Beforehand, ensure to back up your company file so you can restore it in case of data loss. That's because you may need to edit transactions to fix the issue. Then, you can now proceed with running the report in accrual basis.
Here's how:
Once done, you can follow Steps 2 to 5 in this article to continue the troubleshooting: Fix a Balance Sheet that's out of balance. You can also check out this helpful article for additional procedures in fixing your concern: Balance Sheet Report out of balance - Recurring. Please note that both articles are for QuickBooks Desktop, but it contain the same processes. The steps may be slightly different, but it will give you an idea on how to fix your concern.
Don't hesitate to click on the Reply button so I could assist you further with QuickBooks and running/customizing reports. Have a good one!
Hi there, SSPANGLER.
I'm here to share some troubleshooting steps that can fix this issue.
It could be that there's a damage or integrity issue on the company file causing the discrepancy of the Balance Sheet. To rule this out, you can run the Verify and Rebuild utilities in your QuickBooks Accountant Desktop. This will scan the file for potential data issues and fix them right away. Here's how to verify your data:
If the program didn't detect any errors or problems with the data, then no further action is required. However, if you find that your data has lost integrity, you'll have to rebuild the file to rectify the damage. I'll show you how:
To learn more about this process, you can read this guide: Verify and Rebuild Data in QuickBooks Desktop.
Additionally, here's an article that you can read to learn how to convert the corrected file once you decide to send it back to your client: Convert a QuickBooks for Windows file to QuickBooks for Mac.
You can always find me here if you have any other concerns or follow-up questions. Have a great rest of the day.
Thank you for the reply! I did run the verify and rebuild tool and it didn't fix anything. If you have any additional thoughts, I would greatly appreciate them. I have located one transaction for .01 that I think is a problem for the out of balance issue but haven't taken the steps to change the dates yet. I still have .13 to find for the out of balance issue. Just not sure how to fix the 56.89 issue between the Mac & Accountants versions.
Thanks again for your help! Have a great day!
Thank you for keeping us updated, @SSPANGLER.
I'll walk you through some troubleshooting procedures to fix your Balance Sheet report balance.
Beforehand, ensure to back up your company file so you can restore it in case of data loss. That's because you may need to edit transactions to fix the issue. Then, you can now proceed with running the report in accrual basis.
Here's how:
Once done, you can follow Steps 2 to 5 in this article to continue the troubleshooting: Fix a Balance Sheet that's out of balance. You can also check out this helpful article for additional procedures in fixing your concern: Balance Sheet Report out of balance - Recurring. Please note that both articles are for QuickBooks Desktop, but it contain the same processes. The steps may be slightly different, but it will give you an idea on how to fix your concern.
Don't hesitate to click on the Reply button so I could assist you further with QuickBooks and running/customizing reports. Have a good one!
Thank you! I have both issues fixed now. The out of balance issue on the cash basis balance sheet was fixed by finding the transactions, changing the date on the transaction to 20 years in the future, save & close, opened the future dated transaction and changed the date back to the original date and balance sheet went back into balance at that date. Did this for 6 different transactions spanning over 6 years. The other fix was a transaction showing up in the client Mac file as out of balance but not in my Accountants version of the same data file. My file was in balance for this amount and I was only off the cash basis entries discussed above. I used the find feature for the amount that she was off in her accrual & cash basis balance sheets and found it was deposit with a negative line item to record a credit card merchant fee. She changed the date on the transaction to 20 years in the future, saved the transaction, opened the future dated transaction and changed the date back to the original date and saved it. Ran the balance sheet in both cash accrual basis and the issue was resolved.
Thank you for the help!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.