Run an intercompany report

With an intercompany report, you can report on transactions between a company and all the counter companies where intercompany transactions exist. The purpose of the report is to provide a quick way of tracing differences, before consolidation calculations are performed.

The report consists of a selection screen, a main report and a transaction details report. You can print both reports and send them to Microsoft Excel.

You can generate intercompany reports for both groups and companies. The same report is available from both the Company and the Group menu.

Local currencies are used and translated into B (closing rate), M (average rate) or D (period average rate) only. Note that for D rate, the translation will use the currency rates entered in Data Entry - Currency Rates and previous period values are not included in the calculation.

Procedure

  1. Click Company > Reports > Intercompany Report or Group > Reports > Intercompany Report.
  2. Enter your selections.
    • Consolidation Type: This is used only when selecting Group or Counter Group.
    • If you select a group or counter group, all the companies connected to this group and consolidation type will be included. You can combine Company, Group, Counter Group, and Counter Company.
    • If you select Counter Company or Counter Group, you can also select Only transactions within selection, to view transactions between the selected group or companies and counter group or companies. You can select Only transactions outside of selection to view transactions where you exclude the selected counter groups or companies. This means that you view transactions between selected groups or companies and all other groups or companies, including groups or companies that are not included in the consolidation type.
    • If you want to include information about largest accepted difference in the report, remember to add a Largest accepted difference amount or a relative value.
  3. Click Run Report.

Results

The Intercompany Report is displayed. For information about how to view transaction details, see View transaction details.