Bank Feeds - Sage Intacct Data Target Requirements

DataBlend supports the creation of Bank Feeds into Sage Intacct once an Account Reconciliation has been pushed into Sage Intacct. You will need to create a bank feed separately for each bank account that is present in the instance of Sage Intacct separately and push as a separate data target into Sage Intacct.

Bank Account Transaction Feed:

Name

 

Required

 

Type

 

Description

 

FINANCIALENTITY

Required

string

Bank account or credit card account ID

FEEDDATE

Required

Date

Feed date in format mm/dd/yyyy

FEEDTYPE

Required

string

Feed type to create. Use xml to provide the transactions in XML format, or use onl to use online bank feeds through Sage Cloud Services.

FILENAME

Optional

string

File name that displays in the UI when using automatch with review (AutomatchReview) as the reconciliation mode.

BANKACCTTXNRECORDS

Optional

BANKACCTTXNRECORD[1..n]

Bank account or credit card account transaction records. Required only if the feed type is xml.

 

BANKACCTTXNRECORDS:

Name

 

Required

 

Type

 

Description

 

TRANSACTIONID

Optional

integer

Transaction ID of the bank feed transaction. This is available only for banking cloud transactions.

POSTINGDATE

Optional

date

Transaction posting date in format mm/dd/yyyy

TRANSACTIONTYPE

Required

string

Transaction type. Use withdrawal or deposit for a bank account, or charge or payment for a credit card account.

DOCTYPE

Optional

string

Document type

DOCNO

Optional

string

Document number

PAYEE

Optional

string

Payee

AMOUNT

Required

currency

Transaction amount. For a withdrawal, use a negative number.

DESCRIPTION

Optional

string

Description

CURRENCY

Optional

string

Currency