Simple Payments Received Report

Forum|Forum|9 months ago
October 23, 2025
4 replies
18 views

Hello - I have a need to run a very simple payments received report to be read by non-accounting (production) staff.

Customer Name

Invoice Date

Invoice #

Payment Rec'd Date

Payment Type

Payment Amount

Balance Due

Any help would be greatly appreciated

QuickBooks Desktop

mv32

Level 8

Hi, @jloomy. You can run a report that includes the details you need by using the Customer Balance Detail report. This report can provide the following information:

Customer Name
Invoice Date
Invoice #
Payment Rec'd Date
Payment Type
Payment Amount
Balance Due

Some of the terms in QuickBooks might look slightly different, but match the information you're looking for:

The Invoice Date and Payment Received Date appear under the Date column.
The Payment Type is referred to in the report as Pay Met (Payment Method).
The Payment Amount is listed in the Amount column.
The Balance Due shows up under the Balance or Open Balance column.

If you want to customize the report to focus on only the relevant details, you can follow these steps:

Go to Reports > Customers & Receivables and select Customer Balance Detail.
Click Customize Report.
Go to the Display tab and check the columns you want to include (Type, Date, Num, Pay Met, Balance/Open Balance).
Uncheck any columns you don’t need.
Click OK to save your changes.

This should help create a simple report for your production staff. Please let us know if you need further help.

jloomyAuthor

Do you happen to have a method to run the same exact scenario in QB Online Advanced? I finally got it dialed in using your recommendations only to discover that memorized reports do not migrate over. So frustrating!

Sign up

Login with SSO

Let's get you signed in

Login with SSO