Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Adding a field to a customer report

Hi,

I'm using QuickBooks Desktop Pro 2017

We have just started emailing invoices and offering online payment. I import my invoices using iif. To get the information for the iif file, I run a customer report, export it to excel, and then use that to do a mail merge.

I learned last year that I needed a "To Send" field in my TRANS line but I can't find a report that includes "Preferred Send Method." I use a memorized Customer Contact List but that field is not an option and I can't find another report that includes it that I could even export and merge with my current report. 

Any suggestions? 

Solved
Best answer April 08, 2019

Best Answers
QuickBooks Team

Adding a field to a customer report

Hello, bgeiger.

 

Good to see you here in the QuickBooks Community. Let me help guide you on how to pull up the report you need in QuickBooks Desktop. 

 

You can run the Transaction List by Customer report and customize it to show the Preferred Send/Delivery Method information. Here's how:

  1. At the top menu bar, click Reports.
  2. Go to Customer & Receivables.
  3. Select Transaction List by Customer
  4. Click Customize Report.
  5. Select Display option.
  6. On the Columns tab, type-in and select the Preferred Delivery Method.
  7. Click OK
  8. Change the date range.

For additional reference, you can check this article on how to customize reports in QuickBooks Desktop

 

This will get you on the right track. Feel me in if you have additional questions about the Transaction List by Customer report. I'll be around to help. 

View solution in original post

3 Comments
QuickBooks Team

Adding a field to a customer report

Hello, bgeiger.

 

Good to see you here in the QuickBooks Community. Let me help guide you on how to pull up the report you need in QuickBooks Desktop. 

 

You can run the Transaction List by Customer report and customize it to show the Preferred Send/Delivery Method information. Here's how:

  1. At the top menu bar, click Reports.
  2. Go to Customer & Receivables.
  3. Select Transaction List by Customer
  4. Click Customize Report.
  5. Select Display option.
  6. On the Columns tab, type-in and select the Preferred Delivery Method.
  7. Click OK
  8. Change the date range.

For additional reference, you can check this article on how to customize reports in QuickBooks Desktop

 

This will get you on the right track. Feel me in if you have additional questions about the Transaction List by Customer report. I'll be around to help. 

View solution in original post

Level 1

Adding a field to a customer report

Thanks - that's exactly what I was looking for.

Barb

QuickBooks Team

Adding a field to a customer report

You're very much welcome, bgeiger.

 

I'm glad that I was able to help you today. Please know that you're always welcome to post if you have any other concerns about your QuickBooks. The Community team will always here to help you out. 

 

Wishing you and your business continued success. 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us