DriversRecommendedOutdated drivers can make a good PC feel brokenScan driver issues before chasing fixes manually.Scan NowHalloween DealsAmazon USHalloween week deals: useful picks before month-endAmazon US: current deals, useful picks and tech finds.Check DealsClean PCRecommendedOne scan can reveal what keeps slowing WindowsLook for cleanup and repair opportunities.Run Scan×
Skip to the guide
THE FINANCEBASE List yours

Guide

How to Switch From Square to Another POS Without Losing Your Sales Data

By TheFinanceBase Team 12 min read

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

You can leave Square without losing your sales history, but a new point-of-sale system will not automatically reproduce every report, order, customer record, inventory adjustment, refund, or saved payment method. The safe method is to preserve Square’s original exports, extract any missing order detail through the Orders API, reshape catalog and customer files to the destination system’s templates, arrange a compliant card-on-file transfer separately, and cut over only after a test import and reconciliation.

Keep Square access in read-only use for audit and refunds while the new POS becomes your transaction system. Do not delete the Square account or alter the original files until the first complete post-cutover reconciliation is finished.

As an Amazon Associate I earn from qualifying purchases.

What transfers cleanly—and what usually needs separate work

A POS migration has several different data sets. A report export is not the same thing as an order archive, and a customer CSV is not a payment-token transfer. Start by separating the data into domains so you can assign an export method, a transformation step, and an owner for each one.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Data domain Typical Square source What the destination may need Migration risk
Sales totals and deposits Reports and transaction CSV exports Historical archive for accounting and reconciliation Filters, date ranges, time zones, and edited reports can change totals
Orders and line items Transactions or Orders API Order IDs, itemization, returns, customer references, and timestamps A summary report may omit line-level detail
Items and variants Items > Item library > Actions > Export Library SKU, variation, price, tax, modifier, location, and external ID fields Column names and variant structures differ by POS
Inventory Item library and location records Quantity by matched location, plus an adjustment history if supported Location names may not match; quantities can be imported into the wrong site
Customers Customer Directory export Name, email, phone, addresses, IDs, consent and tags where supported Destination templates often require exact headings and formatting
Refunds, discounts, taxes and fees Transaction and report exports Historical evidence and rules for handling pre-cutover returns Tax and fee fields may not map one-to-one
Gift cards and loyalty Square program records Balances, numbers, expiration and customer links Portability is destination-specific and may require manual validation
Saved cards Card-on-file records held by the processor Processor-to-processor token transfer PCI requirements and account-owner verification apply
Employees and permissions Team and permission settings New roles, PINs, locations and approval limits Permission models rarely match exactly

Mark every row as exportable, transformable, or destination-specific. This prevents a common mistake: assuming that because a CSV exists, the new POS can recreate the same operational behavior.

#1 Best Overall
Kinevolve Mouse Pad for Excel/Word/PowerPoint/Windows Shortcuts – Small Excel Cheat Sheet Desk Pad – 11.8"x9.8" Portable Computer Mousepad – Gaming, Office, Waterproof, Non-Slip, Stitched Edges
  • Compact & Portable Design: This Small Excel, Word, PowerPoint, & Windows Cheat Sheet Mouse Pad measures 11.8" x 9.8", offering a portable mouse pad. Its compact size fits in bags or laptop cases, suitable for professionals, students, or travelers.
  • Multi-Software Shortcut Guide: Featuring essential shortcut keys for Excel, Word, PowerPoint, & Windows, this small mouse pad provides a quick reference for frequently used shortcuts, offering a reference designed to support workflow efficiency
  • Smooth & Precise Surface: The finely-textured surface ensures precise mouse control, allowing for smooth and accurate movement during work or gaming sessions.
  • Durable & Non-Slip Design: This Multi-Software Shortcut Mouse Pad features stitched edges to reduce fraying. The non-slip rubber base helps keep it securely in place, and the water-resistant fabric allows for easier maintenance.
  • Clear Print Quality: Displays high-resolution printing intended to remain legible through regular use and cleaning

Build a controlled backup before changing Square

Choose a migration owner and a cutover date before exporting. The owner should control the source account, the destination account, the accounting contact, and the payment processor contact. Create a dated folder with separate subfolders for raw exports, working copies, API responses, mapping documents, test-import results, and reconciliation sign-offs.

Preserve the originals

  1. Use a date range that includes the complete period you may need for tax, chargeback, refund, and management reporting. If you operate in several time zones or locations, record the Dashboard filters and timezone used.
  2. Download each file directly from Square and do not edit it. Give it a descriptive name such as square_transactions_2020-01-01_to_2026-10-17_raw.csv.
  3. Make a read-only copy or checksum-controlled archive. Perform cleaning and column changes only in a working copy.
  4. Record the export date, account and location scope, selected filters, file format, row count, and the person who performed the export.

Square’s report workflow instructs users to click Start export to download a CSV file and open it with spreadsheet software. Treat that downloaded file as evidence, not as a file to “tidy” before archiving.

Export Square reports and transaction history

Reports for accounting and trend history

Export the broadest useful date range for sales, taxes, discounts, refunds, fees, tenders, and deposits. If the Dashboard offers separate report types, export each one rather than relying on a single total. Keep the report name and filters with the file, because two files covering the same dates can legitimately differ when one is filtered to a location, channel, or payment type.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Transaction-level CSV

In Square Dashboard, open the transaction-search area, set the required date and location filters, and choose Export to download transaction details as CSV. Square’s support guidance describes this as the separate path for transaction data. Transaction rows are useful for matching payments and refunds to deposits, but they may not contain every order-level field needed to recreate a historical order in another POS.

Reconcile the source before importing anything

Use the raw files to calculate control totals: number of transactions, gross sales, discounts, taxes, refunds, processing fees, net sales, and deposits. Compare those totals with Square’s Dashboard summaries and your accounting records. Investigate mismatches before migration; importing inconsistent source data only makes the discrepancy harder to find.

Export items, variants, locations and customers

Item library

In Square, go to Items > Item library > Actions > Export Library. Choose Excel or CSV, and export all items unless you have a documented reason to export a filtered subset. Keep the item ID, variation ID, SKU, price, tax category, modifiers, categories, and location assignments whenever those columns are available.

Rank #2
Office Desk Accessories 2pcs Computer Monitor Memo Board Office Supplies | Computer Monitor Memo Board Computer Sticky Note Holder
  • [MULTIFUNCTIONAL]You'll get 2 pieces computer monitor memo boards that you can stick on the left and right edges of your monitor, and they're the perfect office desk organizers and accessories. Computer monitor side panels desktop organizer are suitable for home work or office,bringing convenience. Desktop memo is used to organize meeting memos, important messages, business cards, planning notes.Paste on the message board to keep track of important things and to-do items to prevent forgetting.
  • [🌟HIGHLY QUALITY] The material of computer screen side note holder is transparent acrylic. Durable, simple, stylish, light weight, easy to use, not easy to fall off or break. This cute office supplies for women desk can be used for a long time. This computer desk accessories is waterproof and dirt resistance, and look simple and stylish. The transparent acrylic sticky note holder as cubicle accessories is easy to notice the context of your sticky notes.
  • [📋Easy to use] Office must haves cool office gadgets for desk ready to tear, easy to install and remove, not easy to leave traces. You only need to peel off the protective film on the surface of the computer side board memo, wipe off the dust on the edge of the computer monitor, and then stick the desk essentials for women office on the right or left side of the tape, and you're done. A perfect gift for your colleagues, friends or classmates and family members or relatives
  • [🏢MULTI-SCENE USE] This desk supplies computer memo board can be applied to home and office, clear your office decor for women, suitable for most computer monitors, screens and cabinets, you can put it where you think, this cute office decor serve as a reminder. Stick on the computer side. It’s a good office gadgets can remind work improve office productivity. Pasted cabinets, dressers, refrigerators, walls, etc as cubicle accessories. To make life more orderly.
  • [💌NOTE] The adhesive force of the computer sticky note holder is very strong. It can not be directly pasted on the computer screen. It should pasted on the black edge of the screen. Narrow edge not recommended!!! If you are not satisfied with your purchase, or if the product is damaged or broken in transit, please let us know immediately. We will promptly solve your problem.

Do not overwrite a SKU because the new POS rejects duplicates. Instead, flag the duplicate in the mapping sheet and decide whether the destination should merge, rename, or retain separate variants. Preserve Square IDs in an external-ID column or a separate crosswalk so a future refund or customer-service request can be traced back to the source record.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Inventory by location

Capture the quantity for every location at a defined “as of” time. Freeze stock movements during the final export window or record every movement made after the snapshot. A quantity without a location is not enough for a multi-site business. Include inactive or zero-quantity items if they are needed for historical reporting, but mark them so they do not accidentally become sellable in the new POS.

Customer Directory

Export the customer directory and retain Square customer IDs. Keep email and phone values in their original form in the raw file, then normalize them in a working copy. Record duplicate candidates rather than deleting them: two customers can share a household phone number, and merging records can erase consent or purchase history.

Customer marketing consent, notes, addresses, tags, and custom fields may not have equivalent destination fields. Create a column-by-column disposition: import, transform, archive-only, or manually review.

Use the Orders API when reports are not detailed enough

If you need historical orders with line items, returns, customer references, or other order-level details that are absent from a CSV report, use Square’s Orders API rather than trying to infer them from totals. Square describes the API as able to search a seller’s past sales and returns for itemization data, customer references, and other details from sales made through POS or online.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Protect API extracts

  • Save the unmodified response payloads, not only a spreadsheet conversion.
  • Record the request date, location identifiers, date filters, pagination state, and timezone assumptions.
  • Keep order IDs, return IDs, payment IDs, and customer IDs in separate columns when normalizing.
  • Preserve null values and status fields; a missing value is different from a zero amount.
  • Never paste payment-card numbers or authentication secrets into a working spreadsheet.

Use API data as a historical archive unless the destination has a documented order-import endpoint. Many POS products can import a catalog and customers but cannot recreate closed historical orders as native transactions.

Rank #3
Taja To Do List Notepad, Undated Daily Planner for Work and Goal Setting
  • Stay Organized with Ease: Our To Do List Notepad provides multiple sections with plenty of space to jot down all of your important tasks.A versatile office supply perfect for daily task management, helping you keep track of everything that needs to be done and prioritize effectively.
  • Achieve Your Productivity Goals: Begin each day on a positive note, reminding you of your potential, strength, and the significance of staying focused on your goals. Our Daily Checklist Notepad is the ultimate tool to streamline your daily planning and elevate your productivity. With a clear and concise overview of your tasks, you can effortlessly prioritize what truly matters and make consistent strides towards achieving your goals.
  • Reliable and Stylish: Our to do list planner combines functionality with durability. With a transparent PP cover, the inner pages are well-protected from dirt and wear. Additionally, the back cover is crafted with thick paperboard, offering a stable surface for your writing needs. Each notepad includes 52 pages of high-quality, 100gsm paper, which is thick and non-bleeding, resulting in a smooth and enjoyable writing experience.
  • Versatile Use: This daily checklist notepad, suitable for teacher supplies and a wide range of applications, proves invaluable in various settings including work, school, and home. Whether you need to organize your daily tasks, plan a project, or create a grocery list, this notepad serves as the ideal tool. Its compact size ensures easy portability, allowing you to conveniently carry it with you throughout your day.
  • Perfect Present for Anyone: Our Daily To-Do List Notepad is the perfect present for those who value organization and productivity. With its stylish design and versatility, this office desk accessory is also a practical addition to school supplies. Suitable for students, professionals, and homemakers alike, it helps keep tasks and priorities in check effortlessly.

Map Square fields to the destination POS

Obtain the destination POS’s current import templates before editing Square files. Treat the destination headings, allowed values, character limits, and required fields as the source of truth. Create a mapping workbook with one row per source field and columns for destination field, transformation rule, default value, owner, and validation status.

Square-side value Destination decision Validation to perform
Item and variation name Map to product and variant names without collapsing distinct sellable units Check duplicate names and parent-child relationships
SKU or variation ID Use SKU as the operational key; retain Square ID as an external reference Confirm uniqueness and permitted characters
Price Map to the destination’s price field and currency Check decimal precision and tax-included versus tax-excluded behavior
Tax category Map to a destination tax rule, or mark for manual setup Test taxable, tax-exempt, and mixed-tax orders
Modifier Recreate as an option group if supported Test required, optional, and priced modifiers
Location Match by an exact approved location crosswalk Reject unmapped locations rather than defaulting silently
Customer email and phone Map to the destination’s customer columns Validate formatting and duplicate handling
External ID Store the Square customer, item, or order ID Confirm the destination preserves the value after import

Example: a location-aware import

Shopify’s documented migration workflow illustrates why location mapping matters. Its Store Migration app can accept Square files, import inventory quantities per Square location, match locations by name, and create a new location when no matching location exists. That behavior must be confirmed for your destination and current app version; never assume another POS handles unmatched locations the same way.

For customer imports, Shopify warns that Square’s export must be reshaped to its customer CSV headings and that its import does not provide automatic data mapping. The practical lesson applies broadly: download the destination template, map every heading explicitly, and retain the mapping workbook as part of your audit record.

Free tools Windows power users keep installed

One-click scans. No signup required.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Saved cards are a separate, regulated migration

Do not copy card numbers, security codes, or payment tokens into a normal CSV. Square states that, under PCI rules, it can directly transfer card-on-file data only to another PCI DSS Level 1-compliant payment processor. The account owner must contact Square Support for verification, and Square states that the average export timeframe can be up to two weeks.

Coordinate the processors

  1. Ask the receiving processor whether it accepts a card-on-file token transfer from Square and which customer identifiers it requires.
  2. Confirm that the receiving processor is PCI DSS Level 1 compliant and obtain its written transfer procedure.
  3. Have the Square account owner begin the verification process and allow up to two weeks based on Square’s stated average timeframe.
  4. Map the receiving processor’s customer IDs to your destination POS customer IDs without exposing card data.
  5. Test a recurring or card-on-file charge in a controlled account before announcing that saved cards are available.

If the receiving processor cannot accept the transfer, tell customers they may need to enter payment details again. Do not describe a saved-card migration as complete until an authorized payment test succeeds and the processor confirms token status.

Choose a replacement POS using migration questions

Price and interface are not enough. Require written answers from the destination provider on the following points before signing a contract or scheduling cutover.

Rank #4
Gogoonike Adjustable Laptop Stand for Desk, Metal Laptop Riser Holder | Portable Desktop Book Stands, Foldable Ventilated Cooling Computer Notebook Stand Compatible with 10-15.6” Laptops, Tablets
  • 【Adjustable & Ergonomic】:This laptop stand can be adjusted to a comfortable height and angle according to your actual needs, letting you fix posture and reduce your neck fatigue, back pain and eye strain. Very comfortable for working in home, office and outdoor.
  • 【Sturdy & Protective】 :Made of sturdy metal, it can support up to 17.6 lbs (8kg) weight on top; With 2 rubber mats on the hook and anti-skid silicone pads on top & bottom, it can secure your laptop in place and maximum protect your device from scratches and sliding. Moreover, smooth edges will never hurt your hands.
  • 【Heat Dissipation】 :The top of the laptop stand is designed with multiple ventilation holes. The open design offers greater ventilation and more airflow to cool your laptop during operation other than it just lays flat on the table.
  • 【Portable & Foldable】:The foldable design allows you to easily slip it in your backpack. Ideal for people who travel for business a lot.
  • 【Broad Compatibility】:Our desktop book stand is compatible with all laptops from 10-15.6 inches, such as MacBook Air/ Pro, Google Pixelbook, Dell XPS, HP, ASUS, Lenovo ThinkPad, Acer, Chromebook and Microsoft Surface, etc.Be your ideal companion in Home, Office & Outdoor.
  • Can it import historical orders, or does it only archive CSV files?
  • Which item, variation, modifier, tax, and SKU fields are supported?
  • How are quantities imported for multiple locations, and what happens to an unmatched location?
  • Can customer IDs, consent fields, loyalty balances, gift cards, notes, and addresses be preserved?
  • What is the saved-card transfer path, who is the processor, and who handles PCI responsibilities?
  • How are refunds for sales made before cutover processed?
  • Are APIs, scheduled exports, and raw audit reports available after cancellation?
  • Can the system reproduce gross sales, discounts, taxes, fees, refunds, and net deposits for reconciliation?

There is no universal import guarantee across POS products. Ask for a field-level mapping and cutover plan in writing, including who corrects rejected rows and whether support will perform a test import.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Run a representative test import

Never begin with the entire catalog. Create a small test set that exercises the rules most likely to fail.

  1. Include a standard sale, a discounted sale, a refund, a tax-exempt item, a product with variants, a product with modifiers, and a customer with multiple addresses.
  2. Include at least one record from every operating location and sales channel.
  3. Import into a test or staging account when available. Keep the original Square IDs in the destination records.
  4. Check rejected rows, silently defaulted values, duplicate customers, price rounding, tax behavior, modifier availability, and location assignment.
  5. Process a controlled test payment and refund using the destination processor, then verify the receipt, settlement, and reporting entries.
  6. Document every correction in the mapping workbook and rerun the test until the result is repeatable.

Reconcile before the final cutover

After the test import, compare the destination’s results with Square’s raw exports. Use both counts and monetary totals; matching only one does not prove the migration is correct.

Check What to compare Pass condition
Catalog Items, variants, SKUs, prices, tax categories and modifiers Every intended sellable record is present once and has the correct rule
Inventory Quantity by location at the same snapshot time Differences are explained by recorded movements or rounding
Customers Record count, IDs, contact fields and duplicate list No unexplained losses, merges or consent changes
Sales Transaction count and gross sales Totals agree for the same date, location and timezone scope
Adjustments Refunds, discounts, taxes and fees Each category ties to the source export or a documented rule change
Deposits Net deposits and settlement dates Accounting can trace destination settlements separately from Square settlements

Cut over in controlled stages

Final export and freeze

Choose a low-volume period. Announce a short catalog-edit freeze, complete the final reports and transaction export, capture final inventory quantities, and record any sales or refunds that occur during the freeze. Do not let staff edit prices or item names in both systems at the same time.

Parallel operations when practical

A brief parallel period can expose receipt, tax, printer, network, staff-permission, and refund problems before the old system is disabled. If parallel processing would create duplicate charges or inventory confusion, use a scripted dry run instead and define exactly which system is allowed to accept live payments.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Switch transactions

  1. Confirm the destination processor, terminals, receipts, taxes, printers and user permissions.
  2. Post a visible staff notice with the exact go-live time and the rule for handling an order started before that time.
  3. Take new sales only in the destination POS after go-live.
  4. Keep Square available for lookup and pre-cutover refunds, but block routine new sales there.
  5. Save the first destination-day reports and compare them with processor settlements and expected inventory movements.

Handle refunds, disputes and audits after leaving Square

Write a written policy for pre-cutover sales. The policy should state whether refunds are issued in Square, the destination POS, or through a manual accounting process. A refund in the wrong system can create a duplicate return, an unlinked customer record, or a mismatch between payment settlement and sales reporting.

Best Value
Hiacry 8 Pack Gel Pens, Quick-Drying Black Ink, 0.7mm Fine Point Fidget Pen
  • Twin-Ball Design : Hiacry gel pen features a double ball conical tip that reduces writing resistance and provides a stable and smooth writing experience. 0.7mm quick drying black ink ensures no jumping, leakage or seepage.
  • Quick-Dry Long Lasting Ink:0.7mm black ink can slide effortlessly, dry immediately, & is not easily dirty. It has a high-capacity reservoir (up to 1300 meters), which is very suitable for left-handed & right-handed users.
  • Sleek Design for Journaling & Planning: Engineered with a low center of gravity and precision tip for steady ink flow, these journaling pens excel at note-taking, sketching, planning, and more. They combine stylish pens with top-tier performance.
  • Rolling Ball Design:The pocket clip with roll ball design can be easily attached to notebook pockets and binders, in addition, the fidget on the pen clip is also a small toy for your daily thinking to relieve stress.
  • Comfortable Non-Slip Grip:The ergonomic pen barrel has a soft rubberized coating for a comfortable, non-slip grip, so you won't get fatigued even after long hours of writing.

Keep Square’s raw reports, transaction files, API responses, mapping workbook, test results, support correspondence, and final reconciliation in your normal financial-record retention system. Preserve the original files even if the destination successfully imports a copy. Read access is particularly valuable when a customer disputes an old charge or an auditor asks how a deposit was calculated.

Troubleshoot common migration failures

Totals do not match

First compare date range, location filter, sales channel, timezone, and whether refunds are recorded by sale date or refund date. Then compare gross sales, discounts, taxes, fees, and net deposits separately. Do not “fix” a total by editing the raw export.

Items imported but variants are missing

Check whether the destination requires a parent product row and separate variant rows. Verify that each variant has a unique SKU or external ID, then rerun only the rejected or incomplete rows after correcting the mapping.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Inventory landed at the wrong location

Stop sales of affected items, compare the location crosswalk with the destination’s location names, and correct the mapping before making a bulk adjustment. Keep an adjustment log showing the original imported quantity and the approved correction.

Customers were duplicated

Use a deterministic matching rule based on a preserved Square customer ID where possible. Review shared household emails and phone numbers manually; never merge records solely because one contact field matches.

Saved cards are unavailable

Ask the receiving processor whether the transfer was accepted, whether verification is complete, and whether the destination customer IDs match the submitted crosswalk. If the processor is not eligible for direct transfer, stop attempting spreadsheet workarounds and use a secure customer re-entry process.

Old orders cannot be recreated

Retain the Square archive and Orders API responses as the authoritative history. Configure the new POS to record a reference to the original order ID when handling a post-cutover inquiry or refund, rather than inventing a historical sale in the new ledger.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Migration checklist

  • Assign an owner, cutover date, accounting contact and processor contacts.
  • Inventory sales, orders, items, variants, locations, inventory, customers, gift cards, loyalty, refunds, taxes, discounts, fees and permissions.
  • Export Square reports and transaction CSVs with documented filters.
  • Export the item library and customer directory; preserve IDs.
  • Use the Orders API for missing line-item or customer-reference detail.
  • Archive raw files and keep all transformations in working copies.
  • Obtain destination templates and complete a field-level mapping workbook.
  • Arrange saved-card transfer directly between compliant processors.
  • Test-import representative records from every location and edge case.
  • Reconcile counts, inventory, gross sales, refunds, discounts, taxes, fees and deposits.
  • Freeze catalog edits for the final export and choose a low-volume cutover window.
  • Switch new transactions to the destination while retaining Square read access.
  • Complete the first post-cutover reconciliation before closing or deleting anything.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.

Leave a comment

Your email address will not be published. Required fields are marked *

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

More guides

Recommended PC Tool
Recommended PC Tool
Windows Errors? Fix Them Before They SpreadFree repair scan
Crashes, No Sound, or Screen Glitches?Free driver scan

Two free Windows tools

One Free Minute Could Fix That PC

Before you go - each of these free tools takes about a minute and tackles what quietly slows a Windows PC down.

Special offer. View Outbyte info, uninstall instructions, EULA, and Privacy Policy.