Navigation: GOLD Services > GOLD Services Screens > General Ledger Screen Group > Autopost Parameters Screen >
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.
|
||
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).
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.
|
||
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. |