MTD Transaction Report
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
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
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
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.
