Difference between revisions of "MTD Transaction Report"

From EDgearWiki
Jump to navigationJump to search
 
(20 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
__NOTOC__
 
'''These reports are part of the documents that are printed each month to submit to the district office for review. The ending balance column MUST match the YTD ending balance column.'''
 
'''These reports are part of the documents that are printed each month to submit to the district office for review. The ending balance column MUST match the YTD ending balance column.'''
  
−
#Select '''Funds/Lists/MTD Transaction Report''' from the list of JCampus modules on the left of the screen.
+
==Menu Location==
−
#In the setup box verify the '''Fiscal Date'''. It should be in the form '''Jul 01 20##'''.
 
−
#Select '''Month to Show'''.
 
−
#NOTE: Use the Account field if you want to print information for fewer than all accounts.
 
−
#Select the following:
 
−
#*Accounts--All or Active: '''Active''' will include only those accounts that have a beginning balance record and/or at least one transaction during the current fiscal year. '''All''' will include only those accounts that have a beginning balance record with or without any activity during the year.
 
−
#*Report Type--Detail or Summary: '''Detail''' will show every transaction for the month. '''Summary''' will show monthly beginning balance with summary income and summary expenses for the month with the end-of-month balance.
 
−
#*Show--Comment or Vendor: These options are available for '''Report Type--Detail''' only. You have the option of include either both '''Comment''' and the '''Vendor''' name from the transaction or you can include only one of these.
 
−
#Click '''Ok'''.
 
−
#The display will appear on the screen.
 
−
#Use the print instructions below to print a copy of the report to send to the district office.
 
−
#Print a second copy to file with other monthly documents.
 
  
 +
'''Funds > Lists > MTD Transaction Report'''
  
−
'''To Print this Report'''
+
==Setup Options==
−
#Click the '''Print''' button at the bottom of the screen.
+
 
−
#A popup will appear with a set of document print options--PDF, XLS, CSV, HTML.  
+
[[File:MTDtransrepsetup.png]]
−
#The default print option will be '''PDF'''.
+
 
−
#Click the print button on this popup and a print preview window will appear.  
+
'''District''' - Default value is based on the user's security settings. The user will be limited to their district only.
−
#'''To get the print icon''' on this window, hover the mouse in the bottom right area of the preview. A grey rectangle will appear with several icons.  
+
 
−
#Click the print icon at the right end of this rectangle. Another print preview will appear.
+
'''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.
−
#Click the print button at the top left to print the report. Close the print preview.
+
 
 +
'''Fiscal Start Date''' - This date should be January 1st or July 1st.  For school finance it should be July 1st.
 +
 
 +
'''Month to Show''' - Select Month to Show.
 +
 
 +
''' Account''' - If the user wants to print information for fewer than all accounts.
 +
 
 +
'''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.
 +
 +
'''Accounts''':
 +
 
 +
'''All''' will include only those accounts that have a beginning balance record with or without any activity during the year.
 +
 
 +
'''Active''' will include only those accounts that have a beginning balance record and/or at least one transaction during the current fiscal year.
 +
 
 +
'''Report Type''':
 +
 
 +
'''Detail''' will show every transaction for the month.  
 +
 
 +
'''Summary''' will show monthly beginning balance with summary income and summary expenses for the month with the end-of-month balance.
 +
 
 +
'''Show''':
 +
 
 +
'''Both''', '''Comment''' and the '''Vendor''' name from the transaction or you can include only one of these.
 +
 
 +
'''Page Break''':
 +
 
 +
'''Yes''' to print each account information on a separate page.
 +
 
 +
'''No''' to print a continuous report without page breaks between accounts.
 +
 
 +
'''Ok''' - Click to continue.
 +
 
 +
To find definitions for standard setup values, follow this link: [[Standard Setup Options]].
 +
 
 +
==Main==
 +
 
 +
[[File:MTDtransrepmain.png]]
 +
 
 +
===Column Headers===
 +
 
 +
'''Vendor''' - Vendor number.
 +
 
 +
'''Vendor Name''' - Vendor name.
 +
 
 +
'''Account''' - Account number.
 +
 
 +
'''Account Name''' - Account name.
 +
 
 +
'''Date''' - Post date of transaction.
 +
 
 +
'''Rec/Vouch''' - Reciept number or voucher number.
 +
 
 +
'''Ck Number''' - Check number (based on the transaction type values will be the check number, ADJ, INT, DEP, or TRA).
 +
 
 +
'''Beg Bal''' - Beginning balance.
 +
 
 +
'''Rev Adj''' - Monthly revenue adjustments (Code 21 & 40).
 +
 
 +
'''Revenue''' - Monthly revenue deposits (Code 30, 31, 32, 34).
 +
 
 +
'''Exp Adj''' - Monthly expenses adjustment (Code 24, 50, 51).
 +
 
 +
'''Expense''' - Monthly expenses espenses (Code 11, 12, 13).
 +
 
 +
'''Total''' - Net for the month's revenue and expenses.
 +
 
 +
'''End Bal''' - Ending balance.
 +
 
 +
To find definitions of commonly used column headers, follow this link: [[Common Column Headers]].
 +
 
 +
==Bottom==
 +
 
 +
[[File:MTDtransrepbottom.png]]
 +
 
 +
'''Setup''' - Click to go back to the Setup box.
 +
 
 +
[[Standard Print Options | '''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|'''Funds''' Main Page]]
 +
 
 +
----
 +
[[WebPams|'''JCampus''' Main Page]]

Latest revision as of 11:44, 20 July 2023

These reports are part of the documents that are printed each month to submit to the district office for review. The ending balance column MUST match the YTD ending balance column.

Menu Location

Funds > Lists > MTD Transaction Report

Setup Options

MTDtransrepsetup.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.

Fiscal Start Date - This date should be January 1st or July 1st. For school finance it should be July 1st.

Month to Show - Select Month to Show.

Account - If the user wants to print information for fewer than all accounts.

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.

Accounts:

All will include only those accounts that have a beginning balance record with or without any activity during the year.

Active will include only those accounts that have a beginning balance record and/or at least one transaction during the current fiscal year.

Report Type:

Detail will show every transaction for the month.

Summary will show monthly beginning balance with summary income and summary expenses for the month with the end-of-month balance.

Show:

Both, Comment and the Vendor name from the transaction or you can include only one of these.

Page Break:

Yes to print each account information on a separate page.

No to print a continuous report without page breaks between accounts.

Ok - Click to continue.

To find definitions for standard setup values, follow this link: Standard Setup Options.

Main

MTDtransrepmain.png

Column Headers

Vendor - Vendor number.

Vendor Name - Vendor name.

Account - Account number.

Account Name - Account name.

Date - Post date of transaction.

Rec/Vouch - Reciept number or voucher number.

Ck Number - Check number (based on the transaction type values will be the check number, ADJ, INT, DEP, or TRA).

Beg Bal - Beginning balance.

Rev Adj - Monthly revenue adjustments (Code 21 & 40).

Revenue - Monthly revenue deposits (Code 30, 31, 32, 34).

Exp Adj - Monthly expenses adjustment (Code 24, 50, 51).

Expense - Monthly expenses espenses (Code 11, 12, 13).

Total - Net for the month's revenue and expenses.

End Bal - Ending balance.

To find definitions of commonly used column headers, follow this link: Common Column Headers.

Bottom

MTDtransrepbottom.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