Foreign Exchange Transaction Report (FPSDR093) |
  
|
Navigation: Deposit Reports > Deposit Reports - Numerical Order >
Foreign Exchange Transaction Report (FPSDR093) |
|
Availability
This report should run daily in the afterhours for those institutions that process foreign exchanges.
Purpose
The Foreign Exchange Transaction Report program reads tranlogs created from the GOLDTeller System during the day to create a report of the foreign exchange transactions run for the day.
Report Column Information
See FPSDR093 Example for an example of this report.
Column |
Description |
|---|---|
Tran Date |
This column displays the date the foreign exchange transaction was run. |
Trn Time |
This column displays the time the foreign exchange transaction was run. |
Tllr |
This column displays the teller number of the teller who ran the foreign exchange transaction. |
Trn Type |
This column displays the type of transaction that was run. This column shows whether the transaction was an exchange TO (to) U.S. funds or an exchange FM (from) U.S. funds. |
Cash In |
This column displays the foreign cash input amount (if any) from the foreign exchange transaction. |
Check In |
This column displays the foreign check input amount (if any) from the foreign exchange transaction. |
Difference |
This column displays the conversion difference between the Cash Inand Check In amounts. It also displays the amount converted to U.S. funds. |
Xcg Rate |
This column displays the rate used to convert U.S. funds to foreign funds or the rate used to convert foreign funds to U.S. funds. The rate used depends on the transaction used. |
Cash Out |
This column displays the foreign cash output amount (if any) from the foreign exchange transaction. |
Check Out |
This column displays the foreign check output amount (if any) from the foreign exchange transaction. |
Totals and Subtotals Provided
Subtotals (if used) are given for the institution to show the following:
1. Number of foreign exchange transactions
2. Foreign cash in
3. Foreign check in
4. Foreign exchange difference amount
5. Foreign cash out
6. Foreign check out
Totals are given for the institution to show the following:
1. Total number of foreign exchange transactions
2. Total foreign cash in
3. Total foreign check in
4. Net foreign exchange difference amount
5. Total foreign cash out
6. Total foreign check out
Sort Options Available
The default options for sorting are:
•Date (4)
•Time (3)
•Employee Number (5)
Sorting (and subtotaling) options available for this report are:
80 Transaction Date (4)
81 Transaction Time (3)
82 Employee Number (5)
83 Character Transaction Type (TO/FM) (2)