Customizing a Transaction Detail report in Management Reporter

If you want to generate a transaction detail report, you must first create a customized column definition specifically for that type of report.

When you set up the column definition for your transaction detail report, include at least one column for the financial data current period amounts (PERIODIC) and at least one column for the financial data year-to-date amounts (YTD). The transaction amounts appear in the PERIODIC column and period balances in the YTD column. You can also include any transaction detail codes that are specific to your accounting system.

When you generate your transaction detail report, use either the Transaction Only, Financial & Transaction option or the Financial, Account & Transaction option in the Detail Level list of the report definition.

Note:  By default, transaction detail accounts with a zero balance and no period activity are suppressed in reports. If you want to show these transaction detail accounts, select the Display rows with no amounts check box on the Settings tab of the report definition.

In this topic

Creating a Multiple Period Transaction Detail Report

Creating a Year-to-Date Transaction Detail Report

Creating a Debit/Credit Report

Creating a Multiple Period Transaction Detail Report

Transaction detail amounts can appear only in columns for which the Time Range cell is set to PERIODIC. If you want a report to cover more than one period, enter the period range in the Period cell of the PERIODIC column. For example, to run a report that covers the last three periods, enter a Period of BASE-2:BASE in the PERIODIC column.

You can use multiple scenarios in a transaction detail report.

Top of Page

Creating a Year-to-Date Transaction Detail Report

To run a transaction detail report for the entire year, type 1:BASE in the Periodcell of the PERIODIC column, and then type BASE in the YTD column, as shown in the following table.

 

A

B

C

Header 1

Activity

Balance

Column Type

DESC

FD

FD

Scenario/Attribute Category

ACTUAL

ACTUAL

Fiscal Year

BASE

BASE

Period

1:BASE

BASE

Time Range

PERIODIC

YTD

You can specify YTD columns for transaction detail reports, but no transactions appear in the YTD columns.

Top of Page

Creating a Debit/Credit Report

To create a report that categorizes transactions by debit and credit, create two PERIODIC columns (one PERIODIC column for debits, and one PERIODIC column for credits). Also create one YTD column for the period totals. Enter the debit code (DR) in the Column Restriction cell of one of the PERIODIC columns, and the credit code (CR) in the Column Restriction cell of the other PERIODIC column, as shown in the following table.

 

A

B

C

D

E

Header 1

Beg Balance

Debits

Credits

YTD

Column Type

DESC

FD

FD

FD

FD

Scenario/Attribute Category

ACTUAL

ACTUAL

ACTUAL

ACTUAL

Fiscal Year

BASE

BASE

BASE

BASE

Period

BASE

BASE

BASE

BASE

Time Range

PERIODIC/BB

PERIODIC

PERIODIC

YTD

...

Column Restrictions

DR

CR

As in other transaction reports, if you want to display details for multiple periods, enter a range (for example, 1:BASE) in the Period cell.

Note:  The value in the Column Restrictions cell overrides any restriction that is assigned in the row definition.

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!

×