About Totals and Subtotals

Sage 300 ERP

About Totals and Subtotals

Financial statements contain columns of figures that are subtotaled and totaled according to account type.

The most common arithmetical operation involves summing the balances or net changes of groups of accounts at a moment in time, as in the following example:

 

Current Balance

Last Year Balance

Petty cash

274.57

358.00

Bank account, US dollars

8,437.54

5,932.90

Bank account, CAD dollars

4,372.96

3,665.39

  Total:

13,085.07

9,956.29

If this was a spreadsheet, you would place a formula such as =SUM(B3:B5) in each of the "total" cells. This formula would add together the values in cells B3, B4 and B5, and display the total in B6.

Totaling a column of figures with Financial Reporter is just as easy. All you do is refer to the cells or range of cells in the specification, and Financial Reporter will translate the cell references in the final report. You may refer to a single cell, a list of cells, or a cell range.

In the following example, the formula =SUM(F3) will be translated when you generate the report to the appropriate range of cells in the Report range to add the balances of all accounts in the range 1100 to 1300.

image\totaling.gif

Note:

Excel does not allow you to specify a negative range of cells as a parameter of SUM. For example, the following SUM formula will not work in Excel: =SUM(-G10:G14).

You can fix the formula by moving the minus sign like this: =-SUM(G10:G14).

In summary, to perform any mathematical operations within the financial report, use standard spreadsheet formulas and functions.

Related Topics