Delimited files are simple text files with a series of values separated by a comma or other character. Each row in the file is a transaction and the values in each row are considered columns.
MoneyWell gives you a lot of control over your import layout. You can select the date and number format in the same way as you would a QIF import, plus you get to assign which fields in MoneyWell correspond to the columns in the delimited file. You can also save a layout and give it a name to reuse it in the future. In fact, MoneyWell will automatically reuse it based on the account you have selected.
Check the "First row is a header" option if the file looks like it has column titles in the first row. These will help you assign fields to your columns.
Change the "Delimiter" until you see all your columns broken out in the "Review Data" table in the lower right. Most files use commas or tabs, but there are some that use semicolons or colons as delimiters
Lastly, assign fields to each relevant column by clicking on the popup in the "Assign Fields" table in the lower left and picking a field. Below are some tips as to which fields are critical:
- Amount - This is a critical field and must be assigned to a transaction unless there are two amount columns (see below).
- Amount (Debit/-) - Use this amount field if you have both credit and debit columns in your file. This is for the debit or negative numbers.
- Amount (Credit/+) - Use this amount field if you have both credit and debit columns in your file. This is for the credit or positive numbers.
- Bucket Name - This is an optional field and is rarely included in delimited files. Using this will assign a bucket to the imported transaction based on the information in the file.
- Check Ref. - Only select this field if the column truly contains check numbers. If there is a check number during import, MoneyWell will set the type to Check and force the amount to be negative.
- Date - This is a critical field and must be assigned to a transaction or it will have no date.
- Memo - This is an optional field and will assign the column value to the memo of the transaction.
- Payee - This is a critical field and should be assigned to a transaction.
- Type - This is optional field and rarely used. Do not use it unless the amount is always positive in the file and the type column is the only way to determine debit versus credit.
- Unique ID - This is an optional field and rarely used. If you use this, make sure these values are indeed unique. If not, MoneyWell will discard duplicate transactions with the same value in this field and your imported information will be incomplete.
Here are some basic rules to follow:
- Don't assign the same field to more than one column. You may think that using the memo field multiple times concatenates the values, but it won't.
- Don't use the Amount field if you are also using the Amount (Debit/-) and Amount (Credit/+) fields—pick the one or use the pair.
- If you use the Type field, make sure that the common name for the deposit type is in the comma-separated "Deposit Types" string.
Once you have the settings correct, give the layout a name. Click New Layout before making any layout changes if you want to keep an existing layout. MoneyWell automatically links the selected layout with the selected account after you perform an import. This means that the next time you select an account and try to import a delimited file, the proper format is automatically chosen for you.