Admins and Finance users can manually export a CSV to import all transactions to the NetSuite bank feed.
The file can be exported in Transactions tab > Filter results > Export > NetSuite:
In the CSV, you will find the following columns populated:
- Date
- The date when the transaction was made.
- Payer/Payee Name
- The merchant or the beneficiary name.
- Transaction ID
- The transaction ID from the database.
- Transaction Type
- Debit for outgoing payments and credit for incoming transaction.
- Amount
- The actual payment amount; “+” is money in and “-” is money out.
- Memo
- The merchant details, payment amount in the original currency and the conversion rate (if applicable).