Wiki source code of Importing a CSV File W-2/1099

Version 9.1 by jackb on 2023/12/20 22:31
Show last authors
1 **Add Row/Column**
2
3 *
4 ** Right-click on numbered row and choose to insert row. Then enter the number of rows you wish to enter.
5
6 [[image:https://customer.aatrix.com/files/2615/4419/3742/2018-12-07_8-39-28.png||alt="2018-12-07_8-39-28.png" height="1036" width="1916"]]
7
8
9 *
10 ** Right click on a column and choose to **Insert**. Then enter the **Column name** and a default value if desired.
11
12 [[image:https://customer.aatrix.com/files/4615/4419/3998/2018-12-07_8-43-42.png||alt="2018-12-07_8-43-42.png" height="1037" width="1919"]]
13
14
15 *
16 ** Edit and choose to **insert row or column**.
17
18 **~ **
19
20 **Remove Row/Column**
21
22
23 *
24 ** Right-click on numbered row and choose to remove row
25
26 *
27 ** A column can not be removed:
28
29 *
30 **
31 *** If there is an unnecessary state or local column, remove this item from the company setup by going to the **Edit** menu and choose **Company Info**.
32
33 *
34 **
35 *** If it is a column that was added and assigned. Unassign the column by clicking on the dropdown menu and select **Unassign**.
36
37 **Link Box 12 & 14**
38
39 *
40 ** Insert the column. Enter in the name of the column. The **Default Value** is optional. The new column will appear with a yellow header that says** Unassigned**. To assign the column, select the dropdown menu, choose the box number from the dropdown menu. If adding a Box 11, 12, or 14, there will be an additional menu to select further details.
41
42 [[image:https://customer.aatrix.com/files/9515/4419/4876/2018-12-07_8-55-27.png||alt="2018-12-07_8-55-27.png" height="1031" width="1915"]]
43
44 **~ State and Local Tax Items**
45
46 To access the Company Setup while in the Preparer, go to the **Edit** menu and choose **Company Info**.
47
48 *
49 ** On the **State & Local Tax Items** screen is where you can **Add**, **Edit**, or **Remove** state and local tax items.
50
51 //Notes~://
52
53 * //If attempting to remove a state or local item but the Remove button is grayed out, the amounts for that state or local item will have to be zeroed out in the Preparer instead. The Remove option will not be available in corrections mode.//
54 * //To change the format of a state account number, choose the "**...**" off to the right of the account number and select the appropriate format. //
55
56 [[image:https://customer.aatrix.com/files/6814/6049/4103/State_and_Local_Items.png||height="487" width="651"]]
57
58 **Correct Company Information**
59
60 *
61 ** To change the address, update the item in the Company Setup by going to **Edit** menu and choose **Company Info**. Change the company information on the **Company Information** screen.
62
63 **Data Verification (W-2s)**
64
65 *
66 ** When an employee is exempt from any part of Medicare or Social Security taxes then this must be indicated on the **Data Verification** screen within the Company Setup. Once this is indicated as **Yes**, that fatal error message will now have an option to **Continue without Correcting**, making it a nonfatal error.
67 ** If you wish to use control numbers on your W-2 forms, indicate **Yes** to have the **Employee ID** column display in the Preparer.
68 ** If employees have elected to receive only an electronic-only copy of their W-2, indicate **Yes** to have the **Electronic W-2** and **Email Address** columns appear in the Preparer.
69
70 //[[image:NL4yzO4.png||alt="https://customer.aatrix.com/files/3914/6049/4272/data_verification.png" height="487" width="651"]]//
71
72 //Note: If your electronic W-2 option is grayed out, this indicates that your payroll software is passing electronic only employees. //
73
74 **For Additional Functions :**
75
76 * [[Incorrect Data Populating into Preparer>>]][[ >>doc:Windows.U\.S\..Standard Filing Questions ».Processing & Forms Introduction.Incorrect Information on Forms.WebHome]]
77 * [[Merging>>doc:Windows.U\.S\..Standard Filing Questions ».Processing & Forms Introduction.Merging.WebHome]]
78 * [[Social Security Number Information>>doc:Windows.U\.S\..Standard Filing Questions ».Processing & Forms Introduction.Social Security Number Information.WebHome]]
79 * [[1099 Error Checking>>doc:Windows.U\.S\..Year-end, W-210951099 Questions ». Processing and Form Introduction.1099 Error Checking.WebHome]]
80 * [[Foreign Employees>>doc:Windows.U\.S\..Year-end, W-210951099 Questions ». Processing and Form Introduction.Foreign Employees.WebHome]]
81 * [[W-2 Error Checking>>doc:Windows.U\.S\..Year-end, W-210951099 Questions ». Processing and Form Introduction.W-2 Error Checking.WebHome]]
82 * [[NJ Wage and Tax Formats>>doc:Windows.U\.S\..Year-end, W-210951099 Questions ». Processing and Form Introduction.NJ Wage and Tax Formats.WebHome]]
83
84 ----
85
86 == Related Pages: ==
87
88
89 === [[1095-B eFiling Process>>doc:Windows.U\.S\..Affordable Care Act (ACA) ».Processing and Form Introduction.1095-B eFiling Process.WebHome]] ===
90
91 ====== Learn more about the 1095-B e-Filing Process with the Aatrix ACA Preparer. ======
92
93
94 === [[Covered Individual Information>>doc:Windows.U\.S\..Affordable Care Act (ACA) ».Processing and Form Introduction.Covered Individual Information.WebHome]] ===
95
96 ====== Learn about covered individuals. ======
97
98
99 === [[Importing a CSV File>>doc:Windows.U\.S\..Affordable Care Act (ACA) ».Processing and Form Introduction.Importing a CSF File.WebHome]] ===
100
101 ====== Learn about importing a CSV into the ACA Preparer. ======
102
103
104 === [[1095-C eFiling Process>>doc:Windows.U\.S\..Affordable Care Act (ACA) ».Processing and Form Introduction.1095-C eFiling Process.WebHome]] ===
105
106 ====== Learn more about the 1095-C e-Filing Process with the Aatrix ACA Preparer. ======
107
108
109 === [[Indicate the Combining of W-2 and 1095s>>doc:Windows.U\.S\..Affordable Care Act (ACA) ».Processing and Form Introduction.Indicate the Combining of W-2 and 1095s.WebHome]] ===
110
111 ====== Learn about saving money by combining W-2s and 1095s. ======