How to See Total Revenue From Your Jotform Submissions

If you take orders through a Jotform form with a payment field — Stripe, PayPal, Square, or a manual “order total” number — every sale lands as a submission. Jotform is great at capturing those orders. What it doesn’t do is tell you how much money they add up to. Here are the three real ways to get that number, from most manual to most automatic.

Method 1 — Sum the payment column in Jotform Tables

You don’t always need to export. Jotform Tables can total a single column in place:

1. Open your form and go to the Tables view.
2. Find the column that holds the paid amount (your payment element, or an “Order Total” number field).
3. Click the summary area at the bottom of that column and choose Sum. Jotform shows a running total of everything currently visible.
4. Use a filter first (e.g. status = Paid, or a date range) so test and incomplete orders don’t inflate the number.

This is the fastest way to a single total. Its limit: it’s one sum at a time. It won’t give you average order value, revenue by product, or how this month compares to last.

Method 2 — Export to Excel or Google Sheets and SUM

For anything more than a single total, export and use a spreadsheet:

1. In Jotform, open Submissions (or Tables) and choose Download / Export → Excel (or CSV).
2. Open the file. Locate your payment/total column.
3. Clean it first: strip currency symbols and commas so the cells are plain numbers, and delete rows for refunded, cancelled, or test/sandbox payments.
4. In an empty cell, enter =SUM(F2:F999) (swap Ffor your payment column). That’s your total revenue.
5. For average order value, add =AVERAGE(...); for revenue by product or month, insert a PivotTable and drag the product or date field to rows and the payment total to values.

This works and it’s free. The catch is that it’s a monthly chore — export, clean, re-build the pivot — and it’s easy to get a wrong total from stray symbols or leftover test orders.

Method 3 — Skip the export entirely

If you find yourself doing Method 2 every month, the point of a tool like TutuMarginis to remove that chore. It reads your Jotform submissions (read-only), detects the payment field, and shows total revenue, average order value, top products, and month-over-month trend the moment your form connects — no CSV, no pivot table. You can also just ask it in plain English (“total revenue this month”) and get the chart. Your order rows stay in your browser.

Getting an accurate number — the gotchas

• Filter to paid orders. Incomplete and abandoned payments still create submissions. Count only completed ones.
• Remove test/sandbox payments. Orders you made while setting up the form will otherwise pad your total.
• Subtract refunds.A refunded order is still a row in your export; it isn’t revenue.
• Mind multi-item orders.If one submission contains several products, the row total is the order total — splitting revenue by product needs the line items, not just the order sum.
• Watch the timezone. Monthly totals shift if the submission date is in a different timezone than you assume.

Bottom line:for a one-off number, Jotform Tables’ column sum is enough. For recurring revenue, AOV, product, and trend reporting without the monthly spreadsheet ritual, a purpose-built reader is faster and harder to get wrong. Related: getting AOV, top products, and repeat customers and turning submissions into a chart without Excel.