Sage 100

 View Only
Expand all | Collapse all

V/I Job for GL Transaction Entry

  • 1.  V/I Job for GL Transaction Entry

    Posted 04-03-2025 17:30

    Hello. I wonder whether anyone has created a V/I import job for GL Transaction Entry and would be willing to share? I need to bring in payroll distributions from a third party and also post the net amount to bank rec, which is why I'm using GL Trx Entry. 

    Thank you,

    Karen



    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    559-448-0900
    559-577-4142
    http://www.asifocus.com
    ------------------------------


  • 2.  RE: V/I Job for GL Transaction Entry

    Posted 04-03-2025 17:53

    Wayne has some decade+ old ones in the Content Library.



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 3.  RE: V/I Job for GL Transaction Entry

    Posted 04-03-2025 17:55

    Actually, I have a few recent ones.  I'll post shortly.



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 4.  RE: V/I Job for GL Transaction Entry

    Posted 04-03-2025 18:01
      |   view attached

    The attached contains a couple from v2017 (Nov '17).



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Attachment(s)

    exp
    gl trans entry - v2017.exp   90 KB 1 version


  • 5.  RE: V/I Job for GL Transaction Entry

    Posted 04-03-2025 19:01

    Thank you, Brett! I just got back from a much-needed afternoon coffee break. I will give these a go. I appreciate your help!

    Karen



    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    559-448-0900
    559-577-4142
    http://www.asifocus.com
    ------------------------------



  • 6.  RE: V/I Job for GL Transaction Entry

    Posted 04-07-2025 13:47

    @Brett Zimmerman, these were very helpful, thanks again. That said;

    Today I was this many years old when I learned:

    GL Transaction Journal Entry will NOT post the grand total to bank rec. It will split out each GL line amount into BR, with the sum of those lines adding up to the total that is deducted from the bank. So now I'm changing tactics and will import into AP Manual Check Entry.

    Karen 



    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    559-448-0900
    559-577-4142
    http://www.asifocus.com
    ------------------------------



  • 7.  RE: V/I Job for GL Transaction Entry

    Posted 04-08-2025 11:40

    Not disagreeing the TJE IS difficult to master, but I thought you could post in total.  Does the help text below not apply to your need?

    Post Deposits in Summary

    Select this check box to post all deposit transactions for an entry as one entry in the Bank Reconciliation module. This check box is available only if the Bank Reconciliation module is integrated with General Ledger, and Deposit is selected in the Transaction Type field in the Transaction Journal Format window.

    Clear this check box to post all deposit transactions for an entry as separate entries in the Bank Reconciliation module.

    The value of this check box displays in the Post Deposits in Summary check box on the Transaction Journal Entry Header tab.

    Note  When the summary posting is updated to the Bank Reconciliation module, the posting date entered in the Posting Date field on the Transaction Journal Entry Header tab is used for the Bank Reconciliation deposit date, not the date entered in the Date field on the Lines tab.



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

    Improving bottom lines for over 25 years!
    ------------------------------



  • 8.  RE: V/I Job for GL Transaction Entry

    Posted 04-08-2025 12:07

    I thought that also, @Jeff Schwenk, but assumed 'payroll distributions' wouldn't be done as deposit type.



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 9.  RE: V/I Job for GL Transaction Entry

    Posted 04-08-2025 18:46

    No reason why you couldn't use it as a negative deposit..



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

    Improving bottom lines for over 25 years!
    ------------------------------



  • 10.  RE: V/I Job for GL Transaction Entry

    Posted 04-09-2025 08:45

    @Karen O'Lane I use a Payroll Clearing Account with my clients.  They do a simple GL Transaction Entry (or Bank Rec Entry) to Credit Cash and Debit a Payroll Clearing Account.  With this first entry, they enter each "cash disbursement" as it's own entry.  So if their payroll actually pulls dollars from the account with four separate entries, they post them separately.  Then they do the formal journal entry to Credit the Payroll Clearing Account with all the ins and outs.  It works well for the clients that are doing it in this manner.  



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------



  • 11.  RE: V/I Job for GL Transaction Entry

    Posted 04-09-2025 10:11

    (An Admin might want to move this post to the Sage 100 community... instead of the big 90 Minds community, which is open to all...).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 12.  RE: V/I Job for GL Transaction Entry

    Posted 04-09-2025 10:15

    @Robert Wood, can you move this thread to the Sage 100 group.  Good catch, @Kevin Moyes.



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 13.  RE: V/I Job for GL Transaction Entry

    Posted 04-09-2025 11:06

    It is moved.



    ------------------------------
    Robert Wood
    DDF Consulting Group
    Ocala FL
    (352) 615-5898
    ------------------------------