Skip to content Skip to main navigation Skip to footer

How to Export Your Memberships List (CSV) in Collar

You can download your whole membership base as a CSV spreadsheet from the Memberships page. The export gives one row per membership with:

  • the client and pets
  • the plan and variations
  • status and amounts
  • start and next billing dates
  • any pause or cancellation dates

Use it to track paused members, check plan capacity or reconcile billing without copying figures by hand.

Prerequisites

  • Access to Memberships in the main sidebar.
  • At least one client membership on your branch.
  • A spreadsheet app such as Excel, Google Sheets or Numbers to open the CSV file.

Overview

The export always covers the branch you are signed in to. You choose what to include in the export window itself: by membership status, by membership plan, or both. Leaving both filters empty downloads every membership on the branch, including cancelled ones.

How to Export Your Memberships

  1. Open Memberships. In the left sidebar, click Memberships. Stay on the All or Cancelled tab.
  2. Click Export. At the bottom of the memberships list, click Export. The Export Memberships window opens.
  3. Choose statuses (optional). Under Status, select one or more of Active, Past due, Paused, Inactive and Canceled. Leave it on All statuses to include everything.
  4. Choose plans (optional). Under Memberships, select the membership plans you want. Leave it on All memberships to include every plan.
  5. Download. Click Download. Collar saves a CSV file named after your branch and today’s date, for example Happy Paws Memberships 2026-10-05.csv.

What the Export Contains

Rows are sorted by membership number. Dates use the YYYY-MM-DD format, and amounts are shown to two decimal places without a currency symbol.

ColumnWhat it shows
Membership NumberThe membership’s reference number, for example M00042.
ClientThe owner’s full name.
PetsEvery pet on the membership, separated by commas.
ProductThe membership plan name.
VariationsThe tiers or add-ons chosen, for example Bus Service: Pick-up Only, separated by semicolons.
StatusActive, Past due, Paused, Inactive or Cancelled.
Billing FrequencyHow often the membership bills: Monthly, Quarterly, Bi-annual or Annual.
AmountThe recurring charge per billing cycle for the whole membership (all pets included), after any discount voucher on the membership.
Monthly AmountThe same amount expressed per month (for example a yearly charge divided by 12), useful for comparing plans on different intervals.
CurrencyYour branch currency, for example GBP.
Start DateThe membership’s billing start date.
Next Billing DateWhen the next renewal is due. Blank if the membership is paused, cancelled, or scheduled to pause or cancel.
Pause DateWhen the membership was paused. For a pause scheduled at the end of the billing period, the date it will pause.
Paused UntilThe resume date for a pause until a set date. Blank for an indefinite pause.
Cancellation DateWhen the membership was cancelled. For a cancellation at the end of the billing period, the date it will end.

Important Notes, Tips & Warnings

  • Note: The export uses only the Status and Memberships filters in the export window. Searches, tabs or filters on the Memberships page itself are not applied.
  • Note: The filter spells the status Canceled, but the file’s Status column shows Cancelled. They mean the same thing.
  • Note: Membership numbers are unique across all of Collar, so gaps in your branch’s numbering are normal.
  • Note: The date in the file name is in UTC, so near midnight it can differ from your local date.
  • Note: If your branch uses a language other than English, the column headings and values are translated.
  • Tip: To see how many paused members could return soon, export with Status set to Paused and sort the spreadsheet by Paused Until.
  • Tip: Add up the Monthly Amount column for Active and Past due memberships to get a quick monthly recurring revenue figure. For trends over time, use Memberships > Analytics.
  • Note: The export is a snapshot taken when you click Download. Export again whenever you need up-to-date figures.
  • Warning: The file contains client names and billing details. Store and share it in line with your data protection obligations.

Troubleshooting

Issue: You cannot see the Export button.
Resolution: Open Memberships from the main sidebar, not Operations > Memberships, which is your plan catalogue. Then stay on the All or Cancelled tab (not Analytics) and scroll to the bottom of the list.

Issue: The file has fewer rows than expected.
Resolution: Re-open Export and check the Status and Memberships filters. Clear both to export every membership on the branch.

Issue: The file only contains the header row.
Resolution: No memberships match the filters you chose. Clear the filters and download again.

Issue: Next Billing Date is empty for some memberships.
Resolution: This is expected for memberships that are paused or cancelled, or scheduled to pause or cancel at the end of the billing period. Check the Pause Date, Paused Until and Cancellation Date columns.

Issue: Amounts look different from the price on the plan.
Resolution: Amount is the price on that client’s membership, covering all of its pets and variations, after any voucher discount. It can differ from the catalogue price if the membership was edited, discounted or covers several pets.

Related Articles

Was This Article Helpful?