Understanding your payment reports (new)

  • Updated

This feature is currently only available to users who are part of the beta program.

To join the beta, please contact support.

In this article, you will learn how to use the Payment reports built into Workiz — what each report shows, when to use it, and how to make it work for your business.

What are payment reports?

Every dollar that comes into your business passes through a payment. Payment reports give you a clear picture of your cash flow — how much you've collected, how it was paid, which technicians are bringing in the most money, and whether any payments have been refunded.

Instead of trying to piece together your collections from individual job records, you can pull up a report that answers a specific question in seconds.

For example:

  • “How much did we collect this month?”
  • “Which payment methods are my customers using most?”
  • “Which technician is collecting the most in tips?”
  • “Are there any refunds I need to review?”

Workiz has several ready-to-use payment reports that answer these kinds of questions right out of the box. Each one is pre-configured so you can get to the answer quickly, without needing to set anything up yourself.

How payment reports work

Every payment report in Workiz is built on the same foundation, which means they all work the same way. Each report shows you a list of payments, and you can shape what that list looks like using three tools:

Filters
Filters let you narrow down which payments appear in the report. For example, you can filter to show only payments from this month, or only refunded transactions. If you do not set a filter, the report shows all payments.

Grouping
Grouping rolls your payments up into categories so you can see totals at a glance. For example, grouping by payment type shows you one row per method — credit card, cash, check — with totals for each, instead of listing every payment individually.

Visible columns
Each report comes with a default set of columns — the pieces of information shown for each payment. You can add or remove columns depending on what you want to see.

Each of the reports below comes pre-configured with sensible defaults for filters, grouping, and columns. You can use them as-is or adjust them on the fly.

Your default payment reports

Workiz includes various pre-built payment reports. Here is what each one does and when you might use it.

All payments

This is the default payment report — your complete list of every payment received, with no filters applied. It is the best place to start when you want to look up a specific payment or review your full payment history.

SettingDefault
Default filtersNone — shows all payments
Default columns
  • Payment date
  • Amount
  • Tip amount
  • Fee amount
  • Net amount
  • Payment type
  • Payment status
  • Confirmation code
  • Description
  • Document (e.g., invoice ID)
  • Job ID
  • Client
Default groupingNone — one row per payment
Good for
  • Looking up a specific payment
  • Reviewing your full payment history
  • Exporting all payment data

This month

All payments processed in the current calendar month. Use this as your go-to report for a quick snapshot of what's come in so far this month.

SettingDefault
Default filtersPayment date: This month
Default columns
  • Payment date
  • Amount
  • Tip amount
  • Processing fee amount
  • Net Amount
  • Payment type
  • Payment status
  • Description
  • Document
  • Job ID
  • Client
  • Technician
Default groupingNone — one row per payment
Good for
  • Reviewing everything collected so far this month
  • Reconciling daily or weekly cash flow

Last month

All payments processed in the previous calendar month. Use this to close out last month's books or compare performance to the current month.

SettingDefault
Default filtersPayment date: Last month
Default columns
  • Payment date
  • Amount
  • Tip amount
  • Processing fee amount
  • Net Amount
  • Payment type
  • Payment status
  • Description
  • Document
  • Job ID
  • Client
  • Technician
Default groupingNone — one row per payment
Good for
  • Closing out the previous month
  • Comparing last month's collections to this month

Last 30 days

All payments processed in the last 30 days, regardless of where the calendar month falls. Use this when you want a rolling window rather than a fixed calendar month.

SettingDefault
Default filtersPayment date: Last 30 days
Default columns
  • Payment date
  • Amount
  • Tip amount
  • Processing fee amount
  • Net Amount
  • Payment type
  • Payment status
  • Description
  • Document
  • Job ID
  • Client
  • Technician
Default groupingNone — one row per payment
Good for
  • Getting a rolling 30-day picture of collections
  • Spotting recent payment trends that don't align with calendar months

Refunds

This report shows all refunded payments from the last 30 days. Refund amounts display as negative values so you can see their impact on your total collections at a glance.

SettingDefault
Default filters
  • Payment status: Refunded
  • Payment date: Last 30 days
Default columns
  • Payment date
  • Amount
  • Payment type
  • Payment status
  • Description
  • Client
  • Technician
  • Document
  • Job ID
Default groupingNone — one row per refund
Good for
  • Reviewing recent refund activity
  • Identifying which jobs or clients refunds are tied to

By month

This report shows your monthly payment totals over the past 12 months, grouped by month. Use it to track whether collections are growing, shrinking, or staying steady over time.

SettingDefault
Default filtersPayment Date: Last 12 Months
Default columns
  • Payment date (month)
  • Amount
  • Net amount
  • Processing fee
  • Tip
Default groupingPayment date (month)
Good for
  • Tracking revenue trends month over month
  • Spotting seasonal patterns in cash flow
  • Comparing gross collected vs. net after fees by month

By week

This report shows your weekly payment totals over the past 6 months, grouped by week. Use it for a more granular look at cash flow patterns within and across months.

SettingDefault
Default filtersPayment date: Last 6 months
Default columns
  • Payment date (week)
  • Payments # (count)
  • Amount
  • Net amount
  • Processing fee
  • Tip
Default groupingPayment Date — grouped by week
Good for
  • Spotting slow weeks or unusually strong ones
  • Tracking week-over-week collection trends

By zip code

This report shows payment totals broken down by the zip code of the job location over the past 12 months. Use it to see which service areas are generating the most revenue.

SettingDefault
Default filtersPayment date: Last 12 months
Default columns
  • Zip code
  • Payments # (count)
  • Amount
  • Net amount
  • Processing fee
  • Tip
Default groupingZip code
Good for
  • Identifying your highest-revenue zip codes
  • Planning where to focus marketing or hiring

Tips by technician

This report shows total tips collected per technician this month. Use it to see who's earning the most in tips and how tips compare to overall collections for each team member.

SettingDefault
Default filtersPayment Date: This Month
Default columns
  • Technician
  • Payments # (count)
  • Total tips
  • Average tip
  • Amount
  • Net amount 
Default groupingTechnician
Good for
  • Tracking tip totals per technician for the month
  • Recognizing top-performing team members
  • Reviewing average tip amounts alongside total collections

This month by payment type

This report breaks down this month's payments by how customers paid — credit card, cash, check, ACH, and so on. Use it to understand your payment mix and see how processing fees vary by method.

SettingDefault
Default filtersPayment date: This month
Default columns
  • Payment type
  • Payments # (count)
  • Amount paid
  • Net amount
  • Processing fee
  • Tip
Default groupingPayment type
Good for
  • Understanding how customers are paying
  • Comparing gross collected vs. net after fees by payment method

By card type

This report breaks down payment volume by card brand — Visa, Mastercard, Amex, and others — for the current month. Since processing fees vary by card brand, this report helps you understand how your card mix is affecting your net revenue.

SettingDefault
Default filtersPayment date: This month
Default columns
  • Card brand
  • Payments # (count)
  • Amount 
  • Net amount
  • Processing fee
Default groupingCard Brand
Good for
  • Seeing which card brands your customers use most
  • Understanding how card type affects your processing fees
  • Comparing gross vs. net revenue by card brand

Saving your own custom reports

Every report above is a great starting point, but your business is unique — and sometimes you need a report that is set up exactly the way you want it, every time.

Rather than adjusting filters or groupings every time you open a report, you can save your own version of any payment report as a custom report. Give it a name that makes sense to you and Workiz will save all your settings so the report opens exactly the way you left it.

When you save a custom report, you can lock in:

  • The date range or filters you always use
  • Your preferred grouping (by technician, by payment type, by week, etc.)
  • The columns you want to see

To save changes to a pre-built report or create a new one from scratch, you will need access to the new Custom Reports feature. To learn more, please see this help article.

Your custom reports are always available in the Reports section alongside the built-in ones. The original pre-built reports stay untouched, so you can always go back to the default if you need to.

Was this article helpful?