Sage Mas 90 and Mas 200 General Ledger module Utility Menu has a General Ledger Exchange option that allows you to import and export
GL Account numbers, Budget figures, and GL Transactions to/from a variety of formats, including excel spreadsheets. One tricky thing about this is that the excel-spreadsheet format is hidden in the G/L Exchange FAQ entries in the help text which takes 2-3 clicks from the help button on the exchange screen (and some searching) to locate. For all those who may have missed this info, here are the formats for your source spreadsheets:

GL Transaction data fields that can be imported using either the Alternate Exchange format or the Standard Exchange format, depending on the length of your GL account numbers.

Alternate Exchange Format – for 9-digit or less GL Acct #’s
Account Number 9 characters maximum (not including separators)
Account Description 30 characters
Transaction Date 8 characters Must be formatted MM/DD/YY.
Source Journal 2 characters
Journal/Register No 4 characters
Line Sequence # 3 characters
Source Module 2 characters
Reference Descr 40 characters
Posting Amount Numeric
Posting Comment N/A

Standard Exchange Format – for greater than 9-digit GL Acct #’s
Account Number 41 characters maximum (including separators)
Account Description 50 characters
Transaction Date 10 characters Must be formatted as YYYY-MM-DD.
Source Journal 2 characters
Journal/Register No 6 characters
Line Sequence # 14 characters
Source Module 2 characters
Reference Descr N/A
Posting Amount Numeric
Posting Comment 2048 characters

For more assistance on this subject, call Friendly Systems support at: 678-273-4010 ext 2

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>