Skip to main content
A
AMartin11
January 15, 2024
Question

Transaction list by Customer - debits and credits

  • January 15, 2024
  • 1 reply
  • 0 views

Hi, I am a fairly new user to QB and have just run the new enhanced "transaction list by customer" report. The "amount" column is showing absolute values ie. debits and credits are all showing as positives. If grouping by customer, the subtotal by customer is therefore adding all values together to give an incorrect total eg. a sales invoice of £100 and a customer receipt of £100 are both showing as positive and subtotal to £200 rather than the sales invoices as £100, the receipt as -£100 and a subtotal of zero.  Has anyone found any logic behind this? The same report on the supplier side shows invoices as debits and payments as credits, which is exactly as I'd expect. So I'm at a loss why the Customer side doesn't work the same. Thanks

    1 reply

    A
    Ashleigh1
    January 15, 2024

    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. 

    A
    AMartin11Author
    January 16, 2024

    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. 

    A
    AMartin11Author
    January 16, 2024

    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.

    Terms & ConditionsAccessibility statement