Enhanced interface

AP Open Items 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.

For example, suppose at the end of your last reporting period, you stated an AP transaction value at $100 USD, but now it's valued at $96 due to currency fluctuations. Because you have to pay $4.00 less, you have an unrealized gain of $4.00 relative to the amount you previously stated ($100).

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

Who typically needs this report?

Companies that use foreign-currency transactions
Accountants, controllers, those responsible for managing the company’s financials.

For information on terms that may differ in your location, see Terminology across locales.

To generate this report, go to Accounts Payable > All > Reports > AP open items revaluation.

Subscription	Accounts Payable
User type	Business, CRM
Permissions	Run AP Open Items Revaluation Report

View a monthly report

When the report page loads, select View. A report showing all results for the month to date appears in your browser.
To refine the report, select Customize to return to the main report page and follow the steps in Customizing and Running This Report in the next section.

Customize and run

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

If you want to see every result for a particular category, do not make selections from any of the data entry boxes. You can run this report without entering any search information. If you do that, however, the report may take a long time to run and may return too many results to be useful.

To customize and run a report:

Set the filters to get the specific data you want.

Filters enable you to include or exclude specific types of data in the report, such as customer, item, UPC, value, or account. As a general rule, to get fewer and more precise results in your report, set more filters.
Format the report.

Format options will vary from report to report. Generally you can set the layout of the report and arrange how to group and display the data contained in the report.
Enter a title, subtitle, and footer for your report.

Do one of the following:

How to work with reports
To:	Select:
View the report now, in your browser.	View
Display the report in PDF format so you can print it or save it to your local drive.	Print
Generate the report and store it for later access. Available formats include HTML, printable (PDF), Excel, CSV (comma-separated value), and Text. Reports can be stored: In Intacct In the My stored reports list Delivered to a cloud storage location, such as Dropbox Learn more about processing and storing reports.	Process and store
Add the report to your dashboard.	Add to dashboard
Memorize (that is, save) the report in the Memorized reports list so that later you can refer back to it or modify and re-run it. You can schedule memorized reports to run on a recurring basis. Intacct can automatically email the reports or deliver them to a cloud storage location.	Memorize
Export the report to a separate file that you can then distribute or save to your local drive. Available file formats vary among reports.	Export

After you run a report, you can either email it to others or return to the Report Settings page to refine the results.

Share and refine reports
After running the report, to...	Select
Email the report to others.	Email
Return to the main report page and refine the report further.	Customize

For example, suppose at the end of your last reporting period, you stated an AP transaction values at $100 USD, but now it's valued at $96 due to currency fluctuations. Because you have to pay $4.00 less, you have an unrealized gain of $4.00 relative to the amount you previously stated ($100).

This report is available to companies that use foreign-currency transactions.

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.

To customize your report results, change the filters as follows:

To calculate the exchange rate gains or losses as of a particular date, enter the date in the Revaluation as of date field, in mm/dd/yyyy format.
To filter your data on a custom exchange rate type, select the custom type from the Revaluation Exchange Rate Types dropdown menu.
To use transactions based on the document dates, select Document Date. To use transactions based on the date the transactions post to the GL, select GL Posting Date.
To show results for a specific supplier or range of suppliers, use the From Supplier and To Supplier dropdowns.
To show results for a specific supplier type, select the Supplier Type dropdown, then choose the supplier type you want the report to include, such as consultants and distributors.

The following filter options display only if you work in a multi-currency and multi-entity environment:

To filter by a specific currency, select the currency from the Transaction Currency dropdown.
To filter the report by geographic location, type the name of the region, country, state or territory, or city in the Location box, or select the down arrow, and then select the location you want from the list that appears.

You must enter or select a location to run this report at the top level. The location you specify is used to determine the appropriate currency.
To filter the report by department within the company, enter the name of the department in the Department box, or select the down arrow and then, from the list that appears, select the department you want.
If you want the report to cover certain locations regardless of what you select in the Location box, use the Show For field. To do this, in the Show For field, select the down arrow and then select the locations you want the report to cover:
If you want the report to include data for all locations regardless of the entity you're currently using, select All Locations.
Do one of the following:
- If you want the report to include data only for the entity you're currently using, select This Location.
- If you want the report to include data only for locations that are child locations of your current entity, select Child Locations. For example, if your current entity is California, and you have child locations for San Francisco and Los Angeles, use this option to have the report include data only for Los Angeles and California.

To show results for cheques from a specific location, disregarding the location selected in the Location dropdown, use the Show For dropdown.
Select either Summary or Detail, depending on how much information to include in the report.

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

Filter Box	Notes	Limitations
Revaluation As Of Date	The date on which the revaluation was performed
Revaluation Exchange Rate Types	The revaluation exchange rate type: Intacct Daily Rate or custom type
Based on	Includes data based on the exchange rate as of either the document date or the GL posting date, whichever you select
From Supplier, To Supplier	Includes data only for a specific supplier or range of suppliers. By default these boxes are blank, which means the report will include all suppliers.
Supplier Type	Include data only for the type of supplier specified. By default this box is blank, which means the report will include all supplier types.
Transaction Currency	The currency in which the transaction was paid
Location	Enables you to limit report results to a specific location.	Only appears for multi-currency, multi-entity companies.
Department	Enables you to limit report results to a specific department.
Individual Report	Select this checkbox if you want each entity or department and/or location to have its own report.	Due to their potentially large size, reports with departments and locations on individual pages can be run offline only. Therefore, if you select the Individual report option, you can select only Process and store. When you select Individual reports, all of the individual reports are contained in a single report or Excel workbook.
Prompt on Run	Select this checkbox to force you (or anyone using this report) to enter a location, department, and/or time period before it will run the report.
Show For	Select to show different views of the data, based on the location or entity you choose: All locations: This option shows the data that's posted to the location or entity and its children. This location: This option shows only the data that's posted to the location or entity you select. The data posted to any child location is not shown. Child locations: This option shows only the data that's posted to the child locations of the location or entity that you select. Any data that's posted to the parent location or entity is not shown.	Example: Suppose your location is United States > California > San Francisco. All locations would show transactions for United States, California, and San Francisco. This location would show transactions for United States. Child locations would show transactions for California and San Francisco only.
Show	Summary: displays one line per customer, including the total amount owed by each customer Detail: displays additional columns and lines with significantly more detail (individual line items are shown for each customer along with details, such as their AR sales invoice number, AR sales invoice date, transaction currency, and transaction amount).

Journal entry creation

At close of period, it's common practice to run revaluation reports to compute the unrealized gains and losses for the period. Rather than create a manual journal entry from the results of your revaluation report, Intacct automatically creates a draft journal entry. Controllers and finance VPs can then review the draft and post the unrealized gains and losses for the period.

You can run revaluation reports by location, meaning an entity and all its locations. Or, you can run individual revaluation reports for each child location of the entity.

Individual revaluation reports are not supported when auto-creating draft journal entries.

There are two workflows for creating a draft journal entry from your revaluation report: one for online revaluation reports, and one for offline revaluation reports.

Set up auto-create revaluation draft journal entry

You first need to create an unrealized gain and loss account and journal. Next, you'll want to select the account and journal you created in the Configure General Ledger page.

When setting up your accounts, selecting Disallow direct posting prevents the posting of draft revaluation journal entries.

Before you select the auto-create draft journal entry option, deselect Disallow direct posting in the accounts for which you want to produce a revaluation report.
To edit your accounts, go to General Ledger > All > General Ledger accounts. Find the account and select More actions > Edit at the end of the row.

Before you select the auto-create draft journal entry option, deselect Disallow direct posting in the accounts for which you want to produce a revaluation report.
To edit your accounts, go to General Ledger > All > General Ledger accounts and select Edit next to the account to change.

For details on editing your accounts, see Edit or view an account.

Create your gain and loss account and gain and loss journal, if you do not already have them. For details, see Accounts and Journals.
Go to General Ledger > Setup > Configuration.
On the Configure General Ledger page, scroll down to Multi-currency management.
Select the Unrealized gain and loss account and Unrealized gain and loss journal that you want to use for revaluation reports.

Online revaluation report: auto-create draft journal entry

After the revaluation report runs, select View to see the results, and then Create JE to create a journal entry at each location level in AP, AR, or GL.

Set up the unrealized gain and loss account and journal.
Go to Accounts Payable > All > Reports > AP open items revaluation.
Enter your revaluation report parameters.
Scroll down to Journal entry creation, and select Auto-create draft JE when offline.
Select View to view your results.
Select Create JE to create the draft journal entry.

The journal entry is a draft.

After the journal entry is created, review it as follows:

Go to General Ledger > All > Journal entries.
Find the relevant journal in the list.
Select Transactions.
Select the transaction number.
Select Post.
Reverse the transaction on the following day by selecting the same transaction and then selecting Reverse.

Go to General Ledger > All > Journal entries.
Find the relevant journal in the list.
Select View transactions.
Select the transaction.
Select Post.
Reverse the transaction on the following day by selecting the same transaction and then selecting Reverse.

Offline revaluation report: auto-create draft journal entry

Intacct automatically creates a draft journal entry when you select an offline option for running the revaluation report, such as the Process and store or Memorize options, where you memorize the report and schedule it to run later. If you select Memorize, schedule the report to run offline later.

Instead of manually capturing data produced by an offline revaluation report, Intacct automatically drafts a journal entry. This saves time and reduces potential errors.

Before you run a revaluation report and auto-create a draft journal entry, create a gain and loss account and journal. Then select the gain and loss account and journal on the General Ledger. Learn more about selecting the account and journal on the General Ledger Setup page.

Set up the unrealized gain and loss account and journal.
Go to Accounts Payable > All > Reports > AP open items revaluation.
Scroll down to Journal entry creation, and select Auto-create draft JE when offline.
Select Process and store or Memorize. If you select Memorize, schedule the report to run later, offline.
You can view the status of any queued offline job by going to Company > Admin > Offline jobs > Offline job queue.
When Intacct processes the report, the draft journal entry is automatically created.

The journal entry is a draft.

After the journal entry is created, review it as follows:

Go to General Ledger > All > Journal entries.
Find the relevant journal in the list.
Select Transactions.
Select the transaction number.
Select Post.
Reverse the transaction on the following day by selecting the same transaction and then selecting Reverse.

Go to General Ledger > All > Journal entries.
Find the relevant journal in the list.
Select View transactions.
Select the transaction.
Select Post.
Reverse the transaction on the following day by selecting the same transaction and then selecting Reverse.

Formatting

Use the boxes in this section to arrange the data by a particular group and to change the page layout.

To format this report:

To arrange related data together by group, select the Group by dropdown list, and then select the group you want.
To change the page layout, select the Page orientation dropdown list, and then select either Portrait or Landscape.

Report format options
Format Box	Notes
Group by	Select how related data is arranged.
Sort by	Select how to the sort data.
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 print versions of this report. Export to Excel or CSV, or select Print for a PDF version.

What's in this report?

The default AP Open Items Revaluation Report consists of the following columns:

Report Column Heading	Description
Supplier	The ID and name of the supplier
Document Date	The date on which the transaction occurred (was documented)
Trans. Currency	The currency in which the transaction was paid
Txn amount	The amount of the transaction in the currency of the supplier
Base Amount	The value of the transaction in your base currency, at the time the transaction took place
Type	The revaluation exchange rate type: Intacct Daily Rate or custom type
Reval Exch Rate	The rate of exchange between the value of the transaction currency and the base currency
Reval Amount	The value of the transaction amount multiplied by the revaluation exchange rate
Gain	The difference between the base amount and revaluation amount if the fluctuation resulted in a gain
Loss	The difference between the base amount and revaluation amount if the fluctuation resulted in a loss

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

Best practices for AP revaluation reports

Run the AR and AP revaluation reports "for the period" for each base currency. Include all the entities that share the base currency each time you run a revaluation. The report will only pull transactions from the subledger that are not completed.
Common practice for posting revaluation journal entries is to set the initial posting date to the end of the month and the reversal date for the first day of the next month.
Sage Intacct automatically posts realized FX gain/loss at the time the AR and AP transactions are settled.
To save time and increase efficiency, use the Location "individual" report option to get all entities across different base currency in the same report run. Using the Individual report option uses the offline method.