XML Format

Use this format to create a file used to import data into XML-compatible software, such as eFinancials or AMSI QuickBooks loader for importing into QuickBooks.

The XML format has a root element of <GLTRANSACTIONS> with an element of <GLTRANSACTION> for each transaction. Each GLTRANSACTION element has a number of attributes with the field values. The following table lists each attribute. There are numerous data values in this file, many of which are normally ignored by the importing software.

Attribute	Description
userId=	eSite user who created the file.
A.PropertyId=	Property ID. Normally ignored.
ReportDate=	MM/DD/YYYY. System date when file created.
Entity=	Entity ID. The G/L entity to post to.
PostPeriod=	YYYYMM. Fiscal period.
TransType=	Transaction Type*
IncCode=	Income Code*
VariableKeyForPost=	GL Account/Transaction Description/Income Code* Normally ignored.
DrCrFlag=	D for Debit or C for Credit. Normally ignored. Use the sign of the amount instead.
VariableKeyForPrint=	Internal information. Normally ignored.
SiteId=	Blank
TransferId=	Sequential identifier. Normally ignored.
BbNo=	Bank Book Number*
JournalNo=	Batch Number*
GlAcctNo=	GL Account Number*
AcctProfitCenFlag=	Y for Yes; N for No.
AcctProfitCen=	Profit Center, if profit center flag is Y.
AcctXferToGl=	Summarization method*
DateOfRecord=	MM/DD/YYYY, normally ignored and posting period used instead.
AmtToGl=	Amount of transaction
GlDesc=	Description/Income Code* (Maximum imported amount into eFinancials is 40 characters.)
TransEntryType=	JE for Journal entry, DP for Deposit, CR for Cash Receipt
RefCheckNo=	AUTOxx/AUTPxx*
PostFlag=	Y for Yes; N for No. Normally ignored.
CurrAcctPrd=	YYYYMM. Current period of the property. Normally ignored.
/>

Example: