SECTIONSGrouping Data Using a Reporting Filter Mapping
Some of the templates supplied in the Reporting package incorporate a calculation, such as a calculation of total assets or variance.
The following example includes a calculation of gross profit.
Rows 1 to 10 are summarized as Sales and rows 11 to 20 as Cost of Sales. The two sub-totals are then used to calculate the Gross Profit. The gaps allow you to insert your own data.
With these reporting filter mappings:
| Reporting Filter Mapping | Type/Template Key | Reporting Filter |
|---|---|---|
| Sales Revenue | ROWS01 | RBA Sales Revenue (retrieves reporting balances associated with any general ledger account that represents sales revenue) |
| Cost of Sales | ROWS11 | RBA Cost of Sales (retrieves reporting balances associated with any general ledger account that represents cost of sales) |
| Other Expenses | ROWS21 | RBA Other Expenses (retrieves reporting balances associated with any General Ledger Account that represents expenses) |
The report will show:
| Home Value | |
|---|---|
| Sales Revenue | 1000.00 |
| Cost of Sales | 600.00 |
| Gross Profit | 400.00 |
| Other Expenses | 150.00 |
| Net Profit | 250.00 |
A more detailed example
If you wanted to analyze your revenue and cost of sales in more detail, you could amend the filters as follows:
| Reporting Filter Mapping | Type/Template Key | Reporting Filter |
|---|---|---|
| Sales - Hardware | ROWS01 | RBA Hardware Sales (reporting balances associated with any general ledger account that represents hardware sales) |
| Sales - Software | ROWS02 | RBA Software Sales (reporting balances associated with any general ledger account that represents software sales) |
| COS - Hardware | ROWS11 | RBA Hardware Costs (reporting balances associated with any general ledger account that represents hardware costs) |
| COS - Software | ROWS12 | RBA Software Costs (reporting balances associated with any general ledger account that represents software costs) |
| Other Expenses | ROWS21 | RBA Other Expenses (reporting balances associated with any general ledger account that represents expenses) |
By placing the sales filters in rows 1 to 10, cost of sales in rows 11 to 20 and other expenses above 20, the report will then show:
| Home Value | |
|---|---|
| Sales - Hardware | 750.00 |
| Sales – Software | 250.00 |
| 1000.00 | |
| COS - Hardware | 400.00 |
| COS – Software | 200.00 |
| 600.00 | |
| Gross Profit | 400.00 |
| Other Expenses | 150.00 |
| Net Profit | 250.00 |