by ProcureDeskLast Updated : Sep-01-2021
Wondering how you can automate the accounts payable process using QuickBooks Online or QuickBooks Enterprise?
After helping 100’s of customers, I think we are qualified to answer this question.
In this article, we will cover the core capabilities of QuickBooks and to what extent you can use those capabilities to automate the accounts payable process. We will cover:
But before you get started:
Download out Invoice Process Optimization Guide to see the proven strategies to reduce AP cycle time by 39.8%
Before we talk about automating the accounts payable process using QuickBooks, Let’s first look at the key steps in the AP process.
The first step in the accounts payable process is receiving the invoice from the vendor.
Here you are looking at increasing the efficiency by automatically capturing the invoices from vendors.
The problem with many companies is that they don’t have a defined process for receiving invoices
You might have paper invoices or invoices sent directly to stakeholders instead of the AP team. That results in extra effort in scanning the invoices and following up with different stakeholders to gather the supplier information.
In an ideal state, you want to reduce the effort spent on receiving invoices by using the following strategies:
Once you have received the invoice, the invoice needs to be entered into your accounting system.
This generally includes someone to manually enter the data into your accounting system.
That is a time-consuming process because not only do you have to enter the invoice, you also have to code the invoice to the right chart of accounts.
In an ideal state, you don’t need to enter the invoice data into the system. You can reduce the data entry time by:
The next step is matching the invoice with the relevant documents like purchase order and receipt (a.k.a 3-way matching process).
If you want to read more, we have covered the 3-way match process in detail.
The challenge is that many companies don’t either have a purchase order process or the match process is highly manual.
In either case, you have to use emails for getting the invoices approved, and that not only takes time, but it also sucks the productivity of the entire company.
You can reduce the time spent on matching invoices by:
The next step is getting invoices approved for payment.
If you are using a purchase order (PO) process, you can rely on the purchase order to match the invoice.
If the invoice matches the PO and there is a receipt confirmation, you don’t need further approvals.
However, if you do have to get the invoices approved then emails become a challenge.
You can reduce the time spent on approvals by:
The final step is the payment to the vendor.
This can be managed directly in QuickBooks or you can use third-party systems like Bill.com to process payments.
The short answer is that QuickBooks doesn’t have AP automation capabilities.
QuickBooks is designed with a use case where only a few people are entering the invoices and it is assumed that the invoice has already been approved.
We will answer this question in the context of the capabilities we have defined above.
A common challenge for many companies is that they need to get the Bill/Invoice approved before the vendor can be paid.
As we mentioned above, if you use a 3-way match process then you don’t need to approve every invoice. An Integrated purchasing and invoicing solution can in fact provide you a view like this:
However, QuickBooks doesn’t have a native approval workflow capability.
So you are left with two choices:
Use good old email
You of course can use emails for approvals. The challenge is that using emails is very cumbersome.
Some of the challenges with an email-based approval process:
All this causes delays and you have a longer month-end process.
Use a third-party system like ProcureDesk
Here is how that invoice approval works:
Who wants to do double data entry?
I guess no one!
So that’s why you need to have Accounts payable software that is compatible with QuickBooks so that the data is automatically synced with QuickBooks.
In this section, we will cover key capabilities and how the AP automation solution integrates with QuickBooks Accounts payable process.
There is no benefit in automating your accounts payable process and then still entering the data manually in QuickBooks online or Enterprise. For example, entering invoices in QuickBooks and so on.
If you have AP software like ProcureDesk that integrates with QuickBooks, then you don’t need to worry about entering the data into QuickBooks. Infact connecting with QuickBooks just take few clicks:
Through an automated workflow, you can set up the system to send the purchase orders and invoices to QuickBooks once they are approved in ProcureDesk.
This can be done in real-time as is the case with QuickBooks online or close to real-time in the case of QuickBooks Enterprise.
With an AP software that integrates with QuickBooks, you can implement a complete procure-to-pay process in the AP system and use the accounting system for bookkeeping and payments.
Another benefit of integration is that you don’t have to give access to QuickBooks to anyone outside the finance team.
That not only saves cost but also gives you peace of mind that no one outside finance is looking into the financials and no one will mess up your books!
For creating an invoice in QuickBooks, you need the following
With an integrated system, you don’t have to worry about syncing the data manually.
The data gets automatically synced based on a fixed schedule.
For example, Suppliers and charts of accounts could be in real-time and the rest of the data can be synced every night.
The biggest benefit of an AP system is that you don’t have to manually match the invoices with purchase orders.
For example, with ProcureDesk, you can have purchase orders and invoices in a single system so that when the invoice is uploaded, you don’t have to go looking for the purchase order.
The invoice to PO match can be done in two different ways
3-way match process
With a 3-way match process, the invoice is matched to the PO and receipt to confirm that the invoice matches with what was being purchased and at the correct price.
2-way match process
With a 2-way match process, the invoice is matched with the purchase order and it is also sent for approvals so that the invoice can be verified for payment.
For example, consulting services and so on.
With the 3-way and 2-way match processes, you can significantly reduce the number of invoices that need approval.
However, there are still going to be invoices that need approval.
For example, An invoice shows up without an associated purchase order, then that invoice needs to be approved before the vendor can be paid.
Or the invoice total amount exceeds what is on the purchase order.
Or the invoice line amount is greater than the line amount on the purchase order.
The examples above are some of the day-to-day issues you see with invoices.
So how should this be handled?
You need to set up a workflow so that invoices can be routed to the respective team members based on the scenario. You can define simple business rules as follows:
Here are a couple of sample workflows you can implement by leveraging the Automated Payables process for QuickBooks:
Once the invoice is approved, the next step is to pay the vendor.
If you are using QuickBooks or other solutions like Bill.com, then you need to enter the invoice data in QuickBooks first.
Now since you have already created an invoice in a system like ProcureDesk, you don’t need to re-create the same document in another system.
By leveraging the integration with QuickBooks, the Bill can be automatically synced with QuickBooks from the AP automation system.
The frequency of the sync could vary based on whether you use QuickBooks Online or QuickBooks Enterprise (a.k.a QuickBooks Desktop version).
For example: With QuickBooks online, the Bill is synced in real-time and the invoice is instantly available in QuickBooks after it is approved in ProcureDesk.
However, the process with QuickBooks Enterprise is different because QuickBooks doesn’t offer a real-time integration for the enterprise version.
In that case, you can set up how frequently you want the Bill to be synced and by adjusting the time interval, you can achieve a near real-time integration with QuickBooks Enterprise.
You could pay the invoice using your Bank or you could use online payment systems like Bill.com.
However, once the payment is paid, the invoice remittance details need to be sent back to the AP system so that the other users can see that the invoice has been paid.
There are two main advantages of syncing the payment status:
ProcureDesk automatically syncs the payment information back from QuickBooks so that you don’t have to keep track of what is paid and what is not.
Even though QuickBooks doesn’t automate your accounts payable process, you have options to use third-party tools like ProcureDesk to fully automate the Accounts payable process.
Our customers who have implemented ProcureDesk with QuickBooks has seen at least a 30-40% reduction in the AP cycle (From Invoice entry to Invoice Paid)
And they love that they don’t have to do redundant data entry in multiple systems.
Ready to start your AP automation journey?
Schedule a demo with one of our product specialists and see how you can reduce the AP cycle time by 30-40%
What you should do now
Whenever you’re ready… here are 4 ways we can help you scale your purchasing and Accounts payable process.