Create the File for Transfer

Use a spreadsheet program to create a file containing financial transactions.

Requirements:

Use an asterisk (*) in any field that has no data value. This lets the software knows how to align the various blank data fields.
The format for dates must meet the specifications outlined in the File Format pages.

Below is an example of a set of ISD (TC65) transactions created on an Excel spreadsheet. The fields are in columns and the Financial data in rows.

                       Figure 1 -- Spreadsheet Sample (Excel)
                        
# A   B    C    D      E      F      G H   I       J       K     L M N       O   P      Q     R
-----------------------------------------------------------------------------------------------
1 65 12345 1 5/21/92 66-8801 9620-77 * * 990010 01-8801 03-46-00 * * *   $190.00 *     3-1234 N
2 65 12346 2 5/22/92 66-8801 9620-77 * * 990010 01-8801 03-46-00 * * *    $95.00 *   543-1234 N
3 65 12346 3 5/29/92 66-8801 9620-77 * * 990010 01-8801 03-46-00 * * * $7,809.00 * 2065431234 N

Create a file (from a spreadsheet like the one above) that contains no headings or totals, with each field separated by one or more spaces. This is what we call a a Space Delimited File. An example follows:

                     Figure 2 -- Space Delimited Saved Data (from Excel)
                      
65 12345 1 5/21/92 66-8801 9620-77 * * 990010 01-8801 03-46-00 * * * $190.00 * 3-1234 N
65 12346 2 5/22/92 66-8801 9620-77 * * 990010 01-8801 03-46-00 * * * $95.00 * 543-1234 N 
65 12346 3 5/29/92 66-8801 9620-77 * * 990010 01-8801 03-46-00 * * * $7,809.00 * 2065431234 N

The above example has each field separated by at least one space, contains no headings or totals, and has an asterisk in each field with no value.

Certain rules apply to the creation of a file for transfer to FasTrans:

Space-delimited:
- The file generated for uploading is space-delimited, i.e., with each field separated by one or more spaces.
- Space-delimited filenames must start with the letter F
- The number of spaces between fields is not significant, i.e., column positions are not fixed.
Fields:
- No fields may be omitted, since the sequence of fields determines their meaning.
- Use an asterisk (*) to indicate there is no value in the field.
Files:
- You may use upper-case or lower-case letters. The software will convert all lower-case text to upper-case during the FAS loading process.
- Each file should only contain one type of transaction, i.e., ISDs or CTIs.
- Each file should contain transactions for one accounting month, i.e., ISDs for month 06 should be in one file; ISDs for month 07 must be in another.
- You may submit multiple files on any given day or month.
Other Notes:
- Review the file formats carefully for the transaction type(s) being used. In some case dollar amount fields require a decimal point followed by exactly two digits, while in others no decimal point is required. Generally the following will be accepted:
  - Leading $
  - Leading zeroes
  - Leading or trailing sign (+ or -)
  - Embedded commas
  - Surrounding matching parentheses (indicating a negative amount)
  Examples of valid dollar amount fields:
```
 
$123.45
$1,234.56
000123.45-
+001,234.56
($234,567.98)
 
```

Fixed Format Files

Central office users and heavy volume users of FasTrans may use a Fixed-Length Format for their files for transfer. You can find out more about this format in the section Fixed-Length File Formats.

FASTRANS Create Format Name Transfer Submit

Create the File for Transfer

Create a space-delimited file

Certain rules apply to the creation of a file for transfer to FasTrans:

Fixed Format Files