Import General Ledger Transactions
Third party companies or programs often provide export files containing payroll or credit card transaction information that can be imported into ACS.
Typically, these are CSV (comma separated value) files: simple text files with field values separated by commas.
- Under Manage Records, click the Transactions tab.
- In the drop-down list, select General Ledger Transactions and click Go
.
- Click Add/Edit Transactions, then Import.
- Click Browse, locate and select the CSV file you want to import, and click Next.
- If you have saved mappings previously and want to reuse one, use Select a mapping. You can also edit or delete the mapping. If you are not using a previous mapping, click Create a new mapping from your import file. Click Next.
- On the Configure tab, specify what information ACS should check for in the import file.
- On the Mapping tab, select the Import Field that you want to correspond with each ACS Field.
- On the View Import Data tab, preview a sample of the values that will be imported. Click Next.
- A data preview page displays. Only error-free transactions will be imported. When ready, click Import.
If you imported without resolving all errors, the problem transactions must be manually entered using Add/Edit Transactions.