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

Individual Customer All Transaction with Debit, Credit, Balance and Open Balance Columns for QuickBooks Desktop Pro 2019

How to generate individual customer complete report with following columns for QuickBooks Desktop Pro 2019.

 

1. Type

2. Num

3. PO Number

4. Date

5. Account

6. Due Date

7. Aging

8. Debit

9. Credit

10. Balance

11. Open Balance

12. Memo

 

I have attached excel sheet for the sample report format. Which is created manually with the help of exporting transactions.

 

3 Comments 3
Rubielyn_J
QuickBooks Team

Individual Customer All Transaction with Debit, Credit, Balance and Open Balance Columns for QuickBooks Desktop Pro 2019

It's my pleasure to help you generate a report showing all customer transactions in QuickBooks Desktop, @echemaccounts.

 

To display all the information you've mention above, we can open the Customer Balance Detail report and add some filters. Let me show you how: 

 

  1. Open your company file.
  2. Choose the Reports menu at the top portion.
  3.  Select the Customers and Receivables tab and then click the Customer Balance Detail report.
  4. Click the Customize Report button.
  5. In the Display tab, go to the Columns section. 
  6. In the Columns section, put a checkmark next to TypeNumPO NumberDateAccountDue DateAgingDebitCreditBalanceOpen Balance, and Memo. 
  7. Once done, click OK.
    rep.PNG
    rep1.PNG

To learn more on how to personalize your report, feel free to check out this article: Customize reports in QuickBooks Desktop.

 

You can also memorize reports in QuickBooks if you want the same settings of the customized report to be available for future use. This way, you do not have to go through the customization process again.

 

That's should do it. Let me know if you have other concerns with managing reports in QuickBooks. I'll get back to you right away. Keep safe.

echemaccounts
Level 1

Individual Customer All Transaction with Debit, Credit, Balance and Open Balance Columns for QuickBooks Desktop Pro 2019

Thanks! It works.

How to get such report for a single customer.

Rea_M
Moderator

Individual Customer All Transaction with Debit, Credit, Balance and Open Balance Columns for QuickBooks Desktop Pro 2019

I'm glad you're able to pull up the right report and get all the necessary data you need, @echemaccounts.

 

While you're on the Customer Balance Detail report window, you'll have to filter its display for a single customer's transactions. Let me guide you how.

  1. Go to the Customize Report button.
  2. Click the Filters tab.
  3. In the Choose Filter field, type in Name, then select the Name option.
  4. In the Name drop-down, select the name of the customer.
  5. Click OK.

 

I've attached a screenshot below for your reference.

 

To learn more about generating a customized report in QBDT, you can check out this article: Customize reports in QuickBooks Desktop. Then you can memorize it to pull up the same settings of the said report.

 

Also, I'm adding this article to learn more on how QuickBooks generates reports and displays data based on a set of instructions: Understand reports. It also includes the complete list of available reports in QBDT and their description.

 

Let me know in the comments below if you have other concerns about customizing reports and managing customer transactions in QBDT. I'm just around to help. Take care always.

Need to get in touch?

Contact us