Filtering orders for invoice reconciliation

Modified on Mon, 18 Mar, 2024 at 12:13 PM

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



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article