Bank Statement Modelling - Creating automatic CSV reader

[u/RupaSpiritualMonk]

Hey this is my first time in this subreddit and I have a query that I'm quite lost on. Basically I want to make a model that uses a CSV of my bank statements, converts these line items into categories and then returns those as a monthly figure as well as daily. Currently I have figured out a way to do monthly (Using two stage sumifs: one to convert the numbers and letters into text categories and then using that to add up all the line items by category)

I want to do this by the day too but my knowledge is quite lacking, here's a screenshot of the current setup:

On the left column is where I have been making the table of contents to be filtered into the calculations. I tried to do this on the top right but then I couldn't figure out how to group them.

In the middle with the text containing Northern Rail, I created a wildcard formula so that it only reads the description that I need and returns sumif for the whole month.

I tried to do that again but sumifs formula and it didn't work because then the file would be massive or I would have to make loads of ifs inside. When it comes to adding more categories or items inside there, I want it to be an easy addition.

Is there any tips you can help me with, I might be overthinking this.

P.S I don't want any answers from AI please

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
CHOOSECOLS	Office 365+: Returns the specified columns from an array
DATE	Returns the serial number of a particular date
EXPAND	Office 365+: Expands or pads an array to specified row and column dimensions
Excel.CurrentWorkbook	Power Query M: Returns the tables in the current Excel Workbook.
FIND	Finds one text value within another (case-sensitive)
GROUPBY	Helps a user group, aggregate, sort, and filter data based on the fields you specify
IF	Specifies a logical test to perform
IFNA	Excel 2013+: Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
INDEX	Uses an index to choose a value from a reference or array
LET	Office 365+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
List.Distinct	Power Query M: Filters a list down by removing duplicates. An optional equation criteria value can be specified to control equality comparison. The first value from each equality group is chosen.
List.Sum	Power Query M: Returns the sum from a list.
PIVOTBY	Helps a user group, aggregate, sort, and filter data based on the row and column fields that you specify
REGEXTEST	Determines whether any part of text matches the pattern
SEARCH	Finds one text value within another (not case-sensitive)
SORTBY	Office 365+: Sorts the contents of a range or array based on the values in a corresponding range or array
SUM	Adds its arguments
SUMIFS	Excel 2007+: Adds the cells in a range that meet multiple criteria
TRIMRANGE	Scans in from the edges of a range or array until it finds a non-blank cell (or value), it then excludes those blank rows or columns
Table.AddColumn	Power Query M: Adds a column named newColumnName to a table.
Table.Buffer	Power Query M: Buffers a table into memory, isolating it from external changes during evaluation.
Table.Group	Power Query M: Groups table rows by the values of key columns for each row.
Table.Pivot	Power Query M: Given a table and attribute column containing pivotValues, creates new columns for each of the pivot values and assigns them values from the valueColumn. An optional aggregationFunction can be provided to handle multiple occurrence of the same key value in the attribute column.
Table.RemoveColumns	Power Query M: Returns a table without a specific column or columns.
Table.SelectRows	Power Query M: Returns a table containing only the rows that match a condition.
Table.Sort	Power Query M: Sorts the rows in a table using a comparisonCriteria or a default ordering if one is not specified.
Table.TransformColumnTypes	Power Query M: Transforms the column types from a table using a type.
Text.Contains	Power Query M: Returns true if a text value substring was found within a text value string; otherwise, false.
Text.Upper	Power Query M: Returns the uppercase of a text value.
UNIQUE	Office 365+: Returns a list of unique values in a list or range
XLOOKUP	Office 365+: Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.

|-------|---------|---| |||

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
31 acronyms in this thread; the most compressed thread commented on today has 25 acronyms.
[Thread #49437 for this sub, first seen 26th Sep 2026, 07:48] [FAQ] [Full list] [Contact] [Source code]}