Content Comparison

Sometimes, your budget line items are informed by detail that isn’t values are made up of details not shown in the Profit and Loss statement. Use You can use sum rows or working rows lines to include this detail in the Main tab. Then, you and your team can see the breakdown of where money is coming from or going to and get answers to your questions straight away.

Sum lines automatically calculate budget values. The values in the sum rows lines sum up to the main (parent) row. Working rows Sum lines are handy for expense accounts, such as office supplies and maintenance, that typically have supporting schedules managed elsewhere (external spreadsheet). Rather than viewing only the total value in the budget and looking elsewhere for the details, you can use sum lines to view the breakdown of the total right underneath the main budget row. For example, you might have a row for the Maintenance expense with multiple sum lines underneath for the cost of painting, roof replacement, and so on.

Working lines are more versatile than sum rows lines, and you can use them in two ways: add the data for information purposes or reference the data in formulas in the main budget row.

. Working lines are particularly handy for managing budget items based on a percentage of another item. For example, you might budget 2% of sales for your Advertising expense. You can enter the percentage into the working line and use a formula to calculate the expense, referencing the percentage and the Sales value. Then, if the sales value increases, the Advertising expense increases automatically.

Add a sum or working line to one row

To add a working or sum row:

Find the row for which you want to add the line. Hover over the first column of

that row

, click the blue Add button that displays

Image Removed

, then select Working line or Sum line

.

Image Added

Image Modified

For multiple budget items in bulk, select

Add sum or working lines to multiple rows in bulk

1. Use the search box to quickly find the rows for which you want to add lines.

2. Select the applicable rows, then

1. use either of these methods:

   • Click the Row menu, then select Working line or Sum line.

   • Hover over the first column of any selected

1. • rows, click the blue Add button that displays, then select Working line or Sum line.

Image Removed

1. • Image Added

2. In the Add [sum or working] lines window, enter a name for the sum

1. line and click Apply. If you want to add a working

1. line instead, click the toggle button to switch the sum

1. line to a working

1. line, then click Apply.

   Image Modified

Customize the format of the measures in a working line

Click the menu button (three dots) at the start of the working line and define your custom format. See Format measures in working and sum lines for more information.

Image Added

You don't have the option to apply a custom format to sum lines because it sums up to its parent row.

Example - Use a sum row

Delete a sum or working line

Expand the sum/working line, then hover over the first column of that row to display the Delete button. Click the Delete button, then click Delete to confirm.

Image Added

Examples and videos

Examples

lines. Image Modified

lines, one each for the loan balance, repayments and interest rate. Next, use a formula in the first Interest Expense cell to calculate the loan balance across the 12-month period (= Interest Rate * Loan Balance / 12), then copy the formula forward. Image Modified As the loan balance will change each month (increasing by the interest change and reducing by any repayments), use a formula in the second Loan Balance cell to calculate the loan balance value (= Loan Balance + Repayments + Interest Expense), then copy all rows forward to populate the remaining cells. Image Modified Now if you change the interest rate or repayments amount, the system will automatically update the Interest Expense values. Image Modified

Click the menu button (three dots) at the start of the working row and define your custom format. See Format measures in working and sum rows for more information.

Image Removed

You don't have the option to apply a custom format to sum rows because it sums up to its parent row.

Delete a sum or working row

Expand the sum/working row, then hover over the first column of that row to display the Delete button. Click the Delete button, then click Delete to confirm.

Image Removed

Phocas Academy videos:

• Use working rows

• Use sum rows

PUG Training videos

The following videos are segments of the PUG Training session: Budgets & Forecasts 101 – expenses. Watch the full session and others in the Budgets & Forecasts series here.

• Add working lines: This video shows how to add two working lines and refer to them in a formula to calculate the value of the Digital Marketing expense.

• Add working lines to multiple rows at the same time: This video shows how to add two working lines to multiple like rows in the budget simultaneously, then refer to the lines in a formula to calculate the value of the Digital Marketing expense. It also shows how to use the copy forward and copy down features to quickly populate the Digital Marketing expense rows, and change the measure format of the working lines to view decimal points.

• Add sum lines: This video shows how to add sum lines for three events under the Trade Show expense to automatically calculate the total expense value.