All the payments collected from customers are recorded under Collections. You can filter the data based on the company, received from (credit card, net banking, Xpress Account), settlement status and date range etc. 



This report gives a detailed description on the customer /company /transaction status etc. for all the payments collected. 

The Export file contains the following details:- 

 

Company Name

Name of the company from whom the amount is received.

Reference Code

Reference Code shared by the business against each contact for their internal reference or identification.

Transaction ID

Unique Transaction ID generated against each transaction.

Transaction Date

Date of payment transferred from customer to business.

Invoice Number

Invoice generated by the Business against which business receives the payment.

Request Sent Date

The date on which payment request is sent by the business

Request Amount

The amount for which the payment is requested

Discount

Discount given, if any

TDS

Tax deducted at source, if any.

GST Type

Applicable CGST or SGST.

GST Rate

Rate of GST applied.

GST

GST

Received Amount

Amount Received from the contact.

Currency

Currency of the transaction.

Client Charges

Charges borne by the customer, if any.

Client Charges GST

GST borne by the customer.

Business Charges

Charges borne by the business, if any.

Business Charges GST

GST borne by the business.

Settlement Amount

Amount settled to Business after deducting Charges and Taxes (if applicable).

Exchange Rate

Exchange rate of a foreign currency to INR.

Settlement Currency

The currency in which the transaction is settled.

Bank Ref Number

Unique reference number generated by the bank for each transaction. 

Status

Current status of the transaction.

Settlement Date

Date on which settlement is done to business's settlement account.

Settled To Account No

Account number in which payment is settled.

Payment Mode

Payment received from contact via Credit Card / Net Banking / NEFT, RTGS.

Payment Through

Payment received through which Card / Bank