Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
posted
Best answer September 18, 2021
Solved
Best Answers
Hi BWG1611!
Thanks for getting help with your Youth Camp expense report. It’s good to know that you’re adding memos to your transactions. They are useful when filtering out expenses for Youth Camp. I'll help you to include the payroll part.
To do this, we'll create a custom report that only shows the payroll expense and the youth camp expense transactions. Then, we'll export it to Excel to filter those with Youth Camp memos.
- Go to the Reports menu.
- Choose Custom Report, and then Transaction Detail.
- Set the date range, click Filters, and then the Account filter.
- In the Account droplist, select Multiple accounts.
- In the Select Account window, choose Payroll Expenses and your youth camp expense account.
- Click OK and then OK again on the previous window.
- In the Total By droplist, select Account list. This step groups and totals the transactions by account.
If you have non-Youth Camp payroll transactions like in my screenshot, you can export your report to Excel and remove them. You can also make more customizations before exporting the report to Excel.
That's it. Let me know if you have questions as you go through the steps. Take care and enjoy your weekend!
Hi BWG1611!
Thanks for getting help with your Youth Camp expense report. It’s good to know that you’re adding memos to your transactions. They are useful when filtering out expenses for Youth Camp. I'll help you to include the payroll part.
To do this, we'll create a custom report that only shows the payroll expense and the youth camp expense transactions. Then, we'll export it to Excel to filter those with Youth Camp memos.
- Go to the Reports menu.
- Choose Custom Report, and then Transaction Detail.
- Set the date range, click Filters, and then the Account filter.
- In the Account droplist, select Multiple accounts.
- In the Select Account window, choose Payroll Expenses and your youth camp expense account.
- Click OK and then OK again on the previous window.
- In the Total By droplist, select Account list. This step groups and totals the transactions by account.
If you have non-Youth Camp payroll transactions like in my screenshot, you can export your report to Excel and remove them. You can also make more customizations before exporting the report to Excel.
That's it. Let me know if you have questions as you go through the steps. Take care and enjoy your weekend!
Allow me to step in and provide some information regarding moving the corrected report from Excel to QuickBooks Desktop, BWG1611.
While the option to move the corrected report from Excel to QuickBooks Desktop is unavailable, you'll want to search for a third-party importing app that allows you to import corrected reports into QuickBooks.
Here's how:
- Go to https://desktop.apps.com/home#!category/10368/6984.
- Search for apps in the search box.
- Hit Search.
The system displays the list of applications available that match the description you entered and are compatible, and designed to work with QuickBooks Desktop. Once you find the right app, click to open it.
Also, I'd suggest submitting feedback to make the program better by going to the Send Feedback Online on your QuickBooks Desktop.
Additionally, I recommend customizing the report to get the specific details you need. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use.
Feel free to drop me a reply below if you need additional assistance. I'd be more than willing to lend you a hand.
