LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Sam3Ste
Level 1

Customized Reports

I am trying to run a report filtered by Accounts: Donations Expense and Advertising Expense. It's also filtered by TransactionType: Bill and Check. My issue is the Amount shown on the report is not the true Amount of the Bill. To explain further, we have a two companies and some bills get split between both companies. Rather than send the vendor two checks, I enter the bill in one company and split the transaction as "Donations" and "Due from Company2" . However the amount on the line for "due from Company2" is not showing up on my report. Meaning, when I look at the report it looks like we cut a check for $312.50 (because that's the amount I coded to Donations) but in reality the check was for $625 because there's a second line on the bill for $312.50 coded to Due from Company2. $625 is the amount I want to show up on the report. What customized option do I need to include in order for that to happen?

3 Comments 3
Angelyn_T
Moderator

Customized Reports

Thank you for reaching out, @Sam3Ste. I appreciate your effort in filtering your report to get the information you need. Let me help you customize it to get the bill amount of $625.

 

If I may ask, is the Due from Company2 added as an account? If yes, make sure to include this in your Accounts to get the full amount of your transaction.

 

 Here's how:

 

  1. From the report's page, go to the Customize Report menu.
  2. Click on Filter, then Account.
  3. Choose Multiple accounts, then mark the accounts you need (Due from Company2).
  4. Tap OK.

 

Switching the account's basis from cash to accrual will also isolate the issue. 

 

However, if you entered the bill differently, please feel free to share a screenshot of your transaction so I can look into this further.

 

On the other hand, I'm adding these resources for more hints while running and customizing your reports in our system:

 

 

You may also memorize their customization settings to be available for future use. Check out this link as your guide: Create, access and modify memorized reports.
 

 Mention my name in the comment section below if you have follow-up concerns. I'm just here to help you again. Keep safe!

Sam3Ste
Level 1

Customized Reports

Thank you for your reply. I understand your explanation but it doesn't quite work with our set up. The way you have the screenshot it shows two different bills. When I enter a bill that is split, I enter it as one bill but two lines on the expense tab. Our Due from Company2 is an other current asset. When I select Due from Company2 in the transaction type, it brings up everything I've coded Due from Company2, and I want this report to just be Donations/Advertising.

 

 
 

 

 

 

BigRedConsulting
Community Champion

Customized Reports

RE: I am trying to run a report filtered by Accounts: Donations Expense and Advertising Expense....

Rather than send the vendor two checks, I enter the bill in one company and split the transaction as "Donations" and "Due from Company2" . However the amount on the line for "due from Company2" is not showing up on my report.

 

Yes, that's because you filtered the report for two accounts that are not "due from Company2".  If you want to see that detail you have to add that account to the filter.

 

RE: ...but in reality the check was for $625 because there's a second line on the bill for $312.50 coded to Due from Company2. $625 is the amount I want to show up on the report. 

 

You seem to want both to exclude "due from Company2" and include it, but QB won't do that.

 

However, you could add the Accounts Payable account to your filter and then you would see the bill total but as a separate line item. You can't get QB to show the bill total amount on one of its detail rows.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us