Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowUsing QuickBooks Desktop version. I'm trying to search within my checking register for transactions that are assigned to a particular account -- e.g., all advertising expenses paid for out of checking. Except I guess that's not the right terminology since "checking" and "advertising expenses" are both accounts, so what I need to do is find something that belongs to two accounts. Using CTRL-F and also filters on reports, if I select multiple accounts in the filter I get things that belong to either account, when I really want things that belong to both accounts.
@quo212 Well, it's not exactly the same thing, but there is a way to get practically what you want here.
If you create a P&L for the time period you want to consider (presumably All) and double-click on the amount for the expense you want to examine (presumably Advertising), it will open up a subreport for Advertising.
If you sort that subreport by Split, it will group the lines of the report by the Split account.
The Split account is typically the bank account used to pay the expense of the line in question.
From there, you can either ignore the Split groupings you don't need, or export it to Excel for some quick deletion.
@quo212 One additional note (that I still can't edit into my original post, Intuit
While I'm not a big fan of the Class system in QB, if you're willing to entertain its shortcomings, you could always assign a Class to the transactions associated with each bank account you use going forward; it is a new year, so this is probably about the best time to consider such a thing.
That would allow you to create a P&L by Class that should only contain transactions associated with said Class.
@FishingForAnswers 's advice is the easiest. If you want a report that just shows these transaction, you can go to Reports > Accountant & Taxes > Transaction Detail by Account. Click 'Customize Report', click the 'Filter' tab, choose 'Account' under the filter list, select your checking account under account drop-down, under 'Include split detail?', select 'For detail accounts matching' and select your advertising expense account. Adjust the dates as needed.
@Rainflurry "@FishingForAnswers 's advice is the easiest."
For once, I actually disagree with you; your answer seems a lot more efficient and accessible.
Thank you for this answer; I wasn't aware of that Filter function. Should be pretty useful in future.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here