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

Create Report for Actuals Only

Hi All,

 

Just some background; I am trying to build a report that will show actual account balances across twelve months. The Budget Vs. Actual report is great for this, however I need to update this sheet monthly and would like to avoid having to delete out the budget columns each time.

 

Therefore, I was hoping someone could explain how to build/run a report that would only show GL account balances similar to the Budget Vs Actuals report minus the Budget columns. I would like to keep detail from the report as well. Any help would be greatly appreciated!

 

Thanks,

Rick

Solved
Best answer June 05, 2019

Best Answers
Highlighted
QuickBooks Team

Create Report for Actuals Only

Hi Rick H,

 

You can use the Profit and Loss Standard report so you'll be able to see actual account balances. I'll show you how to do it.

  1. Click Reports.
  2. Click Company & Financial.
  3. Click Profit & Loss Standard.
  4. Click the Dates drop-down and change to This Fiscal Year.
  5. Change the Show Columns drop-down to Month.

Feel free to read this article for details: How to customize your Profit and Loss report.

 

For future reference, you might want to check out this handy article about built-in financial reports: Customize company and financial reports.

 

If you have additional concerns, please let me know. I'm here to help you some more.

 

PNL.JPG

View solution in original post

2 Comments
Highlighted
QuickBooks Team

Create Report for Actuals Only

Hi Rick H,

 

You can use the Profit and Loss Standard report so you'll be able to see actual account balances. I'll show you how to do it.

  1. Click Reports.
  2. Click Company & Financial.
  3. Click Profit & Loss Standard.
  4. Click the Dates drop-down and change to This Fiscal Year.
  5. Change the Show Columns drop-down to Month.

Feel free to read this article for details: How to customize your Profit and Loss report.

 

For future reference, you might want to check out this handy article about built-in financial reports: Customize company and financial reports.

 

If you have additional concerns, please let me know. I'm here to help you some more.

 

PNL.JPG

View solution in original post

Highlighted
Level 2

Create Report for Actuals Only

Thank you Sheilla this is very much appreciated!!

Need to get in touch?

Contact us