Skip to main content
U
user96878
December 5, 2019
Question

How do I customise a report showing a month by month balance sheet comparison

  • December 5, 2019
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

Bonny_
Bonny_
December 5, 2019

Hi user96878,

 

You can run a Balance Sheet Comparison Report to compare monthly figures. Ensure that the Report Period is set to a month, and it will bring in the current month's data vs. the previous month. Also ensure that the Compare Another Period drop-down menu is set to the Previous Period, instead of Previous Year.

 

To go back further, adjust the date ranges to the period of your choice and then select Run Report.

 

Bonny

M
Marie GPG
June 9, 2020

Hi there,

 

Can there be more than 1 month comparison?

K
Kass_B - Product Champion
June 9, 2020

Hi Marie GPG,

 

Yes, you can customise the comparison reports to compare to different periods:

 

  1. Go to the Reports tab and search for the Balance Sheet Comparison report.
  2. Customise by changing the 'Report Period' to your preferred range. For example, to compare last week to the week before, select 'Last Week' and under the 'Compare Another Period' dropdown, choose 'Previous Period'. You can also choose 'Previous Year' instead of 'Previous Period' to run a yearly comparison. Then select Run Report.

 

-Kass

 

C
CraftyAccountant
June 23, 2021

Though you stated you figured it out, I wanted to put the steps that I used for a year long, month by month balance sheet comparison so others could use this as a resource. I figured it out myself, but I came to this thread first trying to expedite my process.

 

Once you are on the balance sheet I selected "custom" for my dates. I clicked Customize Report, set my dates from 01/31/XXXX to 12/31/XXXX. I also selected display columns by month.

 

 

    D
    Dwight52
    August 3, 2021

    How do you customize a report in QB online so that the current period is on the left and the oldest period is on the right.  When I run a monthly income and expense by month compared to last year it puts Jan on the left and Dec on the right.  I want it the other way around, Dec on the left and Jan on the right.

    G
    GlinetteC
    August 3, 2021

    Glad to have you join this conversation, Dwight52.

     

    Let me share some insights about reports in QuickBooks Online. 

     

    The way you see the report in QBO is working as designed. You may export the report to Excel and filter it to get the data you wanted. 

     

    I'll show you how:

     

    1. On the Balance Sheet Report page, select the Export icon.
    2. Then select Export to Excel.
    3. Save the file somewhere you can easily find it, like your Downloads folder or your desktop.

    You can also check this article to learn more details on exporting reports to Excel: Export your reports to Excel from QuickBooks Online.

     

    I'm just a post away if you need a helping hand in managing your reports.

    Terms & ConditionsAccessibility statement