Sales order reporting

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:
  1. Item sold
  2. Deposit collected/paid at time of sale
  3. 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;