Barclays CSV to Beancount

Barclays does not escape a comma inside a payee name, so that row leaves the bank with seven fields where every other row has six, and the payee splits in two at the comma. Every column this preset maps sits before the split, so the date and the amount on that row are still correct and only the narration is truncated. Retype the handful of affected narrations after converting, or quote the field in the file before you paste it.

That is the bank's window, not a limit of this page. Run the export several times, moving the date range back each time, and paste each file in turn — Beancount does not mind what order transactions arrive in, and you can sort the finished file by date afterwards. History older than the online window is available only as a PDF statement, which this converter does not read.

Number is a cheque number, and on a modern account it is zero on almost every row; Subcategory is Barclays' own transaction type — Direct Debit, Contactless Card Purchase, Counter Credit. Neither is mapped, because the payee is in Memo and the direction is already carried by the sign on Amount. If you want the transaction type recorded, add it as metadata after conversion rather than folding it into the narration.