Tag: Bank reconciliation

Unexpected Error in saving Bank Reconciliation Page

Requirement: The user would like to use the old Bank Reconciliation function which is the Reconcile Bank Statement page. While editing the Account record and unchecking  the Match Bank Data and Reconciliation Pages, it throws an error: “An Unexpected Error has occurred. Please click here to notify Support.” Solution Navigate to Lists > Accounting > Accounts Click Edit on a Bank Account… Continue reading Unexpected Error in saving Bank Reconciliation Page

Bank Reconciliation Import Template For matching data with Netsuite and Bank

Template file used for importing the bank reconciliation data. Date (MM/DD/YYYY Payer/Payee Name Transaction ID Transaction Type Amount Memo 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

Bank Reconciliation Report Using Saved Search

Construct the Reconciliation report using the saved search. Create a new transaction saved search based on the criteria below: Account Type is Bank Posting is true   Date is on or before today   Cleared is True for Reconciled Transaction And the Result fields are as follows: FIELD SUMMARY TYPE FUNCTION FORMULA CUSTOM LABEL SUMMARY… Continue reading Bank Reconciliation Report Using Saved Search

Bank Reconciliation details at the Starting Process of the first Statement

Bank Reconciliation When processing the very first Bank statement, you can use the “Bank Start” and “Enter Statement Balances” as a check but this isn’t necessary. The fields should be populated as-is: The Bank Start Balance is the closing balance of the previous statement. As this is the first statement imported into NetSuite for this… Continue reading Bank Reconciliation details at the Starting Process of the first Statement