• AP automatic check is a bank adjustment now

    We have just run into a new issue. 3 automatic ( not manual) checks show up in the bank recap report as "Adjustments" and not check, like everything else. They were printed during a check run with 400 other checks, but they show as 'Adjustment' in the…
  • bank reconciliation not clearing

    I am trying to clear the transactions on one of our accounts while reconciling & the system will not bring up the dialog box that asks if we want to remove cleared transactions. The bank balance matches the GL, but the calculated book balance is off…
  • purge cleared items - bank reconciliation

    How can I be sure that I purged cleared items on my bank reconciliation? I do not recall the system asking this question, but I may have been on auto-pilot and answered it without realizing.
  • Bank Rec

    I have discovered that the previous accounting manager has not updated the bank Rec module for several months. My CEO told me just worry about updating the most recent month so we can move forward quickly. What is the best way to do this? Its like I am…
  • Bank feed does not work with Bank Reconciliation

    We have started using Bank Feed to get bank transactions into Bank Rec to clear items. When we download the Bank Feed it imports all transactions not previously downloaded. When we want to do the Bank rec for a month (October) we don't start until the…
  • Drop Ship PO's in Purchases Clearing

    I thought when a PO has a "Drop Ship" order type the qty received is ignored in SAGE, therefore shouldn't show in the purchases clearing report? I am showing the qty invoiced but 0 received for this PO and I checked the PO and it has Drop Ship selected…
  • Sage 100: Out of Balance

    Our system is reflecting an "Out of Balance" message when trying to reconcile our Bank Rec for month end. Now when converting quotes into sales orders and sending an email confirmation to our customers 1) it's not show all the lines items and 2) there…
  • how to uncheck/unclear the range of cleared items in Bank Reconciliation

    Does anyone know how to uncheck/unclear/unmark the range of cleared items in Bank Reconciliation without having to do it one by one?
  • Are we OKAY to started checking off the boxes to 'clear' transactions from the next month before a Prior Month(s) has been cleared?

    For example: August-23 isn't balanced so we are still researching the discrepancies. In the meantime, can we begin 'clearing' (checking the boxes) for September? Financial reporting is updated and presented weekly, so having an almost 'real-time'…
  • Bank Reconciliation - Beginning Balance Changed from Ending Balance of Previous Month

    Hello everyone, I am trying to reconcile one of our accounts in Sage 100 and when I am in the Reconcile Bank feature, it shows that there is zero difference, but when I printed the report it said that I was off. I have identified that it was the beginning…
  • Cash Receipts, source

    I've been at this company for about 5 months and when a payment comes in from a customer we post that payment via Cash Receipts, the source is AR. If I have a deposit (NOT from a customer) I enter that via Cash Receipts, the source is GL. This company…
  • Bank Reconciliations - How can we find information from previous months reconciliations?

    We are fairly new to Sage 100. We upgraded to Sage 100 in March 2023 due to corrupted data in Sage 50. When we reconciled our bank accounts for March and April, unfortunately we didnt print out the reconciliation and the staff member that completed the…
  • Bank reconciliation

    The statement ending balance after finalizing a reconciliation changes when i open up the next month's reconciliation and then beginning balance doesn't match. I've tried the fixes offered by Sage support; but it has not fixed it. Any ideas? thank…
  • Invoices Not Closing Properly

    We are having an issue with invoices not closing properly and causing them to show up as unpaid on the Accounts Receivable Aged Invoice Report and still open in Cash Receipts Entry. anyone else had this issue and if so, what is being done wrong and how…
  • Transaction tied to past reconciliation

    I need to void an invoice for something that was appearing in my main bank reconciliation screen for June. So it will throw off the rec balance but I am planning on re-entering in sage again in a different form so it should work.
  • Saving bank recon

    When i try to save a bank or CC final recon program goes to "not responding" and i have to shut down. Any fix?
  • Completed Bank Rec with wrong date

    Hi. I came in this morning to close out the month of June. My module date was set for 7/3, i forgot to change the date back to June. Does anyone know how to reverse the back rec? Can I just go back in and redo for June? Any help on where to move from…
  • Credit Card and ACH Settlement Rpt

    Hello, For the past couple months our credit card and ach settlement report has been showing a Company: as "MANUAL PROCESSED" we see this for multiple Settlement Numbers on report. Can anyone tell me what "Manual Processed" refers to.. I want believe…
  • Outstanding Credit on BR, Financials reflect Debit - SAGE 100

    Hello, Looking for any help/guidance I can get. I had some issues when printing a check for an invoice, so I made adjustments and reversals, and then the second check was double the invoice, I realized I incorrectly adjusted the invoice, corrected that…
  • Auto Check Clear file in use

    We continually have an issue in Bank Rec auto check reconciliation every month where the import file always needs to be renamed to something different than what it was the previous month in order to get through the process. If not this message pops up…
  • Voided EFT Payment in Future Period

    We had one EFT payment in December 2022 that never left the bank, so we voided it in Intacct when we began reconciling our bank accounts. Unfortunately, the payment void date was selected as December 2023 instead of December 2022. We cannot reverse the…
  • AP GL Reconciliation-How TO?

    I am a very new user and am trying to reconcile my AP GL balance to my AP Aged Invoice and AP Trial Balance. What are the steps to do so? In previous systems I have used, you could reconcile an account like this by reviewing the "schedule" for lingering…
  • AP to GL Reconciliation

    When reconciling AP to the GL and using the AP Trial balance, does the invoice date have an impact on differences? As I understand it using the AP Trial balance goes by transaction date which is the GL posting date. I'm reconciling day by day and sometimes…