Excel Order Entry

Paste the order from Excel. Skip the retyping.

Copy 180 rows from a spreadsheet into an invoice in one go. Product codes, quantities and prices are recognised, and promotional lines can go on their own invoice.

01 / Excel Order Entry

What is Excel order entry?

Excel order entry is for businesses whose orders already exist as a spreadsheet: an export from a mobile ordering app, a customer's order form, a rep's list. Instead of typing each line into the invoice, you copy the rows and paste them. Each row is matched to one of your saved items by its item code, and you see the whole order before anything is saved.

For a day of orders, Import orders on the Invoices page reads a CSV or Excel file with one row per line and makes a draft invoice for every order, finding each customer by their account code first, then email, then name. Lines marked to bill separately, such as promotional items, become their own invoice for the same customer.

  • Paste up to 500 rows into an invoice or estimate at once.
  • Codes match your saved items, whatever the upper or lower case.
  • Promo lines become their own draft invoice, linked to the order.
  • Nothing is saved until you confirm the preview, and nothing is sent until you send it.

02 / Capabilities

Built for long orders

A 170-line order should take as long as a 2-line one, and come out right the first time.

Paste from any spreadsheet

Copy rows in Excel, Google Sheets or Numbers, with or without the header row, or paste comma- or semicolon-separated text. Quoted cells, blank rows, dollar signs and thousands separators are read correctly, in your account's number format. The review shows how the columns were separated and lets you change it, and if a comma could be part of a number (12,50), it asks you to confirm the columns first.

Columns recognised once

Code, description, quantity, unit price and bill separately are guessed from the headers. Fix the mapping once and it is remembered for your account on every computer.

Matched to your saved items

A code that matches a saved item takes that item, its unit and its tax setting, and fills in the description or price when the spreadsheet leaves them out. A code that is not saved is flagged: keep it as a typed line, pick an item, or skip it.

Your price rules still apply

The spreadsheet price is used when there is one. With Lock catalog prices on, a saved item keeps its saved price; with Only allow saved items on, every line has to be a saved item. The server checks it, not just the screen.

Bill separately

Set Bill separately as on a saved item (Promo, say), or paste a bill separately column, and turn on Bill each group on its own invoice. The preview says how many invoices the order becomes, and each extra one is a draft for the same customer with the same reference, marked Split from the original. Professional and above.

Import a day of orders

Upload a CSV or Excel file, or paste rows copied from a spreadsheet, with an order number on each row: up to 100 orders and 10,000 rows. Customers are found by account code, then email, then name, and an order imported before is flagged. Progress shows as the drafts are made. Professional and above.

Client account codes

Give each client the account code your books and ordering app use, such as SMITH01. Imported orders find the client by it first, the client list shows and searches it, and a code already used by another client is flagged. Every plan.

03 / Process

How to paste an order into an invoice

01

Save your price list once

In Settings > Items > Import from spreadsheet, import your products with their item code (SKU), name and price. Re-import later to update prices.

02

Copy the rows and paste them

Open a new invoice or estimate, choose Paste lines and paste the rows you copied. Check which column is which the first time.

03

Review the preview

See every row, the matched and unmatched codes, the totals and, on Professional and above, how many invoices the order becomes. Fix or skip the flagged rows.

04

Confirm

All the lines are saved in one step, safe to retry. The invoices are drafts until you send them.

04 / FAQ

Excel order entry FAQs

Which plans include it?

Pasting lines with item code matching is on Starter and above, for invoices and estimates. Bill separately and order import are on Professional and above. Pasting lines on purchase orders, importing purchase orders one row per line and choosing which lines of a PO to invoice are part of purchase orders, on Business and above. On Free, lines are entered one at a time. Client account codes and importing your saved items from a spreadsheet are on every plan.

Do you integrate with Sage 50?

No. There is no Sage connection and no Sage import or export file. Your price list and customers come over once as CSV files, and the customer ID in a Sage 50 customer export can be imported as each client's account code, which is how imported orders find the client. Orders then come in by paste or file import.

Does an AI read my spreadsheet?

No. Columns are matched from their headers and rows from their item codes, by fixed rules you can see in the preview. AI assistants connected through the MCP server can add many lines to an invoice or estimate in one call, under the same plan and price rules.

How many lines can an invoice have?

One paste takes up to 500 rows, and an order import up to 10,000 rows across 100 orders. Long invoices send, print to PDF and get paid like short ones.

Can I do this on the Android app?

Not yet. Pasting lines and importing orders are in the web app, where the spreadsheet is. The invoices they make open and send from the Android app like any other.

How are imported orders matched to my clients?

By the client's account code first, then by email, then by name. Type the code on the client, or bring it in with Import Clients on the Clients page: a column headed Account code, A/C Ref, Account Ref, Customer code, Customer number, Cust No or Customer ID is read as the account code. A code, email or name that fits more than one client is flagged so you pick the client; nothing is guessed. The code is your own reference: it is not printed on invoices and does not sync to QuickBooks Online or Xero.

Stop retyping orders

Save your price list once, then paste each order in one go.

No credit card required to start.

  • Payments processed by StripeCard numbers never touch our servers
  • Encrypted in transit and at restHTTPS only, on AWS encrypted storage
  • Passkeys and two-step sign-inOptional authenticator-app codes
  • Free plan, no card requiredUpgrade only when you need to