Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
tu3712
Level 1

Balance sheet error on shareholder distributions

When I run a balance sheet report YTD it is returning incorrect shareholder distributions. It returns a running total of all distributions back to 2018 and not just the 2023 distributions. I cannot figure out why or how to fix it. Any help would be appreciated. 

7 Comments 7
ZackE
Moderator

Balance sheet error on shareholder distributions

Welcome to the Community, tu3712. I appreciate your detailed information.

To verify my understanding, did you select the Run report button after setting your Report period to This Year-to-date? If not, this may be why it's still displaying data from other years outside of your desired date range.
 

In the event your balance sheet report is configured properly with a Report period of This Year-to-date, but is showing shareholder distributions from other years that weren't specified in your Report period, I'd recommend checking the browser you're using. It's possible this could have something to do with temporary internet files. Browsing applications store these types of records, but sometimes they can cause issues with certain webpages. You can open a private window and check to see if your report displays correctly according to its Date range.
 

Here's how to access incognito mode in some of the most commonly used web browsers:

 

  • Google Chrome: Ctrl Shift N
  • Mozilla Firefox: Ctrl Shift P
  • Microsoft Edge: Ctrl Shift P
  • Safari: Command Option P

 

If your balance sheet displays correctly while browsing privately, it's safe to say this problem's being caused by your browser. It can be fixed by clearing cached data and Intuit-specific cookies.
 

In the event it continues not displaying properly while browsing in incognito mode, you'll initially want to try switching to another browsing application.
 

Here's a list of supported browsers:

 

  • Google Chrome - version 78 or newer
  • Mozilla Firefox - version 76 or newer
  • Microsoft Edge - version 75 or newer
  • Opera - version 68 or newer
  • Samsung - version 10 or newer
  • Safari - version 12 or newer

 

QuickBooks supports the current and two previous versions of browsers. If you find that you're using an unsupported version, make sure to update it to its latest release. Steps for doing so can be found on the particular company's website.
 

In the event you've found no problems that could be causing this with your browser, you'll want to check the operating system and internet speed you're working with.
 

Here's our recommended operating systems and internet speeds:
 

  • Windows PC - Windows 10, Intel Core i3 or a comparable processor (2013 or newer) with at least 2 GB of RAM, or Windows 10, Intel Core i5 or comparable processor with at least 4 GB of RAM.
  • Mac - OS X El Capitan 10.11, OS X High Sierra 10.13, or newer.
  • Linux - QuickBooks works with Linux, but you'll want to make sure you're using a supported browser and our recommended internet speeds.
  • Internet connection - 1.5 Mbps to 3 Mbps or higher.


If you meet our system requirements, but are still encountering pages that aren't loading properly, I'd recommend using a different device and/or internet connection. If it continues happening on other devices and internet connections, you'll want to get in touch with our Customer Care team. They'll be able to pull up your account in a secure environment, conduct further research, and create an investigation ticket if necessary.
 

They can be reached while you're signed in.
 

Here's how:

 

  1. Use the Help (?) icon.


     
  2. Click Contact Us.


     
  3. Enter a description of your situation in the What can we help you with? field, then hit Let's talk.


     
  4. Select Start messaging or Get a call.


Be sure to review their support hours so you'll know when agents are available.
 

I've also included a detailed resource about system requirements for QuickBooks which may come in handy moving forward: System requirements
 

Please don't hesitate to send a reply if there's any questions. Have an awesome Friday!

Rainflurry
Level 15

Balance sheet error on shareholder distributions

@tu3712 

 

There is no such thing as a YTD balance sheet.  QB Online should not even have that as an option - it's a poor design.  A balance sheet that is run YTD in QB Online is a balance sheet that represents the financial position of the company from day 1 of the business's existence until the day you run the report.  You will notice it says on the top of the report "Balance Sheet - As of October 27, 2023.  If your business started Jan. 1, 2018, the "YTD" balance sheet is for all dates from Jan. 1, 2018 through Oct. 27, 2023.  That is why your balance sheet shows distributions dating back to 2018.  Intuit should fix that.      

Rainflurry
Level 15

Balance sheet error on shareholder distributions

@tu3712 

 

EDIT: 

A balance sheet that is run YTD in QB Online is a balance sheet that represents the financial position of the company as of the day the report is run.  To do that, it includes all transactions from day 1 of the business's existence until the day you run the report.

tu3712
Level 1

Balance sheet error on shareholder distributions

Thank you. I tired this yesterday for over an hour. They escalated it and are looking at my issue. This happens across different PCs and users so it’s not isolated to just me or my PC. Thank you for the input. 

tu3712
Level 1

Balance sheet error on shareholder distributions

Thank you. I was wondering that was the case and searched for that reasoning but I couldn’t find anywhere that is was a running total of the business since inception. I have asked a few others and they all said it should only return the distributions for the date range selected. 

Rainflurry
Level 15

Balance sheet error on shareholder distributions

@tu3712 

 

There's nothing to fix.  It's just how QB Online is designed.  I meant they should fix the option of choosing a date range when running a balance sheet.  It creates issues like this, where people assume a balance sheet can be run for a date range - it can't.  It is a snapshot of the business as of a certain date.  

 

"I have asked a few others and they all said it should only return the distributions for the date range selected."

 

Then they are not formally trained accountants or CPAs.  You can (and should) close out distributions to retained earnings at year-end.  Debit retained earnings, credit distributions  

tu3712
Level 1

Balance sheet error on shareholder distributions

Thank you for the info

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us