cancel
Showing results for 
Search instead for 
Did you mean: 
melissas-marines
Level 2

vendor open balance report with splits

I have entered some American Express bills in QB online.  In desktop I was able to create an open balance report with all the split detail.  With online I may have several transactions entered as a bill but when I export, it gives total balance with the expense category and amount.  My balance has several transactions that are not all the same expense.  For example, if you look at 12/13 Travel expense of $2185.62: it has 14 lines of travel and auto expenses.  I need to export the split detail to excel, not just the total bill amount entered.

Solved
Best answer January 25, 2024

Best Answers
Adrian_A
Moderator

vendor open balance report with splits

Hi Melissas,

 

I can see how convenient it could be to be able to pull up a report that breaks down the associated split transactions.

 

As of now, this data is unavailable in QuickBooks Online. With that, I suggest sharing a proposal with our developer's team. Here's how:

 

  1. Click the Gear icon.
  2. Under PROFILE, select Feedback.
  3. Enter a few words to describe your suggestions.
  4. Click Next.

 

For now, we may run the Transaction List with Splits report and then filter it to show only the Bills. I'll guide you through the steps.

 

  1. From the Reports tab, select Reports.
  2. Enter and select Transaction List with Splits.
  3. Click Customize.
  4. Modify the Report period.
  5. Go to the Filter drop-down.
  6. Tick the Transaction Type box, then select Bill.
  7. Click Run report.
  8. Click the Export icon.

 

Furthermore, you can check this article in case you want to open the report with the same customization settings: Memorize reports.

 

I'm always around whenever you have concerns about exporting reports.

View solution in original post

3 Comments 3
Adrian_A
Moderator

vendor open balance report with splits

Hi Melissas,

 

I can see how convenient it could be to be able to pull up a report that breaks down the associated split transactions.

 

As of now, this data is unavailable in QuickBooks Online. With that, I suggest sharing a proposal with our developer's team. Here's how:

 

  1. Click the Gear icon.
  2. Under PROFILE, select Feedback.
  3. Enter a few words to describe your suggestions.
  4. Click Next.

 

For now, we may run the Transaction List with Splits report and then filter it to show only the Bills. I'll guide you through the steps.

 

  1. From the Reports tab, select Reports.
  2. Enter and select Transaction List with Splits.
  3. Click Customize.
  4. Modify the Report period.
  5. Go to the Filter drop-down.
  6. Tick the Transaction Type box, then select Bill.
  7. Click Run report.
  8. Click the Export icon.

 

Furthermore, you can check this article in case you want to open the report with the same customization settings: Memorize reports.

 

I'm always around whenever you have concerns about exporting reports.

melissas-marines
Level 2

vendor open balance report with splits

Thank you.  This was very helpful.

RhoiceW
QuickBooks Team

vendor open balance report with splits

It's good to hear that all is working correctly on your end, melissas.

On behalf of my colleague, it's our pleasure to help you resolve this matter and be able to export your transaction with ease. Please know that your concerns are our utmost priority, and we want to provide you with the most accurate solutions that fit your every concern.

Leave us a comment or a reply if you have other concerns related to QuickBooks. We're always here to assist you anytime. Have a great day.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us