Navigation:  Loans > Loan Screens > System Setup Screens > Loan Funding Transactions Screen >

Setup of Funding Transactions

Navigation:  Loans > Loan Screens > System Setup Screens > Loan Funding Transactions Screen >

Setup of Funding Transactions

Previous pageReturn to chapter overviewNext page  Print this Topic

The following steps provide a generalized guideline for creating Loan Funding Transactions. These steps are for reference only. Most of these steps are completed before your institution converts onto GOLDPoint Systems.

 

1.In order to determine what funding transactions are needed, representatives from GOLDPoint Systems' Accounting and Loans departments should outline the entire open new loan process for each loan type with your institution's staff members of the same three areas of expertise.

 

2.Once the transaction needs are determined, the team can outline which transaction codes and field numbers should be assigned to each funding transaction.

 

3.Determine which Loan Field Numbers are necessary with each transaction. There are three sources of Loan Field Numbers:

 

The first is to store the Loan Field Number. The Loan Field Number identifies the monetary field in the Loan system that should be affected by the transaction. For example, if we wanted to increase Remaining Deferred Fees with a transaction code 510 (Field Credit), we would use Field Number 235 (Remaining Deferred Fees).

 

The second is to store the LIP Budget Description Code. We call it LIP budgets, but it's really any type of disbursement involved in opening a loan, such as insurance, dealer incentives, and   checks to the customer. For example, an LIP Budget Description code 1200 was created for Dealer Incentives owed back to the dealer once the loan is opened. We would set up a tran code 430 with Loan Field Number 1200, representing the disbursement to the dealer. LIP Budget Description codes are set up on the Loans > System Setup Screens > Construction Budget Descriptions screen

 

The third is to identify Amortizing Fee Codes used in tran code 910. For transaction code 910 (Amortizing Fee Credit), the Loan Field Number will be the amortizing Fee Code field (F1FEEC; loan posting field #25) found on the Loans > Amortizing Fees and Costs in CIM GOLD. The amortizing fee code can be up to four digits long.

 

4. Generally, the Loans in Process (LIP) system is used to record the various disbursements during loan funding. Therefore, organization option LBGT (Use Extended LIP Budget Features?) should be set to "Y." For each disbursement needed, an LIP Budget Description Code should be created/assigned in the Loan system in CIM GOLD on the Construction Budget Descriptions screen found under Loans > System Setup Screens in the tree-navigation. There are a few default LIP Budget Description Codes that we recommend using:

 

7000: Non-Cash Payoff or In-House Refinance
8001-8025: Check Sequences 1-25

 

paperclipnote

Note: It is the LIP Budget Description Code titles that are pulled to populate the Loan History Statement. Although the Description field allows for more characters, only 15 will appear on the Loan History Statement.

 

In the Category field on LIP Budget Description Codes, it is recommended that "Other" be entered to distinguish these codes from the other LIP items (as with true constructions loans).

 

5.The next step is to determine how many funding transactions are necessary for funding. There are two reasons that a new funding transaction is required.

 

First, if a G/L Debit or Credit transaction for the same Field posts to a different G/L account, then an additional funding transaction is required. For example, the Field LNCORG (Deferred Cost) posts to G/L account 2090 BR for consumer loans. The same Field posts to 2091 BR for mortgage loans. This example would require two different funding transactions: one for consumer loans loan types and one for mortgage loans loan types.

 

The second reason for a different funding transaction deals with the open new loan transaction (tran code 680). The Autopost requires that the Open New Loan transaction always be the first transaction when combining funding transactions using the Loans > System Setup Screens > Loan Funding Sets screen. Line-of-credit loans use the Undisbursed Balance field (LNUNDISB), for the open new loan transaction, while generally every other loan uses Principal Balance (LNPBAL). Because the Field for Open New Loan transaction differs between line-of-credit loans and regular loans, a separate loan funding transaction is required.

 

6.Begin creating the actual loan funding transaction. Remember, the first funding transaction in each Funding Set must be the Open New Loan transaction (tran code 680).

 

The LNPBAL Field Name is used to carry the amount of the open new loan transaction. Generally, this debit transaction should be offset with a Field Credit (510 tran code) to the LIP Balance (loan field number 98). After funding is complete, the LIP Undisbursed Balance (LNLBAL) will normally be zero, meaning the amount of the loan has been properly disbursed to all affected fields and General Ledger accounts. The LIP Disbursed Balance should match the Principal Balance on the loan when the loan is first opened.

 

7.Funding transaction must always be set up with two transactions: a debit and a credit. Generally, both transactions process by journal out/in (L-3 Net Journal by Transaction Origination Code (TORC) 0, D-3 Net Journal by TORC 347, or O-3 Net Journal by TORC 347). It is necessary to enter a G/L account number only for transaction codes 1800 and 1810 (G/L Debits and Credits). For all other transaction codes, the system will determine the corresponding Amount field and then read the Autopost Parameters to find the appropriate G/L account.

 

8.For check disbursements (tran code 430) should be offset with a G/L Credit transaction (tran code 1810) to the applicable G/L account where Accounts Payable checks were printed.

 

9.The following parameter substitutions are available for G/L Debit and Credit transactions set up on the Loan Funding Transactions screen: BR, CL, IG, IM, LP, OB, TL, TP, and UD (see Parameter Substitution). If G/L Debit and Credit transactions using parameter substitutions cannot process to a G/L account (because it is inactive or does not exist), the G/L suspense account in the organizational options (GLLS) will be posted to instead. Additionally, the Autopost Recap Report (FPSDR016) will list the transaction and the G/L account the funding rule attempted to post to with the messages "ACCT NOT FND" and "GTPC SUSP: NOT TOTALED."

 

10.The Reference Number field should be filled with "LNXXXXXX" in order for the loan account number to be passed to the Reference Number field in history and for G/L Debit and Credit transactions to carry the loan account number on the Autopost Resolution Detail Report (FPSDR205). Additionally, if organization option GLPA (Loan Account#/ GTPC Payee in the G/L Payee Field) is set to "Y," then the loan account number associated with transactions flowing to the General Ledger through the Autopost will be passed to the Payee field in the General Ledger. The loan number will be the last 12 positions of the Payee field and will be displayed as "#OOOOAAAAAA," where "OOOO" is the four-digit office number and "AAAAAA" is the six-digit account number. 

 

11.The Description field from the debit and credit transactions is passed to the Autopost Resolution Detail Report (FPSDR205) and to the G/L Description field in the transaction history (as long as the Summarize on Recap checkbox has not been selected in GOLD Services > Autopost Setup > Autopost Parameters). However, if the Description field is left blank, the words, "DESC IS BLANK" will be passed to the G/L Description field to notify the funding rule administrator that a description was left blank.

 

12.Obtain a list of loan types that would be funded and determine which loan patterns are used to board these loan types. If using Loan Gateway to board loans, the loan types are connected to loan patterns using the Loans > System Setup Screen > Loans > System Setup Screens > Gateway Patterns screen. GOLDAcquire Plus ties loan types and patterns together as well. See the GOLDAcquire Plus User's Guide for more information.

 

13.Verify with the loan personnel that the appropriate loan patterns are pointed to the Gateway Patterns and GOLDAcquire Plus programs. Then determine which Loan Funding Set is assigned to each pattern.

 

14.After the loan patterns, funding transactions, and funding sets are created, intense testing by GOLDPoint Systems and your institution's teams should occur to verify that the monetary amount fields on the loan are populated, corresponding G/L entries occur, and that any other G/L debits/credits post appropriately. In addition, the boarded loan system information (such as loan type, payment method, general category, etc.) should be verified for accuracy.

 

15.To print a report that lists the Loan Funding Transactions, right-click the list view and select "Printing > Print Preview" or "Export > Export to Report Manager."

©2020 GOLDPoint Systems. All rights reserved.