AI Merchant Fee Optimiser — Automatically Calculate Your True Effective Payment Processing Rate and Find Out If You Are Overpaying Every Mon
Built by RegistryOrbit ·
About this build
A Claude and n8n powered workflow that takes your monthly transaction data and automatically calculates your true effective merchant fee rate across every payment method — tap, online, manual entry and recurring — then benchmarks it against current Australian market rates from Stripe, Square, Tyro, PayPal and the Big F
What was built
Built this after speaking with three small business owners in one week who were all on different payment providers, all assumed they were on a competitive rate and none of them could tell me their actual effective rate when I asked. One of them was paying an effective rate of 2.3 percent on a provider advertising 1.7 percent because of terminal rental, monthly minimums and a higher rate on manually entered transactions. The workflow runs monthly and takes about 4 minutes of input. Step 1 — Transaction data intake The owner inputs 6 things. Monthly revenue total. Transaction count breakdown by type — how many tap payments, online payments, manually entered and recurring. Their current provider and the rate they think they are on. Any fixed monthly fees — terminal rental, gateway fees, monthly minimums. Their business type — retail, hospitality, e-commerce or services. Their average transaction value. Step 2 — True effective rate calculation via Claude Claude calculates the actual effective rate by combining the percentage fees with the fixed costs spread across the transaction volume. This is the number that matters — not the headline rate but what the business actually paid per dollar processed last month. Most business owners have never seen this number. Step 3 — Live rate verification via Perplexity Perplexity pulls the current rates for every major Australian payment provider — Stripe, Square, Tyro, PayPal, Commonwealth Bank, ANZ, NAB and Westpac — for this specific business type and transaction profile. Rates change regularly and relying on static data gives outdated comparisons. The verification step ensures the benchmarking reflects what the business could actually get today. Step 4 — Switching analysis via Claude Claude runs the same effective rate calculation for each alternative provider using the business’s actual transaction profile. This is important because headline rates are misleading — a provider with a lower percentage rate but a monthly minimum can cost more for a business doing lower volumes. The output shows the true annual cost with each provider for this specific business. Step 5 — Recommendation report The report answers three questions directly. Are you overpaying and by how much per year in dollar terms. Which provider offers the best effective rate for your specific transaction profile. Is the switching worth the effort given the saving and the migration complexity. The report flags when the saving is below AUD $500 per year and explicitly says switching is probably not worth the friction. Honesty about when not to act is what makes the recommendation trustworthy. Step 6 — Monthly tracking in Airtable Each month’s effective rate gets logged to Airtable. Over time this creates a trend showing whether the effective rate is creeping up — which happens when transaction mix shifts, when providers quietly adjust fees or when fixed costs become a larger proportion of lower revenue months. Step 7 — Gmail delivery The complete report lands in the owner’s inbox on the first of each month alongside their other monthly financials. Why this matters for Australia right now: Merchant fees are the fastest rising search term in Australia in October 2026 at plus 50 percent month on month. The ATO credit card payment ban is changing how businesses and customers think about payment methods. Mastercard Merchant Services is also a breakout search term this month. Small business owners are actively trying to understand this space and most of them are finding it confusing. The difference between a 1.4 percent and 1.9 percent effective rate on AUD $50,000 monthly revenue is AUD $3,000 per year. Most businesses spend more time comparing coffee suppliers. Results after 8 weeks: Tested with 6 small businesses across retail, hospitality and e-commerce in Australia. All 6 discovered their actual effective rate was higher than their advertised rate. Average gap was 0.31 percentage points. Two businesses switched providers and saved AUD $2,800 and AUD $4,100 per year respectively. Three businesses decided the saving was not worth the switching effort — which is also a useful outcome. The most common reaction was that nobody had ever shown them this number before in plain language. Will share the full n8n workflow, Claude prompt structure and Airtable tracking template in comments for anyone who wants to deploy this for their own business or clients.
