Difference between revisions of "Monthly Comparison Report"

From EDgearWiki
Jump to navigationJump to search
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
__NOTOC__
 
'''This report will provide a spreadsheet that shows the beginning balance for the fiscal year, the monthly ending balances through the selected date range, and the ending balance as of the end date.'''
 
'''This report will provide a spreadsheet that shows the beginning balance for the fiscal year, the monthly ending balances through the selected date range, and the ending balance as of the end date.'''
  
==Menu==
+
==Menu Location==
  
[[File:monthlycommenu.png]]
+
'''Funds > Lists > Monthly Comparison Report'''
 
 
On the left navigation panel, select '''Funds > Lists > Monthly Comparison Report'''.
 
  
 
==Setup Options==
 
==Setup Options==
Line 51: Line 50:
 
[[Standard Print Options | '''Print''']] - This will allow the user to print the report.
 
[[Standard Print Options | '''Print''']] - This will allow the user to print the report.
 
 
'''Export''' -  
+
'''Export''' - Gives the user the option to print or create CSV or XLS formats.
  
 
'''Help''' - Click to view written instructions and/or videos.
 
'''Help''' - Click to view written instructions and/or videos.
 +
  
  

Latest revision as of 10:43, 20 July 2023

This report will provide a spreadsheet that shows the beginning balance for the fiscal year, the monthly ending balances through the selected date range, and the ending balance as of the end date.

Menu Location

Funds > Lists > Monthly Comparison Report

Setup Options

Monthlycomsetup2.png

District - Default value is based on the user's security settings. The user will be limited to their district only.

School - Default value is based on the user's security settings. If the user is assigned to a school, the school default value will be their school site code. The user will not be able to change this value. If the user is a supervisor or

Fiscal Start Date - This date should be wither January 1st or July 1st.

Category - Click in the box and select a category.

Account - Click in the box and select an account

From Acct - Type an account number that will filter on all accounts greater than or equal to this number.

To Acct - Type an account number that will filter on all accounts less than or equal to this number.

OK - Click to continue.

Main

Monthlycommain.png

Column Headers

Account - Account number.

Account Name - Account name.

Beg Bal - Beginning balance for new Fiscal year for any account not closed during the close-out procedure.

July to June - Totals for each month.

Ending Bal - Ending balance.

Bottom

Monthlycombottom2.png

Setup - Click to go back to the Setup box.

Print - This will allow the user to print the report.

Export - Gives the user the option to print or create CSV or XLS formats.

Help - Click to view written instructions and/or videos.



Funds Main Page


JCampus Main Page

Retrieved from EDgear Wiki