Modify the sample row definition in Management Reporter

In this section, you will modify the new row definition to create the following sections:

  • A revenue section that shows the sources of income

  • An operating expense section that shows the costs of doing business

  • An income section that provides totals for the report

You will add rows, change or add descriptions, insert formulas, create row totals, and more.

In this topic

Sample row definition

Set up the revenue rows in the sample building block

Set up the operating expense rows in the sample building block

Set up the net income row in the sample building block

Sample row definition

The following table shows the completed sample row definition. Use this table as a reference while you are working on the row definition modification procedures.

Row Code

Description

Format Code

Related Formulas/Rows/Units

Format Override

Normal Balance

Print Control

Column Restriction

Row Modifier

Link to Financial Data Source

25

DES

50

Revenue

DES

75

DES

100

Sales

C

410?-(4109)

160

Sales Returns

4110

190

Sales Discounts

4250

197

---

204

Net Sales

TOT

100-160-190

211

DES

220

COGS

450?-(4509)

223

---

226

Gross Margin

TOT

204-220

229

---

232

DES

235

DES

238

Operating Expenses

241

DES

250

Salary Expense

5000

280

Officers Comp

5050

310

Depreciation Expense

5100

340

Office Expense

5200

370

Supplies

5225

400

Maintenance

5240

430

Rent

5250

460

Travel

5300

490

Advertising

5350

520

Commissions Expense

54??

525

---

530

Total Operating Expenses

TOT

250:520

550

---

580

Net Income

TOT

226-530

CS

Top of Page

Set up the revenue rows in the sample building block

  1. Add rows for the revenue section title:

    1. In the new row definition, select row 100 (Sales) through row 160 (Sales Returns).

      Note: To select these rows, click the box to the left of the cell containing 100, hold down SHIFT, and then click the box to the left of the cell containing 160.

    2. On the Edit menu, click Insert Row.

      Three new rows appear above row 100. The new row codes are evenly spaced to fit the gap, in this case 25, 50, and 75.

    3. In row 25, double-click the Format Code cell, and then click DES.

      This code adds a blank row in the report.

    4. In row 50, click the Description cell, and then type Revenue.

    5. In row 50, double-click the Format Code cell, and then click DES.

    6. In row 75, double-click the Format Code cell, and then click DES.

  2. Modify the sales rows:

    1. In row 100 (Sales), click the Link to Financial Data Source cell, and then type 410?-4109 to overwrite the original text.

      The 410? portion pulls in the total for all natural accounts in the range 4100 to 4109. The -4109 portion subtracts the values for account 4109 from the total. Management Reporter inserts parentheses into the formula.

      The C code in the Normal Balance cell reverses the sign of the normal balance credit account so that the value appears as a positive amount on the report.

    2. Select row 130 (Sales - Intercompany), and then, on the Edit menu, click Delete Row.

  3. Add a row and calculation for net sales:

    1. Select row 220 (COGS) through row 280 (Officers Comp).

    2. On the Edit menu, click Insert Row.

      Three new rows appear above row 220.

    3. In row 197, double-click the Format Code cell, and then click ---  (Underscore amounts).

      This code creates an underline beneath row 190 (Sales Discounts) in the report.

    4. In row 204, double-click the Description cell, and then type Net Sales.

    5. In row 204, double-click the Format Code cell, and then click TOT.

      This code indicates that the row contains a total.

    6. In row 204, click the Related Formulas/Rows/Units cell, and then type 100-160-190.

      This formula subtracts the values in rows 160 and 190 from the value in row 100.

  4. Modify the cost of goods sold rows:

    1. In row 211, double-click the Format Code cell, and then click DES.

    2. In row 220 (COGS), click the Link to Financial Data Source cell, and then type 450?-4509 to overwrite the original text.

  5. Add a row and calculation for gross margin:

    1. Select row 250 (Salary Expense) through row 430 (Rent).

    2. On the Edit menu, click Insert Row.

      Seven new rows appear above row 250. You will use these rows for this and the following procedures.

    3. In row 223, double-click the Format Code cell, and then click ---.

    4. In row 226, click the Description cell, and then type Gross Margin.

    5. In row 226 double-click the Format Code cell, and then click TOT.

    6. In row 226, click the Related Formulas/Rows/Units cell, and then type 204-220.

    7. In row 229, double-click the Format Code cell, and then click ---.

    8. On the File menu, click Save.

      Note: For an example of what your row definition should look like, see rows 25 to 229 in the sample row definition in this section.

Top of Page

Set up the operating expense rows in the sample building block

  1. Use two blank lines to separate the revenue rows from the operating expense rows:

    1. In the row definition, in row 232, double-click the Format Code cell, and then click DES.

    2. In row 235, double-click the Format Code cell, and then click DES.

  2. Add a description row for operating expenses:

    1. In row 238, click the Description cell, and then type Operating Expenses.

    2. In row 241, double-click the Format Code cell, and then click DES.

  3. Modify the expense rows:

    1. In row 520 (Commissions Expense), click the Link to Financial Data Source cell, and then type 54?? to overwrite the original text.

      The code 54??? pulls in the total for all natural accounts in the range 5400 to 5499.

    2. Select row 550 (Income Tax Expense) through row 670 (no description).

    3. On the Edit menu, click Insert Row.

      Five new rows appear above row 550.

    4. In row 525, double-click the Format Code cell, and then click ---.

  4. Add a row and calculation for total operating expenses:

    1. In row 530, click the Description cell, and then type Total Operating Expenses.

    2. In row 530, double-click the Format Code cell, and then click TOT.

    3. In row 530, click the Related Formulas/Rows/Units cell, and then type 250:520.

      This formula adds the values in row 250 (Salary Expense) through row 520 (Commissions Expense).

    4. In row 550, double-click the Format Code cell, and then click ---.

    5. On the File menu, click Save.

      Note: For an example of what your row definition should look like, see rows 232 to 535 in the sample row definition in this section.

Top of Page

Set up the net income row in the sample building block

  1. In the row definition, in row 580, click the Description cell, and then type Net Income.

  2. In row 580, double-click the cell in the Format Code column, and then click TOT.

  3. In row 580, click the Related Formulas/Rows/Units cell, and then type 226-530.

  4. In row 580, double-click the Print Control cell, select CS, and then click OK.

    This code adds a currency symbol to this row.

  5. On the File menu, click Save.

    Note: For an example of what your row definition should look like, see rows 540 to 610 in the sample row definition in this section.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×