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.
Kevin Suh, NetSuite Administrator

Recent Posts
Bank Statement Import using CSV File
Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Shipping, SuiteScript
Important Update for Shipping to Germany
UPS has a new regulatory requirement for shipping to Germany. Starting January 1, 2025, shipments weighing 10 kilograms or more will require clear weight labeling to meet compliance laws.
- 10-20kg packages: A 10+ KG icon must be displayed on the shipment.
- 20kg and above packages: A 20+ KG icon must be displayed on the shipment.
Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Shipping
Serial and Lot Inventory with Multiple Units of Measure
Using Multiple Units of Measure alongside Serialized Inventory or Lot Tracking gives you greater flexibility in handling sales, purchases, and inventory transactions for items in various units.
Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips
The Multiple Units of Measure feature allows you to define different units for stocking, purchasing, and selling inventory items, as well as tracking non-monetary accounts.
Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips
System Cost of Goods Sold Adjustments
When an in-stock item is sold, NetSuite decreases the inventory asset account balance and increases the Cost of Goods Sold (COGS) account balance. If an out-of-stock item is sold, NetSuite adjusts the on-hand value of that item with what's known as a "system COGS adjustment," which can appear on financial reports or within transactions.
Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips
CSV Import of Kit/Package Item record
Item records allow you to track and manage the goods and services your company buys and sells in the course of doing business. This can be done by using two files during the upload: one is for Primary, the other is for Item Members. Below are the steps:
Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, Inventory Management, NetSuite Tips, CSV Import
A fulfillment request serves as an intermediary transaction between a sales order and the actual fulfillment process in the order fulfillment workflow. Essentially, it is a request to fulfill a sales order. This process allows employees at a fulfillment location, typically a store, to manage orders that need to be shipped to or picked up by customers. At the store, employees can view, accept, reject, and process fulfillment requests to complete the order.
Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, Inventory Management, NetSuite Tips
Ability to show outstanding balances in Trial Balance Report
The Trial Balance is a report that displays the balance of each active account as of a specific date, typically the end of the month. The account balances are listed in both debit and credit columns. Accountants generate this report before creating financial statements to ensure that the debits and credits are balanced. Once the trial balance is in equilibrium, the financial statements can be prepared. To view the Trial Balance report, follow these steps: Navigate to Reports > Financial > Trial Balance.
Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips
NetSuite allows you to import current sales tax codes for the states where you apply sales tax. Every month, NetSuite refreshes its database with the latest tax rates for all U.S. states. The Version field on the State Tax Import page shows the date when the tax rate change becomes effective. NetSuite sources these tax updates from Wolters Kluwer, and you can find more information on their website at wolterskluwer.com.
Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Tax Codes, State Tax
You can use the Mass Updates feature to locate multiple records with outdated information and update all their fields at once.
Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Netsuite Updates, Mass Updates, functionality, NetSuite Scripts