Uploading bulk transactions from a 3rd party provider into Accounts Hosted from any format (.CSV, .Q
We use NAB corporate cards so our staff can purchase what they need in the course of business without having to ask for approval. At the end of each month they use an online system to code their transactions, add descriptions, set the GST paid amount and advice the office of the cost center they are charging to. At month end we can download a .CSV file (of about 900 lines of transactions). Our current process is to 'enter bills' in RAH for each corporate card and each expense line. This takes 4 full volunteer days and has some fairly obvious issues I don't need to go into.
How can we import the transactions, while maintaining Classes, descriptions, payee, GST etc?
I have looked at the online banking functionality, but the subscriptions for the number of cards / transaction volume is prohibitive as well as the hurdle of the card provider not being part of NAB. Getting the data out and formatted is fine, getting it mapped and back in is the hard part.
Thanks for any help / advice / comments, happy to provide more details if I have missed anything.