PostTrans XL Visual Importer: Import Bank Reconciliation
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. more Information on Designing templates.
The "GL and bank rec" Example shows this in action. more information on PostTrans examples
Demonstration Video:
Features:
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 Bank Rec 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.
|
Tag Name |
Data Type Length |
Description |
|
Required: |
|
|
|
ABPosted |
Yes/No |
Returns 'POSTED' if Trans line has been posted and will be ignored if 'POSTED' (required) |
|
ErrorDesc |
Text |
Description of error posted back if record unsuccessfully posted |
|
BankRef |
Text 40 |
(required) |
|
BankValue |
Double |
(required) |
|
TransDate |
Date |
(required) |
|
Optional: |
|
|
|
BankGLCode |
Long |
|
|
Currency |
Integer |
0-29,1=Sterling, Optional (default=1) |