While there is no national standard format, many states use a format similar to the Commonwealth of Virginia, which is show below:
The states require a CCD+, which is simply a CCD record, with the + referring to the addenda record.
1. Create a Tax profile for the Governmental Agency
From the Profiles tab > select Add.
Note: If you are using a version prior to 2013. From the main menu select Edit/Add > Profiles - TXP Gov't Agencies
Enter the information for the agency as you normally would.
ACH Universal will auto-populate as CCD (CCD+ will be when the addenda record is created).
Click the addenda tab, and turn on (check) the 'Create an addenda record' option.
On the Child Support sub-tab, click the hyperlink 'Populate the entry above...'
For most users, this is all you need to do.
Note: If you will only be paying the state on behalf of one employee, you can over-write any of the variables and hard-code the addenda record.
For example, you can update the template to pay on behalf of John Jones, with a case identified of 12345678, and social security number of 333224444.
From (default template):
DED*CS*[Case_Identifier]*[Pay_Date]*[Amount]*[Soc_Sec_Num_NonCustodial]*[Medical_Support_Ind]*[Parent_Name_NonCustodial]*[FIPS]*[Employment_Termination_Ind]\
To:
DED*CS*12345678*[Pay_Date]*[Amount]*333224444]*[Medical_Support_Ind]*Jones,John*[FIPS]*[Employment_Termination_Ind]\
Of course - if you are paying on behalf of multiple employees - leave the default.
Click Save when done.
2. Creating transactions
Method I - Manually add a payment
In the New Record screen, select the Government Agency and enter in the balance of the fields. Click OK when finished.
Method II - Importing transactions
a. Create a csv or Excel file that looks similar to this:
b. Start the Import Transactions Wizard from Home page and select the file that you created.
At the mapping screen, map the fields in a manner similar to:
Complete the import wizard.
When finished with importing or adding records - create the ACH file as normal.
Your file will include the addenda records (7 records) and should look similar to:
Advanced Options
Note: These features require the Processor edition of ACH Universal.
Want the funds to come out of different bank accounts?
Use our Multiple Origination Accounts feature.
Want different taxpayer name and ID's in the payment (6) record?
Turn on the 'Substitution' feature in the Government Agency's profile.
Then, during the import process - you can map the TAX_TaxpayerName, TAX_TaxpayerID fields (located in the Tax section of the drop down mapping list) as well as the Origination_Account field as needed.