Reports for the United States

These regulatory scheduled reports are for Pismo customers that operate in the United States. For more information, refer to Scheduled reports.

Notes:

  • Product: On the Pismo platform, there are various products, such as checking accounts, cards, and investments. A report can relate to one or more products.
  • Granularity of information: The granularity of a report is its level of detail. For example, there are reports that provide information per account or per document or per transaction. If the granularity of a report is at the document level, this means it can encompass data from multiple accounts.
Report  Frequency  Description  Notes
1099-INT  Annual  The Form 1099-INT (Interest Income) report is a tax reporting document required by the Internal Revenue Service (IRS), the United States tax authority. Financial institutions must issue this report to any customers that earned $10 or more in interest during the year. The taxpayer uses this report to complete Form 1040 for their U.S individual income tax return.

The report gets data from the 1099-Withholding Threshold Tracking report.

For more information, refer to About Form 1099-INT, Interest Income from the U.S. Internal Revenue Service.
Applies to:
Deposit accounts

Delivery format options:
Parquet (Analytical report that can be used to validate the data included in the official report)

Granularity of information:
Account
Document number
1099-Withholding Threshold Tracking  Daily  The Withholding Threshold Tracking report tracks the amount of interest earned on a customer's account. It also identifies when the interest on an account goes over a specified threshold, such as $10. which determines when the interest must be reported. This report is the source of the data used in the Form 1099-INT report.

For more information, refer to About Form 1099-INT, Interest Income from the U.S. Internal Revenue Service.
Applies to:
Deposit accounts

Delivery format options:
Parquet (Analytical report that can be used to validate the data included in the official report)

Granularity of information:
Account
Document number
Call Report  Quarterly  Call Reports is responsible for reporting information on the financial condition and operating results of U.S. depository institutions. It exists to provide U.S. banking regulators with standardized, periodic data used for prudential supervision, regulatory oversight, and public disclosure.

The report is required by the Federal Financial Institutions Examination Council (FFIEC) and is submitted to its member agencies, including the Federal Reserve, Federal Deposit Insurance Corporation (FDIC), and the Office of the Comptroller of the Currency (OCC). The information reported supports supervisory monitoring of institutional safety and soundness, compliance with regulatory and accounting requirements, and broader policy analysis.
Applies to:
Corporate (Transaction accounts), Banking (Other deposits), Interest engine (Other deposits)

Delivery format options:
XML (FED - USA)
Parquet (Analytical report that can be used to validate the data included in the official report)

Granularity of information:
Organization
Deposit type
FDIC Part 370  Annual  FDIC Part 370 (12 CFR Part 370) is a regulation requiring covered institutions (banks with 2 million or more deposit accounts) to maintain complete and accurate records so the FDIC can promptly determine deposit insurance coverage in the event of a bank failure. The rule ensures depositors receive insured funds quickly and minimizes costs to the Deposit Insurance Fund. Applies to:
Deposit Accounts (Savings, Time Deposits / CD), Investment

Delivery format options:
CSV

Granularity of information:
Organization
Account
Customer (one row per customer per account)
Form 1042-S  Annual  The Form 1042-S is responsible for tracking U.S. source income paid to foreign persons (nonresident aliens, foreign entities) from time deposits and CD accounts, along with any tax withholding applied under Chapter 3 (Nonresident Aliens) or Chapter 4 (FATCA). We can deliver 2 files for this report, Analytic layer for validation and Final Layout. Applies to:
Time Deposits / CD Account

Delivery format options:
Parquet file

Granularity of information:
Account
Beneficiary (Foreign Person)
Document Number (Foreign TIN)
FR2900  Weekly or Quarterly  The FR 2900 report contains information about transaction accounts (accounts that allow the account holder to easily withdraw their money), other deposits, and vault cash (the physical money held by financial institutions in their vaults and teller drawers to cover daily customer withdrawals).

For more information, refer to FR 2900 (Savings and Loans) from the U.S. Federal Reserve.
Applies to:
Transaction accounts, bank accounts, deposit accounts

Delivery format options:
XML (FED - USA)
Parquet (Analytical report that can be used to validate the data included in the official report)

Granularity of information:
Organization
Deposit type
Single Account Statement  Monthly  The Single Account Statement report lists a customer's account statements for the month. It supports only individual statements on a savings account. It does not support consolidated statements (statements that combine multiple accounts).

A regulator does not require this as a report. It's used by the consumer or financial institution."
Applies to:
Deposit accounts

Delivery format options:
Parquet (Analytical report)

Granularity of information:
Account
Summary Of Deposit (SOD)  Annual (as of June 30 each year)  The Summary of Deposits (SOD) is an annual survey of branch office deposits as of June 30 for all FDIC-insured institutions, including insured U.S. branches of foreign banks. It is submitted to the Federal Deposit Insurance Corporation (FDIC) and has been conducted since 1934.

The SOD provides branch-level deposit data used for banking market analysis, regulatory supervision, and monitoring regional banking concentration. Total deposits reported must reconcile with the Call Report (Schedule RC, item 13.a for domestic-only banks, or Schedule RC-E for foreign branch banks).
Applies to:
Corporate (Transaction accounts), Banking (Other deposits), Interest engine (Other deposits)

Delivery format options:
Parquet file

Granularity of information:
Organization