TFW Members: Online Documentation - Payment History: Reports

Whatever credit card processor you use, if you send your credit card drafts to them through TFW you have a detailed Payment History on your desktop. We keep card type and last four digits for every transaction, including purchases through the built-in credit card terminal.

With card type, you can separate Visa-MC from AmEx from Discover for the month, since those make separate deposits to your bank account and charge separate rates.

With last four digits, you can pull together transactions done for multiple members on the same card. For example, a member who has a small business of her own, and pays you for a few of her employees, and a daughter or two, and herself, and Curvaceous and supplements for all. You can tell that member exactly what her card has been used for within any given stretch of time, before she comes to you waving her own credit card statement.

TFW sends to any card processor you choose, and keeps this same credit card history for any of them.

Same for check drafting: Vanco, Deposit Express, AllianceACH...

TFW Members can write reports that neither you nor TFW Members have imagined yet.

You'll find "grids" throughout: your information in rows and columns like a spreadsheet.

You can print these or export them to a spreadsheet.

You can sort the list, shorten it to just your selections, or group by any of the headings.

Five examples:

Report Example 1: Member payment history.
Report Example 2: Discover® cards this week.
Report Example 3: Credit card payments this month, grouped and totalled by card type.
Report Example 4: Credit card payments in this batch, grouped and totalled by card type.
Report Example 5: Merchandise last month.

Report Example 1: A Member Payment History

When you open Payment History (History tab), you see payments from your members in date order, most recent first. Suppose you want to report the Payment History for just Karen Agamorthendorp.

Click heading for "Name". Now the list has each member's payments together.

In the filter row, enter the first few letters of the name you want, such as "Aga" for Karen Agamorthendorp, in the "Name" column. Now you just have Karen's Payment History.

The filter row has a picture of a funnel. Above Karen's name it says:

Starts with
Aga

Click the "Due Date" heading to put them in order by due date. In case some payments took a few tries before they went through, sort again by "Done Date": press the shift key and click the heading for "Done Date". The shift key says you don't want the first sort order disrupted, you just want an additional sort order.

Now all Karen's payments are listed by the date they were due and the date they were done.

Need this on paper? In the Shortcut Box (the dropdown box at the bottom of the grid) select "Print" and click the Go button.

Or, from Member Central, select Karen by first name or last, then in the Common Tasks box click Member Payment History.

Report Example 2: Discover® cards this week.

When you open Payment History (History tab), you see payments to and from your members in date order, most recent first. Suppose you want to report the payments by Discover card this week.

If you've sorted, filtered, or grouped the list some other way, just close it and open it again.

In the filter row under "Date Done" enter the start of the week, such as "03/06/2006". Change "= Equals" to "> Greater Than". Now you have payments done this week.

The filter row has a picture of a funnel. For "Done Date" it says:

   > Greater than
   03/06/2006

In the filter row under "Card" select "Discover®" from the dropdown list:

   = Equals
   Discover®

Now you have just payments by Discover® done this week.

Need this on paper? In the Shortcut Box (the dropdown box at the bottom of the grid) select "Print" and click the Go button.

Report Example 3: Credit card payments this month, grouped and totalled by card type.

When you open Payment History (History tab), you see payments to and from your members in date order, most recent first. Suppose you want to report the payments by Discover card so far this month.

If you've sorted, filtered, or grouped the list some other way, just close it and open it again.

In the filter row under "Date Done" enter the first of the month, such as "01/01/2006" for January. Change "= Equals" to "> Greater Than". Now you have just payments done this month.

The filter row has a picture of a funnel. For "Done Date" it says:

   > Greater than
   01/01/2006

In the filter row under "By" select "Credit Card" from the dropdown list. Now you have just payments done by credit card.

   = Equals
   Credit Card

Now group these by card type. Grouping gives your list an outline look.

With your mouse drag the heading for "Card" upwards to the gray Group bar (says "Drag a column header here to group by that column.")

Now your credit card payments for the month are grouped by card type. Discover® is just one of them. If for example you had twelve Discover® payments this month, one line in your list says:

   + Card: Discover® (12 items) [ 468.00 ]

The twelve Discover transactions total $468.00. Click the + button to open the list of twelve. Now you see each of the twelve Discover transactions today.

Need this on paper? In the Shortcut Box (the dropdown box at the bottom of the grid) select "Print" and click the Go button.

Report Example 4: Credit card payments in this batch, grouped and totalled by card type.

When you open Payment History (History tab), you see payments to and from your members in date order, most recent first. Suppose you want the payments in a single batch, and want to sum them by card type, because the proceeds arrive at your bank in separate deposits by card type.

If you've sorted, filtered, or grouped the list some other way, just close it and open it again.

In the filter row under "Date Done" enter the date of the batch you want, such as "01/11/2006" for January 11. Leave "= Equals" above it. Now you have just payments done that day.

The filter row has a picture of a funnel. For "Done Date" it now says:

   = Equals
   01/11/2006

In the filter row under "By" select "Credit Card" from the dropdown list. Now you have just payments done by credit card that day.

   = Equals
   Credit Card

Now group these by card type. Grouping gives your list an outline look.

With your mouse drag the heading for "Card" upwards to the gray Group bar (says "Drag a column header here to group by that column.")

Now your credit card payments for the batch are grouped by card type. Discover® is one of them. If for example you had twelve Discover® payments in this batch, one line in your list says:

   + Card: Discover® (12 items) [ 468.00 ]

The twelve Discover transactions total $468.00. Click the + button to open the list of twelve. Now you see each of the twelve Discover transactions today.

Need this on paper? In the Shortcut Box (the dropdown box at the bottom of the grid) select "Print" and click the Go button.

Report Example 5: Merchandise last week.

Shortcut: View By Date Range (Go)

Select first and last of last week.

Under heading "For" select:

   For
   = Equals
   Merchandise

Under heading "Status" select:

   Status
   = Equals
   Collected

Or, instead of Merchandise, select Membership, Instruction, Rental, or Other.

To see just New Membership money:

Under heading "For" select:

   For
   = Equals
   Membership

Under heading "New" select:

   New
   = Equals
   True

Better yet, see Appointment Book: Follow-Up.