Introduction

The following report summarises monthly bank transactions based upon a key word(s) classification table. Different types of transactions are recognised based upon key words that are found.

The key word classification table used for the current report is shown here with key word(s) for each type in the Patterns column separated by semi colons (;):

Bank transactions were provided for the from January 2022 to June 2022 drawing information from the following columns:

  • Date - column containing transaction date
  • Description - payment description column
  • In - amount of money paid in
  • Out - amount of money paid out

With the following additional columns add based on the type classifications:

  • Type - transaction type classification
  • Pattern - pattern that matched for type classification

Unclassified transactions

Based on the above type classifications using key words, the following transaction descriptions didn’t contain any key words:

Importantly, 1 transactions were excluded as these were classified as the “Exclude” type in the ../../data/dummy_transaction_coding_dictionary.csv file provided.

Average monthly earnings and costs

Without considering transaction type the average monthly earnings, costs, and savings are the following:

  • Earnings: £1,200
  • Costs: £-726
  • Savings: £474

Here is how the above values vary by month:

Static

Interactive

## Warning: replacing previous import 'lifecycle::last_warnings' by
## 'rlang::last_warnings' when loading 'tibble'

Data

Monthly earnings and costs by type

Considering the transaction type we can break down the monthly earnings, costs, and savings on average across the months considered:

Static

Interactive

Data

And by month:

Static

Interactive

Data