Sage 100

 View Only
  • 1.  Commission Checks from Sage

    Posted 10-15-2019 11:15
    At the beginning of this month we received an email from Sage saying we could no longer apply commission credits we received against invoices unless the commissions were used in the same month they were issued.  (They sent the email on October 1st, when it was too late to take those credits in the same month they were received...off course! No prior notice whatsoever.)  And that Sage would be issuing a check for any outstanding commissions/credit memos instead.

    Most folks have already thought about a solution to clear those credits, but this is new for us.  I really didn't want to do an AR to AP Clearing - that just never has worked well for us.  And I didn't want to take the time to "adjust" the 23 credits off of their Vendor File.   So instead, when the check was received, we credited it to a clearing account in Cash Receipts.  Then I set up a new bank account, using that same clearing account as the GL account for the bank, and labeled the new checking account as "Sage Clearing Account."  And proceeded to use the new checking account in manual check entry to "pay" those outstanding credits, with the check number from the Sage check issued to us, and using a negative amount as the check amount.  Finally I let the system select the credits automatically.  I did have to delete a few invoices, but that turned out to be a MUCH easier solution than almost anything else I could think of.  Plus now I have a bank account set up where I can keep track of not only the Commissions Sage has paid for, but also the checks we are receiving from Sage.

    Probably you have your own process in place already, but if you don't, this was an easy way to clear a lot of credits all at once!

    ------------------------------
    Sue Bennett
    Jack of All Trades, Master of 1
    Bennett/Porter & Associates, Inc.
    Tigard OR
    503.620.3484
    ------------------------------


  • 2.  RE: Commission Checks from Sage

    Posted 10-16-2019 09:01
    Hi Sue, are you familiar with the APP check number process?  You can enter the letters APP as the first three characters of the check number in Manual Check Entry, and then use any three digit number after it to create a dummy check.  We keep track of this number by simply looking it up in Sage 100 when we process the next APP check, so we started at APP000, and then we move sequentially with APP001, APP002, etc.  The purpose is to apply open credits to open invoices, but you can also use it to "pay off" outstanding credits.  The way we do it is we record the check from Sage into our Customer Deposits GL account.  We then use an APP check in Manual Check Entry to select all the open credits.  On the last line of the Manual Check Entry, we apply the total against the Customer Deposits account.  We use our existing Bank Code throughout.  It works perfectly for us.

    ------------------------------
    Brian Kelly
    President and Head Cheerleader
    Accounting Systems, Inc. (ASI)
    Columbia SC
    803-252-6154 x210
    ------------------------------



  • 3.  RE: Commission Checks from Sage

    Posted 10-16-2019 09:39
    We do the same thing @Brian Kelly!​

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------



  • 4.  RE: Commission Checks from Sage

    Posted 10-16-2019 10:27

    Hi Brian – I am indeed familiar with the APP process!  And since both methods record the deposit into, basically, a clearing account, it is the same number of steps – just a different way to do it.  (Plus – I like seeing all of the detail of the commission credits in a totally separate place – they're all together that way!)

     

    Sue Bennett | President

    P. 503 620 3484 | F. 503 620 2765

    12559 SW 69th Ave | Tigard, OR  97223

    Sue@benpor.comwww.benpor.com

    Bennett/Porter Blog facebook twitter

     

     



    ------Original Message------

    Hi Sue, are you familiar with the APP check number process?  You can enter the letters APP as the first three characters of the check number in Manual Check Entry, and then use any three digit number after it to create a dummy check.  We keep track of this number by simply looking it up in Sage 100 when we process the next APP check, so we started at APP000, and then we move sequentially with APP001, APP002, etc.  The purpose is to apply open credits to open invoices, but you can also use it to "pay off" outstanding credits.  The way we do it is we record the check from Sage into our Customer Deposits GL account.  We then use an APP check in Manual Check Entry to select all the open credits.  On the last line of the Manual Check Entry, we apply the total against the Customer Deposits account.  We use our existing Bank Code throughout.  It works perfectly for us.

    ------------------------------
    Brian Kelly
    President and Head Cheerleader
    Accounting Systems, Inc. (ASI)
    Columbia SC
    803-252-6154 x210
    ------------------------------