MRAL Alabama Qtly Unemployment & Annual W-2 Electronic Reporting 

Download Links:

To Order:

MRAL Alabama Quarterly Electronic Reporting allows the user to generate media as required by the state of Alabama. This report includes the following data: Employee Name, Social Security Number, Employer Account Number, Reporting Period, and State Quarter Wages Subject to Unemployment Insurance. It also generates a summary report.

"Tax preparers in the State of Alabama filing on behalf of 100 or more employers are required by regulation to file their quarterly contribution returns for unemployment insurance on electronic media Preparers submitting contribution data electronically for the first times are required to submit a test tape or diskettes (call 410-767-2885 for mailing the test media)."

Also creates the annual W-2 electronic media report.

This enhancement for Sage MAS 90 Magnetic Media allows the user to:

Generate media as required by the State of Alabama. This report includes the following data:

• Employee Name
• Social Security Number
• Employer Account Number (EIN)
• Reporting Period
• State Quarter Wages Subject to Unemployment Insurance

Generate a Media summary report, after the creation of the magnetic media file, that reports the information needed to complete the Media Transmittal form that must be submitted with the media.

FAQ

Format Being Used For Quarterly Unemployment Reporting

The file is generated in the Alabama ICESA Wage Record format. This is a 80-character per line (plus CR, LF) format.

The name of the file produced for the quarterly unemployment wage report is “ALAWAGES”. This file is located in the company’s Payroll data folder.

Format Being Used For W-2

The file is generated in the Alabama MMREF Wage Record format. This is a 512-character per line (plus CR, LF) format.

The name of the file produced for the quarterly unemployment wage report is “W2WAGES”. This file is located in the company’s Payroll data folder.

Why Unemployment Wages Might be Reported Incorrectly

The most common reason Unemployment Wages for a particular employee are reported incorrectly is that a deduction was not made because an Earnings Code was not set up correctly so a deduction would be made in Unemployment Wages.

The program reports exactly what is contained in Qtd Wages Subject To Unemployment field the Employee’s P/R Employee Tax Summary File record (for technical readers, this is the PR3[9] numeric).

To correct Unemployment Wages before reporting, use the Fix button in Employee Maintenance (click the Tax Summary button and then the Fix button). Supervisor rights are required to access the Fix button.

The Summary Totals are Different Than Another Report

Note that the specification for the magnetic media report differs from the specification for a printed report. For example, employees with negative numbers for wages or zero wages cannot be reported in the magnetic media file according to the specification.

The Quarterly Tax Summary Report may not match the Summary Report due to either the Limit not being applied, deduction codes for Cafeteria plan, or non-taxable wages not being set up properly.

Making Archival Backups of Payroll Data

Sage MAS 90 does not retain summary data from previous quarters. It is good practice to make a permanent copy of a quarter’s Payroll data before running Period End Processing. When Period End Processing is run, the total buckets are cleared.

To report from a previous quarter, make a copy of the current Payroll data, restore the Payroll data from the desired quarter, make a report and then restore the current quarter Payroll data.