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

      Monthly Balance Sheet Report

      View the balance sheet on a month by month basis

      Overview: 

      This reporting function will allow users to view a balance sheet on a month to month basis for up to 12 months. 

      Steps:

      Starting from the navigation screen 

      1.     Navigate to ACCOUNTING > General Ledger > General Ledger Reports and                       expand the Balance Sheet Reports section to see the list of available reports. 

      2.     Select the Monthly Balance Sheet Report 

      Large Knowledge Base Template (13)-Mar-06-2023-05-15-40-1725-AM

      3.     Enter or select the desired information 

      Maria Large Knowledge Base Template (18)

      Label  Field Name  Description
      a From Accounting Year  Select the From Accounting Year of the Monthly Balance Sheet Report sheet
      b From Accounting Month  Select the From Accounting Month of the Monthly Balance Sheet Report sheet 
      c Show Sub GL Account Detail? This is checked by default. If created with a header account, uncheck this to roll up the report at the header account level. 
      d Apply Ownership % ?   Check Apply Ownership % ? - Optional 
      e To Accounting Year Select the To Accounting Year of the Monthly Balance Sheet Report sheet 
      f To Accounting Month Select the To Accounting Month of the Monthly Balance Sheet Report sheet 
      g Report Format  Select the Report Format 
      h Include Transactions Up To  Select or Enter the Include Transactions Up To  date - Optional
      i Currencies 

      Select the type of Currency 

      • Use Office Home Currencies
      • Convert To Selected Currency 
      j Filters 

      Users can include only specific filters to the report.

      • Offices
      The list of offices you see are based on the Office Restrictions on your Employee record.

      4.     Select PREVIEW to view the Prepayments Reconciliation Report.  Users can                     also select Excel to download the report into data format. 

      Large Knowledge Base Template -Mar-17-2023-01-51-54-2044-PM

      This report enables to see the balance sheet on a month by month basis for up to 12 months – even if those 12 months span multiple financial years.

      It is formatted similarly to the Client Statement Report – but it is not designed to show the client how much money they owe, its purpose is to simply provide the client a listing of everything you have invoiced them for a selected date range (typically for a month).