{"type":"doc","content":[{"type":"heading","attrs":{"level":2},"content":[{"text":"Show Me","type":"text"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"html","parameters":{"macroParams":{"__bodyContent":{"value":" "}},"macroMetadata":{"macroId":{"value":"620cbfd4-8d97-495d-a18b-394c839c5728"},"schemaVersion":{"value":"1"},"title":"html"}}}},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Video - 2:51","type":"text"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"cxhtml":"BLOCK

Tell Me

What is the Actual Details by Date Period report?

The Actuals Detail by Date Period report shows all transaction lines pertaining to a selected chart-string for the selected date period.

Who Should use this report?

The report provides low-level detail that will show a users what specifically their revenue or expenses are for their department.

The report is also useful for reconciling, as it is similar to the Retriever Account Inquiry report.

Running the Report

File Path: Financial Reports > Detail Reports > Actuals Detail by Date Period

Parameters

Set the report period:

Begin Date

End Date

Department - Select one department or a roll-up department.

Account - Defaults to all accounts, users can also select specific account, or a specific type of account (at the bottom).

Fund - Select one fund code.

Projects - Select which projects to include.

Include Fringe Benefits -Fringe Benefits that are reimbursable for 1111 fund. Defaults to "Yes".

*NEW March 2020: You can now click to include "Year-End periods", to include entries made in the the adjustment periods (906, 910, 920, 930, 970, & 998).

Reading the Report

The report is broken down into different transaction categories.

The first page will have the revenue transactions (if applicable).

The next page will show the payroll information.

The next page are the operating expenses. All the detail information for operating expenses from each transaction line will appear on the same table (Both Journal Entries and Vouchers).

Drill Downs

Clicking on the journal ID will pull up the Journal Entry Detail report and show all the journal information.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt","parameters":{"macroParams":{"atlassian-macro-output-type":{"value":"BLOCK"}},"macroMetadata":{"macroId":{"value":"1b98ea4f-1e20-4aa5-b8a2-c43bc8ec0e9b"},"schemaVersion":{"value":"1"},"title":"Excerpt"}}},"content":[{"type":"heading","attrs":{"level":2},"content":[{"text":"Tell Me","type":"text"}]},{"type":"paragraph","content":[{"text":"What is the Actual Details by Date Period report?","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"The Actuals Detail by Date Period report shows all transaction lines pertaining to a selected chart-string for the selected date period.","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Who Should use this report?","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"The report provides low-level detail that will show a users what specifically their revenue or expenses are for their department.","type":"text"}]},{"type":"paragraph","content":[{"text":"The report is also useful for reconciling, as it is similar to the Retriever Account Inquiry report.","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Running the Report","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"File Path:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"https://rex-web.ps.umbc.edu/Reports/Pages/Report.aspx?ItemPath=%2fFinancial+Services%2fFinancial+Reports%2fDetail+Reports%2fActuals+Detail+by+Fiscal+Year&ViewMode=Detail"}}]},{"text":" ","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"https://rex-web.ps.umbc.edu/Reports/Pages/Report.aspx?ItemPath=%2fFinancial+Services%2fFinancial+Reports%2fDetail+Reports%2fActuals+Detail+by+Fiscal+Year&ViewMode=Detail"}}]},{"text":"Financial Reports > Detail Reports > Actuals Detail by Date Period","type":"text","marks":[{"type":"underline"},{"type":"link","attrs":{"href":"https://rexprd-ssrs1.rex.aws.umbc.edu/Reports/report/Financial%20Services/Financial%20Reports/Detail%20Reports/Actuals%20Detail%20by%20Date%20Period"}}]}]},{"type":"paragraph","content":[{"text":"Parameters","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Set the report period:","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Begin Date","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"End Date","type":"text"}]},{"type":"paragraph","content":[{"text":"Department - Select one department or a roll-up department.","type":"text"}]},{"type":"paragraph","content":[{"text":"Account - Defaults to all accounts, users can also select specific account, or a specific type of account (at the bottom).","type":"text"}]},{"type":"paragraph","content":[{"text":"Fund - Select one fund code.","type":"text"}]},{"type":"paragraph","content":[{"text":"Projects - Select which projects to include.","type":"text"}]},{"type":"paragraph","content":[{"text":"Include Fringe Benefits -Fringe Benefits that are reimbursable for 1111 fund. Defaults to \"Yes\".","type":"text"}]},{"type":"paragraph","content":[{"text":"*NEW March 2020: You can now click to include \"Year-End periods\", to include entries made in the the adjustment periods (906, 910, 920, 930, 970, & 998).","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Reading the Report","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"The report is broken down into different transaction categories.","type":"text"}]},{"type":"paragraph","content":[{"text":"The first page will have the revenue transactions (if applicable).","type":"text"}]},{"type":"paragraph","content":[{"text":"The next page will show the payroll information.","type":"text"}]},{"type":"paragraph","content":[{"text":"The next page are the operating expenses. All the detail information for operating expenses from each transaction line will appear on the same table (Both Journal Entries and Vouchers).","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Drill Downs","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Clicking on the journal ID will pull up the Journal Entry Detail report and show all the journal information.","type":"text"}]}]}],"version":1}}}},{"type":"paragraph"}],"version":1}

What is the Actuals Detail by Date Period report?

Show Me