cancel
Showing results for 
Search instead for 
Did you mean: 
RBCTreasurer
Level 2

Request to Create Custom Graphs in QB-Online

I am new to Quickbooks so if what I am asking is beyond the scope let me know.

 

I am supporting a Church so P&L is not something to show the Leadership team.

 

My request is for a graphing capability in QuickBooks that shows a stacked bar of income and expenses month by month for a Fiscal Year (current or specified previous year). I would also like to be able to compare income and expenses for the last 2 to 5 fiscal years month by month. In other words a line for each year with $ plotted on the Y axis and months plotted on the X axis. The goal would be useful in determining what months to spread the budgets for income and expenses. And during the fiscal year we could more easily see if the current year is following previous years patterns.

Steve G 

3 Comments 3
JenoP
Moderator

Request to Create Custom Graphs in QB-Online

Hi there, Steve.

 

There's a graphical comparison of your income and expenses in your Dashboard. However, there's no option to show the data month by month for the last 5 fiscal years. You can only select between This fiscal year or Last fiscal year.

 

 You might also want to open the Business Snapshot report. Here's how:

 

  1. Go to the Reports menu and select Business Snapshot under Business Overview.
  2. Scroll down to the Previous Year Income Comparison and Previous Year Expense Comparison section.
  3. Click the drop-down list for period and select Monthly for both.

In addition, you can run a Profit and Loss Comparison report to get the data for the past 5 years. Then, export it to Excel and create a graphic bar using the information from the report. 

 

To open your Profit and Loss, please follow these steps:

 

  1. Look for Profit and Loss under the Reports menu.
  2. Change the date to the right Fiscal Year in the Report Period section. 
  3. Click the drop-down arrow for Display columns by and select Month.

You can also click the drop-down arrow for Compare another period and check Previous Period. Although, this will only give you the date for the current and previous period. 

 

You can always visit us again if you have other questions. 

graph.PNG

 

graph 2.PNG

 

graph 3.PNG

 

yfreeman
Level 1

Request to Create Custom Graphs in QB-Online

Is there anything like this for desktop version?

Candice C
QuickBooks Team

Request to Create Custom Graphs in QB-Online

Good Afternoon, @yfreeman

 

Thanks for joining in on this thread. At this time, there isn't an option for the Business Snapshot report in QuickBooks Desktop. However, you can export a report to Excel.

 

Here's how: 

 

  1. Go to the Reports menu. 
  2. Locate and run the report. 
  3. Once you're on the report's screen. 
  4. Click the Excel drop-down. 
  5. Pick the Create new worksheet

 

Here's an article that can help you out with exporting reports: Export reports as Excel workbooks in QuickBooks Desktop

 

If you need any further assistance, feel free to ask. Have a great day!

Need to get in touch?

Contact us