Statement import from permanent TSB

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"

1 answer

Jan February 1, 2018
Public

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
#answer-4919

Please login or Register to Submit Answer