IRIS Enterprise - Import Bank Reconciliation using PostTrans

This PostTrans spreadsheet allows the user to easily Import Bank Reconciliation data into Exchequer Enterprise.   It uses a series of tags, placed in row 1, to identify the data to be Imported.  These tags can be easily added to a spreadsheet using the [Design] button, on the PostTrans Toolbar.  The data is read from row 3 onwards, which allows you to put user descriptions in row 2.  Click here for more Information on Designing templates.

The "GL and bank rec" Example shows this in action.  Click here for more information on PostTrans examples

Demonstration Videos   

Show me a demonstration video

Importing new Bank Reconciliation data

Simply add new lines to the spreadsheet from row 3 onwards.  Then press [Post Transactions], on the PostTrans Toolbar,  to import Exchequer Enterprise data.  

The Automatic Bank Reconciliation is then performed in Exchequer Enterprise as normal.

Bank Reconciliation  Required fields

To Import Exchequer Enterprise Bank Reconciliation Data, the following Tags/Fields must be specified:

ABPosted, ErrorDesc, BankRef, BankValue, and TransDate

Cell A1 must equal ABPosted

BankRefis used to detect end of spreadsheet.  PostTrans will stop Importing/Amending, from row 3 onwards, when this field is empty.

The Default GL code for the Bank account can be set in System setup.

Restrictions

None known

Exchequer Enterprise General Ledger Fields Available for update:

The following Tags are used to identify the corresponding fields in Exchequer Enterprise.  Use the [Design] button (or Ctrl+Shift+D), on the PostTrans Toolbar, to access these tags.   Click here for more Information on Designing templates.

PostTrans: PostTrans for Exchequer Enterprise Prices

Import PostTrans for Exchequer Enterprise Transactions, PostTrans for Exchequer Enterprise Customer/Suppliers, PostTrans for Exchequer Enterprise Stock, PostTrans for Exchequer Enterprise BOM (Bill of Materials) (, PostTrans for Exchequer Enterprise  Price Matrix, PostTrans for Exchequer Enterprise Alternate Code DB, PostTrans for Exchequer Enterprise Job, PostTrans for Exchequer Enterprise Job Analysis, PostTrans for Exchequer Enterprise Job Rates, PostTrans for Exchequer Enterprise Employee, PostTrans for Exchequer Enterprise Order from cheapest supplier, PostTrans for Exchequer Enterprise Enhanced Reorder, PostTrans for Exchequer Enterprise Serial/Batch and Multi-Bins, PostTrans for Exchequer Enterprise Examples included

  [ More about Exchequer Software ]  [ IRIS Enterprise Software ] [ WebRangle Linking ]

Last modified: August 18, 2006