Below are notes for specific codes.
Note: Bank names have been removed to retain privacy.
1182
This format is unique in that it contains address information in the file. This information may not be readily available in many accounting systems and the data may need to be massaged into an Excel / csv file as noted below.
Excel / csv file imports
When importing an Excel or csv file, make sure that you map the fields for the address block:
Address_Line_1 (this is the payee)
Address_Line_2 (typically the street address)
QuickBooks
If you are importing from QuickBooks Pro, Premier or Enterprise, the system automatically imports the required fields.
If you are using an alternative location for the company name that you are printing on checks, you can select it from the drop down located on the QuickBooks Integration Window > Settings tab > Common Settings > 'Use alternate names in transmission'
Technical notes:
--This bank express code output file uses a new output field: Address_Line_1_v2
This field is designed to work with the this new code 1182.
What makes this format unique is the Transaction Type field (three positions in length) in the output file.
*10 Issue Add
*11 Issue Delete
*26 Void Add
*27 Void Delete
Excel / csv file imports - Daily Operations
For most daily operations, the value for this field will be:
*10 Issue Add
*26 Void Add
These values (*10, *26) can be created by importing simply the typical fields needed to create a file, such as: Date, Check Number, Payee and Amount (or Amount_Reverse_Sign, Debits/Credit, etc...).
Excel / csv file imports - Cleanup, use of delete
However, for cleanup or advanced users - you may need to include the *11 and *27 codes to delete records from your bank's system. You will need to map the Action Indicator field.
Action Indicator field
The Action Indicator field should contain a D (a single letter, capital D) for the records you want to delete.
Any other value will indicate an add. Therefore the following values will indicate and add: blank, (null), A, Add or anything else. Only a 'D' will indicate a delete.
In the example below, only the 2nd record - check # 45001 will be marked as a deletion.
QuickBooks - Daily Operations
If you are importing from QuickBooks Pro, Premier, Enterprise or Online, the system automatically imports the data and assigns it to:
*10 Issue Add
*26 Void Add
QuickBooks - Cleanup, use of delete
As QuickBooks does not have any flag or value/field to assign a deletion - it cannot be used to create deletes. To create deletes, export your data to an Excel or csv file - and then add a column and mark the records to delete with a 'D' (see Excel/csv above).
