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 nowFor example, I have 5 different bank ledgers, 10 different income codings...what is the best way to search for transactions on only 1 (of the 5) bank ledgers and one (of the 10) income types?
Please advise.
Hi there, @belowradar. I'm here to help you get the report you need.
To help you search for a transaction under the specific bank ledgers and income types, you can run the Transaction Detail by Account report. Then, export the report to Excel to remove information you don't need. Here's how:
For more details about managing reports in QBDT, feel free to visit this article: Customize reports in QuickBooks Desktop.
Also, in QBDT setting up preferences for your reports to customize it depending on your business needs is easy. For the detailed instructions, check out this link: Set report preferences.
Keep me posted if you need additional assistance in getting a report for a transaction under the specific bank ledgers and income types. I'll be always around to help. Have a good one.
I dont want to have to use excel...is there no way to have quickbooks generate? This seems unlikely.
so, quickbooks is unable to generate this report? This seems unlikely. How can I avoid using excel to generate "specific bank account" with "specific income amount"
Thanks for getting back to us, @belowradar.
I'm here to help share additional information about the report you need in QuickBooks Desktop (QBDT).
In making a report there's no other option, you can filter the bank account transactions but you can't filter what income account you see.
To learn more about reports in QBDT and how to customize them, you can check out this article: Customize reports in QuickBooks Desktop.
You can also export your report to Excel. This way it'll be easy to convert the report to your specified file format. See this article for more details: Export reports as Excel workbooks in QuickBooks Desktop.
Please know that I'll be right here to help you if you have any other questions about running reports in QBDT. I'll be always happy to help you!
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