Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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
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…
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…
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…
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…
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: 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…
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…
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'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…
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 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…
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?
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?
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…
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…
We are facing a strange issue in our Bank reconciliation. None of the withdrawals are reconciled but the withdrawals at the bottom of the bank rec screen has a balance. We have double checked and none of the withdrawals are selected. Please assist.
…
It looks like this has been asked before, but the posts are ancient history so I thought that I'd ask again in case something has changed in the last eight years.
I reversed a cheque, but it was mailed and cleared our bank account. My reconciliation…
Hi,
As a user of Sage 300 v2016 PU2 we have the following error
"An error has occurred during the processing of Check Reconciliation. The error returned was 1. Process error." while posting Bank Reconciliation.
Data error. Check 0 for BK XX was…
Hi all,
I have a situation in how to account for a creditor refund. The scenario is:
Prepayment to Goods Supplier 1000
Goods received 900
Supplier invoice 900
Supplier refund 100
As the prepayment as been paid on a proforma invoice, the…
HI,
SAGE 300 ERP 6.1A PU4
WE HAVE POSTED THE BANK RECONCILIATION WITH A DEPOSIT WHICH WAS HAVING 38 ENTRIES. BY MISTAKE THE DEPOSIT IS RECONCILED WITHOUT SELECTING THE OPTION "CLEARED BY DEPOSIT DETAILS". DUE TO THIS NOW WE ARE NOT ABLE TO SEE THAT…