Moving from a spreadsheet to a chargeback app: a set-up guide for UK Shopify stores

The spreadsheet worked for the first six disputes. It had a tab for each month, a column for the due date, and a cell that turned red when something was late. Then a busy autumn brought fourteen disputes in a fortnight, one deadline slid past because the red cell sat on a tab nobody opened, and you spent a Sunday copying tracking numbers into a letter. The spreadsheet did not fail you. It simply reached the size where a person, not a sheet, is doing the work.

Moving from a spreadsheet to a chargeback app is a good idea when the spreadsheet is a to-do list that you have to maintain by hand, and a bad idea if you throw the spreadsheet away. The best set-up keeps a simple spreadsheet as your own dispute log and adds the chargeback app for what a sheet cannot do: pulling the order, payment and delivery records for you, scoring the evidence, drafting the response and watching the deadline. You run both side by side for a few weeks, compare, and then decide what the sheet is still for.

This guide is for you if:

• You run a UK Shopify store on Shopify Payments, you track disputes in a spreadsheet, and you suspect it is costing you time or deadlines.
• You are thinking about a chargeback app but worry about losing your history, your process or your control.
• You want a step-by-step way to move across without missing a due date, with the columns and formulas worth keeping.

Last updated: 22 October 2026. Written by the ChargeFix team. Reviewed against sources on 22 October 2026. General information, not legal or tax advice.

Disclosure. ChargeFix is a chargeback app, so I have an interest in you using one. I have written the guide so that the spreadsheet stays useful either way, and I say when a spreadsheet alone is enough. The stores and numbers are made up to show the method.

The 30-second answer (TL;DR)

• Switch when the spreadsheet depends on you remembering things: deadlines, evidence, drafting. Stay if you get a couple of disputes a month.
• Do not delete the sheet. Keep a lean dispute log for outcomes, costs and patterns, and let the app do the gathering and drafting.
• Run both in parallel for two to four weeks, in Manual mode, and compare the app's drafts with what you would have written.
• ChargeFix only sees Shopify Payments disputes and the last 60 days of orders, so keep your own history for anything older or from other gateways.
• Do not store customers' personal details in the spreadsheet unless you need to. Order numbers are enough.

Do this today (10 minutes):

1. Open your spreadsheet and count the disputes in the last 90 days.
2. Next to each, note the minutes it took you. Total them.
3. If the total is under two hours, a spreadsheet is probably fine. If it is over five, read on.

From spreadsheet to app

Stage	What you do	Spreadsheet role	App role
1. Check	Decide if a switch is worth it	Source of your time and counts	Not yet installed
2. Prepare	Clean the sheet and define the log	Becomes the dispute log	Not yet installed
3. Parallel run	Use both for two to four weeks	You still record	Drafts, you compare
4. Switch	Let the app lead on new disputes	Records outcomes only	Gathers and drafts
5. Review	Compare time, errors and results	Source of evidence	Source of drafts

When has a spreadsheet stopped being enough?

A spreadsheet is a fine tool until the work around it outgrows it. These are the signs, with a rule of thumb for each.

Sign	What it looks like	Why a spreadsheet struggles
A missed or close deadline	A due date nearly passed unnoticed	A sheet cannot alert you unless you build and watch it
Slow evidence gathering	You copy tracking, addresses and emails by hand	A sheet does not read your Shopify records
Inconsistent responses	Each letter is written differently	A sheet does not draft or enforce a structure
No score before filing	You guess whether it is worth fighting	A sheet has no view of evidence strength
Volume above about five a month	Admin time passes an hour a week	The cost of copying grows with every dispute
More than one person	Two people edit the same row	Version problems and silent errors
You dread dispute day	The process lives in your head	It is not written down or repeatable

If none of these is true, keep the spreadsheet. A store with two small disputes a month gains little from an app, and Shopify's built-in response plus a good spreadsheet is a sensible set-up. The signs that matter most are the first two: a close call on a deadline, and the hours lost to copying.

For context on the deadlines you are tracking: Shopify's help pages say the response deadline is usually 7 to 21 days after the dispute is filed, with 11:59 PM as the cut-off if no time is shown, that submitting early locks your edits, and that if you add no evidence Shopify submits what it collected on the due date. A spreadsheet can hold all of that, but only a person can keep it current.

What does a chargeback app do that a spreadsheet cannot?

A spreadsheet stores what you type. An app connected to your store reads what is already there. That difference is the whole case for switching.

Job	Spreadsheet	Chargeback app
Notice a new dispute	You notice and add a row	It sees the dispute in Shopify
Find the order, payment checks and tracking	You copy them in	It reads them from the order
Show what is missing	You check by eye	It lists missing evidence
Score evidence strength	You judge	It scores item by item
Draft the letter	You write it	It drafts from your records
Watch the due date	A colour or a reminder	It tracks it for you
File the response	You do it in Shopify	You or the app, under your rules
Keep history	Everything you enter	Case ID, amount, reason, status and dates
Learn from outcomes	You build the charts	Limited, so keep your own log

The last two rows are why the sheet should stay. ChargeFix, for example, stores minimal data: the case ID, amount, reason, status, dates and shop settings. Its view is limited to Shopify Payments disputes and a 60-day window of orders. If you want a long history, a count of costs or disputes from other gateways, your spreadsheet holds what the app does not. Its help page also says a filed response cannot be changed, which is another reason to keep your own record of what was filed.

If you want to see how tools compare before you pick one, read our guide to the best chargeback apps for Shopify in the UK.

Which spreadsheet columns are worth keeping?

Clean the sheet before you do anything else. Keep the columns that tell you something and drop the ones you only filled in out of habit. This is a lean layout for a dispute log that works with or without an app.

Column	Example	Why keep it
Order number	#10482	Links to Shopify; no personal data
Date dispute opened	14 Oct 2026	Starts the clock
Deadline	28 Oct 2026, 11:59 PM	The only date that matters
Amount disputed (£)	95.00	Cost tracking
Dispute fee (£)	10.00	The UK fee, returned only on a win
Reason	Product not received	Pattern spotting
Evidence found	Tracking, delivery scan, emails	What you could show
Fight or accept	Fight	Your decision
Filed on	24 Oct 2026	Proof you were in time
Filed by	Me, or the app	Accountability
Outcome	Won, Lost, Pending	Win rate
Date decided	30 Nov 2026	Time to decision
Notes	Customer wrote twice	Lessons

Leave out names, emails and addresses. The order number lets you find everything in Shopify, and a sheet without personal data is much easier to share with a VA or an accountant under UK GDPR. If you do need personal data in the sheet, restrict who can open it and delete it when you no longer need it.

Add three summary cells at the top, because they answer most questions. These formulas work in Google Sheets and Excel. Replace the column letters with your own.

Win rate: =COUNTIF(K:K,"Won") / (COUNTIF(K:K,"Won") + COUNTIF(K:K,"Lost"))
Total disputed (£): =SUM(D:D)
Fees paid and not returned (£): =SUMIF(K:K,"Lost",E:E)

Win rate counts only decided disputes, which is why pending ones are left out. And fees are "not returned" only when you lose, so that formula sums the fee column for lost cases.

What should you not move into the app?

A chargeback app is not a place to dump your whole spreadsheet. Some things belong elsewhere.

Keep in the spreadsheet or elsewhere	Why
Disputes older than the app's window	ChargeFix reads only the last 60 days of orders
Disputes from PayPal, Stripe or other gateways	ChargeFix handles Shopify Payments disputes alone
Your cost and fee totals	The app stores minimal data
Your decision rules	They are your policy, not a setting alone
Lessons learned	Patterns need your judgement
Customer conversations	Keep them in your helpdesk or email

Many mistakes in a move come from assuming the app will hold everything. It will hold what it needs to do its job. The rest of your history is yours to keep.

How do you run a parallel run without missing a deadline?

A parallel run means doing the work both ways for a short time, so you can compare the app's output with your own before you trust it. Keep the rules simple and the safety nets in place.

Rule	Why
Install in Manual mode	Nothing is filed without you reading it
Keep the spreadsheet due date column	A second view of each deadline
File from the app's draft only after you check each claim	Catches errors early
For the first two disputes, also write your own version	Shows the difference
Never run two tools on the same dispute	A duplicate filing can confuse the result
Calendar each due date two working days early	A buffer if anything fails

Manual is the default in ChargeFix and Auto mode is off until you turn it on. When you eventually consider auto filing, our guide to chargeback automation explains the limits worth setting. For now, the goal is to learn how the app writes and whether its drafts are accurate.

Check each draft against your records. Every statement should trace to something you can find: a tracking scan, a payment check, an email. If the draft says something you cannot find, remove it. Ask the vendor how the tool handles gaps, and in particular whether it leaves out claims the records do not support. ChargeFix's public page says its letters omit claims the records cannot support, and I would still check each one.

What should you compare during the parallel run?

Use a short scorecard for each dispute. It takes five minutes and gives you evidence for the switch.

Measure	Spreadsheet route	App route
Minutes to prepare the response
Evidence items found
Evidence items missed
Errors or unsupported claims
Edits you made to the draft
Days before the due date it was ready

After four to six disputes, add up the columns. If the app saves you a clear amount of time, finds at least as much evidence and its drafts need few edits, it has earned a bigger role. If not, ask the vendor why, or stay with the sheet. A parallel run costs a few hours, and it is the cheapest way to avoid a bad decision.

Decisions on filed disputes can take a long time, so judge the first weeks on process quality: time saved, completeness and accuracy. ChargeFix's help page says a decision usually arrives 30 to 75 days after filing, which means wins and losses come later.

How do you build a deadline tracker in a spreadsheet?

If you keep the spreadsheet, make it do the one job a sheet does well: nagging you. Two columns and one rule are enough.

Column	Formula or entry	What it does
Deadline	The date and time shown on the dispute in Shopify	The source of truth
Days left	=ROUNDDOWN(F2-NOW(),0) where F2 is the deadline	Counts down in whole days
Status	Won, Lost, Pending, Filed	Lets you filter

Add conditional formatting to the days left column. Colour a cell amber when the value is 3 or less and red when it is 1 or less, and apply it only to rows where the status is not Filed, Won or Lost. In Google Sheets and Excel this is a custom rule on the column, and you can sort by days left so the most urgent row is always at the top.

Two cautions. A deadline tracker only works if you open the sheet, so pair it with a calendar entry two working days before each deadline. And the time shown on the dispute can differ from your local time, so copy it exactly from Shopify. Shopify's help pages say that if no time is shown, the cut-off is 11:59 PM on the displayed date, and the deadline is usually 7 to 21 days after the dispute is filed.

How do you use the dispute log to improve, month by month?

The real value of a dispute log is the pattern it shows, and that is the part an app does not hand you. Once a month, spend 20 minutes on these checks.

Question	How to answer it in the sheet
Which reason costs me most?	Sum the amount by reason, using a pivot table or SUMIF
Which products come up most?	Add a product column and count by product
Which carrier do disputes cluster around?	Add a carrier column and count
What is my win rate by reason?	COUNTIFS on reason and outcome
How long do decisions take?	Date decided minus date filed
What did disputes cost me in fees?	Sum the fee column for lost disputes

A COUNTIFS formula for win rate by reason, with reasons in column F and outcomes in column K, looks like this.

=COUNTIFS(F:F,"Product not received",K:K,"Won") / (COUNTIFS(F:F,"Product not received",K:K,"Won") + COUNTIFS(F:F,"Product not received",K:K,"Lost"))

Copy it once per reason. When one reason has a poor win rate, the answer is usually in your records, not your letters. Our 30-point chargeback audit shows what to fix.

Back up the log. Use the export option in Google Sheets or Excel to save a copy as a file each month, and keep it somewhere other than your working folder. If you ever need to show an accountant, a bank or a new VA what happened, a dated export is easier to trust than a sheet that anyone could have edited.

You can also export order lists from your Shopify admin to compare against your log, which is useful for checking your dispute rate: disputes in the month divided by orders in the month. I have not set out the steps, because Shopify's export screens change, so look for the export option on your orders page.

What can conditional formatting do beyond the deadline column?

Conditional formatting is the cheapest alert system you own, so use it on more than one column. A few rules turn a flat sheet into something that tells you where to look.

Rule	Applies to	Colour
Days left 3 or less, status Pending	Days left	Amber
Days left 1 or less, status Pending	Days left	Red
Outcome is Lost	Outcome	Grey
Evidence found is blank	Evidence column	Yellow
Filed on is later than the deadline	Filed on	Red

The last rule matters most. If a filing date is ever later than its deadline, you want to see it in red the same day, and then ask why. Conditional formatting costs nothing and takes ten minutes to set up, and it catches the slow drift that makes a sheet unreliable. If you share the sheet with a VA, lock the formatting cells so a stray edit does not remove the rules.

What is a dated plan to move across?

This plan starts on Monday 26 October 2026 and runs for about four weeks.

Date	Task	Time
Mon 26 Oct	Count disputes and minutes for the last 90 days	30 minutes
Tue 27 Oct	Clean the spreadsheet to the columns above and remove personal data	45 minutes
Wed 28 Oct	Add the three summary formulas and check them against a known dispute	20 minutes
Thu 29 Oct	Read the app's permissions, privacy policy and data processing agreement	30 minutes
Fri 30 Oct	Install the app in Manual mode and connect it	20 minutes
Mon 2 Nov	Run one old closed dispute through the app and compare with what you filed	45 minutes
Wed 4 Nov	Start the parallel run on live disputes	Ongoing
Fri 6 Nov	First scorecard check	20 minutes
Fri 13 Nov	Second scorecard check	20 minutes
Mon 16 Nov	Decide what the app leads on, and what the sheet keeps	30 minutes
Fri 20 Nov	Write the one-page process: who, what, when	30 minutes

For the data checks on Thursday, our guide on whether it is safe to connect a chargeback app to your Shopify store lists what to ask.

What does the switch look like for three UK stores?

These stores are made up to show the choice. They are not real merchants.

Wickham Teas. It has two or three disputes a month at about £30. The spreadsheet takes 20 minutes a month. An app saves little. The owner adds the clean columns, a calendar reminder for every due date, and keeps Shopify's default response as a fallback.

Trelawney Surf. Eleven disputes in a busy month, around £110 each, with two close calls on deadlines. The spreadsheet takes about six hours a month. The owner runs a four-week parallel run, finds the app's drafts need few edits and moves the gathering and drafting across, keeping the sheet for outcomes and costs.

Brookfield Audio. Twenty disputes a month, a team of three, and disputes from both Shopify Payments and PayPal. The app covers Shopify Payments only, so the sheet stays the single log of everything, the app prepares the Shopify Payments responses, and PayPal disputes stay on a manual process.

What is different for UK merchants?

• Fees. Shopify's UK dispute fee is £10, taken with the disputed amount when the dispute opens and returned only if you win. Your spreadsheet should show both.
• Data protection. UK GDPR applies to any personal data in your sheet. Order numbers avoid the issue, and the ICO's guidance applies if you keep more.
• Gateways. Many UK stores also take PayPal, and an app that sees only Shopify Payments will not cover those disputes.
• Billing. Some competing apps price in US dollars, so ask about GBP before you compare costs.
• Shopify Protect. It is for US stores only, so UK merchants have no free guarantee to lean on.

What I could not verify: how any particular app imports an existing spreadsheet, since ChargeFix reads from Shopify rather than a file, the real time you will save, and how competing tools treat historical data. Test with your own disputes.

What are the common mistakes when moving from a spreadsheet?

1. Deleting the spreadsheet. Keep it as your log of outcomes, costs and patterns.
2. Skipping the parallel run. Compare the app's drafts with your own before you trust it.
3. Switching on auto filing straight away. Start in Manual mode.
4. Storing personal data in the sheet. Use order numbers.
5. Forgetting disputes outside the app's reach. Other gateways and older orders stay with you.
6. Dropping your own deadline column. Keep a second view of each due date.
7. Moving mid-dispute. Let open disputes finish the way they started.
8. Not reading the permissions. Check what the app can see before you install.
9. Judging by results in week two. Decisions take weeks, so judge process first.
10. Not writing the process down. A one-page process makes the next change easy.

Frequently asked questions

When should I move from a spreadsheet to a chargeback app?

Move when the spreadsheet depends on you remembering deadlines, copying evidence and writing letters by hand, especially if you have had a close call on a deadline or spend more than an hour a week on disputes. If you get a couple of disputes a month, a good spreadsheet may be enough.

Do I still need a spreadsheet after installing a chargeback app?

Yes, a lean one. The app handles gathering, scoring, drafting and deadline tracking, but it stores minimal data and sees only Shopify Payments disputes and recent orders. Keep a dispute log for outcomes, costs, patterns and disputes from other gateways, using order numbers rather than personal details.

Can I import my spreadsheet into a chargeback app?

It depends on the app. ChargeFix reads from your Shopify store rather than from a file, so there is nothing to import, and its view is limited to Shopify Payments disputes and the latest 60 days of orders. Keep your history in your own sheet. Ask any other vendor how it treats imported history.

What columns should a dispute log have?

Order number, date opened, due date and time, amount, dispute fee, reason, evidence found, fight or accept, filed on, filed by, outcome, date decided and notes. Leave out names, emails and addresses. These columns give you win rate, cost and patterns without holding personal data.

How do I calculate my win rate in a spreadsheet?

Count Won and divide by Won plus Lost, leaving out pending disputes. In Google Sheets or Excel, with outcomes in column K, the formula is the count of "Won" divided by the count of "Won" plus the count of "Lost". Use decided disputes only so the figure is not distorted.

How long should I run the sheet and the app together?

Two to four weeks, or four to six disputes, whichever comes later. Use Manual mode, keep your own due date column, compare time and accuracy for each dispute, and only widen the app's role once its drafts need few edits. If you get few disputes, run old closed ones through it.

Will I lose my dispute history if I switch?

Not if you keep your spreadsheet. A chargeback app stores what it needs, which for ChargeFix is the case ID, amount, reason, status, dates and shop settings, and it sees a limited window of orders. Your own log holds the full history, the costs and anything from other gateways.

Is it safe to keep customer details in the spreadsheet?

It is better not to. Use order numbers, which let you find everything in Shopify, and restrict who can open the sheet. UK GDPR applies to any personal data you keep, so delete what you do not need. If you share the sheet with a VA or accountant, personal data makes it riskier.

What if my app does not cover my other payment gateways?

Keep a manual process for them. ChargeFix, for instance, sees only Shopify Payments disputes, so PayPal or Stripe disputes need another route. Keep one master spreadsheet of every dispute, flag which are handled by the app, and set a calendar reminder for the others.

Can the spreadsheet and the app both file the same dispute?

They should not. Pick one owner for each dispute, record it in the log and never file the same dispute twice. A filed response cannot be changed in ChargeFix, and a duplicate filing can confuse the result. Calendar every due date two working days early as a backup.

Start free trial with ChargeFix

If your spreadsheet has become a chore, ChargeFix is a chargeback app for Shopify Payments disputes. It gathers the real order, payment-check and delivery records for each dispute, scores the evidence and drafts the response from your own data, never inventing facts. You can run it beside your spreadsheet, review and file each response yourself or let Auto mode handle them, and a free plan lets you test it on real disputes. Start free trial

Sources

• Responding to chargebacks and inquiries, Shopify Help Center
• Managing chargebacks in the Shopify admin, Shopify Help Center
• What needs to be included in the contract, ICO
• ChargeFix support page
• ChargeFix privacy policy
• Stripe, Best practices for preventing fraud: further reading on stopping disputes before they start
• Adyen, Manage disputes: further reading on how another payment provider handles disputes