Bank Import

Compeat allows you to import bank statements to automatically clear transactions that match up to the Compeat items in the Reconcile Bank Statements screen. This screen allows you to setup configurations for importing bank files. Your financial institution should provide you with the necessary specifications to configure this screen. If they do not, it can be determined by manually inspecting a file in NotePad.

Once you have configured Compeat for bank import for a financial institution, you can import bank files using the Import Bank File utility.

Tips and Tricks
Although this screen stores file layouts for each different bank code, there is also a way to use one file layout to clear entries in all of your bank codes.

If you select Account Number as a field to be imported, this number will be matched up against the On Us # defined for your banks in the Bank Accounts screen. Using this number, you could receive a single file with entries in it for multiple bank accounts— in this scenario, Compeat will use the Account Number field to match up each entry to the appropriate bank account.

If an account number is not imported in the bank file, all entries will go to the bank code selected when you import the bank file.

baby_down.jpg Click to view/hide picture.

To create a new bank import definition, you must first select the bank that it will be used for. When you select Bank Import from the menu, you will be presented with a list of banks (defined in Bank Accounts). Select a bank from the list to proceed. The bank information will be displayed in the top of the screen.

Export Specifications

Use the following options to define your export specifications:

File Format

Specify the format used in the source file.

 Field Delimiter

For delimited files, specify the delimiter used, that is the thing used to separate one data field from another.

Options

Note: Text qualifiers are used with delimited data to indicate when punctuation (e.g., space, comma) is used as text rather than as a delimiter.

Field Conversion

Select field names or "Filler Space" from the left-hand frame and move them to the right-hand frame using the arrow buttons to build a conversion for your spreadsheet. Each field name represents a column of the source data that should be imported, and filler space represents a column in the source that should not be imported. Use the up/down arrow on the right to move a selected item within the list. If you are importing fixed width data, once you add an item to the right frame, you can change the field length by clicking the Set Width button.