Tag: Bank reconciliation

Journals via Auto-create rule from Selected transactions

Instead of manually creating individual account transactions and matching them to imported bank lines, we can automate both these processes using auto-create rules. Auto-create rules enable us to automatically create and match the transactions. But unfortunately, NetSuite can do this only for following transactions: Deposits and charges for general ledger bank accounts Charges and refunds for general… Continue reading Journals via Auto-create rule from Selected transactions

Reconciling bank transactions from Account Register

We can use bank and credit card account registers to manually mark transactions cleared. Transactions cleared through a register appear on Reconciliation Summary and Reconciliation Detail reports, under the appropriate heading. However, they do not appear in Reconciliation History reports. To mark transactions cleared: 1.Go to a bank or credit card account register in one of… Continue reading Reconciling bank transactions from Account Register

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