Overview

Updated 10/14/2022

 

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.

 

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.

• Click here for information on Standard Reports
• Click here for information on Advanced Queries

 

 

ACA Package Reports
Imports and Exports
Standard Reports
Auditing Tools

 

 

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.  Click here for 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.

 

Back to Top

 

 

Imports and Exports

These imports and exports can be helpful for ACA purposes.

• Click here for more information on ACA Healthcare Imports and Exports

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.

 

Back to Top

 

 

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.)

 

Back to Top

 

 

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.

• Click here for more information on the Standard Advanced Queries.

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.	Branch, Start Week Worked, End Week Worked, Health Care Code, Show Summary (True, False), Exclude Non-W2 Employees (True, False)	Employee ID, First Name, Middle Name, Last Name, SSN, Employee Status, Employee Branch, Birth Date, Original Hire Date, Recent Hire Date, First Check Date, Recent Check Date, Effective Insurance Date, Assignment Max End Date, Street 1, Street 2, City, State, Zip Code, Email Address, Cell Phone #, Gender, Total Wages, Total Hours, Deduction Amount, Benefit Amount, Is ACA Eligible, Current Stability Period End Date, Measurement Start Date, Measurement End Date, Measured Type, Measurement Total Hours, Measured Eligibility, Reason for Deactivation, On Assignment	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 (Offered Date/Enrollment Date/ Declination Date), Employer, SSN Ends With, Show Dependents (Yes/No)	Employee ID, SSN, First Name, Middle Name, Last Name, Address Street, Address City, Address State/Province Code, Address Country, Address Postal Code, On Assignment, Last check Date, Most Recent Eligibility Status Declaration, Benefit Package Name, Offered By Employer Name, Offered By Employer Identification Number, Offered Date, Health Insurance Plan Name, Health Insurance Provider Name, ACA Offer of Coverage Code, Safe Harbor Code, Is Self Insured, Includes Spouse, Includes Dependents, In Minimum Essential Coverage, Is Minimum Value, Enrollment Date, Coverage Start Date, Coverage End Date, Declination Start Date, Declination End Date, Declination Reason	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 AQ	Displays a list of all offers made in the ACA Companion Application.	Start Date, End Date, Date Type (OfferedDate, StartDate, LastCheckDate), Branch, Benefit Package	Employer Name, SSN, First Name, Last Name, Benefit Package, Offered Date, Accept or Decline, Insurance Plan or Declination Reason, Start Date, End Date, Last Check Date, Last Assignment End Date, Employee ID, Branch, Employee Statuses	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.  Click here for more information on the 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.  Click here for more information on the 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. Click here for more information on the Employee Payroll - ACA Eligibility.

 

Back to Top