The following tools can be helpful for ACA purposes. While some of these tools come standard with Avionté, others are available as part of the ACA Package. For more information on the ACA Package, contact your Avionté Representative.
CHAPTERS
Imports and Exports
Standard Reports
Auditing Tools
Historical ACA Package Reports
ACA Package Reports
| Name | Description | Parameters | Fields | Why is this report useful? |
| 1095C Report | Form 1095C is the Employer-Provided Health Insurance Offer and Coverage Insurance Form. This form is required to be distributed to employees of an ALE member who is full-time for one or more months during the calendar year. | SSN, Form Batch ID, Branch, Primary Order By (Last Name, First Name, SSN), Print Start From, Print Start To, Show ONLY Last 4 SSN (True, False) | Populated Federal 1095C Forms. |
This report makes printing and sending 1095C Forms easy! It is available with the Avionté ACA package. |
| Get employee 1095-C info | Get 1095-C fields that will appear on the 1095-C form. | Form Batch ID, SSN | All12MonthsColumnEmployeeShare, All12MonthsColumnSeries1Code, All12MonthsColumnSeries2Code, City, Electronic1095C, FirstName, FullName, IsCorrected,IsSelfInsuredCoverageOffered, IsVoided, LastName, MiddleName, PlanStartMonth, SSN, State, Street, ZipCode, JanuaryColumnEmployeeShare, JanuaryColumnSeries1Code, JanuaryColumnSeries2Code, FebruaryColumnEmployeeShare, FebruaryColumnSeries1Code, FebruaryColumnSeries2Code, MarchColumnEmployeeShare, MarchColumnSeries1Code, MarchColumnSeries2Code, AprilColumnEmployeeShare, AprilColumnSeries1Code, AprilColumnSeries2Code, MayColumnEmployeeShare, MayColumnSeries1Code, MayColumnSeries2Code, JuneColumnEmployeeShare, JuneColumnSeries1Code, JuneColumnSeries2Code, JulyColumnEmployeeShare, JulyColumnSeries1Code, JulyColumnSeries2Code, AugustColumnEmployeeShare, AugustColumnSeries1Code, AugustColumnSeries2Code,SeptemberColumnEmployeeShare, SeptemberColumnSeries1Code, SeptemberColumnSeries2Code, OctoberColumnEmployeeShare, OctoberColumnSeries1Code,OctoberColumnSeries2Code, NovemberColumnEmployeeShare, NovemberColumnSeries1Code, NovemberColumnSeries2Code, DecemberColumnEmployeeShare, DecemberColumnSeries1Code, DecemberColumnSeries2Code |
|
| ACA Insert Employee 1095-C Overrides |
|
Imports and Exports
These imports and exports can be helpful for ACA purposes.
| Name | Description | Parameters | Fields | Who uses this report? | Why is this report useful? |
|
ACA Import |
Pulls employee deductions into the system for 1094/1095 reporting. | Supplier, As of Date, Measurement Period | Mapping Group, Processing Method, File, Year ID, Check for Duplicate SSN | Back Office | The Standard Benefit Import is a standard report that includes all employee deductions during 1094/1095 reporting. |
| Essential Staff Care (ESC) MEC Benefit Import* | Imports data for employees who use the Essential StaffCARE Minimum Essential Coverage (ESC MEC). | Supplier, As of Date, Measurement Period | Batch Name, Description, Batch Status, Mapping Group, Processing method, File | Back Office | This import marks employees who use the ESC MEC plan. |
|
Essential StaffCare (ESC) FI-MVP Bronze Plan Export* |
Exports data for employees who use the Essential StaffCARE (ESC) FI-MVP Bronze. | Supplier, As of Date, Measurement Period | Batch Name, Description, Batch Status, Mapping Group, Processing method | Back Office | This export shows the employees who use the ESC FI-MVP Bronze Plan. |
|
ACA Export - IBF* |
Exports data for employees who use IBF. | Supplier, As of Date, Measurement Period | Batch Name, Description, Batch Status, Mapping Group, Processing method | Back Office | This export shows the employees who use IBF. |
|
ACA Export - Nelco* |
Exports data for employees who use Nelco. | Supplier, As of Date, Measurement Period | Batch Name, Description, Batch Status, Mapping Group, Processing method | Back Office | This export shows the employees who use Nelco. |
*Indicates resources deployed at client request. Create a utility ticket in the Support Center to add the selected imports and exports.
Standard Reports
These reports are standard with Avionté and can be helpful for ACA purposes. For more information on other kinds of Reports, see the Standard Reports help article.
| Name | Description | Parameters | Fields | Who uses this report? | Why is this report useful? |
| Cash Requirements | Details liabilities and the amount of cash needed to process payroll | Date Type (Check Date, Accounting Period Date), Group By (Staffing Company, Branch, None), Start Date, End Date, Branch | Employee Earnings, Agency Earnings, Deductions, Tax Liability, Net Pay, Employer Contributions, Worker Compensation, Employer Taxes, Summary. Each of these fields is broken down to specific values. | Back Office | This report is a useful resource for payroll processing or for determining the cost of running the business for a specific time period. |
| Check Register | Shows paycheck information for all employees | Date Type (Check Date, Accounting Period Date), SSN, Start Date, End Date, Branch, Employee Type (All, W2, 1099), Sort By (Employee Name, Check Date) | Employee Name, Check #, Check Date, Gross Amount, Total Taxes, Total Deductions, Net Check, Is DD?. Further broken down: Transaction (Type, Units, Rate, Total Pay), Tax (Tax Name, Taxable Gross, Tax Amount), Deduction (Deduction Type, Amount), Benefit (Type, Amounts, YTD Benefit), Accruals (Plan, Accrual Units, Balance, Depleted Units.) |
Auditing Tools
While some of these reports are standard in Avionté, some are available through the ACA Package. Contact your Avionté Representative for more information.
| Name | Description | Parameters | Fields | Who uses this report? | Why is this report useful? |
| Shows an employee's total hours and ACA Eligibility as well as total wages, benefits, and benefit amounts. |
Start Date, End Date, Date Type, Employer, SSN end with, Show All Measurements, Exclude Non W2 Employees
|
EmployeeID, SSN, FirstName, MiddleName, LastName, Branch, ACAEligibility, EmployeeStatus, OnAssignment, LastCheckDate, DateOfBirth, Gender, Phone, Email, AddressStreet, AddressCity, AddressStateorProvinceCode, AddressCountryCode, AddressPostalCode, EmployerName, EmployerIdentificationNumber, FirstWorkedDate, TerminatedDate, MeasurementType, MeasurementPeriodStartDate, MeasurementPeriodEndDate, MeasurementPeriodTotalHours, MeasurementEligibility, StabilityPeriodStartDate, StabilityPeriodEndDate, MostRecentEligibilityStatusDeclaration, MostRecentOffferedDate, MostRecentOfferedBenefitPackage, MostRecentOfferedStatus | Back Office | This report is useful for tracking healthcare eligibility as well as other benefit participation. It is also a great resource to report data to insurance brokers. | |
| Displays a list of all offers made in the ACA Companion Application. | Start Date, End Date, Date Type, Employer, SSN end with, Show Dependents | EmployeeIDs, SSN, FirstName, MiddleName, LastName, AddressStreet, AddressCity, AddressStateOrProvinceCode, AddressCountryCode, AddressPostalCode, OnAssignment, LastCheckDate, MostRecentEligibilityStatusDeclaration, BenefitPackageName, OfferedByEmployerName, OfferedByEmployerIdentificationNumber, OfferedDate, HealthInsurancePlanName, HealthInsurancePlanProviderName, AcaOfferOfCoverageCode, SafeHarborCode, IsSelfInsured, IncludesSpouse, IncludesDependents, IsMinimumEssentialCoverage, IsMinimumValue, EnrollmentDate, CoverageStartDate, CoverageEndDate, DeclinationStartDate, DeclinationEndDate, DeclinationReason | Benefits Admin, Back Office | Allows users to audit and review all insurance offers entered into the ACA Companion Application for accuracy. | |
| Displays a list of all offers made in the ACA Companion Application. | Start Date, End Date, Date Type, Branch, Benefit Package | EmployerName, SSN, FirstName, MiddleName, LastName, BenefitPackage, OfferedDate, AcceptOrDecline, InsurancePlanOrDeclinationReason, StartDate, EndDate, LastCheckDate, LastAssignmentEndDate, EmployeeIDs, Branches, EmployeeStatuses | Benefits Admin, Back Office | Allows users to audit and review insurance offers entered into the ACA Companion Application for accuracy. | |
| Lists changes to specific tables within the application | Start Date (Audit Date Modified), End Date (Audit Date Modified), User Name, Table name, Column Name | Audit Type, Table Name, Column Name, Old Value, New Value, Date Modified, User Name, User Description | Front Office, Admin | This report lists all changes made to any table along with the value prior to the change, the date the change was made, and the User that made the change. | |
| Details deductions and contributions for each employee | Branch, Date Type (Check Date, Date Entered, Start Date, None), Start Date, End Date, Deduction/Contribution Name | Employee Branch, Employee Status, Employee ID, First Name, Middle Name, Last Name, Deduction/Contribution Type, Deduction/Contribution Name, Amount, Is Fixed Amount, Is Levy, Is Per Hour, Sequence, Percent of Gross, Percent of Net, Agency Name, Agency Address, Agency Reference Number, Deduction DI Percent, Start Date, End Date, Pay Period Limit, Monthly Limit, Yearly Limit, Lifetime Limit, Deduction Amount MTD, Deduction Amount YTD, Deduction Amount LTD, Deduction Balance, Note, Frequency, Deduction/Contribution Supplier, Flag During Payroll, Entered By, Date Entered, Last Check Date, Employee Last Assignment End Date, Deduction Max Percent of Net | Front Office, Back Office | This report gives detailed deduction/contribution information and can be useful when checking employee payroll deductions. | |
|
Employee Log |
Records information specific to the employee such as address, billing information, contact information, etc. | N/A | ACA Eligibility, Accrual Setup, Address, Assignments, Certifications, Contact Method, Contribution Setup, Dates, Deduction Setup, Direct Deposit Setup, Documents, Edocument, Education, Employee, Employment Category, Extra, Interview, Message, Past Jobs, Professional Summary, Requirements, Skills, Tax Setup, Test, Users | Back Office |
This tool records specific information in regards to an employee. |
| Employee Pay History page | Displays all of the payments and other billing associated with past paychecks for a selected employee. | N/A | Branch, Check Date, Check Deliver, Check Number, Date Cleared, Deductions, Direct Deposit, Employer Cont, Gross Pay, Name, Net Amount, See Paycheck, Select, Status, Supplier, Taxes, W2, Year ID, YTD Gross | Back Office |
This tool records all information pertaining to an employee's paycheck history. |
| Employee ACA Eligibility page | Displays if an employee is eligible for ACA. | N/A | No (not eligible), Yes (eligible), Measured Start Date, Measured End Date, Measured Type, Total Hours, Measured Eligibility | Back Office |
This tool allows you to view and edit an employee's ACA eligibility status. |
Historical ACA Package Reports
These reports and advance queries are available through the ACA Package. Contact your Avionté Representative for more information.
| Name | Description | Parameters | Fields | Who uses this report? | Why is this report useful? |
|
1095 C Report |
The IRS version of form 1095C. This is the Employer-Provided Health Insurance Offer and Coverage Insurance Form. This form is required to be distributed to employees of an ALE member who is full-time for one or more months during the calendar year. | SSN, Form Batch ID, Branch, Primary Order By (Last Name, First Name, SSN), Print Start From, Print Start To, Show ONLY Last 4 SSN (True, False), Include Electronic 1095-C (True, False) | Populated Federal 1095C Forms | Back Office | Note: This report version is for 2021 and 2022. |
|
1095 C Report 2020 |
The IRS version of form 1095C. This is the Employer-Provided Health Insurance Offer and Coverage Insurance Form. This form is required to be distributed to employees of an ALE member who is full-time for one or more months during the calendar year. | SSN, Form Batch ID, Branch, Primary Order By (Last Name, First Name, SSN), Print Start From, Print Start To | Populated Federal 1095C Forms | Back Office | Note: This report version is for 2020. |
|
1095 C Report 2019 |
The IRS version of form 1095C. This is the Employer-Provided Health Insurance Offer and Coverage Insurance Form. This form is required to be distributed to employees of an ALE member who is full-time for one or more months during the calendar year. | SSN, Form Batch ID, Branch, Primary Order By (Last Name, First Name, SSN), Print Start From, Print Start To | Populated Federal 1095C Forms | Back Office | Note: This report version is for 2016-2019. |
|
1095 C Report 2015 |
The IRS version of form 1095C. This is the Employer-Provided Health Insurance Offer and Coverage Insurance Form. This form is required to be distributed to employees of an ALE member who is full-time for one or more months during the calendar year. | SSN, Year, Branch, Primary Order By (Last Name, First Name, SSN), Primary Mailing Address (Primary Address, Home Address, W2 Address, Previous Address), Include (All 1095C, Only Corrected 1095C), Sent to the IRS (True, False) | Populated Federal 1095C Forms | Back Office | Note: This report version is for 2015. |
|
1095 C No Instruction Page |
The IRS version of form 1095C - without having to print page two, the instruction page. This is the Employer-Provided Health Insurance Offer and Coverage Insurance Form. This form is required to be distributed to employees of an ALE member who is full-time for one or more months during the calendar year. | SSN, Form Batch ID, Branch, Primary Order By (Last Name, First Name, SSN), Print Start From, Print Start To, Show ONLY Last 4 SSN (True, False), Include Electronic 1095-C (True, False) | Populated Federal 1095C Forms | Back Office | This report makes printing and sending 1095C Forms easy! This version does NOT include the form instructions. Note: This report version is for 2021. |
|
1095 C No Instruction Page 2020 |
The IRS version of form 1095C - without having to print page two, the instruction page. This is the Employer-Provided Health Insurance Offer and Coverage Insurance Form. This form is required to be distributed to employees of an ALE member who is full-time for one or more months during the calendar year. | SSN, Form Batch ID, Branch, Primary Order By (Last Name, First Name, SSN), Print Start From, Print Start To | Populated Federal 1095C Forms | Back Office | This report makes printing and sending 1095C Forms easy! This version does NOT include the form instructions. Note: This report version is for 2020. |
|
1095 C No Instruction Page 2019 |
The IRS version of form 1095C - without having to print page two, the instruction page. This is the Employer-Provided Health Insurance Offer and Coverage Insurance Form. This form is required to be distributed to employees of an ALE member who is full-time for one or more months during the calendar year. | SSN, Form Batch ID, Branch, Primary Order By (Last Name, First Name, SSN), Print Start From, Print Start To | Populated Federal 1095C Forms | Back Office | Note: This report version is for 2016-2019. |
|
Avionte_1095 C Report_Portrait |
This is not the IRS published version, rather an alternative version of the 1095-C that is portrait (not landscape) and on one page. | SSN, Form Batch ID, Branch, Primary Order By (Last Name, First Name, SSN), Print Start From, Print Start To, Include Electronic 1095-C (True, False) | Populated 1095-C alternative form | Back Office |
Note: This report version is for 2020. |
|
Avionte_1095 C Report_Portrait 2019 |
This is not the IRS published version, rather an alternative version of the 1095-C that is portrait (not landscape) and on one page. | SSN, Form Batch ID, Branch, Primary Order By (Last Name, First Name, SSN), Print Start From, Print Start To | Populated 1095-C alternative form | Back Office |
Note: This report version is for 2016-2019. |
|
1094 C Report |
The IRS version of form 1094C. This is the transmittal to the IRS for the 1095-C forms and summarizes the 1095-C information for the reporting year. | Form Batch ID | Populated Federal 1094C Forms. | Back Office |
This report makes printing and sending 1094C Forms easy! Note: This report version is for 2016 and forward. |
|
1094 C Report 2015 |
The 2015 version of form 1094C. This is the transmittal to the IRS for the 1095-C forms and summarizes the 1095-C information for the reporting year. | Year, Is Corrected (Yes or No), Sent to IRS (Yes or No) | Populated Federal 1094C Forms. | Back Office | This report makes printing and sending 1094C Forms easy! |
|
Get Employee 1095-C Info AQ |
Gives details of employee 1095-C in an AQ or spreadsheet format | Populated information that appears on employee's 1095-C form. | Back Office | This AQ allows you to preview the information that will be on employees' 1095-C forms in a mass way. | |
|
1095 C Label |
This creates formatted mailing labels for envelopes to mail the 1095-C form to employees. You can print this report directly onto 5160 label paper | Entity Type (Agency, Contact, Customer, Employee). Status, Contact Method, Address Type (Home, Previous, Secondary), Entity Name, Branch, Start Date, End Date, Exclude Last Check/Invoice Date (True, False), Show Contact Method (True, False) | Populated information appears on the label. | Front Office, Back Office | This report makes label-making easy. Use 5160 label paper when printing. |
|
1095 C Label Report 2015 |
This creates formatted mailing labels for envelopes to mail the 1095-C form to 2015 employees. | Entity Type (Agency, Contact, Customer, Employee). Status, Contact Method, Address Type (Home, Previous, Secondary), Entity Name, Branch, Start Date, End Date, Exclude Last Check/Invoice Date (True, False), Show Contact Method (True, False) | Populated information appears on the label. | Front Office, Back Office | This report makes label-making easy. Use 5160 label paper when printing. |
3rd party link Disclaimer: These links are being provided as a convenience and for informational purposes only; they do not constitute an endorsement or an approval by [The author] of any of the products, services or opinions of the corporation or organization or individual. [The author] bears no responsibility for the accuracy, legality or content of the external site or for that of subsequent links. Contact the external site for answers to questions regarding its content.
Comments
0 commentsPlease sign in to leave a comment.