Start from the problem, not the feature list
Paste Excel orders into invoices
You sell wholesale. Orders come in from a mobile ordering app as Excel files of 60 to 180 lines, about 15 a day, and every one of them gets typed into the invoice again, line by line. Promotional products have to go on a separate invoice.
The situation
An electrical supplier takes orders from its reps and customers through a mobile ordering app. The app exports each order to Excel: a product code, a description, a quantity and a price on every row. A normal order is 60 to 180 rows, and about 15 of them arrive on a busy day.
Some of the products on those orders are promotional items, and the supplier bills them on their own invoice, separate from the stock order, so the promotion can be tracked and paid on its own terms.
What goes wrong today
The invoicing software takes one line at a time. Someone reads the spreadsheet on one screen and types it into the invoice on the other: find the product by its code, enter the quantity, check the price, next line. A 170-line order is a long, careful job, and a typo in a quantity or a code goes out on the invoice.
The promo lines are picked out by eye and moved to a second invoice by hand, and if one is missed the customer is billed for it on the wrong invoice.
How it works in Invoice My Clients
Save your products once as saved items, each with its item code (SKU), description and price; a price list exported from your current system can be imported from a spreadsheet in Settings > Items. Then copy the rows of an order in Excel, Google Sheets or Numbers and paste them into the invoice.
Each row is matched to a saved item by its code, ignoring upper or lower case and any spaces around it. A matched row takes the saved item, its unit and whether it is taxable, and its description and price when the spreadsheet has none. A code you have not saved is flagged on its row: keep it as a typed line, pick the right item, or skip it. You see the whole order, with row counts and totals, before anything is saved.
If a saved item is set to Bill separately as Promo, or the spreadsheet has a Bill separately column, turn on Bill each group on its own invoice and those lines become their own draft invoice for the same customer with the same reference. The first invoice shows Split into and the new one Split from, each with the other's number (Professional and above).
For a day of orders, the Import orders button on the Invoices page takes a CSV or Excel file with one row per line and an order number on each, and makes a draft invoice for every order (Professional and above). Each order finds its customer by account code first, then email, then name, so give your clients the account codes your ordering app uses. Nothing is sent until you send it.
Step by step
- 01
Save your products once
Import your price list in Settings > Items > Import from spreadsheet and say which column is the item code (SKU), the name and the price. Set Bill separately as to Promo on promotional items (it is a column in the import too). Importing the list again later updates the items with the same code.
- 02
Copy the order in Excel and paste it
Select the rows (with or without the header row), choose Paste lines on a new invoice and paste them. The columns are recognised from their headers: item code, description, quantity, unit price and, if you have one, bill separately. Check the mapping once; it is remembered for your account, on every computer you sign in from.
- 03
Check the preview
Every row shows what it matched. Dollar signs and thousands separators in a price are read correctly. Codes that are not saved, a quantity of zero or below, or text where a number should be are flagged on their row. The preview counts the rows, the matched and unmatched codes, and the totals, and says how many invoices the order becomes.
- 04
Confirm, then send
All the lines are saved in one step; if the connection drops and you try again, nothing is added twice. The invoices are drafts. Read them over and send them when you are ready.
A worked example: one electrical supplies order
The sample order below has 176 lines for Northline Electric Co. on PO 4471: 164 lines of stock (conduit, fittings, wire, breakers, devices, boxes, lighting) and 12 promotional items. Two of the codes, BR-PNL-200 and LED-WP80, are new products the supplier has not saved yet. Prices are made up, and sales tax is left out.
| Code | Description | Qty | Unit price | Amount | Bill separately |
|---|---|---|---|---|---|
| EMT-050 | EMT conduit, 10 ft, 1/2"Saved item | 25 | $6.48 | $162.00 | Stock |
| EMT-075 | EMT conduit, 10 ft, 3/4"Saved item | 30 | $11.92 | $357.60 | Stock |
| EMT-100 | EMT conduit, 10 ft, 1"Saved item | 50 | $19.85 | $992.50 | Stock |
| … 93 more lines | |||||
| BR-PNL-200 | Load center, 200 A, 40 spaceNot saved: kept as typed line | 1 | $214.50 | $214.50 | Stock |
| … 66 more lines | |||||
| LED-WP80 | LED wall pack, 80 WNot saved: kept as typed line | 1 | $132.50 | $132.50 | Stock |
| PR-LED24-2PK | Promo: LED flat panel 2x4, 2-packSaved item | 2 | $119.00 | $238.00 | Promo |
| PR-GFR20-10 | Promo: GFCI receptacle 20 A, 10-packSaved item | 1 | $135.00 | $135.00 | Promo |
| … 10 more lines | |||||
176 rows · 174 matched · 2 not saved
This order becomes 2 invoices: Stock (164 lines, $42,492.02), Promo (12 lines, $1,537.20).
Order total: $44,029.22
Stock · 164 lines · PO 4471
$42,492.02
Split from INV-202611-042
Promo · 12 lines · PO 4471
$1,537.20
Split from INV-202611-041
Pasted into a new invoice, 174 rows match saved items and 2 are flagged; both are kept as typed lines with the description and price from the spreadsheet. The preview says the order becomes 2 invoices: Stock, 164 lines for $42,492.02, and Promo, 12 lines for $1,537.20. Together that is $44,029.22, the total of the spreadsheet to the cent. Both are drafts for Northline Electric Co. with PO 4471, numbered in your normal sequence (here INV-202611-041 and INV-202611-042); the first shows Split into INV-202611-042 and the second Split from INV-202611-041.
Open it in Excel or Google Sheets and paste it into an invoice to try it. The same file works in Import orders on the Invoices page, where the Customer column finds the client by name.
What each plan includes
| Feature | Free | Starter | Professional | Business | Enterprise |
|---|---|---|---|---|---|
| Paste lines from a spreadsheet (item codes matched) | Not included | Included | Included | Included | Included |
| Bill separately (split an order into invoices) | Not included | Not included | Included | Included | Included |
| Import orders from CSV or Excel as draft invoices | Not included | Not included | Included | Included | Included |
| Purchase orders: paste lines, import one row per line, pick the lines to invoice | Not included | Not included | Not included | Included | Included |
On Free, lines are entered one at a time and the Paste lines (upgrade) button shows what Starter adds. Saved items, importing them from a spreadsheet, and client account codes are on every plan. Prices and the full list are on the pricing page.
When it does not fit
| Situation | What happens | What you do |
|---|---|---|
| You want orders to flow from Sage 50 on their own | There is no Sage integration, and no Sage import or export file | Paste or import the order spreadsheet; your price list comes in once from a CSV |
| An order has more than 500 lines | One paste takes up to 500 rows | Paste it in two parts, or use Import orders (up to 10,000 rows and 100 orders per file) |
| Only allow saved items is on and a code is not saved | A typed line is not allowed, so the row cannot be kept as typed | Save the new item first, pick an existing one, or skip the row |
| You want to see stock levels or reserve inventory | Saved items are a price list, not inventory | Keep your inventory system for stock, and invoice here |
| You enter orders on the Android app | Pasting lines and importing orders are in the web app | Use a computer for the spreadsheet; the Android app still opens and sends the invoices |
Where this lives in the product
Free tools
Questions people ask
Do you integrate with Sage 50?+
No. Invoice My Clients has no connection to Sage 50 and does not read or write Sage files. What carries over is your data as spreadsheets: Sage 50 exports lists from File > Select Import/Export as CSV files (tick Include Headings). Its inventory item list (ITEM.CSV by default) has the Item ID, Description for Sales and Sales Price/Billing Rate columns that Settings > Items > Import from spreadsheet asks for, and its customer list (CUSTOMER.CSV) has a Customer ID column that Import Clients on the Clients page reads as each client's account code, which is how imported orders find the customer. Then paste or import orders. If you keep your accounts in Sage 50, invoices made here are not posted to it; QuickBooks Online and Xero are the books that sync automatically (Professional and above).
Which wins, the price in my spreadsheet or the saved price?+
The spreadsheet price, when it has one. A row without a price takes the saved item price. If Lock catalog prices is on, a line matched to a saved item keeps the saved price, whatever the spreadsheet says; with Only allow saved items on, every line has to be a saved item.
What if the same code is on two rows?+
Both rows stay, as two separate lines with their own quantities, the way they are in the spreadsheet. Nothing is merged without you seeing it.
What happens if I import the same orders twice?+
An order number that already made invoices is flagged as a duplicate and skipped. You can choose to import it again on purpose; otherwise it is left alone.
Does the split work on estimates too?+
Pasting lines works on estimates (Starter and above), but billing groups do not split an estimate: it stays one estimate. The split happens on invoices. An estimate whose pricing has options (tiers) does not take pasted lines.
How does an imported order find the right customer?+
By the client's account code first, then by email, then by name. Add the code in the Account code field on each client, or import it with your client list: 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 shared by more than one client is flagged and you pick the client; nothing is guessed. The code is your own reference and is not printed on invoices.
Try it with the sample order
Create a free account, move to Starter to paste lines, or to Professional for the Promo split and order import.