---
updatedAt: 2026-06-16T16:11:03.000Z
agentTools:
  projectIndex: https://docs.sikoia.com/llms.txt
---

# Generate Affordability Insights

# Get Started

Before requesting affordability insights, create a case and share bank transaction data either by uploading bank statements and / or by creating an open banking connection.

## Create a Case

Create a `case` using the [create case](https://docs.sikoia.com/reference/post_v2-cases) endpoint. A `case` can optionally contain `companies` and/or `people`. You can share bank transaction data and request Affordability Insights at the `case`, `person` or `company` level.

* For unique insights for individual applicants within a case, add each person as a `person` entity, upload relevant documents, create open banking connections, and request insights per `person`.
* For joint applications, add all necessary documents or connections to the `case` and request insights for the entire `case`.

> ℹ️
>
> If joint bank accounts or statements are being used, upload transaction data and request Affordability Insights at the `case` level.

## Upload Bank Statements

Upload bank statements using the [upload document](https://docs.sikoia.com/reference/post_v2-documents) endpoint.  Ensure the `entity_id` and `entity_type` are specified in the request.  For accurate insights, upload at least three months of statements.

*Learn about the criteria bank statements must meet and explore the list of supported banks and institutions[here](https://docs.sikoia.com/docs/supported-bank-statements).*

When a bank statement has been uploaded and we have attempted to extract the data from it we will try to send a `BankStatementProcessing.Completed` webhook if one has been [configured in our API](https://docs.sikoia.com/reference/post_v2-webhooks). For full details, please see the [Bank Statement Processing Completed Webhook](https://docs.sikoia.com/docs/webhooks#example-bankstatementprocessingcompleted-event) section.

## Create an Open Banking Connection

As an alternative to uploading bank statements, connect a bank account for a UK bank using open banking by utilising  the relevant [open banking connection endpoint](https://docs.sikoia.com/reference/post_v2-openbanking).

You can find more information on the types of connected accounts that can be used to generate an affordability insights [here](https://docs.sikoia.com/docs/supported-banks-accounts).

When an open banking connection has been completed we will try to send a `OpenBankingProcessing.Completed` webhook if one has been [configured in our API](https://docs.sikoia.com/reference/post_v2-webhooks). For full details, please see the [Open Banking Processing Completed Webhook](https://docs.sikoia.com/docs/webhooks#example-openbankingprocessingcompleted-event) section.

## Review Data Sources

If you're not using webhooks or if you want to view all the data sources which have been provided for a given entity, you can also verify the processing status for all documents and open banking connections using our [data sources](https://docs.sikoia.com/reference/get_v2-entity_type-entity_id-insight-data-sources) endpoint.

*Learn more about data sources[here](https://docs.sikoia.com/docs/data-sources-1).*

Before requesting Affordability Insights, ensure the status is `Complete` for all data sources you wish to use.  Data Sources with a `Provided`, `Failed`, or `Pending` statuses cannot be used to generate affordability insights.

# Generate Affordability Insight Request

Once you've created a case and successfully uploaded the relevant documents or created the relevant open banking connections, you can request affordability insights.

Use the POST [Affordability Insights](https://docs.sikoia.com/reference/post_v2-affordability-insights) endpoint to initiate the affordability insights request for the specific entity.

```json Example response
{
  "request_id": "a5f84a41-01cf-4d21-901d-124c5a7c743a",
  "status": "Pending",
  "entity_id": "7885857d-fa2b-43ab-8b15-67e5fea8e896",
  "entity_type": "case",
  "datetime_requested": "2023-11-24T12:38:45.711Z",
  "message": "Affordability insights pending"
}
```

Record the `request_id` from the response as it will be required to check the status.

## Check the Status of the Request

If you have configured any [webhooks](https://docs.sikoia.com/docs/webhooks#example-bankstatementprocessingcompleted-event) that reference the [AffordabilityInsights.Completed event](https://docs.sikoia.com/docs/webhooks#example-affordabilityinsightscompleted-event) you will receive a request of this event type as soon as the affordability insights process has completed.  Check out our [webhooks guide](https://docs.sikoia.com/docs/webhooks) for more information on how to set up and configure webhooks.

Alternatively, you can monitor the status by polling the GET [Affordability Insights](https://docs.sikoia.com/reference/get_v2-affordability-insights-request_id) endpoint. Specify the `request_id` for the relevant entity in the request.  Wait for a `Complete` status to be achieved before retrieving the Affordability Insights.

```json Example response
{
  "request_id": "a5f84a41-01cf-4d21-901d-124c5a7c743a",
  "status": "Pending",
  "entity_id": "7885857d-fa2b-43ab-8b15-67e5fea8e896",
  "entity_type": "case",
  "datetime_requested": "2023-11-24T12:38:45.711Z",
  "message": "Affordability insights pending"

```

# Retrieve Affordability Insights

Once you've requested affordability insights and the status of your request is complete, you can retrieve the results. Sikoia provides three levels of Affordability Insights:

1. Overview
2. Monthly Summary
3. Detailed Transaction Breakdown

This flexibility allows you to choose the level of granularity that best fits your integration needs.

## 1. Retrieve the Overview

This overview provides the cashflow summary and indicators. The cashflow summary shows typical monthly income, essential expenditure, and non-essential expenditure, broken down by category and sub-categories. Indicators highlight transactions that meet specific criteria such as transactions pertaining to gambling, childcare and insurance.

Use the GET [Affordability Insights](https://docs.sikoia.com/reference/get_v2-affordability-insights-request_id) endpoint and ensure the relevant `request_id` is specified in the URL.

```json Example response
{
   "request_id":"1e2b8dec-b8f3-40b6-aef7-a5c85b77e7d7",
   "status":"Complete",
   "entity_id":"c7fcf490-2a2f-4391-9538-17db90e0e956",
   "entity_type":"case",
   "datetime_requested":"2025-02-24T11:21:49.293Z",
   "datetime_completed":"2025-02-24T11:22:48.722Z",
   "message":null,
   "data":{
      "cashflow":[
         {
            "group":"Income",
            "value":2823.58,
            "categories":[
               {
                  "name":"Employment and/or Self-employment",
                  "value":2672.18,
                  "subcategories":[
                     
                  ]
               },
               {
                  "name":"Benefits",
                  "value":151.4,
                  "subcategories":[
                     {
                        "name":"Child benefit",
                        "value":151.4
                     }
                  ]
               }
            ]
         },
         {
            "group":"Essential expenditure",
            "value":-2173.35,
            "categories":[
               {
                  "name":"Groceries and shopping",
                  "value":-409.17,
                  "subcategories":[
                     
                  ]
               },
               {
                  "name":"Credit cards and loans",
                  "value":-390.83,
                  "subcategories":[
                     
                  ]
               },
               {
                  "name":"Transportation and travel",
                  "value":-397.54,
                  "subcategories":[
                     {
                        "name":"Other",
                        "value":-275.64
                     },
                     {
                        "name":"Fuel",
                        "value":-121.9
                     }
                  ]
               },
               {
                  "name":"Insurance premiums",
                  "value":-88.11,
                  "subcategories":[
                     
                  ]
               },
               {
                  "name":"Mortgage and rent",
                  "value":-560.4,
                  "subcategories":[
                     
                  ]
               },
               {
                  "name":"Cash withdrawal",
                  "value":-126.67,
                  "subcategories":[
                     
                  ]
               },
               {
                  "name":"Tax",
                  "value":-135,
                  "subcategories":[
                     {
                        "name":"Council tax",
                        "value":-135
                     }
                  ]
               },
               {
                  "name":"Utilities",
                  "value":-65.63,
                  "subcategories":[
                     {
                        "name":"Energy",
                        "value":-65.63
                     }
                  ]
               }
            ]
         },
         {
            "group":"Non-essential expenditure",
            "value":-577.08,
            "categories":[
               {
                  "name":"Gambling",
                  "value":-66.67,
                  "subcategories":[
                     
                  ]
               },
               {
                  "name":"Entertainment",
                  "value":-290.46,
                  "subcategories":[
                     {
                        "name":"Dining out and takeaways",
                        "value":-290.46
                     }
                  ]
               },
               {
                  "name":"TV and subscriptions",
                  "value":-43.74,
                  "subcategories":[
                     
                  ]
               },
               {
                  "name":"Shopping",
                  "value":-176.21,
                  "subcategories":[
                     
                  ]
               }
            ]
         },
         {
            "group":"Other",
            "value":35.96,
            "categories":[
               {
                  "name":"Other inflows",
                  "value":35.96,
                  "subcategories":[
                     
                  ]
               }
            ]
         }
      ],
      "indicators":[
         {
            "name":"Gambling",
            "present":true,
            "transactions":[
               {
                  "transaction_id":"41e3caa2-1f43-635d-7eaf-e255c41d999f",
                  "account_connection_id":"e54aaff4-3746-4e49-a017-44f79c9d0adc",
                  "date":"2023-11-04",
                  "group":"Non-essential expenditure",
                  "category":"Gambling",
                  "subcategory":null,
                  "short_description":"Stoke",
                  "long_description":"BET365 , STOKE GB",
                  "amount":-10,
                  "normalised_amount":-3.33
               }
            ]
         },
         {
            "name":"Benefits",
            "present":true,
            "transactions":[
               {
                  "transaction_id":"953fc456-0700-5c01-7f4d-8f3689a119c8",
                  "account_connection_id":"e54aaff4-3746-4e49-a017-44f79c9d0adc",
                  "date":"2023-10-17",
                  "group":"Income",
                  "category":"Benefits",
                  "subcategory":"Child benefit",
                  "short_description":"Hmrc Child Benefit",
                  "long_description":"HMRC CHILD BENEFIT",
                  "amount":139.75,
                  "normalised_amount":50.47
               }
            ]
         },
         {
            "name":"Children",
            "present":true,
            "transactions":[
               {
                  "transaction_id":"953fc456-0700-5c01-7f4d-8f3689a119c8",
                  "account_connection_id":"e54aaff4-3746-4e49-a017-44f79c9d0adc",
                  "date":"2023-10-17",
                  "group":"Income",
                  "category":"Benefits",
                  "subcategory":"Child benefit",
                  "short_description":"Hmrc Child Benefit",
                  "long_description":"HMRC CHILD BENEFIT",
                  "amount":139.75,
                  "normalised_amount":50.47
               }
            ]
         },
         {
            "name":"High value transactions",
            "present":false,
            "transactions":[
               
            ]
         },
         {
            "name":"Insurance",
            "present":true,
            "transactions":[
               {
                  "transaction_id":"616a4758-c93c-1960-82a3-1ecf6c841db1",
                  "account_connection_id":"e54aaff4-3746-4e49-a017-44f79c9d0adc",
                  "date":"2023-10-12",
                  "group":"Essential expenditure",
                  "category":"Insurance premiums",
                  "subcategory":null,
                  "short_description":"Aviva Life",
                  "long_description":"Aviva Life",
                  "amount":-12.53,
                  "normalised_amount":-4.18
               }
            ]
         },
         {
            "name":"Loans (excluding credit cards)",
            "present":true,
            "transactions":[
               {
                  "transaction_id":"ed08ba4e-4258-b73b-3617-fd686220b91c",
                  "account_connection_id":"e54aaff4-3746-4e49-a017-44f79c9d0adc",
                  "date":"2023-10-22",
                  "group":"Essential expenditure",
                  "category":"Credit cards and loans",
                  "subcategory":null,
                  "short_description":"Hsbc PLC Loans",
                  "long_description":"HSBC PLC LOANS",
                  "amount":-200.21,
                  "normalised_amount":-66.74
               }
            ]
         }
      ],
      "data_sources":[
         {
            "source_id":"e53b7b7a-1fe0-4e0d-8da1-320ab4e67146",
            "source_name":"Sample data A - monthly pay - bank statement 1 of 3 - Sam Weetabix.pdf",
            "source_category_type":"Document",
            "source_type":"BankStatement"
         },
         {
            "source_id":"076c4af0-4860-4942-8027-e9fb3aa0ff4e",
            "source_name":"Sample data A - monthly pay - bank statement 2 of 3 - Sam Weetabix.pdf",
            "source_category_type":"Document",
            "source_type":"BankStatement"
         },
         {
            "source_id":"0da4c03d-862b-4799-bfb2-e31b05d7c29d",
            "source_name":"Sample data A - monthly pay - bank statement 3 of 3 - Sam Weetabix.pdf",
            "source_category_type":"Document",
            "source_type":"BankStatement"
         }
      ]
   }
}
```

For a full list of potential groups, categories, and indicators click [here](https://docs.sikoia.com/docs/groups-categories-indicators).

## 2. Retrieve the Monthly Summary

The monthly summary view provides a comprehensive breakdown of categorised transactions, providing granular view of monthly, aggregate and average spend by merchant, grouped by category.

Use the GET [Affordability Insights](https://docs.sikoia.com/reference/get_v2-affordability-insights-request_id-transactions) endpoint and ensure the relevant `request_id` is specified in the URL.

```json Example response
{
   "request_id":"1e2b8dec-b8f3-40b6-aef7-a5c85b77e7d7",
   "status":"Complete",
   "entity_id":"c7fcf490-2a2f-4391-9538-17db90e0e956",
   "entity_type":"case",
   "datetime_requested":"2025-02-24T11:21:49.293Z",
   "datetime_completed":"2025-02-24T11:22:48.722Z",
   "message":null,
   "data":[
      {
         "group":"Income",
         "category":"Employment and/or Self-employment",
         "subcategory":null,
         "short_description":"Salary SAM Weetabix CEREALS-R-US",
         "number_of_transactions":3,
         "total_value":8016.54,
         "average_value":2672.18,
         "minimum_value":2449.04,
         "maximum_value":2865.04,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":2865.04
            },
            {
               "year":2023,
               "month":11,
               "total_value":2702.46
            },
            {
               "year":2023,
               "month":12,
               "total_value":2449.04
            }
         ]
      },
      {
         "group":"Non-essential expenditure",
         "category":"TV and subscriptions",
         "subcategory":null,
         "short_description":"BT Group PLC",
         "number_of_transactions":3,
         "total_value":-98.31,
         "average_value":-32.77,
         "minimum_value":-32.77,
         "maximum_value":-32.77,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-32.77
            },
            {
               "year":2023,
               "month":11,
               "total_value":-32.77
            },
            {
               "year":2023,
               "month":12,
               "total_value":-32.77
            }
         ]
      },
      {
         "group":"Non-essential expenditure",
         "category":"Gambling",
         "subcategory":null,
         "short_description":"Stoke",
         "number_of_transactions":13,
         "total_value":-200,
         "average_value":-15.38,
         "minimum_value":-20,
         "maximum_value":-10,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-50
            },
            {
               "year":2023,
               "month":11,
               "total_value":-60
            },
            {
               "year":2023,
               "month":12,
               "total_value":-70
            },
            {
               "year":2024,
               "month":1,
               "total_value":-20
            }
         ]
      },
      {
         "group":"Non-essential expenditure",
         "category":"Entertainment",
         "subcategory":"Dining out and takeaways",
         "short_description":"Just EAT (via Apple Pay)",
         "number_of_transactions":13,
         "total_value":-402.47,
         "average_value":-30.96,
         "minimum_value":-36.13,
         "maximum_value":-21.21,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-86.72
            },
            {
               "year":2023,
               "month":11,
               "total_value":-166.55
            },
            {
               "year":2023,
               "month":12,
               "total_value":-119.42
            },
            {
               "year":2024,
               "month":1,
               "total_value":-29.78
            }
         ]
      },
      {
         "group":"Essential expenditure",
         "category":"Groceries and shopping",
         "subcategory":null,
         "short_description":"Tesco Store Hook",
         "number_of_transactions":52,
         "total_value":-1227.66,
         "average_value":-23.61,
         "minimum_value":-49.42,
         "maximum_value":-3.02,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-275.29
            },
            {
               "year":2023,
               "month":11,
               "total_value":-370.17
            },
            {
               "year":2023,
               "month":12,
               "total_value":-423.24
            },
            {
               "year":2024,
               "month":1,
               "total_value":-158.96
            }
         ]
      },
      {
         "group":"Essential expenditure",
         "category":"Credit cards and loans",
         "subcategory":null,
         "short_description":"Hsbc PLC Loans",
         "number_of_transactions":3,
         "total_value":-600.63,
         "average_value":-200.21,
         "minimum_value":-200.21,
         "maximum_value":-200.21,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-200.21
            },
            {
               "year":2023,
               "month":11,
               "total_value":-200.21
            },
            {
               "year":2023,
               "month":12,
               "total_value":-200.21
            }
         ]
      },
      {
         "group":"Essential expenditure",
         "category":"Transportation and travel",
         "subcategory":"Other",
         "short_description":"Vwfs UK Limited",
         "number_of_transactions":3,
         "total_value":-826.92,
         "average_value":-275.64,
         "minimum_value":-275.64,
         "maximum_value":-275.64,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-275.64
            },
            {
               "year":2023,
               "month":11,
               "total_value":-275.64
            },
            {
               "year":2023,
               "month":12,
               "total_value":-275.64
            }
         ]
      },
      {
         "group":"Non-essential expenditure",
         "category":"Entertainment",
         "subcategory":"Dining out and takeaways",
         "short_description":"Pret a Manger London",
         "number_of_transactions":53,
         "total_value":-251.3,
         "average_value":-4.74,
         "minimum_value":-6.9,
         "maximum_value":-2.5,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-61.1
            },
            {
               "year":2023,
               "month":11,
               "total_value":-84.6
            },
            {
               "year":2023,
               "month":12,
               "total_value":-77.4
            },
            {
               "year":2024,
               "month":1,
               "total_value":-28.2
            }
         ]
      },
      {
         "group":"Non-essential expenditure",
         "category":"Entertainment",
         "subcategory":"Dining out and takeaways",
         "short_description":"Five Guys Gloucest",
         "number_of_transactions":13,
         "total_value":-217.5,
         "average_value":-16.73,
         "minimum_value":-20.6,
         "maximum_value":-12.9,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-50.2
            },
            {
               "year":2023,
               "month":11,
               "total_value":-66.9
            },
            {
               "year":2023,
               "month":12,
               "total_value":-83.7
            },
            {
               "year":2024,
               "month":1,
               "total_value":-16.7
            }
         ]
      },
      {
         "group":"Essential expenditure",
         "category":"Insurance premiums",
         "subcategory":null,
         "short_description":"AXA Insurance",
         "number_of_transactions":3,
         "total_value":-114.18,
         "average_value":-38.06,
         "minimum_value":-38.06,
         "maximum_value":-38.06,
         "monthly_data":[
            {
               "year":2023,
               "month":11,
               "total_value":-38.06
            },
            {
               "year":2023,
               "month":12,
               "total_value":-38.06
            },
            {
               "year":2024,
               "month":1,
               "total_value":-38.06
            }
         ]
      },
      {
         "group":"Non-essential expenditure",
         "category":"TV and subscriptions",
         "subcategory":null,
         "short_description":"netflix.com",
         "number_of_transactions":3,
         "total_value":-32.97,
         "average_value":-10.99,
         "minimum_value":-10.99,
         "maximum_value":-10.99,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-10.99
            },
            {
               "year":2023,
               "month":11,
               "total_value":-10.99
            },
            {
               "year":2023,
               "month":12,
               "total_value":-10.99
            }
         ]
      },
      {
         "group":"Essential expenditure",
         "category":"Mortgage and rent",
         "subcategory":null,
         "short_description":"Nottingham BS Mtge",
         "number_of_transactions":3,
         "total_value":-1681.2,
         "average_value":-560.4,
         "minimum_value":-560.4,
         "maximum_value":-560.4,
         "monthly_data":[
            {
               "year":2023,
               "month":11,
               "total_value":-560.4
            },
            {
               "year":2023,
               "month":12,
               "total_value":-560.4
            },
            {
               "year":2024,
               "month":1,
               "total_value":-560.4
            }
         ]
      },
      {
         "group":"Income",
         "category":"Benefits",
         "subcategory":"Child benefit",
         "short_description":"Hmrc Child Benefit",
         "number_of_transactions":3,
         "total_value":419.25,
         "average_value":139.75,
         "minimum_value":139.75,
         "maximum_value":139.75,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":139.75
            },
            {
               "year":2023,
               "month":11,
               "total_value":139.75
            },
            {
               "year":2023,
               "month":12,
               "total_value":139.75
            }
         ]
      },
      {
         "group":"Essential expenditure",
         "category":"Cash withdrawal",
         "subcategory":null,
         "short_description":"Cash Withdrawal at Barclays Asda Burgh HTH 2",
         "number_of_transactions":13,
         "total_value":-380,
         "average_value":-29.23,
         "minimum_value":-40,
         "maximum_value":-20,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-80
            },
            {
               "year":2023,
               "month":11,
               "total_value":-120
            },
            {
               "year":2023,
               "month":12,
               "total_value":-160
            },
            {
               "year":2024,
               "month":1,
               "total_value":-20
            }
         ]
      },
      {
         "group":"Non-essential expenditure",
         "category":"Shopping",
         "subcategory":null,
         "short_description":"H & M Hennes & Mauritz U London",
         "number_of_transactions":3,
         "total_value":-216.28,
         "average_value":-72.09,
         "minimum_value":-103.15,
         "maximum_value":-44.85,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-44.85
            },
            {
               "year":2023,
               "month":11,
               "total_value":-103.15
            },
            {
               "year":2023,
               "month":12,
               "total_value":-68.28
            }
         ]
      },
      {
         "group":"Essential expenditure",
         "category":"Tax",
         "subcategory":"Council tax",
         "short_description":"Sevenoaks D.c.",
         "number_of_transactions":3,
         "total_value":-405,
         "average_value":-135,
         "minimum_value":-135,
         "maximum_value":-135,
         "monthly_data":[
            {
               "year":2023,
               "month":11,
               "total_value":-135
            },
            {
               "year":2023,
               "month":12,
               "total_value":-135
            },
            {
               "year":2024,
               "month":1,
               "total_value":-135
            }
         ]
      },
      {
         "group":"Non-essential expenditure",
         "category":"Shopping",
         "subcategory":null,
         "short_description":"Amznmktplace",
         "number_of_transactions":3,
         "total_value":-312.34,
         "average_value":-104.11,
         "minimum_value":-172.2,
         "maximum_value":-68.33,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-68.33
            },
            {
               "year":2023,
               "month":11,
               "total_value":-71.81
            },
            {
               "year":2023,
               "month":12,
               "total_value":-172.2
            }
         ]
      },
      {
         "group":"Essential expenditure",
         "category":"Transportation and travel",
         "subcategory":"Fuel",
         "short_description":"BP Deer Park S/serve (via Apple Pay)",
         "number_of_transactions":13,
         "total_value":-365.69,
         "average_value":-28.13,
         "minimum_value":-39.75,
         "maximum_value":-15.48,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-67.9
            },
            {
               "year":2023,
               "month":11,
               "total_value":-156
            },
            {
               "year":2023,
               "month":12,
               "total_value":-122.94
            },
            {
               "year":2024,
               "month":1,
               "total_value":-18.85
            }
         ]
      },
      {
         "group":"Essential expenditure",
         "category":"Insurance premiums",
         "subcategory":null,
         "short_description":"Aviva Insurance",
         "number_of_transactions":3,
         "total_value":-112.47,
         "average_value":-37.49,
         "minimum_value":-37.49,
         "maximum_value":-37.49,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-37.49
            },
            {
               "year":2023,
               "month":11,
               "total_value":-37.49
            },
            {
               "year":2023,
               "month":12,
               "total_value":-37.49
            }
         ]
      },
      {
         "group":"Essential expenditure",
         "category":"Credit cards and loans",
         "subcategory":null,
         "short_description":"M & S Credit",
         "number_of_transactions":3,
         "total_value":-571.86,
         "average_value":-190.62,
         "minimum_value":-263.23,
         "maximum_value":-51.73,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-263.23
            },
            {
               "year":2023,
               "month":11,
               "total_value":-51.73
            },
            {
               "year":2023,
               "month":12,
               "total_value":-256.9
            }
         ]
      },
      {
         "group":"Essential expenditure",
         "category":"Utilities",
         "subcategory":"Energy",
         "short_description":"British Gas",
         "number_of_transactions":3,
         "total_value":-196.89,
         "average_value":-65.63,
         "minimum_value":-72.23,
         "maximum_value":-56.34,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-56.34
            },
            {
               "year":2023,
               "month":11,
               "total_value":-68.32
            },
            {
               "year":2023,
               "month":12,
               "total_value":-72.23
            }
         ]
      },
      {
         "group":"Other",
         "category":"Other inflows",
         "subcategory":null,
         "short_description":"Gross Interest",
         "number_of_transactions":3,
         "total_value":10.33,
         "average_value":3.44,
         "minimum_value":1.24,
         "maximum_value":4.67,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":4.67
            },
            {
               "year":2023,
               "month":11,
               "total_value":1.24
            },
            {
               "year":2023,
               "month":12,
               "total_value":4.42
            }
         ]
      },
      {
         "group":"Other",
         "category":"Other inflows",
         "subcategory":null,
         "short_description":"Amznmktplace Refund",
         "number_of_transactions":3,
         "total_value":97.55,
         "average_value":32.52,
         "minimum_value":23.34,
         "maximum_value":38.64,
         "monthly_data":[
            {
               "year":2023,
               "month":11,
               "total_value":23.34
            },
            {
               "year":2023,
               "month":12,
               "total_value":35.57
            },
            {
               "year":2024,
               "month":1,
               "total_value":38.64
            }
         ]
      },
      {
         "group":"Essential expenditure",
         "category":"Insurance premiums",
         "subcategory":null,
         "short_description":"Aviva Life",
         "number_of_transactions":3,
         "total_value":-37.59,
         "average_value":-12.53,
         "minimum_value":-12.53,
         "maximum_value":-12.53,
         "monthly_data":[
            {
               "year":2023,
               "month":10,
               "total_value":-12.53
            },
            {
               "year":2023,
               "month":11,
               "total_value":-12.53
            },
            {
               "year":2023,
               "month":12,
               "total_value":-12.53
            }
         ]
      }
   ],
   "data_sources":[
      {
         "source_id":"e53b7b7a-1fe0-4e0d-8da1-320ab4e67146",
         "source_name":"Sample data A - monthly pay - bank statement 1 of 3 - Sam Weetabix.pdf",
         "source_category_type":"Document",
         "source_type":"BankStatement"
      },
      {
         "source_id":"076c4af0-4860-4942-8027-e9fb3aa0ff4e",
         "source_name":"Sample data A - monthly pay - bank statement 2 of 3 - Sam Weetabix.pdf",
         "source_category_type":"Document",
         "source_type":"BankStatement"
      },
      {
         "source_id":"0da4c03d-862b-4799-bfb2-e31b05d7c29d",
         "source_name":"Sample data A - monthly pay - bank statement 3 of 3 - Sam Weetabix.pdf",
         "source_category_type":"Document",
         "source_type":"BankStatement"
      }
   ]
}
```

## 3. Retrieve the Detailed Transaction Breakdown

The detailed transaction breakdown view provides a comprehensive breakdown of each individual categorised transactions.

Use the GET [Affordability Insights](https://docs.sikoia.com/reference/get_v2-affordability-insights-request_id-transaction-details) endpoint and ensure the relevant `request_id` is specified in the URL.

```json Example Response
{
  "request_id": "1e2b8dec-b8f3-40b6-aef7-a5c85b77e7d7",
  "status": "Complete",
  "entity_id": "c7fcf490-2a2f-4391-9538-17db90e0e956",
  "entity_type": "case",
  "datetime_requested": "2025-02-24T11:21:49.293Z",
  "datetime_completed": "2025-02-24T11:22:48.722Z",
  "message": null,
  "data": [
    {
      "transaction_id": "c86ef559-5738-7d45-699f-1356af4ba40c",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-28",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -31.65,
      "normalised_amount": -10.55
    },
    {
      "transaction_id": "22b1e828-2f42-47bd-d382-60fa376f961a",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-21",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -31.37,
      "normalised_amount": -10.46
    },
    {
      "transaction_id": "a3d44e4a-a6ad-47e3-5563-0bbf595bc3bf",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-30",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -22.81,
      "normalised_amount": -7.6
    },
    {
      "transaction_id": "6f8945ae-a7be-4083-2715-b9d3c75b756f",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-13",
      "group": "Non-essential expenditure",
      "category": "Shopping",
      "subcategory": null,
      "short_description": "H & M Hennes & Mauritz U London",
      "long_description": "H&M Hennes & Mauritz U London GBR",
      "amount": -68.28,
      "normalised_amount": -22.76
    },
    {
      "transaction_id": "8d6c81ec-063d-2a28-8e96-f1457ed7b483",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-28",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -26.69,
      "normalised_amount": -8.9
    },
    {
      "transaction_id": "025374be-86c7-a1c4-add5-75e689da24bf",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-09",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "9e0b5671-d687-15e4-850e-343fbb69931e",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-04",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -29.78,
      "normalised_amount": -9.93
    },
    {
      "transaction_id": "31f924b0-19ee-82e4-739a-79d3ded63fef",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-25",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "08e2e9bf-d486-44ca-f767-c997aec1860c",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-04",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "c47c5a44-bea9-5db7-655c-53c0292920d5",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-25",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -22.97,
      "normalised_amount": -7.66
    },
    {
      "transaction_id": "66a08624-b920-da44-6896-ef7b4d810789",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-17",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -3.02,
      "normalised_amount": -1.01
    },
    {
      "transaction_id": "27b35c62-a30c-0825-437e-d53ddbfe59f4",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-19",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "34de6902-b22c-0b03-3aff-21e7232573dd",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-01",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "28c4e120-0c9a-3a89-8ec6-1c61200fd7ec",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-14",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -23.69,
      "normalised_amount": -7.9
    },
    {
      "transaction_id": "f59d32aa-ff87-08e8-509c-fa48f23645e1",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-01",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -23.29,
      "normalised_amount": -7.76
    },
    {
      "transaction_id": "587a0d33-99a6-03d2-7f5d-507bd3499f45",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-10",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Other",
      "short_description": "Vwfs UK Limited",
      "long_description": "Vwfs UK Limited",
      "amount": -275.64,
      "normalised_amount": -91.88
    },
    {
      "transaction_id": "37c5d7c8-973f-401d-db55-d748a9e1be6f",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-03",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "7b076ae6-ea23-30f1-6fa1-2504f9f62cdc",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-08",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -17.44,
      "normalised_amount": -5.81
    },
    {
      "transaction_id": "66972adb-0ee4-a6f7-6f47-684c0513300a",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-07",
      "group": "Other",
      "category": "Other inflows",
      "subcategory": null,
      "short_description": "Amznmktplace Refund",
      "long_description": "AMZNMktplace CD 0118, REFUND",
      "amount": 38.64,
      "normalised_amount": 12.88
    },
    {
      "transaction_id": "b6703fb0-311a-2bcb-5f62-c81c761ef1b7",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-26",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "e22230fa-85ec-0da2-b4a9-c12182624af3",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-21",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -26.39,
      "normalised_amount": -8.8
    },
    {
      "transaction_id": "1c020c1a-bca4-735d-8570-3f73840c21d0",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-15",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -16.7,
      "normalised_amount": -5.57
    },
    {
      "transaction_id": "1f9aa518-0b6e-3beb-d134-211499827f19",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-31",
      "group": "Income",
      "category": "Employment and/or Self-employment",
      "subcategory": null,
      "short_description": "Salary SAM Weetabix CEREALS-R-US",
      "long_description": "Salary - Sam Weetabix - Cereals-R-Us",
      "amount": 2449.04,
      "normalised_amount": 890.73
    },
    {
      "transaction_id": "c5271790-3920-a369-7e9c-0526bb2f149f",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-12",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "98a1e7f4-4e90-2f2b-f9c1-081f369745bd",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-11",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "b5a62353-7ad9-4ca1-7440-4ee035a1da89",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-26",
      "group": "Non-essential expenditure",
      "category": "Shopping",
      "subcategory": null,
      "short_description": "Amznmktplace",
      "long_description": "AMZNMktplace CD 0118",
      "amount": -172.2,
      "normalised_amount": -57.4
    },
    {
      "transaction_id": "c9564ac0-73a2-3862-6252-3cfa2db93abb",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-07",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "5d74feab-ed1d-5867-1145-ec12fd143205",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-21",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -45.67,
      "normalised_amount": -15.22
    },
    {
      "transaction_id": "01c0cb57-0987-f921-03fc-d5fcc8d25256",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-21",
      "group": "Essential expenditure",
      "category": "Utilities",
      "subcategory": "Energy",
      "short_description": "British Gas",
      "long_description": "BRITISH GAS",
      "amount": -72.23,
      "normalised_amount": -24.08
    },
    {
      "transaction_id": "a4851746-ae82-df24-ce86-836fa661ba1f",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-11",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -43.4,
      "normalised_amount": -14.47
    },
    {
      "transaction_id": "e792140d-5bfc-701f-6ac0-982fc7024c6e",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-14",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -39.75,
      "normalised_amount": -13.25
    },
    {
      "transaction_id": "1b78270a-f15d-7c95-9959-9e8e7585db3c",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-02",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "26fc1bfc-eb5f-c401-4334-02b9ff631ff3",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-17",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -40,
      "normalised_amount": -13.33
    },
    {
      "transaction_id": "cda5bab2-cdb1-4346-e035-da317ad59afb",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-28",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -11.81,
      "normalised_amount": -3.94
    },
    {
      "transaction_id": "87ed7d7d-61d6-4fbc-ac7f-901c75c70763",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-04",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -27.18,
      "normalised_amount": -9.06
    },
    {
      "transaction_id": "ee45ef74-e714-53b1-d070-84e3cd250eab",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-24",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -13.99,
      "normalised_amount": -4.66
    },
    {
      "transaction_id": "e25b5224-9c9f-e733-c691-925295d7bbe7",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-20",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "5fcde398-a2f4-3ba8-e945-eda338fef792",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-24",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "d4a289a0-67e6-9c7d-ba97-d1c275b045df",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-06",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -42.14,
      "normalised_amount": -14.05
    },
    {
      "transaction_id": "365e7072-75de-46c5-532f-430b79f83c9c",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-31",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -40,
      "normalised_amount": -13.33
    },
    {
      "transaction_id": "c399ddfa-81be-6bbd-ec7f-bf2354a54516",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-23",
      "group": "Non-essential expenditure",
      "category": "TV and subscriptions",
      "subcategory": null,
      "short_description": "BT Group PLC",
      "long_description": "BT GROUP PLC",
      "amount": -32.77,
      "normalised_amount": -10.92
    },
    {
      "transaction_id": "75aa92d8-fbbe-1e61-de02-15e6586a1b62",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-04",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -18.85,
      "normalised_amount": -6.28
    },
    {
      "transaction_id": "9486d151-d4f5-8ddd-5769-76ac32c1337d",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-10",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -24.31,
      "normalised_amount": -8.1
    },
    {
      "transaction_id": "d704557f-b854-ec1c-2851-1dd0c18b7f7b",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-08",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "6dd61ed6-b20f-2831-05df-14dd1fd50c50",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-16",
      "group": "Essential expenditure",
      "category": "Credit cards and loans",
      "subcategory": null,
      "short_description": "M & S Credit",
      "long_description": "M&S CREDIT CARD",
      "amount": -256.9,
      "normalised_amount": -85.63
    },
    {
      "transaction_id": "d45228ae-ff2b-79f8-d771-9953c0bb4f24",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-14",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "67962d87-dc6e-4463-9e24-83e957f650b3",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-28",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "ebcba3e8-41a4-a6dd-0a7e-e5772e79ba58",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-13",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "ca4f4113-cfba-2d35-2337-bd653f84036b",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-31",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -20.95,
      "normalised_amount": -6.98
    },
    {
      "transaction_id": "c984da8d-3efe-2c9b-491b-f248f927edd4",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-22",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -12.9,
      "normalised_amount": -4.3
    },
    {
      "transaction_id": "e4cdb867-d360-5c98-31f6-01eee9afcad8",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-21",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "feeace2b-e037-fa0f-00cc-d22fc239b3cd",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-01",
      "group": "Essential expenditure",
      "category": "Tax",
      "subcategory": "Council tax",
      "short_description": "Sevenoaks D.c.",
      "long_description": "SEVENOAKS D.C.",
      "amount": -135,
      "normalised_amount": -45
    },
    {
      "transaction_id": "cea95ef2-63d1-7b5c-d292-5a78f33bef73",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-10",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "7e4c0f61-f13f-5e7c-8e42-cec3aea249bd",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-05",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -16.7,
      "normalised_amount": -5.57
    },
    {
      "transaction_id": "93b208c1-6296-743e-912a-d9ae884862a5",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-29",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -20.6,
      "normalised_amount": -6.87
    },
    {
      "transaction_id": "d0f4c715-bbb9-5c5e-0bf7-8bb0edf8127d",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-27",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "6570b068-46f4-d1c8-1699-a8b201f65dfe",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-23",
      "group": "Other",
      "category": "Other inflows",
      "subcategory": null,
      "short_description": "Gross Interest",
      "long_description": "GROSS INTEREST TO 2023-12-23",
      "amount": 4.42,
      "normalised_amount": 1.47
    },
    {
      "transaction_id": "48d0342e-d88c-e7fd-47b2-31918d1ce447",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-06",
      "group": "Essential expenditure",
      "category": "Mortgage and rent",
      "subcategory": null,
      "short_description": "Nottingham BS Mtge",
      "long_description": "NOTTINGHAM BS MTGE",
      "amount": -560.4,
      "normalised_amount": -186.8
    },
    {
      "transaction_id": "84ee938f-c5fc-d4ac-8244-cfc25dcd0c84",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-18",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "d6727a7c-e15b-3384-074d-fe4cfc7cbac9",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-16",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -44.19,
      "normalised_amount": -14.73
    },
    {
      "transaction_id": "56999a45-7285-fa00-174a-e41fe8e6ebc4",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-14",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -43.13,
      "normalised_amount": -14.38
    },
    {
      "transaction_id": "cd16c9a1-81bf-6610-3627-4870098fc376",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-17",
      "group": "Non-essential expenditure",
      "category": "TV and subscriptions",
      "subcategory": null,
      "short_description": "netflix.com",
      "long_description": "NETFLIX.COM 18665797172",
      "amount": -10.99,
      "normalised_amount": -3.66
    },
    {
      "transaction_id": "d37afc2c-f4ca-c8cd-74ea-71767ebf988d",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-18",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -29.41,
      "normalised_amount": -9.8
    },
    {
      "transaction_id": "1109db0d-3ad1-9b7a-e834-386078b5b997",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-23",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -21.93,
      "normalised_amount": -7.31
    },
    {
      "transaction_id": "9241a90d-7254-dd4b-b373-6c31dcf43fd3",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-07",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -48.91,
      "normalised_amount": -16.3
    },
    {
      "transaction_id": "b149b0ca-c257-51e2-ad1c-a397df39804d",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-20",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "10b4a7a3-c6ae-5fee-8f26-321d40b7e6e5",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-13",
      "group": "Non-essential expenditure",
      "category": "Shopping",
      "subcategory": null,
      "short_description": "H & M Hennes & Mauritz U London",
      "long_description": "H&M Hennes & Mauritz U London GBR",
      "amount": -103.15,
      "normalised_amount": -34.38
    },
    {
      "transaction_id": "123378b2-5be8-8892-c462-3b9b6ca55999",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-01",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -12.9,
      "normalised_amount": -4.3
    },
    {
      "transaction_id": "158b0b04-63e9-1e31-d59b-46cdd65bf963",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-20",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -34.02,
      "normalised_amount": -11.34
    },
    {
      "transaction_id": "ccaa08c3-ef1e-5f7a-9f5f-51db49734ebb",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-23",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "b163d88b-f693-2075-8e89-f43cd48a0ccb",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-09",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -3.19,
      "normalised_amount": -1.06
    },
    {
      "transaction_id": "d9d44441-53b6-99f1-57f6-2842a109544a",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-21",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "375bc604-a828-2d06-5d62-35de6328b079",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-06",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "c83229ca-488a-67a6-2e08-b4c600010025",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-23",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -21.62,
      "normalised_amount": -7.21
    },
    {
      "transaction_id": "6b1f3a1f-bd21-7f99-e61b-cf54b9c6797b",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-17",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -20.6,
      "normalised_amount": -6.87
    },
    {
      "transaction_id": "cace7dae-13fc-cb18-4e35-4af67d5b06a3",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-19",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -40,
      "normalised_amount": -13.33
    },
    {
      "transaction_id": "76ec24a8-df67-f0f1-da3f-9f79c5a74f0d",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-30",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "c9de0bcb-d22b-d9fe-cd12-54eaa73246f5",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-23",
      "group": "Non-essential expenditure",
      "category": "TV and subscriptions",
      "subcategory": null,
      "short_description": "BT Group PLC",
      "long_description": "BT GROUP PLC",
      "amount": -32.77,
      "normalised_amount": -10.92
    },
    {
      "transaction_id": "7a5930e0-fcc6-448b-4293-5ce7703d3ce3",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-11",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -32.86,
      "normalised_amount": -10.95
    },
    {
      "transaction_id": "6c6b7905-6f47-d799-7cfb-d4bad9c8f102",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-30",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -23.7,
      "normalised_amount": -7.9
    },
    {
      "transaction_id": "af2ed1d1-2289-419d-f84c-8d31c0863fc6",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-28",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "ab49b170-eab7-ddc0-0711-e21f3e0fdde8",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-07",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -25.03,
      "normalised_amount": -8.34
    },
    {
      "transaction_id": "8de9250d-4256-3058-5d87-66d55cb5d619",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-01",
      "group": "Essential expenditure",
      "category": "Tax",
      "subcategory": "Council tax",
      "short_description": "Sevenoaks D.c.",
      "long_description": "SEVENOAKS D.C.",
      "amount": -135,
      "normalised_amount": -45
    },
    {
      "transaction_id": "290c25bd-b65b-de02-25b5-8038790a43dd",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-14",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "ab1424f4-a119-24b8-2b17-e728828efce3",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-10",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Other",
      "short_description": "Vwfs UK Limited",
      "long_description": "Vwfs UK Limited",
      "amount": -275.64,
      "normalised_amount": -91.88
    },
    {
      "transaction_id": "51ec6d54-0583-d8c4-4715-8291646c6c96",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-16",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -25.88,
      "normalised_amount": -8.63
    },
    {
      "transaction_id": "4d2fb359-772e-7b73-a4bd-f2f66b247029",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-07",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -30.11,
      "normalised_amount": -10.04
    },
    {
      "transaction_id": "0e7c507b-e818-d1cf-329f-58ca73dc1dcc",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-04",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -7.75,
      "normalised_amount": -2.58
    },
    {
      "transaction_id": "d3306a31-e567-4381-5be1-a157e478e8d4",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-24",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -16.7,
      "normalised_amount": -5.57
    },
    {
      "transaction_id": "822a1a02-b8c0-43bb-f99b-b9af9ee9140b",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-23",
      "group": "Other",
      "category": "Other inflows",
      "subcategory": null,
      "short_description": "Gross Interest",
      "long_description": "GROSS INTEREST TO 2023-11-23",
      "amount": 1.24,
      "normalised_amount": 0.41
    },
    {
      "transaction_id": "bbb0d452-9826-c298-e4f0-61307c07886a",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-16",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "21a6b306-c06d-a1f4-d347-7f3d12aaeea5",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-05",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "384c54b3-7ef8-7445-d500-fad7dd22c2cd",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-23",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -49.42,
      "normalised_amount": -16.47
    },
    {
      "transaction_id": "284ffb36-80f9-00a8-ba2d-8f1f09815e00",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-26",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -8.15,
      "normalised_amount": -2.72
    },
    {
      "transaction_id": "09ab091a-2c2d-398f-dbfa-b1eb71a7853b",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-29",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "6342303e-620a-d71e-6d30-3ef41aed28d6",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-15",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "4eb4a43a-1e08-fd63-5a2a-97204acb87bc",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-03",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -23.32,
      "normalised_amount": -7.77
    },
    {
      "transaction_id": "96e92069-2407-8854-f20e-4bb429b2b3cd",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-07",
      "group": "Other",
      "category": "Other inflows",
      "subcategory": null,
      "short_description": "Amznmktplace Refund",
      "long_description": "AMZNMktplace CD 0118, REFUND",
      "amount": 35.57,
      "normalised_amount": 11.86
    },
    {
      "transaction_id": "c49ee154-a9f7-924a-007a-1c3fabad5c3c",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-16",
      "group": "Essential expenditure",
      "category": "Credit cards and loans",
      "subcategory": null,
      "short_description": "M & S Credit",
      "long_description": "M&S CREDIT CARD",
      "amount": -51.73,
      "normalised_amount": -17.24
    },
    {
      "transaction_id": "5b7d9ec0-b7e0-f6b6-d35a-5b531e2aff7c",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-08",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -20.6,
      "normalised_amount": -6.87
    },
    {
      "transaction_id": "4c209d97-4f1f-8459-f2c5-c44814f8d3c9",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-27",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -3.88,
      "normalised_amount": -1.29
    },
    {
      "transaction_id": "f3291f03-1b4b-b0df-e18c-14452caa1a0e",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-06",
      "group": "Essential expenditure",
      "category": "Mortgage and rent",
      "subcategory": null,
      "short_description": "Nottingham BS Mtge",
      "long_description": "NOTTINGHAM BS MTGE",
      "amount": -560.4,
      "normalised_amount": -186.8
    },
    {
      "transaction_id": "133396c7-4195-6875-ef39-3b7aa77cac68",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-30",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -13.47,
      "normalised_amount": -4.49
    },
    {
      "transaction_id": "159cf639-58e0-31a4-86b9-b5e72c8f5afe",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-13",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "331f4407-d92b-e458-585e-9513904aec43",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-02",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -16.36,
      "normalised_amount": -5.45
    },
    {
      "transaction_id": "484b199d-0cc6-7e04-6221-059cbf4282c7",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-23",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -36.13,
      "normalised_amount": -12.04
    },
    {
      "transaction_id": "45ecf944-6e5c-5a73-2e27-eab74f8eb3b2",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-12",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -33.94,
      "normalised_amount": -11.31
    },
    {
      "transaction_id": "b389c021-041d-0c6f-6926-5de9db15994b",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-21",
      "group": "Essential expenditure",
      "category": "Utilities",
      "subcategory": "Energy",
      "short_description": "British Gas",
      "long_description": "BRITISH GAS",
      "amount": -68.32,
      "normalised_amount": -22.77
    },
    {
      "transaction_id": "9cf76bed-e702-3ae9-334e-1e4c1de6c0ce",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-19",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -30.13,
      "normalised_amount": -10.04
    },
    {
      "transaction_id": "8fd41b57-8910-26de-6f67-7889b7af1ff1",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-04",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "45fccebe-cab0-06a2-6629-a1a633667871",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-12",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "7363d08e-5acf-a5ea-e417-cbee01e6e620",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-13",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -13.18,
      "normalised_amount": -4.39
    },
    {
      "transaction_id": "255125d0-708d-cfec-3bef-df88723bc034",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-10",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -12.9,
      "normalised_amount": -4.3
    },
    {
      "transaction_id": "29d2c41f-1ce4-9dc9-0c7e-1042870a0d1b",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-30",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -35.28,
      "normalised_amount": -11.76
    },
    {
      "transaction_id": "6a2b5b95-10e5-3d97-0b1a-899520fe0030",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-16",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -35.45,
      "normalised_amount": -11.82
    },
    {
      "transaction_id": "6528739e-cf08-fbea-363e-f566520bbf77",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-26",
      "group": "Non-essential expenditure",
      "category": "Shopping",
      "subcategory": null,
      "short_description": "Amznmktplace",
      "long_description": "AMZNMktplace CD 0118",
      "amount": -71.81,
      "normalised_amount": -23.94
    },
    {
      "transaction_id": "6e245f6b-4405-fcf2-4e4b-5ad8c3c0dbaf",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-27",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "7fda6827-61d2-f15b-f1ba-b34eb560bd00",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-07",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "586dafcd-5e6d-f22a-b1e4-7f0b1f656cfd",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-03",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -40,
      "normalised_amount": -13.33
    },
    {
      "transaction_id": "ad8dff33-e8c1-008f-5c16-321aa750f771",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-25",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -7.78,
      "normalised_amount": -2.59
    },
    {
      "transaction_id": "fa9fd21a-db4b-f65d-24f1-efcd4451cdb6",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-17",
      "group": "Non-essential expenditure",
      "category": "TV and subscriptions",
      "subcategory": null,
      "short_description": "netflix.com",
      "long_description": "NETFLIX.COM 18665797172",
      "amount": -10.99,
      "normalised_amount": -3.66
    },
    {
      "transaction_id": "06400711-a0df-71fc-ef5d-abe4570f26c5",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-22",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "a7f3c523-2ce6-0462-371e-c307471c1af4",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-26",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "3756643e-5592-08d0-e835-ec895ff55114",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-16",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -38.79,
      "normalised_amount": -12.93
    },
    {
      "transaction_id": "e6ff6d9c-251e-6d1f-81dc-f101df10af3d",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-18",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -15.64,
      "normalised_amount": -5.21
    },
    {
      "transaction_id": "66dcaf3e-6a07-a829-2cde-f7cf16f894f6",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-07",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -32.71,
      "normalised_amount": -10.9
    },
    {
      "transaction_id": "50ea54d8-890d-dad9-b34f-03b77a21363b",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-30",
      "group": "Income",
      "category": "Employment and/or Self-employment",
      "subcategory": null,
      "short_description": "Salary SAM Weetabix CEREALS-R-US",
      "long_description": "Salary - Sam Weetabix - Cereals-R-Us",
      "amount": 2702.46,
      "normalised_amount": 890.73
    },
    {
      "transaction_id": "df8337c5-0d4c-39d4-f710-4367d790c4b5",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-31",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "4e3c7e17-66fd-86d5-6181-1c49f2132d5f",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-19",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "2e199eb5-b1c3-8c58-0f5e-f325bb2678f9",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-03",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -16.7,
      "normalised_amount": -5.57
    },
    {
      "transaction_id": "616a4758-c93c-1960-82a3-1ecf6c841db1",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-12",
      "group": "Essential expenditure",
      "category": "Insurance premiums",
      "subcategory": null,
      "short_description": "Aviva Life",
      "long_description": "Aviva Life",
      "amount": -12.53,
      "normalised_amount": -4.18
    },
    {
      "transaction_id": "a8fb347a-d265-1233-e921-cb742bb7bd2d",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-23",
      "group": "Non-essential expenditure",
      "category": "TV and subscriptions",
      "subcategory": null,
      "short_description": "BT Group PLC",
      "long_description": "BT GROUP PLC",
      "amount": -32.77,
      "normalised_amount": -10.92
    },
    {
      "transaction_id": "440267c1-15d6-64c5-6a40-2ac9bbf3755f",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-22",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -4.48,
      "normalised_amount": -1.49
    },
    {
      "transaction_id": "f4133462-5e8b-0fac-ffa3-131e4de79198",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-17",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "2719b58a-d416-415b-e35b-b215512d5c64",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-09",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -25.14,
      "normalised_amount": -8.38
    },
    {
      "transaction_id": "28b413d9-da49-a0c2-a41d-375d28a77d88",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-29",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "9d751633-520c-b930-89ce-437badda8ed4",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-09",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -25.71,
      "normalised_amount": -8.57
    },
    {
      "transaction_id": "42bbf680-030f-1d41-93cb-bc1167bcb75f",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-16",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -46.29,
      "normalised_amount": -15.43
    },
    {
      "transaction_id": "5650ff80-b101-618a-f8bc-3b0c78af55d4",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-30",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -36.24,
      "normalised_amount": -12.08
    },
    {
      "transaction_id": "502580a2-cc66-5889-a65d-9f5426bda3d2",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-07",
      "group": "Other",
      "category": "Other inflows",
      "subcategory": null,
      "short_description": "Amznmktplace Refund",
      "long_description": "AMZNMktplace CD 0118, REFUND",
      "amount": 23.34,
      "normalised_amount": 7.78
    },
    {
      "transaction_id": "bb296168-9cd5-ac90-e86e-33f05e452efc",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-23",
      "group": "Other",
      "category": "Other inflows",
      "subcategory": null,
      "short_description": "Gross Interest",
      "long_description": "GROSS INTEREST TO 2023-10-23",
      "amount": 4.67,
      "normalised_amount": 1.56
    },
    {
      "transaction_id": "8778db66-f450-19ed-bf3d-4356fd5a9b59",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-06",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "2a6faea0-f998-6dd7-8dc5-1e9c39f9ea2c",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-05",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -38.98,
      "normalised_amount": -12.99
    },
    {
      "transaction_id": "41e3caa2-1f43-635d-7eaf-e255c41d999f",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-04",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -10,
      "normalised_amount": -3.33
    },
    {
      "transaction_id": "897d834f-0fb0-e904-3aa1-19b8f99ea9e4",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-12",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -29.39,
      "normalised_amount": -9.8
    },
    {
      "transaction_id": "f0b260fc-0a8b-1f38-47bf-54fe3a9738a4",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-12",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -15.48,
      "normalised_amount": -5.16
    },
    {
      "transaction_id": "53607d82-48c7-922d-9df1-36ed85fa68e3",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-09",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "2cb1ec2b-91b1-12fc-9941-168781e7f120",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-14",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -21.49,
      "normalised_amount": -7.16
    },
    {
      "transaction_id": "2e49efee-42a7-1d37-9c57-95597dbece62",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-21",
      "group": "Essential expenditure",
      "category": "Utilities",
      "subcategory": "Energy",
      "short_description": "British Gas",
      "long_description": "BRITISH GAS",
      "amount": -56.34,
      "normalised_amount": -18.78
    },
    {
      "transaction_id": "4b411f89-3d60-b296-0600-585c84a1afc6",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-26",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -31.72,
      "normalised_amount": -10.57
    },
    {
      "transaction_id": "0b6d9483-cf58-cbda-4268-b864939f59ba",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-24",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "94721f90-fa62-37b1-cfd9-5b7fd036cfc1",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-16",
      "group": "Essential expenditure",
      "category": "Credit cards and loans",
      "subcategory": null,
      "short_description": "M & S Credit",
      "long_description": "M&S CREDIT CARD",
      "amount": -263.23,
      "normalised_amount": -87.74
    },
    {
      "transaction_id": "0d3cf4a2-f2e1-210b-de46-068933669857",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-23",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "51024c5d-0ca7-ed22-3e37-4e8cf73f7e37",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-01",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "178f5ada-3359-e61f-a88a-70332369d8ed",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-19",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -32.25,
      "normalised_amount": -10.75
    },
    {
      "transaction_id": "2e1ca344-9d25-1318-306b-6548629f5a19",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-09",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -36.66,
      "normalised_amount": -12.22
    },
    {
      "transaction_id": "9f4f9f40-a5e8-c773-e49e-39222a013f39",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-18",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "ab6d9c0e-3cab-ceca-90de-4466ba76b792",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-02",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -35.23,
      "normalised_amount": -11.74
    },
    {
      "transaction_id": "1604d6f3-6d0d-ff2c-3d7f-8291ea3b3c99",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-07",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "a763860d-ed28-f5e1-3b3e-2f231d0abfc2",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-22",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -40,
      "normalised_amount": -13.33
    },
    {
      "transaction_id": "ad4997cd-3e85-6bef-8738-54183cb074d9",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-24",
      "group": "Essential expenditure",
      "category": "Insurance premiums",
      "subcategory": null,
      "short_description": "Aviva Insurance",
      "long_description": "AVIVA INSURANCE CD 0118",
      "amount": -37.49,
      "normalised_amount": -12.5
    },
    {
      "transaction_id": "3a7914ab-c84f-26c9-a8d7-c3a619020192",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-12",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "76b74753-7f5f-63c4-9b20-395310927560",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-28",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -21.67,
      "normalised_amount": -7.22
    },
    {
      "transaction_id": "b6d6b22a-f271-ab6e-aa20-cf3dc70b8a67",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-12",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -30.79,
      "normalised_amount": -10.26
    },
    {
      "transaction_id": "137b45f8-56f6-b8b2-4ac7-8105f41a8751",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-15",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "2baaa21c-2d24-36a2-572b-b46dc705bdb3",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-26",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Fuel",
      "short_description": "BP Deer Park S/serve (via Apple Pay)",
      "long_description": "BP DEER PARK S/SERVE (VIA APPLE PAY)",
      "amount": -20.17,
      "normalised_amount": -6.72
    },
    {
      "transaction_id": "c1898768-b4f8-ceaf-5516-9c64abd9bd63",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-26",
      "group": "Non-essential expenditure",
      "category": "Shopping",
      "subcategory": null,
      "short_description": "Amznmktplace",
      "long_description": "AMZNMktplace CD 0118",
      "amount": -68.33,
      "normalised_amount": -22.78
    },
    {
      "transaction_id": "17b8a695-2e96-8f78-0e41-e99af86f1d02",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-01",
      "group": "Essential expenditure",
      "category": "Tax",
      "subcategory": "Council tax",
      "short_description": "Sevenoaks D.c.",
      "long_description": "SEVENOAKS D.C.",
      "amount": -135,
      "normalised_amount": -45
    },
    {
      "transaction_id": "dff5e516-33db-ac26-2c06-9cc2d07bccbb",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-26",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "c658286b-ce0f-59d4-52e0-b76598271e5d",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-02",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "fba226a9-99b7-fc03-08c9-86ba7b4a0850",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-30",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "8fc8fc4f-8bec-37d7-2457-8a2f6a97c60d",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-11",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -6.9,
      "normalised_amount": -2.3
    },
    {
      "transaction_id": "206b152f-19fa-8d2b-942f-759c95f1c29f",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-13",
      "group": "Non-essential expenditure",
      "category": "Shopping",
      "subcategory": null,
      "short_description": "H & M Hennes & Mauritz U London",
      "long_description": "H&M Hennes & Mauritz U London GBR",
      "amount": -44.85,
      "normalised_amount": -14.95
    },
    {
      "transaction_id": "e1e2179d-331d-1297-6532-13c9b8cb7ed8",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-05",
      "group": "Essential expenditure",
      "category": "Cash withdrawal",
      "subcategory": null,
      "short_description": "Cash Withdrawal at Barclays Asda Burgh HTH 2",
      "long_description": "Cash Withdrawal at Barclays ASDA Burgh Hth 2",
      "amount": -40,
      "normalised_amount": -13.33
    },
    {
      "transaction_id": "59f7ae55-2d3b-3585-3ccd-e5dee61ccb75",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-19",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -11.51,
      "normalised_amount": -3.84
    },
    {
      "transaction_id": "4ffece06-8804-ef66-99e6-8df6573b3c96",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-15",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -10.76,
      "normalised_amount": -3.59
    },
    {
      "transaction_id": "00ad757d-471f-db45-ede5-69dbe79e3bf2",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-04",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -10.29,
      "normalised_amount": -3.43
    },
    {
      "transaction_id": "953fc456-0700-5c01-7f4d-8f3689a119c8",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-17",
      "group": "Income",
      "category": "Benefits",
      "subcategory": "Child benefit",
      "short_description": "Hmrc Child Benefit",
      "long_description": "HMRC CHILD BENEFIT",
      "amount": 139.75,
      "normalised_amount": 50.47
    },
    {
      "transaction_id": "996cff44-9cad-5982-7813-b7e7b4ccc295",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-14",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "ac0244ec-57cb-a49e-907a-3d8fe8d8ca09",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-06",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -5.19,
      "normalised_amount": -1.73
    },
    {
      "transaction_id": "389003fe-80f5-868a-0741-893a6b9830d3",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-06",
      "group": "Essential expenditure",
      "category": "Mortgage and rent",
      "subcategory": null,
      "short_description": "Nottingham BS Mtge",
      "long_description": "NOTTINGHAM BS MTGE",
      "amount": -560.4,
      "normalised_amount": -186.8
    },
    {
      "transaction_id": "9608484a-bc7c-89fb-e420-086006a468d5",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-28",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "d016fba5-39f6-c140-a964-6ae4d5415968",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-25",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "69bcf53a-256e-9625-5592-23896bdb9570",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-29",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -18.97,
      "normalised_amount": -6.32
    },
    {
      "transaction_id": "150bd619-76da-0ba0-d9e9-aa255495c388",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-10",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "321ab87e-be70-753f-dfe6-e8f5bab00721",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-17",
      "group": "Non-essential expenditure",
      "category": "TV and subscriptions",
      "subcategory": null,
      "short_description": "netflix.com",
      "long_description": "NETFLIX.COM 18665797172",
      "amount": -10.99,
      "normalised_amount": -3.66
    },
    {
      "transaction_id": "87556019-d727-7d8b-9d6b-70a88c36e347",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-13",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -16.7,
      "normalised_amount": -5.57
    },
    {
      "transaction_id": "4019d4bb-f968-a86e-1bf1-725857ade5ef",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-23",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -36.57,
      "normalised_amount": -12.19
    },
    {
      "transaction_id": "559bbca3-b6b5-104e-eb65-c61ef31921fb",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-08",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -2.5,
      "normalised_amount": -0.83
    },
    {
      "transaction_id": "68ca0edd-7cf1-c6f2-7f01-2299cf83640e",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-07",
      "group": "Essential expenditure",
      "category": "Insurance premiums",
      "subcategory": null,
      "short_description": "AXA Insurance",
      "long_description": "AXA INSURANCE",
      "amount": -38.06,
      "normalised_amount": -12.69
    },
    {
      "transaction_id": "be601073-6730-c796-1ace-90d1eca47919",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-02",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -22.22,
      "normalised_amount": -7.41
    },
    {
      "transaction_id": "1f4b32d7-4d4d-ff82-14f3-f58b91c72fbe",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-31",
      "group": "Income",
      "category": "Employment and/or Self-employment",
      "subcategory": null,
      "short_description": "Salary SAM Weetabix CEREALS-R-US",
      "long_description": "Salary - Sam Weetabix - Cereals-R-Us",
      "amount": 2865.04,
      "normalised_amount": 890.73
    },
    {
      "transaction_id": "adaffc12-4f64-4bfd-77aa-774d5694adac",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-20",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -12.9,
      "normalised_amount": -4.3
    },
    {
      "transaction_id": "6c2906fd-d727-8b48-ab6c-f367a9838fbe",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-27",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Five Guys Gloucest",
      "long_description": "Five Guys Gloucest",
      "amount": -20.6,
      "normalised_amount": -6.87
    },
    {
      "transaction_id": "e1f4e8e4-23db-7864-2149-d6bbdcb93e2b",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-16",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Pret a Manger London",
      "long_description": "PRET A MANGER , LONDON GB",
      "amount": -4.7,
      "normalised_amount": -1.57
    },
    {
      "transaction_id": "0c51343f-5ed3-ad7c-621e-d2932f51bfef",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-26",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -34.72,
      "normalised_amount": -11.57
    },
    {
      "transaction_id": "d4acc2f7-d0c2-1193-cb8c-90c534537362",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-11-02",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -33.98,
      "normalised_amount": -11.33
    },
    {
      "transaction_id": "145f4c58-c66d-3efe-5175-5b0954a5e10e",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-10",
      "group": "Essential expenditure",
      "category": "Transportation and travel",
      "subcategory": "Other",
      "short_description": "Vwfs UK Limited",
      "long_description": "Vwfs UK Limited",
      "amount": -275.64,
      "normalised_amount": -91.88
    },
    {
      "transaction_id": "ed08ba4e-4258-b73b-3617-fd686220b91c",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-22",
      "group": "Essential expenditure",
      "category": "Credit cards and loans",
      "subcategory": null,
      "short_description": "Hsbc PLC Loans",
      "long_description": "HSBC PLC LOANS",
      "amount": -200.21,
      "normalised_amount": -66.74
    },
    {
      "transaction_id": "ce40d289-f171-8e90-6efc-b6178abac14c",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-21",
      "group": "Essential expenditure",
      "category": "Groceries and shopping",
      "subcategory": null,
      "short_description": "Tesco Store Hook",
      "long_description": "TESCO STORE 2670 , HOOK GB",
      "amount": -6.2,
      "normalised_amount": -2.07
    },
    {
      "transaction_id": "ea0ee905-62ef-451f-d135-a7bc2674076f",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-19",
      "group": "Non-essential expenditure",
      "category": "Entertainment",
      "subcategory": "Dining out and takeaways",
      "short_description": "Just EAT (via Apple Pay)",
      "long_description": "JUST EAT (VIA APPLE PAY)",
      "amount": -21.21,
      "normalised_amount": -7.07
    },
    {
      "transaction_id": "b3d8a975-0f56-533d-8b22-73ff87349678",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-16",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -10,
      "normalised_amount": -3.33
    },
    {
      "transaction_id": "7d69f354-a226-cfe6-0072-27d0b838d2d1",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-30",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -10,
      "normalised_amount": -3.33
    },
    {
      "transaction_id": "d0a35329-4a54-9573-22aa-cb6e960a4589",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-23",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "9533efcc-65c9-c560-0cdc-114b9e5c400e",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-06",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "da59c1de-fa2a-bed3-4c25-3f8f1e5297b4",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-09",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "f785e276-8aee-33a6-de72-e0ef263197cb",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-02",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -10,
      "normalised_amount": -3.33
    },
    {
      "transaction_id": "ce68d0ee-24ab-ed8a-7c0b-fc6bcfeb53e1",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-18",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -10,
      "normalised_amount": -3.33
    },
    {
      "transaction_id": "07036e00-28d1-5cab-3301-bed5630156a9",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-25",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "f0e5842d-197b-a87a-cd78-c9711bc36161",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-11",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -20,
      "normalised_amount": -6.67
    },
    {
      "transaction_id": "87412696-6f7e-70df-806f-adce0bc8771a",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-22",
      "group": "Essential expenditure",
      "category": "Credit cards and loans",
      "subcategory": null,
      "short_description": "Hsbc PLC Loans",
      "long_description": "HSBC PLC LOANS",
      "amount": -200.21,
      "normalised_amount": -66.74
    },
    {
      "transaction_id": "10aeaf85-e8ec-b8cb-010c-8f3bbd494f9d",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-22",
      "group": "Essential expenditure",
      "category": "Credit cards and loans",
      "subcategory": null,
      "short_description": "Hsbc PLC Loans",
      "long_description": "HSBC PLC LOANS",
      "amount": -200.21,
      "normalised_amount": -66.74
    },
    {
      "transaction_id": "b7f2d446-4b27-bb8d-3f1e-2cd7d7557b73",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-12",
      "group": "Essential expenditure",
      "category": "Insurance premiums",
      "subcategory": null,
      "short_description": "Aviva Life",
      "long_description": "Aviva Life",
      "amount": -12.53,
      "normalised_amount": -4.18
    },
    {
      "transaction_id": "f03ede0e-1c29-6dd2-7ac8-d0c4f2466863",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2024-01-07",
      "group": "Essential expenditure",
      "category": "Insurance premiums",
      "subcategory": null,
      "short_description": "AXA Insurance",
      "long_description": "AXA INSURANCE",
      "amount": -38.06,
      "normalised_amount": -12.69
    },
    {
      "transaction_id": "8f6c1f72-daf3-b1bc-a98f-ea5b757f9090",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-24",
      "group": "Essential expenditure",
      "category": "Insurance premiums",
      "subcategory": null,
      "short_description": "Aviva Insurance",
      "long_description": "AVIVA INSURANCE CD 0118",
      "amount": -37.49,
      "normalised_amount": -12.5
    },
    {
      "transaction_id": "937fe6ee-d7f3-3781-52f9-98bcba72a27f",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-12",
      "group": "Essential expenditure",
      "category": "Insurance premiums",
      "subcategory": null,
      "short_description": "Aviva Life",
      "long_description": "Aviva Life",
      "amount": -12.53,
      "normalised_amount": -4.18
    },
    {
      "transaction_id": "a8b48741-c944-7945-8854-90991fdb718a",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-12-07",
      "group": "Essential expenditure",
      "category": "Insurance premiums",
      "subcategory": null,
      "short_description": "AXA Insurance",
      "long_description": "AXA INSURANCE",
      "amount": -38.06,
      "normalised_amount": -12.69
    },
    {
      "transaction_id": "9ba2e0e8-5ee1-7130-d25d-26f7328b1592",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-24",
      "group": "Essential expenditure",
      "category": "Insurance premiums",
      "subcategory": null,
      "short_description": "Aviva Insurance",
      "long_description": "AVIVA INSURANCE CD 0118",
      "amount": -37.49,
      "normalised_amount": -12.5
    },
    {
      "transaction_id": "79480d89-ba6f-4a43-caec-017924c1dfb0",
      "account_connection_id": "280fdc37-f907-4fac-b25e-8ee4bbf43e6b",
      "date": "2023-12-17",
      "group": "Income",
      "category": "Benefits",
      "subcategory": "Child benefit",
      "short_description": "Hmrc Child Benefit",
      "long_description": "HMRC CHILD BENEFIT",
      "amount": 139.75,
      "normalised_amount": 50.47
    },
    {
      "transaction_id": "9d9df86e-f5e9-9a57-ff99-3111b6a384a2",
      "account_connection_id": "4821d9fd-6ac6-4f66-a563-c83854e8493f",
      "date": "2023-11-17",
      "group": "Income",
      "category": "Benefits",
      "subcategory": "Child benefit",
      "short_description": "Hmrc Child Benefit",
      "long_description": "HMRC CHILD BENEFIT",
      "amount": 139.75,
      "normalised_amount": 50.47
    },
    {
      "transaction_id": "917c652c-cbdd-91fc-c289-7e0e51cf8245",
      "account_connection_id": "e54aaff4-3746-4e49-a017-44f79c9d0adc",
      "date": "2023-10-21",
      "group": "Non-essential expenditure",
      "category": "Gambling",
      "subcategory": null,
      "short_description": "Stoke",
      "long_description": "BET365 , STOKE GB",
      "amount": -10,
      "normalised_amount": -3.33
    }
  ],
  "data_sources": [
    {
      "source_id": "e53b7b7a-1fe0-4e0d-8da1-320ab4e67146",
      "source_name": "Sample data A - monthly pay - bank statement 1 of 3 - Sam Weetabix.pdf",
      "source_category_type": "Document",
      "source_type": "BankStatement"
    },
    {
      "source_id": "076c4af0-4860-4942-8027-e9fb3aa0ff4e",
      "source_name": "Sample data A - monthly pay - bank statement 2 of 3 - Sam Weetabix.pdf",
      "source_category_type": "Document",
      "source_type": "BankStatement"
    },
    {
      "source_id": "0da4c03d-862b-4799-bfb2-e31b05d7c29d",
      "source_name": "Sample data A - monthly pay - bank statement 3 of 3 - Sam Weetabix.pdf",
      "source_category_type": "Document",
      "source_type": "BankStatement"
    }
  ]
}
```