You are here: Reports > Monthly Activity Report

MONTHLY ACTIVITY REPORT
Function 
To produce a listing of all activity recorded within the specified period.

Operating Instructions

Period 
The screen will default to the current period, displayed as MM/YY.  You may edit the field if desired by entering or selecting an alternate period in the same format.

Report Options         
“Detail” will produce an itemized report showing the specifics of each activity recorded, with “Summary by Fund” as the final page.

“Summary” will produce only the “Summary by Fund” portion of the report.

Sort by Fund             
Selecting this option will cause the transactions to appear in funding source order.

Sort by Date              
Selecting this option will cause the transactions to print in order by Activity Date.

Sort by Loan #
Selecting this option will cause the transactions to print in order by Loan # order.

Include All Dates      
The term “Dates” refers to the activity date entered when the activity was recorded. 

Leaving the dot in “Yes” will produce a report that includes all activity posted within the specified period.

Moving the dot to “No” will allow selection of a date range.  Select the dates by clicking on the calendar.  If a “From” date is selected, it is required that a “To” date also be selected.  Using this option will result in a report that only includes activity recorded for that period with activity dates matching the date range entered.

Include All Activity Types 
Removing this checkmark will allow you to produce a report with only Repayments, Disbursements or Escrows. 

Include All Funds     
Leaving the dot in “Yes” will produce a report that includes activity posted within the period for all existing loan funds. 

Moving the dot to “No” will allow selection of specific funds.  To select a fund, hold down the Ctrl key and click on the funding code and description.  This fund will then be highlighted, indicating the fund is to be included on the report.  If more than one fund is to be selected, hold down the Ctrl key and click on the additional fund(s).  If you wish to remove a loan fund from the report once it has been selected, Ctrl/click will remove the checkmark.

Ending Date              
This is an automatic field for information purposes and cannot be edited.  If all dates were selected for the report, this field will display the date of the last activity recorded in the specified period.  If a date range is entered, this field will display the final date of the specified range. 

Include Non-Cash Activity
Putting a checkmark here will cause an additional totals line to print on the Summary Page that summarizes all loan activity with the words non-cash, non cash or noncash in the Notes section. You may want to utilize this feature when writing off a bad debt or any other activity where cash has not transferred in or out of your bank account but an amount is entered in the Activity Total box. This will aid in reconciling your cash account and/or editing your month-end general journal entry.

Things You Should Know
  • This report may be produced as often as desired with no consequence to the database. 
  • Each time an activity is entered through the program, an “Activity Period” is required.  If there is an activity that you feel should be included in the report but does not appear, the most likely reason is that it was recorded in another Activity Period. Should you find an activity entered into an incorrect Activity Period, you may correct this by selecting Tools, Change Activity Period. 
  • Activity dates do not always correspond to Activity Period.  An example would be a payment that was received in March, 2009 but not recorded until April, 2009.  The decision as to whether to record in period 03/09 or 04/09 is yours.  It is recommended it be recorded in the period corresponding to the date it was deposited.  This allows the Activity Report to be a useful tool when doing bank reconciliations. 
  • Although a date range is optional, it is strongly advised that you select “All” dates when preparing a month-end report.  This will allow the program to include all activity within the activity period regardless of activity date. 
  • It is also advised the month-end report include “All” funds.