Sage 100

 View Only
  • 1.  Paya Transactions Don't Post to Bank Rec

    Posted 10-23-2019 08:48
    Edited by Doug Higgs 10-23-2019 08:48
    v5.20.4 Standard - Customer just implemented Paya.  Credit card transaction entered in accounts receivable cash receipts or entered during sales order entry are not posting to the bank reconciliation module.  Integrate with bank rec is enabled in AR Options.  The transactions are posted correctly in the general ledger.  Is there integration to the bank rec?  If so, how is it enabled?

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------


  • 2.  RE: Paya Transactions Don't Post to Bank Rec

    Posted 10-23-2019 08:53
    By design CC transactions aren't supposed to post to Bank Rec.  When setting up the payment type, you should be specifying a credit card clearing account instead of a cash account.  When the funds actually hit the bank account, you should do a cash receipt offsetting the credit card clearing account.

    ------------------------------
    Mary Jo Krueger
    Senior Software Consultant
    CLA (CliftonLarsonAllen LLP)
    Appleton WI
    920-996-1176
    ------------------------------



  • 3.  RE: Paya Transactions Don't Post to Bank Rec

    Posted 10-23-2019 10:31
    https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=a8453865-4766-4faf-ba08-fafdc734a47a&CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=digestviewer#bma8453865-4766-4faf-ba08-fafdc734a47a

    ------------------------------
    - Brett
    ------------------------------



  • 4.  RE: Paya Transactions Don't Post to Bank Rec

    Posted 10-24-2019 08:32
    @Brett Zimmerman  Thanks.  The links you provided are potential options I can present.​

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 5.  RE: Paya Transactions Don't Post to Bank Rec

    Posted 10-24-2019 08:42
    @Mary Jo Krueger  Thank you for your reply.  I am not sure I agree with Sage's "working as designed", particularly​​ when the credit card is charged during SO entry and updated to the GL after the sales journal is updated.  I see the business logic if the CC is entered during AR cash receipts. I know there are service fees that reduce the cash receipt however they should be accounted for in payment type maintenance.  It would be nice if there were an option to post to the bank rec. There is are timing differences which could be an issue at the end of the month.  Timing difference could be reconciled by flagging the CC transaction in the bank rec as a deposit in transit, similar to a deposit that is mailed but hasn't cleared the bank. 

    I know many companies prefer using a clearing account to accumulate CC transactions. Some companies may prefer to avoid this step and post directly to cash.  It wold be nice if this method were an option.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 6.  RE: Paya Transactions Don't Post to Bank Rec

    Posted 10-24-2019 22:06
    I set my users CC payments up to post to a CC clearing account and then post the CC deposit via cash receipts entry to the same account.  I believe @Therese Logeais even has a Crystal report to help with reconciling.  How would your reconcile the BR if every individual transaction posted to it but only the total for the day posted to the bank?  Seems to be a catch 22 situation.  Some clients even use a VI of their bank deposits to their CC deposits at month end.  Takes about five minutes to do 20 - 25 deposits at the end of the month. ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------