QB Online. Custom Balance Sheet Report

Hi Sam360,

Welcome to the Online family! QuickBooks Online not only provides you tons of great financial reports to stay on top of your business health but also enables you to customize these reports to focus on details that are more important to you. I see what you're trying to achieve in your Balance sheet report, and I'd be happy to show you how to do so in the program.

To customize your Balance sheet in QuickBooks Online to add a previous period with $ change and % change, follow these steps.

1. Go to the Reports menu.
2. Find and open your Balance sheet report.
3. Use the basic filters on the report to adjust things like the report dates.
4. Under the Compare another period section (beside Accounting method), use the dropdown to select the box beside Previous period (PP), $ change, and % change.
5. Feel free to include other customization you'd like.
6. When ready, select Run report to apply them.

And that's it! For more on how to run and customize reports in QuickBooks Online, check out these articles.

• Run reports in QuickBooks Online
• Customize reports in QuickBooks Online

I hope this helps! Don't hesitate to reach out if you need anything else!

Thank you for the reply. I tried the steps you provided; however, I do not have the Compare another period section next to Accounting method.  On my screen i only see Report period, Display columns by, Show non-zero or active only and Accounting method. There is no Compare another period. I am using EasyStart. Is this because of the version that I am using? 

Thank you! Looks like I need to upgrade...

You're welcome! Feel free to reach back out if you have more questions.

What if I have plus and would like to compare current year to date to Dec 31 of PY on the balance sheet. 

Hi there christinehalpin,

It's important that all your transactions be entered correctly for your books to be well balanced. QuickBooks Online is a great tool able to help you keep track of sales and expenses so you can see the profit of your company. I can provide some information about reports.

The balance sheet can be compared to either the last period or the previous year. If you select the year to date as the period and then choose to compare to the previous period or previous year in the Compare another period drop-down menu, it will show comparing it to the same date range last year (in this case, Jan 1 2023- Jul 17 2023 to Jan 1 2022 - Jul 17 2022). If you would want to compare to last year as a whole, the period would have to choose would be This year, but what to consider with that would be that if you have any entries made for the future of this year, they will also be considered. If that is the case, two separate reports would need to be generated, one for This year to date, and then another of Last year, compared outside of QuickBooks.

If you have any other questions, feel free to reach out here.