PO matching in QuickBooks
I have been trying to set up a three way match workflow in QuickBooks Online for the last few weeks and the PO module is there in name but actually matching a PO to a bill to a payment in a clean automated way is essentially impossible, everything ends up being a manual cross check and we are still missing matches at month end.
To be more specific the problem is that QuickBooks treats POs, bills and payments as loosely connected rather than as a single linked record so when a vendor sends a bill that does not exactly match the PO amount (because of partial shipments or fees) the system flags it and asks me to manually decide which fields take precedence. This week for example I had a vendor send a bill with three line items spread across two POs and figuring out how to split it across the right matches took me almost an hour for one invoice so now multiply that by 40 to 60 bills a month and it compounds a lot.
Is this something that could be solved inside QB itself/like am I missing a setting. If any other users have had this problem like did you move to a third party tool or is this a setup issue on my end I would love to hear from you guys.