Financial Services

Financial Services

site header

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:

FAST filter funtionality to isolate Currency

Custom Column Filtering Currency

 

 

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