Just in case somebody tries to come up with a solution, I made some progress, so I can import the ascii table as org-table:
%(progn
(with-current-buffer (org-capture-get :original-buffer)
(call-interactively 'copy-region-as-kill))
(with-temp-buffer
"*import-temp*"
(erase-buffer)
(yank)
(org-table-convert-region (buffer-end -1) (buffer-end 1) 2)
(buffer-string)))
next step would be to extract the data from the columns replace the name
strings and format it in the ledger style.
