Accounts Payable by Item

Franklin Manitoba · ‎August 24, 2021

I am trying to create a report that will summarize my accounts payable by Item. We use QB Desktop Enterprise 2021.

We order a number of similar items from different vendors, with varied payment terms. I am trying to show the total item quantity we have received but have not yet paid for (regardless of vendor we received the items from). I reconcile in terms of vendor balances - that is not a concern.

I can print our my listing of unpaid bills and do some data entry into excel to summarize manually, but I would much prefer an automated approach.

I assume I am going to have to export into excel and use a pivot table or something similar???

Any help would be greatly appreciated.

Alex M · ‎August 24, 2021

Hi there,

It's important that you're able to view the amount of money owed to suppliers as well as deadlines so that you can pay them correctly. QuickBooks Desktop has a selection of reports to be able to show you various aspects of your business financials. I can point you in the right direction for support with reports.

I'm happy that you were able to find a workaround within Excel to be able to view this aspect of your accounts payable. In order to see if that's possible within the QuickBooks Enterprise system itself, I recommend reaching out to the QuickBooks Desktop support team. They'll be able to see if that's possible to be done within the software in order to save you time with the Excel export. You can find the ways to reach out to them in the Quickbooks Desktop software support policies.

If you have any other questions, feel free to reach out here.

Topics

Training

Community

Resources

Accounts Payable by Item

Accounts Payable by Item

Need to get in touch?