cancel
Showing results for 
Search instead for 
Did you mean: 
SSPANGLER
Level 1

Same QB File in Mac & Accountant versions have diff Balance Sheet Figures

Client 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
Best answer August 26, 2021

Best Answers
Mich_S
QuickBooks Team

Same QB File in Mac & Accountant versions have diff Balance Sheet Figures

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:

  1. Click on Company & Financial from the Reports menu.
  2. Then, select Balance Sheet Summary.
  3. Click on Customize Report.
  4. From the Display tab, choose Accrual under Report Basis.
  5. Hit OK.

 

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!

 

View solution in original post

4 Comments 4
KlentB
Moderator

Same QB File in Mac & Accountant versions have diff Balance Sheet Figures

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:

 

  1. Choose Window, then click Close All.
  2. Go to the File menu, then select Utilities.
  3. Select Verify 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:

 

  1. Go to the File menu, then choose Utilities.
  2. Select Rebuild Data.
  3. Follow the on-screen instruction to back up your data. The Rebuild Data utility starts as soon as the backup is finished.
  4. Click OK once you get the Rebuild has completed message.

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.

SSPANGLER
Level 1

Same QB File in Mac & Accountant versions have diff Balance Sheet Figures

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!

Mich_S
QuickBooks Team

Same QB File in Mac & Accountant versions have diff Balance Sheet Figures

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:

  1. Click on Company & Financial from the Reports menu.
  2. Then, select Balance Sheet Summary.
  3. Click on Customize Report.
  4. From the Display tab, choose Accrual under Report Basis.
  5. Hit OK.

 

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!

 

SSPANGLER
Level 1

Same QB File in Mac & Accountant versions have diff Balance Sheet Figures

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!

Need to get in touch?

Contact us