Bank Reconciliation Import Template For matching data with Netsuite and Bank

Template file used for importing the bank reconciliation data.

Date (MM/DD/YYYYPayer/Payee NameTransaction IDTransaction TypeAmountMemo
NS Internal Customer ID

NS Customer Name
Invoice Number(s)
date in the format
*mandatory
Name of payer
*mandatory
Transaction id
*mandatory
Type of transaction Eg: DEPOSIT
*mandatory
Amount
*mandatory
*Not Mandatory*Not Mandatory*Not Mandatory*Not Mandatory

Leave a comment

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