Show/Hide Toolbars

ACH Universal

Navigation: ACH Universal > File Creation and Transmission

General Ledger and Loan Records

Scroll Prev Top Next More

 

General Ledger and Loan Records

 

 

This is for users who need to create Financial Institution General Ledger records with a transaction code of 41 - 49, and Loan Account records with transaction codes of 51 - 56.

 

Note: These codes are typically used internally within financial institutions and their processing partners, and should not be used unless specifically requested.

 

 

Just as there are multiple ways to import and manually add transactions into ACH Universal, there are just as many ways to indicate their Transaction Code.  The methods below are not mutually exclusive and you can use any one or combination of methods.

 

You may create transactions with:

-Manual Addition

-Profile Storage

-Importing

-QuickBooks Integration

-Recurring and Quick Pay transactions

-Importing Profile Information

 

 

Manual addition

 

If you want to manually enter in a record, from within the Home tab select 'Add a Record'.

 

By selecting from the drop down list, the system will auto-select between 42/47 and 52/55.  If you wish another code in the 40 or 50 series, you may key it in directly into the drop down list.

 

Add_a_Record2

 

 

Profile Storage

 

If you are using Profiles, you may enter the G/L or Loan category from the drop down list.  The system will auto-select between 42/47 and 52/55 for debits vs. credits.

 

Profiles1

 

 

Importing

 

Map the field containing your two digit transaction codes as 'ACH_Transaction_Code'.

Note: Remember that your Amount field should be positive amounts, as the sign designated by the Transaction Code will determine whether it is a debit or credit.

 

Mapping

 

 

QuickBooks Integration

 

From within QuickBooks, navigate to the Vendor, Employee or Customer Profile that you want to to be General Ledger (40 series) or Loan (50 series).

In the CHK/SAV field, enter in either a 40 or 50. The system will auto-select between 42/47 and 52/55 for debits vs. credits.

 
Loan
 
 

Recurring and Quick Pay transactions

 

As ACH Universal pulls the underlying banking information from the Profile, these transactions will be compatible for 40 series and 50 series transactions as well.

 

QuickPay

 

 

Importing Profile Information

 

When you are importing Profiles, you can specify the Profile type:
 

Type

Allowable values (not case sensitive)

Checking

c, chk, checking, checkings, 0

Savings

s, sav, saving, savings, 1

General ledger

genledger, gl, g/l, g, 40

Loan

loan, loans, l (letter L), 50

 

ACH_General_Ledger_Record_06