Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
What to when?
a) a vendor sent two invoices for two separate services
b) each invoice got entered to QBO Plus as a separate Bill
c) the invoices later got paid by ACH at the vendor’s website BUT the website would only accept a SINGLE payment for both invoices combined, so
d) QBO Banking then added the single payment to the account register as an Expense.
e) so now in QBO there are two “unpaid” bills and a corresponding single Expense that in real life paid them. WHAT SHOULD BE DONE TO RESOLVE THIS?
Solved! Go to Solution.
Thank you for the details, finance139.
I'm here to help you record these transactions.
Since the single payment (Expense) was downloaded on the Banking page, we can Find match to locate the two bills and linked them. I'll guide you with these steps:
I've also added this article as your guide in categorizing downloaded transactions: Review downloaded bank and credit card transactions and put them in the correct accounts..
Feel free to get back to us here if you have other questions about managing your expense-related transactions. I've got your back!
Thank you for the details, finance139.
I'm here to help you record these transactions.
Since the single payment (Expense) was downloaded on the Banking page, we can Find match to locate the two bills and linked them. I'll guide you with these steps:
I've also added this article as your guide in categorizing downloaded transactions: Review downloaded bank and credit card transactions and put them in the correct accounts..
Feel free to get back to us here if you have other questions about managing your expense-related transactions. I've got your back!
I discovered this back in January 2021 and reported it, and while some is part fixed, it is still possible to make a mistake for one scenario....
If you open an expense (either matched to a bank feed transaction or not), QuickBooks will pull up on the left all open bills and credits on the right hand side for that supplier. Great for matching outstanding bills to those bank feed transactions recorded as an expense instead of matching to a bill (either missed or bill received late)
Open the expense and match a bill previously recorded in a filed vat return to the open expense = works
Open the expense and match a bill in the same vat period as the expense = works
Open the expense and match a bill to an expense recorded in a previous vat return fails, as it creates an expense exception payment for this value on the vat return, duplicating the expense.
You should also note you cannot go back into the expense to amend as it will disappear, you will need to contact QuickBooks for support for a solution.
Test it this out in the sample company.
So although matching up expenses to bills seems to be an option, be very careful. If you are unsure, un-match the expense and add the payment to the bill in the correct QuickBooks method.
I think they have changed the UI since this was written. All steps can be followed until Step 4. Now there is no "Find Match" button. Do you have whatever the new way to do this is by chance? I have Bills I entered that were paid with one payment and I would like to match those two bills to the one payment.
Hello there, @MichaelM210.
The steps shared by my colleague @Adrian_A still work. And I have checked our records and haven't found any reports from other users about the Find Match button not showing when trying to match bank transactions in QuickBooks Online (QBO).
To further investigate the problem, you can use a private browser or incognito window to eliminate any browser history that may cause a glitch inside QuickBooks. You can refer to the following keyboard shortcuts below:
If this fixes the issue, close the private window and clear the cache on the regular browser. Otherwise, use other supported browsers to help narrow down the cause of this behaviour.
For future reference, here's a great resource about the best practices when reconciling: Learn the reconcile workflow in QuickBooks.
Please let me know if there's anything else I can do for you. I'll be standing by for your response. Have a great day.
Oh - I see it now. I had only clicked the Checkbox, not clicked into the full view to allocate the transaction. My apologies!
Hi Adrian_A
Hope you are well.
I am new to QBO and having trouble with something along the same lines. I have a supplier I get materials from and get billed monthly. When I pick up materials I receive a receipt for the amount that will be billed to my account. I upload that receipt to QBO "Plus" and create a bill. At the end of the month I uploaded the statement ($818.75) and categorize as an expense (it is unmatched waiting for a matched credit card transaction) . When I select the month end transaction in expenses it shows up with all the corresponding bills on the right side with an "ADD" option. I add the bills to equal the amount of the Expense (Which has now turned to bill payment).
I fill in "amount" box to equal the total of the bills for the month ($818.75) when I hit save, the transaction is now in my expenses as a bill payment with the amount of negative $818.75.
Hoping you can let me know what I am doing wrong?
I also tried manually matching the bills to the expense in the receipts for review. I could find all of the the bills, but when I tried to match them I got a noticing saying I could only match one transaction. I tried this in private window as well. Just not really sure what to do from here
Thank you for your time.
Welcome to the family of QuickBooks, @TyC. Detailing your concern enables me to provide a precise explanation and solution. I appreciate you for doing that.
I'll discuss this situation further as to why the bill payment is showing negative after saving it and how to fix it. This way, you're able to monitor them accordingly.
First, bills and expenses usually don't match up because they both serve the same purpose in QuickBooks Online. Use bills if you pay them later, then use expenses if you pay in real-time. For more details, see this article: Learn the difference between bills, checks, and expenses in QuickBooks Online.
Also, you don't need to create a bill since you already upload the receipts. I'd suggest deleting the bill payment and bill so that the transactions don't double. This will also correct the negative amount.
Go as follow:
3. Hit Apply.
4. Double-click the transaction, then press More and Delete.
Additionally, if there's no record found after uploading your receipt, you can make a new expense transaction from your receipt. Let me show you on how:
However, if one record is found, please select Match to connect your receipt to the transaction immediately. For more details, check out this article: Upload your receipts to QuickBooks Online.
Lastly, check out the following articles below to learn the different ways to record payments toward bills and other related matters:
Feel free to post a reply and tag me in the comments below if you have other questions about your vendor transactions. I'll take care of them for you. I hope everything is clear, @TyC.
Hello QB Support!
I have a similar issue, we created the bills for the receipts that we are meant to pay at some point in the future. However, once we paid we have an expense entry as well as the bill entry. We have both entries. Given that they serve the same purpose and we do not want duplicate amounts or duplicate items for something that should be together or be a single item. What can we do?
Thank you in advance.
Best,
Welcome to the Community, @Tamar9. I’m here to provide insights and assist you with banking concerns in QuickBooks Online (QBO).
If the Expense is downloaded from your bank, click Find Match to locate those two entries. You'll be able to match with different vendors as well. Just make sure the total of these transactions equals the expense.
Let me show you how:
If the expense is manually recorded, ensure it is accounted for under Accounts Payable (A/P).
Here's how:
When you are done, please link it to the Bill through Pay Bills so that it can be applied as credit.
I've added this screenshot as a reference.
You can also check out our guide on entering, editing, or deleting expenses in QuickBooks Online.
Lastly, check out the following articles below to learn the different ways to record payments toward bills and other related matters:
Let me know if you need any further assistance matching your transactions. The Community is always here to help. Have a great day!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here