Invoice Matching

Invoice Matching

With Zahara, you can raise purchase orders and you can record invoices. You can of course link the two together and show the difference between the order and the invoice. Zahara also has receipting (GRN) data so there is effectively a three-way match. Because of the nature of the customers that use Zahara – mainly service-based businesses, we aren’t a stock control system. Zahara is designed to be easy to use and if anything, will always try and take a simpler approach where possible.

The process for matching orders and invoices is as follows:

  1. Create a purchase order and send onto your supplier 
  2. Receipt the delivery (GRN the order)
  3. Record the invoice against the order 
  4. Report on any differences

 

Linking an Order to an Invoice 

The invoice Inbox is the starting place for all Invoice processing. We will assume here that an invoice has been read and you are ready to process it. You select the order number from a list of outstanding orders for the selected supplier or confirm the order number if the order number is referenced on the invoice, as shown below: 

With the supplier correctly identified, any outstanding purchase orders will be available in the Purchase Orders select list. The invoice may relate to multiple purchase orders. You can select one or more in this field. If the OCR engine is successful (its expected to be), the purchase order number will be pre-selected in this field, if it is referenced on the invoice

 

Adjusting Your Lines to Match 

This is an essential point of Zahara’s functionality. Where an invoice and order differ – you have to adjust the order line items to reflect the invoice. We don’t do this automatically. The Order lines are the truth – this is what you have created and now the supplier has invoiced you, you need to reflect the invoice in the order lines. 

As an example. You have 3 order lines as shown below and this went off to the supplier. In an ideal world, the supplier would send you an invoice that exactly matched this. 

However, the supplier has sent an invoice as shown:

You now have to reflect this when creating the invoice. You could create a stand alone invoice, with no link to the order. Your order would be orphaned though. What you need to do is create the invoice, select the order it relates to and then adjust the three lines as shown below: 

The other point to mention here is that when you are recording the invoice, and using the Order lines, you have the ability to change the coding as well. It could be you need to change the nominal code to assign the invoice to a Project. This is all possible at this stage but doesn’t affect the matching balance.

Line Item Balances

Each order and invoice has an overall order invoice balance. When the original order was raised, the balance was £448.80 – ie we are in credit by £448.80. 

After the first invoice is received, the balance is now £404.12 – the original order value, less the first invoice. 

In terms of the line balances, this would be as shown below:

As you can see, we are trying to get to a balance of zero where the order matches the invoices received against it. 

The line item balances will be available to view on both the order and the invoice. 

Creating an Invoice (No Inbox)

You can create an invoice from the + > Invoice menu and populate all fields yourself. You then select the purchase order that the invoice relates to from the list of available PO numbers in the select list. 

Notice the “Import Purchase Order Line Items” in blue. You have to click this link to pull through the Order lines. You will also notice that we show in the Purchase Order select list any orders that are awaiting approval –

Once the order lines are imported to the line items, you complete the Invoice create using the method above to adjust any lines to reflect the invoice received. 

Reporting 

Zahara has a number of reports that can be used to help you calculate the overall Purchase Order Invoice Difference. We have a report of this name, in the Purchase Orders section of our reporting,  that can be run which will give you the balance of all orders and invoices. This is a non-line item-level report so won’t provide the granularity of where the balances lie. 

Advanced Reporting 

You can use the Zahara reporting API to connect to the order, invoices and line-items data source in Excel (or PowerBI). The swagger file – https://data-api.myzahara.net/swagger/index.html shows the data sets available and the field. The balance is available on the Line Items table. 

Please read the Advanced Reporting help guide or submit a support ticket to have your Zahara account enabled.  

    • Related Articles

    • Invoice Processing Explained

      Introduction In Zahara, you can record two types of invoices – standalone and those that relate to a purchase order. There are several different ways of recording an invoice in Zahara and as well as the in-built Invoice Inbox. Once an invoice is ...
    • Supplier Matching

      This article will help you get better supplier matching when using the Invoice Inbox. How it Works 1. The receive email address identifies the business unit 2. The sender’s email address should identify the suppliers (unless it’s your own or a ...
    • Invoice Inbox Setup

      This help article will help you set up the Invoice Inbox and start getting your invoices read; for fast and easy processing. So let’s get you started. To have access to the Invoice Inbox; you need to have full permissions for invoices – create; edit; ...
    • Flashing invoice approval icon

      A flashing approval icon is a notification related to an Adhoc approval. It means that the invoice has been updated and you need to take action. Please see the help article that covers adhoc invoice approvals – Click Here
    • Apply invoice to budget

      You can enable the ability to apply an invoice to a budget. Go to Business > Settings > Budgets to find these settings. Firstly enable the feature. You can choose to either adjust a budget with the invoice that’s created or to create a retrospective ...