What it does
ACS import screens expect a file in a specific layout: particular columns, dates written a particular way, and amounts as plain numbers. Exports from other systems rarely match. ACS File Converter lets you drop in a CSV, tell it which of your columns is which, and download a new CSV that is ready to import.
How it works
- Choose your platform. Pick ACS Realm or ACS OnDemand, so your file is formatted for the right import.
- Upload. Drag in a CSV file, or choose one from your computer.
- Map. Choose which column in your file goes into each ACS field. Common column names are matched automatically, and you can save your mapping for next time.
- Review. Dates, amounts and required fields are checked, and anything that needs attention is shown first.
- Export. Save the converted CSV and import it into ACS.
Supported destinations
- ACS OnDemand: available now, using the general ledger import.
- ACS Realm: available as an early version. We're still refining it.
Your data
There are no accounts. Your file is read and converted inside your own browser, and you can upload, map and preview your conversion freely. To export the full file, we ask for your work email address.
We store your email address, the destination you chose and the number of rows exported. If you choose to remember a column mapping, it is saved only in your browser and it holds column names.