Switching From Sage 50: A Practical Guide for Wholesalers
When orders run to 100 lines and more, typing them in becomes the job. What to look for in a replacement, a migration checklist that keeps your books intact, and how Invoice My Clients handles a 180-line order.
Invoice My Clients publishes this guide and sells invoicing software. It is not affiliated with Sage, has no Sage connector and does not import or export Sage files. The Sage steps below come from Sage’s own help pages, linked where they appear.
A wholesale order with 150 lines is not hard to understand. It is just long. When fifteen of them arrive every day as spreadsheets from a mobile ordering app, someone spends the day reading a product code, typing it, typing a quantity and checking a price. This guide is for that person and for the owner who pays for those hours: why order entry becomes the bottleneck, what replacement software should do, how to move off Sage 50 without losing your books, and where Invoice My Clients fits and where it does not.
Why order entry becomes the bottleneck
Most invoice screens are built for entering one line at a time: pick the customer, add a line, pick the item, type the quantity, repeat. That is fine at 10 lines. At 120 lines it becomes the whole job, and the typing adds nothing, because the order already exists in the spreadsheet your ordering app exported.
The cost shows up in three places:
- Time. At 15 seconds a line, 15 orders of 120 lines is 7.5 hours of typing a day. Your numbers will differ; the white paper has a time model you can fill in with your own.
- Errors. Every retyped code and quantity is a chance to bill the wrong product or the wrong amount, and the customer usually finds it before you do.
- Promotional stock. If promo items must be billed on their own invoice, someone has to pull those lines out of each order and build a second invoice by hand.
None of this means your accounting software is bad at accounting. It is a mismatch: a ledger is built to record transactions carefully, and a distributor with long orders needs a fast way to get lines in.
What to look for in replacement software
- Bulk paste from a spreadsheet. Copy the rows in Excel or Google Sheets and paste them onto the invoice in one go, with a preview before anything is saved.
- Matching by product code. A pasted code should find your saved product, with its description and price. Codes that do not match should be flagged line by line, never dropped silently.
- Price control. If your prices are fixed, the software should stop a pasted price from overriding the saved one.
- Separate invoices for promotional stock. Lines marked as promo should become their own invoice for the same customer and order reference, without retyping.
- Whole-order import. When the ordering app exports a day of orders in one file, load the file once and get one draft invoice per order.
- Customer account codes. An imported order should find the customer by the account code your books and ordering app already use, and ask you when two customers share a code instead of guessing.
- Purchase order handling. If you also buy in long orders from suppliers, paste and import should work on purchase orders too, and turning a PO into an invoice should keep the product codes.
- Accounting sync. If you keep a separate ledger, invoices, customers and payments should reach it without exporting files by hand.
Ask every vendor to show these on one of your real orders, at full length, before you commit.
What Invoice My Clients is, and what it is not
Invoice My Clients is invoicing and accounts receivable software: estimates, invoices, purchase orders, online payments and payment reminders, in a web app and an Android app. It is not a full replacement for Sage 50.
| Job | In Invoice My Clients |
|---|---|
| General ledger, chart of accounts, journals | Not included. Keep them in QuickBooks Online or Xero, which Invoice My Clients syncs with on Professional and above |
| Stock quantities and costing | Not included. The item catalog is a price list with codes, not inventory control |
| Payroll | Not included |
| Bank feeds and reconciliation | Not included |
| Customer estimates, invoices and purchase orders | Included, by plan |
| Online payments and reminders for late invoices | Included, by plan |
If you rely on your current system for the ledger, stock or payroll, the realistic plan is to keep a ledger and move only order entry and invoicing. The move below uses ordinary CSV files, not a Sage connection.
How Invoice My Clients handles a 180-line order
Say a customer’s order arrives from your ordering app as a spreadsheet with 180 lines: product code, description, quantity and price, plus a column that marks 12 lines as promo.
- Paste. Open a new invoice for the customer and choose Paste lines. Select the rows in the spreadsheet, copy them and paste them into the review grid.
- Check the columns. A header row is detected, and the columns are matched to Code, Description, Quantity, Unit price and Bill separately. Fix any guess that is wrong; the mapping is remembered for your account next time, on any computer.
- Match the codes. Each code is looked up in your item catalog, ignoring case and stray spaces. A matched line takes the saved item, and its description and price when the spreadsheet has none. The pasted price is used unless Lock catalog prices or Only allow saved items is switched on, in which case the catalog rules apply.
- Deal with what did not match. Each unknown code is flagged on its row: keep it as a typed line with a description, pick the right catalog item, or skip it. The same code on two rows stays as two lines.
- Read the preview. It shows the row count, matched and unmatched lines and the totals. Because there is a promo column, turn on Bill each group on its own invoice and the preview says this order becomes 2 invoices: 168 lines on this invoice and 12 promo lines.
- Confirm. All lines are saved in one step. The promo lines become a second draft invoice for the same customer with the same reference; the first invoice shows Split into and the second Split from, each with the other’s number. New invoices take the next number in your sequence; existing numbers never change.
Nothing goes to the customer until you send it. Up to 500 rows fit in one paste, and invoices of 180 lines and more open, print and download as a PDF like any other. Paste lines works in the web app on a computer.
Importing a day of orders at once
When your ordering app can export several orders in one file, the Import orders button on the Invoices page takes a CSV or Excel (XLSX) file, or rows pasted from a spreadsheet, with one row per line and a column for the order number. Map the customer account code, customer name or email, item code, description, quantity, unit price and, if you use it, the billing group. Pasted rows can be tab-separated, the way Excel and Google Sheets copy them, or comma- or semicolon-separated text, with quoted cells kept whole. The separator is detected and shown above the columns, where you can change it, and if a comma could be part of a number (such as 12,50) you confirm the columns before the preview. You can also upload the .csv file.
Each order finds its customer by account code first, then by email, then by name, so give every client the account code your ordering app uses. A code, email or name that fits more than one client is flagged so you pick the client; nothing is guessed. Codes are matched to your catalog as above, and a code that is not saved is decided once for the whole file (or keep every one as a typed line). The preview says how many orders become how many draft invoices after promo splits, and flags unmatched customers and codes order by order. The drafts are then made with the progress on screen; keep the page open, and if you leave, the import pauses and continues from Recent imports. A file can hold up to 100 orders and 10,000 rows (5 MB), and an order up to 500 lines. An order number that was already imported is flagged as a duplicate and skipped unless you choose to import it again. Nothing is sent.
Migration checklist: moving off Sage 50
Plan the move for a quiet week, and expect to run both systems side by side for one billing cycle.
- Decide what stays in a ledger. If you keep Sage 50 for accounts, stock or payroll, you are moving order entry and invoicing only. If the books are moving too, choose QuickBooks Online or Xero first, because Invoice My Clients sends invoices and payments there on Professional and above.
- Export customers from Sage 50. In Sage 50 U.S. Edition, choose File, Select Import/Export, pick the customer list template, tick Include Headings and export; the default file is CUSTOMER.CSV (Sage help: export data). In Sage 50 Accounts in the UK, run the Customer Record CSV report from Customers, Reports (Sage help: export data, UK).
- Export products the same way. The U.S. inventory item export defaults to ITEM.CSV and includes Item ID, Description for Sales and up to ten sales prices (Sage help: item fields). In the UK edition, the Product Record CSV report is under Products and services, Reports, Product details (Sage help: export data, UK).
- Protect your product codes. Sage’s own tips warn that a spreadsheet can drop leading zeros ("01" becomes "1") and read a code such as 10-25 as a date (Sage help: import/export tips). Open the export with the code column set to Text, and spot-check codes before you import.
- Import customers with their account codes. Use Import Clients on the Clients page in Invoice My Clients. The import reads the Customer ID, Customer Name and Customer Email columns of the U.S. CUSTOMER.CSV export (Sage help: customer fields) as each client’s account code, name and email; a column headed A/C Ref, Account Ref, Account code or Customer code is read as the account code too. Copy addresses into the template’s address columns. The account code is what imported orders use first to find the customer. See client import.
- Import products. In Settings, Items, choose Import from spreadsheet, pick your file, and point Item code (SKU) at the item ID column, Price at the price level you bill at, and Description at the sales description. Nothing is written until you confirm, and importing again later updates the items with the same code. This works on every plan, Free included.
- Leave opening balances in the books. Open invoices and customer balances stay in the system they were raised in and are collected there. Start new invoices in Invoice My Clients from a set date, and do not re-enter old ones.
- Run both for one cycle. For a week or a month, enter real orders in Invoice My Clients and compare invoices and totals with what you billed the old way. Fix catalog codes and prices as mismatches show up.
- Connect the ledger. With QuickBooks Online or Xero, connect it (Professional and above) so invoices, customers and payments sync, and payments recorded there come back automatically. If Sage 50 stays your ledger, there is no connection: you would post invoice totals into it yourself, which is worth agreeing with your accountant before you switch.
- Switch over. Stop entering new orders in the old system, and keep it available for reports and old balances.
Which plan does what
| Plan | For this workflow |
|---|---|
| Free | Manual line entry, the item catalog and catalog import, client account codes. No paste, split or order import |
| Starter | Paste lines on invoices and estimates, with product code matching |
| Professional | Adds Bill separately (promo on its own invoice), Import orders, and QuickBooks Online or Xero sync |
| Business | Adds purchase orders: paste lines on a PO, a line-by-line PO import, and choosing which PO lines to invoice |
Prices are on the pricing page. Purchase orders are covered in more depth on the purchase orders page.
When this is not the right move
| If | Then |
|---|---|
| You need stock levels, costing or payroll in the same system | Keep a system that does them. Invoice My Clients does not |
| Your orders are a handful of lines | Typing is fine, and the Free plan may be all you need |
| Your accountant needs every invoice inside Sage 50 | Agree how totals get there before you move order entry |
| Orders arrive on paper, not in a spreadsheet | Paste and import need a spreadsheet or CSV; ask your ordering app for an export first |
Questions people ask
Can Invoice My Clients import my Sage 50 company file?
No. It has no Sage connector and does not read Sage files. You export customers and products from Sage 50 as CSV files and import those.
Does Invoice My Clients replace Sage 50 completely?
No. It covers estimates, invoices, purchase orders and getting paid. It has no general ledger, stock control or payroll; keep those in QuickBooks Online, Xero or your current system.
How many lines can I paste at once?
Up to 500 rows per paste. An order import file can hold up to 100 orders and 10,000 rows.
What happens to codes that are not in my catalog?
They are flagged on their row. Keep the line as typed text with a description, pick a catalog item, or skip it.
Can promotional items go on a separate invoice?
Yes, on Professional and above. Lines in another billing group, such as Promo, become a second draft invoice for the same customer and reference.
How do imported orders find the right customer?
By the client’s account code first, then email, then name. Bring the codes in with your client list (a Sage 50 Customer ID column is read as the account code) or type them on each client. A code shared by two clients is flagged and never guessed. The code is not printed on invoices and does not sync to QuickBooks Online or Xero.
Which plan do I need?
Starter for paste and code matching, Professional for promo splits, order import and QuickBooks Online or Xero sync, Business for purchase orders. Client account codes are on every plan.