FAST - Exchange Rate, Currency and Foreign Amount fields added to Transaction Details Revenue and Expense Report
Three new fields have been added to the Transaction Details Revenue and Expense report in FAST. The addition of Exchange Rate, Foreign Amount and Currency columns will provide insight into foreign currency transactions.
Finance Reporting - Transaction Details Revenue and Expense - Transaction Lookup (Actuals) (Data as of 23/03/2018 |
||||||||
SETID = QUNIV| FUND = 10000| DEPT = 99999| ACCOUNT = 6% | DATE FROM = Jun-2017 | DATE TO = Jun-2017 |
||||||||
AMOUNT |
PERIOD |
YEAR |
JOURNAL ID |
LINE DESCRIPTION |
Ref# |
EXCHANGE RATE |
FOREIGN AMOUNT |
CURRENCY |
2,479.50 |
02 |
2018 |
AP00295062 |
LEXISNEXIS INC 999999 |
;01234567 |
1.00 |
2,479.50 |
CAD |
41.91 |
02 |
2018 |
AP00295062 |
USA Co-152336 |
02345678 |
1.32 |
31.67 |
USD |
1,529.90 |
02 |
2018 |
AP00295062 |
Walmart - 34567 |
03456789 |
1.32 |
1,156.21 |
USD |
702.20 |
02 |
2018 |
AP00295062 |
Grand & Toy - 234567 |
01212345 |
1.00 |
702.20 |
CAD |
62.60 |
02 |
2018 |
AP00295062 |
USA Co-154988 |
01212435 |
1.35 |
46.52 |
USD |
180.15 |
02 |
2018 |
AP00295062 |
USA Co-154989 |
01212436 |
1.35 |
133.40 |
USD |
201.75 |
02 |
2018 |
AP00295062 |
Walmart - 34777 |
01212437 |
1.35 |
149.94 |
USD |
343.00 |
02 |
2018 |
AP00295062 |
USA Co-166780 |
01212438 |
1.33 |
258.52 |
USD |
How can I isolate foreign currency transactions?
You can use the filter functionality in FAST to isolate Currency types by applying a filter on the Currency column:
Finance Reporting - Transaction Details Revenue and Expense -Transaction Lookup (Actuals) (Data as of 27/03/2018 |
|||||||||
SETID = QUNIV| FUND = 10000|DEPT = 99999| ACCOUNT = 6%| |
|||||||||
DATE FROM = Jun-2017 |DATE TO = Jun-2017| CURRENCY NOT LIKE CAD |
|||||||||
AMOUNT |
PERIOD |
YEAR |
JOURNAL ID |
LINE DESCRIPTION |
Ref# |
EXCHANGE RATE |
FOREIGN AMOUNT |
CURRENCY |
|
41.91 |
02 |
2018 |
AP00295062 |
USA Co-152336 |
02345678 |
1.32 |
31.67 |
USD |
|
1,529.90 |
02 |
2018 |
AP00295062 |
Walmart - 34567 |
03456789 |
1.32 |
1,156.21 |
USD |
|
62.60 |
02 |
2018 |
AP00295062 |
USA Co-154988 |
01212435 |
1.35 |
46.52 |
USD |
|
180.15 |
02 |
2018 |
AP00295062 |
USA Co-154989 |
01212436 |
1.35 |
133.40 |
USD |
|
201.75 |
02 |
2018 |
AP00295062 |
Walmart - 34777 |
01212437 |
1.35 |
149.94 |
USD |
|
343.00 |
02 |
2018 |
AP00295062 |
USA Co-166780 |
01212438 |
1.33 |
258.52 |
USD |