Sage 100

 View Only
  • 1.  Discounts Amounts on AR Aging Report

    Posted 10-30-2024 10:03

    Its hard to believe that I have never noticed this before, so I am hoping I am incorrect.

    But it appears that the invoice discount due date and amount (from 2% net 30 terms code) have no real effect on the AR Aging Report. A column is there for the discount amount. If you run the Aging Report after the discount due date, the discount amount will still show the full amount.

    Also, if you pay the invoice (or partial payment ) and take the discount. When you go back and running the aging report prior to the payment date, the discount amount on the Aging Report is now zero even if it is before or after the discount due date.

    The same appears to be true on the AR Trial Balance Report

    My client was relying on this discount column to create an accrual entry for sales discounts but they are really questioning that value of the column now.

    Assuming I get to write a custom crystal report to re-calc aging, but wanted to ask for any other suggestions prior to this.

    Or maybe I misunderstanding the discount amount columns.

    Thank you

    Michael



    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    ------------------------------


  • 2.  RE: Discounts Amounts on AR Aging Report

    Posted 10-30-2024 13:40

    From my perspective, not sure why you accrue something that is dependent on an event that may or may NOT happen and is totally based on management's discretion.  Inventory arrived but not the invoice, you accrue it.  Bonus is earned as of a certain date, you accrue it.  Invoice arrives but you may or may not take the discount (depends on how management feels that day), why bother?  But I digress......

    Odds are (most extremely likely) that this is the way it has always been in Sage.  Big ol WAD.



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444
    ------------------------------



  • 3.  RE: Discounts Amounts on AR Aging Report

    Posted 10-30-2024 15:17

    You make a good point @Jeff Schwenk about not accruing a potential customer discount in most situations.  However, similar to accruing bad debts to allowance for doubtful accounts as opposed to the direct write-off method, I believe there is appropriate circumstances to accrue customer discounts.

    If a company does most or all of it's customer invoicing at the end of the month, then, if the discounts aren't recognized until the following month or months, then the matching principle is violated. The revenue and associated costs of a transaction should be recognized in the same reporting period.  If a large percentage of the discounts will be potentially recognized in a future period then it would be appropriate to create an allowance for customer discounts account to estimate the discounts taken in a later month.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 4.  RE: Discounts Amounts on AR Aging Report

    Posted 10-30-2024 15:43

    I think you must be clear about WHY they want to book this contra-asset.

    If it's for auditors, isn't it a moot point for all sales older than 30 days? If they want to book it for EOY B/S, then make the entry equal to the average % of 30-day sales that took discounts. Or better yet, just take the actual $$ amount of discounts experienced in January and apply it to 12/31. 

    If it's for cash flow management, think about simply entering an amount equal to the past 90-day average of discounts taken. Then make periodic updates to the actuals.

    For management, I'd rather focus on how to get the 60- and 90-day accounts to pay in 30- 45-days.



    ------------------------------
    Jerry Norman
    Smartbridge Partners
    (512) 653-7498
    ------------------------------



  • 5.  RE: Discounts Amounts on AR Aging Report

    Posted 10-30-2024 18:12

    Yep, auditors get a major voice as does the CFO.....

    I would also hope that the amounts are material



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444
    ------------------------------



  • 6.  RE: Discounts Amounts on AR Aging Report

    Posted 10-30-2024 18:19

    Yep.  I just execute whatever accounting treatment the CFO and outside CPAs decide.  I make it clear I don't provide accounting advice.  It's fun to speculate on their reasoning though!



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 7.  RE: Discounts Amounts on AR Aging Report

    Posted 10-30-2024 19:11

    We all have clients where our accounting radar goes off.....



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444
    ------------------------------



  • 8.  RE: Discounts Amounts on AR Aging Report

    Posted 10-31-2024 08:03

    Yes. The amount is going to be material enough at year end that the Controller and Accountant wanted the number.

     

    Guess it is report writing time.

     

    Thank you to everyone.

    Michael

     

    Michael  H . Davis

    CPA.CITP, MCSE

    Senior Consultant

    Michael.Davis@warrenaverett.com

    (D) 

    205.313.4734

    (O) 

    205.313.4700   

    (F) 

    205.592.9991

    2500 Acton Road, Birmingham, AL 35243

    Ranked as one of the top managed service providers (MSP)
    and managed security service providers (MSSP) 
    in the world several years in a row. 

     

     

     

    To contact our Software Support Team call 844.712.6223 or email software@warrenaverett.com.
    To contact our Technical Services Team call 888.419.9090 or email resource.center@warrenaverett.com

    Confidentiality Notice: This email and any attachments may contain confidential and privileged information intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient, please delete this message and notify the sender immediately. Thank you.