When a customer has made a pre-payment on a Sales Order but no invoice exists in NetSuite to match to. The Bank Reconciliation tool will allow the user to match the transaction to a Sales Order is converted into an invoice, the pre-payment will be automatically be already applied to the invoice.
Step-by-step guide
- In the bank account configuration, make sure the following option Matching Preferences option "Match deposits for sales orders on document number / parameters" is ticked:
Setup > Bank Reconciliation setup > Bank Account Configuration > (select the account configuration record you want to be able to match the prepayment to the Sales Order to) > Matching Preferences
...
3. Select the customer name of the open sales order under the "NAME" column
4. This will open up the "POPUP" screen which will display all open transactions for the selected customer, including any open sales orders.
5. Apply the amount of the transaction to the required sales order and click on "Submit".
6. The amount has now been applied to the open sales order. Once If the user has completed the other transactions on the bank statement, click on "Save" in order to submit the transaction(s) on the bank statement. Once processed the Fast Four Bank Reconciliation tool will create a customer deposit customer deposit against the selected Sales Order. On the bank statement you will see that there is a Customer Deposit number allocated after it has processed:
7. When in the sales order you can see To find the deposit back, go into the Sales Oder and you can find the deposit under "Related Records" tab. 
8. At the time the Sales order is made into the invoice, the payment is automatically applied to the invoice and the amount owing is reduced by the deposit(ed) amount(s).
| Info |
|---|
| Once After the payment has been generated from the bank statement, no further user action is required. Any future payment payments made on the invoice will apply to the open amount. |
...