cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
ar2
Not applicable

Report to show CUSTOMER paid invoices for the particular month by sales rep.

Desktop Pro 2017, I need to know how to create a report that will show me:

  • Only the paid customer invoices for "paid in set month" (invoices could be in previous months or current).
  • By Sales Rep.

The Sales by Rep Detail, with the customized adjustment of paid status of "closed" WAS great EXCEPT now that I am into additional months I've discovered an issue.  I know for a fact a customer paid this month for an invoice done last month...however that is not showing up!

We basically need this report to help figure out the "bonus" our salespeople are to receive each month.  Which is figured by what invoices those sales people had paid...  If we haven't been paid how can we give that bonus to the salesperson!?  So last month being our first run I used the Sales By Rep Detail paid status closed and it worked great.  I figured I would just check to see how things are going this month just to test the report.  I noticed that the only ones showing up are the ones that were invoiced this month and paid during this current month set.  It is not showing last months invoice that was paid this month and there is a few. 

HELP

Solved
Best answer 12-10-2018

Accepted Solutions
Established Community Backer ***

try changing the report basis to cash based that should s...

try changing the report basis to cash based

that should show only paid invoices

17 Comments
Established Community Backer ***

try changing the report basis to cash based that should s...

try changing the report basis to cash based

that should show only paid invoices

ar2
Not applicable

I actually had to reach out to the tech support line.  I...

I actually had to reach out to the tech support line.  I was in the cash based...I tried playing with that and no luck.  However took me and them a while to get it figured out but it seems the needs to be multiple filters added to make it happen.  Some of those I still don't understand why were needed but once combined it worked.
ar2
Not applicable

Thank you Rustler though for trying to help!  :)

Thank you Rustler though for trying to help!  :)
Not applicable

Would you be able to post the settings that you have? I h...

Would you be able to post the settings that you have? I have the exact same problem and have been trying for many hours to get it to work. Thanks in advance for your help!
Not applicable

Hi! I have the exact same thing happening and would like...

Hi! I have the exact same thing happening and would like to know the right combination of settings too, thanks!
Not applicable

I could sure use this info too.  It would be a lot of hel...

I could sure use this info too.  It would be a lot of help to know how to show a report for every invoice/sales payment received in a month no matter when the invoice was originally created.
Established Community Backer ***

Run your Sales Report on Cash Basis = the dates of the re...

Run your Sales Report on Cash Basis = the dates of the report will include only things Paid in that same date range, no matter what dates are on invoices. Top left of the reporting = Cash Basis is all you need.
Not applicable

I just realized this topic is for the desktop version - N...

I just realized this topic is for the desktop version - No wonder I can't make the report work. I'm using the online version. However, I can't find a topic on this same issue for the online version, and I don't have any option to change the report to cash basis.
Established Community Backer ***

"I want all pmts made in a given month, by rep, regardles...

"I want all pmts made in a given month, by rep, regardless of month of original invoice."

= Cash Basis, top left.

"  "sales by rep" doesn't seem to have a filter that allows previous months invoices."

But you just stated you didn't want "Previous Month"s invoices" because you want Paid in a given month = the date of the invoice is meaningless in this request.

"I have tried running that report on a cash basis and it neglects previous months invoices."

No, it doesn't. It is Payments; the date you set on that report is Payment Dates. If you want last month, set the date to Last Month. That = Payment Dates. That's what you just asked.


Established Community Backer ***

I have attached sample images that should be helpful for...

I have attached sample images that should be helpful for you to understand the difference between cash and accrual invoice payment reporting.

And read this article: Differentiate Cash and Accrual basis - QuickBooks Learn & Support


Not applicable

I am familiar with cash vs accrual basis accounting. The...

I am familiar with cash vs accrual basis accounting. The sales by rep report on a cash basis does NOT show what you describe. Case in point, I have multiple examples of invoices issued on the last day of the month (30th) and paid 5 days later. When I try to run a cash basis report of sales receipts by rep, it is run for the month the pmt was made, only.
Established Community Backer ***

"When I try to run a cash basis report of sales receipts...

"When I try to run a cash basis report of sales receipts by rep, it is run for the month the pmt was made, only."


Yes, you have to explain which perspective do you want?

If you want Sales last month, even thought they are paid this month, that is Accrual Basis = for the date On The Invoice.

But you also will filter on Paid Status = Closed.

I will copy what keeps getting Down Votes, because it is right here:

Accrual Basis setting = the dates of the invoices for the date you put on the report, even if Never paid.

Cash Basis = the dates of the Payments for the invoices, not for the date of the invoices, and only if paid.

Accrual Basis, filter on Paid Status = Closed. This gives you "Sales for this specific date/Date range (date Of Invoices) but only those Paid, no matter what is the payment date."

Established Community Backer ***

Accrual Basis setting = the dates of the invoices for the...

Accrual Basis setting = the dates of the invoices for the date you put on the report, even if Never paid.

Cash Basis = the dates of the Payments for the invoices, not for the date of the invoices, and only if paid.

Accrual Basis, filter on Paid Status = Closed. This gives you "Sales for this specific date/Date range (date Of Invoices) but only those Paid, no matter what is the payment date."

Not applicable

Thanks qbteachmt. I want all pmts made in a given month,...

Thanks qbteachmt. I want all pmts made in a given month, by rep, regardless of month of original invoice.  "sales by rep" doesn't seem to have a filter that allows previous months invoices.  I have tried running that report on a cash basis and it neglects previous months invoices.
Not applicable

Re: Thanks qbteachmt. I want all pmts made in a given month,...

 

#1

I create a November 15th invoice for 1000.00 and it is taxed. Tax is 80.00

The invoice is paid on December 10.

#2

I create a January 15th (of the next year) invoice ( a progress billing) for 2000.00 and it is taxed. Tax is 160.00

The invoice is paid on December 28th.

The only report that I can find that shows both of these payments and the net sale amount is

From financialtoolbox.com:

 

"From the menu bar, go to Reports > Banking > Check Detail
- Click on Modify Report button in upper left
- Click on the Filters tab
- Click down arrow next to Account box, choose All Accounts
- Click on Amount, change to All
- Click on Transaction Type, choose Payment
- Click on Detail Level, choose All except summary

This is not a perfect report. It will show the deposit that the payment is in (linked to). You can always export to excel and delete the deposit information. "

 

This report is a blessing! It shows every payment received and the details of the invoice it was applied to. Once exported to Excel, it is easily "cleaned up".  QuickBooks engineers really need to address this. This report is great for a small company, but for any company with a magnitude of small payments, this is still cumbersome.

 

Established Community Backer ***

Re: Thanks qbteachmt. I want all pmts made in a given month,...

This is an Error: "

#2

I create a January 15th (of the next year) invoice ( a progress billing) for 2000.00 and it is taxed. Tax is 160.00

The invoice is paid on December 28th."

 

You cannot Pay something in Dec that isn't there until Jan. You seem to be overlooking proper handling of a Prepayment. In Dec, you got a Prepayment. In Jan, you use your Prepayment Item, from the Dec Sales Receipt, on a Credit Memo dated on or after the date of the Jan Invoice, so that you can show the customer their prepayment from Dec is now applied to the Jan invoice.

 

If you only use Receive Payment in Dec, you created Negative AR. This is backwards accounting and obscures your total AR, as well.

 

An Accrual Basis entity treats Prepayments as Liability (not negative AR, which = backwards asset). A Cash Basis entity links their other charge type item for Prepayment to Income, because you are supposed to report that as Income; you received Funds and that is income. Later, when you use it on a credit memo to apply to the actual sale, that reverses the prepayment income by showing it now applies to an actual sale, so that is a wash for the date you put on the credit memo (the CM is dated the same or Later than the invoice you applied it to).

 

You need to work with your CPA to learn how prepayments must be handled to meet your specific accounting and sales tax requirements.

Not applicable

Re: Run your Sales Report on Cash Basis = the dates of the re...

not necessarily true.  it will only be accurate if you change the invoice date to match the payment date.  For example, say you have 100 april invoices which total $1000, say each invoice is for $10.

They are all dated April 1.  Let's say 20 customers pay in March 31 because they know what their April invoice amount will be.  If you leave the date of the invoice set to April 1, you will NEVER see the $200 received in March on your March p and l, even on a cash basis.  If you want a true cash basis p and l, one of the things you'll need to do is to change the invoice date to the paid date when the customer pays earlier than the invoice date.  As mentioned, there are filters in customized reports that will get you to where you want to be, but not via the standard p and l.  QB is limited in its capabilities of producing a cash basis p and l. For example, you use a credit card for an expense, it shows up on your cash basis p and l. But you won't pay the credit card until the following month. Bottom line, don't rely on the p and l to tell you what you think it is telling you.

Need to get in touch?

Contact us