Checking Account Reconciliation - Sage Intacct Data Target Requirements

In order to pass Bank Feeds into Sage Intacct through DataBlend, you must first create a reconciliation.

Name

 

Required

 

Type

 

Description

 

FINANCIALENTITY

Required

string

Checking account ID

STMTENDINGDATE

Required

date

Statement ending date

CUTOFFDATE

Optional

date

Cut-off date for the reconciliation, which is the date from which you want to reconcile transactions. Required only for the first reconciliation. This date can be the day before you transitioned to Sage Intacct, or another date if you don’t want to go all the way back to when you first started using Sage Intacct. (Typically, it’s the day before the statement start date.)

STMTENDINGBALANCE

Required

currency

Statement ending balance, can be pushed as 1 then updated in the User Interface

MODE

Required

string

Reconciliation mode. Use Automatch to attempt to clear all the transactions or AutomatchReview if you want to view/complete the open reconciliation in the UI. Force to AutomatchReview

FEEDTYPE

Optional

string

Bank transaction feed type. Use xml for a bank feed created with XML records, or onl for an online bank feed from Sage Cloud Services (Default: xml).

SUPDOCKEY

Optional

string

Attachment record number