You are here

Home › Theatre Manager Online Help › System Setup › Company Preferences › Accounting Tab › Export Format Options

Sage Intacct

Subscribe to Syndicate
Theatre Manager will create a comma-delimited text file (.csv) that can be used to import into Sage Intacct accounting software. Sage Intacct's ability to create unique accounts, locations, departments, and classes for each GL account requires the setup of Theatre Manager's External Account field to be set in a specific format to accomodate the various aspects of the Intacct export file, prior to performing the first export.

 

Sage Intacct

The Sage Intacct exports each detail line within the G/L Entry. Each deposit and sales posting are exported as their own separate entry within the export file. This allows an exact match of each G/L Entry to crossover into Intacct (line for line).

 

Parts of the Sage Intacct Export File

DONOTIMPORT Do Not Import flag - Any row which starts with a # will be ignored during the Intacct import.

Theatre Manager does not populate this field during the export process.

JOURNAL A valid Journal Type within Intacct representing the type of journal entry. The field is limited to 4 characters.
  • The value ARJ for Accounts Receivable Journal Entries, will be used for Sales Postings.
  • The value CRJ for Credit Receipts Journal Entries, will be used for Deposit Postings.
  • The value GJ for General Journal Entries, will be used for Manual G/L Entries.
DATE The Journal Entry Date for this G/L Entry. The date will be in a MM/DD/YYYY format.
DESCRIPTION The Journal Entry Description for this G/L Entry (Sales Posting, Deposit Posting). The field is limited to 80 characters.
REFERENCE_NO Journal Entry Reference Number. The Journal Number for this G/L Entry (SP-0001318, DP-0001255, GL-2020351).
LINE_NO A sequential Line Counter for each exported entry line. Line numbers begin at 1 and increment by 1 for each associated entry line. The Line Counter ID will reset back to 1 again for each new Sales Posting, Deposit Posting, or G/L Entry exported.
ACCT_NO The Intacct account number. Theatere Manager's External Account value (name or number) will be used to create the export file.
LOCATION_ID An associated Location ID to the Account Number. Theatre Manager's External Account value (name or number) will be used to create the export file.
DEPT_ID An associated Department ID to the Account Number. Theatre Manager's External Account value (name or number) will be used to create the export file.
GLENTRY_CLASSID An associated Class ID to the Account Number. Theatre Manager's External Account value (name or number) will be used to create the export file.
DOCUMENT The Document Reference for this G/L Detail Line. The field is limited to 30 characters.

Theatre Manager does not populate this field during the export process.

MEMO The memo text for this G/L Detail Line. The field is limited to 1000 characters.
DEBIT The debit amount for this G/L Detail Line. A blank value is used for $0.00 amounts.
CREDIT The credit amount for this G/L Detail Line. A blank value is used for $0.00 amounts.
REVERSEDATE The Reverse Date for this G/L Entry. The date will be in a MM/DD/YYYY format.

Theatre Manager does not populate this field during the export process.

SOURCEENTITY Refers to a valid Location within Intacct. The field is limited to 20 characters.
Required only when the option to auto-create inter-entity transactions is enabled for journal entries and the journal entry is not balanced by location.

Theatre Manager does not populate this field during the export process.

CURRENCY A valid Currency ID within Intacct. The field is limited to 40 characters.
Any defined currency, such as USD or EUR; blank denotes base currency. Use only in multi-currency companies. This field defines the transaction currency. If no field is defined here, the system uses base currency.

Theatre Manager does not populate this field during the export process.

EXCH_RATE_DATE The Exchange Rate Date indicator for this G/L Entry. The date will be in a MM/DD/YYYY format.
Required field, unless the EXCHANGE_RATE is provided. Use only in multi-currency companies. This field determines the exchange rate as of this date.

Theatre Manager does not populate this field during the export process.

EXCH_RATE_TYPE_ID A valid Exchange Rate Type ID within Intacct. The field is limited to 40 characters.
Default Value: Intacct Daily Rate, unless a custom exchange rate is defined as the default.
Use only in multi-currency companies. Defines an optional custom exchange rate type. The system uses the Intacct Daily rate if no optional one is defined here.

Theatre Manager does not populate this field during the export process.

EXCHANGE_RATE The Exchange Rate for this G/L Entry. The field is limited to 17 characters, not including decimal point.
Defaults to the exchange rate of the CURRENCY on the EXCH_RATE_DATE for the EXCH_RATE_TYPE_ID. Must be a positive integer value.
Use only in multi-currency companies. Overrides the default exchange rate, which is the product of the CURRENCY, EXCH_RATE_DATE and EXCH_RATE_TYPE_ID.

Theatre Manager does not populate this field during the export process.

STATE The current State indicator for the G/L Entry.
  • Draft for draft state.
  • Posted(default if not supplied) for posted state.

Theatre Manager does not populate this field during the export process.

ALLOCATION_ID A valid Allocation ID within Intacct. The field is limited to 50 characters.

Theatre Manager does not populate this field during the export process.

BILLABLE The Billable for this G/L Entry.
  • T for billable.
  • F(default if not supplied) for non-billable.

Theatre Manager does not populate this field during the export process.

GLENTRY_CUSTOMERID A valid Customer ID within Intacct. The field is limited to 20 characters.

Theatre Manager does not populate this field during the export process.

GLENTRY_VENDORID A valid Vendor ID within Intacct. The field is limited to 20 characters.

Theatre Manager does not populate this field during the export process.

 

Formatting the External Account Number

Theatre Manager's External Account number are required to be set up in a specific format to accomodate the various aspects of the Sage Intacct export file.

The format of the External Account varies based on the purpose of the GL Account. The format of this field is required to have a backslash (\) used as separator between fields. A leading or trailing backslash (\) for the External Account field should not be added.
  • (Accounts with No Location, No Dept, No Class) The field formation will be A23456789
  • (Accounts with Location, No Dept, No Class) The field formation will be A23456789\L2345
  • (Accounts with Location, Dept, No Class) The field formation will be A23456789\L2345\D23456
  • (Accounts with Location, Dept, Class) The field formation will be A23456789\L2345\D23456\C23456
  • (Accounts with No Location, Dept, No Class) The field formation will be A23456789\\D23456
  • (Accounts with No Location, No Dept, Class) The field formation will be A23456789\\\C23456
ACCT_NO A23456789 - The account number that transactions get posted to.
The format of this field is defined within Intacct. If Intacct's accounts include a dash (-), include this dash (-) in the C23456 formatting at the appropriate position. For example: 00-0000 or 000-000 or 0000-00 etc.
LOCATION_ID L2345 - A predefined Location ID within Intacct. This ID is only required if Intacct requires it when using this account number.
DEPT_ID D23456 - A predefined Department ID within Intacct. This ID is only required if Intacct requires it when using this account number.
GLENTRY_CLASSID C23456 - A predefined Class ID within Intacct. This ID is only required if Intacct requires it when using this account number.

 

Diataxis: 
Reference