Parks and Recreation Knowledge Base

Cash Journal Report

Updated on

Locating the Cash Journal Report

Log in to PARKS DIRECT and select Reporting > Report Output Listing on the menu tab.

Reporting menu expanded with Report Output Listing selected.

This will generate the Report Output Listing main screen. In the description box, type "Cash Journal" and filter out the modules/group list. Single click on the Module/Group: System - Financial.

Report Output Listing screen filtered by “Cash Journal” with System – Financial module highlighted.

Select the VSI-Cash Journal-System-Financial report.

VSI Cash Journal report row highlighted with Run Report button visible.

A preview window will appear n the right pane of the screen, but please note, this feature is only for the reports that are pre-built though the VSI software. Click Run Report.

Cash Journal Report preview showing transaction list and Run Report button.

The Information screen will appear, select Continue.

Information dialog showing report criteria screen with Continue button highlighted.

Setting Date Parameters

The Cash Journal report can return various data set by parameters on the GL Distribution Report screen. One of the features that can be set when running this report is the time frame.  

Locate the Use Posting Date Range under the Transaction Criteria section of the page and check that box.

Transaction Criteria section with Use Posting Date Range checkbox highlighted.

Once the box has been selected, additional options will appear.    

Note: This section should contain the date range/time frame you want in the report.

Transaction Criteria section showing Begin Posting Date and End Posting Date fields displayed after enabling posting date range.

Input the Begin Posting Date and the End Posting Date.

Transaction Criteria section with posting date range enabled and both begin and end posting dates set to the same day.

Setting Cash Drawer/Facility Parameters

To set the Cash Journal report to run solely for a facility, check the Use Cash Drawer Range box. Enter the Begin Drawer and End Drawer range that correspond to the facility you are looking for. Find the full list of cash drawers on the Screensteps article.

Note: (Skip this step if you'd like to see transactions from all M-NCPPC facilities.)

Transaction Criteria section with Use Cash Drawer Range enabled and begin and end drawer fields populated.

Setting User Parameters

If you want the Cash Journal report to display every transaction that occurred within the date and cash drawer range you specified, set parameters to return transactions from all users by checking the Use User Name Range box. Leave the Begin UserName field blank and set the End Username field to "ZZZZZZ."

User Range section with Use User Name Range enabled, begin username blank, and end username set to ZZZZZZ.

If you only want to see transactions from a specific user or set of users, leave the Use User Name Range box unchecked. For this query, select the user or users you want from the user datagrid on the left pane of the Core tab.

User datagrid displaying selected user accounts highlighted for report filtering.

Running the Report

Once you have your parameters set appropriately, click Process at the bottom right of the screen to begin running the report.

Process button highlighted between Default Settings and Prev buttons.

On the next screen you'll see three different fields labeled: Cash Journal Format Options, File Format, and Output Options.

The Cash Journal Format Options contains a various ways to determine the layout of the report. You always want to check the option Print End of Shift Batch Number to ensure that the specific Batch Number each transaction belongs to will print on the report.

Cash Journal Format Options section with Print End of Shift Batch Number checkbox selected.
Print End of Shift Batch Number checkbox highlighted as selected.

Under the File Format section, select PDF. If you want to do this through mass email, select the CSV option. This will generate an export Excel file.

File Format section with PDF option selected.

In Output Options, select the option on which you'd like for the final report to generate. (The most commonly used is Preview Report.)

Output Options section with Preview Report selected and other options unchecked.

Print Report will generate the report to print without viewing before you print.  

Preview Report (recommended)  will allow you to look view the report on your computer screen before you print.

E-mail Report will e-mail the report to the address of your choice.

FTP Report is less useful and will not be checked in almost all circumstances.

Once your preferred Output Option is selected, click Continue.

Continue button highlighted at bottom of report options screen.

The Success screen: 

Success message confirming report sent to server for processing.

After a short delay, the report will appear as requested under the Output Options field.

Generated Cash Journal Report showing payment type totals and grand totals.

If the report is blank, return back to the GL Distribution Report (the main screen) of the Cash Journal Report and select the Default Process button. This will clear any and all information that is set into the fields. Then, input the information again.

Default Settings button highlighted on the Cash Journal Report main screen.

Contact the Help Desk for any additional assistance.

Previous Article GL Distribution Report - Summary by Drawer
Next Article Household Trial Balance Report