At 7/24/00 4:43 PM, Tom Brown wrote:

>However: this is _FAR_ from sufficient for reconcilliation... I do not
>understand why openSRS has not/can not provide a simple "audit trail" of
>RCU's ... it would seem like the simplest thing in the world to do!?
>
>-2 RCUs july 1,2000 11:00:00 new domain, xyz.com
>-1 RCU  july 1,2000 11:30:00 transfer,  some other domain
>+50 RCU july 2,2000 09:00:00 deposit, credit card
>
>WHY is this so difficult? It would make the resellers lives and
>accountants lives _so_ much easier?

I agree; this would be very handy.

This is actually even more important because of a concern I have about 
OpenSRS accounting that I've been meaning to discuss.

I recently had a situation where OpenSRS gave me a $100 credit. 
Unfortunately, the OpenSRS accounting department had some difficulties 
doing this, because when all was said and done, this is what showed in my 
"Payments Information" section of the Web login:

Jun 19, 2000    Misc Credit    100.00
Jun 16, 2000    Misc Credit    100.00
Jun 16, 2000    Correction    -100.00
Jun 16, 2000    Correction    -100.00
Jun 14, 2000    Correction    -100.00
Jun 14, 2000    Misc Credit    100.00

As you can see, it's three credits, and three debits, which (you would 
think) would cancel each other out. I talked to [person's name available 
on request] in the OpenSRS accounting department, and I was told that 
there is not a one-to-one correlation between RCUs and dollar accounting 
information shown on the Payment Information screen. Apparently, four of 
these entries were mistakes that canceled each other out (fair enough), 
one was the true 10 RCU credit, and the remaining "Correction" had no 
effect on my RCUs and was "just an entry to make our internal accounting 
system balance" (?!).

So, in short, I was told that 10 RCUs were actually credited to my 
account even though no dollars are shown as having been credited. Okay -- 
unfortunately, the only way to check this is to total up all the payments 
I've ever sent to OpenSRS, then deduct one RCU for every domain year I've 
ever registered, and see if that matches my current RCU balance.

I tried this and to my dismay, it doesn't seem to balance either way. But 
I have no way of telling where the error crept in, because all I can tell 
is that I think I've sent OpenSRS X dollars in credits since January, and 
they should have taken out Y dollars in debits since then, and that 
should equal Z RCUs in July. The problem could have happened at any time 
in those seven months. (Or it could be my accounting error -- no way to 
tell.)

Anyway, sorry for the longwindedness, but my point is that this has shown 
a serious weakness of the current system: there's no way to trace what 
went wrong when things get out of whack. To reconcile any accounting 
system, including OpenSRS, you have to start from a point where you know 
the two parties agree on the current balance, which is usually the 
closing date of your last statement. But the only balance I know that 
OpenSRS and I agree on is zero dollars when I opened the account -- there 
is no way for me to find out what OpenSRS thinks my balance was on, say, 
June 1.

Maybe I'm the only one to have this problem because I had a credit to my 
account, but anyway, to add to Tom's example, what's needed is a display 
of every entry that affects accounting, plus a running balance, 
preferably in dollars to avoid problems when (if) RCUs get revalued:

DATE                  DESCRIPTION                    CHANGE BALANCE 
july 1,2000 08:00:00  opening balance from june               $100
july 1,2000 09:00:00  deposit, credit card           + $500   $600
july 1,2000 11:00:00  new domain, xyz.com, 2 years    - $20   $580
july 1,2000 11:30:00  transfer, abc.com               - $10   $570
july 2,2000 09:00:00  miscellaneous credit           + $100   $670
july 2,2000 10:00:00  transfer failed, def.com        + $10   $680

                                     CURRENT BALANCE: $680, 68 RCUs

If the OpenSRS accounting system showed me this information, I could tell 
exactly where the problem crept in. I could see if it matched my 
accounting records through January, then February, etc., and eventually 
I'd find which day it didn't match any more.

--
Robert L Mathews, Tiger Technologies

"A professional in an ape mask is still a professional." -Marge Simpson

Reply via email to