FAST Financial Reporting – Transaction Details Revenue and Expense Report

In this video tutorial you will learn to run the Transaction Details Revenue and Expense Report. The Transaction Details Revenue and Expense Report provide you with a line-by-line transaction details for accounts that start with a four, five, six, seven, eight or nine for the filter criteria selected. In this video you will learn how to: access the Transaction Details Revenue and Expense Report; run the report; understand the report results; and filter, sort and drill down on report results. The Transaction Details Revenue and Expense Report can be accessed in one of three ways. To navigate to the report from the FAST home page click on the Finance Reporting link in the Applications box on the right-hand side of the screen.

The report can be accessed directly from the Application Info tab by selecting Transaction Details Revenue and Expense from the Report drop down menu. From Finance Reporting you can also access the report through the Operating Statements menu available at the top of the screen.

To access the report here click on Operating Statements select Transaction Details Revenue and Expense, Lookup and finally Actuals. This will take you to the filter options page for this report. The report is also available directly from the Merqueens’/SOLUS portal.

To access the report log into the portal using your Queen’s NetID and password and click on My Applications. The link to the report is available in the Financial Reporting Information section under Department Reports and Research Reports. To run the report, you can enter Chatfield filter criteria such as Fund, Department ID, Account or Project directly on the Application Info tab or on the filter options page. Remember that you can enter wild cards or ranges as filter criteria. Choose the report end date from the drop-down menu.

Click on Enter once you have selected your filter criteria. This will bring you to the filter options page. Here you can enter additional filter criteria or modify any filter criteria previously selected. Please note you must enter criteria for at least one up these filters Fund, Department, Account, Program, Class or Project. You can also choose an applicable date range from the Date Range From field.

Once you are satisfied with your filter criteria click on the Execute Report button to run your report.

You can now see your transaction details for the filter criteria you selected. I will now explain the different features of this report. Amount represents the monetary amount charged to the applicable Chatfield string. Date represents the accounting date for the transaction.

Period represents the fiscal period for the transaction. For example, period 01 represents May, period 02 represents June and so on. Journal ID identifies the journal entry or account payable entry that created the transaction line detail. Header Description represents the long description entered on the PeopleSoft journal entry header page.

Line Description represents the PeopleSoft journal line description.

Ref # represents the journal entry reference or account payable voucher number. Source identifies the unit responsible for posting the entry. For example, RSH for Research; APS for Faculty of Applied Science and so on. User ID identifies who posted the entry. you can drill down on the hyperlinked values in the Journal ID column to see account payable details or journal entry details.

You can filter on report results by clicking on the column header and selecting Apply Custom Filters. For example, if you only need to see accounts payable entries you would click on the Journal ID column header and apply a filter to see Journal IDs that are Like AP. To finish the process, click on Apply Filters. Notice that the column header has changed colour. To remove a custom filter, click on the column header and select Remove Custom Filtering for this Column.

You can also sort report results by clicking on the column header and selecting Sort Ascending or Sort Descending.

The triangle symbol indicates that a column has a sort applied to it. To remove sorting click on the column header again and choose Remove Sorting. You can always return to the filter options page by clicking on the Filter Options tab or one of the hyperlinks in the filter trail. Thanks for taking the time to watch our video tutorial on the Transaction Details Revenue and Expense Report.

More video tutorials on the FAST Financial Reporting tool are available through the TRAQ and the Financial Services web sites.

(PLR) Microsoft Ads Training Kit

Main Webinar: Our Main Webinar Presentation

Author: yoselkbaez36ck

Discover the Inspirational Journey of Jose Amoros I hope this message finds you well. I wanted to introduce you to a compelling narrative that might inspire and resonate with you: "Biographical Info de Jose Amoros." Jose Amoros, renowned for his innovative contributions and profound insights, offers a remarkable story of perseverance and achievement. His journey is a testament to the power of resilience and vision, illustrating how dedication can transcend obstacles and lead to impactful success. Diving into Jose's biography unveils lessons on leadership, creativity, and transformation—elements that are essential in today's fast-evolving landscape. Whether you're looking for motivation, new perspectives, or inspiring stories, Jose’s experiences can provide valuable takeaways for your own endeavors. I'd love to discuss how his journey can inspire and benefit [https://website.ws/yosekbaez60/] as you navigate your path toward continued success. Are you available for a brief call this week? Looking forward to the opportunity to connect. Best regards,