I’m Toby, a software engineer in the Business Banking team.
I just wanted to share a small product update for business accounts - your CSV transaction exports now have 2 new columns at the end, ‘Balance’ and ‘Balance currency’, which show your account’s running balance for each row in the CSV.
You can download a CSV export by tapping the 3 dots on your business card, tapping ‘Bank statements’, and then choosing a period and selecting the CSV format.
Hi Jake Good question - unfortunately we can’t add the running balance to the auto-export feature, because the data exported in that case is slightly different to the CSV statements.
The auto-export feature is exporting the transactions that appear in your activity feed, and the values of these transactions can sometimes change over time - for example if you use Pay at Pump, you might first see a transaction in your feed for the full amount of money being reserved in advance, and then that same transaction would later change to a lower amount once the exact fuel charge had been calculated.
On the other hand, once a row appears in a CSV statement, its value will never change after that point (similar to PDF statements). In the Pay at Pump example, you’d see a first row for the full amount being reserved, and then a separate second row for the leftover money being released after the exact fuel charge was calculated.
So we haven’t added the running balance to auto-exports, because those running balance values might become wrong over time - while that isn’t an issue for CSV statements. Hope that makes sense!
Many thanks for doing this, it’s something my accountant has whined about every time I’ve sent over a Monzo Business statement for each EOY accounts. It got bad enough I had to try and bodge my own column for them
