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

      Interoffice Reconciliation Report

      Automated reconciliation of interoffice loan account and interoffice AR and AP transactions

       

      The interoffice reconciliation report consolidates transactions that are shared between two offices.  There are two scenarios covered: 

      1. Interoffice cost sharing, using the Interoffice Loan Account, as described here.
      2. Interoffice billing, as described here. 

      Steps

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

      2.     Select the Inter-Office Reconciliation Report hyperlink 

      Large Knowledge Base Template (14)-Mar-17-2023-01-14-58-9146-PM

      3.     Enter or select the desired information 

      Maria Large Knowledge Base Template (15)

      Label  Field Name  Description
      a Accounting Year  Select the Accounting Year of the Inter- Office Report  sheet
      b From Accounting Month  Select the From Accounting Month of the Inter- Office Report sheet 
      c To Accounting Year  Select the To Accounting Year of the Inter- Office Report t sheets 
      d To Accounting Month  Select the To Accounting Month of the Inter- Office Report t sheets 
      e Currencies 

      Select the type of currency 

      • Use Office Hone Currencies 
      • Convert to Selected Currency 
      f Reporting View

       

      For transactions posted to the Interoffice Loan Account, choose from one of these views:

      • Detail - This shows the Opening Balance, the transaction details with relevant dissections, and the Closing Balance for each office
      • Summary - This shows the Opening Balance, Movement, and Closing Balance at the office level 

      For interoffice AR and AP transactions, Accountability does an automatic reconciliation of these client and supplier invoices upon approval. 

      • Interoffice Billing Reconciliation -  Choose this view to see
        • The details of each interoffice client invoice raised, amount of receipts against that invoice and the unpaid balance
        • The details of the related interoffice supplier invoice, amount of payments against that invoice and the unpaid balance
      g Filters 

      Users can include only specific filters to the report.

      • Offices
      The report will display both sides of the transactions that apply to each office(s) selected, regardless of user access.

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

      Large Knowledge Base Template (15)-Mar-17-2023-01-18-40-1302-PM