Last updated

MoneyThumb JSON (MTJson) Example

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
                        }
                    ]
                }
            ]
        }
    ]
}

Required Fields

To use the MTJson format, add these required fields.

For transactions:

  • date
  • description
  • amount

For statements:

  • startDate
  • endDate
  • endBalance
  • startBalance

For accounts:

  • bankName
  • accountNumber

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.