Check record Import – Data requirements

On attempting an import process for Check records, we have to prepare data such that both Body field accounts and line field accounts must be defined separately and should be set accordingly.

For preparing the CSV data, the body account should be repetitive along all the columns with the same internal id.
The body amount should also be repeated along the same check data.

The line account and amount fields can be kept as values present in the Item line fields of the Check.

Internal IDAccountAccount lineAmountAmount line
1714110102 Cash and equivalents : Account A61100 Professional Services : Management Services4300037000
1714110102 Cash and equivalents : Account A62100 Facilities & Operations : Information Tech & Telecom430006000
1714210135 Cash and equivalents : Account B62350 Facilities & Operations : Bank Service Charges1515
1714310130 Cash and equivalents : Account B62350 Facilities & Operations : Bank Service Charges1010

Leave a comment

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