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

Customer Balance Detail vs Transaction List by Customer report

What are the differences between the Customer Balance Detail and Transaction List by Customer reports?

3 Comments 3
Highlighted
Level 10

Customer Balance Detail vs Transaction List by Customer report

@martin_law23

 

Customer Balance Detail report = detail listing of all open unpaid customer invoices


Transaction List by Customer report = detail listing of all the sales forms (invoice, sale receipt, estimate, credit memo, refund receipt, delayed credit, delayed charge) in QBO.

Highlighted
Level 1

Customer Balance Detail vs Transaction List by Customer report

@vpcontroller

If I customize the Customer Balance Detail report by setting the A/R Paid filter to All in QBO, I get more transaction types like payment and credit memo.

Highlighted
Level 15

Customer Balance Detail vs Transaction List by Customer report

Transaction List = everything that has the Customer Name on it, such as Invoices, Payments, Sales Receipts, and even Checks you wrote with them as Payee. This is an Activities perspective; not AR, not sales, not anything financial. It should be the same Transaction listing you see when you click on their Customer Name, but a report is easy to browse, set a date range, etc.

 

Customer Balance Detail = only their AR activities, and it is not reliant on Open Balance. That is the same info but different perspectives, to see everything, even if they end at 0; or to see only Open, Unpaid and Unapplied AR transactions.

Need to get in touch?

Contact us