Invoice Processing
Invoice Processing
5.0 OBJECTIVES
The objectives for this unit are to familiarize the learners with:
x types of invoices;
x invoices processing;
x credit notes processing;
x vendor account reconciliation;
x significance of invoice processing and vendor reconciliation to the P2P cycle;
and
x other activities associated with the invoice clearing process.
5.1 INTRODUCTION
In the preceding units, we understood the overall Procure to pay (P2P) process at
a high level. We also learnt how new vendors are set up in the vendor master. In
this unit, we will look at how invoices and credit notes are processed. We will
also learn the process of vendor accounts reconciliation.
Invoice processing is the most important activity in the whole P2P cycle. It needs
to be done accurately and quickly; otherwise it can lead to vendor dissatisfaction
and subsequently the buyer’s (client’s) business suffering a loss of reputation and
44 may delay in receipt of goods or services for future requirement.
Let us take a look at the overall P2P process, as shown in Fig 5.1. (Invoice Invoice Processing
processing is highlighted as this is the topic of discussion now)
5- Vendor makes
Stores Dept. delivery Vendor
) Recap -The purpose of using POs: Purchase orders are created for 2
primary reasons:
a) The client organization clearly sets out its requirements to the vendor
in terms of the items required, the quantity and rate of each item and
other delivery terms. Since the vendor agrees to these terms, it
constitutes an agreement between the two parties. This avoids
confusion at the time of delivery.
b) Since the PO needs the approval of the authorized employee(s) before
it is sent out, the process ensures prevents unauthorized purchases
by employees.
1. Paper invoices
2. Electronic invoices
The paper invoices are printed on papers out of the invoicing systems of the
vendor and sent to the buyer (client) using the traditional mail facility. Processing
of these invoices takes longer time and involves manual data entry of the invoice
into the client’s ERP.
The electronic invoices are received through electronic channels (like computer
networks, internet. etc.) and not on paper. The invoice data enters into the client’s
computers directly and the invoice is processed automatically for payment. The
electronic invoices can be broadly classified into the following types:
a. EDI (Electronic Data Interchange)
b. Supplier portal
EDI invoices: The National Automated Clearing House Association, USA defines
EDI as “the application-to-application exchange of business information in a
standard format”. In simple terms, EDI is a standardized electronic format for 2
companies to exchange commercial information.
Invoices sent to
customer electronically
through EDI
AP Dept.
Vendor
AP Dept. electronically
matches invoice with
electronic PO and GRN
using EDI standards
EDI technology has a strong application in the AP process. In this method, the
supplier submits the invoices in electronic files (adhering to the EDI standards)
which are transmitted to the client using an EDI network (as shown in Fig.5.3).
Once the invoices are received by the buyer, they are automatically loaded into
the AP systems and processed for payment. It is compared with the other data
from the purchase order and matching takes place accordingly. Once it goes
through, the invoice is processed for payment.
The benefits of this technology are realised for suppliers who send large volumes
of invoices as they can be processed automatically without any manual intervention.
Companies and industries like automobile, manufacturing, retail, etc. deal with a
47
Procure to Pay large number of suppliers and get thousands of invoices each day. They usually
insist that their vendors (especially the large ones) use EDI to send their invoices.
The challenges in using EDI is primarily around high initial costs involve for EDI
platform.
Supplier Portal invoices: Some large clients with complex procurement function
have automated the invoice handling process by creating secure internet websites
especially developed for this purpose. These websites are called supplier or vendor
portals and they help to streamline coordination with their vendors and automate
activities. (See figure 5.4)
Client
Company’s
Supplier Portal
Vendor
Client
Here are some of the activities for which the portal can be used:
x The company can send the purchase order to the vendor using the portal.
x Vendors can confirm their agreement to the purchase order.
x The vendors can submit electronic invoices to the company.
x The vendors can update the status when the goods are shipped to the buyer.
x Vendors can track the status of the payments for their invoices.
These websites use secure technology to make sure that the transaction are made
by the actual parties and avoid frauds or impersonation.
Once the invoice has been received electronically by the company, the rest of the
processing (including invoice matching and payment) happens automatically.
This is not very widely used because the client is usually selective about enabling
only large vendors through this channel.
48
) Some other types of invoices Invoice Processing
AP Dept.
User Dept.
The figure 5.5 above shows how the accounts payable process is managed from a
remote location. The outsourcing team operates from this remote location.
1. The vendor sends the invoice to the company. The client gives all vendors a
specific address to send their invoices. This is usually the address of the mail
room and scanning centre.
2. The initial handling of the invoice at the mailroom consists of the following
steps:
a. Scanning: The scanning operation converts the paper documents into
digital images which are stored on computers and can be accessed over
a computer network from anywhere in the world.
b. Indexing: For further processing, the scanned images of the invoices
are indexed based on some key information e.g. invoice number, vendor
code/name, invoice date, invoice amount etc. so they can be easily queried
50 and accessed by the AP team. Indexing enables easy classification and
search by the AP team later. It usually happens from the remote location. Invoice Processing
Indexed invoices are sorted first in invoice or credit note, PO / Non PO,
compliant invoices and non compliant invoices. Compliant invoices are
those invoices where all the required information to process an invoice
is available and in non compliant invoices some of the required
information to process are either missing or not adequate e.g. PO number,
PO not authorized etc.
c. Validation: The invoice is initially validated for the following:
• Whether the same invoice is processed in the past i.e. if the invoice
is a duplicate.
• Whether it is an invoice or a credit note (credit note is received along
with invoices but needs a different treatment).
• Whether all the data required to be entered into the system against
the invoice is available. (Vendor’s name, PO no., invoice no., invoice
amount, payment date, cost/account codes etc.)
If the invoice is identified as duplicate it is not processed further because
it may result in duplicate payments. If the invoice turns out to be a
credit note, it is processed by the invoice team albeit differently (this
has been discussed later in this unit). In case some data to process the
invoice is missing, the invoice is put on “Invoice on Hold”; we will
discuss this in details in the subsequent unit (unit 6).
3. Thereafter, the invoices are sent for processing. Those invoices which were
sent against POs feed into a process called matching. Here the invoice is
matched against the PO to verify the items that have been charged are the
same ones that were ordered and that the rate mentioned is the same. Also
the invoice is matched against the goods receipt note (GRN) to verify that
the items that have been charged were indeed delivered.
There may be invoices that were put on hold due to certain issues. The
authorized approver clears or rejects any of these invoices that are on hold.
4 Non-PO invoices are those invoices where goods and services are procured
without corresponding PO. These invoices are sent to the buyer to get the
necessary approval from the authorized approvers.
5. In this step, the authorized approver approves any non-PO invoices in the
workflow.
6. The payment is made to the vendor.
Let us examine the processes (from step no. 3 onwards) in more details.
3XUFKDVH
2UGHU
,QYRLFHV
*RRGV
5HFHLSW
1RWH
The process to clear the PO based invoices looks like as shown in fig. 5.7 below.
The steps followed in this process are:
1) The vendor sends the invoice to the address given by the clients for this
purpose.
2) The rnailroom sorts the invoices and hands them over to the scanning service
where the invoices are scanned into digital images.
3) Thereafter the scanning service team archives the invoice. In Archiving, the
paper documents are filed and stored safely in case they need to be referred
to in future. This is likely to happen if the scanning is not done well.
52
Invoice Processing
Start
6- Check if the
scanned invoice is
clear If No
Invoice Processing
Team
If Yes
7- Check if
the invoice is Stop
a duplicate If Yes
Invoice Processing
Team
If No
8- Check if all
9- Request vendor to provide
the required data is
the missing data
available on the If No
Invoice Processing
Team
invoice
If Yes
10- Vendor provides the
missing data
Stop
4) The Invoice Processing (IP) team accesses the invoice using the document
management system.
5) The IP team indexes the invoice on the document management system.
6) A check is done to see if the invoice is legible. If not, the image is sent back
for rescanning.
7) The IP team checks whether the invoice has been sent in the past and whether
this version is a duplicate. If it is, then the invoice is not further processed.
8) A check is done to see whether all the data fields necessary to process the
invoice is present. 53
Procure to Pay 9) If not, request the vendor to provide the missing data for the invoice.
10) Once the vendor provides the required data, proceed to the next step.
11) The invoice related data is entered into the ERP for processing for payment.
Two-Way Match
A two-way match indicates matching two documents i.e. invoice and PO. This
usually happens when the purchase order has been raised for supply of services.
Since services supplied are intangible, a GRN cannot be raised for them. For
example, if the sales department hires an outside trainer to train its salesmen on
managing customer relationships, the trainer provides the training services.
Someone needs to confirm the services were received as per the details stated in
the invoice. Since GRN is not available in this case, the invoice is compared with
the PO only and then sent to the buying manager for confirmation, using workflow
tool. Taking the above example, once the training is over, no GRN is raised. The
person who hired the trainer needs to confirm that the training services were
delivered to his satisfaction so that the trainer can be paid. Once this confirmation
is received, the invoice is cleared for payment.
,QYRLFHV 3XUFKDVH
2UGHU
Fig. 5.8: Two way match
Ihe invoice processing team usually checks for the following:
x Whether the quantity supplied (as stated in the invoice) and accepted (stated
in GRN) matches the quantity that was ordered (stated in PO), in case of 3
way match.
x Whether the prices for goods/services (as mentioned in the invoice) match
the ones mentioned in the PO.
x Whether bank account information on the invoice matches the information
in the vendor master, if available on the invoice.
For processing an invoice, the invoice details mentioned on the scanned invoice
is keyed by the processing team into the ERP system. Some of the key fields that
are entered at this point are:
1. Invoice number
2. Invoice date
3. Date of posting
4. Invoice amount
54
5. PO number Invoice Processing
Invoice processing
Basic Data
Invoice Date Invoice #
Posting Date Vendor
Amount
Tax Amount
Payment Terms
Invoice data
x The invoice may not be numbered. This poses a problem while indexing
and tracking it. It can also potentially result in some duplicate payments.
x The vendor may not have been set up in the vendor master of the client,
when the invoice is received. The invoice has to be put on hold and the
55
Procure to Pay
vendor has to be set up first. This puts the pressure on The Service Level
Agreements of the invoice processing team as well as vendor maintenance
team.
x In the absence of a PO, the proof of purchase approval is not readily
available. Similarly, whether the goods and services have been delivered to
the end user’s satisfaction is also not known. Hence the invoices have to be
put on hold for buyer’s approval. This increases the lead time for invoice
processing.
x In the absence of the PO, the cost center and account codes under which
the expenses will be booked also needs to be determined prior to processing.
This is done by putting it on hold.
x sending the invoice to the client (refer to invoice on hold process Unit 6)
This shows that the PO invoices are easier to process than non-PO invoices. Also,
due to the above reasons it is in the buyer’s interests to have a high PO coverage
for the buying process i.e. cover more purchases through the purchase orders than
outside these, to have a better control on spending.
The non-PO based invoices are identified and separated from PO based invoices,
by the invoice processing team and are sent separately for approval to the concerned
buyer/cost center head. The buyer confirms the receipt of goods/services, approves
the payment and also provides the cost codes under which to book the expense.
For processing of Non PO invoices, the team also needs to be equipped with the
list of valid approvers for various cost centers and their scanned signatures or
invoices are sent to them for approval using work flow. Once invoices are approved
by the respective approver, it will be ready for payment. The steps for processing
it are as follows:
1) The vendor sends the invoice to the address given by the clients for this
purpose.
2) The mailroom sorts the invoices and hands them over to the scanning service
where the invoices are scanned into digital images.
3) Thereafter, the scanning service team archives the paper version of the
invoice
4) The Invoice Processing (IP) team accesses the invoice using the document
management system.
5) The IP team indexes the invoice on the document management system.
6) The invoice related data into the ERP for processing for payment. A check
is done to see if the invoice is legible. If not, the image is sent back for
rescanning.
7) The IP team checks whether the invoice has been sent in the past and whether
this document is a duplicate. If it is, then the invoice is not processed further.
56
Invoice Processing
Start
Vendor
2 - The Scanning service
scans the invoice
If Yes
If No
If Yes
11 - Request vendor to
10 - Check if all the provide the missing
required data is available data
Invoice Processing
Team on the invoice If No
Stop
58
Invoice Processing
) Some of the common invoice processing errors that you need to watch
out for are:
• Invoice processed as credit note or vice versa.
• Invoice processed with incorrect amount
• Invoice Processed with incorrect payment currency
• Invoice processed to incorrect site (or incorrect profit center within
client’s organisation)
• Invoice sent to incorrect approver for approving the invoice
• Invoice matched with wrong lines in the PO
• Credit note not processed with immediate payment terms
• Multiple pages in an invoice (the Total of first page is processed instead
of the actual total which may be provided at the last page.)
) Care needs to be taken to identify the credit note properly among the
documents received from the vendor. If it is processed as an invoice,
instead of deducting a credit, a vendor gets money it attempted to give
back to the client.
For example if the vendor supplied goods worth USD 12500 and the
client returned goods worth USD 3500. The vendor sends a credit
note for USD 3500. If the credit note is processed as an invoice, the
client will end up paying the vendor USD 16000 (USD 12500 + USD
3500) instead of USD 9000.
59
Procure to Pay
5.6 RETURN OF INVOICE
In some cases the invoices cannot be processed for payment and have to be returned
to the vendors. The reasons for which invoices are usually returned are:
1. The PO number mentioned on the invoice does not match or is missing.
2. Authorizer does not approve the invoice or has a disagreement with the amount
stated on the invoice (e.g. some discount that was promised on the purchase
may not have been passed on to the buyer).
3. Some crucial information is missing on the invoice which cannot be supplied
by the client also.
61
Procure to Pay
5.8 LET US SUM UP
Invoice processing is the most crucial and effort intensive part of the P2P cycle. It
involves examining the invoice and making sure that the goods and services for
which the invoice has been raised have been received to the satisfaction of the
buyer.
The invoices may be received electronically or on paper. The electronic invoices
can be processed automatically. The paper invoices require effort to process. The
paper invoices are received in a mail room in the client location. They are scanned
and uploaded into the computer. The invoice processing team indexes them and
sorts them based on invoice / credit notes, PO & Non PO invoice etc. For PO based
invoices (which are sent for the goods supplied), a three way match is conducted i.e.
matching the contents of PO, invoice and GRN. When the services have been supplied
and invoiced, the GRN does not exist so the invoice undergoes a two way match.
For non-PO based invoices one needs to forward these to the buying manager
within the client’s organisation and get information on cost codes as well as the
approval for the invoice. After the approval is in place and cost code and cost
center is identified, the invoice can be cleared for payment.
Credit note is identified by a negative amount stated on it and the word credit
note/credit memo in its title. It needs to be identified properly and processed as a
credit note and not as an invoice.
Vendor account reconciliation also needs to be done from time to time. This is
done to make sure that the transactions recorded in client’s books of accounts are
identical to the ones recorded in vendor’s books and the differences are accounted
for or eliminated.