Move from a chargeback spreadsheet to an app, step by step

Your chargeback spreadsheet started as a tidy list: order number, amount, due date, status. It grew a column for notes, then one for the carrier, then a tab for customer emails, then a colour code only you understand. It has served you well. Then last month a due date slid past because you read the wrong row, and a $140 dispute got Shopify's thin default response instead of yours. Now you are wondering whether it is time to move the work somewhere that watches the dates for you.

It probably is, if you handle more than a handful of disputes a month, if you have missed or nearly missed a deadline, or if more than one person touches the sheet. The move is not hard, and it does not mean throwing the sheet away. This guide shows you how to migrate from a chargeback spreadsheet to a chargeback app in about two weeks without missing a due date: the signs you have outgrown the sheet, a column-by-column map, a ten-step plan, a parallel run with clear pass marks, and the few things worth keeping in a spreadsheet afterwards.

This guide is for you if:

You track chargebacks in a spreadsheet and the process is starting to creak.
You want to move to a chargeback app without losing a deadline during the switch.
You want to know what to keep in the sheet once the app is running.

Last updated: 30 October 2026. Written by the ChargeFix team. Reviewed against sources on 30 October 2026.

A note on bias before we start: we make ChargeFix, so we gain if you switch. We also say below when a spreadsheet is enough. The steps apply to any chargeback app, and where we mention ChargeFix specifically, it is because we know how it counts and handles disputes. Time and cost figures are assumptions for illustration, so replace them with your own.

The 30-second answer (TL;DR)

A spreadsheet is fine at low volume and one person. It breaks when deadlines, evidence and handoffs outgrow what a person can remember.
The strongest signs you have outgrown it: a missed or nearly missed deadline, more than 10 disputes a month, more than one person editing, or evidence scattered across tabs and inboxes.
A tool reads disputes straight from your payments account, so you usually do not need to import your sheet. Your sheet's history stays yours.
Move in ten steps: back up, list open disputes, pick a cut-over date, install in Manual mode, run in parallel for about ten disputes, then retire the daily use of the sheet.
Never submit the same dispute from two places. Shopify accepts one evidence submission per dispute and it is final.
Keep a slim monthly scorecard in a spreadsheet, so you can see whether the app is earning its fee.

Quick note: The danger in a migration is not the new tool. It is the gap between the old process and the new one, where a due date can fall through. Hand over open disputes deliberately, one at a time.

The migration at a glance

Phase	Days	What happens
Prepare	1 to 3	Back up the sheet, list open disputes, choose the cut-over date
Install	4 to 5	Connect the app in Manual mode and check what it can see
Parallel run	6 to 12	Handle about ten disputes in both, submit from one
Cut over	13 to 14	Make the app the source of truth, slim the sheet down

When is a chargeback spreadsheet enough?

Do not migrate for the sake of it. A spreadsheet is a perfectly good tool when all of these are true.

You have fewer than about five disputes a month.
One person handles them all.
You have never missed a due date.
Your orders and delivery proof are easy to find.
Your responses take under 20 minutes each.

At that size, the sheet costs you little, and a paid plan would add cost for little gain. A free plan from a tool, or Shopify's own form, might be all you need. Our break-even guide shows the volume at which each plan starts to pay.

What a spreadsheet cannot do is act. It cannot warn you when a due date is two days away, collect the tracking page, draft the letter or tell you the case is too weak to fight. Those are the jobs that tools take on, and they matter more as volume grows.

What are the signs you have outgrown the sheet?

Score yourself honestly. One point for each sign that applies.

Sign	Points
You have missed a due date, or nearly did, in the last six months	2
You get more than 10 disputes a month	1
More than one person edits the sheet	1
Evidence lives in several places: email, shared drives, carrier sites	1
Each response takes you more than 30 minutes	1
You update the sheet by hand after every step	1
You cannot tell at a glance which disputes are due this week	1
You have lost track of an outcome or a fee	1

A score of 0 to 2 means the sheet is probably fine. A score of 3 to 4 means a free plan is worth testing. A score of 5 or more means you are paying for the sheet in time and risk, and a flat monthly plan will likely cost you less.

The cost of the sheet is easy to underestimate because it hides in small tasks. Suppose you spend 6 minutes per dispute on tracking alone, updating statuses, setting reminders and chasing dates, and you handle 20 disputes a month. That is 120 minutes, or 2 hours. At $30 an hour, it costs $60 a month before you have written a single letter. Add one slipped deadline a quarter. If your usual win chance is 40% on a $115 case, a missed response loses an expected $46, which is about $15 a month averaged over the quarter. The tracking overhead alone is about $75 a month, against $19 for a Starter plan. These are our assumptions, so use yours.

What does your spreadsheet hold, and where does each column go?

Most chargeback sheets have the same fields. The table maps each one to what happens after you migrate.

Spreadsheet column	In an app	What to do
Dispute or order number	Pulled from your payments account	Nothing to copy
Amount	Pulled from the dispute	Nothing to copy
Reason	Pulled from the dispute	Nothing to copy
Date opened	Pulled from the dispute	Nothing to copy
Due date	Shown in the dispute list	Check it matches the sheet
Evidence gathered	Built by the tool from your records	Add your own files for special cases
Notes on the customer	Not in the payments data	Keep in the order notes or the sheet
Carrier and tracking	Read from the fulfilment record	Check it is there
Decision: fight, accept or refund	A verdict on whether it is worth fighting, in some tools	Treat as advice, then decide
Outcome and date	Pulled from Shopify when decided	Nothing to copy
Fees paid and recovered	Visible in Shopify	Keep a monthly total
Time spent	Not tracked by tools	Keep in your own sheet
Lessons learned	Not tracked	Keep in the sheet or a notes file

The pattern is clear. The facts that come from Shopify, such as order, amount, reason and outcome, are usually pulled in for you, so you do not retype them. What a tool cannot know is your judgement, your time and your lessons. Those stay in a spreadsheet, which is why it does not disappear.

Because the tool works from your Shopify Payments disputes, you generally do not need to import the sheet. Ask any vendor what it reads and what it stores before you connect it. ChargeFix reads customer data during review and does not save it, and its data processing agreement is public.

How do you migrate, step by step?

Ten steps, in order.

Step 1: Back up the sheet

Make a copy with today's date in the name and keep it somewhere safe. Do not edit the original while you migrate. You are protecting your history and your open disputes.

Step 2: List every open dispute and its due date

Filter your sheet for anything not yet decided. For each, write the order number, amount, reason, due date and whether evidence has been submitted. This is the most important list in the migration, because the biggest risk is a due date lost in the handover. Typical response windows run 7 to 21 days.

Step 3: Decide who owns each open dispute

For every open dispute, choose one owner: the sheet process or the app. Evidence is final once submitted, so never let both submit. A simple rule works well: disputes opened before the cut-over date stay in the old process until they are done, and disputes opened after go to the app.

Step 4: Choose the cut-over date

Pick a date, not a feeling. Two tips. First, avoid your busiest week. Second, consider cutting over just after the 1st of a month if your plan counts usage monthly. ChargeFix, for example, counts a dispute as one filing the first time its evidence is saved or filed, and usage resets on the 1st, so a fresh month gives you a full allowance.

Step 5: Install the app in Manual mode

Connect it, check which payment accounts it can see, and keep it in Manual mode so nothing is sent without your approval. In ChargeFix, manual is the default. Look at one or two existing disputes to confirm the tool reads the order, shipping and payment data correctly. Be careful with old, closed disputes: opening or saving them can count against an allowance, so test on live ones.

Step 6: Set up notifications and access

Make sure due-date reminders go to a person who will see them. If a second person helps, give them their own login with only the access they need, not a shared password.

Step 7: Run in parallel on about ten disputes

For the first ten new disputes, prepare the response both ways: your usual process and the tool's draft. Submit from one only. Compare the two before you choose. This is how you learn where the tool is strong and where it needs your files.

Step 8: Score the parallel run

Use the pass marks below. If it passes, proceed. If it does not, extend the parallel run or change the plan.

Step 9: Cut over

Make the app your single place for new disputes. Stop updating the old columns. Finish any old open disputes in the old process, and mark them as done in the sheet when they close.

Step 10: Slim the sheet down

Keep the history, and keep a small monthly scorecard. We cover that below.

What does the open-dispute handoff look like?

A small table makes the handover safe. Here is an illustration with made-up cases for a store cutting over on the 12th.

Order	Amount	Reason	Opened	Due	Status at cut-over	Owner
4821	$120	Item not received	3rd	17th	Evidence ready, not submitted	Old process, submit by the 14th
4833	$75	Fraudulent	8th	22nd	Not started	Old process, to finish by the 20th
4840	$210	Not as described	11th	25th	Not started	App, moved over because nothing was submitted
4851	$60	Credit not processed	13th	27th	Opens after the cut-over	App

The column that matters is the last one. Each dispute has exactly one owner and a date. If a dispute opened before the cut-over would be easier to handle in the app, you can move it, but only if nothing has been submitted for it. Write it down either way.

What are the pass marks for the parallel run?

Decide the pass marks before you start, so the result cannot talk you into a choice. Here is a template.

Check	Pass mark
The tool found the right order, customer and shipping data	10 of 10 disputes
Delivery proof was picked up where it existed	At least 8 of 10
The drafted letter matched the dispute reason	10 of 10
You would have submitted the tool's draft with light edits	At least 7 of 10
Time to review a draft, compared with your usual time	At least 50% shorter
Any missed or late deadlines during the run	None

Time the review with a stopwatch. If your usual response takes 35 minutes and the review takes 9, the time saved is 26 minutes per dispute. At 20 disputes a month, that is about 8.7 hours, worth about $260 at $30 an hour, before the plan cost.

If the tool misses delivery proof you know exists, find out why. It may be a naming difference in your records, a carrier the tool does not read or evidence outside Shopify. Fixing the cause is better than working around it every time.

Illustration: a one-person store with eight disputes a month

Rafa sells candles and tracks eight disputes a month in one tab. His score on the signs table is 3: one near miss, evidence in email and a status he updates by hand.

Timeline:

Days 1 to 2. He copies the sheet and lists three open disputes with their due dates.
Day 3. He decides the three stay in the old process and everything new goes to the app.
Days 4 to 5. He connects a free plan in Manual mode and checks two live disputes.
Days 6 to 12. Two new disputes arrive. He prepares both ways and submits from the app on one. On the free plan's allowance of 2 filings, he stops there and notes the quality.
Day 13. The three old disputes close. He moves up to a $19 Starter plan, with its 14-day free trial, and keeps the slim scorecard.

Rafa's sums: 8 disputes at 35 minutes by hand is 4.7 hours, or $140 at $30 an hour. With 9-minute reviews it is 1.2 hours, or $36, plus $19 for the plan, so $55. He saves about $85 a month, and his tracking risk drops to nearly nothing.

Illustration: a three-person team on a shared sheet

A fashion store has a founder, a support agent and a part-time VA, all editing one Google Sheet. They handle 30 disputes a month. The score on the signs table is 6: two missed dates in the past year, shared edits, evidence in three places and a daily status chase.

The risks here are about people, not data. Their plan:

The founder writes the decision rule: accept or refund under $30 with no proof, ask before fighting anything over $500.
The support agent owns the daily check of due dates for the first two weeks.
The VA is given a limited login to review drafts.
They run the parallel test on the first ten new disputes, with the agent scoring each against the pass marks.
After cut-over, the sheet becomes a monthly scorecard that the founder updates in 10 minutes.

At 30 disputes, a Growth plan at $49 with 8-minute reviews costs about $49 plus 4 hours of review time. By hand it was 17.5 hours. The saving is roughly 13.5 hours a month, and the real gain is a single source of truth that no one has to chase.

Illustration: a high-volume store moving in phases

A store with 80 disputes a month does not need to move everything at once. It can migrate by reason code.

Phase 1. Item not received disputes move first, because the evidence is mostly tracking and delivery data that a tool reads well.
Phase 2. Credit not processed and duplicate disputes follow, because they rest on refund and order records.
Phase 3. Fraud disputes move last, because they need the most judgement and the tool's score and verdict deserve the most checking.

Each phase has its own parallel run of about ten disputes and its own pass marks. A phased plan takes about six weeks and keeps risk low. Our reason code guides explain the evidence for each category.

What should you keep in a spreadsheet afterwards?

Not much, and that is the point. Keep a slim sheet with one row per month.

Month	Disputes opened	Wins	Losses	Accepted or refunded	Fees paid	Fees returned	Tool cost	Hours spent	Missed deadlines	Notes
___	___	___	___	___	$___	$___	$___	___	___	___

From this one row you can work out net recovered per dispute, time per dispute and whether the plan still pays. It takes about ten minutes a month. Our chargeback app vs doing it yourself template gives you a fuller scorecard if you want to test the tool properly, and the chargeback ROI calculator guide shows how to turn it into a return.

Also keep a lessons tab. When a case surprises you, note what you learned: a carrier that rarely scans, a product that causes "not as described" claims, a descriptor that confuses customers. Those notes drive prevention, which saves more than any tool.

What should you ask a vendor before you migrate?

A short email before you connect anything saves surprises later. Ask these, and keep the replies.

Which payment accounts and dispute types do you read, and which do you not?
How do you count a dispute against my plan, and when does the count reset?
What happens to disputes that are already open when I connect?
Can I keep Manual mode on, and can I turn automatic filing off at any time?
What happens at the plan limit: do you stop, charge more or ask me first?
What customer data do you read and store, and is there a data processing agreement?
How do I cancel, and what do I keep: drafts, history, exports?

If a vendor cannot answer in plain words, treat that as information. A migration is a good moment to learn how a company behaves before you depend on it.

What does the first month after cut-over look like?

The first month is for building trust and catching problems early. A simple weekly rhythm works.

Week 1: read everything. Review every draft before it goes out, and note each change you make. Time yourself on each one. Check every due date on the dispute list against the one in Shopify, because a mismatch is the earliest sign of trouble.

Week 2: look for patterns. Which reasons produce strong drafts, and which need your files? If the tool keeps missing the same piece of evidence, find out why. It may be a carrier it does not read or a record kept outside Shopify.

Week 3: tighten your rules. Write down your decision rule for what to fight, what to accept and what to refund, and check that the tool's verdicts match your judgement. Start deciding which cases you trust the drafts for, with a view to the safest slice for automatic filing later.

Week 4: run the scorecard. Fill in the monthly row. Compare time per dispute with your baseline, count missed deadlines, add up the plan cost and see whether the tool is earning its fee. If it is, keep going. If it is not, check the plan size before you give up on the tool.

By the end of the month you should know three things: how often you change the drafts, how much time you save and whether any deadline nearly slipped. Those three answers tell you whether to stay, upgrade or leave. They also give you the numbers to decide when to try automatic mode, which our guide to automatic versus manual chargeback response covers in detail.

What can go wrong in a migration?

A dispute falls between the two processes. This is the main risk. The handoff table and one-owner rule prevent it.
Double submission. Shopify accepts one evidence submission per dispute and treats it as final. Do not prepare in both and then submit from both.
Spending your allowance on tests. On plans that count filings, opening old disputes can use up the allowance. Test on live ones.
Missing evidence. The tool may not see proof that lives outside Shopify. Attach your own files for those cases.
Notification gaps. If reminders go to a retired inbox, nobody sees a due date.
Shared logins. Use limited accounts, and remove access when someone leaves.
Trusting the tool blindly. Stay in Manual mode until the parallel run passes, and keep reading drafts.
Dropping the history. Keep the old sheet. You will want it for comparisons.

What about privacy during a migration?

Moving to an app means a new party sees customer data, so it deserves a few direct questions before you connect.

What customer data does the tool read, and when?
Does it store that data, and for how long?
Is there a data processing agreement, and is it public?
Who at the vendor can see it?
What happens to it if I leave?

ChargeFix reads customer data during review and does not save it, and its data processing agreement is public. Whatever tool you pick, get the answers in writing. Do not paste customer data into forms or chat tools that you have not checked.

Common mistakes when leaving a chargeback spreadsheet

Switching in your busiest week. Pick a quiet stretch.
Moving open disputes without a plan. Give each one an owner and a date.
Skipping the parallel run. Trust comes from comparing, not hoping.
Retiring the sheet completely. Keep a monthly scorecard and a lessons tab.
Not measuring time. Without a stopwatch you cannot show the tool earned its fee.
Forgetting about reminders. Check they reach a person.
Assuming the tool replaces process. It still needs a decision rule and a review habit.
Importing everything for its own sake. Old closed disputes rarely need to be in the new tool.

What we checked, and what you should check

We read Shopify's help center pages on the chargeback process, vendor pricing pages and Shopify App Store listings for the tools in this series, and ChargeFix's own plan, counting and data descriptions on 30 October 2026. Time per dispute comes from Redo's estimate of 20 to 45 minutes by hand. The tracking overhead, the hourly value and the pass marks are our assumptions.

What you should check: what any tool you pick reads from your account, how it counts disputes against a plan, how it handles disputes already open when you connect and what its data statement says. Our chargeback cost calculator and dispute deadline countdown help with the numbers and the dates.

Frequently asked questions

Do I need to import my chargeback spreadsheet into an app?

Usually not. A tool that works from your Shopify Payments disputes reads the order, amount, reason and outcome from Shopify, so you do not retype them. Keep your sheet as your own history, and ask any vendor what it reads and stores before you connect it.

How long does it take to move from a spreadsheet to a chargeback app?

About two weeks for most stores: a few days to prepare, a day or two to install, about a week of parallel running on roughly ten disputes, and a day to cut over. High-volume stores can phase it by reason code over about six weeks.

What happens to disputes that are already open?

Give each open dispute one owner and a date. A simple rule is that disputes opened before the cut-over finish in the old process and later ones go to the app. Evidence is final once submitted, so never submit the same dispute from both places.

Can I run my spreadsheet and the app together?

Yes, for a short parallel run. Prepare about ten new disputes both ways, compare the results, and submit from only one. Shopify accepts a single evidence submission per dispute, so a second one cannot add to the first. After the run, make the app your source of truth.

What should I keep in my spreadsheet afterwards?

A slim monthly scorecard: disputes opened, wins, losses, fees paid and returned, tool cost, hours spent and missed deadlines. Add a lessons tab for patterns, such as carriers that rarely scan. This takes about ten minutes a month and shows whether the tool still pays.

Will the app count my old disputes against my plan?

It depends on how the plan counts. ChargeFix counts a dispute as one filing the first time its evidence is saved or filed, and usage resets on the 1st, so opening old closed disputes to test can use allowance. Test on live disputes, and ask any vendor how it counts.

Is a spreadsheet really so bad?

No. Below about five disputes a month with one person and no missed dates, it is fine and costs nothing. It struggles with deadlines, scattered evidence and handoffs, which is why volume and missed dates are the signs to watch.

How do I know the migration worked?

Compare the parallel run against pass marks you set in advance: correct data on every dispute, delivery proof found on most, drafts you would submit with light edits, review time at least half your old time and no late deadlines. Then track the monthly scorecard for a quarter.

Should I move to Auto mode right away?

No. Stay in Manual mode through the parallel run and for your first 20 or so disputes, record how often you change drafts, then automate the safest slice. Our guide to automatic versus manual chargeback response gives a formula and a staged plan for the decision.

Start free trial with ChargeFix

If your chargeback spreadsheet is starting to creak, ChargeFix has a free plan with 2 filings a month, which is enough to run a small parallel test, and paid plans move up as your volume grows, with a 14-day free trial. It never takes a cut of what you win. It checks your evidence item by item, gives each case a strength score and a worth-fighting verdict and drafts a letter from your real records. Manual mode is the default, so nothing goes to the bank until you say so. It works with Shopify Payments only.

Start free trial