Synchronize data between Millennium 3™ and SwipeClock™ TimeWorks/TimeWorksPlus...View User Guide
The M3 To SwipeClock Interface allows the payroll service bureau and its clients to reduce double data entry by synchronizing data between the systems, both on a schedule and on demand from within the Millennium 3™ software itself. The interface also drastically reduces the time it takes for compiling billing information by importing the number of active employees per company from SwipeClock™ and referencing that information from a billing product SQL in Millennium™.
Data Transferred From SwipeClock™ to Millennium™
Updated Employee Information
Time Import File
Billing Data (Active Employees by Company per Month)
Data Transferred from Millennium™ to SwipeClock™
Updated Employee Information
Accrual Balances (FEATURE COMING SOON!)
Audit the data in your payroll database and payrolls BEFORE they are processed. Reduce your correction payroll runs by up to 80%!View User Guide
The Payroll Audit System assists the payroll service bureau in "scrubbing" your payroll data before and after payroll processing. This helps reduce the need for correction payroll runs, tax problems and a variety of other issues. The system consists of two main parts: Scheduled Audits and Pre-Process Audits.
The majority of the Audit System management is accessed via a separate management console. Add/edit/remove audits. View reports on audit status, who is getting which audits and when, etc. Archive/purge log data.
The Scheduled Audits are SQL queries that are run against the payroll database and the results emailed to specified recipients on a customizable schedule. These audits are completely customizable to allow for an infinite amount of possibilities. (Example: List companies with an incorrect tax setup.) Run audits daily, weekly, monthly, quarterly, yearly or even all throughout the business day. Any of the audits in the system can also be run manually (ad-hoc). The audits generate HTML tabular formatted emails to desired recipients and are easy to read and appealing to the eye. Audits may be set to be formatted as "alerts", using bold and noticeable colors.
UNLIMITED NUMBER OF AUDITS
The system comes preconfigured with approximately 100 different audits, ranging from invalid employee birthdates to missing taxes on W2 employees. These reports can help fulfill SAS70 audit requirements.
All of the audits performed by the Audit System are written in standard T-SQL code. Therefore, changes to audit parameters are easily made. For those experienced in SQL, fully custom audits can be written to analyze data in any of the payroll database tables.
The Pre-Process Audit portion of the system provides a customized “Payroll Submit” screen in the payroll system which executes special SQL queries against the payroll. When users local to the service bureau (CSR's, Citrix users, etc.) enter the submit screen, the system automatically audits the payroll based on parameters that you define. (Example: W2 employees missing taxes, paycheck is over a certain amount threshold.) Preprocess audits can be configured to be mandatory or approvable. For mandatory audits, the item must be corrected before they are allowed to submit the payroll. For approvable audits they are given an “Approve” button which logs the user and time that they have approved it. Approvable audits can be assigned roles from the payroll system to allow only users in those roles to approve those audits. For remote clients, you can run the audits on the payroll before it is processed by using the customized Job Requests screen. If any audits fail, the payroll can be opened, corrected and re-submitted. This process will greatly reduce your correction payroll runs and tax department issues at quarter and year end.
Customize an employee import from a client’s data file...View User Guide
The Employee Import Utility allows you to import new employees, update existing employees and import/update employee information in the payroll database from customizable, preconfigured Excel template files. Virtually any employee data can be imported/updated, from demographics to taxes to HR tables. Multiple levels of validation occur before an import can take place. (Example: When importing deductions, earnings and taxes the utility verifies that the items exist on the company level before allowing the import to proceed.) This helps prevent "bad" data from being imported into the payroll system. The utility can also be used for quick manual batch entry of employee data instead of using the new hire screen in the payroll system.
Import company setup items from a client’s data file...View User Guide
The Company Import Utility allows you to convert a new company, import new or updateexisting company information in the payroll database from customizable, preconfigured Excel template files. Multiple levels of data validation occur before the import can take place. (Example: When importing deductions, the utility verifies that dependent items, such as the agencies or calc codes, exist on the company before allowing the import to proceed.) This helps prevent "bad" data from being imported into the payroll system. The utility can also be used for quick manual batch entry of company data instead of using the screens in the payroll system.
Convert time files to import into payroll...View User Guide
The Time File Converter converts export files from various time and attendance systems to a format readable by the Millennium 3™ payroll software. Current formats available are (others available for custom programming fee):
Generic Excel Spreadsheet
2Touch POS ADP eTime
Aloha POS (Generic)
Aloha POS 5.x.x
Aloha POS 6.x.x
Micros POS (Generic)
Sublive (Subway restaurants)
YUM! Foods (KFC / Taco Bell / Pizza Hut)
Automatically import newly on-boarded employees into Millennium 3™...View User Guide
The Efficient Forms™ to Millennium 3™ Interface imports new employees from XML files delivered through Efficient Form’s™ EFConnect service. EFConnect is a Windows Service application that can be obtained from Efficient Forms™.
Sync data between Shugo™ and Millennium 3™...View User Guide
The Shugo™ to Millennium 3™ Interface allows for manual and/or automated data transfer between Shugo™ and Millennium 3™. The interface also facilitates company setup, employee new hires and employee changes in Shugo™ for data pulled directly from Millennium™.
Data Transferred from Millennium™ to Shugo™
Company (If the company does not exist in Shugo™, it will be created.)
Company Payroll Schedule
Company Organization Groups
Company PTO Buckets
Employees (If the employee does not exist in Shugo™, it will be created.)
Employee PTO Balances
Data Transferred From Shugo™ to Millennium™
Time Import File
Automatically export W2 data and upload/import to Intuit TurboTax™...
When your company participates, you will offer a benefit that over one million employers offer their employees: the ability to automatically import their W2 into the tax filing process using TurboTax™. You will also be offering an ancillary service that competes with large payroll providers such as ADP™, which have been offering the TurboTax™ W2 import program for years.
Your service bureau’s benefits
Income earned for each successful W2 import – TurboTax™ pays you!
No cost to implement and little resources required
Set it and forget it – once the program is installed you have nothing more to do
Compete with large payroll providers (e.g. ADP™)
Support green friendly (paperless) solutions
Your clients’ benefits
A free and easy employee benefit from the payroll/HR department
Extend the value of employee self-service (ESS)
Increase the accuracy of W-2 data entry and ease of tax return prep for employees
Export W2s to PDF...
The W2 Export utility allows you to export all W2s for a selected company and specified tax year to a designated folder on your computer or network.
Verify your clients' FITW filing statuses...
The IRS Filing Status Utility allows you to compare the filing status download file provided by the IRS to the status in the Millennium™ database. A report is produced showing any discrepancies.
Make payroll schedule management easier...
The Interactive Payroll Schedule Screen replaces the default payroll schedule screen in Millennium 3™. No more printing schedule reports! The screen shows unprocessed and processed payrolls for the given date range. Numerous sort and filter options make it easy to customize the view, per user. Easily and quickly see who has processed and who hasn't. Update payroll notes, change the scheduled process date, mark a payroll as "received", all in one place!
See all pertinent company data in one place...
The Company Dashboard Screen replaces the default company and company maintenance screens in Millennium 3™. The screen provides quick access to the most accessed data for a company. Need to know if the company is on direct deposit and how many employees use it? Done! Want to see active employee count, active company services, current check date and payroll status all in one place? Bingo!
Compare the contents of your MAG files to the payroll database...
The MAG File Analyzer compares the contents of MAG (Magnetic Media) files generated from the payroll system to what the payroll database actually contains. It looks for discrepancies in totals reported on the file as well as the companies expected to exist on the file. Currently the analyzer will process the following MAG file types: W2, Oklahoma SUI, Kansas SUI, New Mexico SUI, Tennessee SUI and Texas SUI.
Interpret Social Security number verification return files from the SSA...
This is useful if your service bureau is verifying Social Security numbers for your clients. Dump your SSA file to a folder and have an automated script parse it and send out emails to your clients. No more manual effort! It reads the SSA return file and generates a customizable email from the payroll database to notify your clients of possible SSN errors for their employees.
Change the due date of a tax deposit...View User Guide
When a secondary payroll is processed that reaches the 100K liability and is created with the incorrect due date, simply put the tax deposits on hold, open the Tax Checks utility and change the due dates to modify amounts on the tax deposit. Also, allows for modifying amounts on agency checks.
Change a calendar date or batch details...View User Guide
This utility will allow you to pull in an existing calendar date and change it to a new date without deleting and adding new calendar dates in payroll. The helps prevent unscheduled payrolls. It also allows you to modify pay period dates on the associated batches at the same time.
- Payroll Audit System
- M3 To SwipeClock Interface™
- Custom M3 Screens
- Employee Import
- Time File Converter