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

      Monthly Profit & Loss Report 

      Steps:

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

      2.     Select the Monthly Profit & Loss Report  

      Management Data Export (2)

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

      Monthly P&L

      Label  Field name Description
      a From Accounting Year  You can view your consolidated balance sheet at a point in time by selecting the  Accounting Year 
      b From 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 Apply Ownership This will apply the Ownership % specified on the each Office record. 
      e To Accounting Year   
      f To Accounting Month   
      g

      Report Format

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

      Use Office Home Currencies 

       
      i

      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.