cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
EvanAS
Level 1

QBAR - Job Profitability Summary, Exclude jobs that are not invoiced.

I am using QuickBooks Advanced report writer, and using a slightly modified version of the starter report for Job Profitability Summary. I am trying to get the included pivot table to exclude any customers who have not been invoiced yet. The only modifications I have made is a list box for Job Status, and added an expression for Job Profit Margin as a percentage (Diff/Actual Revenue).

 

Long story short I am trying to exclude customers/jobs who have not been invoiced. Again this is the starter report for Job Profitability Summary  

 

If this can be achieved via a list box filter that's fine too, expressions make my brain hurt haha. 

 

3 Comments 3
LeizylM
QuickBooks Team

QBAR - Job Profitability Summary, Exclude jobs that are not invoiced.

I appreciate the time you've taken to ensure you can modify the Job Profitability report. Our primary aim is to help resolve your issue, MargieS. 

 

With that, I suggest contacting our customer care team. They have the tools to check your account and help you customize the report.

 

Here's how to reach them:

 

  1. Open QuickBooks Desktop.
  2. Go to the Help menu, then select QuickBooks Desktop Help.
  3. Click Contact Us at the bottom.
  4. Enter a brief description of your issue, then select Let's talk.
  5. Choose a way to connect.

 

Additionally, I've included articles that'll help you learn more about personalizing and memorizing your reports in QuickBooks Online:

 

 

I'm always prepared if you have more questions or concerns running project reports in QBO. Kindly leave a comment below, and I'll promptly lend a hand.

EvanAS
Level 1

QBAR - Job Profitability Summary, Exclude jobs that are not invoiced.

This is for Quickbooks Advanced Report writer, for enterprise desktop. Not the built in quickbooks reports. 

FateCandylaneT
QuickBooks Team

QBAR - Job Profitability Summary, Exclude jobs that are not invoiced.

 I appreciate you getting back to this thread, EvanAS. Let me provide additional input to help you exclude customers or job that haven't been invoiced when modifying reports in your account.

 

With QuickBooks Advanced Reporting, you can customize all aspects of your reports available in your company file. Here are some tips to keep you going:

 

  • You can use the starter reports that resemble existing reports.
  • The Library has common customization tools like table, chart, text & utility, etc.
  • In the Library, you can select any list box to add to your report. This helps filter the information you’ll use.
  • Right-click on any object you want to customize, then select Properties. This gives you the information you need in the right format.

 

For more detailed information, visit this guide: QuickBooks Advanced Reporting (QBAR) FAQ. This also includes training videos that can help you start and familiarize QBAR reporting.

 

However, if you require further guidance modifying specific details to your reports, I recommend reaching out to our Customer Care Team. They have additional tools to help you sort detailed information in your data reports.

 

  1. In your QBDT account, go to Help and select QuickBooks Help/Contact Us.
  2. Choose Contact Us and enter a brief description of your issue. Then, Continue.
  3. Sign in to your Intuit account, choose Continue, and then Continue with my account.
  4. We'll email you a single-use code. Enter your code and select Continue.
  5. Then, select to Chat with us or Have us call you.

 

Once everything looks good, you can start reviewing your accounts to ensure they always match your bank and credit card statements: Reconcile an account in QuickBooks Desktop.

 

I'll be on this forum anytime you need additional assistance managing reports in your account. Just leave a reply in the comments below. Keep safe!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us