The easiest way to do this is to open up Excel and enter the following values in the first row:

  • Column A (Tax Period End) - this will be December 31, 2010 entered in the following format: 2010-12-31
  • Column B (Software ID) - This is the software product used to make the report file.  Enter 0 if you do not want to specify what made the file "Excel" without quotes.
  • Column C (Software Version) - This is the version of the software product used to make the report file.  Enter 0 if you do not want to specify the version or click Help-About in your software and enter the version number from that window.
  • Column D (Amended Return Indicator) - Enter 0 if this an amended return or 1 if it is not.  For WizMag enter 0.
  • Column E (TIN) - Enter the company's FEIN without dashes.  An example would be if your company FEIN is 11-2211223 then enter 112211223.
  • Column F (State EIN) - Enter the company's Withholding ID without dashes.
  • Column G (Due Date) - Enter the due date of the W-2 report.  This will be February 28, 2011 and will be entered in the following format: 2011-02-28.
  • Column H (Tax Year) - Enter 2010.
  • Column I (No GA Tax) - Enter 0 if your company withholds state tax, 1 if you are a domestic employer and do not withhold state taxes.
  • Column J (Number of Forms) - Enter the number of W-2 forms being reported.
  • Column K (GA Taxable Wages) - Enter the total taxable wages being reported.  Two (2) digits must be shown after the decimal point. Example: 50.7 would not be correct but 50.70 would be correct.
  • Column L (GA Tax Withheld) - Enter the total taxes withheld being reported.  Two (2) digits must be shown after the decimal point. Example: 50.7 would not be correct but 50.70 would be correct.

Once the data is entered, click File, then Save As.  Specify the location and the file name and change the type to CSV.  A couple of dialogs will appear telling you that the CSV format can't store all of the features in Excel.  Click OK/Yes to continue.  Please note if you decide to open this file after closing Excel, it will format the dates incorrectly and make some fields too small to display the contents without widening the field.  Until the column is widened, it will show number signs (######).

When uploading the file you will choose G-1003 CSV as the file type, then locate the file made in the steps listed above as the file to upload.