Financial Reports > GL Reports > GL Closing Reports
  
GL Closing Reports
Before you can close a GL period, all data for that period must be consistent and complete.
A number of reports are provided for this purpose. For the closing process, manually run the reports and, if no issues or exceptions are found, close the GL period.
These reports are all on the Closing Process Reports menu (25.21.2) except for the Revaluation Report, which is grouped with other revaluation activities.

Closing Process Reports Menu (25.21.2)
 
Report
Description
Revaluation Report (25.21.1.6)
Displays the revaluation results for the current entity, optionally in the statutory currency, and has two revaluation-specific selection criteria:
Revaluation Area: Balance Sheet Accounts, Customer Open Items, Customer Payments, Profit and Loss Accounts, Supplier Open Items, and Supplier Payments
Revaluation Number
Numbering Completeness (25.21.2.1)
Checks for gaps in the numbering of documents and lists any discrepancies. It also checks other periods for numbering errors.
GL Balance vs Transactions (25.21.2.2)
Lets you verify whether the sum of all detailed transactions equals the balance.
The report contains the following amount columns:
Activity Transaction
Displays the sum of transactions in the Posting Line table for the selected GL period. This amount is compared with the Activity History column.
Activity History
Displays the total value of transactions in the Posting History table for the selected GL period.
Balance Transaction
Displays the closing balance of transactions in the Posting Line table for the selected GL period. This amount is compared with the Balance History column.
Balance History
Displays the closing balance of transactions in the Posting History table for the selected GL period.
The report comparisons are performed for each combination of the complete accounting key—GL account, sub-account, cost center, project, SAFs, daybook, currency, and intercompany code.
The report checks debit and credit totals separately, and prints inconsistencies on separate rows for debit and credit.
The report also checks total transaction currency, base currency, and statutory currency values separately, and prints inconsistencies on separate rows for each currency.
Posting Balance Validation (25.21.2.3)
Lists all unbalanced transactions for the specified period.
Open Item GL Validation (25.21.2.4)
Sums GL open items with the Open Items sub-ledger.
AR vs Control GL Check (25.21.2.5)
Compares the balances of Customer Control accounts against the open item balance of customers whose accounts are Invoice Control GL or Credit Note Control GL.
AP vs Control GL Check (25.21.2.6)
Compares the balances of Supplier Control accounts against the open item balance of suppliers whose accounts are Invoice Control GL or Credit Note Control GL.
Unmarked GL Postings Validation (25.21.2.7)
Lists transactions that do not have a period mark.
A period mark is a code used in the GL close procedures. All normal transactions before a close get the initial mark of that period. If a period is reopened for further activity, a new mark is created so that the corrective entries can be reported separately.
Unallocated Invoices Balance (25.21.2.9)
This report checks the consistency of the unallocated supplier invoice balance by comparing:
The balance on the system account of type Unmatched Invoices
The total of unmatched supplier invoices
Pending Transient Layer Postings (25.21.2.10)
Identifies unposted entries in the Transient layer, which you can then transfer to the Official layer. One possible usage of Transient layers is to store postings for review. When the postings have been reviewed and approved, they can then be transferred to an Official or Management layer.
Pending Allocations (25.21.2.11)
Prints details of transactions that are pending allocation.
Pending Recurring Entries (25.21.2.12)
Checks for unposted recurring entries. The report output is sorted by recurring entry code and posting date.
Zero Postings Report (25.21.2.13)
This report enables you to check posting lines with a zero amount. The search filters are Check Unposted Transactions, Entity, Daybook, GL Cal Year, GL Period, and Zero Amount By.
When you set Check Unposted Transactions to Yes and there are any unposted transactions, the report stops and displays a message. You can set up the report to display zero amount postings in trade currency, base currency, and statutory currency.