Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowThere are no reports that show remaining balance on all purchase orders. I have to drill into each PO to find the remaining balance. Is there a way to get a report with remaining balances on all open PO's?
I've got your back, Nsargent. I'm here to ensure you'll get the report you need to show the remaining balances of all open purchase orders you've created.
Let's run an Open Purchase Order Detail report to enable you to show all the balances you've received and the amount paid to your vendor.
Here's how:
You'll now be able to view and check the remaining balances you've ordered and received from your vendors.
I'm adding this reference to guide you on how to add an accepted purchase order to a transaction for your vendor: Add purchase orders to expenses, bills, or checks in QuickBooks Online. It includes details steps on how to record these transactions.
You're always welcome to get back to this forum if you have additional questions when running reports. We're looking forward to assisting you further. Have a good one!
We do have the open balance displayed already. What happens is we use bill.com and for some reason bill.com does not sync invoices against PO's even though bill.com has field for this info. So, we have to manually input deductions against the PO anytime we enter an invoice in bill.com. I was wondering if the Open Balance column does not consider negative amounts when calculating. The remaining balance calculates and shows when we drill in so I am not sure why the report would act any differently. But it's the only "explanation" I can think of.
Hello there, @nsargent.
To answer your queries, it's no. The Open Balance column accepts negative amounts when calculating in QuickBooks Online (QBO).
The negative numbers on the accounts indicate a credit balance that made the company pay more than the expected amount.
Moreover, if you want to zero out the balance, you can sort it out by creating a Journal Entry.
Feel free to leave a reply if you have any additional questions about your opening balance in QBO. The Community team always has your back. Have a good one.
I am confused - you say "no" there's no way to display the balance but then you say QBO *does* accept negative amounts. We aren't able to receive invoices against the PO (thereby populating the Received column on the PO) - instead we add lines to input the negative amounts in the "Amount" column. I think there is definitely no way to have the balance display properly no matter how we try.
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