cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
accounts203
Level 1

Does anyone know how to run a customer open item statement to include customer journal entries as well as open invoices?

 
1 Comment 1
Ashley H
QuickBooks Team

Does anyone know how to run a customer open item statement to include customer journal entries as well as open invoices?

Hi there, @accounts203. I'm here to help you get the information you're looking for.

 

There are three types of customer statements to choose from in QuickBooks Online: Balance ForwardOpen Item, and Transaction Statement. They show the customer's summary of their invoices, payments, credits, and balances. Here's an article that provides detailed steps on how you can pull each of those statements: Create and view customer statements.

 

You can also run two reports: Customer Balance Detail and Adjusting Journal Entries. For the Customer Balance Detail report, you'd be able to see all the transactions and open balances for the customer. To see the Journal Entries, you'd have to run the other report and Filter to see just the person it was created for. I've provided the steps below on how to run the reports.

 

How To Run Customer Balance Detail Report:

  1. Go to Reports on the left-hand menu.
  2. On the right-hand side of the page, search for Customer Balance Detail.
  3. Once you have it opened, click on Customize and Filter by Customer.
  4. You may edit the date range and however you see fit.
  5. Press Run Report.

How To Run An Adjusting Journal Entries Report:

  1. Go to Reports on the left-hand menu.
  2. On the right-hand side of the page, search for Adjusting Journal Entries.
  3. Once you have it opened, click on Customize and Filter by Customer.
  4. You may edit the date range and however you see fit.
  5. Press Run Report.

For additional information on customization within reports, click here.

 

The Community is the place to go to find the best solutions for your QuickBooks needs. Have a great day!