End of Month

Commission transfer

Consultant Conv. rate TTV Gross sales margin Positive CT Negative CT Total CT Ledgers GST payable GST receivable
Tim Brown 0.00 100,000.00 30.00% 35,000.00 -5,000.00 30,000.00 90
Booking Customer Travel date Turnover Pos. CT Neg. CT Total CT Margin Transfer date T3
123456 James Hicks 22/07/2013 $5,000,567 $1,000,023 -$100.00 $1,345,665 15% 22/07/2013 107799
123456 Sue Robertson 22/07/2013 $4,067,877 $1,001,345 -$100.00 $1,003,115 10% 22/07/2013 107799
123456 Lisa Jones 22/07/2013 $6,000,054 $1,045,655 -$100.00 $1,001,345 12% 22/07/2013 107799
Jane Doe 0.00 0.00 0.00% 0.00 0.00 0.00 0
Booking Customer Travel date Turnover Pos. CT Neg. CT Total CT Margin Transfer date T3
123456 James Hicks 22/07/2013 $5,000,567 $1,000,023 -$100.00 $1,345,665 15% 22/07/2013 107799
123456 Lisa Jones 22/07/2013 $4,067,877 $1,001,345 -$100.00 $1,003,115 10% 22/07/2013 107799
Ewan Lamond 0.00 100,000.00 30.00% 35,000.00 -5,000.00 30,000.00 90
Henry James 0.00 450,000.00 0.99% 800,000.00 0.00 80,000.00 70
Grand total 900,000.00 845,000.00 -5,000.00 833,000.00 240

Commission listing

Trans Id Consultant Booking Id Commission amount Consultant Status Date paid Change alloc. Request alloc. change
  Request

Change allocation

Customer Booking # Travel date Turnover + Comm Tsfr - Comm Tsfr Total Comm Tsfr Gross sales Transfer T3 T4 Consultant
Customer A 1233454 22/07/2013 10000.00 500,00 -20.00 480.00 5% 22/07/2013 Jane Doe
-480.00 Jane Doe
230.00 Jane Doe
250.00 Cheryl Talbot

Select

Cancel