Automate vendor statement reconciliations in SAP.

See a demonstration on how to of how to automate vendor statement reconciliations in SAP with BEST Vendor Recons Module. Register for a live interactive session or watch the recording later:

When: Thursday 19th March

At: 10h00 GMT

To register click here

Find our more about BEST Supplier Reconciliation in SAP.

How To Reconcile Supplier Statements

As with other accounts payable processes, it is essential to digitise. A computer or automated supplier statement reconciliation will save personnel time, be more accurate and ensure proper audit controls.

If you can implement an automated supplier reconciliation solution directly in your existing accounting package or ERP, this is preferable to an additional stand-alone system. For example, I spend much of my time working with businesses or shared service centres that run SAP. We implement an add-on module called BEST to automate the supplier reconciliations directly in SAP. Accounts payable personnel then use their existing SAP login, and you don’t require any additional hardware or software. Unfortunately if you cannot implement a solution directly in your current accounting system, then you need to interface all your transactions to a new stand-alone system, which can be technically difficult and unreliable. Cloud solutions are also stand-alone systems that require separate logins, and interface extractors from your accounting system of all supplier master and transactional data. For a Cloud solution, you must also consider the security of your confidential supplier transactions that will now be stored outside of your company environment at another organisation.

Supplier statement formats

You will most likely receive supplier statements in multiple formats, as each supplier system produces a different format or layout. Emailed statements usually come in Excel or PDF. Other statements will be paper via post or delivery. Unless your suppliers are able to conform to a single statement template, your automated supplier reconciliation solution should be able to automatically load all formats and layouts to ensure that you do not need to type the statement data into the system.

Match supplier statements up the procurement chain

If you cannot match the statement to a supplier invoice or credit note from your system, your supplier reconciliation solution should automatically match up the procurement chain

  • If you use an invoice automation solution such as ReadSoft, OpenText / VIM, Dolphin, eFlow or one of the many on the market, or EDI invoices, you need to be able to match invoices still in processing in this system. Or if you park or held invoices before posting. For example, invoices not yet approved, or with processing errors. If the automatically produced reconciliation report immediately identifies where the invoice is, then this can be quickly resolved.
  • Matching to the GRIR account is also essential to identify statement lines that have no invoice match, but a goods receipt has been posted.
  • If the supplier can provide purchase order numbers on the statement, and the statement cannot be matched to any invoice or GRIR, then identifying the valid PO in your system will help investigation.

Go paperless: approve reconciliations, store electronically & email to the supplier

Rather than signing paper, approve reconciliations in your accounting system to ensure a complete audit trail. Approved reconciliations should be emailed by the system to the supplier, so the supplier has sight of all issues reducing follow up ad hoc queries. Both the original statement and finalised reconciliations should be stored in your accounting system, to alleviate the need for any filing.