Daily Transaction Listings

Use the options on the Daily Transaction Listings menu to generate reports of daily posting activities. These reports are used to balance and verify entries.

Menu Path:  Fund Accounting > Reports > Daily Transaction Listings > select an option

Verifying Posting Activities

Run the appropriate report whenever you need to verify posting activities. For example, if a series of journal entries is posted, you can run the Journal Entry Activity report to verify the entries. Reports should be proofed against source documents and by someone other than the person who entered the data.

Notes do not appear in these reports. If you want reports that include notes, run the Expenditure, Revenue, Project, or General Ledger Audit Trail report options on the Audit Trails menu . Refer to those sections in Audit Trails.

Transaction Codes

Transaction codes appear in all Daily Transaction Listing reports under the T/C column heading. These codes identify the type of financial transaction associated with an entry. Following are the codes used:

T/C Financial Transaction

11 Post Expenditure Budgets
12 Post Revenue Budgets
13 Adjust Expenditure Budgets
14 Adjust Revenue Budgets
15 Post Project Budgets
16 Adjust Project Budgets
17 Add Encumbrances
18 Change Encumbrances
19 Journal Entries
20 Manual/Void Checks
21 Accounts Payable
22 Payroll Interface and Manual Payroll
23 Receivables
24 Receipts
25 Expenditure Budget Transfers
26 Revenue Budget Transfers
27 Project Budget Transfers

Standard Report Procedure

Following is the standard procedure that applies to all Daily Transaction Listing options. Any additional steps for a particular option will be noted in the section where the option is discussed.

Generating a Daily Transaction Listings report

1. Select the desired option from the Daily Transaction Listings menu to display a report page.
   All Daily Transaction Listings pages include a Report Criteria section for selecting the records to include in a report.
   
   • The Vendor Audit Report and Transaction Status Report pages include an Advanced button for using additional fields in a search.
   • The Payable Activity Report and Receiving Report pages provide radio buttons for changing the sort order of these reports. The Journal Entry Report has a sort drop down.
   • The Receipt Activity and Receiving Report pages also include a Report Type section for selecting different versions of the report.
2. In the Report Criteria section, enter selection criteria to specify the records you want to include.
3. Click OK to display a standard Print page.

4. In the Print page, select one of the following radio buttons:

   File	Stores the report in a file for printing or viewing later. You can accept or replace the default file name for saving the report.
   Screen	Displays the report on your monitor. If needed, you can print or save a report after viewing it.
   Excel	Sends the report to excel. Based on your selection in the Data Option field of the print page, you can select to print all the information in the report, or omit totals.

   You can also select a printer other than your default printer and specify the number of copies to print.

5. Click OK to generate the report. A Processing displays showing the system's progress in processing the report.
6. Click Yes to clear data from the activity file used to generate the report.
   Generally, you should clear this file after running a report so that the next report covers current activity only. The data that is cleared is available through other reports, such as the Transaction Analysis report and reports on the Audit Trails menu.
   Or
   Click No to retain the data.