Coterminous transfer pricing of investments and borrowings is not required, but the results generally add to the quality of the model.

Usually this data is provided in a spreadsheet retrieved from an investment accounting system.

Four things are vital for setup:

1. A chart of accounts.
2. A list of centers (with descriptions and a listing of divisions, if appropriate)
3. A company list (if appropriate)
4. Financials showing account-level balances, preferably with summary level balances too.

We strongly recommend sending general ledger data after eliminations if you are a multi-company institution. This minimizes the need for you to provide significant guidance to our staff each period on an ongoing basis. If it is not possible, please instruct us how to do this processing.

There are several things we'll need every quarter. These are:

1. Financials. We will need a quarterly average balance sheet and quarterly income statement in order to prove the results we generate.
2. Elimination entries/worksheets (if applicable).
3. The general ledger extract as laid out below:

This data will be used for purposes of funds transfer pricing. Funds credit and charge rates are calculated at the customer account level.

Please generate this extract as soon as possible after the quarter ends. Many customers send this data in two files: One for demand accounts, one for time deposits.

Here is the field list we need. As always, please call us if you have questions.

This data will be used for purposes of funds transfer pricing. Funds credit and charge rates are calculated at the customer account level.

Please generate this extract as soon as possible after the quarter ends. Many customers send this data in two files: One for demand accounts, one for time deposits.

Here is the field list we need. As always, please call us if you have questions.

We will need a few things to set up processing for each of the quarterly files you will submit:

1. A record layout indicating which field is in which position
2. Application code definitions (including a list of GL centers and a chart of accounts)
3. Application/GL code mappings

Sending the quarterly data in a spreadsheet with the field headings in the first row is best, but a text file is fine. Please make sure the file is in ASCII format with Windows line endings (a carriage return and a linefeed character). If you do send quarterly data in a text file, please send a document listing how the data is laid out. For example, if it is a fixed-width text file, indicate the origination date is in position 436 for a length of 8 bytes (characters) and so on. We need to know the field order for comma-delimited files. Please explicitly use decimal points (i.e. a balance should be 661.25 not 66125). Also, put negative signs in front of the number if possible.

Most application systems use some means of indicating the type of account a customer has. Software vendors have several names for this: type code, class code, plan code, etc. We need a listing of what these are. Depending on other requirements which we will discuss in setup, we might need a few other code listings as well.

Because we need to allocate funds transfer pricing (and sometimes principal and interest) balances to the general ledger, we need to know how to map all the different application codes to general ledger accounts. This frequently called the GL interface.

Items 2 and 3 can be combined in a spreadsheet that looks like this (one per application):