Browse By Tags

  • 1st credit card rec

    I am still waiting for an answer to my question 10 days ago. I started my 1st credit card rec. I entered all transactions from the statement and checked them off. Opening balance and ending balance from the statement. (GOOD) I am good with all postings…
  • 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…
  • year end bank reconciliation - bank statement date is Dec 29th not 31st

    My 2023 Dec actual RBC bank statement ends Dec 29th My fiscal year ends Dec 31 2023 there is no banking transactions in my online banking for Dec 30 or 31th. I have not yet received the Jan 2024 statement, obviously bc the month is not complete…
  • Bank Reconciliation add supplier name

    Within the screen BNR0 Bank reconciliation has these reference tables which is OTB GACCENTRY Accounting entries GACCENTRYD Accounting entry lines BANREC Bank Reconciliation Statement BANRECD …
  • 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…
  • How put negative sign in Gst purchases in balance sheet

    Hi there! I have a problem with our sage 50. I am currently a bookkeeper and I having a problem with GSt purchases in balance sheet. It doesnt show the negative sign, and it's adding the gst sale and gst purchase. The previous bookkeper up the books as…
  • upload bank statement

    Hello - Can I convert my bank statement from pdf format to the .ofx for sage upload? I can't seem to find the option when downloading from my bank.
  • Bank Reconciliations

    My bank reconciliation is out, can I go back and re-reconcile an account? Also, we have EFT payments that get removed from the bank at the end of one month, but don't come out of our account until the early days of the next month on Sage. This is due…
  • 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?
  • 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…
  • How do I Undo a recent reconciliation so I can rectify something?

    When working with Quickbooks, we have a really easy way to undo a reconciliation to then adjust one transaction and re-save the reconciliation. How do I do that in Sage 100 Contractor?
  • Incoming Bank Transactions : transaction appears twice on VISA statement (2 currencies)

    Hello, In the Incoming Bank Transactions screen for my Credit Card, I see 2 separate entries for the SAME purchase : One entry is in CAD (41.18) and the other is in USD (29.99), as shown in the attached screenshot. Since I work in Canada, I processed…
  • Purchases Clearing Report <> balance with PO clearing GL account

    Specifically asking when you have a PV source journal due to Sage's KB scenario below, what are users best practice recommendations on how they handle the balance sitting in the GL PO clearing account? Do you leave the costs there, reclass somewhere,…
  • Paying invoice that has inventory

    Newbie here. When I go to make an invoice paid that has associated inventory items on the purchase it won't let me change payment to cash so my Bank reconciliation is off by these invoices. So the invoice stays as Pay Later. How do I make these payments…
  • Adjusted book balance not matching statement

    I have reconciled my bank accounts and the correct totals are showing with a zero adjustment required in the reconciliation window. Since this is back work (2022) I am working forward and the balance sheet at Jan 1 2022 is not showing the correct statement…
  • How do I void uncleared cheques from prior years

    I have some cheques that were issued in 2020 and 2021 that were never cashed and I want to void them and get them off my bank rec. How would I do this? I will not be re-issuing these cheques.
  • CM Old Uncleared Transactions cannot be reconciled or changed

    We are trying to clear up some accounts that were never properly reconciled. There are several transactions from past years that we need to mark as reconciled. When we attempt to change them in the Edit Register, we get an error that says: Could not…
  • Some bank transactions not appearing

    I'm trying to do my first bank rec for our operating account and am running into an issue. I've linked our bank account, and all applicable transactions show up on the match transactions screen, but when I go to do the bank rec 2 of my May 31st transactions…
  • How to Delete a Bank Reconciliation? on sage50 Canada

    Help please, I am almost positive my Sage50 bank reconciliation has glitched in some way. I attempted to reconcile the account with my bank statement - everything matches up. I have the correct: statement start date; statement end date; statement…
  • Bank Reconciliation warnings

    I don't understand why I am getting this warning when trying to check off a deposit.
  • Bank reconciliation out of balance

    Good morning! I am currently trying to get caught up on some bank recs and have run into an out of balance that I'm not sure how to fix. I have gone through the bank rec module and clicked all of the checks that cleared, all of the deposits, and all of…
  • Small Unresolved Amounts in Account Reconciliation

    Hi, I had an accounts receivable paid by a customer, however, the cheque they wrote us was short by the small amount of $0.20 (the cheque was for over $5,000.) I entered the A/R as paid in full, knowing that when I do the account reconciliation that…