Consolidated Reporting


Before running any Consolidated Reports, be sure that the fiscal year start date on the District Information page is correct


Receipts and Disbursements – Alphabetical list of each school and its corresponding MTD and YTD financial data as of the ending date entered.  The total of all the schools is printed at the bottom.


Report Designer – Custom report designer offering options to create transactional reports and account reports in a myriad of combinations.  All schools are included with their accounts and various financial reporting options to be included on each report.  Reports can be saved by clicking the “Create Saved Report” button allowing the same parameters to be run at another time.


Returned Checks – A consolidated listing of all returned check entries by school with school totals and district total.  Run for a specified ending date with or without repayment (Y) entries.


Outstanding Checks – A consolidated listing of all outstanding checks by schools with totals and district totals.  Run for a specified number of days outstanding.  A school’s bank reconciliation must be completed for this list to be complete.


Void Checks – A consolidated listing of all voided checks by school with totals and district totals.  Run for a specified start and end date.


Deposits in Transit – A consolidated listing of all deposits in transit by schools with totals and district totals.  Run for a specified reconciliation date.  A school’s bank reconciliation must be completed for this list to be complete.


Sales Tax (NC ONLY) – Provides the total, by county, of sales tax paid during a specified date range. 


Accounts


  • Account History – Allows you to choose a specific district-wide account and print the beginning year balance, ending balance, and year-to-date receipt, disbursement, transfer, and encumbrance totals for each school.


  • District Wide Accounts – Prints a listing of the district wide chart of accounts.


  • Consolidated Negative Balances – A list of all accounts with negative balances as of the date entered sorted by school.


  • Consolidated Trial Balance – Trial Balance Reports for all schools in one report


  • Consolidated Month to Date – A for all schools listing MTD Receipts and MTD Disbursements for each account at each school.  This report can be printed or exported to Excel.  


  • Consolidated Account Listing – Compiles a list of all account numbers at all schools.


Vendors


  • 1099 - Combines all the payments made from the individual schools to each vendor (flagged as 1099) for the date range entered.  If the 1099 vendors are not setup as “district-wide”, the schools may enter a vendor’s name differently.  1099 records are consolidated by social security number.   Data from the “CO Vendor #” field now prints on this report, if present.


  • District Vendor History – Prints transactional history for any district-wide vendor by Vendor or by Vendor Code.


  • Print 1099-MISC – Prints on actual 1099 forms if central office upload is not needed.


  • 1099 Export File – Uploads 1099 data to the central office host system. 


  • District One-Time Vendor – A combined listing, by school, of all one-time vendors.


(Examples of these reports are found at the end of this guide.)



State Reports – Required year-end reports for Tennessee, Georgia, West Virginia, and Maryland only.