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…
  • 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…
  • 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 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…
  • Difference between AR General Ledger and AR Subledgers

    Hi, We found a Difference between AR GL balance and AR subledgers as at 31st December 2022 and that difference comes from December 2022. i want to know how to reconcile the month of December 2022 and find the reasons for this difference. Please advice…
  • Book Balance in Bank Reconciliation

    Our bank has not been reconciled in Sage from 2018 onwards because of some issues. Now I want to start reconciling in Sage. Our bank balance is as below and there is a book balance of the below amount in the picture. The question I have is where is the…
  • 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…
  • 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…
  • Credit Card Statement Reconciliation

    Hello, Is there a way to record individual credit card expense transactions and be able to reconcile the monthly credit card statements like a bank account? Or import the invoice #s for reconciliation? We have hundreds of credit card transactions…
  • 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…
  • Troubleshooting the “Sage 300 ERP UI Container has stopped working” part 1

    It is probably an error we’ve all seen while in Sage 300 ERP, the dreaded “Sage 300 ERP UI Container has stopped working”. We have blogged about this topic before but it seems that this error message has popped up in a variety situations from opening…
  • Balancing the books

    Recently, I listened in on a call where the customer was having an issue where their book balance didn’t agree with the General Ledger. They noticed this while trying to reconcile their statements in Bank Services. Here is an example of what that would…