---
title: "Get transaction report"
method: GET
path: "/reconciliation/transaction-report/{date}"
tags: ["ReconciliationReports"]
---

# Get transaction report

`GET /reconciliation/transaction-report/{date}`

## Request

- Base URL: `https://production.pier-finance.com/api`
- URL: `https://production.pier-finance.com/api/reconciliation/transaction-report/{date}`
- Auth: HTTP bearer

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

- `date` string, required: An ISO 8601 date string in the format YYYY-MM-DD

## Response `200`

- TransactionReportResponse
  - `facility_transactions` ReconciliationReportTransactions[], required: A list of transactions for the day that make up the ledger of the facility
    - ReconciliationReportTransaction[]: A list of transactions for the day that make up the ledger of the facility
      - `amount` integer, required: The amount of the transaction, in cents (e.g. 1000 = $10.00)
      - `net_amount` integer, required: The net amount of the transaction, meaning positive or negative depending on the effect on the ledger, in cents (e.g. 1000 = $10.00)
      - `transaction_date` string, required: The date of the transaction (YYYY-MM-DD)
      - `effective_date` string, required: The effective date of the transaction (YYYY-MM-DD)
      - `description` string, required: A description of the transaction
      - `category` 'DRAWER_RESERVE_PURCHASE_IN_FROM_RESERVE_BANK' | 'REVERSE_PURCHASE_IN_FROM_RESERVE_BANK' | 'CASH_DRAWER_SELL_OFF_FUNDS_OUT_TO_RESERVE' | 'REVERSE_SELL_OFF_FUNDS_OUT_TO_RESERVE' | 'CASH_DRAWER_RESERVE_BANK_DEPOSIT_OUT' | 'REVERSE_BANK_DEPOSIT_OUT' | 'CASH_DRAWER_RESERVE_RECONCILING_ERROR_CORRECTION' | 'REVERSE_RECONCILING_ERROR_CORRECTION' | 'TRUST_DEPOSIT' | 'REVERSE_TRUST_DEPOSIT' | 'TRUST_DISBURSEMENT' | 'REVERSE_TRUST_DISBURSEMENT' | 'TRUST_DISBURSEMENT_SERVICING_FEE' | 'REVERSE_TRUST_DISBURSEMENT_SERVICING_FEE' | 'TRUST_RECEIVABLE_SERVICING_FEE' | 'REVERSE_TRUST_RECEIVABLE_SERVICING_FEE' | 'SUBSIDIZED_INTEREST_RECEIVABLE' | 'REVERSE_SUBSIDIZED_INTEREST_RECEIVABLE' | 'SUBSIDIZED_INTEREST_PAYABLE' | 'REVERSE_SUBSIDIZED_INTEREST_PAYABLE' | 'REVERSE_DEALER_RESERVE_RECEIVABLE' | 'DISBURSEMENT' | 'REVERSE_DISBURSEMENT' | 'CRED_LINE_LIMIT' | 'REVERSE_CRED_LINE_LIMIT' | 'PRECOMPUTED_INTEREST' | 'REVERSE_PRECOMPUTED_INTEREST' | 'FA_PRECOMPUTED_INTEREST' | 'REVERSE_FA_PRECOMPUTED_INTEREST' | 'PRINCIPAL_BILLING' | 'REVERSE_PRINCIPAL_BILLING' | 'INTEREST_BILLING' | 'REVERSE_INTEREST_BILLING' | 'PRINCIPAL_AND_INTEREST_BILLING' | 'REVERSE_PRINCIPAL_AND_INTEREST_BILLING' | 'PRINCIPAL_BALLOON_BILLING' | 'REVERSE_PRINCIPAL_BALLOON_BILLING' | 'INTEREST_BALLOON_BILLING' | 'REVERSE_INTEREST_BALLOON_BILLING' | 'DEFERRED_INTEREST_BILLING' | 'REVERSE_DEFERRED_INTEREST_BILLING' | 'ADB_INTEREST_BILLING' | 'REVERSE_ADB_INTEREST_BILLING' | 'ADB_INTEREST_BILLING_ADJUSTMENT' | 'REVERSE_ADB_INTEREST_BILLING_ADJUSTMENT' | 'LATE_FEE' | 'REVERSE_LATE_FEE' | 'CREDIT_LINE_ADVANCE_FEE' | 'REVERSE_CREDIT_LINE_ADVANCE_FEE' | 'CREDIT_LINE_OVERDRAFT_FEE' | 'REVERSE_CREDIT_LINE_OVERDRAFT_FEE' | 'IMPOUND_ASSESSMENT' | 'REVERSE_IMPOUND_ASSESSMENT' | 'NSF_FEE' | 'REVERSE_NSF_FEE' | 'AMORTIZED_INCOME_FEE' | 'REVERSE_AMORTIZED_INCOME_FEE' | 'AMORTIZATION_OF_INCOME_FEE' | 'REVERSE_AMORTIZATION_OF_INCOME_FEE' | 'AMORTIZED_EXPENSE_FEE' | 'REVERSE_AMORTIZED_EXPENSE_FEE' | 'AMORTIZATION_OF_EXPENSE_FEE' | 'REVERSE_AMORTIZATION_OF_EXPENSE_FEE' | 'PRINCIPAL_PAYMENT' | 'REVERSE_PRINCIPAL_PAYMENT' | 'INTEREST_PAYMENT' | 'REVERSE_INTEREST_PAYMENT' | 'P_PLUS_I_PRINCIPAL_PAYMENT' | 'REVERSE_P_PLUS_I_PRINCIPAL_PAYMENT' | 'P_PLUS_I_INTEREST_PAYMENT' | 'REVERSE_P_PLUS_I_INTEREST_PAYMENT' | 'PRINCIPAL_BALLOON_PAYMENT' | 'REVERSE_PRINCIPAL_BALLOON_PAYMENT' | 'INTEREST_BALLOON_PAYMENT' | 'REVERSE_INTEREST_BALLOON_PAYMENT' | 'DEFERRED_INTEREST_PAYMENT' | 'REVERSE_DEFERRED_INTEREST_PAYMENT' | 'RULE_OF_78S_ACTUARIAL_PAYMENT' | 'REVERSE_RULE_OF_78S_ACTUARIAL_PAYMENT' | 'PRINCIPAL_REDUCTION' | 'REVERSE_PRINCIPAL_REDUCTION' | 'INTEREST_REDUCTION' | 'REVERSE_INTEREST_REDUCTION' | 'FEE_REDUCTION' | 'REVERSE_FEE_REDUCTION' | 'LATE_FEE_REDUCTION' | 'DEFERRED_INTEREST_REDUCTION' | 'REVERSE_DEFERRED_INTEREST_REDUCTION' | 'LATE_FEE_PAYMENT' | 'REVERSE_LATE_FEE_PAYMENT' | 'CREDIT_LINE_ADVANCE_FEE_PAYMENT' | 'REVERSE_CREDIT_LINE_ADVANCE_FEE_PAYMENT' | 'CREDIT_LINE_OVERDRAFT_FEE_PAYMENT' | 'REVERSE_CREDIT_LINE_OVERDRAFT_FEE_PAYMENT' | 'DOWN_PAYMENT' | 'REVERSE_DOWN_PAYMENT' | 'IMPOUND_PAYMENT' | 'REVERSE_IMPOUND_PAYMENT' | 'NSF_FEE_PAYMENT' | 'REVERSE_NSF_FEE_PAYMENT' | 'INTEREST_INCOME' | 'REVERSE_INTEREST_INCOME' | 'DISCOUNT_INCOME' | 'REVERSE_DISCOUNT_INCOME' | 'SHORT_TERM_CAPITAL_GAIN' | 'REVERSE_SHORT_TERM_CAPITAL_GAIN' | 'LONG_TERM_CAPITAL_GAIN' | 'REVERSE_LONG_TERM_CAPITAL_GAIN' | 'INTEREST_FREE_PRINCIPAL_ADJ' | 'REVERSE_INTEREST_FREE_PRINCIPAL_ADJ' | 'INTEREST_FREE_INTEREST_ADJ' | 'REVERSE_INTEREST_FREE_INTEREST_ADJ' | 'CAPITALIZE_OVERPAID_INTEREST' | 'REVERSE_CAPITALIZE_OVERPAID_INTEREST' | 'UNEARNED_ADDON_INTEREST_REDUCTION' | 'REVERSE_UNEARNED_ADDON_INTEREST_REDUCTION' | 'UNEARNED_ADDON_INTEREST_ADDITION' | 'REVERSE_UNEARNED_ADDON_INTEREST_ADDITION' | 'CAPITALIZE_INTEREST' | 'REVERSE_CAPITALIZE_INTEREST' | 'COMPOUND_INTEREST_BALANCE_ADJUSTMENT' | 'REVERSE_COMPOUND_INTEREST_BALANCE_ADJUSTMENT' | 'CAPITALIZE_DEFERRED_INTEREST' | 'REVERSE_CAPITALIZE_DEFERRED_INTEREST' | 'CAPITALIZE_OVERPAID_DEFERRED_INTEREST' | 'REVERSE_CAPITALIZE_OVERPAID_DEFERRED_INTEREST' | 'SERVICING_FEE' | 'REVERSE_SERVICING_FEE', required
      - `transaction_type` 'NONE' | 'CREDIT' | 'DEBIT', required
      - `transaction_iso_timestamp` string, date-time, required: The ISO timestamp of the transaction
  - `payments` Payment[], required: A list of payments for the day
    - `id` string, required
    - `amount` integer, required: The amount of the payment, in cents
    - `facility_id` string, required: The facility_id of the credit facility to make a payment for
    - `status` 'pending' | 'processing' | 'processed' | 'settled' | 'failed' | 'canceled' | 'cancellation_pending', required
    - `transfer_type` 'standard' | 'none' | 'refund' | 'credit' | 'cancellation' | 'suspense_credit', required: Transfer types that are not standard/none are set by special operations like the refund endpoint for example. Special types, like refund, will reference the original transaction transfer type of standard/none to determine if ACH was used if this knowledge is needed (e.g. does an ACH refund need to happen or was this ledgering only).
    - `created_on` string, date-time, required: Timestamp the payment is created on
    - `failure_reason` string, nullable: A reason for the failure if one exists
    - `is_autopay` boolean, nullable: If the payment was a result of an autopay
  - `disbursements` Disbursement[], required: A list of disbursements for the day
    - `id` string, required: The id of the disbursement
    - `facility_id` string, required
    - `amount` integer, required: The amount of the disbursement, in cents (e.g. 1000 = $10.00)
    - `status` 'pending' | 'processing' | 'processed' | 'settled' | 'failed' | 'canceled' | 'cancellation_pending', required
    - `failure_reason` string, nullable: A reason for the failure if any exists
    - `date` string, nullable: The date of the disbursement (YYYY-MM-DD)
    - `created_on` string, date-time, required: Timestamp the disbursement object is created on
    - `transfer_type` 'standard' | 'none' | 'refund' | 'cancellation' | 'suspense_refund', required: Transfer types that are not standard/none are set by special operations like the refund endpoint for example. Special types, like refund, will reference the original transaction transfer type of standard/none to determine if ACH was used if this knowledge is needed (e.g. does an ACH refund need to happen or was this ledgering only).
  - `cadence` 'daily', required
  - `type` 'transaction' | 'balance', required
  - `report_date` string, required: An ISO 8601 date string in the format YYYY-MM-DD
  - `last_updated` string, date-time, required: The timestamp when the report was last updated.

## Other responses

- `400`
- `401`
- `409`
- `412`
- `422`
- `429`
- `500`

---

[API](https://skmtc.dev/pier-finance/apis/pier-api.md) - [All operations](https://skmtc.dev/pier-finance/apis/pier-api/llms.txt) - [OpenAPI document](https://skmtc.dev/pier-finance/apis/pier-api/revisions/08a7c49252b9?raw)