I was a little disappointed to find that there’s no simple way of generating statements from the Monzo app, so I set about creating my own permanent record by exporting “all spending” to a CSV file and importing the data into a spreadsheet.
I found that the data doesn’t contain a running balance (as one would normally see in a bank statement), so I inserted a column and calculated the balance after each transaction. I then found that the sum of all credits minus the sum of all expenditure didn’t equal the current balance shown in the app.
This discrepancy is wholly explained by the presence in the CSV file of several duplicated transactions, where each series of duplicates is a few seconds apart and refers to a single real transaction. For example:
|2017-10-14 15:22:86 +0100|-£29.97| |2017-10-14 15:22:02 +0100|-£29.97| |2017-10-14 15:21:21 +0100|-£29.97|
After removing all the duplicates from the file, the sum of credits minus the sum of debits does indeed equal the current balance, as expected.
This all means that the CSV export is less useful than it could be and leads to three “wishes”:
- Remove the duplicate entries from the CSV export
- Include a running balance column
- Ideally, provide a PDF statement facility as well as the CSV export