Billing Reports

Billing Reports

Sofia Zúñiga Vega avatar
Written by Sofia Zúñiga Vega
Updated over a week ago

Billing Reports Training Video

There are several Billing Reports you can access in Fit Pro Tracker to help you obtain various information. The reports include:

  • Transaction Report

  • Cancelled Memberships

  • New Memberships

  • Paused / Frozen Memberships

  • Projected EFT

  • Active Memberships

  • Trials

  • Past Due

  • Inactive / Expired or Near to Expire Payment Methods

  • Merchant's Deposit Report

  • Merchant's Statements Report

  • Gross Revenue

  • Modified Invoice Report

You can access the reports by clicking Membership Billing > Reports.

Reports Pro-tip:

  • You can Download any Billing Report into an Excel spreadsheet

  • You can click on the Contact name and the system will direct you to the contact's profile

  • You may sort columns in all reports (ascending and descending) by clicking to the righthand side of the column header.


  • Transactions Report

The transaction report was designed to help you see the health of your business. You can view all transactions processed through Fit Pro Tracker including refunds, credits, and more. You’ll be able to filter the report by date, transaction type, membership name, and membership type. Under the filters there is a Transaction Report Summary which changes based on the date range filter. This helps you quickly see totals of the various transaction types.

Below the summary is an itemized list of the transactions including the Transaction number, Customer, the date the transaction was due, Amount, Transaction Type, Customer Balance, Type (Status of the transaction), and Notes.

You can also click on the transaction number to get the details or click on the contact’s name to be directed to the contact profile.

This is an invoice driven report and is great for reconciling your Merchant Deposit Statement. Keep in mind that the transactions occur 3 business days prior to the deposit into your bank account. When using this report to reconcile you will want to select dates according to these rules. For example, if you were looking at the report below the filtered dates would of Oct 1, 2021 - Oct 31, 2021 would reflect the deposits that occurred in your bank account on Oct 6, 2021 - Nov 3, 2021.

For additional tips and tricks on the deposit and transaction reconciliation process please see this article.

  • Canceled Memberships

The Canceled Memberships Report gives you insight and data on member cancelations. You can filter your canceled memberships by date range, the reason for the cancellation, and/or the membership type.

The Canceled Memberships report shows the Customer Name (you may click on the name to go directly to the client profile), Membership Name, Membership Type, the date the customer became a member, Cancelation Date, the reason for Cancelation, Total Lifetime Value (how much the member paid while they were active), any notes entered and the User that canceled the membership.

  • New Memberships

This report helps you account for new memberships including those that are scheduled but have not yet made their first installment payment. You can filter the by Date Range or Membership Type. The Member Since date will show when they became a member.

  • Paused / Frozen Memberships

This report was designed for you to see and filter through all of your Frozen and Paused memberships. You can filter by the date range, the reason, all freezes or all pauses, and the membership type. The date will filter for the start of Freeze/Pause.

Data in the report includes the Customer Name, Membership Name that is paused/frozen, Membership Type, End Date (for Freezes), Reason, any Notes added when pausing/freezing, and any Follow-Up Tasks.

  • Projected EFT

The Projected EFT helps you to forecast your recurring revenue for the next 30 days. The report will show data from the previous Sunday to 30 days in the future. Each Sunday the report will update and will always only include the next 30 days. While the dates cannot be filtered you may export the report to and excel document.

On the top of the report is a summary of the projected recurring revenue.

Below is detailed information regarding all the transactions expected to come in within that 30 day time period.

The itemized view includes Customer Name, Customer Email, Next Billing Date, Membership Name, Amount, Payment Method (information is masked except the last 4 digits of the account number), Payment Method Status. The Customer and Membership Name column have filtering capabilities by clicking the filter icon.

  • Active Memberships

    This report will show all the memberships currently in an active status in Fit Pro Tracker. You can filter it by the Membership type and it will tell you the start and end date. Plus you will see the last payment date as well as the customer's balance and the membership last invoice.

    An important note: New members who have not yet paid the first installment will not show on this report not will any membership that is not reflected on the Projected EFT report. If Paid in Full memberships are set up as single payments with EFT turned off they will not show up on your Active Memberships Report.

  • Trials

This report will show all the active trials you have in Fit Pro Tracker. You can filter it by the Membership type and it will tell you the start and end date. Plus you will see the last payment date as well as the customer's balance and the membership last invoice.

  • Past Due Report

This report shows the total past due amount. There are 2 filters: By Customer and by Invoices.

Customers:

  • You are able to see the Invoice number, Customer, Email Address, and Balance.

  • You can click the Add Payment button next to the client information to easily process a payment to resolve the Past Due Amount without being redirected off of this page.

  • You can click on the Customer name to be redirected to the contact profile

Invoices:

  • You are able to see the Invoice number, Customer, Amount, Balance, Type, Membership, Membership type, due date, and Note.

  • You can click on the Invoice number to see the Transaction Details.

  • Inactive/Expired or Near to Expire Payment Methods

This report makes it easy for you to see any inactive/expired or near to expired cards in your Fit Pro Tracker billing system. It will show the Customer, Card Holder name Card Number, Expiration Date, Expiration Status, the status of the card, if the card is Primary, Last Payment Date, and the Last Transaction Details.

Under the Last Transaction Details column, you are able to click the view button for the client to see additional details.

  • Merchant's Deposits Reports

The Merchant's Deposits Report is a quick easy way to access the deposit statement information that Zift emails to you daily. You can easily see what deposits have gone to or are going to your bank account without having to search through your email. The information contained in this report comes from Zift.

This report can be filtered by the date. You will notice a summary for the selected date range under the date filter.

The report shows daily deposit information that can be expanded to show each transaction contained in the deposit. Expand the data by clicking the arrow next to the deposit date.

An important note: The activity date is the date that the invoice was processed in FPT. This is the date you would search your transaction report for in order to reconcile the transactions deposited (Merchant Statement) with the invoices processed (Transaction or Gross Revenue Report).

  • Merchant's Statement Reports

    Similar to the Merchant Deposit Report the Merchant Statement Report pulls all of the information from Zift and contains information on deposits. You can filter this report by dates. Clicking on the Statement ID Link within the report will take you to the Merchant's Deposits Report to view the Statement Details.

  • Gross Revenue Report

    The Gross Revenue Report can be filtered by date range. This report receives it's information based off of invoices processed. When comparing this report to your Merchant Statements you will need to adjust the dates by 3 business days prior to the deposits.

    Under the date filter you will notice a summary of your Gross Revenue for the Previous Period and for this Period. You will also notice information for Gross Revenue according to organization. This information is for franchisors and is the Gross Revenue less any retail transactions.

    This report is great for seeing your revenue. It contains information on the date of the transaction, the total amount of the transaction, how much you collected in taxes, and the transaction type. This report can also be useful in calculating taxes. It is easy to export to Excel and total up the Tax Amount.

  • Modified Invoice Report

    The Modified Invoice Report gives insight into any single invoices that were modified to an amount different than the regular subscription amount. This is useful to look at to verify that the invoice was modified correctly.

    This report offers various filters including date range, Customer, Membership, Staff Member, and Action Status.

    Once the filters are selected the report will show the Customer Information, Membership Name, Installment Date (the date the invoice is scheduled to process), Action (what the installment amount was changed to), Staff member who made the modification, Notes made when modifying the installment amount, and the Status (Complete, Failed, Upcoming, In Progress).

Did this answer your question?