Reporting API – Spending Plan

For details on how to consume Spending Plan reports, see the Reporting API Docs.

Reporting API – Spending Plan

The following are fields for Spending Plan reports.

Field Name	Data Type	Definition
created_at	Integer	The date and time at which the spending_plan was created.
current_iteration_number	Integer	The current active associated spending_plan_iteration number for a given spending_plan.
guid	String	The unique identifier for the spending_plan. Defined by MX.
updated_at	Integer	The date and time at which the spending_plan was last updated.
user_guid	String	The unique identifier for the user to which the spending_plan belongs. Defined by MX.
user_id	String	The unique partner-defined identifier for the user associated with the spending_plan.

Reporting API – Spending Plan Account

The following are fields for Spending Plan account reports.

Field Name	Data Type	Definition
account_guid	String	The unique identifier for the account associated with the spending_plan_account. Defined by MX.
created_at	Integer	The date and time at which the spending_plan_account was created.
guid	String	The unique identifier for the spending_plan_account. Defined by MX.
spending_plan_guid	String	The unique identifier for the spending_plan associated with the spending_plan_account. Defined by MX.
updated_at	Integer	The date and time at which the spending_plan_account was last updated.
user_guid	String	The unique identifier for the user to which the spending_plan_account belongs. Defined by MX.

Reporting API – Spending Plan Iteration

The following are fields for Spending Plan iteration reports.

Field Name	Data Type	Definition
created_at	Integer	The date and time at which the spending_plan_iteration was created.
end_on	Integer	The date at which the spending_plan_iteration ends.
guid	String	The unique identifier for the spending_plan_iteration. Defined by MX.
iteration_number	Integer	The current iteration number for the spending_plan_iteration.
spending_plan_guid	Integer	The unique identifier for the spending_plan. Defined by MX.
start_on	Integer	The date at which the spending_plan_iteration starts.
updated_at	Integer	The date and time at which the spending_plan_iteration was most recently updated.
user_guid	String	The unique identifier for the user to which the spending_plan_iteration belongs. Defined by MX.
user_id	String	The unique partner-defined identifier for the user associated with the spending_plan_iteration.

Reporting API – Spending Plan Iteration Item

The following are fields for Spending Plan iteration item reports.

Field Name	Data Type	Definition
actual_amount	Decimal	The sum of the transactions associated with the spending_plan_iteration_item.
category_guid	String	The unique identifier for the category_guid associated with the spending_plan_iteration. Defined by MX.
created_at	Integer	The date and time at which the spending_plan_iteration_item was created.
guid	String	The unique identifier for the spending_plan_iteration_item. Defined by MX.
item_type	String	The type of transaction grouping for the spending_plan_iteration_item. It will be RECURRING_EXPENSE, PLANNED_EXPENSE, OTHER_EXPENSE, or INCOME
planned_amount	Decimal	The total amount planned for a spending_plan_iteration_item.
scheduled_payment_guid	String	The unique identifier for the scheduled_payment_guid associated with the spending_plan_iteration_item. Defined by MX.
spending_plan_iteration_guid	String	The unique identifier for the spending_plan_iteration. Defined by MX.
top_level_category_guid	String	The unique identifier for the top_level_category_guid associated with the spending_plan_iteration_item. Defined by MX.
transaction_guids	Array	An array of transaction GUIDs that are relevant to the spending_plan_iteration_item. Defined by MX.
updated_at	Integer	The date and time at which the spending_plan_iteration_item was most recently updated.
user_guid	String	The unique identifier for the user to which the spending_plan_iteration_item belongs. Defined by MX.
user_id	String	The unique partner-defined identifier for the user associated with the spending_plan_iteration_item.