Keep an original copy before cleaning the data
Export the records your current system allows you to export and keep a protected, unchanged copy. Record the export date, store and period. Make a working copy for cleanup so you can trace a correction back to the original record.
Ask which fields the new setup can import and which need another agreed process. Bill Pondy can discuss your Posnic-based configuration, but do not assume that every file from every billing product can be loaded unchanged. Share a small sample without private customer information before handing over a full export.
Give each product an unambiguous identity
Review names, barcodes, variants, units and prices. Resolve duplicates carefully: two similar names may be different pack sizes, while two different spellings may describe the same item. A cashier should recognise the difference on screen and on the printed receipt.
- Use a consistent name for each product and variant.
- Check barcode values for missing digits or duplicates.
- Confirm buying and selling units.
- Separate active products from items no longer sold.
- Have the owner approve selling prices and relevant configuration.
Have the accountant review tax-related fields for the business. Do not use guessed rates simply to make an import complete.
Choose an opening-stock moment
Decide when the old system stops being the live counter and the new one starts. Count stock close to that moment and document any sales, receiving or returns that happen between the count and cutover. Otherwise the opening quantity can be out of date before the first new bill is saved.
For a small pilot, choose a handful of easily counted items and follow them through receiving, a sale and a return. Use the ten-unit inventory check to make the expected change visible. For the actual count, use the stock-count example and blank worksheet to account for movements before the opening-stock time.
Treat outstanding balances separately
A customer list and a customer balance are not the same thing. Review unpaid sales, supplier balances and any deposits using an agreed process. Keep the supporting records and decide who approves the opening position.
Do not load historical sales casually if they would also change current stock or duplicate outstanding amounts. Establish how the new setup represents history, opening stock and balances before importing the full dataset.
Rehearse with the person who will use the till
Ask the cashier to find a product, scan an item, change a quantity, save a sale, print a receipt and reopen it. Include a return, held bill or part payment if those tasks are part of normal trading. The owner should review the resulting reports and quantities.
For restaurants, also prepare the menu and table references, then use the restaurant sample service. Staff should know how to handle a changed order before the kitchen is busy.
Write down cutover, backup and recovery responsibilities
Agree a cutover time, the person who approves it and what happens if a critical check fails. Keep the previous records accessible through an approved method. Avoid running two live counters for the same stock without a defined reconciliation process.
Take a backup of the prepared system and prove a restore on a separate test setup. Check that the first live close has an owner and a support contact. Our local billing and backup guide explains why a backup on the same disk is not enough.
Bring your sample data and equipment list when arranging a Bill Pondy demo in Puducherry or Karaikal. The aim is a controlled opening position that your team understands, with a clear way to find and correct problems.
Approve the opening position with evidence
Keep a short acceptance record with the cutover time, source file or report, expected result, observed result and the person approving each check. A successful import message proves that a process finished; it does not prove that the opening position is correct.
Swipe the table, or focus it and use arrow keys, to read all columns.
| Check | Evidence to compare | If it differs |
|---|---|---|
| Products | Accepted active item and variant counts, plus samples of pack size, unit, barcode and selling price | Trace skipped or merged rows to the working file; keep a list of deliberate exclusions. |
| Opening stock | Counted quantity for each sampled item, adjusted for recorded movements up to cutover | Check the count time, unit conversion and duplicate movements before changing a quantity. |
| Outstanding amounts | Approved customer and supplier totals, with individual records supporting each balance | Find the affected account; check whether history and opening balances have both been loaded. |
| Trial transactions | A saved trial bill, its paper receipt, payment record and resulting stock movement in a separate rehearsal setup | Repeat the failed workflow after correction and retain the corrected result. |
| Recovery | A backup and a successful separate restore with known records checked | Resolve recovery access and responsibilities before approving the switch. |
For example, an imaginary shop counts 24 individual bottles at 6 pm, sells three and receives six before an 8 pm cutover. Its expected opening quantity is 24 − 3 + 6 = 27 bottles. An imported quantity of 24 is three short even if the file loaded without an error. Record the two movements and their times, and confirm that neither will be applied again after opening. This is a planning example, not a claim of automatic migration.
Agree which failures stop the changeover. A missing fast-selling item, an unexplained customer balance or an unusable receipt needs a named decision before live billing. If the switch is postponed, capture a fresh cutoff and account for later transactions; do not simply reuse yesterday’s opening file.
Keep rehearsal bills out of live turnover. Ask the installer how test data will be separated or reset through the supported process. At the first live close, compare payments and stock with the approved opening position using the cash-closing guide. Use the restore checklist for the recovery evidence, or request a migration discussion; only your phone number is required.
Work through a small catalogue sample first
Use a working copy of a few representative rows before preparing the full catalogue. The fictional sample below shows why a row count alone cannot establish that products are ready. The codes are illustrative identifiers, not registered retail barcodes or an import template.
Swipe the table, or focus it and use arrow keys, to read all columns.
| Source rows | Problem to resolve | Decision before a trial import |
|---|---|---|
| Soap 100 g — code 00127 | A spreadsheet copy shows 127 instead. | Keep the original code as text and compare it with the product label. Do not silently remove leading zeros. |
| Soap 100 g and Soap 150 g — both code 00127 | Two different packs share one identifier. | Hold both rows for label checks. Do not merge the packs or invent a replacement code to make the file pass. |
| Tea 250 g and Tea powder 250 g | Different names may describe one product. | Compare the physical item, brand, pack and identifier. Merge only after approval; retain the old-to-new reference. |
| Water bottle — stock 3, unit carton | The till will sell individual bottles. | Count the bottles per carton and loose bottles, then agree the opening unit. Three cartons do not mean three bottles. |
Keep a decision beside each source row: ready for rehearsal, held for correction or deliberately excluded, with a reason and approver. If two rows become one approved product, retain both source references. Never discard the original export to hide the difference.
For example, three sealed cartons containing 12 bottles each plus four loose bottles represent 3 × 12 + 4 = 40 individual bottles, provided the physical count confirms those quantities. This establishes the proposed opening quantity; it does not prove the software will convert cartons automatically. Confirm the units and supported import fields with the installer.
In the separate rehearsal setup, find each accepted product, scan its real label, sell the intended unit and compare the saved bill and stock movement. A soap scan should select the approved pack, not simply the first similarly named item. Use the barcode catalogue checks to record the result, then return to the opening-position checks before approving the changeover.
A note from Bill Pondy
We provide a white-label Posnic POS offering with the restaurant module. These are practical planning guides from the business offering the software; examples are illustrative. Confirm features, equipment, prices and service arrangements for your own setup. Questions or corrections? Talk to us.