Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI am trying to create a simple Expense Report for this year's Youth Camp.
All the Expenses came from either the "Youth Camp" Expense Account (for general youth camp expenses) and the "Payroll" Account (to pay the pastor for preaching the youth camp).
So, for my Filters I chose the "Youth Camp" Expense Account and the "Payroll" Account, and to make sure that I ONLY got this year's youth camp, I also chose "Youth Camp 2021" memo.
I made sure that I added "Youth Camp 2021" to the memo line for each transaction including Payroll.
My problem is that the report contains all the expense transactions from the "Youth Camp" Expense Account, but nothing from the "Payroll" Account. I can't seem to get the Payroll information to show up on the report!
Any help with this would be GREATLY APPRECIATED!!! THANK YOU!!!
Solved! Go to Solution.
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.
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.
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 JessT!
THANK YOU so much for replying to my post and providing the solution to my problem!!
I followed your instructions to the letter, and my Youth Camp Expense Report now contains BOTH Youth Camp Expenses and Youth Camp Payroll Expenses!! Absolutely AWESOME!!
I have one Follow-Up Question: I Exported my Youth Camp Expense QuickBooks Report into Excel, like you said to do, in order to remove a couple of transactions that didn't need in be in the report, which worked perfectly. Is there anyway to now move the "Corrected" report in Excel, back into QuickBooks again?
THANK YOU SO MUCH FOR YOUR HELP!!!
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:
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.
Hi Rose-A!
I really appreciate you getting back with me!!
I have spent about an hour searching for an app that will allow me to import reports into QuickBooks from Excel, but I couldn't find one.
I seems that you can import just about everything else from Excel into QuickBooks, just not a report.
Maybe I'm just not searching for the right thing...
THANK YOU SO MUCH FOR YOUR HELP!!!
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