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 the parent accounts payable and the accounts payable sub-account for the supplier. The actual total balance of accounts payable would be imported in the trial balance import. If your outstanding bills have multiple lines, you would just include the total outstanding amounts from all the lines. No additional detail is imported for bills because we are only tracking the outstanding amounts for the purpose of paying them off later.
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
0 comments
Please sign in to leave a comment.
Related articles