PDF document

- 1 -

Requirements for ACH Credit EFT Transactions
To submit ACH Credit EFT transactions follow the specifications below.

You are required to make ACH credit EFT transactions if you meet the requirements per Louisville Metro
Government Ordinance Number 066 – Ordinance for Electronic Fund Transfer (as of May 26, 2016).

If you are not required per Ordinance 066 to remit payments in the ACH format, beginning in mid-July
2018 a free e-check option will be available on our web portal.

File Specifications

ACH Credit Detail and Addenda Record Formats
The only format that the Louisville Metro Revenue Commission accepts for ACH-Credit transactions is
the NACHA CCD+ with TXP ADDENDA. Your bank must be able to transmit funds using this format.
Following is the data required in the ACH Credit Detail and Addenda Record Formats. Within NACHA
standards there are other lines that must be included besides the LMRC required line 6 and line 7.

For complete information on NACHA formats, specifications, and definitions, refer to the ACH Rule Book
and work with your financial institution.

Changes as of 7/1/2018

• LMRC account ID must be numbers only.
o This may be –
 10 digit LMRC customer number
 10 digit LMRC account number
 6 digit LMRC legacy account number
 No account with USA###

- 2 -

CCD+ Entry Detail Record Format (Line 6 Record)

Field Position Size Content Required Description

1 1–1 1 6 Yes Record Type Code. Insert the number 6.
2 2–3 2 22 Yes Transaction Code. Enter the number 22.
3 4–11 8 Numeric Yes Louisville Metro Revenue Commission Routing Number.
4 12–12 1 Numeric Yes Louisville Revenue Commission Routing Number Check Digit.
Yes Louisville Metro Revenue Commission Account Number (with
5 13–29 17 Alphanumeric
trailing blanks).
6 30–39 10 $$$$$$$$¢¢ Yes Total Payment Amount. No decimal. Insert leading zeros.
Yes Louisville Metro Revenue Commission Account Number. Insert
7 40–54 15 Numeric
leading zeros.
8 55–76 22 Alphanumeric Yes Receiving Company Name (your business name).
9 77–78 2 Not used No Discretionary Data.
10 79–79 1 1 Yes Addenda Record Indicator. Insert the number “ 1 ” .
11 80–94 15 Numeric No ACH Trace Number.

Field 1—Record Type Code. This field will always decimal point. The last two characters are cents.
be a 6 for the Entry Detail Record.
Field 7—Louisville Metro Revenue Commission
Field 2—Transaction Code. This field indicates Account Number. This is analphanumeric field
the transaction is a credit and the payment is that identifies the taxpayer sending the
going to a checking account. (This code is “24” payment. This field is your 6 digit account
when you send a pre-note.) number. Its use is essential for your payment to
be properly posted. The account number must
Field 3/4—Receiving Routing Number and
be right justified with leading zeros.
Check Digit. This nine-digit number identifies the
Louisville Metro Revenue Commission financial Field 8—Receiving Company Name. The
institution. The first eight digits go in Field 3. The Louisville Metro Revenue Commission
ninth digit goes in Field 4 (Routing Number Check recommends that you enter your corporation’s
Digit). The Louisville Metro Revenue name in this field for research purposes.
Commission will give you the receiving routing
Field 9—Discretionary Data. This two-character
number in the confirmation letter after receiving
field is not used by the department.
and approving your ACH Credit Agreement.
Field 10—Addenda Record Indicator. Always
Field 5—Receiving Account Number. This field
insert the number 1, as there will be an
identifies the account at the Louisville Metro
addendum record with this transaction.
Revenue Commission’s financial institution
where the EFT payments will be sent. This Field 11—Trace Number. A number added to the
number will be given to you by the Louisville record by the originating/sending financial
Metro Revenue Commission in the confirmation institution to trace the transaction through the
letter. system. This number is especially important in
case of an error.
Field 6—Amount. This field is the amount to be
posted to the recipient’s account. It must be
right justified with leading zeros. Do not insert a

- 3 -

                                                                                             ACH uploads v1.0 
                                                                                             May 2018 created 

CCD+ Addenda Record Format (Line 7) 
Use this addenda format for payment of taxes to the Louisville Metro Revenue Commission.  Line 7 must 
be filled out correctly or delay in applying payments or applying payments to incorrect accounts will 
happen.  An asterisk * is used as a separator. 

Field Position                            Size Required Content                      Description 
1     1-1                                 1    Yes      7            Record Type Code.  Insert number 7. 
2     2-3                                 2    Yes      05           Addenda Type Code.  Insert 05. 
3     4-6                                 3    Yes      TXP          Tax Payment ID.  Insert TXP. 
                                                                      
      7-7                                 1    Yes      *            Separator 
4     8-13                                6-10 Yes      Numeric      Numbers only  
                                                                     Valid account numbers only 
                                                                      This may be –  
                                                                     10 digit LMRC customer number 10 digit 
                                                                     LMRC account number  
                                                                     6 digit LMRC legacy account number  
                                                                     No account with USA### 
                                                                      
                                14        1    Yes      *            Separator 
5     15-23                               9    Yes      Numeric      Federal Identification Number or Social 
                                                                     Security Number of the Taxpayer.   
                                24        1    Yes      *            Separator 
6                                         1-4  Yes      Alphanumeric Tax Type Code 
                                                                     W1     Employer’s Withholding Tax 
                                                                     OL     Business Net Profit Tax 
                                                                     LINS   Louisville Urban Service District 
                                 Fields                                              Insurance Premiums Tax 
                                                                     TRAN Transient Room Tax 
                Variable Length 
                                                                     TRUK Truck Decal 
                                                                      
                                          1    Yes      *            Separator 
7                                         8    Yes      YYYYMMDD     Tax Period End Date 
                                          1    Yes      *            Separator 
8                                         1    Yes      T            Payment Type  
                                          1    Yes      *            Separator 
9                                         1-10          $$$$$$$$¢¢   Payment Amount.  No decimal point. 
                                                                     The amount should not include a dollar sign 
                                                                     or decimal point, but it should always 
                                                                     include cents even if it is 00.  For example, 
                                                                     1000000 would equate to a payment of 
                                                                     $10,000.00. 
                                          1             \            Terminator 
15                                        1             Blanks       Enter space through position 83 

                                                                                                              3

- 4 -

ACH uploads v1.0
May 2018 created

16 84-87 4 0001 Addenda Sequence Number
17 88-94 7 Numeric Entry Detail Sequence Number. Insert
leading zeroes.

Field 1—Record Type Code. This field will be a 7 for the CCD+ Addenda Record.
Field 2—Addenda Type Code. This field will be a 05 for the CCD+ Addenda Record.
Field 3—Tax Payment ID. This field will be TXP.
Field 4—Louisville Metro Revenue CommissionAccount Number. This number is your Louisville Metro
Revenue Commission Account Number. This account number is required to properly post your payment.
Processing will be delayed if this account number is not valid.
Field 5—Federal ID Number or Social Security Number. This field is used to ensure that the account
number presented above is valid and matches the FEIN/SSN assigned to the account. Processing will be
delayed if the FEIN/SSN does not match the same field on file for the account number presented above.
Field 6—Tax Type Code. This code identifies the type of tax for which the payment is to be applied.

Field 7—Tax Period End Date. This field must contain the tax period ending date, using the format
YYYYMMDD. Example: A payment with a tax period ending date of March 31, 2003 will be entered as:
20030331.
Field 8—Amount Type Code. This field must contain a ‘T’ to indicate a tax payment.
Field 9—Tax Amount. The amount to be posted to your account for the tax type and tax period ending
presented above. Do not insert a decimal point. The last two characters are cents. Example: A payment
of $480.00 must be entered as 48000
Field 14—Terminator. A backslash (\) must be entered.

Field 15—Blank Fill. Enter blank spaces through position 83. The next field starts on position 84.
Field 16—Special Addenda Sequence Number. For the CCD+ format this entry will always be 0001.
Field 17—Entry Detail Sequence Number. This entry is the same as the last seven digits of the ACH trace
number (field 11 of CCD+ Entry Detail Record) on the corresponding Entry Detail Record.

Sample TXP Addenda records – positions 4 - 83

• Employer’s Withholding Tax
TXP*123456*613333333*W1*20040331*T*120000\

This represents a payment of $1200.00 against a W1 tax period ending March 31, 2004, for account
123456, with a federal id of 613333333.

• Business Net Profit Tax
TXP*654321*401111111*OL*20031231*T*52038\

This represents a payment of $520.38 against an OL tax period ending December 31, 2003, for account
654321, with a social security number of 401111111.

PDF file checksum: 2934535799

(Plugin #1/8.13/12.0)