Get transaction report — Pier

Get the transaction report for all facilities for a Pier partner for a specific day. The report contains all transactions for the day that make up the ledger of the facility as well as payments and disbursements.

Path parameters

datestringRequired

An ISO 8601 date string in the format YYYY-MM-DD

Response

This endpoint returns an object.

facility_transactionslist of lists of objects

A list of transactions for the day that make up the ledger of the facility

paymentslist of objects

A list of payments for the day

disbursementslist of objects

A list of disbursements for the day

cadence"daily"

Allowed values: daily

The cadence that the report is generated in. For now, “daily” cadence is the only one that exists.

type"transaction" or "balance"

Allowed values: transactionbalance

The type of report that is being generated. For now, “balance” is the only type that exists.

report_datestring

The date of the report - this is the same as the date in the path parameter.

last_updateddatetime

The timestamp when the report was last updated.

Errors

1 curl https://production.pier-finance.com/api/reconciliation/transaction-report/2024-10-01 \ 2 -H "Authorization: Bearer <token>"

1 { 2 "facility_transactions": [ 3 [ 4 { 5 "amount": 100000, 6 "borrower_id": "bor_a1d0c30d77104f35b4c842b99132624e", 7 "description": "Disbursement", 8 "effective_date": "2023-05-12", 9 "facility_id": "fac_18e5a3726b3943cda2635f40e1041ba4", 10 "net_amount": 100000, 11 "transaction_date": "2023-05-12", 12 "transaction_iso_timestamp": "2023-05-12T00:00:00.000Z", 13 "transaction_type": "DEBIT" 14 }, 15 { 16 "amount": 500000, 17 "borrower_id": "bor_a1d0c30d77104f35b4c842b99132624e", 18 "description": "Principal Reduction", 19 "effective_date": "2024-06-02", 20 "facility_id": "fac_18e5a3726b3943cda2635f40e1041ba4", 21 "net_amount": -500000, 22 "transaction_date": "2024-06-02", 23 "transaction_iso_timestamp": "2023-05-12T00:00:00.000Z", 24 "transaction_type": "CREDIT" 25 } 26 ] 27 ], 28 "payments": [ 29 { 30 "id": "pmt_18e5a3726b3943cda2635f40e1041ba4", 31 "amount": 100000, 32 "facility_id": "fac_18e5a3726b3943cda2635f40e1041ba4", 33 "status": "pending", 34 "transfer_type": "standard", 35 "created_on": "2023-02-27T00:00:00Z", 36 "is_autopay": false 37 } 38 ], 39 "disbursements": [ 40 { 41 "id": "dsb_18e5a3726b3943cda2635f40e1041ba4", 42 "facility_id": "fac_18e5a3726b3943cda2635f40e1041ba4", 43 "amount": 100000, 44 "status": "pending", 45 "created_on": "2023-02-27T00:00:00Z", 46 "transfer_type": "standard", 47 "failure_reason": null, 48 "date": "2023-02-27" 49 } 50 ], 51 "cadence": "daily", 52 "type": "transaction", 53 "report_date": "2024-10-01", 54 "last_updated": "2024-10-02T00:00:00Z" 55 }

1	curl https://production.pier-finance.com/api/reconciliation/transaction-report/2024-10-01 \
2	-H "Authorization: Bearer <token>"

1	{
2	"facility_transactions": [
3	[
4	{
5	"amount": 100000,
6	"borrower_id": "bor_a1d0c30d77104f35b4c842b99132624e",
7	"description": "Disbursement",
8	"effective_date": "2023-05-12",
9	"facility_id": "fac_18e5a3726b3943cda2635f40e1041ba4",
10	"net_amount": 100000,
11	"transaction_date": "2023-05-12",
12	"transaction_iso_timestamp": "2023-05-12T00:00:00.000Z",
13	"transaction_type": "DEBIT"
14	},
15	{
16	"amount": 500000,
17	"borrower_id": "bor_a1d0c30d77104f35b4c842b99132624e",
18	"description": "Principal Reduction",
19	"effective_date": "2024-06-02",
20	"facility_id": "fac_18e5a3726b3943cda2635f40e1041ba4",
21	"net_amount": -500000,
22	"transaction_date": "2024-06-02",
23	"transaction_iso_timestamp": "2023-05-12T00:00:00.000Z",
24	"transaction_type": "CREDIT"
25	}
26	]
27	],
28	"payments": [
29	{
30	"id": "pmt_18e5a3726b3943cda2635f40e1041ba4",
31	"amount": 100000,
32	"facility_id": "fac_18e5a3726b3943cda2635f40e1041ba4",
33	"status": "pending",
34	"transfer_type": "standard",
35	"created_on": "2023-02-27T00:00:00Z",
36	"is_autopay": false
37	}
38	],
39	"disbursements": [
40	{
41	"id": "dsb_18e5a3726b3943cda2635f40e1041ba4",
42	"facility_id": "fac_18e5a3726b3943cda2635f40e1041ba4",
43	"amount": 100000,
44	"status": "pending",
45	"created_on": "2023-02-27T00:00:00Z",
46	"transfer_type": "standard",
47	"failure_reason": null,
48	"date": "2023-02-27"
49	}
50	],
51	"cadence": "daily",
52	"type": "transaction",
53	"report_date": "2024-10-01",
54	"last_updated": "2024-10-02T00:00:00Z"
55	}