Import instructions

How to import invoices from a CSV file.

Download the template, keep the column names unchanged and save the file as CSV. Each row is one invoice line. Use the same invoice_key to group several lines into one invoice.

1. Download the template

Open it in a spreadsheet, but don't change the column names. After completing, save the file in CSV format.

The invoice has several items?

Add a separate line for each item and repeat the same one invoice_key. InvoiceRate will combine these lines into one document.

2. Complete the required columns

Required

  • invoice_key
  • issue_date (RRRR-MM-DD)
  • due_date (RRRR-MM-DD)
  • client_name or client_email
  • item_description
  • item_quantity
  • item_unit_price

Optional

  • invoice_direction (sales/purchase)
  • currency, status, payment_terms
  • Customer's contact and address details
  • item_unit, item_tax_percent
  • amount_paid, notes

3. Run the import in the application

  1. 01
    In the app, choose Import invoices.
  2. 02
    Select the prepared CSV file.
  3. 03
    Review the result and messages for rows requiring correction.

4. Fix only bad rows

InvoiceRate imports valid data and indicates row-level problems. Keep the original file, correct the marked fields and re-import.

I need help with the format