Salesforce

Postings Summary Report

« Go Back
Article
Overview
 
  • This report summarizes all GL postings for a selected period.

  • It is presented in a form of a trial balance, where summarized detail is listed by GL account with beginning balance, period debits, period credits, period net, ending balance and the respective year-to-date amounts.

  • Further, summarized GL postings can also be extracted specific to division, dimension, and project. The Postings Summary Report can be exported to CSV and printed to PDF.
 
Prerequisites

Once AP, AR and inventory transactions are processed, they must be reflected in general ledger as GL transactions to further produce financials statements and other related reports and reconciliations.
  • Other financial transactions outside of AP, AR and inventory flows are captured through journal entries and are also reflected in general ledger.

  • Postings summary report groups all GL transactions by GL Account and presents a full summary trial balance and partial trial balance when reporting segments are selected for the period. 
 
Navigation
 
Rootstock Site Map > Postings Summary Report
 
Processing
 
Fields
 
Company:  The Company for which the Posting Summary Report is being generated. 
 
Subsidiary Company:  Select the Subsidiary Company to filter the Posting Summary Report for a specific entity under the selected company.
 
Year:  Select the Fiscal Year for which you want to generate the Posting Summary Report. 
 
Period:  Select the Fiscal Period within the chosen Fiscal Year for which you want to view the Posting Summary Report.
 
  NOTE  The period ranges from 1 to 12 if 'Use 13 Operational Periods' is set to False in System Configuration (SYCONFIG), or from 1 to 13 if it is set to True.
 
Select Source Data:  Choose the source of the data to be used. Dropdown options include:
  1. Full Trial Balance:  Account Level Data
  2. Partial Trial Balance:  Account + Dimensions
  3. Partial Trial Balance:  Account + Division
  4. Partial Trial Balance:  Account + Division + Dimension
  5. Partial Trial Balance:  Account + Project
  6. Partial Trial Balance:  Account + Project + Dimension
Include Zero Balance Accounts:  If it is false, accounts that have no beginning balance or activity for the year are skipped. if it is true, then account that have no beginning balance or activity will be considered.
 
Include Inactive Account:  Postings Summary Report will include GL Accounts which were deactivated during the reporting period. In practice, inactive GL accounts should total to zero in the period they were deactivated.
 
Buttons
 

Print Report:  This option allows you to print Posting Summary Report. Summarized detail is listed by GL account with beginning balance, period debits, period credits, period net, ending balance and the respective year-to-date amounts.

 

Export Report:  This option allows to you export Postings Summary Report to CSV format. Summarized detail is listed by GL account with beginning balance, period debits, period credits, period net, ending balance and the respective year-to-date amounts.

 
Report Behavior Based on Operational Period Configuration
 
The behavior of Period 12 in this Posting Summary Report depends on whether the system is configured to use 12 or 13 operational periods (as defined in field 'Use 13 Operational Periods' in the System Configuration).
 
  • When using 12 periods
The report displays Period 12 values as a combined total of actual Period 12 transactions and any year-end adjustments, which are typically recorded in the background using the 13th period.
 
  • When using 13 operational periods
The 13th period is treated as a regular accounting period, not reserved exclusively for adjustments. In this case, the report shows:
      • Period 12: Only actual values for the 12th period
      • Period 13: Actual values for the 13th period

SEE ALSO
 
Settings
Postings Summary Report
Postings-Summary-Report

Powered by