NEUS-44
For the Bank Reconciliation process in NetSuite, we need the actual transactions to be there in Netsuite along with the statement in the CSV format uploaded in the system.
For uploading transactions in Netsuite, we need to import the transaction that affects the bank GL accounts. The transactions that affect the bank account are below.
- Cash sale
- Journal
- Intercompany journal
- Advanced IC Journal
- Invoice payment
- Bill payment
The below transactions have no import option:-
- Customer deposit
- Customer refund
- Fund transfer
In this list for uploading the Invoice payments and bill payments, there are two options for us.
Option 1: We can first Import the invoices and bill records and then import the related payments. This option is used when we need all the details of invoices and bills, its correct transaction date, and its related payments, the related reports, etc In here there will be 4 sets of imports.
- Bill import
- Bill payment import
- Invoice import
- Invoice payment import
These for import files need to be provided to us so that we can import it into the system.
Option 2: We can Import the journal entry with a suitable memo for payment-related entries for both bill/invoice payments.If we need only bank payment entries and related customer/vendor name, then we can create journals. So if we create journal entries, then we cannot identify the bills and invoices for which the payment entry is created but we can add it in the body/line memo for journal lines.