• G/L Journal Entry Error - Please Help

    Has anyone experienced this error before when processing G/L Journal Entry? Not sure where to even begin but processing a few transactions / posting banking transactions and then doing G/L Journal Entry and we get this error. We are running Sage 300 2022…
  • Bank Reconciliation posting error: Requested payment was cleared previously

    We have been working with a customer who has had some issues with their bank rec. We have worked through their issues and are at the point where we are ready to post the reconciliation and we have received this error: Requested payment was cleared previously…
  • Can you reconcile E-Statements with Fifth Third Direct Bank that is different from Fifth Third Bank

    Hi, I have a client that would like to Reconcile E-Statements with Fifth Third Direct not Fifth Third Bank and they cannot. Does anyone no if Fifth Third Direct is supported? Thanks for all you do
  • A/R deposit shows Not Posted in bank rec

    We have a client running Sage 300 v2021.5. They have an A/R Receipt batch that was posted in A/R, but in Bank Services bank rec screen, it shows as ‘Not Posted’. Because of this status, they cannot clear the deposit in their bank rec. Has anyone seen…
  • Bank Entries doubling up

    In Sage 300 version 2020, I have seen in the last 2 days, bank entries doubling up. A entry was done as a withdrawal for 200 and it shows in the bank rec. as 400.00 , and an $100.00 entry was showing as a 200.00 entry on the reconciliation tab. When we…
  • bank Rec Deposit Date, Posting Date

    Problem: Receipt batch with a deposit date in one year and the posting dates of each entry in another year that was reversed Problem specific Details: Receipt batch created and posted as deposit date of 01/12/2022 and all entries in the batch with…
  • How to Link a Payment Code to the Bank Reconciliation

    We are starting to do EFT(s) to process some payments. I usually create a batch of invoices and then create a payment batch, In the past they have all been to cheques so I select criteria and then process the cheques. Once posted they will appear in my…
  • Bank reconciliation variance

    Hello, there is a discrepancy between the adjusted book balance of our bank rec and our gl account over a number of periods. The first variance ties perfectly to one entry that appears like it was posted correctly as a bank entry and cleared on the bank…
  • Bank Reconciliation issue

    Bank Reconciliation issue: We had to few receipts incorrectly entered in AR Module. We reversed them using the reversal feature in Bank Rec module. Reversal was recorded correctly in AR Module and GL. But in the Bank Rec these reversals are showing up…
  • Reversing GL entries that have been cleared in the bank?

    Hi All, I entered a bank USD entry with the wrong USD to CAD rate. This is messing up the balance of the clearing account and so I would like to reverse the bank entry and re-enter it with the correct USD to CAD rate. However, the bank entry is now…
  • Bank Rec purge

    Ran a bank transaction purge but some records were not removed. What is the requirement for removing old AP/AR records in Bank Services? I saw a document a few years back but cannot find it now?
  • I have an urgent bank reconcilition question

    I have multiple banks to reconcile and the GL and the Bank Balance is not the same.
  • Missing Cash Disbursement Entries in Bank Rec

    I've encountered a challenge reconciling my bank. At month end I input a cash disbursements batch and posted it. Transactions show up fine in the bank account. But when I run the bank rec the transactions are not there. I did some looking online and evidently…
  • Bank Rec does not show AR deposits pre conversion

    We recently upgraded to Sage 300 and are trying our first Bank Rec. All outstanding deposits pre-conversion are missing from the reconciliation screen, all outstanding checks both pre and post conversion are fine. We also ran the Bank Rec status report…
  • Data Integrity Bank Entry Error

    Sage 300 ERP 2016, working through my data integrity issues and there is a warning that I would like to resolve. The message is "W: G/L Account 'XXXXXXXX' is inactive, but can be used." It does give a sequence number with the error and when I go to BKENTH…
  • Deleting some old transactions in Bank Reconciliation

    Hi, There are some entries in the bank reconciliation has 0 amount, status shows 'X' reconciled. I am not able to change this and even after posting these entries still showing up. These never goes off from BR screen. Is there a way to remove these…
  • AP Payment not appearing in Bank Rec

    AP Batch contains 3 entries for a particular supplier. Payment entry dates are 5th october, 17th october & 31st October. Payment batch posted and resulting gl batch posted successfully. Zero issues here. (3 entries Payment Batch and 3 entry GL Batch…
  • Difference Between Bank Reconciliation GL Book Balance versus G/L Account Code Balance

    Hi, My customer has a difference since a few months between GL Bank Account versus Bank Book Balance, not much - $ 2676.12 pesos - but dont found the issue. Correct balance is the one in G/L but is less by that amount than Bank Book balance figure…
  • Bank Reconciliation - wrong check reconciled, how to correct?

    Bank Activity: Item 1: Customer 1 4/2/2018 Wire Transfer $500.00 Item 2: Customer 2 4/26/2018 Check 1234 $500.00 Item 3: Customer 1 4/30/2018 Wire Transfer $500.00 The person who reconciled the bank cleared Item number 1 and 2, instead of Item…
  • Bank Reconciliation - imbalance between Book Balance and GL Balance

    I understand how to correct an imbalance between the Book Balance the GL Balance if the GL is correct - simply post a bank entry to the GL account. But how do you adjust the GL balance if the Book Balance is already correct?
  • Clearing with bank error and write off

    when a deposit or withdrawal is cleared with bank error or Write off, what happens to it? does it show in the GL account which is selected i bank setup for Write off?
  • Bank Reconciliation Out of Balance

    I reconciled on 4/30/18 and all was good. Then i realized a bank transfer was entered twice, so i entered a transaction going the opposite way to clear one of them out. When i reconcile the statement for 5/3 and select both of the transactions it shows…
  • REVERSING CLEARED PAYMENTS IN A/P

    FormerMember
    FormerMember
    I'm not sure why we can reverse A/R payments and not A/P payments? I have had situations where we have prepaid items and then for whatever reason the funds were returned to us at a later date after I have reconciled the account. Then I have to do a debit…
  • Initial Bank Reconciliation

    Hi Support, We need to do a Bank rec for the first time even though Bank, AP and AR have been in use for some time now. What is the correct procedure for this.
  • Reverse Cleared Check

    Hi Support, An AP check has been cleared and bank rec has been posted. How can this check be reversed now? Priti