Skip to main content
T
TSsquared
March 19, 2020
Solved

How to run a budget vs actual profit and loss by class? We are a non profit and need to see how our classes are performing against the budget.

  • March 19, 2020
  • 4 replies
  • 0 views
Original commenter did not share additional details
Best answer by JasroV

Hi there, @TSsquared.

 

When importing your QuickBooks Desktop (QBDT) file to QuickBooks Online (QBO). There are transactions and reports that don't match. 

 

That being said, when you import your budget report from your QBDT to your QBO account. Only Profit and Loss budget types convert to QuickBooks Online. To learn more what data does and doesn't convert to QBO, you can check this article for the details: What to expect when you switch from QuickBooks Desktop to QuickBooks Online.

 

I also encourage you to check our Help articles page to learn some best practices on managing your QBO account.

 

You're always welcome to post here anytime you have other concerns. Our door is always open to help you. Have a great day and always stay safe.

4 replies

J
JamesDuanT
March 19, 2020

Hello TSsquared,

 

The Budget VS. Actuals: Profit and Loss by Class report is only available in QuickBooks Online Plus and Advanced. For non-profit organizations, it is called Statement of Activity.

 

If you're subscribed to QuickBooks Online Simple Start or Essentials, I'd recommend upgrading your plan to avail the report. Aside from that, you can see other added reports once you upgrade. You can use this link to compare the availability of the reports: Reports included in your QuickBooks Online subscription.

 

Here's how to pull up the Budget vs. Actuals report: Profit and Loss by Class:

  1. Click Reports on the left menu and search Budget vs. Actuals.
  2. You can customize the report based on the data you need to display.
  3. Click Run report.

You can browse these articles to know more about the report and how to manage it:

Once you're done customizing the report, you can memorize or export it to Excel if necessary.

 

Your knowledge of the report would give you more opportunity on how to manipulate or customize the displayed data.

 

We got you if you have more questions regarding the report.

 

Boost your immune system and stay safe. Have a great day!

T
TSsquaredAuthor
March 19, 2020

That didnt answer my question, I know you can run the budget by class and the profit and loss by class but when I run the budget vs actuals it a grand total not a comparison of the classes 

J
JamesDuanT
March 19, 2020

Thanks for getting back to me, TSsquared.

 

Currently, running a detailed budget report is part of the product limitations. You'll need to click the amounts to see the associated transactions. You can also pull up the Profit and Loss Detail or Profit and Loss by Class report and compare the amounts with the budget report.

 

I'll share your feedback about the report to our Product Development Team. This might be added to the product updates if many users requests for this feature or report. You can visit the QuickBooks Blog to see what's new on the program.

 

We'd be glad to hear of your ideas so we can improve the product to suit your business needs.

    vpcontroller
    vpcontroller
    March 19, 2020

    @TSsquared 

     

    How was the Budget created? You can run a budget vs actual profit and loss comparison report if you've prepared one in QBO.

    T
    TSsquaredAuthor
    March 19, 2020

    It was created in desktop and imported into QB Online, I can run it as a total but not by class.

     

    JasroV
    JasroVAnswer
    March 19, 2020

    Hi there, @TSsquared.

     

    When importing your QuickBooks Desktop (QBDT) file to QuickBooks Online (QBO). There are transactions and reports that don't match. 

     

    That being said, when you import your budget report from your QBDT to your QBO account. Only Profit and Loss budget types convert to QuickBooks Online. To learn more what data does and doesn't convert to QBO, you can check this article for the details: What to expect when you switch from QuickBooks Desktop to QuickBooks Online.

     

    I also encourage you to check our Help articles page to learn some best practices on managing your QBO account.

     

    You're always welcome to post here anytime you have other concerns. Our door is always open to help you. Have a great day and always stay safe.

      B
      briaal
      April 11, 2024

      We do have the plus version and I do see the option to filter by class on the Actuals vs. Budget.

      B
      briaal
      April 11, 2024

      And as a further note the 'Statement of Activity' only allows comparison to prior periods not to budget.

       

       

      JaeAnnC
      JaeAnnC
      April 11, 2024

      Thanks for getting back to us, @briaal.

       

      We'd love to help you with your report concern in QuickBooks Online (QBO). However, we need further details so we can have a better understanding of the issue.

       

      Could you please specify your issue regarding the Budget vs Actual Profit and Loss report in QBO? We'd appreciate any additional information you can provide.

       

      We're looking forward to hearing from you, briaal. Just click the Reply button below, and we'll respond promptly to your question. Stay safe.

      C
      Charlie424
      June 7, 2024

      I also am in the process of changing from desktop to online. I worked with the Customer Support team on 3 separate phone calls. The budget by class is a stopping point and quite frustrating. Monthly I need to provide each department director a budget to actuals report which I can no longer do. Some of my budgets are subs-budgets and roll up to the sub-department. The information I need to provide is the subs and the the roll-up. I provide to my BOD a monthly report on each concert we hold to see if each made a profit. Monthly does nothing for me. In the desktop my budget was loaded by class. My understanding is there is not a report where I can view, at a minimum, the budget entered for each class. Another issue. If I make a data input error, I have no way to see where the error is. I find it unacceptable that any corporation would not want know how each of their areas are performing to budget. This must be fixed immediately. As far as being able to customize the budget to actuals report, the options shown in this thread no longer exist.

      It was explained to me yesterday to get anything even remotely close to what my job requires, I should keep an excel sheet template of the class budgets. Then each month run a P&L for each class. Then manually populate the excel sheet with the newest data. Ridiculous!!

      Likewise, not every report can be exported to excel. Why?

      From my walk-through yesterday, I see even exporting to excel takes triple the steps. Or I can add the excel app and run that. Problem I have to figure put in QB Online what report I want to run first. The go to excel and hope I can run from there. 

      I see little to no advantage to QB online. Not time-saving. Not able to extract the data populated. Higher cost than desktop.

      Terms & ConditionsAccessibility statement