cancel
Showing results for 
Search instead for 
Did you mean: 
yasbas
Level 3

How can I see my income by type?

Hello,

 

In my business I fully utilise

'Sales receipts;' - for direct spot cash sales

'Invoice;' - for goods supplied that will be paid later

'Estimates;' - for quotations that will possibly turn into an invoice. 

 

Anyway when an Invoice is paid/partially paid by a customer it appears as a 'payment'. My issue is the following.

 

Ocassionally I need to present a sales report of the month so far and in particular 'actual cash collected'. Due to the nature of the way QBO is setup it is broken down into 3 revenue streams to take in. 

 

Sales Receipt

Invoice

Payment

It is simple to filter out Sales Receipt; just select Sales Receipt and 'This month'

Invoice is the same process but then I do a simple subraction from total invoice sales at the bottom of the page less the outstanding balance to get actual funds received. 

 

Now the interesting one; Payments. Firstly there is no option really for 'Payments' so I've found 'All Transactions' to be the most useful option and 'This Month' selected. 

 

The problem is that I need to asertain the Invoices that have been paid in the current month (say October) but were issued in months prior (ie. September, august etc). I can't seem to find a way to do that unless I manually add each invoice one by one and on top of that I need to go into each payment because I cannot otherwise see the actual date the invoice was issued. QBO will only display the date the payment was made.

 

Is there a way to filter create a report that shows me monies received in the current month but for invoices issued in the previous months? 

 

Hope the above makes sense. 

 

Cheers. 

 

Yasbas

 

1 Comment 1
ReymondO
QuickBooks Team

How can I see my income by type?

Hi there, @yasbas.

 

You can run the Invoices and Received Payments report to view the payments you’ve received and the invoices that go with them in QuickBooks. Let me show you how:

 

  1. Go to Reports and run the Invoices and Received Payments report.
  2. Filter the Report period to Custom.
  3. Select the date. 

invoice and receive.PNG

This will now show you the list of invoices together with payments received for each of them. 

 

Moreover, you can customize your reports to get the details that matter the most to your business.

 

If you have any other QuickBooks-related concerns, simply add them in this thread. We'll be happy to assist you further. Have a good one.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us