SmartFusion Modules > Payroll > Taxes > Quarterly Tax Reports (Florida Customers Only)

Recent Changes: 
6.89 - Implementation of new report and XML file

Introduction

Florida customers will have the option to print a report and/or generate an XML file for State Reemployment Taxes.

Report

Summary Page

  • Total Number of Covered Workers for 1st, 2nd, and 3rd Month of the Quarter.
  • Total Wages Paid
  • Less Wages in Excess of the Taxable Wage (Entered on form)
  • Taxable Wages
  • Contributions Due

Detail Pages

  • SSN (will be hidden if security does not permit user to view SSNs)
  • Employee Name
  • Taxable Wages
  • Total Wages

XML File

  • Jurisdiction – Defaulted to “Florida”.
  • Transmission Id – Unique ID for each submission. Stored in ConfigurationItems.
  • Transmission Timestamp – Datetime.Now.
  • ETIN – Electronic Transmitter Identification Number. Stored in ConfigurationItems.
  • ProcessType – T or P for either “Test” or “Production”.
  • OriginId – Default "00000000".
  • Timestamp – Datetime.Now
  • AgentIdentifier – Stored in ConfigurationItems.
  • EFIN – Not used.
  • Type – Not used.
  • ContentLocation - Optional.
  • Quarter – Entered from winform.
  • Taxyear – Entered from winform.
  • SoftwareId – Stored in ConfigurationItems.
  • ReturnType – “StateUI”.
  • Form – “RT-6”.
  • Action – “Original”.
  • Reason – For Amendment, currently not used.
  • TypeTIN – “FEIN”.
  • TINTypeValue – FEIN. Stored in ConfigurationItems.
  • TypeStateEIN – “UIAccountNo”
  • StateEINValue – RT account number assigned by the Department. Stored in ConfigurationItem.
  • BusinessName – Organization Name. Stored in ConfigurationItems.
  • AddressLine – Organization Address. Stored in ConfigurationItems.
  • City – Organization City. Stored in ConfigurationItems.
  • StateOrProvince – Organization State. Stored in ConfigurationItems.
  • ZipCode – Organization Zip. Stored in ConfigurationItems (Format #####, #########, or ############)
  • PhoneNumber – Organization Phone. Stored in ConfigurationItems (Format #########)
  • FirstName – Stored in ConfigurationItems.
  • MiddleName – Stored in ConfigurationItems. (Optional)
  • LastName – Stored in ConfigurationItems.
  • Suffix – Stored in ConfigurationItems. (Optional)
  • Phone – Stored in ConfigurationItems.(Format #########)
  • EmailAddress – Stored in ConfigurationItems. (Optional)
  • FinalReturnElect – Optional. For future use.
  • UITotalWages – Report total (Format 9999999999999.99. Must be numeric. Cannot be negative.)
  • ExcessWages – Wages paid in excess of $7,000.00. (Format 999999999.99. Must be numeric. Cannot be negative.)
  • UITaxableWages – Report total (Format 9999999999999.99. Must be numeric. Cannot be negative.)
  • ContributionRate – “0.00”
  • ContributionDue – Total employer cost. UITaxableWage * TaxRate. (Format 999999999.99. Must be numeric. Cannot be negative. )
  • UIInterest – "0.00"
  • UIPenalty – "0.00"
  • UITotalDue – Sum of ContributionDue + UIInterest + UIPenalty (Format 9999999999999.99. Must be numeric. Cannot be negative. )
  • SSN – Stored HR180 (Format #########, Default “999999999”)
  • FirstName – Stored HR180 (Only first 8 characters used, Default “Jane”)
  • MiddleName – Stored HR180 (Only first character used, Optional)
  • LastName – Stored HR180 (Only first 8 characters used, Default “Doe")
  • Suffix – Stored HR180 (Only first 8 characters used, Optional)
  • TotalWages – (Format 999999999.99)
  • TaxableWages – (Format 999999999.99)
  • TotalWages – N/A.
  • TaxableWages – N/A.
  • TaxState – N/A.
  • TotalWages – N/A.
  • NumberOfEmployees – Report Total (Format 999999. Must be numeric. Cannot be negative.)
  • Month1Employees – Report Total (Format 999999. Must be numeric. Cannot be negative.)
  • Month2Employees – Report Total (Format 999999. Must be numeric. Cannot be negative.)
  • Month3Employees – Report Total (Format 999999. Must be numeric. Cannot be negative.)

(The following tags are only included if "Pay with ACH Debit" is checked in the Reemployment Tax System File

  • PaymentMethodType = "DBT".
  • RoutingTransitNumber - Stored in ConfigurationItems.
  • BankAccountNumber - Stored in ConfigurationItems.
  • AccountType - ACH checking = "1", ACH savings = "2". Stored in ConfigurationItems.
  • AccountHolderType - "1".
  • DebitAmount - Default to Total UITotalDue (Format 99999999.99. Must be numeric. Cannot be negative. )
  • ActualSettlementDate - Default to tomorrows date.