How To Upload A Bank Statement & Reconcile It In NetSuite


Below is a TrueCloud tutorial on how to import online bank statements as well as complete a bank reconciliation in NetSuite.

Click on the tutorial video for a step-by-step walk through.

Additional information you may want to consider are the file formats, actions sets needed and transaction types. They’re listed in detail for you below.

Importing Online Bank Statements

Once your banking data has been downloaded from your financial institution or credit card company you can import the data into your NetSuite account.

You can import bank statements in the following formats:

  • OFX (Open Financial Exchange)
  • QFX (Quicken Financial Exchange)
  • QIF (Quicken Interchange Format)


Reconciling Bank Statements
Keep your NetSuite account accurate by reconciling your statements.  NetSuite gives you the ability to manually mark transactions as “cleared” in the check register process.  When you reconcile a bank statement, all reconciled transactions are automatically marked cleared. Transactions must be both cleared and…

View original post 75 more words