Get all statement transactions Run in API Explorer
Query parameters
-
Comma separated list of relationships to include in the response. Valid relationships are [statement, providerStatement].
-
Filter by a comma separated list of UUIDs.
-
Filter provider statement transactions by a statement UUID.
-
Filter provider statement transactions by an exact provider statement UUID.
-
Get provider statement transactions from a certain date.
-
Get provider statement transactions to a certain date.
-
Get provider statement transactions greater than or equal to a certain amount in pennies.
-
Get provider statement transactions less than or equal to a certain amount in pennies.
-
Filter by partial client name given on provider statement.
-
Filter by partial policy number given on provider statement.
-
Filter by partial transaction reference.
-
Filter by partial agency number.
-
Filter by partial product reference.
-
Filter provider statement transactions by exact provider UUID.
-
Filter provider statement transactions to client or provider paid. Valid options are [client, provider]
-
Comma separated string of categories to filter by.
-
Filter by partial adviser name given on provider statement.
-
Filter provider statement transactions by their reconciliation status. Valid statuses are reconciled,unreconciled,reconciled_with_expectations,reconciled_with_bank_transactions,unreconciled_with_expectations,unreconciled_with_bank_transactions,partially_reconciled_with_expectations,partially_reconciled_with_bank_transactions
-
Field to sort by. Valid fields are [created_at, updated_at, date, policy_number, client_name, gross_amount]. Negative sign to denote DESC. Defaults to '-updated_at'.
-
Number of results to return with pagination (Default 15. Max 500).
curl \
--request GET 'https://api.plannrcrm.com/api/v1/statement-transaction' \
--header "Authorization: Bearer $ACCESS_TOKEN" \
--header "X-PLANNR-ACCOUNT-UUID: {YOUR_PLANNR_ACCOUNT_UUID}"
{
"uuid": "b89a9372-64d2-46c2-a158-1d1bc44e7c61",
"created_at": "2026-09-18T09:00:12+01:00",
"updated_at": "2026-09-18T09:00:12+01:00",
"client_name": "Gareth Thompson",
"transaction_reference": "0SBG08pwhs",
"policy_number": "AVIVA_00001",
"date": "2026-09-18",
"gross_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": "GBP",
"description": "Currency of the money"
}
},
"net_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": "GBP",
"description": "Currency of the money"
}
},
"category": "initial_fee",
"payment_origin": "provider",
"agency_number": "Agency number",
"product_reference": "Product reference",
"adviser_name": "Adviser name",
"sender_id_sib_number": "Sender id sib number",
"reason": "Reason",
"auto_reconciliation_message": "No plans matching policy number AVIVA_00001.",
"scheme_name": "Scheme name",
"scheme_number": "Scheme number",
"customer_number": "Customer number",
"policy_market_value": "Policy market value",
"provider": "Aviva",
"provider_statement": {
"uuid": "d4c99efe-f9d0-4988-9782-26339f45c244",
"created_at": "2026-09-18T09:00:12+01:00",
"updated_at": "2026-09-18T09:00:12+01:00",
"number": 23,
"name": "Aviva",
"date": "2026-09-18",
"reference": "SW#8434",
"filename": "aviva-statement-may.csv",
"origin": "upload",
"provider": {
"uuid": "883a7e39-9ca9-434b-8101-8b8a83f2db2b",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"name": "AJ Bell",
"slug": "aj-bell"
},
"statement": {
"uuid": "f201c976-a40e-446e-b159-20146a45522c",
"created_at": "2026-09-18T09:00:18+01:00",
"updated_at": "2026-09-18T09:00:18+01:00",
"name": "01/06/2022 - 30/06/2022",
"start_date": "2022-06-30",
"end_date": "2022-06-01",
"locked": false,
"locked_at": "2026-09-18T09:00:18+01:00",
"total_expectations": null,
"total_statement_transactions": null,
"total_bank_transactions": null,
"total_expectation_amount_reconciled_to_bank": null,
"total_expectation_percentage_reconciled_to_bank": null,
"expectations_count": 6,
"statement_transactions_count": 6
},
"statement_transactions_count": 6,
"statement_transactions": {
"uuid": "79e42049-bf16-4a95-a062-3bec276f7154",
"created_at": "2026-09-18T09:00:18+01:00",
"updated_at": "2026-09-18T09:00:18+01:00",
"client_name": "Gareth Thompson",
"transaction_reference": "4u5Xa2EhOO",
"policy_number": "AVIVA_00001",
"date": "2026-09-18",
"gross_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
},
"net_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
},
"category": "initial_fee",
"payment_origin": "provider",
"agency_number": "Agency number",
"product_reference": "Product reference",
"adviser_name": "Adviser name",
"sender_id_sib_number": "Sender id sib number",
"reason": "Reason",
"auto_reconciliation_message": "No plans matching policy number AVIVA_00001.",
"scheme_name": "Scheme name",
"scheme_number": "Scheme number",
"customer_number": "Customer number",
"policy_market_value": "Policy market value",
"provider": "Aviva",
"metadata": {
"client_name": "Gareth Thompson"
}
},
"total_amount": {
"amount": "345895",
"currency": "GBP",
"formatted": "£3,458.95"
},
"reconciled_expectations_amount": {
"amount": "12849",
"currency": "GBP",
"formatted": "£128.49"
},
"reconciled_expectations_percentage": 95.68,
"reconciled_bank_transactions_amount": {
"amount": "22985",
"currency": "GBP",
"formatted": "£229.85"
},
"reconciled_bank_transactions_percentage": 95.68,
"is_fully_reconciled_to_expectations": true
},
"metadata": {
"client_name": "Gareth Thompson"
},
"expectation": {
"uuid": "759c24dc-63a6-4f9e-b5f2-fb47851e7a2a",
"created_at": "2026-09-18T09:00:12+01:00",
"updated_at": "2026-09-18T09:00:12+01:00",
"payment_origin": "provider",
"type": "fee",
"category": "ongoing_fee",
"expected_payment_date": "2026-09-18T09:00:12+01:00",
"tax_exempt": true,
"tax": 20,
"recurring": true,
"is_balanced": false,
"unbalanced_expected_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": "GBP",
"description": "Currency of the money"
}
},
"expected_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": "GBP",
"description": "Currency of the money"
}
},
"gross_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": "GBP",
"description": "Currency of the money"
}
},
"net_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": "GBP",
"description": "Currency of the money"
}
},
"amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": "GBP",
"description": "Currency of the money"
}
},
"percentage": 0.75,
"exclude_from_rmar": true,
"rmar_type": "adviser_charge",
"advice_type": "independent",
"service_type": "initial",
"advice_area_gross": {
"deposit": 7500,
"non_regulated": 0,
"non_rmar": 0,
"non_investment_insurance": 0,
"regulated_mortgage": 2500,
"retail_investment": 0,
"other_fca_regulated": 0,
"unknown": 0
},
"advice_area_net": {
"deposit": 7500,
"non_regulated": 0,
"non_rmar": 0,
"non_investment_insurance": 0,
"regulated_mortgage": 2500,
"retail_investment": 0,
"other_fca_regulated": 0,
"unknown": 0
},
"account": {
"uuid": "09271b9d-7714-43c8-9ba5-23b37ff3621e",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "client",
"role": "client",
"first_name": "Gareth",
"last_name": "Thompson",
"name": "Gareth Thompson",
"email": "gareth@codepotato.co.uk",
"photo_url": "https://eu.ui-avatars.com/api/?name=gareth+thompson",
"first_contact_date": "2026-09-18T09:00:17+01:00",
"next_review_date": "2026-09-18T09:00:17+01:00",
"previous_review_date": "2026-09-18T09:00:17+01:00",
"anniversary_review_date": "2026-09-18T09:00:17+01:00",
"terms_of_business_at": "2026-09-18T09:00:17+01:00",
"client_agreement_at": "2026-09-18T09:00:17+01:00",
"with_login": true,
"has_joint_account": true,
"can_be_deleted": "false",
"ownership_percentage": 100.0,
"inactive_at": "2026-09-18",
"last_interaction_at": "2026-09-18 09:00:17",
"referral_code": "ABC12345",
"is_out_of_office": true,
"out_of_office_from": "2026-09-18T09:00:17+01:00",
"out_of_office_until": "2026-09-18T09:00:17+01:00",
"out_of_office_message": "I am away this week. For urgent matters please contact the office.",
"is_pending_fact_find_account": false,
"permissions": {
"firm:read": [
"firm"
],
"network:read": [
"network:uuid"
]
}
},
"seller": {
"uuid": "09271b9d-7714-43c8-9ba5-23b37ff3621e",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "client",
"role": "client",
"first_name": "Gareth",
"last_name": "Thompson",
"name": "Gareth Thompson",
"email": "gareth@codepotato.co.uk",
"photo_url": "https://eu.ui-avatars.com/api/?name=gareth+thompson",
"first_contact_date": "2026-09-18T09:00:17+01:00",
"next_review_date": "2026-09-18T09:00:17+01:00",
"previous_review_date": "2026-09-18T09:00:17+01:00",
"anniversary_review_date": "2026-09-18T09:00:17+01:00",
"terms_of_business_at": "2026-09-18T09:00:17+01:00",
"client_agreement_at": "2026-09-18T09:00:17+01:00",
"with_login": true,
"has_joint_account": true,
"can_be_deleted": "false",
"ownership_percentage": 100.0,
"inactive_at": "2026-09-18",
"last_interaction_at": "2026-09-18 09:00:17",
"referral_code": "ABC12345",
"is_out_of_office": true,
"out_of_office_from": "2026-09-18T09:00:17+01:00",
"out_of_office_until": "2026-09-18T09:00:17+01:00",
"out_of_office_message": "I am away this week. For urgent matters please contact the office.",
"is_pending_fact_find_account": false,
"permissions": {
"firm:read": [
"firm"
],
"network:read": [
"network:uuid"
]
}
},
"author": {
"uuid": "09271b9d-7714-43c8-9ba5-23b37ff3621e",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "client",
"role": "client",
"first_name": "Gareth",
"last_name": "Thompson",
"name": "Gareth Thompson",
"email": "gareth@codepotato.co.uk",
"photo_url": "https://eu.ui-avatars.com/api/?name=gareth+thompson",
"first_contact_date": "2026-09-18T09:00:17+01:00",
"next_review_date": "2026-09-18T09:00:17+01:00",
"previous_review_date": "2026-09-18T09:00:17+01:00",
"anniversary_review_date": "2026-09-18T09:00:17+01:00",
"terms_of_business_at": "2026-09-18T09:00:17+01:00",
"client_agreement_at": "2026-09-18T09:00:17+01:00",
"with_login": true,
"has_joint_account": true,
"can_be_deleted": "false",
"ownership_percentage": 100.0,
"inactive_at": "2026-09-18",
"last_interaction_at": "2026-09-18 09:00:17",
"referral_code": "ABC12345",
"is_out_of_office": true,
"out_of_office_from": "2026-09-18T09:00:17+01:00",
"out_of_office_until": "2026-09-18T09:00:17+01:00",
"out_of_office_message": "I am away this week. For urgent matters please contact the office.",
"is_pending_fact_find_account": false,
"permissions": {
"firm:read": [
"firm"
],
"network:read": [
"network:uuid"
]
}
},
"charge_schedule": {
"uuid": "0db159d8-0233-4a27-aedf-a6a6fe3b2e85",
"created_at": "2026-09-18T09:00:18+01:00",
"updated_at": "2026-09-18T09:00:18+01:00",
"payment_origin": "provider",
"type": "fee",
"category": "ongoing_fee",
"recurring": true,
"frequency": "monthly",
"start_date": "2026-01-18",
"end_date": "2026-10-18",
"next_expectation_date": "2026-09-28",
"tax_exempt": false,
"tax": 17.5,
"amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
},
"percentage": 0.75,
"percentage_frequency": "annually",
"charge_identifier": "PLANNR-72484",
"exclude_from_rmar": true,
"rmar_type": "adviser_charge",
"advice_type": "independent",
"service_type": "initial",
"advice_area": {
"deposit": 7500,
"non_regulated": 0,
"non_rmar": 0,
"non_investment_insurance": 0,
"regulated_mortgage": 2500,
"retail_investment": 0,
"other_fca_regulated": 0,
"unknown": 0
},
"plan_value": "plan",
"chargeable_type": null,
"notes_count": 5
},
"chargeable_type": "plan",
"chargeable": {
"uuid": "26abbf28-5f98-471b-aeb2-71cc0789bcf4",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"opened_at": "2026-09-18T09:00:17+01:00",
"name": "Johns ISA",
"type": "cash_account",
"sub_type": "lifetime isa",
"abstract_type": "asset",
"policy_number": "AVIVA-123",
"proposal_reference": "AB123456",
"status": "inactive",
"inactive_at": "2026-09-18T09:00:17+01:00",
"inactive_reason": "claimed",
"agency_in_your_name": true,
"agency_in_your_name_from": "2025-09-18",
"originally_sold_by_firm": true,
"under_advice": true,
"visible_on_client_portal": true,
"include_in_client_valuation": true,
"show_on_joint": true,
"shown_on_circles": true,
"review_date": "2025-09-18",
"on_panel": true,
"is_group_scheme": false,
"is_sub_group_scheme": false,
"is_group_scheme_member": false,
"advice_area": "non_investment_insurance",
"total_benefit_amount": {
"amount": {
"example": "25000000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£250,000.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
},
"total_benefits": {
"critical_illness": {
"amount": {
"example": "15000000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£150,000.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
},
"family_income_benefit": {
"amount": {
"example": "10000000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£100,000.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
}
},
"value": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
},
"valued_at": "2026-09-18T09:00:17+01:00",
"original_valued_at": "2026-09-17T09:00:17+01:00",
"statistics": {
"recent_growth": 100
},
"is_wrap_product": false,
"is_wrap_child": false,
"can_be_deleted": "false"
},
"statement_transactions": {
"uuid": "79e42049-bf16-4a95-a062-3bec276f7154",
"created_at": "2026-09-18T09:00:18+01:00",
"updated_at": "2026-09-18T09:00:18+01:00",
"client_name": "Gareth Thompson",
"transaction_reference": "4u5Xa2EhOO",
"policy_number": "AVIVA_00001",
"date": "2026-09-18",
"gross_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
},
"net_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
},
"category": "initial_fee",
"payment_origin": "provider",
"agency_number": "Agency number",
"product_reference": "Product reference",
"adviser_name": "Adviser name",
"sender_id_sib_number": "Sender id sib number",
"reason": "Reason",
"auto_reconciliation_message": "No plans matching policy number AVIVA_00001.",
"scheme_name": "Scheme name",
"scheme_number": "Scheme number",
"customer_number": "Customer number",
"policy_market_value": "Policy market value",
"provider": "Aviva",
"metadata": {
"client_name": "Gareth Thompson"
}
},
"statement": {
"uuid": "f201c976-a40e-446e-b159-20146a45522c",
"created_at": "2026-09-18T09:00:18+01:00",
"updated_at": "2026-09-18T09:00:18+01:00",
"name": "01/06/2022 - 30/06/2022",
"start_date": "2022-06-30",
"end_date": "2022-06-01",
"locked": false,
"locked_at": "2026-09-18T09:00:18+01:00",
"total_expectations": null,
"total_statement_transactions": null,
"total_bank_transactions": null,
"total_expectation_amount_reconciled_to_bank": null,
"total_expectation_percentage_reconciled_to_bank": null,
"expectations_count": 6,
"statement_transactions_count": 6
},
"income_splits": {
"splitable_type": "account",
"splitable_uuid": "8f4413b8-0111-4ce6-ab49-5578aaa3cb9e",
"type": "selling_adviser",
"name": "Gareth Thompson",
"requested_percentage": 70,
"percentage": 70,
"expected_amount": null,
"expected_gross_amount": null,
"expected_net_amount": null,
"expected_fci_recognition": null,
"reconciled_gross_amount": null,
"reconciled_net_amount": null,
"reconciled_fci_recognition": null,
"bank_receipt_date": "2026-09-18"
},
"firm": {
"uuid": "be357285-de5e-4d35-95b0-4a4d8f80b228",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"name": "Codepotato",
"slug": "codepotato",
"address_1": "Suite E, 5 The Briars",
"address_2": "Waterberry Drive",
"town_city": "Waterlooville",
"county": "Hampshire",
"postcode": "PO7 7YH",
"country": "United Kingdom",
"regulatory_text": "Regulatory text",
"logo": "https://api.plannrcrm.com/images/plannr.jpg",
"logo_icon": "https://api.plannrcrm.com/images/plannr-icon.jpg",
"brand_colours": {
"sidebar_background": "#0E0E56",
"sidebar_accent": "#36367E",
"sidebar_text": "#FFFFFF",
"sidebar_hover": "#0A0A42",
"sidebar_active": "#53DBB8",
"sidebar_title_background": "#36367E",
"sidebar_title_primary": "#FFC634",
"sidebar_title_secondary": "#FFFFFF",
"sidebar_title_secondary_hover": "#FFFFFF",
"email_background": "#0E0E56",
"email_logo_background_panel": "#36367E",
"email_sub_text": "#FFFFFF",
"email_button_background": "#36367E",
"email_button_text": "#FFFFFF",
"portal_sidebar_button_background": "#F6F6F6",
"portal_sidebar_button_hover": "#FFFFFF",
"portal_sidebar_button_active": "#FFFFFF",
"portal_brand_title": "#323B4B",
"portal_brand_sub_title": "#828994",
"portal_sidebar_title": "#11151D",
"portal_sidebar_text": "#323B4B",
"portal_sidebar_text_hover": "#323B4B",
"portal_sidebar_text_active": "#323B4B",
"portal_sidebar_icon": "#828994",
"portal_sidebar_icon_hover": "#828994",
"portal_sidebar_icon_active": "#828994",
"portal_background": "#F6F6F6",
"portal_sidebar_account_title": "#11151D",
"portal_sidebar_account_email": "#828994",
"portal_sidebar_divider": "#E3E5E9",
"portal_dashboard_bg_one": "#EF4583",
"portal_dashboard_bg_two": "#FFC634",
"portal_sidebar_collapse_button": "#828994",
"portal_sidebar_collapse_button_hover": "#B3B9C4",
"portal_sidebar_user_select_background": "#F6F6F6",
"portal_sidebar_user_select_hover": "#F6F6F6",
"portal_sidebar_user_select_text": "#323B4B",
"portal_sidebar_user_select_text_hover": "#323B4B",
"portal_sidebar_user_select_border": "#EEEEEE",
"portal_sidebar_user_select_border_hover": "#828994"
},
"factfind_pdf_header_background": "#0E0E56",
"factfind_pdf_header_text": "#ffffff",
"factfind_pdf_logo": "https://api.plannrcrm.com/images/plannr.jpg",
"is_subscribed": true,
"keep_deleted_files_for": 30,
"tax": 17.5,
"month_end": 25,
"statement_frequency": "monthly",
"billing": {
"invoice_address_1": "Suite E, 5 The Briars",
"invoice_address_2": "Waterberry Drive",
"invoice_town_city": "Waterlooville",
"invoice_county": "Hampshire",
"invoice_postcode": "PO7 7YH",
"invoice_country": "United Kingdom",
"invoice_email": "gareth@codepotato.co.uk"
},
"ip_whitelist": [
"192.168.0.1",
"127.0.0.1"
],
"welcome_paragraph_html": "<h1>Welcome.</h1>",
"email_welcome_paragraph_html": "Welcome to Plannr!",
"show_fact_find_illustrations": true,
"cc_email_addresses": [
"jack@example.com",
"jill@example.com"
],
"bcc_email_addresses": [
"jack@example.com",
"jill@example.com"
],
"reply_to_email_address": "jack@example.com",
"mobile_app_support_number": "01234 567890",
"mobile_app_support_email": "support@example.com"
},
"notes_count": 5
},
"bank_transactions": [
{
"uuid": "b84b774c-362d-4ddf-ad48-74e4d6f33082",
"created_at": "2026-09-18T09:00:12+01:00",
"updated_at": "2026-09-18T09:00:12+01:00",
"date": "2022-07-15",
"amount": {
"amount": "12399",
"currency": "GBP",
"formatted": "£123.99"
},
"reference": "VitalityLtd",
"metadata": {
"client_name": "Gareth Thompson"
},
"filename": "Natwest June 2022 Statement.xlsx",
"bank_statement": {
"uuid": "1ba15676-7d9a-4a9f-a599-9355cb518712",
"created_at": "2026-09-18T09:00:18+01:00",
"updated_at": "2026-09-18T09:00:18+01:00",
"number": 23,
"reference": "SW#8434",
"date": "2026-09-18",
"name": "Aviva",
"bank_transactions_count": 6,
"total_amount": null,
"reconciled_amount": null,
"reconciled_percentage": 95.68
},
"statement": {
"uuid": "f201c976-a40e-446e-b159-20146a45522c",
"created_at": "2026-09-18T09:00:18+01:00",
"updated_at": "2026-09-18T09:00:18+01:00",
"name": "01/06/2022 - 30/06/2022",
"start_date": "2022-06-30",
"end_date": "2022-06-01",
"locked": false,
"locked_at": "2026-09-18T09:00:18+01:00",
"total_expectations": null,
"total_statement_transactions": null,
"total_bank_transactions": null,
"total_expectation_amount_reconciled_to_bank": null,
"total_expectation_percentage_reconciled_to_bank": null,
"expectations_count": 6,
"statement_transactions_count": 6
},
"account": {
"uuid": "09271b9d-7714-43c8-9ba5-23b37ff3621e",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "client",
"role": "client",
"first_name": "Gareth",
"last_name": "Thompson",
"name": "Gareth Thompson",
"email": "gareth@codepotato.co.uk",
"photo_url": "https://eu.ui-avatars.com/api/?name=gareth+thompson",
"first_contact_date": "2026-09-18T09:00:17+01:00",
"next_review_date": "2026-09-18T09:00:17+01:00",
"previous_review_date": "2026-09-18T09:00:17+01:00",
"anniversary_review_date": "2026-09-18T09:00:17+01:00",
"terms_of_business_at": "2026-09-18T09:00:17+01:00",
"client_agreement_at": "2026-09-18T09:00:17+01:00",
"with_login": true,
"has_joint_account": true,
"can_be_deleted": "false",
"ownership_percentage": 100.0,
"inactive_at": "2026-09-18",
"last_interaction_at": "2026-09-18 09:00:17",
"referral_code": "ABC12345",
"is_out_of_office": true,
"out_of_office_from": "2026-09-18T09:00:17+01:00",
"out_of_office_until": "2026-09-18T09:00:17+01:00",
"out_of_office_message": "I am away this week. For urgent matters please contact the office.",
"is_pending_fact_find_account": false,
"permissions": {
"firm:read": [
"firm"
],
"network:read": [
"network:uuid"
]
}
},
"firm": {
"uuid": "be357285-de5e-4d35-95b0-4a4d8f80b228",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"name": "Codepotato",
"slug": "codepotato",
"address_1": "Suite E, 5 The Briars",
"address_2": "Waterberry Drive",
"town_city": "Waterlooville",
"county": "Hampshire",
"postcode": "PO7 7YH",
"country": "United Kingdom",
"regulatory_text": "Regulatory text",
"logo": "https://api.plannrcrm.com/images/plannr.jpg",
"logo_icon": "https://api.plannrcrm.com/images/plannr-icon.jpg",
"brand_colours": {
"sidebar_background": "#0E0E56",
"sidebar_accent": "#36367E",
"sidebar_text": "#FFFFFF",
"sidebar_hover": "#0A0A42",
"sidebar_active": "#53DBB8",
"sidebar_title_background": "#36367E",
"sidebar_title_primary": "#FFC634",
"sidebar_title_secondary": "#FFFFFF",
"sidebar_title_secondary_hover": "#FFFFFF",
"email_background": "#0E0E56",
"email_logo_background_panel": "#36367E",
"email_sub_text": "#FFFFFF",
"email_button_background": "#36367E",
"email_button_text": "#FFFFFF",
"portal_sidebar_button_background": "#F6F6F6",
"portal_sidebar_button_hover": "#FFFFFF",
"portal_sidebar_button_active": "#FFFFFF",
"portal_brand_title": "#323B4B",
"portal_brand_sub_title": "#828994",
"portal_sidebar_title": "#11151D",
"portal_sidebar_text": "#323B4B",
"portal_sidebar_text_hover": "#323B4B",
"portal_sidebar_text_active": "#323B4B",
"portal_sidebar_icon": "#828994",
"portal_sidebar_icon_hover": "#828994",
"portal_sidebar_icon_active": "#828994",
"portal_background": "#F6F6F6",
"portal_sidebar_account_title": "#11151D",
"portal_sidebar_account_email": "#828994",
"portal_sidebar_divider": "#E3E5E9",
"portal_dashboard_bg_one": "#EF4583",
"portal_dashboard_bg_two": "#FFC634",
"portal_sidebar_collapse_button": "#828994",
"portal_sidebar_collapse_button_hover": "#B3B9C4",
"portal_sidebar_user_select_background": "#F6F6F6",
"portal_sidebar_user_select_hover": "#F6F6F6",
"portal_sidebar_user_select_text": "#323B4B",
"portal_sidebar_user_select_text_hover": "#323B4B",
"portal_sidebar_user_select_border": "#EEEEEE",
"portal_sidebar_user_select_border_hover": "#828994"
},
"factfind_pdf_header_background": "#0E0E56",
"factfind_pdf_header_text": "#ffffff",
"factfind_pdf_logo": "https://api.plannrcrm.com/images/plannr.jpg",
"is_subscribed": true,
"keep_deleted_files_for": 30,
"tax": 17.5,
"month_end": 25,
"statement_frequency": "monthly",
"billing": {
"invoice_address_1": "Suite E, 5 The Briars",
"invoice_address_2": "Waterberry Drive",
"invoice_town_city": "Waterlooville",
"invoice_county": "Hampshire",
"invoice_postcode": "PO7 7YH",
"invoice_country": "United Kingdom",
"invoice_email": "gareth@codepotato.co.uk"
},
"ip_whitelist": [
"192.168.0.1",
"127.0.0.1"
],
"welcome_paragraph_html": "<h1>Welcome.</h1>",
"email_welcome_paragraph_html": "Welcome to Plannr!",
"show_fact_find_illustrations": true,
"cc_email_addresses": [
"jack@example.com",
"jill@example.com"
],
"bcc_email_addresses": [
"jack@example.com",
"jill@example.com"
],
"reply_to_email_address": "jack@example.com",
"mobile_app_support_number": "01234 567890",
"mobile_app_support_email": "support@example.com"
}
}
],
"statement": {
"uuid": "c45e2bd7-9f9f-495f-9122-fd03a04954c3",
"created_at": "2026-09-18T09:00:12+01:00",
"updated_at": "2026-09-18T09:00:12+01:00",
"name": "01/06/2022 - 30/06/2022",
"start_date": "2022-06-30",
"end_date": "2022-06-01",
"locked": false,
"locked_at": "2026-09-18T09:00:12+01:00",
"locked_by": {
"uuid": "09271b9d-7714-43c8-9ba5-23b37ff3621e",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "client",
"role": "client",
"first_name": "Gareth",
"last_name": "Thompson",
"name": "Gareth Thompson",
"email": "gareth@codepotato.co.uk",
"photo_url": "https://eu.ui-avatars.com/api/?name=gareth+thompson",
"first_contact_date": "2026-09-18T09:00:17+01:00",
"next_review_date": "2026-09-18T09:00:17+01:00",
"previous_review_date": "2026-09-18T09:00:17+01:00",
"anniversary_review_date": "2026-09-18T09:00:17+01:00",
"terms_of_business_at": "2026-09-18T09:00:17+01:00",
"client_agreement_at": "2026-09-18T09:00:17+01:00",
"with_login": true,
"has_joint_account": true,
"can_be_deleted": "false",
"ownership_percentage": 100.0,
"inactive_at": "2026-09-18",
"last_interaction_at": "2026-09-18 09:00:17",
"referral_code": "ABC12345",
"is_out_of_office": true,
"out_of_office_from": "2026-09-18T09:00:17+01:00",
"out_of_office_until": "2026-09-18T09:00:17+01:00",
"out_of_office_message": "I am away this week. For urgent matters please contact the office.",
"is_pending_fact_find_account": false,
"permissions": {
"firm:read": [
"firm"
],
"network:read": [
"network:uuid"
]
}
},
"total_expectations": {
"amount": "124585",
"currency": "GBP",
"formatted": "£1,245.85"
},
"total_statement_transactions": {
"amount": "125599",
"currency": "GBP",
"formatted": "£1,255.99"
},
"total_bank_transactions": {
"amount": "125599",
"currency": "GBP",
"formatted": "£1,255.99"
},
"total_expectation_amount_reconciled_to_bank": {
"amount": "125599",
"currency": "GBP",
"formatted": "£1,255.99"
},
"total_expectation_percentage_reconciled_to_bank": {
"amount": "8570",
"currency": "GBP",
"formatted": "£85.70"
},
"expectations_count": 6,
"statement_transactions_count": 6,
"statement_transactions": {
"uuid": "79e42049-bf16-4a95-a062-3bec276f7154",
"created_at": "2026-09-18T09:00:18+01:00",
"updated_at": "2026-09-18T09:00:18+01:00",
"client_name": "Gareth Thompson",
"transaction_reference": "4u5Xa2EhOO",
"policy_number": "AVIVA_00001",
"date": "2026-09-18",
"gross_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
},
"net_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
},
"category": "initial_fee",
"payment_origin": "provider",
"agency_number": "Agency number",
"product_reference": "Product reference",
"adviser_name": "Adviser name",
"sender_id_sib_number": "Sender id sib number",
"reason": "Reason",
"auto_reconciliation_message": "No plans matching policy number AVIVA_00001.",
"scheme_name": "Scheme name",
"scheme_number": "Scheme number",
"customer_number": "Customer number",
"policy_market_value": "Policy market value",
"provider": "Aviva",
"metadata": {
"client_name": "Gareth Thompson"
}
}
},
"account": {
"uuid": "1192c21f-6b93-4824-b029-7ab44427a086",
"created_at": "2026-09-18T09:00:12+01:00",
"updated_at": "2026-09-18T09:00:12+01:00",
"type": "client",
"role": "client",
"first_name": "Gareth",
"last_name": "Thompson",
"name": "Gareth Thompson",
"email": "gareth@codepotato.co.uk",
"photo_url": "https://eu.ui-avatars.com/api/?name=gareth+thompson",
"firm": {
"uuid": "be357285-de5e-4d35-95b0-4a4d8f80b228",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"name": "Codepotato",
"slug": "codepotato",
"address_1": "Suite E, 5 The Briars",
"address_2": "Waterberry Drive",
"town_city": "Waterlooville",
"county": "Hampshire",
"postcode": "PO7 7YH",
"country": "United Kingdom",
"regulatory_text": "Regulatory text",
"logo": "https://api.plannrcrm.com/images/plannr.jpg",
"logo_icon": "https://api.plannrcrm.com/images/plannr-icon.jpg",
"brand_colours": {
"sidebar_background": "#0E0E56",
"sidebar_accent": "#36367E",
"sidebar_text": "#FFFFFF",
"sidebar_hover": "#0A0A42",
"sidebar_active": "#53DBB8",
"sidebar_title_background": "#36367E",
"sidebar_title_primary": "#FFC634",
"sidebar_title_secondary": "#FFFFFF",
"sidebar_title_secondary_hover": "#FFFFFF",
"email_background": "#0E0E56",
"email_logo_background_panel": "#36367E",
"email_sub_text": "#FFFFFF",
"email_button_background": "#36367E",
"email_button_text": "#FFFFFF",
"portal_sidebar_button_background": "#F6F6F6",
"portal_sidebar_button_hover": "#FFFFFF",
"portal_sidebar_button_active": "#FFFFFF",
"portal_brand_title": "#323B4B",
"portal_brand_sub_title": "#828994",
"portal_sidebar_title": "#11151D",
"portal_sidebar_text": "#323B4B",
"portal_sidebar_text_hover": "#323B4B",
"portal_sidebar_text_active": "#323B4B",
"portal_sidebar_icon": "#828994",
"portal_sidebar_icon_hover": "#828994",
"portal_sidebar_icon_active": "#828994",
"portal_background": "#F6F6F6",
"portal_sidebar_account_title": "#11151D",
"portal_sidebar_account_email": "#828994",
"portal_sidebar_divider": "#E3E5E9",
"portal_dashboard_bg_one": "#EF4583",
"portal_dashboard_bg_two": "#FFC634",
"portal_sidebar_collapse_button": "#828994",
"portal_sidebar_collapse_button_hover": "#B3B9C4",
"portal_sidebar_user_select_background": "#F6F6F6",
"portal_sidebar_user_select_hover": "#F6F6F6",
"portal_sidebar_user_select_text": "#323B4B",
"portal_sidebar_user_select_text_hover": "#323B4B",
"portal_sidebar_user_select_border": "#EEEEEE",
"portal_sidebar_user_select_border_hover": "#828994"
},
"factfind_pdf_header_background": "#0E0E56",
"factfind_pdf_header_text": "#ffffff",
"factfind_pdf_logo": "https://api.plannrcrm.com/images/plannr.jpg",
"is_subscribed": true,
"keep_deleted_files_for": 30,
"tax": 17.5,
"month_end": 25,
"statement_frequency": "monthly",
"billing": {
"invoice_address_1": "Suite E, 5 The Briars",
"invoice_address_2": "Waterberry Drive",
"invoice_town_city": "Waterlooville",
"invoice_county": "Hampshire",
"invoice_postcode": "PO7 7YH",
"invoice_country": "United Kingdom",
"invoice_email": "gareth@codepotato.co.uk"
},
"ip_whitelist": [
"192.168.0.1",
"127.0.0.1"
],
"welcome_paragraph_html": "<h1>Welcome.</h1>",
"email_welcome_paragraph_html": "Welcome to Plannr!",
"show_fact_find_illustrations": true,
"cc_email_addresses": [
"jack@example.com",
"jill@example.com"
],
"bcc_email_addresses": [
"jack@example.com",
"jill@example.com"
],
"reply_to_email_address": "jack@example.com",
"mobile_app_support_number": "01234 567890",
"mobile_app_support_email": "support@example.com"
},
"primary_phone_number": {
"uuid": "5e75fc37-641d-403c-9f3c-2748db607320",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "phone_number",
"name": "Work number",
"value": "+443330903630",
"phone_number_meta": {
"country": "GB",
"formatted": "0333 090 3630"
}
},
"primary_email": {
"uuid": "5e75fc37-641d-403c-9f3c-2748db607320",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "phone_number",
"name": "Work number",
"value": "+443330903630",
"phone_number_meta": {
"country": "GB",
"formatted": "0333 090 3630"
}
},
"current_time_entry": {
"uuid": "7588bcc4-3eed-4a20-a4ca-3297b4d8986f",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"name": "Research",
"description": "This is a description.",
"trackable_type": "Client",
"start_date": "2026-09-18T08:10:17+01:00",
"end_date": "2026-09-18T08:38:17+01:00",
"is_active": true,
"total_time_in_minutes": 28,
"computed_time_elapsed_in_seconds": 1680
},
"assigned_adviser": {
"uuid": "09271b9d-7714-43c8-9ba5-23b37ff3621e",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "client",
"role": "client",
"first_name": "Gareth",
"last_name": "Thompson",
"name": "Gareth Thompson",
"email": "gareth@codepotato.co.uk",
"photo_url": "https://eu.ui-avatars.com/api/?name=gareth+thompson",
"first_contact_date": "2026-09-18T09:00:17+01:00",
"next_review_date": "2026-09-18T09:00:17+01:00",
"previous_review_date": "2026-09-18T09:00:17+01:00",
"anniversary_review_date": "2026-09-18T09:00:17+01:00",
"terms_of_business_at": "2026-09-18T09:00:17+01:00",
"client_agreement_at": "2026-09-18T09:00:17+01:00",
"with_login": true,
"has_joint_account": true,
"can_be_deleted": "false",
"ownership_percentage": 100.0,
"inactive_at": "2026-09-18",
"last_interaction_at": "2026-09-18 09:00:17",
"referral_code": "ABC12345",
"is_out_of_office": true,
"out_of_office_from": "2026-09-18T09:00:17+01:00",
"out_of_office_until": "2026-09-18T09:00:17+01:00",
"out_of_office_message": "I am away this week. For urgent matters please contact the office.",
"is_pending_fact_find_account": false,
"permissions": {
"firm:read": [
"firm"
],
"network:read": [
"network:uuid"
]
}
},
"assigned_administrator": {
"uuid": "09271b9d-7714-43c8-9ba5-23b37ff3621e",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "client",
"role": "client",
"first_name": "Gareth",
"last_name": "Thompson",
"name": "Gareth Thompson",
"email": "gareth@codepotato.co.uk",
"photo_url": "https://eu.ui-avatars.com/api/?name=gareth+thompson",
"first_contact_date": "2026-09-18T09:00:17+01:00",
"next_review_date": "2026-09-18T09:00:17+01:00",
"previous_review_date": "2026-09-18T09:00:17+01:00",
"anniversary_review_date": "2026-09-18T09:00:17+01:00",
"terms_of_business_at": "2026-09-18T09:00:17+01:00",
"client_agreement_at": "2026-09-18T09:00:17+01:00",
"with_login": true,
"has_joint_account": true,
"can_be_deleted": "false",
"ownership_percentage": 100.0,
"inactive_at": "2026-09-18",
"last_interaction_at": "2026-09-18 09:00:17",
"referral_code": "ABC12345",
"is_out_of_office": true,
"out_of_office_from": "2026-09-18T09:00:17+01:00",
"out_of_office_until": "2026-09-18T09:00:17+01:00",
"out_of_office_message": "I am away this week. For urgent matters please contact the office.",
"is_pending_fact_find_account": false,
"permissions": {
"firm:read": [
"firm"
],
"network:read": [
"network:uuid"
]
}
},
"assigned_paraplanner": {
"uuid": "09271b9d-7714-43c8-9ba5-23b37ff3621e",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "client",
"role": "client",
"first_name": "Gareth",
"last_name": "Thompson",
"name": "Gareth Thompson",
"email": "gareth@codepotato.co.uk",
"photo_url": "https://eu.ui-avatars.com/api/?name=gareth+thompson",
"first_contact_date": "2026-09-18T09:00:17+01:00",
"next_review_date": "2026-09-18T09:00:17+01:00",
"previous_review_date": "2026-09-18T09:00:17+01:00",
"anniversary_review_date": "2026-09-18T09:00:17+01:00",
"terms_of_business_at": "2026-09-18T09:00:17+01:00",
"client_agreement_at": "2026-09-18T09:00:17+01:00",
"with_login": true,
"has_joint_account": true,
"can_be_deleted": "false",
"ownership_percentage": 100.0,
"inactive_at": "2026-09-18",
"last_interaction_at": "2026-09-18 09:00:17",
"referral_code": "ABC12345",
"is_out_of_office": true,
"out_of_office_from": "2026-09-18T09:00:17+01:00",
"out_of_office_until": "2026-09-18T09:00:17+01:00",
"out_of_office_message": "I am away this week. For urgent matters please contact the office.",
"is_pending_fact_find_account": false,
"permissions": {
"firm:read": [
"firm"
],
"network:read": [
"network:uuid"
]
}
},
"introduced_by": {
"uuid": "09271b9d-7714-43c8-9ba5-23b37ff3621e",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "client",
"role": "client",
"first_name": "Gareth",
"last_name": "Thompson",
"name": "Gareth Thompson",
"email": "gareth@codepotato.co.uk",
"photo_url": "https://eu.ui-avatars.com/api/?name=gareth+thompson",
"first_contact_date": "2026-09-18T09:00:17+01:00",
"next_review_date": "2026-09-18T09:00:17+01:00",
"previous_review_date": "2026-09-18T09:00:17+01:00",
"anniversary_review_date": "2026-09-18T09:00:17+01:00",
"terms_of_business_at": "2026-09-18T09:00:17+01:00",
"client_agreement_at": "2026-09-18T09:00:17+01:00",
"with_login": true,
"has_joint_account": true,
"can_be_deleted": "false",
"ownership_percentage": 100.0,
"inactive_at": "2026-09-18",
"last_interaction_at": "2026-09-18 09:00:17",
"referral_code": "ABC12345",
"is_out_of_office": true,
"out_of_office_from": "2026-09-18T09:00:17+01:00",
"out_of_office_until": "2026-09-18T09:00:17+01:00",
"out_of_office_message": "I am away this week. For urgent matters please contact the office.",
"is_pending_fact_find_account": false,
"permissions": {
"firm:read": [
"firm"
],
"network:read": [
"network:uuid"
]
}
},
"business_unit": {
"uuid": "c0be5960-bb59-4ecb-b792-1959e2caefef",
"name": "Wealth Management",
"has_alternative_branding": false,
"brand_colours": [],
"members_count": 3,
"groups_count": 2,
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00"
},
"groups": {
"uuid": null,
"name": "finance",
"slug": "finance",
"participants_count": "3",
"participants": {
"uuid": {
"example": null,
"description": "UUID of the account"
},
"role": {
"example": "client",
"description": "Role of the account"
},
"first_name": {
"example": "Gareth",
"description": "First name of the account"
},
"last_name": {
"example": "Thompson",
"description": "Last name of the account"
},
"name": {
"example": "Gareth Thompson",
"description": "Name of the account"
},
"email": {
"example": "gareth@codepotato.co.uk",
"description": "Email of the account"
}
},
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00"
},
"tags": {
"uuid": "5c9d9f6f-4a9f-401f-8b2a-88fbcfd03b35",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"name": "Mortgage",
"slug": "mortgage",
"colour": "#ef4582"
},
"owners": {
"uuid": "09271b9d-7714-43c8-9ba5-23b37ff3621e",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "client",
"role": "client",
"first_name": "Gareth",
"last_name": "Thompson",
"name": "Gareth Thompson",
"email": "gareth@codepotato.co.uk",
"photo_url": "https://eu.ui-avatars.com/api/?name=gareth+thompson",
"first_contact_date": "2026-09-18T09:00:17+01:00",
"next_review_date": "2026-09-18T09:00:17+01:00",
"previous_review_date": "2026-09-18T09:00:17+01:00",
"anniversary_review_date": "2026-09-18T09:00:17+01:00",
"terms_of_business_at": "2026-09-18T09:00:17+01:00",
"client_agreement_at": "2026-09-18T09:00:17+01:00",
"with_login": true,
"has_joint_account": true,
"can_be_deleted": "false",
"ownership_percentage": 100.0,
"inactive_at": "2026-09-18",
"last_interaction_at": "2026-09-18 09:00:17",
"referral_code": "ABC12345",
"is_out_of_office": true,
"out_of_office_from": "2026-09-18T09:00:17+01:00",
"out_of_office_until": "2026-09-18T09:00:17+01:00",
"out_of_office_message": "I am away this week. For urgent matters please contact the office.",
"is_pending_fact_find_account": false,
"permissions": {
"firm:read": [
"firm"
],
"network:read": [
"network:uuid"
]
}
},
"first_contact_date": "2026-09-18T09:00:12+01:00",
"next_review_date": "2026-09-18T09:00:12+01:00",
"previous_review_date": "2026-09-18T09:00:12+01:00",
"anniversary_review_date": "2026-09-18T09:00:12+01:00",
"terms_of_business_at": "2026-09-18T09:00:12+01:00",
"client_agreement_at": "2026-09-18T09:00:12+01:00",
"with_login": true,
"has_joint_account": true,
"can_be_deleted": "false",
"joint_account_circle": {
"uuid": "04a62953-273c-4172-8a05-9c5107079ce2",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"name": "Jones Family",
"photo_url": "https://eu.ui-avatars.com/api/?name=jones+family",
"bg_colour": "#35f4e1",
"has_portal_access": true,
"portal_access_status": "active",
"engagement_rating": "green",
"last_login": {
"logged_in_at": "2026-09-18T09:00:17+01:00",
"account_uuid": "uuid",
"account_name": "John Smith",
"device_type": "desktop",
"device_platform": "macos"
},
"portal_login_count_30d": 5,
"portal_login_count_90d": 12,
"portal_login_count_365d": 48,
"joint_account_uuid": "23924f8c-7517-478c-9add-efdf6c24713b",
"login_access_level": "write",
"current_life_stage_uuid": "ae1b3158-4813-4f41-931f-fea50edd1308"
},
"circles": {
"uuid": "04a62953-273c-4172-8a05-9c5107079ce2",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"name": "Jones Family",
"photo_url": "https://eu.ui-avatars.com/api/?name=jones+family",
"bg_colour": "#35f4e1",
"has_portal_access": true,
"portal_access_status": "active",
"engagement_rating": "green",
"last_login": {
"logged_in_at": "2026-09-18T09:00:17+01:00",
"account_uuid": "uuid",
"account_name": "John Smith",
"device_type": "desktop",
"device_platform": "macos"
},
"portal_login_count_30d": 5,
"portal_login_count_90d": 12,
"portal_login_count_365d": 48,
"joint_account_uuid": "23924f8c-7517-478c-9add-efdf6c24713b",
"login_access_level": "write",
"current_life_stage_uuid": "ae1b3158-4813-4f41-931f-fea50edd1308"
},
"ownership_percentage": 100,
"inactive_at": "2026-09-18",
"last_interaction_at": "2026-09-18 09:00:12",
"referral_code": "ABC12345",
"is_out_of_office": true,
"out_of_office_from": "2026-09-18T09:00:12+01:00",
"out_of_office_until": "2026-09-18T09:00:12+01:00",
"out_of_office_message": "I am away this week. For urgent matters please contact the office.",
"service_level": {
"uuid": "1b0ee373-e273-439f-b8c4-a93256fa5789",
"name": "Gold",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00"
},
"is_pending_fact_find_account": false,
"permissions": {
"firm:read": [
"firm"
],
"network:read": [
"network:uuid"
]
},
"custom_fields": {
"uuid": null,
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "string",
"name": "Favourite Drink",
"reference": "favourite_drink",
"is_required": false,
"value": "Coffee",
"selection_options": [
"Coffee",
"Tea",
"Water"
],
"help_text": "This is the client's favourite drink."
},
"external_references": {
"uuid": "d9429bc7-4ef5-4ba4-969c-eaae44f3b95f",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"third_party": "nucleus",
"reference": "AB123456"
}
},
"firm": {
"uuid": "848f6b3b-21d9-47b9-ba1d-3cbccd7a2180",
"created_at": "2026-09-18T09:00:12+01:00",
"updated_at": "2026-09-18T09:00:12+01:00",
"name": "Codepotato",
"slug": "codepotato",
"address_1": "Suite E, 5 The Briars",
"address_2": "Waterberry Drive",
"town_city": "Waterlooville",
"county": "Hampshire",
"postcode": "PO7 7YH",
"country": "United Kingdom",
"regulatory_text": "Regulatory text",
"logo": "https://api.plannrcrm.com/images/plannr.jpg",
"logo_icon": "https://api.plannrcrm.com/images/plannr-icon.jpg",
"brand_colours": {
"sidebar_background": "#0E0E56",
"sidebar_accent": "#36367E",
"sidebar_text": "#FFFFFF",
"sidebar_hover": "#0A0A42",
"sidebar_active": "#53DBB8",
"sidebar_title_background": "#36367E",
"sidebar_title_primary": "#FFC634",
"sidebar_title_secondary": "#FFFFFF",
"sidebar_title_secondary_hover": "#FFFFFF",
"email_background": "#0E0E56",
"email_logo_background_panel": "#36367E",
"email_sub_text": "#FFFFFF",
"email_button_background": "#36367E",
"email_button_text": "#FFFFFF",
"portal_sidebar_button_background": "#F6F6F6",
"portal_sidebar_button_hover": "#FFFFFF",
"portal_sidebar_button_active": "#FFFFFF",
"portal_brand_title": "#323B4B",
"portal_brand_sub_title": "#828994",
"portal_sidebar_title": "#11151D",
"portal_sidebar_text": "#323B4B",
"portal_sidebar_text_hover": "#323B4B",
"portal_sidebar_text_active": "#323B4B",
"portal_sidebar_icon": "#828994",
"portal_sidebar_icon_hover": "#828994",
"portal_sidebar_icon_active": "#828994",
"portal_background": "#F6F6F6",
"portal_sidebar_account_title": "#11151D",
"portal_sidebar_account_email": "#828994",
"portal_sidebar_divider": "#E3E5E9",
"portal_dashboard_bg_one": "#EF4583",
"portal_dashboard_bg_two": "#FFC634",
"portal_sidebar_collapse_button": "#828994",
"portal_sidebar_collapse_button_hover": "#B3B9C4",
"portal_sidebar_user_select_background": "#F6F6F6",
"portal_sidebar_user_select_hover": "#F6F6F6",
"portal_sidebar_user_select_text": "#323B4B",
"portal_sidebar_user_select_text_hover": "#323B4B",
"portal_sidebar_user_select_border": "#EEEEEE",
"portal_sidebar_user_select_border_hover": "#828994"
},
"factfind_pdf_header_background": "#0E0E56",
"factfind_pdf_header_text": "#ffffff",
"factfind_pdf_logo": "https://api.plannrcrm.com/images/plannr.jpg",
"is_subscribed": true,
"addon_subscriptions": {
"uuid": "d95df3a3-b6a9-449a-97d4-8f8c24ef4de1",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"enabled": "true",
"trial_ends_at": "2026-10-02",
"trial_ends_in_days": 14,
"payment_confirmed_at": "2026-10-06"
},
"keep_deleted_files_for": 30,
"tax": 17.5,
"month_end": 25,
"statement_frequency": "monthly",
"billing": {
"invoice_address_1": "Suite E, 5 The Briars",
"invoice_address_2": "Waterberry Drive",
"invoice_town_city": "Waterlooville",
"invoice_county": "Hampshire",
"invoice_postcode": "PO7 7YH",
"invoice_country": "United Kingdom",
"invoice_email": "gareth@codepotato.co.uk"
},
"task_board_template": {
"uuid": null,
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"is_template": false,
"name": "Task Board",
"default_list_uuid": null,
"is_editable": true,
"priorities": [
{
"name": "High",
"value": "high"
},
{
"name": "Low",
"value": "low"
}
]
},
"ip_whitelist": [
"192.168.0.1",
"127.0.0.1"
],
"welcome_paragraph_html": "<h1>Welcome.</h1>",
"email_welcome_paragraph_html": "Welcome to Plannr!",
"show_fact_find_illustrations": true,
"cc_email_addresses": [
"jack@example.com",
"jill@example.com"
],
"bcc_email_addresses": [
"jack@example.com",
"jill@example.com"
],
"reply_to_email_address": "jack@example.com",
"mobile_app_support_number": "01234 567890",
"mobile_app_support_email": "support@example.com"
},
"reconciliation": {
"bank_transaction_reconciliation_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": "GBP",
"description": "Currency of the money"
}
},
"bank_transaction_reconciliation_percentage": 100,
"is_fully_reconciled_with_bank_transactions": true,
"expectation_reconciliation_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": "GBP",
"description": "Currency of the money"
}
},
"expectation_reconciliation_percentage": 50,
"is_reconciled_with_expectation": false,
"is_fully_reconciled_with_expectations": false
},
"bank_transaction_reconciliations": {
"uuid": "2b4f46f2-ee1b-428d-b47d-99f5697701b8",
"created_at": "2026-09-18T09:00:12+01:00",
"updated_at": "2026-09-18T09:00:12+01:00",
"amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": "GBP",
"description": "Currency of the money"
}
},
"statement_transaction": {
"uuid": "79e42049-bf16-4a95-a062-3bec276f7154",
"created_at": "2026-09-18T09:00:18+01:00",
"updated_at": "2026-09-18T09:00:18+01:00",
"client_name": "Gareth Thompson",
"transaction_reference": "4u5Xa2EhOO",
"policy_number": "AVIVA_00001",
"date": "2026-09-18",
"gross_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
},
"net_amount": {
"amount": {
"example": "4000",
"description": "Money amount at their lowest denominator (for example: pennies)"
},
"formatted": {
"example": "£40.00",
"description": "Money amount formatted with currency"
},
"currency": {
"example": null,
"description": "Currency of the money"
}
},
"category": "initial_fee",
"payment_origin": "provider",
"agency_number": "Agency number",
"product_reference": "Product reference",
"adviser_name": "Adviser name",
"sender_id_sib_number": "Sender id sib number",
"reason": "Reason",
"auto_reconciliation_message": "No plans matching policy number AVIVA_00001.",
"scheme_name": "Scheme name",
"scheme_number": "Scheme number",
"customer_number": "Customer number",
"policy_market_value": "Policy market value",
"provider": "Aviva",
"metadata": {
"client_name": "Gareth Thompson"
}
},
"bank_transaction": {
"uuid": "f9d3f957-3acd-4ac0-8a02-6c5f95463b63",
"created_at": "2026-09-18T09:00:18+01:00",
"updated_at": "2026-09-18T09:00:18+01:00",
"date": "2022-07-15",
"amount": null,
"reference": "VitalityLtd",
"metadata": {
"client_name": "Gareth Thompson"
},
"filename": "Natwest June 2022 Statement.xlsx"
},
"account": {
"uuid": "09271b9d-7714-43c8-9ba5-23b37ff3621e",
"created_at": "2026-09-18T09:00:17+01:00",
"updated_at": "2026-09-18T09:00:17+01:00",
"type": "client",
"role": "client",
"first_name": "Gareth",
"last_name": "Thompson",
"name": "Gareth Thompson",
"email": "gareth@codepotato.co.uk",
"photo_url": "https://eu.ui-avatars.com/api/?name=gareth+thompson",
"first_contact_date": "2026-09-18T09:00:17+01:00",
"next_review_date": "2026-09-18T09:00:17+01:00",
"previous_review_date": "2026-09-18T09:00:17+01:00",
"anniversary_review_date": "2026-09-18T09:00:17+01:00",
"terms_of_business_at": "2026-09-18T09:00:17+01:00",
"client_agreement_at": "2026-09-18T09:00:17+01:00",
"with_login": true,
"has_joint_account": true,
"can_be_deleted": "false",
"ownership_percentage": 100.0,
"inactive_at": "2026-09-18",
"last_interaction_at": "2026-09-18 09:00:17",
"referral_code": "ABC12345",
"is_out_of_office": true,
"out_of_office_from": "2026-09-18T09:00:17+01:00",
"out_of_office_until": "2026-09-18T09:00:17+01:00",
"out_of_office_message": "I am away this week. For urgent matters please contact the office.",
"is_pending_fact_find_account": false,
"permissions": {
"firm:read": [
"firm"
],
"network:read": [
"network:uuid"
]
}
}
}
}
{
"message": "The given data was invalid.",
"errors": {
"field": [
"The field is invalid."
]
}
}