QuickBooks Desktop- Statement that includes invoices and sales receipts together with balance

Hi there, Chemmark.

In QuickBooks Desktop (QBDT), standard statements are designed to track Accounts Receivable (AR), specifically focusing on invoices and their subsequent payments. Because Sales Receipts are immediate transactions that bypass AR entirely, they don’t appear on the default Balance Forward or Open Item statements.

To see both transaction types along with a running balance, you have two primary options: customize the Statement of Account or run the Customer Balance Detail report. Here's how:

1. Go to the Customers menu and select Create Statements.
2. Choose your Statement Date and the Statement Period.
3. On the right side, under Template, click Customize or go to Lists and then Templates and edit your Statement template).
4. In the Layout Designer, ensure the Description or Transaction columns are wide enough.
5. Check the box for Show invoice item details on statements if you need the specific lines from the Sales Receipts to show up.

Another option would be to run the Customer Balance Detail report and have it tailored to your preference. This report will allow you to see your invoices, payments, and sales receipts. To start, these are the steps:

1. Go to the Reports menu, select Customers & Receivables, then Customer Balance Detail.
2. Click Customize Report at the top left.
3. Go to the Filters tab.
4. Search for Transaction Type. In the dropdown, select Multiple Transaction Types.
5. Check the boxes for Invoice, Payment, and Sales Receipt. Click OK.
6. Go to the Display tab and ensure the Balance column is checked.
7. Click OK to run the report.

We encourage you to utilize the Reply button below if you have other questions about QuickBooks.