Wage File Upload Instructions - Creating a .csv File with Excel
Arizona Unemployment Tax and Wage System
Employee and Wage File Upload Instructions Required Format
Step 1. Open or create the wages file using Excel and key data into the four required columns, SSN, Last Name, First Name and Total Wages. Excess Wages are optional. See Figure 1 below.
Tip: Do not put any spaces or special characters in the Social Security column; do not format the Total Wages or Excess Wages columns with dollar signs or commas; do enter a decimal point and cents; use text format. Do not allow blank lines between employees or after the last employee record. To retain zeros at the beginning of a Social Security Number, key an apostrophe (‘) before typing the Number or format the column using “Special – Social Security Number.”
Figure1.csv
Step 2.
Open the menu item File-Save As. See Figure 2 below.
Figure2.csv
Step 3.
Select CSV from the “Save As Type” list box. You will notice that once this is selected Excel will automatically change your file extension in the “File Name” box from .xls to .csv. See Figure 3 below.
Figure 3.csv
Step 4.
After you click Save, Excel may prompt you with a message box stating,"The selected File type does not support workbooks that contain multiple sheets. To save only the active sheet, click OK."You only want to save the active sheet, so click OK to continue.
Figure4.csv
The Wages file should now be saved as a .csv file. Your quarterly wages are ready to be uploaded into the Arizona Unemployment Tax and Wage System.
Login to the Tax and Wage System
Related Topics: