The end goal of allocating revenue and costs, of course, is to examine the profits or costs associated with each segment of the business; i.e., its profit centers and cost centers. This lesson shows how to prepare a ManagePLUS Gold Profit Analysis report, which is a profit and loss report for a profit center or cost center but with enhanced information about allocated amounts.

Before you start…

If you skipped the advanced quantity handling tutorials, please do the following to make it easier for you to follow the steps in this lesson:

1. Be sure the Enable advanced quantity handling option is on (check marked) in ManagePLUS Preferences (Edit > Preferences > Company > Options). Some of the quantity information shown in this lesson will only be available with advanced quantity handling.
2. Go to the Transactions window and refresh transactions from QuickBooks, to cause transaction quantities to be recalculated.
3. In the Classes window, add the following management quantity entry for Crops:Corn, if it isn’t there already:

ManagePLUS for QuickBooks qsallocprofanalmgmtqty 18. Getting a Profit Anaysis report

Preparing a Profit Analysis report

The easiest way to get a Profit Analysis report is to locate the cost center or profit center for which you want the report, than a right-click and select the report from the pop-up menu.

1. Select or open the Classes window in ManagePLUS Gold.

ManagePLUS for QuickBooks tlbar main classes2 18. Getting a Profit Anaysis report

2. Find the Crops:Corn class. (You may have to scroll down.)
3. Right-click anywhere on the Crops:Corn row, then select Profit Analysis report (for this class) from the pop-up menu.

ManagePLUS for QuickBooks qsallocprofanalpopupmenu 18. Getting a Profit Anaysis report

ManagePLUS for QuickBooks starblue 18. Getting a Profit Anaysis report Another way is to choose Reports > Profit or Cost Center Analysis from the main menu, .

 ManagePLUS Gold will open the report in a new tab:

ManagePLUS for QuickBooks refrepprofanalcropscorn 18. Getting a Profit Anaysis report

ManagePLUS for QuickBooks arrow r 18. Getting a Profit Anaysis report This report is based on a small set of example transactions…don’t be surprised if some of the numbers and per-unit statistics appear odd or outside of “real world” expectations.
4. Scroll down to the bottom of the report, and notice the Allocated Expense (MP) section.

 This is where allocations from other classes appear. In a prior lesson you allocated some of the expense from the Equipment:Combine cost center to the Crops:Corn profit center, and that shows up here.

ManagePLUS for QuickBooks qsallocprofanalallocsection 18. Getting a Profit Anaysis report

 If you had made other allocations to Crops:Corn, they would appear in this section too.

5. Scroll up (if necessary) to the Utilities:Electricity line in the Expenses section of the report.

ManagePLUS for QuickBooks qsallocprofanalelectricitysection 18. Getting a Profit Anaysis report

 In an earlier lesson you allocated this amount from Utilities:Electricity expense to Crops:Corn. But why is it here in the Expense section of the report and not in the Allocated Expense (MP) section? Because allocations from accounts to classes are handled as normal income or expenses. Only allocations from classes to other classes are included in Allocated Expense (MP).

ManagePLUS for QuickBooks starblue 18. Getting a Profit Anaysis report Why are allocations from accounts to classes listed in the main part of the report?

 

Because allocating an amount from an account to a class in ManagePLUS Gold has exactly the same effect as assigning a class to a transaction in QuickBooks. The only difference is that the class is being assigned to an income or expense outside of QuickBooks when you do it in ManagePLUS Gold.

Adding/changing information in a report

While many of the cells in a report spreadsheet are formulas, and not editable, ManagePLUS lets you edit any cells highlighted in the Editable cells color (light blue in these examples). That’s handy for adding quick calculations or changing data on which part of the report is based. The following steps show how to add or change a management quantity in the report, to have per-unit costs calculated on a different basis.

1. Scroll to the right side of the report, and notice that the Mgmt. Qty B columns are mostly empty:

ManagePLUS for QuickBooks qsallocprofanalmgmtqtybempty2 18. Getting a Profit Anaysis report

ManagePLUS for QuickBooks arrow r 18. Getting a Profit Anaysis report If the columns shown above are not present, click on the Modify button in the report window’s toolbar, then check mark the missing column choices (on the Layout tab of the Modify Report dialog).

 These columns are empty because there’s no Mgmt. Qty B associated with Crops:Corn in the Classes window. We could go back to the Classes window and supply one, then re-create the report. But there’s a quicker way. We’re going to supply a Mgmt. Qty B right there in the report, to calculate costs on a per-bushel-sold basis.

 First though, we need to find how how many bushels were sold.

2. Scroll to the upper left part of the report, and click on the cell where the Corn (bu.) row and Qty 1 column intersect.

 This cell shows the Corn sales quantity, totaled from the QuickBooks transactions for the Sales:Grain:Corn account.

ManagePLUS for QuickBooks qsallocprofanalcornqtycell2 18. Getting a Profit Anaysis report

 Let’s copy this quantity, and paste it into the report’s Mgmt. Qty B cell.

3. Right-click on the cell, then select Copy from the popup menu.

ManagePLUS for QuickBooks qsallocprofanalcornqtypopupmenu 18. Getting a Profit Anaysis report

4. Click on the Class Info tab at the bottom of the report window.

ManagePLUS for QuickBooks qsreporttabsclassinfoclick 18. Getting a Profit Anaysis report

5. Right-click on the cell where the Corn row and Mgmt. Qty B column intersect, then select Paste from the popup menu.

ManagePLUS for QuickBooks qsallocprofanalmgmtqtybpastemenu2 18. Getting a Profit Anaysis report

6. Click in the cell just to the right, then type “bu.” there.

 The window should look something like this when you’re done:

ManagePLUS for QuickBooks qsallocprofanalmgmtqtybentered 18. Getting a Profit Anaysis report

7. Click on the Main Report tab at the bottom of the report window.

ManagePLUS for QuickBooks qsreporttabsmainreportclick 18. Getting a Profit Anaysis report

8. Scroll to the right side of the report again, and notice what’s in the Mgmt. Qty B columns now:

ManagePLUS for QuickBooks qsallocprofanalmgmtqtybpopulated2 18. Getting a Profit Anaysis report

 Now the Mgmt. Qty B columns show statistics for each income and expense amount on a per-bushel-sold (Mgmt. Qty B) basis.

ManagePLUS for QuickBooks starblue 18. Getting a Profit Anaysis report Changing any highlighted (editable) cell in a report will cause all cells which depend on it to have their amounts updated immediately.
 

ManagePLUS for QuickBooks lightbulb 18. Getting a Profit Anaysis report

Want to change even more?

 

ManagePLUS for QuickBooks qsallocreportexportbtn2 18. Getting a Profit Anaysis report

The easiest way to make extensive report changes—add new formulas, hide/delete/add rows or columns, etc.—is to export the report as a Microsoft Excel file, then open it in Excel or any Excel-compatible spreadsheet program.

See also:

Working with Cost Centers, Profit Centers, and Allocation in How-To Procedures

18. Getting a Profit Anaysis report