October 28, 2013

m-Fin RECEIVABLES ACTIVITY


[This computation appears at the bottom of the report, providing an amount that the total payments received ordinarily should match.]

This computation appears at the bottom of the report, providing an amount that the total payments received ordinarily should match. This is a cash deficit example.

Do you manage projects? Do you run m-Fin PAYMENTS RECEIVED? A new report is available in Cognos QA for you to test, named m-Fin RECEIVABLES ACTIVITY. [18-Nov-2013 This report is in production now.] It is like m-Fin PAYMENTS RECEIVED but casts a wider net and so will show unusual accounting transactions that are left out of that report. The core idea is to show any source code that is not from the revenue recognition process. You might use m-Fin PAYMENTS RECEIVED when you know all of your receivables are nice and clean, and use m-Fin RECEIVABLES ACTIVITY when you know (or suspect) that they are not.

There is a Cross Check at the bottom of the report that is meant to be a helpful point of reference, showing cash and expenditures.  Normally this total will exactly offset your total receivables.  My thanks to Kathy Illian (School of Medicine – Neurology) for this idea and the proper way to compute the total.