Transaction list by Customer - debits and credits

Hello AMartin11, thanks for posting on the Community page, so the income posts to debtors as it is money owing and the payments for bills post to creditors as money owing, when you post an expense it will then post to the bank account paid from. Any payments for the debtors then post to the bank account paid into and likewise for a bill payment. If you have an expense on the transaction list by customers it will be for a refund as the expense will be posted to debtors. anything with a minus on is more than likely a refund on the account. You can add onto the report if it has been paid or is still unpaid any estimate will show with the amount but the balance will be zero as it has been converted to an invoice. 

Thanks for your response Ashleigh. But I don't think this answers the question though. On the report "Transaction List by Supplier" a Supplier Bill (which is a credit transaction to the creditors ledger) is shown as a positive figure and the corresponding bill payment (the debit transaction to the creditors ledger) is shown as a negative ie. the bill and the bill payment net to zero, which is what you'd expect.
However on the report "Transaction List by Customer" the customer invoice (which is a debit transaction to the debtors ledger) is shown as a positive, but so is the corresponding payment by the customer (which is a credit transaction to the debtors ledgers). The subtotal for the customer is therefore  2 x the invoice value rather than 0. 

I've attached an extract from the report as an example, though the treatment is the same for the whole report, not just this customer. There are no negative figures on the whole report, whether the entries are debits or credits.  As an aside, the customer account shows the entries correctly and 0 balance as outstanding.

Hi AMartin11, thanks for getting back to us here. It is correct that the invoice posts to the debtors account (debit) while the invoice payment posts to the payment account (debit). You can view the transaction journal (Click on the transaction on the report to open > More > Transaction journal) to see how this is posted in the system. 

The Transaction List reports are simply designed to show all transactions for each customer or supplier. It is not intended to be used to view total revenue. If you're looking to view sales information, we recommend running the Sales by Customer Detail or Sales by Customer Summary reports instead.
 

Hello GeorgiaC,

If this is the "correct" treatment, then why is it that the "Transaction List by Supplier" doesn't apply the same (incorrect) logic? Your response below implies that a purchase invoice posts on the supplier account (credit) while the invoice payment posts to the payment account (credit). So according to your explanation, but would appear as positives on the report. Yet on the Supplier report, the invoice shows as a positive but the payment shows as a negative. Extract attached.

The supplier transaction list shows the correct treatment of debits and credits as they appear on the supplier ledger, the customer transaction list does not. 

Hello AMartin11, so it doesn't look right, can you please contact support via phone at 0808 234 5337 or chat so a screen share can be done and escalated to be looked into more for you thanks. 

Hi @Ashleigh1 

Yes this does seem to be an issue in QuickBooks.

We have started using customer accounts but realised we can’t rely on the Transaction list by Customer report and it shows both invoices and bank deposits as debits.

Thanks,

I appreciate you joining the thread, @Daniel12m.

Let me route you to the support group that can best handle this type of concern securely.

Currently, we don't have any ongoing investigation about the Transaction list by Customer report that shows the invoices and bank deposits as debits.

If you also encounter this type of concern. I suggest reaching out to our QuickBooks Support Team. This way, they can help you pull up your account securely and provide in-depth troubleshooting steps to resolve the issue. They can also create a ticket for investigation if needed.

Here's how:

1. On your company file, go to the Help menu.
2. Select Contact Us.
3. Enter your concern, then select Let's Talk.
4. Choose a way to connect with us:

• Start a chat with a support expert.
• Get a callback from the next available expert.

Please be aware that the scheduled times for the Call support are available from M-F, 8:00 AM to 10:00 PM, and S-S, 8:00 AM to 6:00 PM. See this article for further details: QuickBooks Online Support. Otherwise, you'll want to go through this website: Contact QuickBooks Support.

I'm attaching these articles to learn more about generating reports to show the data you need and in case you need to export your reports from your QBO account:

• Customise reports in QuickBooks Online
• Export reports, lists, and more

Please tag me in the comment section if you have other concerns or questions. I'm always here to back you up.

From my experience there would be very little point in @Daniel12m  reaching out to Quickbooks Support Team on this matter. They closed my ticket on this and refuse to accept that a report which treats both Customer Invoices and Customer Bank receipts as Debits is incorrect. They insist the report is working exactly as it was intended. Which is an odd response as it is clearly wrong and also the report works in contrast to how it behaves on the Supplier side. I'll just have to remember to steer well clear of this report.