cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

selecting numerous accounts for custom ppp report

I'm using QB 2018  desktop non-profit edition.  I'd like to report my PPP expenditures for a 60-day period by using a custom 'transaction detail by account' for the selected accounts that I'm spending the PPP loan on.  When I use the filter option and the "multiple accounts" option I get a screen that lists all my accounts.  When I select an account, I get a little checkmark next to it.  The problem is this.  After I've selected multiple accounts, one ONE account goes in the report.  I am completely unable to get the report to have more than one account on it!  I've never created a report before, so I don't understand why this is.  I've been a programmer for a long time (though not in QB) and I tried holding down the shift or control key while I make the subsequent selections, but nothing seems to work!  Can someone help me? 

Solved
Best answer May 03, 2020

Best Answers
Highlighted
QuickBooks Team

selecting numerous accounts for custom ppp report

I appreciate the complete details you've shared, @dougraider.

 

Let's run the verify and rebuild tool to repair any transaction and list related-damages in your QuickBooks company file.

 

To Verify Data:

  1. Go to the File menu.
  2. Tap Utilities then Verify Data.
  3. Click OK on the prompt.

To Rebuild Data:

  1. Click the File menu.
  2. Go to Utilities and select Rebuild Data.
  3. Hit OK to back up your company file.
  4. Wait until the Rebuild is complete.
  5. Click View Results.

 Also, make sure that your program is updated to the latest version. Once completed, you can generate the Custom Transaction Detail report again.

 

Here's how:

  1. Go to the Reports menu.
  2. Scroll down to the Custom Reports section.
  3. Choose the Transaction Detail.
  4. From the Display tab, set the date range of the report.
  5. Select the Filters tab.
  6. Set the Account filter.
    • You can manually pick the expense transactions of choose Expense and Other Expense accounts.
  7. Click Ok.

Lastly, let's ensure that your PPP related-expense transactions are associated with the expense accounts you've selected.

 

By the way, I've added these articles to help  you resolved unexpected behaviors when using QuickBooks:

Keep me posted if you have other questions about generating reports in QuickBooks. I'm just a few clicks away.

View solution in original post

1 Comment 1
Highlighted
QuickBooks Team

selecting numerous accounts for custom ppp report

I appreciate the complete details you've shared, @dougraider.

 

Let's run the verify and rebuild tool to repair any transaction and list related-damages in your QuickBooks company file.

 

To Verify Data:

  1. Go to the File menu.
  2. Tap Utilities then Verify Data.
  3. Click OK on the prompt.

To Rebuild Data:

  1. Click the File menu.
  2. Go to Utilities and select Rebuild Data.
  3. Hit OK to back up your company file.
  4. Wait until the Rebuild is complete.
  5. Click View Results.

 Also, make sure that your program is updated to the latest version. Once completed, you can generate the Custom Transaction Detail report again.

 

Here's how:

  1. Go to the Reports menu.
  2. Scroll down to the Custom Reports section.
  3. Choose the Transaction Detail.
  4. From the Display tab, set the date range of the report.
  5. Select the Filters tab.
  6. Set the Account filter.
    • You can manually pick the expense transactions of choose Expense and Other Expense accounts.
  7. Click Ok.

Lastly, let's ensure that your PPP related-expense transactions are associated with the expense accounts you've selected.

 

By the way, I've added these articles to help  you resolved unexpected behaviors when using QuickBooks:

Keep me posted if you have other questions about generating reports in QuickBooks. I'm just a few clicks away.

View solution in original post

Need to get in touch?

Contact us