Family Ledger

The Family Ledger report lists all invoice information associated with a specific family. This includes, invoice numbers, line item descriptions, and how much was charged on each invoice for that family. This report also contains your gym's name, address, and logo allowing you to send this to clients who request this report for tax purposes.

You can customize your report using the sections listed below.

How to Generate the Report

Report Configurations	Options	Description
Report Period	All Dates Custom (user defines) This Week This Month This Quarter This Year Yesterday Last Week Last Month Last Quarter Last Year	Choose which inclusive dates are needed for the family ledger report. Selecting All Dates will generate the report for all dates of the session and/or reason category selected. Selecting This Year, for instance, will generate the report for all transactions within the family since the beginning of the current year.
Select Family		Choose which family you want to generate the ledger report for by typing their last name into the textbox.
Sort By	Date Invoice Number	Choose if you want the report to be sorted by the date of each transaction or by the invoice number.

Report Configurations

Options

Description

Report Period

All Dates

Custom (user defines)

This Week

This Month

This Quarter

This Year

Yesterday

Last Week

Last Month

Last Quarter

Last Year

Choose which inclusive dates are needed for the family ledger report. Selecting All Dates will generate the report for all dates of the session and/or reason category selected. Selecting This Year, for instance, will generate the report for all transactions within the family since the beginning of the current year.

Select Family

Choose which family you want to generate the ledger report for by typing their last name into the textbox.

Sort By

Date

Invoice Number

Choose if you want the report to be sorted by the date of each transaction or by the invoice number.

If any of the Report Period, Family, or the Sort By options are changed after the report has been generated, the report must be regenerated by selecting the Regenerate Report button. The data will not be updated until that action is taken.

How to Read the Report

Once the report is generated, the exact date and time the report is generated is shown under the report title. There is a button called More in the upper right giving options to Print the report or Download CSV for capturing the data.

The report provides the detailed data shown below.

Report Data	Detailed Data
Date	This column contains the dates of each transaction. The date listed is the date the invoice was sent to the family, or the date the family made a payment depending on what type of transaction it is.
Type	This section details the type of transaction each entry is. A charge is a fee charged to the family. A payment is going to be any time the family has made a payment on an invoice.
Description	The description section is going to either be the line item created for the fee or other fee descriptions such as Global Fees or Late Fees. For payments, this section will list what type of payment was applied: credit, card, cash, or check.
Invoice Number	This section provides the invoice number for each transaction that works as a direct link to the invoice itself.
Amount	This column details the exact amount for each charge in this report.
Tax	For any charges that had tax applied to them, the amount charged for tax will be listed in this column.
Total Amount	The total amount column adds the amount charged with the tax that was applied, so you can view the total amount of that transaction.
Payment	A number will only be listed in this column if the transaction is listed as a payment.
Balance	The balance column provides a running total of how much the family owes after each transaction, adding charges and subtracting payments made along the way.

The total amount paid and refunded to the family will be listed at the bottom of the report.