if you have trouble formatting this way, you could also try to get this data with a webservice (that is how I usually export to software like Sage).
You can write a webservice in your preferred language and build a workflow which hands over the data you need to your webservice.
The service now parses the data in the way you need, outputs it as .csv / .txt or whatever file ending you need and places it on a shared drive.
Hope this helps.
Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant