The following shows JSON Text in the MTJson format.
{
"accounts": [
{
"bank_name": "Wells Fargo",
"account_name": "Business Checking",
"account_number": "1234",
"account_type": "checking",
"account_owner": "ACME Lumber",
"account_address": "123 Main St, Springfield, IL, 11111",
"statements": [
{
"start_date": "2024-10-01",
"end_date": "2024-10-31",
"start_balance": 1234.56,
"end_balance": 1234.56,
"transactions": [
{
"date": "2024-10-20",
"type": "credit",
"description": "McDonalds #3322",
"memo": "",
"check_number": 123,
"amount": -12.0,
"balance": 1432.16,
"customer_id": "123456"
}
]
}
]
}
]
}
To use the MTJson format, add these required fields.
For transactions:
datedescriptionamount
For statements:
startDateendDateendBalancestartBalance
For accounts:
bankNameaccountNumber
Note: Currency values cannot contain more than two decimal points. For example, 1.02 is allowed but not 1.002. Dates must be in the YYYY-MM-DD format.
You can add this optional field to the MTJson format:
customer_id- Shows the user-provided customer ID of each transaction.