If the customer name, ID, and invoice numbers are all missing, the system cannot perform an exact match. When you import the statement, if the customer name and customer ID are both missing, NetSuite uses the invoice numbers to try to match the statement to a NetSuite customer. If the imported file specifies multiple invoices for a transaction, they must all belong to same customer and AR account. For each invoice number in the list, there is a limit of 128 characters. If you use a script or comma-separated file instead of the CSV template in a spreadsheet, put quotation marks around multiple invoice numbers (for example, “132,133,134”). Invoice Number(s) – (Optional) A comma-separated list of invoice numbers in a single field, with no spaces between numbers (for example, 132,133,134). If the customer name is missing, NetSuite checks for invoice numbers. When you import the statement, if the customer ID is missing, NetSuite uses the customer name to try to match the statement to a NetSuite customer. NS Customer Name – (Optional) If the specified customer ID does not match any data, NetSuite uses the value to look up the customer ID. If the customer ID is missing, NetSuite checks for a customer name next. When you import the statement, NetSuite uses the customer ID first to try to match the statement to a NetSuite customer. NS Internal Customer ID – (Optional) The NetSuite internal customer ID. The Memo field must not include any commas, semicolons or underscores. Memo (Optional) – There is a limit of 4000 characters for the memo. The amount currency should be in the same currency as the selected account. The amount column must not contain currency symbols or commas instead of decimal places. Negative amounts are DEBITS, and must begin with a minus sign or be in parentheses. If your file contains CREDIT and DEBIT columns, combine them into a single amount column. Transaction Type – Values in this column must be one of the following transaction types, all uppercase: CREDIT, DEBIT, CHECK, PAYMENT, ACH, INTEREST, DEPOSIT, TRANSFER, FEE, OTHER.Īmount – The amount column must be a single column. This can also be populated with the check number. Transaction ID – Unique Bank Transaction or Reference ID. If you are using Excel, ensure that the date does not get reformatted.
A one–digit month must be preceded by a zero. Content must be in the format of MM/DD/YYYY. The memo must not exceed 4000 characters and must not include any commas, semicolons or underscores.ĭate (MM/DD/YYYY) – The transaction date.