+ Reply to Thread
Results 1 to 5 of 5

Thread: Unearned Revenue keeps changing

  1. #1
    n00b Hamurabi is on a distinguished road
    Join Date
    Jun 2009
    Posts
    2
    Rep Power
    0

    Default Unearned Revenue keeps changing

    Hello,

    Every month while balancing Unearned Revenue (Prior Unearned Rev-Earned Rev+ (-) other specific accounts) to our GL, I have to write off 500 - 2000, due to mysterious activities.

    On May 30th, an “Unearned Revenue” report was ran with a date range of 5/1/2009 – 5/31/2009. This report gave me a balance for Prior Unearned Revenue of $500,000, and an Earned Revenue of 200,000.

    This report was ran again on 6/16/2009 to make sure the Unearned Revenue report was not changing, and to my lack of surprise, it was. The Prior Unearned Revenue decreased by $400, and Earned Revenue decreased by 40.

    I ran the report the next day (17th). The numbers changed again; the Unearned Rev decreased by $90, and Earned Rev decreased by $5. The same day (17th) I ran the report once more. The numbers have yet again changed. The Unearned stayed the same, but the Earned Rev decreased by 10.

    This was all within the same date range of 5/1/2009 – 5/31/2009. I also ran the GL interface for Unearned Revenue twice, 1 time through the month of May, and a second time half way through the month of June…No difference (as it should be) however the Unearned Rev keeps changing. I did some researching on this, and the only thing I have come up with is Unearned Rev auto accounts itself by amortizing, thus changing the numbers as activity happens. Overall, as a percentage the change is very minimal (less than 1%) but it is apparent.

    Should this be happening? Is this a glitch in our system? How should I proceed next?


    Thank you all in advance.

    -H

  2. #2
    n00b Ingmar is on a distinguished road
    Join Date
    Jul 2009
    Posts
    5
    Rep Power
    0

    Default

    I would leave things as they are. The software has been programmed to do so, and this must have a reason. It is not uncommon for unearned revenue to do this. Especially when this is also regarding UCOI (uneanred costs of insurance).
    Have somebody from the company explain to you what is happening and why, and then you will be able to determine if the fluctuations are to be considered normal or not.

  3. #3
    Moderator Helse is on a distinguished road Helse's Avatar
    Join Date
    Dec 2008
    Posts
    610
    Rep Power
    51

    Default

    Statistical Prognosis, algorithmic inconsistency
    Your suffering from a common statistical analysis malady oft denoted: algorithmic
    inconsistency and is the darling of mathematicians, economists, NASA 'telemetricians,
    engineers and Google search engine geeks.

    Consider budget accounting for a Special Purpose Entity (SPE) with 1 (one) property
    contributed for securitization purposes: oil license on proven reserves in Texas.

    Year 1 Revenue: $0
    Year 2 Revenue: $1 mil
    Year 3 Revenue: $10mil
    Year 4 Revenue: $1 mil (well depletion)

    Constructing a spreadsheet to calculate anticipated earnings prognosis, without
    a function designed to "smooth" earnings distributions, results in payments to
    bondholders with variable annual yields similar to venture capital agreements.

    Answer:
    Flag to Zahid or Pat to suggest an Excel function with "smoothing" attributes.
    Example: Mimic automobile lease financing pool securitization practices: Sum
    Years 1,2,3,4 expenses, divide by 48 months, result: monthly lease expense from parent
    company to grantor trust transportation pool.

    Realistic Answer: Heed Ingmar's suggestion; Identify inconsistent data reporting, inform
    relevant parties to expect variable accounting information (dynamic economics) and budget
    accordingly.
    Last edited by Helse; 07-16-2009 at 09:43 PM.
    http://www.accountingblock.com/avatars/helse.gif?type=sigpic&dateline=1271928550

  4. #4
    Moderator Helse is on a distinguished road Helse's Avatar
    Join Date
    Dec 2008
    Posts
    610
    Rep Power
    51

    Default Accounting Salvation (double entendre)

    There is another option. Propeller Head Alert

    I've been waiting to discuss grantor trusts and UNIFORM PRINCIPAL AND INCOME ACT (1997) rules.

    Separate the transportation pool into a separate trust (grantor trust qualifying as
    an entity disregarded for tax purposes*). Account for the trust under a cash system. Complete
    a boiler plate 2 page property management trust agreement similar to a SILO. Expenses, depreciation
    and income (if any) "flow through" to parent entity.
    Accountants term above practice a: "Reserve Account Class 1-3" (FASB), or,
    "Provisional Account"; legal reserve fund (IASB)
    (a.k.a., a trust)
    http://en.wikipedia.org/wiki/Reserve_%28accounting%29


    SECTION 403. BUSINESS AND OTHER ACTIVITIES CONDUCTED BY TRUSTEE.

    ["...or other activity..." rule]

    (a) If a trustee who conducts a business or other activity determines that it is in
    the best interest of all the beneficiaries to account separately for the business or
    activity instead of accounting for it as part of the trust's general accounting records,
    the trustee may maintain separate accounting records for its transactions, whether
    or not its assets are segregated from other trust assets.

    (b) A trustee who accounts separately for a business or other activity may determine
    the extent to which its net cash receipts must be retained for working capital, the
    acquisition or replacement of fixed assets, and other reasonably foreseeable needs of
    the business or activity, and the extent to which the remaining net cash receipts
    are accounted for as principal or income in the trust's general accounting records. If a
    trustee sells assets of the business or other activity, other than in the ordinary course
    of the business or activity, the trustee shall account for the net amount received as
    principal in the trust's general accounting records to the extent the trustee determines
    that the amount received is no longer required in the conduct of the business.
    http://www.law.upenn.edu/bll/archive...ia/upaia97.htm

    * grantor trusts are not technically "entities", under federal tax rules. Helse recognizes
    argument without accord.
    Last edited by Helse; 07-16-2009 at 09:48 PM.
    http://www.accountingblock.com/avatars/helse.gif?type=sigpic&dateline=1271928550

  5. #5
    Pat
    Pat is offline
    Moderator Pat will become famous soon enough
    Join Date
    Apr 2009
    Location
    USA
    Posts
    152
    Rep Power
    38

    Default

    Hamurabi,

    You should fully understand the account as you are responsible for the account balance (performs reconciliations). It may be a quirky calculation in the program, it may be you need to change some inputs that the program uses, it may be some program error or it may be a logic flaw in your reconciliation process, hell it may be a lot of things and it may end up out smarting you but you shouldn't just live with it. Have other people look at it as well. Make sure to use facts and question your assumptions. Just living with a flaw is not a good decision unless you fully understand it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Arcade Games | Video Game Trailers