Loader

Taulia experience center

SUPPLIER SUPPORT SERVICES

What are suppliers currently asking Taulia?

TAULIA SUCCESS GUIDE

New to Taulia? There’s a guide for that! Let us guide you so you can quickly get started.

GET PAID EARLY

Finding capital for your business shouldn’t be complicated.Join the thousands of business who use Taulia to get paid early on their invoices.

I would like to:

What is Taulia

We are a technology company dedicated to helping simplify business transactions and increase cash flow through an easy to use platform.

The fine print

Taulia Support and the entire Technical Services team is dedicated in helping you succeed. To do that, we have policies in place to show our unwavering commitment to you. Take a moment to read through our support policies to learn more.

Home /

Support Topic

Q. How do I create invoices using the Invoice Upload feature?: 000008597

Article Number: 000008597

Note - This feature may not be available in your portal.

Invoice Upload allows you to easily submit multiple invoices at once through the Taulia platform by uploading a csv or xls file of the invoice and line item data. This will save you time when needing to create and submit a large number of invoices when compared to manually flipping POs into an invoice or creating non-po invoices through the Taulia platform. This feature also removes the need to create an API integration. The same invoice rules and validations apply (required fields, value tolerances, etc.) when submitting an invoice via the Invoice Upload feature.

There are two menu items for the Invoice Upload feature that can be found under the Invoices shortcut link:

1 - Upload Invoices: section where you can initiate the invoice upload process

2 - Invoice Upload History: displays a list of all past invoices that have been uploaded



You can upload your invoices by doing the following: 

1 -
From the homepage, select Invoices > Upload Invoices.

2 - Select the Download Template Invoice link to download and open the invoice upload csv template. 

  • The columns showing on the template are all possible fields but only a small subset of these are required to be completed. 
  • You must use these exact field/column names in your submitted file. You can remove any columns you don’t need. If you include extra columns that we don’t recognize, they will be ignored.
    • For PO based invoices, you must include:
      • PO Number (poNumber)
      • PO Item Number (lineItems.poItemNumber)
    • For Credit Notes, you must include:
      • isCreditNote TRUE
      • creditOriginalInvoiceDate
      • creditOriginalInvoiceNumber
      • creditReason
  • The fields returned in the .csv template will be tailored to meet the requirements of the customer you are invoicing (if your customer has custom fields configured). The custom fields will be included in your file in the following format:
    • buyerCustomField.{fieldName}
    • lineItems.buyerCustomField.{fieldName}


IMPORTANT - a header row must be included in your file and for every column.

3 -
 Each row in the file represents an invoice line item. Invoice number is required for every single row and invoice header data must be included in the same row as the first line item. Here is an example:
User-added image

Here is a sample .csv file with the invoice data included:

User-added image

There are some attributes that may not need to be provided in your file (they are optional), as they will be auto-populated by the platform when your invoices are submitted. 

  • All totals are auto-calculated (netAmount, totalTaxAmount, etc.)
  • Your tax identifier(s) will be looked up from your account and included on the invoice

If utilizing a .csv file, your dates must follow an explicit format of YYYY-MM-DD. For example, 2018-07-18. If you are using an xls/xlsx file, this does not apply.

For currencies, the 3 letter ISO 4217 code must be used (ex. EUR). For countries, the two-letter ISO 3166-1 code must be used (ex. IT).

The tax rates applicable to the country in which you are submitting your invoice can be found in this article: What tax rates are required for my country when creating an invoice?

4 - Save the csv template and go back to the Invoice Upload screen. Find the Select Invoice File button to upload your saved invoice template.

5 - Once the file is uploaded, select Submit Invoices to complete your invoice submission. 


6 - Go Invoices > Invoice Upload History and you will be taken to a page with a full history of all invoice files that have been uploaded for your company.  This page will have the following columns:

  • File Name: A link to the originally uploaded invoice file
  • Uploaded on: Date the file was uploaded
  • File Size: Size of the file
  • Uploaded by: Email address of the user that uploaded the file
  • # Successful: # of invoices that were successfully processed and submitted
  • # Failed: # of invoices that failed validation and were not submitted

User-added image

Immediately after submission, while your file is being processed, you will see “In Process” displayed instead of a successful/failed count. Once processing is complete, you will receive a link to download a Submission Report. This will contain a list of the invoices from your file and whether or not each invoice was successful or failed. You can also select Download Submission Report. All failed invoices will include a reason or a list of reasons why the invoice failed.

For invoices that failed, the invoice submission report will show the invoice error. Read the error carefully to understand what needs to be done to successfully submit the invoice.

User-added image

Repeat the process above to re-submit the invoice.

IMPORTANT: Click here to download all Invoice Upload fields and descriptions in following languages: English, French, Canadian French, Italian, German, Spanish, Polish, Portuguese, Dutch, Swedish, Chinese, Norwegian, Japanese, Korean, Slovenian, Greek and Czech. 



Additional FAQs

What is the difference between the Invoice Upload feature and invoice submission through eForm, eFlip, eFile and eSend?

  • Invoice Upload - csv/xls invoice submission through the Taulia platform
  • eFile - integration (typically EDI) invoice submission outside of the Taulia platform
  • eSend - integration (PDF invoicing) invoice submission outside of the Taulia platform
  • eForm - non-po invoice submission through the Taulia platform
  • eFlip - po-based (invoice flip) invoice submission through the Taulia platform

Was this article helpful?

   

TAULIA SUCCESS GUIDE

New to Taulia? There’s a guide for that! Let us guide you so you can quickly get started.

TOP FREQUENTLY ASKED QUESTIONS

Q. How do I add or deactivate users?: 000003731

You can manage your account users in the portal and provide different levels of access.

Q. How do I merge/combine my Taulia accounts into one?: 000003598

If you have more than one customer using the Taulia Portal and you need access to two or more accounts with the same login, you can combine your customers to one login.

Q. I am new to Taulia. What should I do first?: 000008036

Quickly learn about Taulia and how to use it!

Q. How do I assign branches to our portal users?: 000008574

Branch permissions allow account admins to give access to specific data in the portal.

Q. How do I create an invoice from a purchase order (eFlip)?: 000003324

Create an invoice against a PO through the portal.

Q. How do I start/stop receiving email notifications?: 000003472

Use the email notification settings feature to manage your email notifications.

Still can’t find what you’re looking for?

Still can’t find what you’re looking for?

“Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Sed et ligula non.”

Vanessa, Technical Services Manager

Important Message
Got It