Commission ? Can This Be done ? and How please ?

[Jackwalz]

Hi, I have a joint venture with a Company , They have to give me a commission from every sale that came thru my leads.
I only get paid after the sale is closed = paid in full

They set up quickbooks pro 2005 with my name as rep so they know how to make my customers seperate & print it out from Date to Date , the problem is every time they want to pay me. they print out all my sales and fax it to me, #1 they have to go thru it to see if there are any new unpaid commission names from those who paid in full , then they make me check all my invoices from before to see which ones I got paid on & which one are new, and then I enter it in my Quick books and send them a invoice for the new names. It takes alot of time and it only delay's me from getting paid.

I'm think of ways to work this out the question is how?


Is there a way for them to set it up that every time they do a sale under my rep/name they ad the commission right away and save it in a way that it crates a bill or invoice for me? basicly to create somthing to keep the ones that are paid from before not to come out and the ones that are not paid in full ONLY THE ONES THAT THE commission AREN'T PAID YET?

Any advice or ideas with instruction will be greatly appriciated.

Jack

[Joe Williams]

If they use the Sales by REP and modify it to report in cash basis, the report will be the PAID sales amounts. They can then set the date range to "last Month" and memorize it and every time they run it, it will give your sales that were paid last month.

[Jackwalz]

How can they set it to make a report , of how much they owe me for each sale they close.

[lisa_mn]

It can't calculate what they owe you, but the report, as Joe described it, will show the total of sales paid last month and they can do whatever calculation is needed based on that amount.

[LauraD]

If they aren't sending the invoices to their customers, here is a thought. . .

If they add two lines to their invoices for the commission. . .one being commission expense (a calculated item after a total item) and the other being a discount item set to commissions payable. . .this will minus the commissions payable amount from the invoice to their customer.

I am thinking that reports can then be run to show the commission payable amount from those invoices? I haven't actually tried this, but it might work. . .

Thoughts??

Laura