If you have to import financial transactions into more than one account this can be easily accomplished with the Transaction File Importer tool.
Using the Transaction Importer
Make sure that your file has all of these columns with corresponding data in each row:
- Account Number OR Client Claim Number *Required
- Transaction Description (e.g. Payment – Check or Collection Fee) (Note: Collection Fee is a custom transaction description. Custom transactions can be created by going to the Financials tab on the debtor screen, then go to the sub-tab Trans. Descriptions). Transaction descriptions should match those descriptions found under Financials > Trans. Descriptions in your Simplicity software.
- Transaction Type (e.g. Adjustment, Cost, Payment, Client Payment, Netted Payment, Fee). *Required
- Transaction Amount (e.g. 25.00, -25.00) *Required
- Transaction Date (in date format 12/31/2012) *Required
- Does Not Affect Balance (optional) This can be used if you want the transactions to post on the account but not apply to the balance. This effectively posts and “voids” the transactions for you. To enable this, the rows must have the number 1 listed.
- Transaction Note (e.x. Check number 5647) (Optional)
See Examples below:
Importing the transaction file:
- Click on Tools > File Importing > Transaction Importer.
- Select the file you prepared with the transaction information from your computer.
- Click Prepare File for Uploading.
- For the first time that you import you will need to create a new mapping. Otherwise you can select a previously created map. (We suggest reviewing your mapping before each import to ensure that all fields are mapped correctly).
- Click on Create New File Map.
- Match the corresponding columns from your Excel or .csv file to the appropriate transaction element. (e.g. If your file has a column named Account Number then you would click on this wording in the left column, then click on Account Number in the middle box.) Between each association that you are creating click on Add>>. The association will then move to the Mappings box on the far right.
- Name the mapping on the top left where it says Mapping Name. Click Save New Mapping.
- Select your desired mapping from the Mapping drop-down list, and click Import Transactions. You have just imported your transactions. NOTE: Always download the results file. This file will inform you as to which transactions were not imported, if any, and will provide an error message for failed import attempts.
- If your transactions do not look correct, you can use the Rollback button to delete the import and start over again. The original mapping you used will still be available to edit.