Enhanced interface

Revaluation report

Revaluation reports are a part of the month-end workflow to accrue for unrealized AP and AR and General Ledger gains and losses or realized Cash Management gains and losses.

These reports help you calculate unrealized currency gains and losses. Gains and losses are computed on a transaction-by-transaction basis using a selected exchange rate for comparison. This is usually the ending exchange rate for the period, and is always a "best guess" for the final transaction. Foreign currency transactions are recomputed by account, using the selected exchange rates.

Revalue inter-entity transactions by including your inter-entity accounts in your General Ledger revaluation report.

The Revaluation report is available for multi-currency companies.

The filter settings allow you to choose a revaluation as of date, and select the appropriate exchange rate type. The report itself organizes the data by bank account.

The revaluation process is explained in detail in Foreign Currency Revaluation.

Subscription	Cash Management
User type	Business, Project Manager, Employee
Permissions	Revaluation Report: Run

Revaluation overview

If your company has multi-currency transactions as well as foreign-currency current accounts and savings accounts, this report provides data for revaluing those accounts to accrue for unrealized gains or losses, usually due to foreign-currency exchange-rate fluctuations.

This report provides you with the information you need to book the necessary entries. With the report data in hand, you can make journal entries that compensate for the fluctuations on a monthly basis.

1. AR sales invoice sent

Company in UK sells an order to a French customer in Euros
UK company sends a foreign currency AR sales invoice due in 90 days
Current exchange rate: 1 EU = 0.92 GBP

2. AR sales invoice paid

French customer pays in EU 90 days later
30-day exchange rate: 1 EU = 0.94 GBP
60-day exchange rate: 1 EU = 0.93 GBP
90-day exchange rate: 1 EU = 0.91 GBP

3. Book difference

Create revaluation report to show the difference in gain or loss for each month
Create the Journal Entry in the appropriate journal for each month

Best practices

Run the revaluation report as of a specific date.
Post a non-reversing journal entry at the end of the month to “true up” the General Ledger balance with the real world value of the bank account.

You want to generate your revaluation report and make sure it ties to the GL as you move forward. Most likely, your situation is one of the following:

You just moved to Sage Intacct and already have a bank account with a base currency.
You opened a new bank account and selected a currency other than your base currency for that account.

To create a revaluation report that successfully ties to the GL:

Verify that you have a beginning balance in your company in your base currency.
At the end of the month run the revaluation report. Make sure the revaluation As of date is the last day of the month for the period you want it to cover. The result of the report will be a net gain or loss.
Create a journal entry as of the last day of the month to accrue the gain or loss. For example, if the month you are covering is June, 2017, on July 1, 2017 you would revalue for the unrealized gain or loss with a journal entry dated 6/30/2017.

The sum of Reval base amount should equal the General Ledger balance for the bank account. If the amounts aren't equal, view troubleshooting for the probable cause.

Repeat this process every month. Remember, you do not reverse the gain/loss entry.

To successfully tie to the GL:

You have already established a beginning balance in your base currency, and want to generate your revaluation report and make sure it ties to the GL as you move forward. Your situation is one of the following:

you are just moving to Sage Intacct and already have a bank account with a base currency.
you opened a new bank account and selected a currency other than your base currency for that account.

At the first day of the month run the revaluation report. Make sure the revaluation As of date is the last day of the previous month for the period you want it to cover. The result of the report will be a net gain or loss.
Create a journal entry as of the last day of the month to accrue the gain or loss. For example, if the month you are covering is June, 2018, then you would revalue for the unrealized gain or loss with a journal entry dated 6/30/2018.

The sum of Reval base amount should equal the General Ledger balance for the bank account.

Repeat this process every month. Remember, you do not reverse the gain/loss entry.

View the monthly report

Go to Cash Management > All > Reports > Revaluation.
On the report settings page, select View.

The report displays all results for the default reporting period.
To refine the report, select Customize and follow the procedure in the next section.

Customize and run

Before running the report, you can select the time period and types of items to include as well as specify how you want the report to appear.

Use trial-and-error to get the precise results you want.

Fill in the desired boxes, and select View to see the report. If after viewing the results you want to refine the report further, select Customize to return to the report setup page. Repeat this process until you're satisfied. For complex financial reports you plan to run regularly, select a reporting period and memorize the report when you're done setting it up. Just change the As of date before running the report next time.

Time period

You can use one of the pre-defined reporting periods available from the Reporting period and As of date boxes, or create your own reporting period using the Start date and End date boxes.

Set the time period

In the Time Period section, do one of the following:
- Select the Reporting Period down arrow, and then select the time period you want.
- Enter an As of Date (the date that the system will use as a baseline for the period you select. Leave blank for today's date).

If you complete all the time period boxes (that is, if you fill in the Reporting period and As of date boxes in addition to the Start date and End date boxes), the system bases your report only on the specified start and end dates. It ignores the Reporting Period and As of Date specified.

The following table describes each item in the Time period section of this report settings page:

Time Period Box	Notes	Limitations
Reporting period	These periods are relative to the As of date. All periods begin on the first day of the period, the first day of the month, quarter, or /year.	Only works with As of date. Does not apply if you select a Start date or an End date.
As of date	The date used as a baseline for the reporting period you select. Leave this box blank to use today's date.	Only works with Reporting period. Does not apply if you select a Start date or an End date.
Start date, End date	Leave the Start date blank to include all information from the earliest date you entered data into your company up to and including the end date. Leave the End date blank to include all information from the start date up to today.	The format must be MM/DD/YYYY.
Prompt on run	Select this checkbox to force you (or anyone using this report) to enter a location, department, and/or time period before the report will run.

Report filters

Use the filters to focus the results of your report. In effect, filters enable you to isolate and assemble just the data you want. You can set any combination of filters.

Filters the report

The following table describes each item in the Filters section of this report settings page:

Filter Box	Notes
Revaluation as of date	This setting is mandatory and significant. It instructs the system to calculate the exchange rate gains/losses as of a particular date regardless of the date on which you run the report. For example, say you want to revalue transactions for January, but you are running the report in February. You would enter a revaluation date as of January 31.
Revaluation exchange rate types	If you created any custom exchange rate types (that is, exchange rates other than the standard Intacct Daily Rate), you can filter the data on those types.
Bank	Leave this blank to retrieve data for all checking and savings accounts, or choose a single one.
Location	Appears only for multi-entity shared companies with multiple base currencies. Reports run at the top level require a location so that the system can determine the appropriate currency.
Show for	Appears only for multi-entity shared companies. The following choices cause the report to display transactions for certain locations regardless of the location you have chosen in the Location field. For example, you have the following structure: USA > California > Bay Area > Los Gatos. All locations: Shows transactions for California > Bay Area > Los Gatos This location: If you are in the California entity, shows transactions for California, regardless of what you select in the Location field. Child locations: If you are in the California entity, shows transactions for Bay Area and Los Gatos only. For multi-entity shared companies with multiple base currencies. Reports that you run at the top level require a location, so the system can determine the appropriate currency.
Show details	This checkbox is selected by default, which shows more columns and lines for individual transactions. Clear this checkbox if you want to see data that is summarized.

Formatting

Use this section to change the page layout for this report.

To format the report

To change the page layout, select the Page orientation dropdown list, and then select either Portrait or Landscape.

The following table describes each item in the Format section of this report settings page:

Format	Description
Page orientation	Portrait is the default layout. Portrait: display or print the report pages vertically Landscape: display or print the report pages horizontally

Format

Description

Page orientation

Portrait is the default layout.

Portrait: display or print the report pages vertically

Landscape: display or print the report pages horizontally

Titles and footer

Titles, subtitles, and footers apply only to the .pdf version of this report. (Select Print to get the .pdf version).

What's in this report

The default Revaluation report consists of the following columns:

Report column heading	Description
Bank account and Currency	These two columns show the names of the bank accounts along with their foreign currencies. You might have opted for all your bank accounts in the filters section, or you might have chosen a single account.
Transactions	The list of transactions affecting the cash account that were entered against the Bank Account in the bank currency.
Balance	The beginning account balance for the period.
Date	The date of the transaction.
Exchange rate	This is the exchange rate on the date of the transaction. The exchange rate shown here is what you selected in the filter page.
Base amount	The foreign currency amount converted to your company base currency.
Reval exchange rate and Reval base amount	These columns are similar to the Exchange rate and Base amount explained previously, except that they show the correct values on your as of date.
Gain/Loss	The gain or loss as computed on the selected exchange rate type.

You can select any link to drill down to the details.

Troubleshooting

Scenario: The General Ledger and Cash Management Revaluation report do not tie.

Probable cause: The GL contains entries for transactions that weren't entered in the bank currency. Such transactions won't show up in the Cash Management Revaluation report.

Example:

Company/Entity Base Currency: USD
Bank currency: CAD
Journal entry entered in EUR currency.

GL transactions entered in a currency other than the bank currency won't show up on the Cash Management Revaluation report, and will result in the GL and CM Revaluation report failing to tie. We recommend that you convert such transactions to either CAD or USD, and make a journal entry correction.