What This Report Shows


  • This report shows balance sheet activity for a specific fiscal period with beginning balances. The report displays the following: Processing Year and Month, Posted Status, Posted Date, Entry Date (Distributed Date), Source User, Comments, and Source Archive. Descriptions pull from the Chart of Accounts. There is an optional sort by sources as well as the ability to total by account.
  • Source archive pertains to the archived report that created the activity.


Best Practices


  • Although distributed activity can be selected, the normal selection is posted activity only to facilitate comparison to activity reports.


Balance Sheet Monthly Activity Report


  1. Finance → Financial Management → Reports → Activity Reports→ G/L → Balance Sheet Monthly Activity
  2. This reports shows activity for transactions that were created in different modules.
  3. The report shows the account code that was affected by the transaction.
  4. Populate applicable fields using the screen shot and field description below as a guide.
  5. Once the necessary ranging options are used, click Run Report.


Select and Sort Tab

FIELDSOpt.Rec.Req.Description
Fiscal Year/Fiscal Month——♦Range on fiscal year and month (YYYY-MM)
Account Sources——♦Sources from which activity will be drawn and shown on the report
Select Posted—♦—Normal selection when running activity report
Select Distributed♦——True if appropriate
Optional Sort Level——♦Allows for sorting through dimensions


Range Tab

FIELDSOpt.Rec.Req.Description
Range Criteria♦——Enter up to two messages if desire; these will print on the transmittals
Reference ID♦——
  • Reference ID for Journal Entries and Receipts - Journal ID
  • Reference ID for Payroll - Pay ID
Opt. = Optional  Rec. = Recommended  Req. = Required