Importing Data from OnePoint

See Also...
 

If you have OnePoint, you can set up your Third Party options so that a user can initiate a business application from within OnePoint. A new business application is started in Baker Hill Origination that contains information retrieved from the customers' OnePoint records.

This feature will create new applications only; you will not be able to add information to existing business applications.

The user must have the appropriate access rights in both OnePoint and Baker Hill Bank2Business to use this functionality.

Note: To use this feature, you need a file called B2bimport.exe, which is available for Baker Hill Origination administrators to download from Online Resources.  (Go to http://www.bakerhill.com/clientlibrary/or/document.aspx?ID=479872. You'll need to log in with the user name and password given to you. If you don't have a user name and password for the Online Resources, you can request one by completing the form at http://www.bakerhill.com/clientlibrary/or/Register.aspx.) Make note of the directory in which you copy this file (where you put it is not important, as long as your users computers can access the path).

Baker Hill OnePoint Doc Prep

You may perform a Doc Prep export from the Activities menu while the main customer screen is open. Data from your Baker Hill OnePoint customer record will partially populate a new small business application in Baker Hill Origination. The partial population will include general business information, principal information, and financial statement (STAN) information.

Note: Not all product types in Bank2Business require financial statement information. Product types that do not require the information will not display any statement information that may have been available in Baker Hill OnePoint.

Follow these steps in Baker Hill OnePoint:

  1. Access the customer for whom you want to create a small business application.

  2. Make sure the customer screens that contain the information you're exporting (main customer screen, customer contact screen, and so on) are completed and accurate.

    Note: Missing or inaccurate information may be edited in either the customer's Baker Hill OnePoint record or in the new loan application created in Baker Hill Origination.

  3. While the main customer screen is open, choose Activities > Doc Prep from the Baker Hill OnePoint menu bar.

  4. At the bottom of the Doc Prep screen, select the Bank2Business option (the exact name of the option may differ, depending on your setup).

  5. Click the Principals button on the Doc Prep screen.

  6. Select the first contact you wish to include as a principal in the Available Contacts box and then click the right-pointing arrow between the boxes to move that contact into the Selected Principals box.

    To deselect a selected principal, click the principal's name in the Selected Principals box and then click the left-pointing arrow.

    The double-pointing arrows move all contacts from one box to the other.

    Note: Only names in the Selected Principals box will have credit reports retrieved when Origination processes the application.

  7. Click OK to return to the Doc Prep screen.

  8. Click the Submit button at the top of the Doc Prep screen.

  9. Click OK on the confirmation message that appears. Your browser should launch automatically (see the next section of this document).

    Note: If you don't see the confirmation message, the Doc Prep export may not have completed successfully. The most common reasons for an unsuccessful Doc Prep operation are an out-of-balance STAN statement and/or a STAN industry that is not supported.

    Note: The first time you use the Doc Prep feature for Baker Hill Origination, a dialog box will appear, prompting you for your user name and password (along with other information). After you complete this dialog box, your browser starts up.

Submitting the Doc Prep Export

The first time you submit the Doc Prep export, you'll be prompted for your user name and password. Following any subsequent exports, Baker Hill Origination will automatically launch, bypassing the login page, and generate a new application for the OnePoint customer.

The first page that appears is the New Application page. Select the product or products for the application and then click Continue. Fill out and submit the application as you normally would.

See the next section for information on which fields are retrieved from the customer's Baker Hill OnePoint records into the small business application.

Baker Hill OnePoint Data Entry

Proper data entry into your Baker Hill OnePoint database is critical to getting the most out of the Doc Prep functionality. This section specifies the fields that impact the Bank2Business import.

Please note that the Doc Prep functionality performs no verification of the data it extracts; it simply imports the data that is available. If you are not familiar with the customer record from which you are performing a Doc Prep operation, be sure to review the data either prior to importing to Bank2Business or after importing (but before submitting the application).

General Business Information

Fields from Baker Hill OnePoint are imported into the General Business Information section of the small business application as described in the following table.

Note: The main customer screen is typically the first screen you see in Baker Hill OnePoint, containing the customer number, name, address, and other general information.

This Origination field ...

... is populated with this Baker Hill One Point Data

OnePoint Field Name

OnePoint Screen

Additional Information

Business Address

Address

Main customer screen

For Baker Hill Origination purposes, the last line of the address must be the City, State, and Zip line.

Brief Business Description

Business Type

Main customer screen

 

Legal Name

Customer Name

Main customer screen

 

Federal Tax ID

Customer Number

Main customer screen

 

Doing Business As

Doing Business As

Main customer screen

 

Main Business Fax

Fax

Main customer screen

 

Main Business Phone

Phone

Main customer screen

 

SIC Code

SIC Code

Main customer screen

If your OnePoint database uses NAICS codes rather than SIC, the code entered in the NAICS code field will not be imported into the Bank2Business application (although the Business Type field will still be imported).

Experian / D&B D-U-N-S Number

DUNS Number

Dun and Bradstreet Information

From the main customer screen, choose Activities > Dun and Bradstreet to reach the Dun and Bradstreet Information screen.

Average Checking Balance

DDA Balance

More Customer Info

From the main customer screen, click the More button to reach the More Customer Info screen.

Date Business Established

Year Started

More Customer Info

Baker Hill Origination uses January 1 of the year specified.

Present Management Since

Years As Owner

More Customer Info

Baker Hill Origination subtracts the number specified from the current year and uses January 1 as the date.

Principals and Guarantors

Fields from Baker Hill OnePoint are imported into the Principals/Guarantors section of the Bank2Business application as described in the following table.

This Origination field ...

... is populated with this Baker Hill OnePoint Data

OnePoint Field Name

OnePoint Screen

Additional Information

Percent Ownership

% Owner

Customer Contact Information

From the main customer screen, click the Contacts button and then select a contact to add or edit to reach Customer Contact Information.

Other Income

Addl Income

Customer Contact Information

Baker Hill Origination calculates the monthly figure if the Income Per field is not Monthly.

E-mail

E-Mail

Customer Contact Information

 

Salary

Income

Customer Contact Information

Baker Hill Origination calculates the monthly figure if the Income Per field is not Monthly.

Principal Name

Name

Customer Contact Information

 

Social Security Number

SSN

Customer Contact Information

 

Title

Title

Customer Contact Information

 

Date of Birth

Birth Date

More Customer Contact Information

From the Customer Contact Information screen, click the Home button to reach the More Customer Contact Information screen.

Home Address

Home Address

More Customer Contact Information

For Baker Hill Origination purposes, limit this address to two lines only, with the second line containing City, State, Zip.

Mortgage/Rent Payments

Mthly Housing

More Customer Contact Information

This field is used in Baker Hill Origination regardless of whether the customer owns or rents.

Home Phone

Phone

More Customer Contact Information

 

Business Financial Information

Note the following about Doc Prep exports of STAN data:

If the most recent period is an annual period (12 months long): Doc Prep will extract it and will also include the prior period if the prior period is also 12 months long (only these two periods will be extracted).  

If the most recent period is an interim period: Doc Prep will look at the prior period. (a) If the prior period is not an annual period, it is not included; (b) If the prior period is an annual period, it is included, and then Doc Prep looks at its prior period. If this next period is also an annual period, it is included as well. In this case, Doc Prep will extract three periods: one interim period and the two prior annual periods.  

An interim period will not be extracted by Doc Prep unless it's the most recent period.

Fields from Baker Hill OnePoint are imported into the Consolidated Financial Statement of the Bank2Business application as follows. (A colon indicates a summed range of lines.)

This Origination field ...

... is populated with this Baker Hill OnePoint Data

STAN Field(s)

GEN Lines

COR Lines

SMB Lines

1 Cash and Liquid Assets

Cash and equivalents

1:3

1:3

1:2

2 Accounts Receivable

Net trade receivables

5 + 11

5 + 11

4:6

3 Inventory

Inventory

27

27

16

8 Fixed Assets

Net plant and equip

58

58

34

9 Intangible Assets

Intangible Assets

71:72

71:73

41

10 Other Assets

Other current assets

6:10 + 15:19 + 29:33

6:10 + 15:19 + 29:33

5 + 10:11 + 18:20

14 Accounts Payable

Trade accounts payable

87

89

52

16 Notes Payable - Other

Notes payable

77:79

78:80

46:47

17 Taxes Payable

Taxes payable

107

109

64

23 Long-Term Debt

Current long-term debt

80:85

81:85

48:50

24 Other Liabilities

Other current liabilities; Other long-term liabilities

76 + 88:92 +105 + 108:111 + 115:121 + 125:132

77 + 90:94 + 107 + 110:115 + 119:126 + 130:136 + 140:141

45 + 53 + 62 + 65 + 72 + 74:77

30 Net Sales

Net sales

158

177

100

31 Cost of Sales

Cost of sales

160:165

179:184

102:105

36 Selling, G&A Expenses

Selling, general & admin. Exp.

169:170

188:189

109

32 Interest Expense

Annual interest expense

197:198 (217:220)

197:198 (217:220)

128:129

33 Depreciation & Amortization

Depreciation and amortization

165+ 179:180

194 + 199:200

105 + 114:115

34 Business Rent Expense

Rental Expense

172

192

111

38 Other Expenses

Other operating expense

178 + 181

190 + 198 + 201

113 + 116

35 Officers' Salaries

Officer/director/owner compensation

171

191

110

42 Taxes

Taxes

209:210

232:233

137:138

 

© 2016 Baker Hill Solutions, LLC