Navigation:  GOLD Services > GOLD Services Screens > General Ledger Screen Group > Autopost Parameters Screen >

General Ledger Amount Fields

Navigation:  GOLD Services > GOLD Services Screens > General Ledger Screen Group > Autopost Parameters Screen >

General Ledger Amount Fields

Previous pageReturn to chapter overviewNext page  Print this Topic

The following chart describes the available amount fields for the General Ledger Autopost Parameters.

 

System

Amt #

Amt Field

Definition

L

1

Net Cash

Offset amount; the Cash portion of the transaction.

L

2

Check In

Offset amount; the Check In portion of the transaction.

L

3

Net Journal

Offset amount; other than cash or check.

L

4

Principal

Institution's portion of the loan principal in the transaction; normally posted to the loan principal balance.

L

5

Interest

Institution's portion of the loan interest in the transaction; normally posted to the institution interest income

L

6

Reserve 1

Reserve 1 amount; will post to the reserve 1 balance.

L

306

Reserve 1

An additional amount field whereby you can direct the reserve 1 portion to other accounts in the G/L; typically used for transferring custodial funds through a clearing account. All 300 amounts retain the sign of the transaction when posting to a G/L account. Institution option GAP3 must be set.

L

406

Reserve 1

Offset to amount field 306; all 400 amounts reverse the sign of the transaction. Institution option GAP3 must be set.

L

7

Reserve 2

Reserve 2 amount; will post to the reserve 2 balance.

L

307

Reserve 2

An additional amount field whereby you can direct the reserve 2 portion to other accounts in the G/L; typically used for transferring custodial funds through a clearing account. All 300 amounts retain the sign of the transaction when posting to a G/L account. Institution option GAP3 must be set.

L

407

Reserve 2

Offset to amount field 307; all 400 amounts reverse the sign of the transaction. Institution option GAP3 must be set.

L

8

Late Charge

Late charge amount; will post to the late charges due field.

L

58

Late Charge, investor portion

When using L-58, L-158, and L-258, L-8 becomes only the institution portion of the late charge. L-58 becomes the investor portion, L-158 becomes the investor payable, and L-258 becomes the investor contra. These amount numbers require that institution option OP07-IPLC is set, the account is sold to an investor (LNIMST not equal 0, LNIGRP not equal to 0, LNISLD not equal to 0, LNPLDG equal to N), and the investor late charge code (LNILCL) is a 1 or 2. The late charge amounts are broken out at the time of the G/L posting and are not shown in the account history.

L

158

Late Charge, investor payable

See L-58.

L

258

Late Charge, investor contra

See L-58.

L

9

Institution deferred interest principal increase

Debit field; adds to the principal balance of the loan (negative amortized or capitalized interest; posted against the loan principal balance same as field 4).

L

209

Institution deferred interest

Credit field; an offset to amount field 9, which will normally be posted to the institution's interest income, same as field 5.

L

10

Deferred interest principal decrease

Credit field; reduces the principal balance of the loan; posted against the loan principal balance same as field 4.

L

11

Investor portion of principal decrease

Investor's portion of the loan principal; posted against the loan principal balance same as field 4.

L

111

Investor portion of principal

Portion of the principal payment which belongs to the investor and will normally be posted to the investor liability/payable.

L

211

Investor portion of principal contra

Offset to field 11; normally posted to the loan contra/sold.

L

311

Investor portion of principal

Additional amount field whereby you can direct the investor portion of principal to other accounts in the G/L; typically used for transferring custodial funds through a clearing account. All 300 amounts retain the sign of the transaction. Institution option GAP3 must be set.

L

411

Investor portion of principal contra

Same as 311, except all 400 amounts reverse the sign of the transaction. Can be used as an offset to the 311 amount. Institution option GAP3 must be set.

L

12

Investor portion of interest/dealer interest prepaid (premium)

Portion of loan interest including LIP interest that belongs to the investor; normally posted to the investor payable/liability account. Also used for Dealer Interest Prepaid (premium).

L

312

Investor portion of interest

Additional amount field whereby you can direct the investor portion of interest to other accounts in the G/L; typically used for transferring custodial funds through a clearing account. All 300 amounts retain the sign of the transaction when posting to a G/L account. Institution option GAP3 must be set.

L

412

Investor portion of interest

Offset to amount field 312. All 400 amounts reverse the sign of the transaction. Institution option GAP3 must be set.

L

13

Subsidy balance

Subsidy amount of transaction; will post to the subsidy balance; an amount deposited by the buyer/seller/third party to augment the monthly payments; will help the buyer to qualify for the loan.

L

313

Subsidy balance

Additional amount field whereby you can direct the subsidy balance to other accounts in the G/L. All 300 amounts retain the sign of the transaction when posting to a G/L account. Institution option GAP3 must be set.

L

413

Subsidy balance

Offset to amount field 313. All 400 amounts reverse the sign of the transaction. Institution option GAP3 must be set.

L

14

Partial payments

Partial payment amount of the transaction; posts to the partial payment balance.

L

314

Partial payments

Additional amount field whereby you can direct the partial payments to other accounts in the G/L. All 300 amounts retain the sign from the transaction when posting to G/L accounts. Institution option GAP3 must be set.

L

414

Partial payments

Offset to amount field 314. All 400 amounts reverse the sign of the transaction. Institution option GAP3 must be set.

L

15

Miscellaneous funds

Amount field defined by the institution; posts to the miscellaneous funds balance.

L

16

LIP balance

Portion of the transaction that will post to the LIP balance.

L

17

LIP customer balance

Portion of the transaction that will post to the LIP customer balance; an amount deposited by the borrower to qualify for the loan. These funds may be dispensed before institution funds.

L

18

LIP interest

Institution LIP interest; normally posts to interest income.

L

19

Service fee on sold loans

Service fee on a sold loan; normally posts to service fee income.

L

319

Service fee on sold loans

Only use to show interest gross with service fee and show service fee as an expense. Institution option GAP3 must be set.

L

419

Service fee on sold loans offset

Offset to amount 319; only use to show interest gross with service fee and show service fee as an expense. Institution option GAP3 must be set.

L

20

Investor portion of deferred interest principal increase

Increases deferred interest and adds to the loan principal balance; posted against the loan principal balance account used in L-4.

L

220

Investor portion of deferred interest principal increase offset

Offset to amount field 20; normally posts to the loan contract/sold loan account used in L-211.

L

21

Investor portion of deferred interest principal decrease

Decreases deferred interest and reduces the loan principal balance; normally posts to the loan principal balance account used in L-4.

L

121

Investor portion of deferred interest principal decrease

Same as field 21, normally posted to the investor payable/liability account used in L-111.

L

221

Investor portion of deferred interest principal offset

Offset to amount field 21; normally posts to the loan contract/sold loan account used in L-211.

L

321

Investor portion of deferred interest principal decrease

Additional amount field whereby you can direct the investor portion of deferred interest principal decrease to other accounts in the G/L; typically this is used for transferring custodial funds through a clearing account. All 300 amounts retain the sign from the transaction when posting to G/L accounts. Institution option GAP3 must be set.

L

421

Investor portion of deferred interest principal decrease

Offset to amount field 321. All 400 amounts reverse the sign from the transaction. Institution option GAP3 must be set.

L

22

Deferred loan fees and discount/gains, amortizing fee codes, and insurance commissions (branch and corporate)

This amount field is shared in three ways:

 

1.The first use of this amount field is for processing remaining amounts of deferred fees and discounts/gains (Remaining Deferred Fees and Discounts). These deferred fees and discounts/gains are placed on a loan account using tran code 510 (TORC 116 or 118) and amortized at monthend using tran code 450 (fees) and tran code 70 (discounts/gains). There are four possible Transaction Origination Codes (TORCs) assigned to the monthend amortization transactions: TORC 40 (when a certain % of the loan is sold), TORC 56 (regular amortization), TORC 57 (at monthend after payoff), and TORC 80 (100% of loan is sold). L-22 would normally be pointed to the unearned income account(s) while L-3 Net Journal would be directed to the appropriate income account(s) for amortization. Posting field 22 (Unamortized Yield G/L Posting Field (UGL)) is usually used to differentiate between the amount of deferred fees and discounts/gains within L-22. For example, deferred fees could be assigned the UGL of 1, while discounts/gains would have the UGL of 2. In order for deferred fees and discounts/gains to amortize at monthend, the following update functions must be set to CYC31B: fees (function 42) and discounts/gains (function 60).

 

2.The second use of this amount field is for processing remaining amounts of Amortizing Fees (see G/L Remaining field (F1GREM) on the Loans > Account Information > Amortizing Fees and Costs screen). These amortizing fees are funded on a loan using the credit Tran Code 910 (TORC 0) and can be reduced with a debit Tran Code 900 (TORC 0). Amortizing fees are amortized at monthend using Tran Code 451 and TORC 58. The amount field L-22 would normally be pointed to the unearned income account while L-3 Net Journal would be pointed to the appropriate income account for amortization. Loan Posting field 25 Amortizing Fee Code (AFC) is usually used to direct AFCs to different G/L accounts. In order to amortize at monthend, loan update function 87 must be set to CYC31B.

 

Amortizing fee codes can be refunded to the customer during a loan payoff. To successfully accomplish this, a table containing the amortizing fee codes, descriptions, unearned and income G/L accounts must be set up on the GOLD Services > General Ledger > Amortization Descriptions screen.

 

3.The third use of this amount field is for processing remaining amounts of insurance commissions for office and corporate (Loans > Insurance > Policy Detail screen > Commission Information tab). Insurance Commission percentages are set up by Insurance Company Number (ICN), Insurance Policy Type (IPT), and Branch on the GOLD Services > General Ledger > Setup G/L and Commissions screen. Unearned commissions are credit amounts that are usually established by GOLDTrak PC (GTPC), along with associated G/L transactions through the GTPC Funding Rules. However, if the remaining office or corporate commission fields are file maintained, credit transactions (110 Tran Code, TORC 124 or 128) will be generated by journal out.

 

paperclipnote

Note: This transaction does not update GOLDTeller teller totals. Normally, L-22 would point to the unearned income account and L-3 would be pointed to the insurance payable or insurance commission contra account. There are two possible amortizations transactions: regular amortization (Tran Code 460, TORC 125, 129) and amortization the monthend after payoff (Tran Code 460, TORC 126, 130). For amortization, L-22 would reduce the unearned income and L-3 would increase insurance commission income. In addition, insurance commissions may be rebated (Tran Code 490, TORC 127, 131). Normally, L-22 would point to the unearned income account and L-3 would be pointed to the insurance payable or insurance commission contra account. In order for commissions to amortize at monthend, loan update function 80 must be set to CYC31B.

L

23

Remaining costs, premium/losses,  MSRs, miscellaneous fees, and insurance commission costs

This amount field is shared three ways:

 

1.The first use of this amount field is for processing remaining amounts of deferred costs, premiums/losses, or MSRs (see the Loans > Account Information > Deferred Fees screen). These costs, premiums/losses, or MSRs are placed on a loan account using Tran Code 500 (TORC 117, 119, and 120) and amortized at monthend using Tran Code 420 (costs), Tran Code 80 (premiums/losses), or Tran Code 840 (MSRs). There are four possible Transaction Origination Codes (TORCs) assigned to the monthend amortization transactions: TORC 40 (when a certain % of the loan is sold), TORC 56 (regular amortization), TORC 57 (at monthend after payoff), and TORC 80 (100% of loan is sold). L-23 would normally be pointed to the deferred expense account(s) while L-3 Net Journal would be directed to the appropriate expense account(s) for amortization. Posting field 22 [Unamortized Yield G/L Posting Field (UGL)] is usually used to differentiate between the amount of costs, premiums/losses, and MSRs within L-23. For example, costs could be assigned the UGL of 1, premiums/losses the UGL of 2, and MSRs the UGL of 3. In order for costs, premiums/losses, and MSRs to amortize at monthend, the following update functions must be set to CYC31B: costs (function 30), premiums/losses (function 61), and MSRs (function 69).

2.The second use of this amount field is to process loan Miscellaneous Fees (see Loans > Marketing and Collections > Miscellaneous Fees). Miscellaneous fees can be assessed (Tran Code 660), waived (Tran Code 670), paid (Tran Code 850), and reclassified (Tran Code 22). There are basically two types of Miscellaneous Fee Codes (MFCs): income and non-income related. The type of MFC used in the transaction and the status of loan account (charge off) determines what G/L accounts to post to. Therefore, the following posting fields may be necessary to direct amount field L-23 to the correct G/L: 27 Miscellaneous Fee Code, 3 General Category, 33 Transaction Code. Income related MFCs are generally assessed to an account in an effort to make money (ie; Non-Sufficient Funds Fee). For Income related MFCs, amount field L-23 is normally No Posted when assessed or waived, and posted to income or recoveries when paid. Non-Income MFCs are normally assessed to an account to establish a receivable from the customer because the institution has or will be paying for services rendered in behalf of the account holder (e.g.; Towing Fee). For Non-Income MFCs, amount field L-23 is normally posted to a fee receivable/charge off fee receivable when assessed, waived, paid, or reclassified. The offsetting amount field L-3 is generally posted to a Misc Fee Payable or Charge Off Expense. A maximum of 10 MFCs can be reclassified (Tran Code 22) during the Charge-off transaction. The MFCs that occupy the first 10 fields of institution option OFEE (Order of Fee Code Processing) will be reclassified. Additionally, institution option GAP6 should be turned on so as to use loan amount fields L-123 Misc Fee 1 and L-223 Misc Fee 2 during the Charge-off transaction.

3.The third use of this amount field is for processing remaining amounts of Insurance Commission Costs (Loans > Insurance > Policy Detail screen > Commission Information tab > Cost Remaining Amount field (INXREM)).. Insurance Commission Costs are normally used when corporate headquarters subsidizes branch commissions. This debit amount is usually established by GOLDTrak PC (GTPC) boarding, with an associated G/L transaction through GTPC Funding Rules. However, if the remaining cost field is file maintained, a debit transaction (100 Tran Code, TORC 132) will be generated by journal out. Normally, L-23 would point to the deferred expense account and L-3 would be pointed to the insurance payable or insurance commission contra account. This transaction does not update GOLDTeller teller totals. There are two possible amortizations transactions: regular amortization (Tran Code 760, TORC 133), amortization the monthend after payoff (Tran Code 760, TORC 134). For amortization, L-23 would reduce the deferred expense and L-3 would increase insurance commission expense. In addition, commission costs may be rebated (Tran Code 790, TORC 135). Normally, L-23 would point to the deferred expense account and L-3 would be pointed to the insurance payable or insurance commission contra account. In order for commissions to amortize at monthend, loan update function 80 must be set to CYC31B.

 

WARNING: If you have GAP3 set to "Y" for your institution, amount fields 323/324 may show in your Autopost and error report. See L-323 below on how to adjust the Autopost to no longer get that error.

L

123

Misc Loan Fees 1

This amount field is available for use if institution option GAP6 (which allows Loan Amount fields L-123 and L-223 to be used and accompany every L-23 transaction) is turned on. This amount field is normally used to reclassify miscellaneous fees when the loan is charged off (transaction code 2022) and carries the same sign as L-23 on all transactions. This amount field is generally No Posted for income related fees. For all non-income related fees, the G/L accounts normally used will be No Post, Charge Off Expense, and Fee Recoveries. In general, the Loan Posting fields used to direct this amount to the G/L are #27 (Miscellaneous Fee Code), #3 (General Category), and #33 (Transaction Code).

L

223

Misc Loan Fees 2

This amount field is available for use if institution option GAP6 (which allows Loan Amount fields L-123 and L-223 to be used and accompany every L-23 transaction) is turned on. This amount field is an offset to L-123 and is normally used to reclassify miscellaneous fees when the loan is charged off (transaction code 2022) and carries the opposite sign as L-23 on all transactions. This amount field is generally No Posted for income related fees.  For non-income related fees, the G/L accounts normally used will be No Post and Charge Off Fee Contra. In general, the Loan Posting fields used to direct this amount to the G/L are #27 (Miscellaneous Fee Code), #3 (General Category), and #33 (Transaction Code).

L

323

Miscellaneous fees, institution-only portion of miscellaneous fees when the loan is partially (or entirely) sold to an investor

When using L-323 and L-423, L-323 becomes the institution only portion of the miscellaneous fee (asset). L-423 becomes the investor only portion (liability). These amount numbers require institution option GAP3 to be set, the account is sold to an investor (LNIMST not equal to 0, LNIGRP not equal to 0, LNISLD not equal to 0, LNPLDG equal to "N"), and the investor Late Charge code (LNILCL) is a 1 or 2. (Note: The system shares the investor Late Charge field with miscellaneous fees. See the Late Charge field description on the Loan Investor Group screen for more information.)

The miscellaneous fee amounts are broken out at the time of the G/L posting and are not shown in the account history.

These amount fields are generally No Posted for income-related miscellaneous fees. For non-income related fees, the G/L accounts normally used will be No Post and Charge Off Fee Contra. In general, the Loan Posting fields used to direct this amount to the G/L are #27 (Miscellaneous Fee Code), #3 (General Category), and #33 (Transaction Code).

WARNING: For any institutions that have the institution option GAP3 (Use G/L Autopost Amounts Over 300) set to "Yes," these amount fields will begin to come through. They may show up in your Autopost Error Report (FPSDR013). To remove these from the error report, we suggest you do one of the following:

If your institution doesn’t need to move investor-portion of miscellaneous fees to a deposit account, please set up these new amount fields and use the parameter substitution of NP (no post).  

If your institution would like to move these funds to a deposit account, set up the amount field L-323 to post to the appropriate Asset account and L-423 to the appropriate liability.

A future host release will include options to stop this amount field from showing up in your Autopost Error Report. We will let you know via the Update document when that institution option is ready.

L

24

LIP investor balance

Investor portion of the transaction that will post to the LIP customer balance; applies to loans that are sold.

L

124

LIP investor balance

Portion of the principal payment that belongs to the investor and will normally be posted to the investor liability/payable; applies to loans that are sold.

L

224

LIP investor balance offset

Offset to field 24; normally posted to the loan contra/sold account; applies to loans that are sold.

L

324

Miscellaneous fees, investor-only portion of miscellaneous fees when the loan is partially (or entirely) sold to an investor

When using L-323 and L-423, L-323 becomes the institution only portion of the miscellaneous fee (asset). L-423 becomes the investor only portion (liability). These amount numbers require institution option GAP3 to be set, the account is sold to an investor (LNIMST not equal to 0, LNIGRP not equal to 0, LNISLD not equal to 0, LNPLDG equal to "N"), and the investor Late Charge code (LNILCL) is a 1 or 2. (Note: The system shares the investor Late Charge field with miscellaneous fees. See the Late Charge field description on the Loan Investor Group screen for more information.)

The miscellaneous fee amounts are broken out at the time of the G/L posting and are not shown in the account history.

These amount fields are generally No Posted for income-related miscellaneous fees. For non-income related fees, the G/L accounts normally used will be No Post and Charge Off Fee Contra. In general, the Loan Posting fields used to direct this amount to the G/L are #27 (Miscellaneous Fee Code), #3 (General Category), and #33 (Transaction Code).

WARNING: For any institutions that have the institution option GAP3 (Use G/L Autopost Amounts Over 300) set to "Yes," these amount fields will begin to come through. They may show up in your Autopost Error Report (FPSDR013). To remove these from the error report, we suggest you do one of the following:

If your institution doesn’t need to move investor-portion of miscellaneous fees to a deposit account, please set up these new amount fields and use the parameter substitution of NP (no post).  

If your institution would like to move these funds to a deposit account, set up the amount field L-323 to post to the appropriate Asset account and L-423 to the appropriate liability.

A future host release will include options to stop this amount field from showing up in your Autopost Error Report. We will let you know via the Update document when that institution option is ready.

L

25

LIP investor interest

Investor LIP interest; normally posts to the investor payable account.

L

26

Interest on Negative Reserve 1 and 2

Amount of interest accrued and collected on the reserve 1 balance (tran code 810) and reserve 2 balance (tran code 820) below zero (normally posted to interest income).

L

27

PI Fee

Certain states allow an institution to charge a maintenance fee for interest-bearing loans. These fees are assessed on the account the afterhours before the due date. Amount field 27 is posted to a receivable account, which is increased when the fee is assessed and decreased when the fee is paid. Amount field 3 is posted to income when this fee is assessed.

L

30

Check Out

Offset amount; the check out portion of the transaction.

L

31

Accrued interest on principal

Institution portion of accrued interest calculated on an account to the next processing day or the first of the month. Used to automatically post accrued interest to the General Ledger. Does not have an associated transaction. Normally posted to accrued interest receivable (does not include investor amounts).

L

32

Accrued interest offset

Offset to amount 31; normally posted to interest income.

L

33

Delinquent interest

There are two methods for calculating delinquent interest:

 

1.Institution portion of accrued interest that is more than 92 days delinquent from the due date or has either of the Non-Performing or Non-Accrual fields selected (on the Loans > Account Information > Additional Loan Fields screen). This amount is included in L-31. This is normally posted as a reduction to interest income (reduction of L-32, accrued interest offset).

2.If institution option DAIC (Alternate Delinquent Accrued Interest Calculation) is set to “Y,” delinquent days and delinquent interest are determined using the Date Last Accrued (LNDLAC) rather than the Due Date (LNDUDT). Delinquent days are calculated by subtracting the Date Last Accrued from the next afterhours processing date or the first day of the next month and then subtracting the number of days found in institution option NPDY (Days to Mark Loan as Non-Performing); a result greater than zero represents the number of days delinquent. Delinquent interest calculated using the number of days delinquent is normally posted as a reduction of accrued interest income (L-32). This amount is included in L-31. The Delinquent Interest Report (FPSRP249) should be used to display accrued/delinquent interest when DAIC is set to “Y.” The delinquent days calculation is the only criterion for determining delinquent interest when DAIC is set to “Y” (the Non-Performing and Non-Accrual fields mentioned previously are completely ignored).

 

warningalerticon

WARNING: DAIC should only be used by institutions that own 100% of their loans (no investor loans). Institutions that have investor loans should set DAIC to “N” and use the Accrued Interest Report (FPSRP019) and the Investor Accrued Interest Report (FPSRP257) to display accrued/delinquent interest.

 

An option (afterhours update function 59) is available that automatically changes performing loans to non-performing loans if the loan is 93 or more days delinquent. This change takes place only at monthend.

 

Each month, for all loans that exceed being delinquent by 93 days, the system will enter a check in the Non-Performing field. If the loan becomes less than 93 days delinquent, the system unchecks the field at monthend. The system does not look at line-of-credit loans (payment method 5, 9, or 10) with a zero principal balance.

 

An institution option (NPDY) is available that allows you to control how many days delinquent a loan must be before it is automatically classified as non-performing. If this option is not used, the system will use 93 or more days.

 

Action code 59 stops the Non-Performing field from changing on a loan-by-loan basis, if update function 59 is used. No action date is required.

L

34

Delinquent interest offset

Offset to amount 33. This amount is included in amount 32. It may be posted as a deduction from accrued interest receivable (reduction of L-31 Accrued Interest).

L

35

Investor portion of accrued interest

Investor portion of accrued interest (normally posted to accrued interest receivable; see L-31).

L

36

Investor portion of accrued interest offset

Offset to amount 35 (normally posted to investor accrued interest payable).

L

136

Investor Accrued Offset 1

Offset to amount 135 (normally posted to investor accrued interest 1). Note: Only shows if the Use G/L Autopost Amounts 135-238 option (GAP8) is set and the loan is set to a percentage sold.

L

236

Investor Accrued Offset 2

Offset to amount 235 (normally posted to investor accrued interest 2). Note: Only shows if the Use G/L Autopost Amounts 135-238 option (GAP8) is set and the loan is set to a percentage sold.

L

37

Investor delinquent accrued

Investor accrued interest that is more than 92 days delinquent or has either of the Non-Performing and Non-Accrual fields are indicated on the account. This amount is included in amount 35. It may be posted as a deduction from investor accrued interest payable (reduction of L-36 Investor portion of accrued interest offset).

L

137

Investor Delinquent Accrued 1

Investor accrued interest that is more than 92 days delinquent or has either of the Non-Performing/Non-Accrual fields set to “Y” (yes). This amount is included in amount 135. It may be posted as a deduction from investor accrued interest payable (reduction of L-136 Investor portion of accrued interest offset). Note: Only shows if the Use G/L Autopost Amounts 135-238 option (GAP8) is set and the loan is set to a percentage sold.

L

237

Investor Delinquent Accrued 2

Investor accrued interest that is more than 92 days delinquent or has either of the Non-Performing/Non-Accrual fields set to “Y” (yes). This amount is included in amount 235. It may be posted as a deduction from investor accrued interest payable (reduction of L-236 Investor portion of accrued interest offset). Note: Only shows if the Use G/L Autopost Amounts 135-238 option (GAP8) is set and the loan is set to a percentage sold.

L

38

Investor delinquent accrued

Offset to amount 37; it may be posted as a deduction from accrued interest receivable (reduction of L-35 Investor portion of accrued interest).

L

41

Negative reserve one balance

This amount will be the debit amount of the negative reserve one balance that should be directed to the asset accounts to track the advances on reserve one.

L

42

Negative reserve one offset

This amount will be the credit amount of the negative reserve one balance that should be directed to the liability accounts where amount L-6 is normally posted. This will undo the reduction of the negative amounts that posted with L-6.

L

43

Negative reserve two balance

This amount will be the debit amount of the negative reserve two balance that should be directed to the asset accounts to track the advances on reserve two.

L

44

Negative reserve two offset

This amount will be the credit amount of the negative reserve two balance that should be directed to the liability accounts where amount L-7 is normally posted. This will undo the reduction of the negative amounts that posted with L-7.

L

45

Reserve one accrued interest

This is the amount of accrued interest calculated on the reserve one balance of an account to the next processing day or the first of the month. This is used to automatically post accrued interest to the General Ledger. It is normally posted to accrued interest payable.

L

46

Reserve one accrued interest offset

Offset to amount 45; normally posted to interest expense.

L

47

Reserve two accrued interest

This is the amount of accrued interest calculated on the reserve two balance of an account to the next processing day or the first of the month. This is used to automatically post accrued interest to the General Ledger. This is used to automatically post accrued interest payable.

L

48

Reserve two accrued interest offset

Offset to amount 47; normally posted to interest expense.

L

51

Accrued service fee

This amount is the accrued service fee on sold loans calculated on an account to the next processing day or the first of the month; it is normally posted to accrued service fee receivable.

L

52

Accrued service fee offset

This is the offset to amount field 51; this amount is normally posted to service fee income (the same as amount field L-19 - service fees on sold loans).

L

53

Delinquent service fee

This amount is the accrued service fee that is more than 92 days delinquent or for which either the Non-Performing or Non-Accrual statuses are set up on the account. This amount is included in amount L-52. It may be posted as a deduction from accrued service fee income (reduction of L-52 accrued service fee).

L

54

Delinquent service fee offset

This is the offset to amount field 53. This amount is included in amount 51. It can be posted as a deduction from accrued service fee receivable (reduction of L-51 accrued service fee receivable) or a contra account.

 

paperclipnote

Note: Amount fields L-51 through L-54 are only for those institutions that charge service fees on sold loans. Any institution that wants their General Ledger to remain unaffected needs to set up amount fields L-51, L-52, L-53, and L-54 to be exactly like L-31, L-32, L-33, and L-34, respectively. If these fields have not been set up, the result will be Autopost errors on all accrued service fees on sold loans.

L

61

IN RM LOC

Credit field. This amount represents the institution's portion of the remaining line-of-credit amount. Normally posted to the institution remaining line-of-credit payable.

Organization option RLOC—Post Remaining Line-of-Credit to G/L—controls whether or not transactions for the remaining line-of-credit balances will be sent through to the General Ledger with amount fields 61, 62, 63, and 64.

When remaining line-of-credit processing is turned on (option RLOC = "Y"), the system will calculate the remaining line-of-credit amounts on all open loans with a payment method 5, 9, or 10. Remaining line-of-credit amounts for loans that are closed, unopened, or service released will not be posted to the General Ledger.

The system calculates the remaining line-of-credit amount differently depending on whether the loan is a non-revolving or revolving line-of-credit. If the loan is non-revolving, the remaining line-of-credit amount equals the Line-of-Credit Limit (LNRLCL) less the Total Amount Used (LNRLCU). If the loan is revolving, the remaining line-of-credit amount equals the Line-of-Credit Limit (LNRLCL) less the Principal Balance (LNPBAL).

For both non-revolving and revolving line-of-credit loans, if the calculated remaining line-of-credit amount is equal to zero, then no transaction will be posted to the General Ledger. If the calculated remaining line-of-credit is less than zero, the system will process the negative amount.

If the loan has a Portion Sold (LNISLD) then the investor portion of the remaining line-of-credit amount is determined by multiplying the calculated remaining line-of-credit amount by the portion sold. If the sold loan has multiple investors, the total investor portion of the remaining line-of-credit amount will be spread properly through each of the investors. The investor portion of the remaining line-of-credit amount is processed through amount fields 63 and 64.

The institution portion of the remaining line-of-credit amount is the total remaining line-of-credit amount less the investor portion. The institution portion of the remaining line-of-credit amount is processed through amount fields 61 and 62.

Two afterhours control groups are used to post the remaining line-of-credit amounts to the General Ledger:

 

"mmddyy18" – This control group posts the current day’s remaining line-of-credit amounts to the General Ledger.

"mmddyy19" – This control group reverses the remaining line-of-credit amounts posted to the General Ledger on the previous day.

L

62

IN RM LOC2

Debit field. Offset to amount field 61. Normally posted to the institution remaining line-of-credit contra.

L

63

IV RM LOC

Credit field. This amount represents the investor’s portion of the remaining line-of-credit amount. Normally posted to the investor remaining line-of-credit payable.

L

64

IV RM LOC2

Debit field. Offset to amount field 63. Normally posted to the investor remaining line-of-credit contra.

D

1

Net cash

Offset amount; the cash portion of a transaction.

D

2

Check In

Offset amount; the check in portion of a transaction.

D

3

Net journal

Offset amount; the portion of a transaction that is not cash or check.

D

4

Account balance

Amount that affected the balance of the account.

D

5

Federal withholding

Offset amount; the portion of the transaction that went to federal withholding.

D

6

State withholding

Offset amount; the portion of the transaction that went to state withholding.

D

7

Local withholding

Offset amount; the portion of the transaction that went to local withholding.

D

8

Penalty

Offset amount; the portion of the transaction taken as a penalty.

D

9

Interest

Offset amount; the portion of the transaction that is interest.

D

10

Fee

Amount of a transaction that should be posted into fee income; Normally posted by descriptor (posting field 30).

D

11

Money Order

Amount of a transaction that should be posted to money orders.

D

12

Travelers' Checks

Amount of a transaction that should be posted to travelers' checks.

D

13

Exchange Checks

Amount of a transaction that should be posted to exchange checks.

D

14

Cashiers' Checks

Amount of a transaction that should be posted to cashiers' checks.

D

30

Check out

Offset amount; the check out portion of a transaction.

D

31

Accrued interest on account balance

Amount of accrued interest calculated on an account to the next processing day or the first of the month. Used to automatically post accrued interest to the General Ledger. Normally posted to accrued interest payable.

D

32

Accrued interest offset

Offset to amount 31; normally posted to interest expense.

D

35

Negative deposit balance

Balance of any deposit account that is negative at the end of a processing day; normally posted to an asset account.

D

36

Negative deposit balance offset

Offset to amount 35; posted as a credit to the G/L account associated with the account balance (see Amount Field D-4 Account Balance).

O

1

Net cash

Offset amount; the cash portion of a transaction.

O

2

Check in

Offset amount; the check in portion of a transaction.

O

3

Net journal

Offset amount; the portion of a transaction that is not cash or check.

O

4

Entire transaction

The entire amount of the transaction.

O

5

Seller disbursement

Normally credited to the appropriate account based on the following TORCs:

TORC 000 - Seller disbursement via inside ACH transfer to a savings or loan account; a credit, normally stays in the clearing account. Will be offset with the deposit to the savings account or the payment to a loan.

TORC 060 - Seller disbursement by check; amount will normally be a credit to the bank account from which the check is drawn.

TORC 062 - Seller disbursement ACH to an outside institution; amount will normally be the credit to the bank account where ACH items are cleared.

O

6

Seller service fee

Credit amount to the service fee income account.

O

10

Fee

The portion of a transaction that should be posted to fee income.

O

11

Money order

Amount of a transaction that should be posted to money orders.

O

12

Travelers' checks

Amount of a transaction that should be posted to travelers' checks.

O

13

Exchange checks

Amount of a transaction that should be posted to exchange checks.

O

14

Cashiers' checks

Amount of a transaction that should be posted to cashiers' checks.

O

15

Bond Cash

Cashing of government bonds.

O

30

Check out

Offset amount; the check out portion of a transaction.

O

501

Foreign funds cash in

Offset amount; the foreign cash in portion of a transaction.

O

502

Foreign funds check in

Offset amount; the foreign check in portion of a transaction.

O

530

Foreign funds check out

Offset amount; the foreign check out portion of a transaction.

O

591

Foreign funds cash out

Offset amount; the foreign cash out portion of a transaction.

O

592

Foreign check in (in U.S. funds)

Offset amount; the foreign check in portion of a transaction (in U.S. funds).

O

601

Foreign funds exchange cash in

The cash in difference between foreign funds and U.S. funds of a transaction.

O

602

Foreign funds exchange check in

The check in difference between foreign funds and U.S. funds of a transaction.

O

630

Foreign funds exchange check out

The check out difference between foreign funds and U.S. funds of a transaction.

O

691

Foreign funds exchange cash out

The cash out difference between foreign funds and U.S. funds of a transaction.

©2020 GOLDPoint Systems. All rights reserved.