Sales Transaction Report

Question

I would like to generate a sales report for 1 particular customer that shows transactions (sales invoices & payments received).  However, I am only interested in open invoices and the transactions go back to July 2021.

I ran an Invoice Transactions (Accrual) report from the History option of one of the invoices which shows the charges and payments but when run this report via the Reports tab the payments don't show.  I would also like the report to include the closing balance.   Thank you

Isaiah_C · Answer

Hi @LF5,

I understand that you would like to generate a sales report for a specific customer that shows open invoices and payments received since July 2021, and you'd like the report to include the closing balance as well. If customer ledger report doesn't work for you or if you prefer an alternative option, you might want to try these steps.

To achieve this, you can go to the Reports tab. Navigate to Sales and select Sales [Customer Summary]. Set the date range to start from July 2021 to the current date. Select the specific customer you are interested in. In the report options, filter to show only open invoices.

Once the report is generated, click on the Insert/Modify button. Add the Balance Due column to the report to see the outstanding amounts for each invoice. Ensure that the Payments Received column is included as well.

Since you mentioned that payments don't show up when you generate the report from the Reports tab, I recommend running a Customer Payments Report for the same date range. This report can give you a detailed view of all payments received. You can cross-reference this report with the Sales [Customer Summary] report to get a full picture.

The Balance Due column in the Sales [Customer Summary] report should provide you with the closing balance for each report. If you need a total closing balance for the customer, you can export the report to Excel and sum the Balance Due column.

LF5 · Answer

Hi Mike, when I run that report it doesn't have any amounts. It's just a list in date order of transactions.  I would like a report that shows each sale and then the payments associated with that sale (like you see on the history of the invoice in the register).

Mike_James · Answer

Hi @LF5 , for AccountRight, try the customer ledger report.