I appreciate you for providing the matching fields in your master file, @coolrite. I've got the suggestions you need to automate a custom report in QuickBooks Desktop (QBDT) Pro.
Let's customize the Transaction Detail by Account report so you can streamline this process. Making the three multiple accounts as column headers are currently unavailable, but you'll get the six display fields. I'll guide you how.
- Go to Reports from the top menu.
- Select Accountant & Taxes and click Transaction Detail by Account.
- Choose Customize Report.
- Set the Report Date Range in the Display tab.
- In the Columns drop-down list, check the Date, Num, and Amount options.
- Click OK.
- Go to the Filters tab.
- In the Filter drop-down menu, select Multiple accounts.
- Check Acct 4000, Acct 4001, and Acct 4002 in the Search Account window.
- Click OK twice.
The screenshots below show you the last seven steps.
Once done, the report will display the six matching fields in your master file. You can also use the Total amounts under each account. Here's what it looks like:
After that, I recommend memorizing the report to save the current customization settings. You can easily access it from the Report Center, Memorized Report List, or Reports menu.
You can also run and customize other reports, such as Profit & Loss, to keep track of your income and expense accounts. For more details, visit this article: Customizing Reports.
Don't hesitate to leave a comment below if you need anything else. I'm always up for assistance, @coolrite.