I can't see any report that would show my Accounts Payable by supplier. How can I find this on QBO?

Anonymous · ‎January 18, 2022

McBrideBookkeeping · ‎January 23, 2022

Hey Tonic,

Yeah, unfortunately, @Jen_D was on the right track there with her answer, You do not have "Payables" with the Easy Start Plan, so naturally there's no payables report. See the below screenshot from her Link on "What reports are included in your Plan"

Easy Start is meant to track expenses, not bills, hence the lower tier/price. It suits some people for sure who just track expenses when they are paid.

I guess, good new is that you don't' owe anyone anything (at least, according to QBO & yes that was a poor taste joke, sorry, you gotta laugh or cry sometimes, right?) So yeah, the bad news is, the entries you've made so far were all posted as "Expenses" meaning they've been posted as Paid to your Ledgers.

If you have a look at your Balance Sheet it should confirm, you have NO Accounts Payable balance.

So if you're thinking you entered unpaid bills in QBO then I'm afraid they were posted to a bank or Credit Card Account. You'll need to reconcile those in order to find the unpaid items and take them out.

Also you should still be able to pop into your Supplier Menu and look up transactions by Supplier that way, but again, QBO thinks these are paid, and there would be a payment account (Bank or Credit Card) listed on each of them.

I hope this helps get you on the right track but if not, reach out to a QBO Proadvisor in your area or look for a recommendation from a colleague or trusted source. Everything can be fixed with the right knowledge, trust me!

Please mark this answer as a helpful solution if it answers your question
Thanks
McBride Bookkeeping

View solution in original post

Nick K · ‎January 19, 2022

Hi Tonic EC.

Being able to pull up the information that you want when you need it is one of the great things about QuickBooks Online. I'd be happy to help you pull up your accounts payable reports.

In order to pull up your unpaid bills and what you owe your suppliers you can run the Supplier Balance Detail. This will give you a break down of each bill that has yet to be paid for each supplier you have in your QuickBooks Online account. To find this report you'll need to go to Reports>What You Owe>Supplier Balance Detail. Another option you can use is Supplier Balance Summary which just shows how much each supplier is owed but won't show the bills.

If you have any questions let us know and we'd be happy to help.

Anonymous · ‎January 20, 2022

Hi Nick - thanks for the reply. Unfortunately I do not see a 'What You Owe' section in the Reports listing, nor do I see 'Supplier Balance Detail' or 'Supplier Balance Summary' reports listed or available by search. I only have a 'Expenses and Suppliers' section with a few irrelevant report options. How do I find these reports you mentioned?

JamesM4 · ‎January 20, 2022

Hello Tonic EC. Could I have you access your account using a private/incognito window? This is a good method for by-passing browser display issues while using QuickBooks. Try this out and let me know if you're now seeing the reports.

Anonymous · ‎January 20, 2022

I've attached a screenshot. These are all the supplier-related reports I see, as well as the ones that pop up when I search 'Supplier'.

Trish_T · ‎January 21, 2022

Hi Tonic EC,

Thanks for getting back to us here. QuickBooks Online provides the flexibility you need with additional options for customizing your reports. I'd be happy to provide some insight here so you can locate the required elements of your report.

Here's how to see the accounts payable on the Transaction List by Supplier report:

1. From the left menu open Reports

2. In the Search field, enter Transaction List by Supplier and open the report

3. Click on the small Gear (settings) in the top right of the report

4. Hit Show more to expand the list of options

5. Checkmark the box next to A/P paid and any additional preferences

You're all set!

Please don't hesitate to reach back out with any other questions. We'd be glad to assist.

Anonymous · ‎January 21, 2022

Hi! There is no A/P paid box (see attached screenshot).

Jen_D · ‎January 22, 2022

Hello Toni,

Thanks for reaching out to us regarding this reporting concern in QuickBooks Online.

For this, I need to verify the type of service you have for us. Are you using EasyStart, Essentials, or Plus? I am asking because every subscription has it's own set of reports available.

See this link to learn more: Reports included in your QuickBooks Online subscription

For now, you can try a Transaction List by Supplier report and filter the transaction types you want to see. Check out this report for the steps to customize a report in the program: Customize reports in QuickBooks Online

Visit us again for the additional details or mention me on your posts. I'll be right here to help you out. All the best!

Anonymous · ‎January 23, 2022

Hi - I am on an EasyStart plan. I am just looking to see my outstanding accounts payable for a specific supplier, but can't seem to find where to see that.

Thanks!

McBrideBookkeeping · ‎January 23, 2022

Hey Tonic,

Yeah, unfortunately, @Jen_D was on the right track there with her answer, You do not have "Payables" with the Easy Start Plan, so naturally there's no payables report. See the below screenshot from her Link on "What reports are included in your Plan"

Easy Start is meant to track expenses, not bills, hence the lower tier/price. It suits some people for sure who just track expenses when they are paid.

I guess, good new is that you don't' owe anyone anything (at least, according to QBO & yes that was a poor taste joke, sorry, you gotta laugh or cry sometimes, right?) So yeah, the bad news is, the entries you've made so far were all posted as "Expenses" meaning they've been posted as Paid to your Ledgers.

If you have a look at your Balance Sheet it should confirm, you have NO Accounts Payable balance.

So if you're thinking you entered unpaid bills in QBO then I'm afraid they were posted to a bank or Credit Card Account. You'll need to reconcile those in order to find the unpaid items and take them out.

Also you should still be able to pop into your Supplier Menu and look up transactions by Supplier that way, but again, QBO thinks these are paid, and there would be a payment account (Bank or Credit Card) listed on each of them.

I hope this helps get you on the right track but if not, reach out to a QBO Proadvisor in your area or look for a recommendation from a colleague or trusted source. Everything can be fixed with the right knowledge, trust me!

Please mark this answer as a helpful solution if it answers your question
Thanks
McBride Bookkeeping

Anonymous · ‎January 25, 2022

Thanks McBride - that makes sense. Unfortunately I do use journal entries to record payables so it seems like I will have to reconcile manually. Appreciate the help!

McBrideBookkeeping · ‎January 26, 2022

Ouch,

Sorry to hear that Tonic

Well yeah, Journals are not really the intention with such a powerful accounting software.

They're generally a last resort when a "transaction" won't work.

I realize every transaction posts a journal of sorts behind the scene in the GL but reporting, dashboards, taxes etc they all rely on transactional flags in QBO and other software so Journal entry can circumvent that and skew reporting unless you're very aware & even the best of us forget something.

I highly recommend you upgrade and use the actual payables, it's a breeze, quicker, more flexible and provides accurate reporting.

Best of Luck either way !

Topics

Training

Community

Resources

I can't see any report that would show my Accounts Payable by supplier. How can I find this on QBO?