ACA Reports - including 1095C

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? 

ACA Companion Census AQ

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.

ACA Companion Insurance Offers AQ

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.

ACA Companion Employee Offers

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.

Audit AQ

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.

Employee Deduction/ Contribution List AQ

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 Log

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 History - Pay 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.

Employee Payroll - ACA Eligibility

 

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. 

Recommendations for envelopes

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.

 

Articles in this section

Was this article helpful?
0 out of 1 found this helpful
Share