Overview of the Invoice Reconciliation Report | Scribe

    Overview of the Invoice Reconciliation Report

    • 28 steps |
    • 2 minutes
      1
      Navigate to Brokerage Engine

      Generate the Report

      2
      Click "Accounting"
      3
      Click "Reports"
      4
      Click "Subledger Reporting"
      5
      Click "Invoice Reconciliation"
      6
      The report will populate.
      7
      The date range can be determined by the options from the dropdown menu, or by the date fields.
      8
      Click "Generate"
      9
      The report will generate with the dates provided. The blue heading indicate the criteria on the Brokerage Connect platform, and the yellow heading the criteria in Accounting.

      Breakdown of fields

      10
      Invoice # - it is the autogenerated reference number of the invoice. Office - it is the office tied to the invoice. Bill To - the Agent (Customer) that is billed by the invoice. Invoice Date - the date the invoice was created.
      11
      LSS Amount - the amount of the invoice in the Connect platform. LSS Balance - the balance of the invoice in the Connect platform. LSS Status - the status of the invoice in the Connect platform.
      12
      Accounting Amount - the amount of the invoice in the Accounting platform. Accounting Balance - the balance of the invoice in the Accounting platform. Accounting Status - the status of the invoice in the Accounting platform.
      13
      Accounting Match - it displays two statuses. If the Accounting Match is "true", then the invoice created in the Connect platform synced successfully to the Accounting platform. If the Accounting Match is "false, then the sync log for the invoice needs to be reviewed. Any errors will need to be revised, and then the invoice will sync. The Action column has a force sync button to expedite the sync of invoices. If the invoice is not force synced, then it will automatically feed on the next scheduled sync.

      Search for Invoices

      14
      You can search for an invoice by typing the invoice number on the text field.
      15
      Additionally, you can search by Office by selecting from the dropdown menu.
      16
      You can pull all the invoices that belong to an Agent by selecting their name from the dropdown menu under "Bill To".
      17
      The toggle key for "Hide Matching Invoices" can be selected to "No" and "Yes", in order to direct the system whether to display Invoices that have been synced to the Accounting platform and have a match.