GS Logo
The Green Sheet, Inc

Please Log in

A Thing
View Archives

View PDF of this issue

Care to Share?

Table of Contents

Lead Story

XTP: Putting sexy into payments


Industry Update

PCI - the talk of NRF 2008

It's a woman's world, too

Calling all Canadian ISOs, MLSs

Uh oh, where'd Penney's data go?

Payments in podcast


Steven Peisner

EMV and the United States

Tracy Kitten


Gift card muscle flex

Maxwell Sinovoi
United Bank Card Inc.


Street SmartsSM:
Are you prepared for the big R?

Dee Karawadra
Impact PaySystem

Three ways to boost sales in 2008

Scott Henry

Residual report review

Jeff Fortney
Clearent LLC

Stop, look, listen to merchants: Ten tips

Aaron Bills
3Delta Systems Inc.

Get a grip on revolving doors

Curt Hensley
CSH Consulting

Pounce on cash advance pronto

Mike Evans
2nd Source Funding

Company Profile

New Products

A paper-thin RFID shield

PaperTyger Defender Contactless Card Shield
Chase Corp.

Elo touch screen at Vegas POS

Elo TouchSystems 1729L
Elo TouchSystems


Little lovin', big boost






Resource Guide


A Bigger Thing

The Green Sheet Online Edition

February 11, 2008  •  Issue 08:02:01

previous next

Residual report review

By Jeff Fortney

Residual earnings are the lifeblood of the industry. And most payment professionals want their residuals to escalate and become the backbone of their businesses. With this goal in mind, the review of residual reports should be a top priority - each month.

However, it is all too common for merchant level salespeople (MLSs) to do, at best, a cursory review of the reports they receive. When asked why, they commonly offer the following responses:

Behind each of these comments is a common theme: Residual reporting is often confusing, and many agents do not understand what data should be examined. But reviewing reports can be made easy, even if you do not have a degree in mathematics.

MLSs can take several simple steps to identify basic concerns, simple math errors or even confusion in their program specifics - in other words, confirm that your understanding of your share percentage is actually what you are paid.

I suggest noting your questions as you review the data and holding them for a single phone call or meeting after you have completed your data analysis. This may save everybody a little bit of time and, most importantly, as you grow more comfortable with the data, you will start to answer your own questions.

What to get

Reports come in various formats. Raw data files, Excel spreadsheets and online reporting are the most common. All are electronic in nature. MLSs must be able to read their reports and have the right to request to receive data in a format they can read. For example, if you do not have Excel, request a report in PDF format.

Each report should provide common categories broken down to the merchant level. The categories may have different names, but they should include the following:

There should also be portfolio totals for each category.

What to do

Begin by analyzing the total amount paid to you. Divide the total earned by the gross collected minus your processing expenses. This should equal your expected revenue share percentage.

Divide the total dollars earned by the total bankcard processing volume. This will establish the basis point return on your portfolio. This number is important when comparing your month-to-month earnings.

Simply stated, even though your earnings may be growing, unless the basis point return stays within an acceptable range month to month, there may be an error or a concern that needs to be addressed.

I also suggest that you proof the processing expenses. Ask yourself simple questions such as:

Calculate the basis point return on every merchant, and look for any value that appears to be out of your portfolio's norm. You may find that a merchant may be priced too high, or conversely, priced incorrectly. This calculation also helps to identify any merchant who may be missing a fee or whose calculation contains a mathematical error.

Next, select a random sample of your merchants. This should be merchants of all sizes, not just your biggest volume merchant or your highest or lowest profit merchant.

Once identified, examine each individual merchant's billings. If you have access to merchant statements or online reporting, use these resources as proof instruments to find out whether you are receiving credit for all the revenue collected. If you cannot affirmatively answer this question, you likely have a "disconnect" between the processor's perception of your program and your perception.

This might have a serious impact on your income and could require you to reconsider your choice of partners.

After identifying all your concerns, contact your processor. Time is of the essence, as most contracts only allow a finite period for corrections to reporting. In most cases, you only have 30 to 60 days to submit questions or correction requests.

It's also important to remember to save your work to a separate electronic file or on paper. Keep the data for analyzing future growth trends and for determining if any concern or error is consistent month to month.

With the huge variances in programs offered to MLSs, the importance of a thorough, ongoing review cannot be overstated. You should trust your processor, but also verify. It is your money after all.

Jeff Fortney is Director of Business Development with Clearent LLC. He has more than 12 years experience in the payments industry. Contact him at or 972-618-7340.

Notice to readers: These are archived articles. Contact names or information may be out of date. We regret any inconvenience.

previous next

Spotlight Innovators:

North American Bancard | USAePay | Board Studios