Skip to main content

Filtering orders for invoice reconciliation

The Realhub Accounting module includes a function that allows agencies to reconcile the invoices they receive from a provider against orders to ensure the expected invoice amount matches the amount being on-billed to a vendor.


​

Orders can be filtered by and then reconciled:

  • By individual campaign (against invoices from multiple providers)
    ​

  • By provider (against an invoice covering multiple campaigns)


​

For both options, we need to first navigate to Accounting > Order Reconciliation.


​


​

Once we have orders displayed by either campaign or provider, we can then:

  • Reconcile individual orders one by one

  • Reconcile multiple orders in a table view, by adding details in "cells"

  • Reconcile multiple orders all at once that have the same invoice number and invoice date


Filtering Orders by Campaign


​

Agencies may wish to reconcile all invoices for a particular campaign at once, before closing out their account sales.


​

  1. Start typing the property address into the campaign filter and selecting the relevant campaign

  2. Click Apply Filters

  3. All orders for the campaign will be displayed


​

Filtering Orders by Provider


​

If you have an invoice from a Provider with multiple campaign charges listed, you may find it easier to reconcile by provider rather than campaign.


​

  1. Start typing the name of the provider (as it is in Realhub) in the provider filter and selecting the relevant provider

  2. Enter a date range that applies to the invoice, with a maximum range of 31 days (1 month)

  3. Click Apply Filters

  4. All orders for the selected provider and date range will be displayed


You now have the option to reconcile orders individually, in bulk referencing various invoices, or in bulk referencing the same provider invoice. Each of these options are described in greater detail in each of the following articles


​


​

Did this answer your question?