WeconnectU provides the ability to create multiple supplier invoices by uploading an Excel template.

1. Uploading Supplier Invoices

Navigation: Global Overview > Finances > Payment  > Menu Options > Import Bulk Invoices

Download the template by clicking on the Download template file here, option in the pop-up screen.

An Excel document will be downloaded - which will look similar to the following.

Navigation: Open the downloaded Excel sheet

• Column A: Insert the relevant community code
• Column B: Insert General Ledger Code - example 2000/007
• Column C: Insert Date in format yyyy/mm/dd - format the cell to text first
• Column D: Supplier Code on WeconnectU system.
• Column E: Amount (VAT incl.)
• Column F: Description of invoice 
• Column G: Our reference Best practice would be to use the supplier code hyphenated to the invoice number received, e.g. SUP001-INV001 - this will allow for automated allocation of supplier payments.
• Column H: Supplier reference the reference that will reflect on the supplier's bank statement. 
• Column I: VAT (Y/N)
• Column J: Source Number optional - this is the invoice number 

Once all the relevant information has been added, please save the Excel document.

Once the file has been uploaded, the below screen will appear reflecting all the invoices which will be uploaded from the file.

The invoices will be listed on the Payment page under each community heading. Invoices are listed and sorted in date format. The latest date will be listed at the bottom.