Sage 100

v2017 Adv - Looking for some journal entry/bank reconciliation thoughts. Below is a snippet of a 400 line PR JE that client imports biweekly into Sage. JE works great. Client wants to take it a set further so that the cash credits appear in the bank rec (individually). Have wrestled with a transaction JE but not getting anywhere. Ideally, it would be one entry. Would I add another column to for dummy check numbers? I thought about creating a clearing account for the JE, then do a negative cash receipt offsetting the clearing account but would like to avoid the extra steps if possible. How is everyone handling the external PR service JE's when it comes to the postings on the bank reconciliation? TIA

Maybe DSD enhancement G061 - Bank Rec Integration with GL

We've created a script on post write on the gl_journalheader table that writes to br_transaction if the gl account matches anything in Gl_bank. Seems to work well for our client

In the past I handled this by creating a chained BR import that ran against the same file. We did a regular journal entry for the GL and then a BR entry with filters applied for the BR module. It worked.

The only thing to add to Alan's is we replace the cash account in the journal entry for PR suspense (new gl account) and then the individual amounts are coded to the same (against cash) for the individual dollar amounts to bank rec.