cancel
Showing results for 
Search instead for 
Did you mean: 
loilars
Level 2

Customer:Jobs in reports

I am trying to run a report of AMEX transactions that includes the Customer:Job. Name and Source Name default to the vendor. How do I get the Customer:Job to show up in the report? I know how to do it if I want transactions for just one job but I'm trying to pull the whole AMEX GL. 

 

Additionally, is there any way to control which MEMO field appears in reports? 

Solved
Best answer May 02, 2023

Best Answers
BigRedConsulting
Community Champion

Customer:Jobs in reports

To include the Job name, include all the details of each transaction, not just the "source" rows of the transaction, the ones that use the credit card account.

 

A Journal report will show these details.  To create one, start at Reports  | Accountant & Taxes | Journal.

 

Then click Modify Report and filter it for the credit card account, including split details. The Account filter options should look like this, only using the desired credit card account on your chart of account:

 

Capture1.JPG

 

On the resulting report, the Customer:Jobs - where entered - will appear in the Name column on the detail rows of the credit card transactions.

View solution in original post

2 Comments 2
BigRedConsulting
Community Champion

Customer:Jobs in reports

To include the Job name, include all the details of each transaction, not just the "source" rows of the transaction, the ones that use the credit card account.

 

A Journal report will show these details.  To create one, start at Reports  | Accountant & Taxes | Journal.

 

Then click Modify Report and filter it for the credit card account, including split details. The Account filter options should look like this, only using the desired credit card account on your chart of account:

 

Capture1.JPG

 

On the resulting report, the Customer:Jobs - where entered - will appear in the Name column on the detail rows of the credit card transactions.

loilars
Level 2

Customer:Jobs in reports

This answered both questions, thank you so much!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us