Importing TXP transactions

 

At this point, you should have already created a Governmental Agency Profile (similar to a Vendor profile) and a Tax form.  You should have also tested the addenda record by creating a manual transaction.

 

 

Creating the Excel or csv file

Your import file will need to have the name (or ID number) of the Governmental Agency in one of the fields.  This is called the Profile Look-up field.

In addition, you will need to have at a minimum: the amount of the tax to be paid, as well as tax period that it covers.

 

 

Examples

Enter into the Sample account within ACH Universal and select from the main menu Import > Tax Payments (either)

You will see the location of the Excel file on your computer.  Please feel free to use this as a template.

 

 

Mapping the imported file
We have mapped:

1. ACH_Name_Internal (Profile Lookup) - This matches the Gov't Agency Profile.  Of course, if we used an ID number in the file, we would then have used ACH_ID_Internal (Profile Lookup)

2. Period_Ending_Date_TXP

3. Amount_Reverse_Sign - Of course, if the file contained negative signed numbers, we could have mapped this as simply 'Amount'.  This represents the total payment.

4. Social_Security_941_TXP - Specific to Federal Form 941

5. Medicare_941_TXP - Specific to Federal Form 941

6. Withholding_941_TXP - Specific to Federal Form 941

 

 

This will enable you to create an ACH file with TXP transactions (technically a CCD+ payment, with a TXP formatted addenda record):