# Reports

PaySG provides our users with payment reports, generated on demand, and payout reports, generated for each payout deposited into your receiving bank account. **The report is not customisable.**

## On-demand payment reports

You can download a csv file of all payment links in a payment service. Select your payment service of choice and download the payments under "Actions". 

Try out our interactive demo below:

{% embed url="<https://app.arcade.software/share/qqQ8PVPMGDg5w4QEPaaM>" %}

<figure><img src="https://3185298559-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuqMHPbRxvRp3K0CMQMjE%2Fuploads%2FrB7B86YtzIUwBid11D8C%2Fdownload%20report.png?alt=media&#x26;token=a3d5c44d-ef61-4b4d-b8dc-05aff718b610" alt=""><figcaption></figcaption></figure>

### Payment report fields

The following fields would have been **input during payment link creation.**

* Payment Reference: Reference ID of your choice that is input during the creation of payment links.&#x20;
* Name: Payer’s name.
* Address: Payer’s address.
* Identifier: Payer’s identifier of your agency’s choice (e.g. NRIC, passport number).
* Email: Payer’s email.
* Amount (SGD): Payment amount inclusive of GST.
* Due Date: Optional due date for display purposes only.
* About Payment: Payment description.
* (if applicable) Line items: Available via API only.
* (if applicable) Metadata: Each added metadata will be displayed in its own column.

The following fields are **based off of actions performed on the payment or payment link and are tracked by PaySG.**

* PaySG ID: Unique ID set by PaySG.
* Created by: Email of the individual who created the payment link.
* Payment Link URL: Link to the PaySG payment page.
* Payment Status: Payment status (Paid, Unpaid, Cancelled, Fully refunded, Partial refunded)
* Payout ID: Stripe payout ID. Also found in payout report.
* Email Status: Reflects status of payment email.
* Link sent on: Date when payment link was sent via email on PaySG dashboard.
* Created on: Date of payment link creation.
* Paid on: Date that payer successfully made payment.
* Paid Out on: Date of payout to your agency’s bank account.
* Refunded on: Date of refund(s) and refunded amount(s).

## Payout reports

PaySG generates a report for each payout received in your bank account. Select your payment service of choice and download the report under the "Reports" tab.&#x20;

Try out our interactive demo below:

{% embed url="<https://app.arcade.software/share/1fAwLRTDKJa8882FhR2R>" %}

<figure><img src="https://3185298559-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuqMHPbRxvRp3K0CMQMjE%2Fuploads%2Ftn1Cvfxp0ZCeCReIoWBp%2Fdownload%20payout%20report.png?alt=media&#x26;token=9c5ae760-aca1-46c1-a4b4-4f713772d58b" alt=""><figcaption></figcaption></figure>

### Payout report fields

* payout\_id: ID of the payout credited to your agency's bank account
* payout\_date: Date that payout is credited to your agency’s bank account
* paysg\_id: Unique ID set by PaySG
* paysg\_payment\_service\_id: Payment service ID
* transaction\_ID: Transaction ID generated by Stripe or bank
* transaction\_type: Transaction type (Charge)
* transaction\_timestamp: Timestamp of when payment is made
* transaction\_amt\_in\_dollars: Amount before deduction of transaction fee
* transfer\_amt\_in\_dollars: Amount credited to your bank account after transaction fee deduction
* stripe\_fee\_in\_dollars: Transaction fee charged by Stripe
* bank\_fee\_in\_dollars: Transaction fee charged by the bank
* transaction\_id: Stripe's transaction ID
* currency: SGD only
* payment\_method: Indicates payment method (card for Stripe payments, paynow for bank PayNow)
* payment\_reference: Reference ID of the payment, input during creation of payment link

For Stripe's payout reports:

* card\_funding: Debit or credit
* card\_country: Issuing country for credit card
* card\_brand: Brand of card

For banks' payout reports:

* qr\_reference: Bank PaySG ID, displayed on payers' and agency's bank statement and on the payment page