AutoClerk Interface to Back Office Accounting Software
This Interface has been tested and approved for DataPlus, MAS90 and Business Works.
This document describes the data layout for how AutoClerk communicates with a back office accounting program.
On a daily basis AutoClerk creates a file, which is an export journal that contains the day's dollar activity, and units rented activity broken out by account categories. Both room revenue and units rented are reported by rate class. All other account categories give the totals for the day by account category. The export journal file is an ASCII fixed-field text file created in directory /Autoclerk/data/mas90 on the hotel's AutoClerk server with the following layout:
| Field | Data Description | Date Type | Character Position | Length |
|---|---|---|---|---|
| 1 | Account number | account | 1 | 9 |
| 2 | Account description | String | 10 | 30 |
| 3 | Transaction date | date mm/dd/yy | 40 | 8 |
| 4 | Source journal | string | 48 | 2 |
| 5 | Journal number | partial date ddmm | 50 | 4 |
| 6 | Sequence number | zero fill | 54 | 3 |
| 7 | Application code | string | 57 | 2 |
| 8 | Posting comment | string | 59 | 40 |
| 9 | Transaction amount | numeric | 99 | 13 |
The export process uses a configuration file: Autoclerk/data/etc/mas90.txt, which translates AutoClerk account categories to the export journal "Account" code.
If AutoClerk is properly configured then totaling an export journal's far right column (field #9) with the exclusion of units rented entries will result in a journal total of $0.00.
