Check out the updated Prepare for Evolution section for the latest training schedules/recordings and support articles.

Open navigation

Xero | Where did client deposits from NetSuite sales orders go?

This article outlines the procedure for handling client deposits from NetSuite after migration to the Evo Platform. 


_____________________________________________________________________________________________


What happened to Client Deposits?


Did you have client deposits applied to sales orders in NetSuite as of your books balanced date? Client deposits in NetSuite are typically coded to the 'customer deposit' account, and the balance of this account would have been imported into your Xero account on your conversion date. 


The customer deposit account is a liability account and should be regularly reviewed to ensure that the balance remains accurate.


If you had client deposits allocated on NetSuite sales order that lowered the total amount owing on the invoice, this application will need to be replicated in Xero. Invoices migrated from NetSuite should be appear in awaiting payment status in Xero, and you need to lower the outstanding amount by adding a payment to the invoice and selecting the account 'customer deposit' account.  This will offset the balance in the customer deposit account.


Important note:

This process should only be followed for clients who had deposits recorded in NetSuite. For deposits taken after migration to the Evo Platform, please see the process for create a prepayment


_____________________________________________________________________________________________


Procedure

  1. In Xero, open the invoice
  2. Click Add Payment.
  3. Enter the date you applied the deposit to the invoice.
  4. Select the customer deposit account.
  5. (Optional) Add a reference.
  6. Click Add.


_____________________________________________________________________________________________


Example:

  • Books balanced date = 31 May
  • Deposit: taken and applied to the Sales Order prior to conversion date of 1 June.
  • Job /service completion: Invoice created on 3 June. The deposit flows through to the invoice, lowering the outstanding balance. 

In this case:

  1. Navigate to Xero and open the invoice
  2. Click Add payment. 
  3. Enter the date the deposit was applied to the invoice (3 June). 
  4. Select the customer deposits account.
  5. (optional) Add a reference.
  6. Click Add.



_____________________________________________________________________________________________



Customer deposit account not appearing on your dropdown?

If you cannot find the customer deposit account in the dropdown when adding a payment:

  1. Navigate to chart of accounts 
  2. Click on account name 
  3. Tick enable payments to this account.



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.