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