Creating Wealth. Transforming Lives LEDGER REPORTS

(1)

LEDGER REPORTS

(2)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): REPORT TYPES

The newly deployed ledger reports are aimed at providing various types of reports from a single selection screen across all the brokerage payment types for all the products that a partner is enrolled with.

You can access the reports at the location mentioned below: Partner Desk >> Admin >> Payment >> Ledger Report

The following are the various report types that are available:

1. Ledger Report 2. Bill Report

3. Payment Advice

(3)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): REPORT TYPES

REPORT TYPES:

>> LEDGER REPORT:

The ledger Report displays details relating to all brokerages processed and/or paid during the selected period for all the products.

>> BILLS:

The bill wise report displays brokerage bills generated for the selected period for all the products.

>> PAYMENT ADVICE:

Payment Advice Reports provide you with a summary of all the payments / recoveries processed for all the products.

(4)

LEDGER REPORTS

(5)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): LEDGER REPORT

LEDGER REPORT (1)

To view ledger report kindly make the desired selections from the filter screen for Date, Product and Payment Type.

Please note that selecting “Display payment entries Only” will load only such entries for which payouts have been processed

Select Product

Select Brokerage Type

Select Ledger Report

Select Report Period

(6)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): LEDGER REPORT

In order to get the report in Excel / PDF format, kindly select Export Tab from the top and make the desired selections.

(7)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): LEDGER REPORT

The ledger report provides entry wise details of brokerages and payouts processed.

1

2

3

4

5

6 ₇

₈

₉

₁₀

₁₁

₁₂

₁₃

₁₄

(8)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): PAYMENT ADVICE

The various fields of the ledger report are read as follows:

1. Partner: Displays the partner code and name to which payment has been made. In case where there

are different persons (payees) for different products, the report will be displayed at person level.

2. PAN: Displays the PAN of the Partner Code

3. Period: Displays the period for which the report has been generated 4. Generated On: Displays the report generation date

5. Date: Displays the bill date

6. Product: Displays the product to which the entry relates i.e. In case of brokerage payout for FD, MF

or realty products the field will display the product name accordingly.

7. Payment Type: Displays the nature of brokerage payout i.e. Upfront, Addl Upfront, Trail, etc. 8. Description: Displays whether it is a bill or a payment

9. Bill/Payment Advice No.: Displays the Bill No or Payment Advice no of the entry 10. Bill Amount: Displays the Bill Amount of the transaction

11. TDS: Displays the amount of TDS deducted

12. Payment (Rs): Displays the amount of payment processed 13. Balance: Displays the outstanding ledger balance

14. Chq No.: In case of payment by cheque, the same will display cheque no. 15. Total: Displays column wise totals of respective fields

(9)

BILL REPORTS

(10)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): BILL REPORT

BILL REPORT (1)

Select Report Type as Bills and make the desired selections from the filter screen for Date, Product and Payment Type.

You can provide a bill no to view report of a particular bill. You can also provide more than one bill no by separating the same with commas (,).

Select Product

Select Brokerage Type

Select Bills

Select Report Period

Provide Bill No

(11)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): BILL REPORT

BILL REPORT (2)

(12)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): BILL REPORT

BILL REPORT (3)

The Bill report provides details of bills processed.

1

2

3

4

5

6

7

8

9

(13)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): BILL REPORT

BILL REPORT (4)

1. Partner: Displays the partner code and name to which payment has been made. In case where there

2. Product: Displays the product to which the entry relates i.e. In case of brokerage payout for FD, MF

or realty products the field will display the product name accordingly

3. Sub Type: Displays the nature of brokerage payout i.e. Upfront, Addl Upfront, Trail, etc 4. Bill No: Displays the Bill No of the relevant transaction

5. Bill Date/ Transaction Date: Displays the bill date or transaction date of the transaction 6. Gross Amount: Displays the Bill Amount of the transaction

7. TDS: Displays the amount of TDS deducted

8. Net Amount: Displays the Net amount i.e. Gross Amount – TDS

9. Related Payment Advice No.: Displays the Payment Advice nos through which payments have been

made for the corresponding bill nos

(14)

PAYMENT ADVICE REPORT

(15)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): PAYMENT ADVICE REPORT

PAYMENT ADVICE REPORT (1)

Select Report Type as Payment Advice and make the desired selections from the filter screen for Date, Product and Payment Type.

You can provide a Payment Advice no to view report of a particular Payment Advice. You can also provide more than one payment advice no by separating the same with commas (,).

Select Product

Select Brokerage Type

Select Bills

Select Report Period

Provide Advice No

(16)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): PAYMENT ADVICE REPORT

(17)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): PAYMENT ADVICE REPORT

The Payment Advice provides details of Payments processed.

1

2

3

(18)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): PAYMENT ADVICE REPORT

1. Paid To: Displays the partner code and name to which payment has been made. In case where there

2. Payment Advice No.: Displays the Payment Advice nos through which payments have been

made for the corresponding Amounts

3. Amount: Displays the Amount processed through the payment advice 4. Total: Displays column Sub Total / Total of Amount field

(19)

PAYMENT ADVICE

(20)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): PAYMENT ADVICE

PAYMENT ADVICE (1)

The Payment Advice Statement provides details of brokerages payouts processed.

1

2

4

15

11 3

16

17

6 7 8 9 10 12 14 5 ₁₃

(21)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): PAYMENT ADVICE

The Payment advice is divided in 5 major blocks viz: Partner (Payee) Information, Payable Amount Block, Recoverable Amount Block, Deduction Block and Net Payment Block.

The various fields of the Payment Advice are read as follows:

1. Payment Ref No: Every payment advice bears a unique ref no. known as payment ref no.

2. Partner Details block: Displays various details relating to the partner such as the partner code

and name of the partner to whom payment has been made, the address of the partner.

3. Generated On: Displays the payment advice generation date

4. Payable Amount Block: Displays the details relating to amounts payable to the partner code 5. Opening Balance: Displays total outstanding amount pending to be paid to the partner code

against any of the previously generated bills.

6. Product Sub Type: Displays the nature of brokerage payout i.e. Upfront, Addl Upfront, Trail, etc. 7. Bill No.: Displays the Bill No of the transaction

8. JV Date: Displays the bill date or transaction date as applicable

9. Brokerage Period: Displays the brokerage period of the transaction processed for payment. 10. Net Amount After TDS: This is the net payable amount of the transaction remaining after TDS

deduction i.e. If the Real Estate Brokerage Bill amount is 1000 and TDS rate is 10%, the net amount after TDS = 900

(22)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): PAYMENT ADVICE

11. Processed Amount : Displays the total amount which has been processed for payment till date.

e.g.

The partner earned 5000 RAP points in the month of April 15

And he/she redeemed 2000 RAP Points out of the above amount in the month of May 15. In this case the processed amount will be 2000.

12. Previously Adjusted or Paid Amount: Displays the amount which has already been adjusted /

paid through a previous payment advice. e.g.

The partner earned 5000 RAP points in the month of April 15

And he/she redeemed 2000 out of the above amount in the month of May 15.

In June 15, the partner again redeems the remaining 3000 from the balance RAP (5000-2000) In this case, the previously Adjusted or Paid Amount for the June 15 Payment Advice will show Rs. 2000. Also note that the processed Amount Column will show Rs. 5000 in this case

(23)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): PAYMENT ADVICE

13. Current Adjusted: Displays the amount which has been adjusted towards outstanding recoveries in

the current payment cycle.

e.g. Continuing from the above example of RAP redemption request for 3000,

say there is a recovery of 500 for B15 clawback outstanding against the partner code for the

current payment cycle,in that case, the amount of 500 will be recovered from the RAP redemption request for 3000 and the same will be displayed as current Adjusted amount.

14. Payable Amount: Payable amount is the net payable amount against the bill after

deducting the Previously Adjusted/Paid Amount and Current Adjusted amount from the Processed Amount

e.g. Continuing from the above example of RAP accruals of 5000 for April 15

Net Amount After TDS = 5000 Processed Amount = 5000

Previously Adjusted/Paid Amount = 2000 Current Adjusted = 500

(24)

Agenda – Brokerage Rate Processing

LEDGER REPORTS (PDESK): PAYMENT ADVICE

15. Recovered Amount Block: The recovered amount block, as the name describes, shows the

negative payables (i.e. Recovery) processed in the current payment cycle.

16. Deduction: The deduction block displays any other deduction made from brokerage payouts

e.g. Courier Charges, Cheque processing charges, etc.

(25)