Import of Account Receivable Information

Overview

To bring in outstanding accounts receivable information from your old system (any invoices to your customers with outstanding balances) into Versa, you can use the csv file accounts_receivable.csv. The amounts will be posted against a clearing account called Suspense Clearing and the accounts receivable account. If you have bring in the details from your old system, as you receive payment in Versa, you can record payment against. You just need to bring the outstanding amounts over. If the invoice has multiple lines in the old system, you will just import one line in Versa and this line contains the outstanding amount for the entire invoice.

If you choose not to bring your outstanding invoices over from the old system, you will still need to bring in the total account receivable balance over through Trial balance import.  You will not have a invoice to record payment against. As you receive payment for any of the outstanding invoices, you can do a GL entry to debit Cash account and credit accounts receivable.

The file template contains the following columns.
* are fields that are required.
Invoice Date*: The date of the transaction. In yyyy-mm-dd format.
customer_company_name*: The name of the company. A customer with the name must already exist in the system.
customer_given_name: First name of the contact person in the company.
customer_surname: : Last name of the contact person in the company.
Amount*: The amount that is outstanding on this invoice. (not the invoice total)
currency code*: The currency of the transaction. Use the 3 digit ISO 4217 currency code. USD for example.
Terms discount*: If the invoice has terms and a discount is given for early payment, put the discount % here. Put 0 otherwise.
Terms discount period*: If the invoice has terms and a discount is given for early payment, put the # of days before a discount is provided. Put 0 otherwise.
Terms net*: The # of the days before this invoice is overdue.