Project Summary

Optimized Accounts Payable Workflow Increases Efficiency and Organization 

Optimized Accounts Payable Workflow Increases Efficiency and Organization 

A global provider of learning and development solutions for applications engaged Imaginet to create a SharePoint Online site to track and organize invoices for their organization. Their existing external database held various accounting records, tracking charges and details on vendors, but lacked structure around the invoice approval process and a defined audit trail.  

The Imaginet Business Productivity team built a SharePoint site that organizes invoices, routes them for approval, and identifies which ones are paid or outstanding. Workflows, set up with the help of Power Automate, automatically unzip any necessary files when new vendor invoices are uploaded and archive files when an invoice is approved (marked as paid). Bulk exports from the existing database into the SharePoint site trigger a flow that parses the XML, splitting it out into two SharePoint Lists to track invoice details at a high level (e.g., vendor name, total invoice amount, and invoice number) and more granularly (e.g., itemized details like specific charges). 

Using Power Apps, we simplified the invoice-matching process by making it easy to display a list of invoice files that can be matched to their corresponding invoice record. After a manual match occurs between invoice files and records, an approval flow alerts authorized users of a new invoice to review. We also created a straightforward way for the client to pull a list of invoices pending approval and to add edits or comments to an invoice record directly through the app.

Any actions taken within the site create an audit trail, providing details on record edits, approvals, paid invoices, broken matches between invoices and records, etc. Lastly, we assembled a user guide and added it to the SharePoint site to ensure convenience and understanding of the new system for all employees.

Our efforts were all duplicated for our client’s sister organization (that provides fiscal management), which allowed the client to keep the two entities separate but utilize the same enhanced process. With our updated SharePoint site, the client has one centralized location and singular process for invoice approvals and an audit trail for increased transparency, accuracy, and order within the organization. 

Our team has been working hard to deliver exceptional results, and we are thrilled to share our success with you. Don’t forget to subscribe to our newsletter to stay updated on our most recent Microsoft 365 projects. Fill out the form at the bottom of the page if you would like to work with us and someone will be in touch.

Technologies Used

SharePoint Online leads to optimized accounts payable workflow

discover more

The Differences Between SharePoint and OneDrive: A Guide

Janine JeansonMay 23, 20254 min read

Many people struggle with understanding the differences between SharePoint and OneDrive and when it is appropriate to use each of them. This blog will discuss SharePoint and OneDrive and will help you better understand how to use them for a…

Modernizing Legacy Applications: Future Proof Your Organization

Janine JeansonMay 15, 20254 min read

We are seeing rapid and constant shifts and changes within the technology world. For the average person, these changes can be a lot to keep up with. It seems like there are always new features, new technologies, and updates to…

Attributes of a Well-Designed Microsoft Entra Tenant

Janine JeansonMay 8, 20255 min read

Having a well-designed Microsoft Entra Tenant is essential. It ensures your organization is set up for robust security, compliance, and operational efficiency. Implementing strong authentication methods and conditional access policies protects sensitive data from unauthorized access.   A thoughtfully structured tenant…

Let’s Build Something Amazing Together

From concept to handoff, we’d love to learn more about what you are working on.
Send us a message below or drop us a line at 1-800-989-6022.