Sales order reporting

Here is what I want to do: a commissioned salesperson sells our product for $500.00 and collects a $250.00 deposit with the order with the balance due n/30. I need the salesperson to be able to enter the deposit and have the sales order show:

Item sold
Deposit collected/paid at time of sale
Balance due w/due date

I attempted to do this in ZohoInvoice but cannot create the report showing the sale amount, amount collected and balance outstanding.
At the end of each week I need to create a report sorted by sales rep so I can pay their commission which is paid on the portion collected, not the total invoiced amount. I would also like a reminder to trigger when the balance is due.
Thanks;