You can download a financial statement file from your bank or financial institution and manually upload it to NetSuite for reconciliation or expense tracking. During processing, NetSuite encrypts financial data files for security. Once processing is complete, the files are deleted and not retained. When you import data for bank or credit card reconciliation, NetSuite applies reconciliation rules to automatically match the imported bank lines with corresponding account transactions.
Any bank lines that cannot be matched automatically remain available for manual matching on the Match Bank Data page. Once transactions are matched, you can finalize the reconciliation on the Reconcile Account Statement page. Reasons for performing a manual import include:
- You have a small amount of data already downloaded from your financial institution and stored on your local device.
- You need to upload a single file.
- You want to use the parser and configuration settings from an existing financial institution record to manually import a file.
To import a statement using CSV File:
- Open the CSV file
- On the Amount column, change the format and unmark Use 1000 Separator (,)
- Save the file
Note: Do not close the CSV file. - Reupload the file again
- Navigated to Transactions > Bank > Banking Import History > Upload File
- Select File
- Select Import with a default parser (CSV, OFX, QFX, BAI2, or CAMT.053)
- Select Account
- Click Import
- Click Track your Status on the pop-up window on the upper right side of the screen
Please be sure to have the CSV file ready in this format:
- Date (MM/DD/YYYY) – The transaction date. Content must be in the format of MM/DD/YYYY
- Payer/Payee Name – Counterparty name. Limit of 70 chars.
- Transaction ID – Unique Bank Transaction or Reference ID. Limit of 90 chars.
- Transaction Type – Values in this column must be one of the following transaction types, all uppercase: CREDIT, DEBIT
- Amount – The amount column must be a single column. If your file contains CREDIT and DEBIT columns, combine them into a single amount column. Positive amounts are CREDITS. Negative amounts are DEBITS, and must begin with a minus sign or be in parentheses.
- Memo - Transaction details. It must not include any commas, semicolons or underscores (please take them off it there is any)
- NS Internal Customer ID - Leave empty
- NS Customer Name - Leave empty
- Invoice Number(s) - Leave empty
If you want to learn more about the Bank Statement Import using CSV File in Netsuite, please contact Concentrus today to discuss your needs.
About Us
Concentrus is a leading provider of innovative cloud-based enterprise resource planning (ERP) solutions, including NetSuite. Our team of NetSuite experts offers a range of services, including NetSuite price analysis, NetSuite training, and NetSuite integration services.
Our goal is to help businesses of all sizes maximize their investment in NetSuite by providing expert NetSuite cost optimization and implementation strategies. With years of experience as a NetSuite partner, our NetSuite administrators and NetSuite consultants are well equipped to help businesses of all sizes with their NetSuite consulting needs.
Whether you're looking for a NetSuite consultant to help with your NetSuite implementation or you need ongoing NetSuite support, Concentrus is here to help.
Read About Our Implementation Methodology
Want more NetSuite Tips and Tricks? Check out our Short & 'Suite videos