Enhanced interface

AR 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 AR transaction was valued at 100 ZAR, but now it's valued at 96 ZAR due to currency fluctuations. Because you will receive 4.00 ZAR less, you have an unrealized loss of 4.00 ZAR relative to the amount you previously stated (100 ZAR).

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

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

Who typically needs this report?

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 Receivable > All > Reports > Open items revaluation.

Subscription	Accounts Receivable
User type	Business, CRM
Permissions	Run AR 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 below.

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

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 customer or range of customers, use the From customer and To customer dropdowns.
To show results for a specific customer type, select the customer type dropdown, and then select the customer type you want the report to include.
Consultants and distributors are two examples of customer types.

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 you want to include in the report.

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

Filter Box	Notes
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 customer, To customer	Includes data only for a specific customer or range of customers. By default these boxes are blank, which means the report will include all customers.
Customer type	Include data only for the type of customer specified. By default this box is blank, which means the report will include all customer 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 page. 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.
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.
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.
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 Receivable > 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 Receivable > 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 PDF version of this report.

Generate a PDF version

Open the report and select Graph.
From the graph page, select Print.

Enter the title in the Report title 1 box.
- This title displays in large type at the top of the page, directly under your company name.
- You can enter over any default name that the system might have automatically supplied in this box.
Enter the subtitle in the Report title 2 box.

This subtitle displays in smaller type, directly beneath the main title.
Enter the footer text in the Footer text box. Footer text displays at the bottom center of the report.

You can use up to 80 characters, including spaces, in each title and subtitle, and footer.

When outputting to PDF, Standard reports automatically include the Created on timestamp and page number at the bottom of the page.

What's in this report?

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

Report column heading	Description
Customer	The ID and name of the customer
Document date	The date on which the transaction occurred (was documented)
Txn currency	The currency in which the transaction was paid
Txn amount	The amount of the transaction in the customer's currency
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 AR 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.