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

Why would Transaction Report by Customer show Payments as positive number?

 
4 Comments
QuickBooks Team

Re: Why would Transaction Report by Customer show Payments as positive number?

Greetings, JANICENAPIERjanicen.

 

I'm here to explain why the Transaction List by Customer report would show payments as positive numbers.

 

The reason why these transactions show as positive is that they debit the Target account. In this case, the Target would be the Deposit To account, which could be the Undeposited Funds or Bank account, used when you entered the payment.

 

On the other hand, if your transactions will credit the Target, then it will be shown as a negative amount. You can verify this by checking out the Transaction Journal of each transaction. Let me walk you through the steps on how to pull this up:

  1. Click Sales in the left navigation menu.
  2. Go to the All Sales tab.
  3. Find the Payment and select it.
  4. Click More.
  5. Choose Transaction Journal. You can follow the same steps for other sales transactions.

I hope this clears up everything. Don't hesitate to reach out to me again if there's anything else I can help you with. Thanks for dropping by, wishing you and your business all the best.

Level 1

Re: Why would Transaction Report by Customer show Payments as positive number?

is there a simple report to show transaction history for a customer which has invoices as positive, payments and credits as negative giving the total balance of the transaction list to match the balance due for payment?

 

This is a fairly basic report, no?

 

Customer transaction history is something i use daily and surely most businesses utilise this?

Anonymous
Not applicable

Re: Why would Transaction Report by Customer show Payments as positive number?

Hello, Create_Properties.

 

You can create a customer statement. Depending on the date you’ve selected, this will show invoices (positive), payments, credit memo (negative). This will also reflect the customer’s remaining balance. Here’s how create this:

  1. Go to Sales from the left menu. 
  2. Go to Customers tab. 
  3. Locate the customer involve. 
  4. Click the drop down arrow next to Receive payment. 
  5. Select Create statement. 
  6. Set your desired date range. 
  7. Click Print or Preview. 

Please feel comfortable on visiting and posting your questions here if you need anything else. 
 

ProAdvisor

Re: Why would Transaction Report by Customer show Payments as positive number?


@Create_Properties wrote:

is there a simple report to show transaction history for a customer which has invoices as positive, payments and credits as negative giving the total balance of the transaction list to match the balance due for payment?

 

This is a fairly basic report, no?

 

Customer transaction history is something i use daily and surely most businesses utilise this?


@Create_Properties 

 

Yes, definitely, this should be a basic report dealing with customer transactions in any accounting program. Even after the filter and customize, it's hard to utilize these reports in QBO for the business.

 

I have seen many accounting programs and all kinds of standard reports, customized reports, management reports and so on. I have also seen all of the reports (even after customization) in QuickBooks Online QBO. There is not even one single report that I can give FIVE Stars (out of Five Stars) at this time. Most of them fall way below Three Stars.

Need to get in touch?

Contact us