How To Quickly Automate The Reconciliation Of Excel, PDF And Paper Statements With Statement Matching

One of the challenges of manual supplier statement reconciliation is juggling the complexities of documents in various formats. With statements in Excel or PDF, or on paper, Accounts Payable spend a lot of time getting them into a single format if they are reconciling using Excel lookups or check the statements line by line otherwise. This inevitably takes longer to complete and increases the opportunity for errors, which is why statement reconciliation often ends up at the back of the queue simply through lack of time.

If you’re looking for a quicker, more cost-effective and less burdensome approach to reconciling supplier statements, automated reconciliation software is the way forward.

How Does Statement Matching Work?

With Statement Matching, automation couldn’t be simpler. Whether your supplier sends their statements in digital or paper format, the streamlined process means that all file and document types can easily be automated.

• Excel files: Excel files are a popular format for suppliers to email their statements to you. To get them into Statement Matching for reconciliation, all you have to do is forward the email for auto-import into Statement Matching. Alternatively, suppliers can upload their own statements via a portal if you give them access.
• PDF/paper statements: Supplier statements that you receive as a PDF attachment via email can also be forwarded to our managed service where the data is captured and transferred to Statement Matching. It’s the same process for paper statements, so you can scan them to PDF or TIFF and send them to the same email address used for PDF forwarding. They will be auto-uploaded to Statement-Matching within 24 hours.

With manual reconciliation eliminated, the only task for your accounts payable team is to manage any exceptions that are identified. Errors can be resolved proactively by Accounts Payable to ensure missing invoices/credits are obtained from the supplier on a timely basis and any errors on your ERP system are fixed before they become more costly issues.

Once exceptions are checked and corrected, Statement Matching will automatically re-reconcile statements on a daily basis when we receive new data from ERP system, so users are always looking at the most up to date reconciliation and the system keeps working the statements for you to ensure all errors are fixed.

Statement Matching: Streamline The Work Of Your AP Department

With a streamlined, automated reconciliation solution, the inconvenience of handling different statement formats is overcome. Easy upload reduces time-consuming and repetitive tasks, while improving invoice settlement times, thereby reinforcing supplier relationships. Suppliers are more likely to continue working with clients who settle their invoices within a timely manner and therefore don’t need to be chased for payment.

Our team are working normal business hours and demos are being scheduled as normal. So, to see the platform in action for yourself, book a free live demo by clicking here, or give us a call to find out more.

Image source: Pixabay