Before you start

  • You need Add on Invoices and Can see selling prices. Your company's plan is active.
  • The projects, clients or AMC contracts the invoices bill already exist.

Steps

Download the template

  1. In the sidebar, select Financial › Invoices.

  2. Select Download Template. "Download Template" asks: "Choose the invoice type to download the matching Excel template."

    Step 2. The Download Template box with the three invoice types.
    Step 2. The Download Template box with the three invoice types.
  3. Choose Project Invoice ("Linked to a project"), Individual Invoice ("Direct client invoice") or Service / AMC Invoice ("Linked to an AMC contract").

  4. The template downloads (invoices_template_project.xlsx, invoices_template_individual.xlsx or invoices_template_service.xlsx), and "Template downloaded" shows.

Fill it in and upload it

  1. Open the template. Its sheet is "Project Invoices", "Individual Invoices" or "Service (AMC) Invoices". Row 2 marks each column "Required", "Optional", "Optional (auto-filled)", "Auto-calculated" or "Optional (branch code)".
    • Project Invoices: invoiceNumber, projectName, invoiceDate, dueDate, status, milestone, paymentTerms, currency, taxRate, notes, clientName, clientEmail, clientAddress, itemDescription, itemQuantity, itemUnitPrice, itemAmount (worked out by a formula) and branchCode. The sheet "_projects" lists your project names.
    • Individual Invoices: the same columns without projectName. clientName and clientAddress are required.
    • Service (AMC) Invoices: amcContractNo in place of projectName.
  2. Fill in the template with your invoices.
  3. Save the file as .xlsx or .xls. It must be under 500 KB.
  4. Back on Invoices & Payments, select Bulk Upload and choose the file.

Result

The message shows the result, for example "Bulk upload complete: [number] created." Each new invoice is a Draft on the list, with no number yet. Check each one, then issue it. See Issue an invoice.

If something is different