Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
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:
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.
I don't see those options on my qbo account, nor does this explanation go into what one should do...
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.
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.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here