Get 50% 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.
quo212
Level 1

How do I search for transactions with a specific account within a single register/account

Using 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.

4 Comments 4
FishingForAnswers
Level 10

How do I search for transactions with a specific account within a single register/account

@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.

FishingForAnswers
Level 10

How do I search for transactions with a specific account within a single register/account

@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.

Rainflurry
Level 15

How do I search for transactions with a specific account within a single register/account

@quo212 

 

@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.

FishingForAnswers
Level 10

How do I search for transactions with a specific account within a single register/account

@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.

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

Need to get in touch?

Contact us