Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
July 26, 2022
Solved

Balance Sheets Reports

  • July 26, 2022
  • 1 reply
  • 24 views

I am trying to generate an accurate balance sheet for my company.  A little back story, my father passed away in December 2021, leaving myself, my brother and sister in control of the business since my mother is medically incapable of making her own decisions.

 

I have created a Balance Sheet for last year, and each individual year.  But I have concern on that.  It seems like that, say I pull a Balance Sheet report for 12/31/2021, then all the data for that balance sheet is everything in Quickbooks from the date the file was started, back into the 1990's through that date.  Is that correct?  The custom date range only allows me to put in the date as of, but does not given me the option for dates from  and to, for exmaple.  I can put in 12/31/2021, but I can't generate a BS report based on 01/01/2021 thru 12/31/2021.  Again, this leads me to believe that the balance sheet report is a running total since the start of time of the Quickbooks file for this company.

 

Second issue on the Balance Sheet report is that it list accounts that are no longer active and used.  For example, my father's original credit card for the company, that he stopped using in 2017 and replaced after it was compromized, all the credit card bills were paid off, as they are each month, yet, the BS Report shows X dollar amount on that credit card, on my 2021 report, though it has not been used since 2017.  Is there a way to remove it from the report and the balance sheet?

Best answer by Rainflurry

@cdhodgdon 

 

Balance sheets only represent one point in time.  It is a snapshot of the business as of a certain day going all the way back to Day 1 of the business.  So, yes, you are correct, it is a running total. 

 

In terms of the credit card, if there is a balance on the balance sheet, then it was not reconciled and closed in QB.  It may have been paid off and closed as far as the credit card company is concerned, but it still should be reconciled to zero in QB.

1 reply

QuickBooks Team
July 26, 2022

Hello, @cdhodgdon.

 

Usually, this behavior occurs when your data is damaged or corrupted. We can run the Verify/Rebuild tool utility to detect the data damage.  

 

If the program is in multi-user mode, you need to change to single user mode (Go to File -> Switch to Single User Mode). It is very important that you have to create a backup copy of your company file before running Verify and Rebuild Data.  

 

Verify Data: 

 

  1. Press the File menu. 
  2. Choose Utilities from the drop-down option.  
  3. Select Verify Data
  4. Tap Ok to continue.  

 

Note: If the verify process is successful, you are done. In case it fails due to some problem, QuickBooks will notify you to run Rebuild data. 

 

Rebuild Data:

 

  1. Click the File tab at the top. 
  2. Select Utilities from the drop-down option. 
  3. Choose Rebuild Data
  4. Click Ok on Rebuild has completed.   

 

If the issue persists, I suggest reaching out to our Contact Support team. They'll be able to pull up your account in a secure environment and help you navigate using one of their tools.  

  

Just in case you need additional resources while working with QuickBooks Desktop, you can always open the topics from our help articles

 

Let me know how it goes by dropping a comment below. I'm just around to help. Take care!

cdhodgdonAuthor
July 27, 2022

@Maybelle_S 

 

Not sure why you are asking me to verify the data or do a rebuild id necessary.  The data is verified and no issues at all.  Have actually verified the data several times over the last month for other reasons.

How is this going to cause me issues with a report?  I user different versions of Quickbooks on different computers for different companies, they all do the same things when running a Balance Sheet Report.  It only allows you to pick a date as of and a range period, ie Fiscal Year, Last Fiscal Year, etc., see the attached photo.  So again, my question is again, does the balance sheet show the running total since we started using the Quickbooks?  It does not seem to allow me to only do a balance sheet for on specific calendar year.  If I run a BS Report with the As Of Date of 12-31-2020, then the balance sheet is going to show me everything from the start of using QB to that date, correct?  Report dates should not be affected by any data issues, but then again, we don't have any data issues.  See photo

 

Also, how does that Verify/Rebuild have anything to with what accounts show in the BS Report.  Like in my example, we have an old credit card listed that was my dad's.  All the bills are paid off and zeroed out, and the account has been marked as inactive (been inactive for 2 year give or take a little), yet it shows up in the BS Report and shows how much money was spent on that count, how do I get the report to not show this nor include it in report as it's no longer valid.

I am a 20+ year QB user and beta tester, so I know how to confirm issues or not before coming to this community.  I just don't use BS Reports in my own businesses and so don't have any experience using them in QB.

Rainflurry
Level 11
July 27, 2022

@cdhodgdon 

 

Balance sheets only represent one point in time.  It is a snapshot of the business as of a certain day going all the way back to Day 1 of the business.  So, yes, you are correct, it is a running total. 

 

In terms of the credit card, if there is a balance on the balance sheet, then it was not reconciled and closed in QB.  It may have been paid off and closed as far as the credit card company is concerned, but it still should be reconciled to zero in QB.