Browse By Tags

  • opening balance from 2021, how to reconcile stmt to bring up to date

    Hi there, I took over the book keeping for a company and the previous book keeper was not consistent with using the bank rec for the credit cards. The Company year end is Oct 1 - Sept 30th. I am trying to go backwards to clear out and reconcile 2022…
  • 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…
  • Payroll Tax Remittance

    My starting balance is incorrect in my remittance summary. I tried to adjust the payments part so it would zero it out but it didn't clear it out. How can I get it removed or adjusted?
  • 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…
  • Bank Account Rec - Account Recievable

    Ok, Hopefully I can explain this well. Over the course of 6 months we had continuous sales with one main customer. Lets just call it " cust A" Their was a large amount of discrepencies in "cust A" pay summaries so long story short, I wanted to reverse…
  • 1st bank rec since rebuilding data using accountant's year end figures

    I have done and redone bank recs numerous times, and have always been able to figure it out when the discrepancy and unresolved argue with you. But I am stumped this time. I have rebuilt a company after they lost all data due to a computer crash, and…
  • reconciliation

    With one cheque I paid 3 invoices. When my back statement came in I realized that I entered one of the three invoices incorrectly and therefore my system is off by $.01 because one invoice is off by $.01. I tried to go back and adjust the entry to the…