From spreadsheet and screenshots to a chargeback app: set it up in one afternoon

ChargeFix guide cover with a lightning bolt icon: From spreadsheet and screenshots to a chargeback app

Your chargeback spreadsheet works until the week three disputes land at once. Then you are hunting through email, tracking pages and screenshots with a due date ticking. Can one afternoon fix that?

Moving from a spreadsheet to a chargeback app takes one afternoon of your own preparation, because the slow part is deciding what evidence you keep, not clicking install. This guide gives you the afternoon plan, a checklist for choosing a chargeback app, and a safe way to run both side by side.

This guide is for you if:

  • You track Shopify disputes in a spreadsheet, a notes app or a folder of screenshots.
  • You have missed, or nearly missed, a response date, or you dread the next dispute.
  • You want to try a chargeback app without putting live disputes at risk.

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

The 30-second answer (TL;DR)

  • A chargeback app saves time on the work that repeats in every dispute: finding the order, tracking, delivery proof and customer messages, then putting them in one file.
  • The preparation matters more than the tool. Decide your evidence list, your reasons and your owner before you switch.
  • Shopify gives you usually 7 to 21 days to respond and sends whatever is on file on the due date, so a late start costs real money.
  • Run your old chargeback spreadsheet and the new app side by side for your next few disputes, then retire the sheet.
  • Keep manual review on at the start, so you read every response before it goes out.
  • A good chargeback app keeps an audit trail, so you can see what was sent and when.

Do this today (10 minutes):

  1. Open your chargeback spreadsheet and count the disputes from the last 90 days.
  2. Write down how long the last one really took, from the alert to the submit button.
  3. Pick one person who owns disputes, and put their name at the top of the sheet.

The afternoon plan below turns those three numbers into a switch you can trust.

From dispute to decision

Stage What happens What your setup must do
Alert arrives Shopify tells you a dispute was filed Tell the owner the same day
Days 1 to 3 You find the order, tracking and messages Pull them into one place without retyping
Days 4 to 10 You write and check the response Match the evidence to the reason
Before the due date You submit Submit early, with a copy saved
After submit Card review, up to 75 days Log the outcome and what you learned

Why does a chargeback spreadsheet stop working?

A chargeback spreadsheet stops working when the work around the sheet becomes bigger than the sheet. The sheet records that a dispute exists. It does not find the tracking number, save the delivery page, pull the customer's emails or warn you that a date is close. You do all of that by hand, every time.

That is fine at one dispute a month. Shopify says you usually have 7 to 21 days to respond, and that Shopify Payments submits your response on the due date even if you added nothing. So the cost of a slow process is not just your time. It is a response that goes out thin because you ran out of days.

A spreadsheet also has a quiet weakness: it depends on memory. Which column holds the carrier name? Where did you save last month's screenshots? Did anyone reply to the customer from the shared inbox or from a personal one? When the person who built the sheet is away, the process is away too.

A quick story (illustration). Priya runs a candle store from Brisbane. Her chargeback spreadsheet has columns for date, order number, amount, reason and status, and a folder called "Disputes" with screenshots named after the day she took them. In a busy fortnight she gets three disputes in four days. She answers the first well, the second adequately and the third on the last morning, with a tracking link instead of a screenshot. She loses the third, not because she was wrong but because she was late. A spreadsheet did not cause that. A process that lives in one person's head did.

The fix is not a prettier sheet. It is to move the repeating parts of the work into a tool, and to write down the parts that stay human. That is what the rest of this guide sets up.

What does a chargeback app actually do for you?

A chargeback app for Shopify collects the evidence that already exists in your store and your carrier records, puts it against the dispute, and drafts a response you can send. It does the finding and the formatting. You still decide what is true and whether to fight.

In plain terms, a chargeback app should handle four jobs:

Job By hand in a spreadsheet In a chargeback app
Find the order Search Shopify, copy the number Matched to the dispute for you
Gather proof Open carrier pages, take screenshots Tracking and delivery records pulled in
Add customer messages Search email, forward, screenshot Supported emails attached
Draft the response Write from scratch each time Draft built from the real records

What it should not do is invent anything. A response built on made-up facts loses, and it can harm you with the card company. The rule I would hold any chargeback app to is simple: it uses only real data and real screenshots, and if a piece of evidence does not exist, it says so.

ChargeFix is built around that rule. It collects real tracking, delivery, postal records and supported emails, and it never invents facts. You grant Shopify permission when you install it, and you choose between two modes. In Manual mode it drafts and you review, confirm and send. In Auto mode it collects the evidence and submits on its own. The sections below work whichever tool you pick.

Is a chargeback app worth it for a small store?

A chargeback app is worth it when the time and the lost disputes it saves are bigger than what it costs, and you can test that with your own numbers before you commit. Small stores often see the saving in time first and in won disputes second.

Here is the sum, kept deliberately plain.

Illustration 1: the monthly time cost of doing it by hand. Suppose a store has 6 disputes a month. Each one takes 75 minutes by hand: finding the order, tracking, screenshots, emails and writing. That is 450 minutes, or 7.5 hours. If you value your time at A$40 an hour, the month costs A$300 in time.

Now suppose a chargeback app with manual review cuts each dispute to 20 minutes of reading and checking. That is 120 minutes, or 2 hours, or A$80 of time. The difference is A$220 a month, before counting any extra wins.

Item By hand With a chargeback app (manual review)
Disputes a month 6 6
Minutes each 75 20
Hours a month 7.5 2
Time cost at A$40 an hour A$300 A$80
Difference A$220 a month

Those figures are an illustration, not a promise. Replace them with your own. If you handle one dispute a month and it takes 40 minutes, the time saving is small, and the case for an app rests on safety: never missing a date.

Illustration 2: the cost of one missed response. A customer disputes a A$140 order. The Shopify Payments fee in Australia is A$25. If the response goes out thin or late and you lose, you are out the A$140 and the A$25 fee, so A$165, plus the goods if they have shipped. If a better-prepared response gives you a one in three chance of winning where a thin one gives you one in ten, you can see why the preparation is worth paying for.

None of this means every store needs an app. If you sell a handful of orders a week and rarely see a dispute, a good template and a calendar reminder may be enough. The honest test is the number of disputes and the number of times you were late.

Which parts of your chargeback spreadsheet should move into the app?

Move the repeating parts and keep the judgement calls. A chargeback spreadsheet usually mixes both, so sort each column before you switch.

Spreadsheet column Move to the app? Why
Order number and date Yes The app matches it to the dispute
Amount and fee Yes Comes with the dispute
Reason Yes Comes from Shopify
Tracking number and carrier Yes Repeats in every shipping dispute
Customer emails Yes, where supported Saves searching
Due date Yes The app should warn you
Decision to fight or accept Keep with you A judgement call
Notes on what you learned Keep with you Feeds prevention
Outcome Yes Logged for you

The columns you keep are the ones that need your knowledge of the customer, the product and the risk. For example, you know that a customer who emailed twice about a late parcel is a different case from one who never wrote. A chargeback app can attach the emails. Only you can say what they mean.

If your chargeback spreadsheet has columns that nobody uses, drop them now. A smaller sheet is easier to compare against the app during the trial.

What should you set up before you switch to a chargeback app?

Set up four things before you switch: an evidence list, a reason map, an owner and a response routine. Each takes ten to thirty minutes, and together they are the afternoon's real work.

The evidence list

Shopify's guidance describes the kinds of evidence that help: product details, fulfilment date and time, billing information, IP address and country, customer communication, tracking, and any earlier refunds or replacements. Write that list for your own store, with where each item lives.

EVIDENCE LIST (copy and edit)

Item                      Where it lives                 Needed for
Order and payment record  Shopify admin                  All reasons
Billing and IP match      Shopify admin                  Fraud, unrecognised
Shipping address          Shopify admin                  Not received
Tracking and delivery     Carrier page, tracking app     Not received
Customer emails           Support inbox                  Most reasons
Policy as shown          Store pages (screenshot)       Unacceptable, credit
Product page at purchase  Store pages (screenshot)       Unacceptable
Refund or replacement     Shopify admin                  Credit not processed

The reason map

Shopify lists eight reasons for card disputes: Fraudulent, Unrecognised, Duplicate, Subscription cancelled, Product not received, Product unacceptable, Credit not processed and General. For each one, write the two or three pieces of evidence that matter most. That map is what lets you check a draft quickly.

Reason Lead with Back it with
Fraudulent Billing and IP match, delivery to the billing address Prior orders, customer messages
Unrecognised Order and descriptor, delivery proof Customer messages, product page
Duplicate Two separate orders and what was in each Order records
Subscription cancelled Cancellation terms and billing dates Customer messages
Product not received Tracking and delivery proof Address match, messages
Product unacceptable Product page and photos at purchase Return policy, messages
Credit not processed Refund record or policy Customer messages
General Order, fulfilment, billing and messages Anything that fits the story

The owner

Name one person who sees every alert and one backup. In a one-person store, that is you and a calendar reminder. Write the names in the sheet header and keep them there.

The response routine

Write down the steps from alert to submit, with a day target for each. A simple version: same-day alert, evidence check within 2 days, draft by day 5, review by day 7, submit at least 3 days before the due date. Adjust to your window, which might be as short as 7 days.

How do you run the afternoon plan?

The afternoon plan is four blocks of about 45 minutes, with a break. You do not need live disputes to do it, and you should not do it in the week a due date is close.

Block Time What you do Result
1 12:30 to 1:15 Count disputes, write the evidence list and reason map Two pages of notes
2 1:15 to 2:00 Choose the app using the checklist below, grant Shopify access App connected
3 2:15 to 3:00 Check settings, pick manual review, test on a past dispute A practice draft to read
4 3:00 to 3:45 Write the routine, name the owner, set reminders One-page runbook

You can run this on any quiet afternoon. I would pick a Tuesday or Wednesday, away from the end of the month when you are busy with accounts.

Block 2 in detail: choosing the app

Use the checklist below. It is written so you can score any tool, and it does not depend on a brand.

CHARGEBACK APP CHECKLIST

[ ] Uses only real data and real screenshots, never invented facts
[ ] Shows exactly what will be sent before it is sent
[ ] Has a manual review mode, and you can keep it on
[ ] Pulls tracking, delivery proof and supported customer emails
[ ] Gives a clear audit trail of what was sent and when
[ ] Warns you before the due date
[ ] Lets you export or copy a response for your records
[ ] Tells you what it could not find
[ ] Asks only for the Shopify permissions it explains
[ ] Has a free way to try it before you commit

Two items deserve a second look. "Tells you what it could not find" matters because a good response is built on facts, and a gap is information. And "keeps an audit trail" matters because, later, you may want to know exactly what the card company saw.

What does a good first week with a chargeback app look like?

A good first week with a chargeback app is quiet. You connect it, check the settings, read the practice draft and write your routine. You do not need a dispute to arrive. Most stores learn more from replaying a past case than from waiting for a new one.

On day one, open a dispute you already closed and let the chargeback app build a draft from the order. Read it against what you actually sent. Did it find the tracking? Did it attach the emails? Did it miss the policy page you screenshot every time? That single comparison tells you whether the chargeback app suits your store.

On day two, fix the gaps. Move the shipping emails to a shared inbox the tool can reach, save your policy pages as screenshots, and add the missing pieces to your evidence folder. On day three, write the one-page runbook: who sees the alert, which mode you start in, and the dates you protect. By the end of the week you should have a chargeback app you understand, an evidence folder in order and a dispute tracker with the first row filled in.

If a real dispute lands during the week, run it side by side with your old sheet, as described above. That is the safest first live test of any chargeback app, because your sheet is still the backstop.

What is the safest way to run a the sheet and a chargeback app together?

The safest way is to run both side by side for your next three disputes, and to treat the app's draft as a second opinion on the sheet. You are not trusting a new tool with your money until it has proved itself on your own data.

Here is the routine.

  1. When a dispute arrives, add it to your the sheet as usual.
  2. Let the chargeback app build its draft in manual review mode.
  3. Compare the draft against your evidence list. Is anything missing? Anything wrong?
  4. Send the version you trust more, and note which that was.
  5. After three disputes, decide whether to retire the sheet.
SIDE BY SIDE LOG

Dispute  Reason   Sheet time  App time  App missed?  App found extra?  Sent
1
2
3

If the app saves time and misses nothing, retire the sheet for new disputes but keep it as an archive. If it misses something, find out why. It might be an email that sits in a personal inbox, a carrier not supported, or a policy page you never saved. Those are gaps in your process that the trial just exposed, and fixing them helps whether or not you keep the app.

What happens to your old screenshots and notes?

Keep them, but file them properly. Old disputes are your best training data for what wins and what does not, and Pay Advantage advises keeping records for 12 to 18 months. Do not delete the sheet when you switch.

Create one evidence folder per quarter, the same way for every dispute, with a sub-folder per dispute named by date and order number. Move your screenshots in and rename them so a stranger could follow them. Shopify's guidance, as I read it, favours screenshots over links, because a link can change or disappear.

FILE NAMING TEMPLATE

2026-11-02_order-1043_not-received/
  01_order-and-payment.png
  02_tracking-delivered.png
  03_customer-email-1.png
  04_policy-at-purchase.png
  05_response-as-sent.pdf
  06_outcome-note.txt

Then add one line to your notes for each old dispute: what you sent, what happened, and one thing you would do differently. After ten of these, patterns show up. Maybe most of your losses are "not received" on one carrier, or "unrecognised" on orders with a vague descriptor. That feeds prevention, which is worth more than any response.

How do you keep control with manual review?

You keep control by leaving manual review on until you trust the drafts, and by reading every response against a short checklist before you send it. A chargeback app should make you faster, not make you absent, and a good chargeback app keeps the person in charge.

In Manual mode, the app drafts and you review, confirm and send. Auto mode collects the evidence and submits on its own. Many stores start in manual, with the chargeback app drafting and the owner deciding, and move to auto only for the disputes where the evidence is routine and the amount is small. That is your decision, and you can change it at any time.

Use this review checklist for every draft.

DRAFT REVIEW (2 minutes)

[ ] Does the lead evidence match the dispute reason?
[ ] Is every fact in the draft true? (dates, addresses, amounts)
[ ] Are screenshots clear, labelled and readable?
[ ] Is anything missing that I know exists?
[ ] Is the tone calm and factual?
[ ] Will I be happy for the card company to read every line?
[ ] Is the submit date at least 3 days before the due date?

If the answer to any is no, fix it before you send. The point of manual review is that a person who knows the customer has the last word.

How do you protect the due date once you have an app?

You protect the due date by treating the app's warning as the second alarm, not the first. The first alarm is your own routine. Shopify says it submits on the due date whether or not you added evidence, so the deadline is real, and Pay Advantage says missing it almost always means a loss.

Put three reminders in your calendar when a dispute arrives: one at day 2 for the evidence check, one at day 5 for the draft, and one three days before the due date for submission. Then compare them against the due date shown in Shopify. If the window is only 7 days, compress the plan: evidence check on day 1, draft on day 3, submit on day 5.

An illustration of the calendar. A dispute is filed on Monday 2 November 2026. Shopify shows a due date of Monday 16 November 2026, which is 14 days. The plan looks like this:

Day Date Action
Monday 2 Nov Alert arrives, owner confirms, dispute added to the tracker
Wednesday 4 Nov Evidence check: order, tracking, messages found
Friday 6 Nov Draft ready in the app, owner reads it
Monday 9 Nov Gaps filled, second read
Thursday 12 Nov Response submitted, copy saved
Monday 16 Nov Due date, nothing left to do

Submitting on Thursday 12 November leaves four days of slack in case Shopify needs anything or a screenshot will not upload. Slack is cheap. A rushed Monday morning is not.

How do you track results after you switch?

Track results with a simple dispute tracker that records the reason, the evidence you led with, the outcome and the time spent. The tracker is what turns each dispute into a lesson, whether the answer lives in the app or in your sheet.

Column Why it matters
Date filed and due date Shows how close you cut it
Reason Shows where your risk sits
Amount and fee Shows the real cost
Lead evidence Shows what works
Time spent Shows what the app saves
Outcome Shows win and loss
Lesson Feeds prevention

Review it once a month for 15 minutes. Look for patterns: a carrier, a product, a country, a reason. One pattern fixed upstream, like a clearer delivery estimate or a better billing descriptor, can cut more disputes than a hundred good responses.

Remember what Shopify says about the chargeback rate: it counts disputes filed, not outcomes. A win does not remove the dispute from the rate. So a tracker that shows which orders keep producing disputes is a prevention tool as much as a record.

What is different for Australian merchants?

General information, not legal advice.

Fees and timing

On Shopify Payments in Australia, the chargeback fee is A$25, withdrawn with the disputed amount and returned if you win. You usually have 7 to 21 days to respond, and the card company's review can take up to 75 days after you submit. Cash is tied up in that time, so a quicker, better response helps cash flow as well as the win rate.

Records and consumer expectations

Pay Advantage, an Australian payments provider, advises keeping records for 12 to 18 months and tailoring the evidence to the dispute. It also suggests sending PDFs and, for higher-risk orders, using 3D Secure. The ACCC notes that time limits may apply when consumers raise problems with online purchases, so keep your shipping and policy records long enough to cover that.

Card costs

The NAB page I read says surcharging on debit, prepaid and credit cards ends from 1 October 2026, with lower interchange caps on foreign-issued cards from 1 April 2027. These change what cards cost you, not how disputes work, but they raise the value of every sale you keep.

Permissions and privacy

When you install an app that reads your orders and customer messages, you are giving it access to personal information. I did not verify the details of Australian privacy obligations for apps, so ask an adviser if you hold sensitive customer data, and read what any app asks for before you approve it.

What I could not verify: how long any given app takes to set up, which carriers or inboxes each app supports, the exact Shopify permissions an app requests, how Australian privacy law applies to dispute evidence, and a published win rate for any tool.

What are the common mistakes when moving to a chargeback app?

  • Switching in the week a due date is close, with no time to check the first drafts.
  • Skipping the evidence list and trusting the tool to know what you have.
  • Turning on Auto mode before reading ten or so drafts in reading each draft first.
  • Deleting the old the sheet and losing the history.
  • Leaving the owner's name blank, so the alert goes to nobody.
  • Letting customer emails live in a personal inbox the app cannot reach.
  • Assuming a win removes the dispute from your chargeback rate.
  • Judging the tool on one dispute instead of three.
  • Ignoring the audit trail, then being unable to say what was sent.

Frequently asked questions

Can I really move to a chargeback app in one afternoon?

The preparation fits in an afternoon: your evidence list, reason map, owner and routine, plus connecting and testing the tool. I could not verify how long any specific app takes to set up, so treat the plan as your own work and check the app's own steps. Allow a few more days to learn the drafts.

Do I need a chargeback app if I only get a few disputes?

Not always. If you see one or two disputes a month and always answer early, a template, a calendar reminder and an evidence list may be enough. A chargeback app earns its place when disputes come in clusters, when you have been late, or when each one takes more than an hour of your time.

Will a chargeback app send the wrong evidence?

It can if you let it, which is why reading each draft first exists. In Manual mode the app drafts and you review, confirm and send. Read every draft against your evidence list, check the facts and remove anything that does not fit the reason. Auto mode is for routine cases you trust.

What should I keep in my the sheet after I switch?

Keep it as an archive and as a notes sheet for lessons. Old disputes show which reasons, carriers and products cause trouble. Pay Advantage advises keeping records for 12 to 18 months, so do not delete the history. Move new disputes to the app once three side-by-side trials go well.

How do I choose a chargeback app?

Score it against a short checklist: real data only, a draft you can read before it is sent, manual review, tracking and delivery proof, an audit trail, due date warnings, and a free way to try it. Skip any chargeback app that cannot show you what it will send or that invents facts.

Does the app respond to Shopify disputes for me?

That depends on the mode. In Manual mode you review, confirm and send the response yourself. In Auto mode the app collects the evidence and submits on its own. A chargeback app does not change the Shopify rule: Shopify Payments submits whatever is on file on the due date, so either way the evidence needs to be in place early.

What if the app cannot find tracking or delivery proof?

Then the draft should say so, and you should look elsewhere: the carrier's page, your shipping software or the customer's emails. If proof truly does not exist, you may decide to accept the dispute rather than send a weak response. A gap found early is a better outcome than one found on the due date.

Do I still need my own evidence folder?

Yes. An evidence folder is your backup and your long-term record. Save the response as sent, the key screenshots and a note on the outcome, named by date and order number. Shopify's guidance favours screenshots over links, because links can change. Keep the evidence folder for 12 to 18 months, whichever chargeback app you use.

Does winning a dispute lower my chargeback rate?

No. Shopify says the chargeback rate is based on the disputes filed, not on the outcomes, so a won dispute still counts. You get the amount and the A$25 fee back, but the filing remains on your rate. Prevention is the only way to bring the rate down.

How do I know the move to a chargeback app worked?

Compare three things before and after you add the chargeback app: the time each dispute takes, the number of responses sent at least three days early, and your win rate over several months. Keep a dispute tracker so you are comparing facts, not feelings, and make the dispute tracker part of the monthly review. Give it at least three disputes before you decide.

Start free trial with ChargeFix

ChargeFix is a chargeback app for Shopify that gathers the real order, payment-check and delivery records for a dispute and drafts the response, using only real data and never inventing facts. Review each filing yourself in Manual mode or let Auto mode submit for you, and you can try it on your own disputes before you commit. Start free trial

Sources

Be ready before the next chargeback lands.

ChargeFix is launching soon. Join the VIP waiting list for early access.

Keep reading

More on chargebacks

ChargeFix guide cover with a shield icon: Clear billing descriptors01Preventing disputes

Clear billing descriptors: how Australian stores stop "I don't recognise this charge"

Clear billing descriptors stop most unrecognised charge disputes. Learn what to put on the statement, how to test it and what to check for Australian stores.

Read the guide arrow_forward
ChargeFix guide cover with a document icon: Order confirmation and shipping emails that prevent disputes02Preventing disputes

Order confirmation and shipping emails that prevent disputes: templates for Australian stores

Shipping emails and order confirmations that prevent disputes: what to say, when to send it and copy-ready templates for Australian Shopify stores today.

Read the guide arrow_forward
ChargeFix guide cover with a coin icon: Chargeback cash flow: how disputes tie up your working capital03Chargeback costs

Chargeback cash flow: how disputes tie up your working capital (A$ example)

Chargeback cash flow explained for Australian Shopify stores: when money leaves, how long it stays out, how reserves bite, with A$ sums and a forecast template.

Read the guide arrow_forward
ChargeFix guide cover with a document icon: How to respond to a general dispute on Shopify04Dispute reasons

How to respond to a general dispute on Shopify: find the real claim and send the right evidence

How to respond to a general dispute on Shopify: find the real claim, send the evidence Shopify lists and weigh the A$ cost. Includes templates and a day plan.

Read the guide arrow_forward
ChargeFix guide cover with a scales icon: AFCA complaints and chargebacks: what sellers should expect05How chargebacks work

AFCA complaints and chargebacks: what sellers should expect

AFCA complaints and chargebacks explained for Australian sellers: what AFCA checks, what it cannot do, the timeline, re-disputes and how to keep records.

Read the guide arrow_forward
ChargeFix guide cover with a payment card icon: Amex chargebacks on Shopify06Card networks

Amex chargebacks on Shopify: the 20 day clock, the reason codes and the proof Australian sellers need

Amex chargebacks run on their own clock: 20 days to challenge, up to 120 days to raise. Learn the codes, accepted proof and routine Australian sellers need.

Read the guide arrow_forward