Unrealised Gain/Loss Report

If you are using the Foreign Currency module, this report prints a summary of the foreign exchange losses and gains as at a specified date.

Header Details

Report process date and time
As at Date
Page number

Line Details

This information displays for each customer:

Customer code
Customer name
Customer's currency code
Multiple or divider of the currency code
Foreign outstanding value
Average rate
Original local outstanding value
Current rate
Current local outstanding value
+/- Loss/Gain value

The report summarises information and display sub-totals based on the profile selected in the report parameters. Options include:

Customer code
Customer name
Branch/Customer code (sub-total by branch and customer)
Branch/Customer name
Currency/Customer code
Currency/Customer name

The report also displays a grand total of all customer balances.

Parameters

You can set these parameters for the report:

Branch Code From

Enter the code for the first branch in the range of branches to include in the report.

Branch Code To

Enter the code for the last branch in the range of branches to include in the report. To report on a single branch, leave this field empty.

Leaving the Branch Code From field empty and entering zzzzzz in this field includes all branches in the report.

As At Date

Select the date on which to report losses and gains.

Currency Code From

Enter the code for the first currency in the range of currencies to include in the report.

Currency Code To

Enter the code for the last currency in the range of currencies to include in the report. To include a single currency code in the report, leave this field empty.

Leaving the Currency Code From field empty and entering zzz in this field includes all currencies in the report.

From Customer Code

Enter the code for the first customer in the range of customers to include in the report.

To Customer Code

Enter the code for the last customer in the range of customers to include in the report. To report on a single customer, enter a code in the From Customer Code field and leave this field empty.

Leaving the From Customer Code field empty and entering zzzzzz in this field includes all customers in the report.

Exclude Zero Balances

Select this option to generate the report without transactions that have zero balances.