MAGS | Municipal Administration and Geo-Spatial Solutions

MAGS is the product of over 20 years of accounting and budget experience combined with every function of municipal administration into one comprehensive package. MAGS is an Internet based package designed to meet the needs and budget of any size town hall or municipality. This product integrates municipal administration with mapping capabilities, fund accounting, personnel management, and payroll services to allow a municipality to govern more efficiently, effectively, function more independently, reduce the number of services currently being outsourced, and better service the residents of their community. MAGS will also demonstrate significant cost reductions creating budgetary surplus for the municipality to reinvest back into the community in any manner they choose.

Administration
Fund Accounting
Personnel Management
Payroll Services

The Municipal Administration module is designed to manage and organize detailed information for various departments within a municipality. The module maintains property data, issuing and tracking of permits, licenses, applications, planned growth details, images, documents, maps, generates and tracks inspections, and more. The Municipal Administration module is customizable to meet the needs and budget of any size town hall or municipality.

Functions of the Municipal Administration module are:

Administration
Registration & Permits
Water & Sewer
Permit Tracking
Fixed Asset
Taxation
Trash | Recycling
Benefits

Customize and maintain your entire master data module.
Demographically define the municipality’s zones.
Define various categories of personal and real estate properties.
Categorize various real estate taxes.
Define licensing and permit rates.
Define parameters that are used to calculate real estate taxes like millage rate, penalty, and interest percentage.
Define parameters that are used to calculate water/sewer billing amounts.
Define all types of Inspection Codes and sub-codes and index them numerically.
Create and manage users of the product and assign their accessibility levels.
Define the assessment values of properties.

View the product from a citizen centric perspective e.g. enter, process, and find all the entity information that are related to that particular record (i.e. personal & real estate property, fishing licenses, vehicle licenses, permits and registration).
Maintain all citizen centric data in an organized manner.
Collect all one time license, permit, and registration fees with a few clicks of the mouse.
Provide citizens with prompt service to obtain licenses, permits, and registrations.
Allows citizens to complete online forms to apply for services, permits, licenses, etc.

Allows citizens to register for water and sewer online.
Register water and sewer for a single unit or multiple units building.
Record water and sewer use for each building unit of the township on a periodic basis.
Collect and store meter history.
Generate and collect bills for water/sewer use.

Inspector can enter data into the system from out in the field.
Allows an Inspector to follow a permit from beginning to end.
Pass/fail certificates can be printed online.
Update, review, and inspect entries chronologically.
Inspection reports will help authorities in crime prevention, code enforcement, neighborhood improvement, etc.

Electrical, Gas, Mechanical, Plumbing, Fire Protection, Building, Driveway, Planning, Sewage, etc. allowed by the system.
Print customized permits (i.e. Building, Moving, etc.) as needed.
Allow citizens to register and pay for permits online.
Track and maintain a permit from beginning to end.
Inspections may be associated to any permit, parcel, or violation record.
Generate and print a permit bill.
System tracks all violations associated with a permit.

Generate all tax bills as applicable to comply with local tax laws.
System calculates various taxes and generates bills and reports.
Tax collection is departmentalized and simple.
Post directly to the Fund Accounting Module.
Print Customer Invoicing.
Print Past Due notices.
Generate Billing Reports, Payment Register, Penalty Reports, Past Due Notices, Accounting Transactions, and History Reports.
Allows citizens to pay their taxes online.
Plan review and information requested records can be associated to any permit.

Allows citizens to register and pay for Trash and Recycling online.
Trash and Recycling billing.
Customize billing rates for these services.
Record landlord information.
Update previous records.
Post directly to the Accounting Module.
Print Customer Invoicing.
Print Past Due Notices.
Generate Billing Reports, Payment Register, Penalty Reports, Past Due Notices, Accounting Transactions, and History Reports.

Citizens, businesses and the voluntary and community sector benefit from better regulation, reduced paperwork, and lowered costs from a leaner, modern, more effective public sector.
Public servants have better tools to undertake their jobs, and the opportunity to provide better service as a result.
Policy makers will be better able to achieve intended outcomes in practice.
Managers are able to free resources from the back office to the front-line.
Citizens feel more engaged with the processes of democratic government.

Fund Accounting is the method of segregating resources into funds to identify the sources of funds and the use of those funds. The Fund Accounting module segregates these funds to control and monitor them with the objective of: demonstrating accountability and stewardship, determining the financial condition, planning and budgeting, evaluating organizational/managerial performance, and determining/forecasting cash flow. This module unites accounting, budgeting and reporting tools with an impeccable audit trail with a singular goal: eliminating the school district’s financial management pressures.

Fund/Budget Accounting
Accounts Payable
Accounts Receivable
General Ledger
Fixed Asset Module (GASB34)
Benefits

Enforcing the standards of GAAP, GASB34, FASB, and the Federal Handbook II.
Create and manage a flexible Chart of Accounts per your requirements to allow analysis of data at multiple levels.
Allows for use of commonly used segment names (i.e. Fund, Balance Sheet, Revenue, Program, Project, Function, Sub-Function, Object and Location).
Chart of Accounts, built from the applicable segment combinations:
- Add/Edit Expense Budget
- Add/Edit Revenue Budget
- Budget Adjustment, interim mid-year
- Line Item Transfers, interim mid-year
Powerful Report Generator to show:
- PO Encumbrance
- Invoice Accruals
- Disbursements on one account or range of accounts.
- Show sub-totals by group or by combination of subgroups.
- Segment lengths that are flexible.

Manage Vendors, Purchase Orders, Invoice Processing, Checks Processing and Cash Disbursement Journal.
1099 Vendors
1099 report includes calendar year data covering overlapping fiscal years.
Optional - PO Automatic Numbering
Full integrity maintained with Encumbrance and Accrual. Automatic adjustments to the budget done if noted variance in payment during Invoicing, leaving the PO documentation AS IS. We are writing the INDUSTRY STANDARD in liquidating, managing, and keeping a CLEAN TRACK of the variance between the PO and Invoice.
System handles partial payments at agreed price or a variant, seamlessly.
Quantity driven system that shows how much was ordered, how much was delivered, and what is remaining in the account.
Voided checks handled with secure date sensitivity.
Credit Memo
Complete dossier of all cash disbursed in the system by checks.
Cash payments on Balance Sheet accounts under PO, if necessary.

Identify and manage revenue sources.
Create Accounts Receivable at the beginning of the year allocating estimated
Budgeted Revenue.
Record Cash Receipts as they occur for refunds against expended money.
Identify revenue sources.
Track Revenue Receipts against A/R bills.
Track Revenue Receipts without bills.
Track Revenue Receipts as refunds.
Revenue Receipts Journal
Revenue Sources are separated by group (i.e. Federal, State, and Local).
Anticipated Revenues accrued through bills as Accounts Receivable.
Complete a dossier of all cash receipts in the system, including cash movement on the Balance Sheet, accounts from investments, CD’s, FICA reimbursement, etc.

Adjusting Journal, General Ledger, Balance Sheet, Trial Balance, and Board Secretary’s Report.
General Ledger details by transaction type for the entire year or any date range.
PO transactions are accumulated as Encumbrance on the Balance Sheet.
Invoice Transactions are accumulated from Accounts Payable.
Budget Transactions for Expense Appropriation.
Budget Transactions for Estimated Revenue.
Billing Transactions for Accounts Receivables.
Check Printing - Cash
Manual Check - Cash
Cash Receipts - Cash
General Ledger Detail for each account between dates.
General Ledger Summary for each account between dates.
Trial Balance - Total Debit, Credit, and Net.

Tracks all Fixed Assets: Tracking Code, Location, Asset Tag, and Value at Installation.
Depreciation - life in years kept as data with the asset value appearing on the balance sheet.
Marking on PO’s designating a Fixed Asset.
Invoice indicates item as an asset triggering management action.
Allows asset detail data entry as a batch for asset move tickets.
Print Bar Code for Asset Tag.
Print short random list for Monthly/Quarterly Inventory Cycle Count.
Inventory write off.
Accumulated Depreciation

Multi-user access.
Access this module over the Internet via a secure VPN allowing you to work from anywhere, anytime.
Manages an unlimited number of funds.
An intuitive navigation interface makes the Fund Accounting module the school district accounting solution that's easy to learn and use.
Application tasks and reports are grouped by accounting function, including easy-to-understand workflow diagrams and checklists.
Customize your Fund Accounting module to fit your work habits and your mission, not the other way around.
SQL-driven database in combination with the object/relational persistence and query service technology
Easily create custom reports to your exact specifications.

The Personnel Management module is a flexible personnel management tool for school districts. Our solution gives you an easy way to gather, organize and manage information about all employees in the school district. For the database novice our intuitive navigation interface and ready-to-use personnel management solutions make it easy to set up and use.

Features
Benefits

Maintain personal and demographic information.
Maintain attendance history.
Maintain contract information.
Employment information.
Emergency information.
Built on the Microsoft® SQL database.
Security levels can be changed at any time to allow access to users.
Multiple accesses allow authorized managers to update and audit employee files.
Miscellaneous Information/User defined fields.
Absence Codes/Types and Day Fractions
Employee/Contract Groups
Employment, Military, Salary, and Mobility History
Performance reviews.
Certificates, Degrees, and Continuing Education history
Skills and Extra-Curricular Activities
Unlimited contract groups, departments, positions, and locations.
Unlimited emergency contacts, doctor information, and allergies.
Unlimited health and benefit plans and providers.
Unlimited calendars for each contract group.
Unlimited reporting based on any criteria.
Generates polished, professional looking reports quickly and easily.
Provides flawless records in the event of unjust claims or audits.
Steps and Guides
Fully integrated with the Fund Accounting and Payroll modules.
Exports reports easily to Microsoft Word and Microsoft Excel.
Using .Net to provide a central, secure employee database this module can be accessed from at any time from any location through the Internet.

Brings order into employee information you use every day.
Improves your management skills and saves your time and money.
Get organized and get things done.
Stop procrastination and work stress.
Do the right things in the right time.
Increase performance and productivity.
Achieve goals with estimated results.

School districts must know their obligations to the schools and to their employees. We’ve gathered best practices from government management and regulatory compliance and integrated them into one comprehensive module. The Payroll Services module is customized and designed specifically for each school district. The module allows the designated user(s) to schedule, pay, and balance the payroll and helps them easily manage employee information and simplify the entire payroll process from processing to payday. This comprehensive, easy-to-use solution includes all the payroll functionality needed by a school district to process payroll accurately and quickly every time.

Features
Benefits

Allows for an unlimited number of employees.
Direct deposit.
Check creation.
Unlimited number of earning categories.
Unlimited number of deduction categories.
Provides all Federal, State, and Local tax reporting.
Calculates imputed group life insurance.
Multiple checks per employee.
Pension reporting.
Integrated with the Fund Accounting for posting salaries into budgetary accounting.
Integrated with the Personnel Management module.
Generate W-2’s and 1099’s with magnetic media.
Prints W-2s and W-3s on plain paper or forms.
Prints 940 and 941 on plain paper.
Wage reports for month, quarter and year-to-date.
Handles pre-tax deductions, such as 401(k).
Provides complete employee reports, including employee earnings, check register, deductions register, plus many more.
File import/export capabilities.

All payroll frequencies (payroll periods) are allowed: daily, weekly, biweekly, semimonthly, monthly, quarterly, and annually.
Includes state withholding payroll tax calculations for every state as well as Federal Income Tax, Social Security, and Medicare.
Start at any time of the year.
Enter all employee hours in one spreadsheet-style window.
Retain hours for future payrolls.
Easily modify check numbers or void checks.
Handles after-the-fact payrolls.
Employees can be exempt from taxes and you can withhold additional taxes if necessary.