Understanding the Companies in Balance Report

All transactions within each company balance should net to zero. The Companies in Balance report (R097001) uses information from the F0902 table to determine whether a company is in balance.

This report identifies adjustments that posted to a prior year that are not included in the balance forward amounts for an account, amounts that were posted after the period cutoff, and missing intercompany settlements. For intercompany settlements, run this report and then run the Intercompany Accounts in Balance report (R097011) immediately to ensure that intercompany accounts are in balance.

Note: The Intercompany Settlements field in the general accounting constants controls the automatic generation of intercompany entries. To automatically create intercompany entries for journal entries, you must set this constant to 1 or 2.

The Companies in Balance report includes three columns. These columns appear blank if a company is in balance. If a company is out of balance, the summarized (net) amount appears in the columns as described in this table:

Column	Description
FY (fiscal year)	This column shows the fiscal year that is out of balance, using these guidelines: If only one year is out of balance, this column shows all future years that are out of balance by the same amount because the out-of-balance amount carries forward to each year until it is corrected. All the years that follow display out-of-balance amounts even if a specific year is in balance. If more than one year is out of balance, then the amounts for the fiscal years are different. The earliest year with an amount is the first out-of-balance condition.
Amount	This column shows the amount by which the company is out of balance. This field is cumulative. For example, if fiscal year 2006 was out of balance, that amount is added to the amount column for fiscal year 2007.
PACO (Post After Cut Off)	This column shows an amount if an entry is out of balance and was posted to a future period or to a future year.

Column

Description

(fiscal year)

This column shows the fiscal year that is out of balance, using these guidelines:

If only one year is out of balance, this column shows all future years that are out of balance by the same amount because the out-of-balance amount carries forward to each year until it is corrected. All the years that follow display out-of-balance amounts even if a specific year is in balance.
If more than one year is out of balance, then the amounts for the fiscal years are different. The earliest year with an amount is the first out-of-balance condition.

Amount

This column shows the amount by which the company is out of balance. This field is cumulative. For example, if fiscal year 2006 was out of balance, that amount is added to the amount column for fiscal year 2007.

PACO (Post After Cut Off)

This column shows an amount if an entry is out of balance and was posted to a future period or to a future year.