USA Bank Statements
Description:
A bank statement is a list of all transactions for a bank account over a set period, usually monthly. The statement includes deposits, charges, withdrawals, as well as the beginning and ending balance for the period. This API only supports USA Banks
The type parameter is us_bank_statement for the Upload endpoint.
NOTE: Please be aware that, at this time, our API does not support Credit Cards and Credit Unions. Rest assured, our development team is actively working on extending our capabilities to include these financial documents. As we continue to enhance and expand our offerings, we will promptly notify our valued users once support for Credit Cards and Credit Unions is implemented.
Fields supported by Docsumo
Note:
To customise fields for extraction, please contact Customer Success Management (CSM) Team
Basic Information
| Field Name | Data Type | Field Description |
|---|---|---|
| Basic Information___Account Name | String | Account Name as shown on USA Bank Statements |
| Basic Information___Account Number | String | Account Number as mentioned in USA Bank Statements |
| Basic Information___Bank Name | String | Bank Name as mentioned in USA Bank Statements |
| Basic Information___Opening Balance | Number | Opening Balance as mentioned in USA Bank Statements |
| Basic Information___Closing Balance | Number | Closing Balance as mentioned in USA Bank Statements |
| Basic Information___Start Date | String | Start Date as mentioned in USA Bank Statements |
| Basic Information___End Date | String | End Date as mentioned in USA Bank Statements |
| Basic Information___Account Address | String | Account Address as mentioned in USA Bank Statements |
| Basic Information___Account Type | String | Account Type as mentioned in USA Bank Statements |
Transactions
| Field Name | Data Type | Field Description |
|---|---|---|
| Transactions___Line Items | Table | First Transaction table extracted from the bank statement |
| Transactions___Transaction Table__1 | Table | Second table extracted from the bank statement. |
| . | ||
| . | ||
| . | ||
|
Note: Naming convention followed is- First extracted table is by default called "Transactions___Line Items" and rest of the extracted tables follow the naming convention as "Transactions___Transaction Table <table_no > ". | ||
Features and Coverage
Features
- Transaction Tables Recognition: The API accurately identifies and picks up transaction tables from the input data.
- Duplicate Data Removal: The API effectively removes any duplicated check data, ensuring clean and unique information.
- Automated Processing: The API utilizes opening and closing balances to process documents without human intervention, increasing efficiency.
- Balance Tables Utilization: The API also picks up balance tables and uses them for post-processing tasks.
- Comprehensive Checks: The API performs three types of balance checks – daily balance, running balance, and opening/closing balance checks, ensuring accurate and reliable results.
STP - Straight Through Processing
Our product is designed to streamline and enhance the extraction process with a focus on efficiency and accuracy. By utilizing our balance check feature, users can confidently approve extractions without the need for human intervention. This is achieved by cross-referencing the balance information gathered from all balances within the statement, ensuring consistency and reliability in the extracted data.
In the event that any inconsistencies are detected, the document will be flagged for manual review. To further facilitate this process, our system intelligently highlights the specific line items in tables that may contain discrepancies, allowing for faster checks and approvals.
AutoSplit
Our product offers the ability to split multi-statement PDFs into separate files and process them. Users can upload multi-year, multi-statement scans, and receive combined output data for complex financial queries and analysis. This feature streamlines document management and enhances data processing capabilities.
Limitations
- Page Limitations: The API can process individual files with a maximum of 25 pages and combined files with a maximum of 400 pages.
- Table Requirements: Tables must have a Date column and either a Description or Check No. column for the API to recognize and process them.
- Amount Specifications: The API supports three ways of specifying amounts in tables: single amounts with +/- signs, separate debit and credit columns, and amounts with debit or credit specified by the title.
- Title Locations: The API can recognize titles placed above the table, on the left of the table, between lines indicating the type of data that follows, or in a dedicated title column within the table.
- Additional Columns: The API can utilize extra columns for other purposes, such as a balances column for tallying running balances. However, these columns may not be supported for all functionalities.
Banks Supported
While we showcase compatibility with a select list of banks, our API is engineered with a generic framework, empowering it to support data extraction from a vast array of financial institutions that we may not have explicitly tested on.
If you encounter a situation where the bank you intend to work with is not listed, or if the extraction process is not functioning as expected, please do not hesitate to reach out to our dedicated support team. We are committed to assisting you with any necessary customizations that will accommodate your specific requests and ensure a seamless integration with the financial institution of your choice.
Wells Fargo
TD Bank
Santander Bank
PNC Bank
M&T Bank
HSBC
Citizens Bank
Chase
Bank of America (BOA)
Woodforest Bank
Wachovia
Texas Republic Bank
Suntrust
Skylands Community Bank
Nevada State Bank
MB
Lincoln Park Savings Bank
SYLVIA HAPPY
Havens-Fulton Bank
Frost Bank
Flushing Bank
FFIB
City View Gardens LLC Bank
Bremer Bank
BB&T (Branch Banking and Trust Company)
Bank United
Bank of Jersey
Goldstein Astoria Bank
Astoria Bank
CIBC (Canadian Imperial Bank of Commerce)
Bank of Montreal
Deutsche Bank
Cathay Bank
American Express
Ally Financial
RBC (Royal Bank of Canada)
East West Bank
First Citizen
Columbia Bank
Arvest
Credit Suisse
TIAA
Comerica
Popular
UMB
Barclays
MidFirst
The Bank of New York Mellon
Webster Bank
Key Bank
Ally Bank
Bank of Hawaii
South State Bank
Commerce Bank
Error Codes
| Error | Description | Action |
|---|---|---|
| Error in Server | Something failed on the server side | Contact the support team |
| ERR_TRANSACTION_DISCREPANCY_XX | Discrepancy identified in transactions list | Look for a table with review required cells, correct the value, re-run the validation |
| ERR_OPENING_CLOSING_BALANCE_DISCREPANCY | No discrepancy in transactions found, so likely the opening and closing balance was wrong | Update the opening closing balance, re-run the validation |
| For Acc: 0 ERR_TALLY_PASSED, For Acc: 1 ERR_TRANSACTION_DISCREPANCY | Account wise error list | Take action according to the error message corresponding to the account |
Error Codes details
Format of the error message:
ERR_<MESSAGE>_<METAINFO>
e.g. ERR_TRANSACTION_DISCREPANCY_01
**Inference -> Document was extracted through bank statement and there was some discrepancy in transaction that was verified.
METAINFO identifies what extractors were used and can be used by developers for quick debugging in case of issues or bugs. For all practical purposes, clients can ignore this metainfo and discard it by discarding last two numeric digits of the error message
| Type of Extractor | Code |
|---|---|
| Bank Statement Extraction | 01 |
| Credit Card Extraction | 02 |
| Consolidated Extraction | 03 |
| Delta Community Special Extraction | 11 |
| Waukesha Special Extraction | 12 |
MESSAGE will give more information of the status of the extraction
ERR_TRANSACTION_DISCREPANCY
there was some discrepancy in the transactions which has been marked
ERR_OPENING_CLOSING_BALANCE_DISCREPANCY
the opening and closing balance were not extracted confidently, we were not able to mark the discrepancy in the transactions.
Consolidated Statements -
The error message formatting remains the same. The only difference is that a consolidated statement, will have information pertaining to multiple account types, the error messages would reflect the value for individual account type.
E.g.
Lets say we have two account types in a given document. One account type passed the Tally check while other had issue in transactions, then the message should look like this-
For Acc: 0 ERR_TALLY_PASSED, For Acc: 1 ERR_TRANSACTION_DISCREPANCY
Updated 3 months ago