General Ledger Reports
      Back to home
      2. General Ledger
      3. General Ledger Reports

      Profit & Loss Consolidation Report 

      Steps:

      1.     To access the Management Date Export Navigate to ACCOUNTING>General Ledger >General Ledger Reports

      2.     Select the Profit & Loss Consolidation Report 

      Management Data Export (2)

      3.     The Profit & Loss Consolidation Report  has the following filter options

      P&L Consolidation

      Label  Field name Description
      a Accounting Year  You can view your consolidated balance sheet at a point in time by selecting the  Accounting Year
      b Accounting Month  You can view your consolidated balance sheet at a point in time by selecting the   Accounting Month
      c Checkbox Show Sub GL Account Detail? This is checked by default. If you created header accounts, uncheck this to roll up the report at the header account level. 
      d Checkbox Show Eliminations? This is checked by default to include elimination entries on the consolidated balance sheet. 
      e Checkbox Apply Ownership This will apply the Ownership % specified on the each Office record. 
      f

      Month or Year to Date

       
      g

      Column Format

      ou can choose to flowchart your report by Office or by Entity.  If you only want to include specific offices or entities in the report, use the Filters or select/de-select the offices on the list accordingly. 
      h

      Report Format

      If your agency has custom financial statement formats, you can apply one of those formats to this report.  See Financial Statement Formats for more information. 
      i

      Use Home Currencies 

       
      j

      Convert to Selected Currency 

      Select this to get a consolidated report across offices with various currencies.  The Report FX Rate column on the office list at the bottom of the request page will appear showing the FX rate for each office to the selected Report Currency. 

      4.     Click Preview to view the Balance Sheet Consolidation Report and export it into PDF.  You can also select Excel to download the report into data format.