Purpose: Allows you to display, edit and add Program Revenue Journal entries which are used to produce the Statement of Activities.
Task Processing
Several differences from the ASP Grid processing are immediately apparent. All entries entered in the program revenue journal are available in the header and detail grids. It is not necessary to limit the entries displayed in the header grid to those for one fund at a time.
Setting focus on an entry in the header grid will display that entry’s accounts and amounts in the detail grid.
The data within the header grid can be sorted by clicking on any field in the header grid top bar. For example clicking on FundSCC will sort the grid by fund-scc number and can be either ascending or descending order by simply clicking FundSCC again. For example if the screen is displaying FundSCC descending, clicking FundSCC will change it to FundSCC ascending.
That same sorting methodology will work for Fund description, Entry #, Transaction Description, or Source.
The mouse icons on the bottom grid rows are as follows:
< - Previous record > - Next record Save changes X – Cancel changes + - Insert new record - - Delete record Refresh data
Adding a Journal Entry
With the cursor focus set in the header grid either hit “Insert” or Click on the “+” icon to insert a new line in the header grid for the new entry.
The following are the data fields for a header record:
- FundSCC – Allows the user to select the fund-SCC for which the entry is being entered by fund-SCC number. Selecting the fund-SCC number will populate the fund description.
- Fund description – Allows the user to select the fund-SCC for which the entry is being entered by fund description. Selecting the fund description will populate the FundSCC number.
- Entry # (number) – Transaction number assigned by the upload program, system or user. If you leave this field blank the system will assign the next available number.
- Description – General description of the transaction.
- Source – Transaction source – such as import or work paper reference.
- Copy to Next Fiscal Year - Check this box if you would like this entry to be copied over to the next fiscal year with 0 balances.
You should enter data for the fund, description, and source and save the header record (* or click on the save icon). You can provide the journal entry number, rather than allowing the system to assign it.
Saving the header record will move the cursor to the detail grid.
The following are the data fields for the detail grid:
- Revenue Account – The revenue being reclassified from the Statement of Revenues, Expenditures, and Changes in Fund Balance format.
- Revenue Type – Charges for Sales and Services, Operating Grants and Contributions, or Capital Grants and Contributions. (Determines the column on the Statement of Activities.)
- Program Account – Program against which the revenue is offset to determine net program expense. (Determines row on Statement of Activities.)
- Amount – Amount you want to credit to the program revenue account. (Accrual basis)
You can enter account code or account descriptions or you can select from either’s drop down menu. When you have completed all of the accounts and amounts save the entry (* or click on the save icon on the bottom of the detail grid).
The revenue account is the account from which you are moving the amount (2.04.XXX) to report as program revenue; the revenue type is the program revenue type (column) to which the revenue is being assigned and the program account is the functional expense account to which the program revenue is being assigned (2.05.XXX).
Entries in the detail grid in the program revenue journal are entered as positive or negative, rather than as debits or credits. To make an amount negative put the minus sign before the amount in the relevant amount field.
Copying a Journal Entry
With the cursor focus set in the header record of the entry you want to copy, hit the plus key. This will create a new header record with the data from the copied record. Select the fund to which you want to post the new entry and save the header record. This will populate the detail grid with the accounts used in the copied entry but the amounts will be zero. Enter the amounts in the detail grid and save the detail grid. You can add lines for accounts as needed or delete any unused lines. You can also edit the account in a copied line as needed.
Deleting a Journal Entry
With the cursor focus set in the header record of the entry you want to delete, hit the delete key. This will bring up a delete confirmation box asking if you are sure if you want to delete the entry. Clicking on OK or hitting enter will confirm the delete. Save the header grid (* or click on the save icon). The process is the same to delete a detail record.
Modifying a Journal Entry
With the cursor focus set in the header record of the entry you want to modify, you can modify any field in the header record or you can toggle (/) to the detail grid and modify any accounts or amounts. Save the grid you modified.
