cancel
Showing results for 
Search instead for 
Did you mean: 
chanscar
Level 3

Balance Sheet Comparison - Previous Year and Previous Month

Hi there - I am wondering if there is a way that I can set up my balance sheet to compare to both the previous year end and the prior month? I played around with the comparison tool in the reporting but so far haven't been able to find a workaround. If I run a report for this fiscal YTD then the PP show the previous FYTD and the PY shows the same thing. Any advice?

3 Comments 3
CharleneMaeF
QuickBooks Team

Balance Sheet Comparison - Previous Year and Previous Month

I appreciate you for sharing what you're trying to achieve, chanscar.

 

For now, we're unable to run a Balance Sheet comparison report for the previous year and previous month's data. As a workaround, I suggest running two separate Balance Sheet report with a different period. Then, export to Excel and merge them to compare the data.

 

Here's how:

  1. From the Reports menu, select Balance Sheet.
  2. Click Customize.
  3. On the Report period, select the specific date.
  4. You'll want to click the Row/Columns and Filter section to customize the display of the report.
  5. Once done, click on Run report.

 

Then, let's export the report by clicking the Export button, then click Export to Excel. Repeat the process for the other report period and then merge them to see the comparison.

 

You may check out the reference below:

 

You may want to consider memorizing the Balance Sheet report in QuickBooks Online. This helps you save the current customized settings for easy access in the future.

 

I've also included an article wherein you can check which reports are available for your version of QuickBooks Online: Reports Included in your QuickBooks Online Subscription.

 

Your success in running reports with QuickBooks is our top priority. We're always here to help.

chriswoods
Level 1

Balance Sheet Comparison - Previous Year and Previous Month

I don't see those options on my qbo account, nor does this explanation go into what one should do...

JoesemM
Moderator

Balance Sheet Comparison - Previous Year and Previous Month

Thanks for joining the Community space, @sharedchriswoods.

 

Exporting the two Balance Sheet report to Excel will help you compare the previous year and the previous month's data.

 

Since the option shared isn't visible for you, I'd suggest opening your account via an incognito window. This way, we can check if this issue is due to pilled up cache from the browser. 

 

To bring up an incognito window, follow the steps below.

 

  • Mozilla Firefox: Ctrl + Shift + P
  • Safari: Command + Shift + N
  • Google Chrome: Ctrl + Shift + N
  • Internet Explorer: Ctrl + Shift + P

 

Once the private browsing opens, try to run and export the report again. You can follow the steps shared by CharleneMae_F above. 

 

If it works fine as suggested, we'll need to clear your regular browser's cache. This will clear the stored data on your platform that may cause some issues in using QuickBooks.

 

Alternatively, you can use other compatible browsers.

 

Here are some articles that you can read for more information: 

Just in case you need more information about running different reports in QBO, I recommend reviewing this article: Run reports in QuickBooks Online.

 

Fill me in if you have more questions about managing your reports or anything else related to QuickBooks. I'll be here to help you. Take care and have a nice day.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us