Do you think you could add statement import for permanent TSB? The format is very similar to the one you request for ‘Other Banks’. Just the column headers are a bit different and there is an additional ‘Balance’ column which you could ignore. Here is an example:
"Date","Description","Money in (€)","Money out (€)","Balance (€)" "26 Apr 16","Debit Card Charge","","2.01","3,218.10"
Just if this helps anyone. I’ve been using the following Excel Macro for the last year to convert PTSB statements to Bullet’s ‘Other’ format. Saves a lot of time.
aSub PTSB_Transactions_Bullet()
'
' PTSB_Transactions_Bullet Macro
'
'
Columns("A:A").Select
Selection.NumberFormat = "dd/mm/yyyy;@"
Columns("D:D").Select
Columns("E:E").Select
Selection.Delete Shift:=xlToLeft
Columns("C:C").Select
Selection.Cut Destination:=Columns("E:E")
Columns("C:C").Select
Selection.Delete Shift:=xlToLeft
Range("C1").Select
ActiveCell.FormulaR1C1 = "Money Out"
Range("D1").Select
ActiveCell.FormulaR1C1 = "Money In"
Columns("A:A").Select
End Sub
Hey Jan,
Thank you very much for sharing this info, it is really very helpful! You’re the best:)
Mariana
