HelloI´m having a reporting issue where a fundamental report is impossible to generate accurately.I need a single report that lists ALL ins and outs (deposits and payments) for a specific Bank Account over a month, showing the correct Expense Category for every transaction.When I run standard reports like Transaction List by Date, General Ledger, or Transaction Detail by Account, the following happens:Direct Expenses (Checks/Expenses): Correctly show the final category (e.g., Supplies, Internet, Membership).Paid Bills (Bill Payments): The 'Split Account' or 'Category' column ALWAYS shows 'Accounts Payable (A/P)' instead of the actual expense category (e.g., Subcontractor, Utilities, Rent) that was assigned when the Bill was first entered.This forces me to manually click into every single Bill Payment to verify the true expense, which defeats the purpose of the report.Is there a way to force ANY report in QuickBooks Online (even a custom one) to "see through" the Accounts Payable account and display the final Expense Category (the one from the Bill) in a single column?Thank you for any workaround

Question

How to get Expense Categories (not A/P) from Paid Bills?

Forum|Forum|8 months ago
November 5, 2025
1 reply
9 views

Hello

I´m having a reporting issue where a fundamental report is impossible to generate accurately.

I need a single report that lists ALL ins and outs (deposits and payments) for a specific Bank Account over a month, showing the correct Expense Category for every transaction.

When I run standard reports like Transaction List by Date, General Ledger, or Transaction Detail by Account, the following happens:

Direct Expenses (Checks/Expenses): Correctly show the final category (e.g., Supplies, Internet, Membership).
Paid Bills (Bill Payments): The 'Split Account' or 'Category' column ALWAYS shows 'Accounts Payable (A/P)' instead of the actual expense category (e.g., Subcontractor, Utilities, Rent) that was assigned when the Bill was first entered.

This forces me to manually click into every single Bill Payment to verify the true expense, which defeats the purpose of the report.

Is there a way to force ANY report in QuickBooks Online (even a custom one) to "see through" the Accounts Payable account and display the final Expense Category (the one from the Bill) in a single column?

Thank you for any workaround

QuickBooks Online

Regina_Lend_A_Hand_Accounting

Level 2

Greetings Ingrid!

You’re right — QuickBooks Online reports will always show “Accounts Payable (A/P)” for Bill Payments, because technically the Bill Payment transaction is reducing the A/P liability rather than hitting the original expense categories. The system treats the Bill (not the payment) as the place where the expense categories live, so most standard reports stop at the A/P level.

Unfortunately, there isn’t a single built-in report that “looks through” the A/P account to show the original Bill expense categories alongside the payments. That’s a known limitation in QBO reporting.

Here are a few workarounds that can help:

1. Run a Transaction Detail by Account report and filter it for:
2. Distribution Account = your bank account
3. Include Bills and Bill Payments in the Transaction Type filter
4. Sort or group by Vendor
This will at least show the payment date and link you to the related Bill that contains the true category.

Export both the “Transaction List by Vendor” and “Vendor Balance Detail” reports to Excel and combine them — that gives you both the Bill details (with expense categories) and the payment information, which you can merge using the Bill number or vendor name.

If you use QuickBooks Online Advanced, you can build a custom report using the Custom Report Builder to join Bills and Bill Payments and expose the expense categories on the same line. It’s still imperfect, but it’s the closest option inside QBO.

So, in short — QBO doesn’t natively “see through” Accounts Payable, but with either a custom Advanced report or an Excel merge, you can get to the view you need.

– Regina Pitts, Advanced Certified QuickBooks Online ProAdvisor

Sign up

Login with SSO

Let's get you signed in

Login with SSO