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
- Client Claim number (optional if you have the account number)
- Transaction Description (e.g. Payment – Check or Collection Fee) (Note: Collection Fee is a custom transaction description found generated under Financials à Advanced). Transaction descriptions should match those descriptions found under Financials à Advanced in your Simplicity software.
- Transaction Type (e.g. Adjustment, Cost, Payment, Client Payment, Netted Payment, Fee).
- Transaction Amount (e.g. 25.00, -25.00) *Required
- Transaction Date (in date format 12/31/2012)*Required
- Transaction Note (optional)
- 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)
Importing the transaction file:
- Click on Tools > File Importing > Transaction File 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.
- 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 Num you would click on this wording in the left most box, 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.
- If your transactions do not look correct, you can use the following options to fix them:
- Use the Rollback button to delete the import and start over again. The original mapping you used will still be available to edit.