Skip to main content
A
AV1611
September 18, 2021
Solved

SIMPLE EXPENSE REPORT

  • September 18, 2021
  • 1 reply
  • 0 views

   I 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!!!

Best answer by JessT

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.

 

  1. Go to the Reports menu.
  2. Choose Custom Report, and then Transaction Detail.
  3. Set the date range, click Filters, and then the Account filter.
  4. In the Account droplist, select Multiple accounts.
  5. In the Select Account window, choose Payroll Expenses and your youth camp expense account.
  6. Click OK and then OK again on the previous window.
  7. 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!

1 reply

JessT
JessTAnswer
September 18, 2021

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.

 

  1. Go to the Reports menu.
  2. Choose Custom Report, and then Transaction Detail.
  3. Set the date range, click Filters, and then the Account filter.
  4. In the Account droplist, select Multiple accounts.
  5. In the Select Account window, choose Payroll Expenses and your youth camp expense account.
  6. Click OK and then OK again on the previous window.
  7. 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!

    A
    AV1611Author
    September 18, 2021

    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!!!

      Rose-A
      Rose-A
      September 18, 2021

      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:

       

      1. Go to https://desktop.apps.com/home#!category/10368/6984.
      2. Search for apps in the search box.
      3. 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.

        Terms & ConditionsAccessibility statement