To bring in outstanding accounts payable information (any invoices from your supplier/vendor with outstanding balances) into VersAccounts, you can use the csv file accounts_payable.csv. The amounts will be posted against an expense account called Suspense Clearing and the accounts payable account.
It contains the following columns.
* are fields that are required.
Bill Date*: The date of the transaction. In yyyy-mm-dd format.
supplier_company_name*: The name of the company. A supplier with the name must already exists in the system.
supplier_given_name: First name of the contact person in the company.
supplier_surname: : Last name of the contact person in the company.
Amount*: The amount that has not been paid on this bill (not the bill total)
currency code*: The currency of the transaction. Use the 3 digit ISO 4217 currency code.
Terms discount*: If the bill has terms and a discount is given for early payment, put the discount % here. Put 0 otherwise.
Terms discount period*: If the bill 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 bill is overdue.
description*: Supplier invoice number. Required if the setting to require supplier invoice no on bill is checked.
internal_ref: Internal ref of the bill number.
Comments and Suggestions
Please sign in to leave a comment.