• importing an RBC Commercial Visa statement

    Hi everyone. Does anyone import Visa statements and use an RBC Commercial Visa account? I have downloaded the OFX file from our bank. When I import it into Sage, it tells me we're about to upload 437 transactions. Which seems about right. However, only…
  • Bank reconciliation

    I reconciled Dec 2023 general ledger and matched it with the bank statement. On Sage, I had unresolved amount of $39.26. I performed a bank adjustment entry for this amount But when I was reconciling general ledger from SAGE and bank statement for Feb…
  • BANK RECONCILIATION

    Hello! I get issues every month while reconciling the bank statement. I always get unresolved, resolved and outstanding figures. Well luckily this time I have outstanding as 0 but resolved/unresolved always have figures. All the transactions are entered…
  • Sage 50 bank rec first time

    We started Sage 50 June 1, 2023 with an existing trial balance from May 31, 2023. I entered all the previous A-R and A-P and trial balance and outstanding cheques and receipts and still have unallocated funds. what and where do i search for them plea…
  • Owner contributions for reconciliation

    Owner is a sole proprietor how frequently deposits money into the business account and then repays himself when cash comes in. Previous bookkeeper did all the entries in GJ with only the business bank account attached. I'd like to create new bank accounts…
  • Receiver General Cheque from previous year

    Hi There, Trying to figure out why an HST Cheque that was entered in a previous year (Sales invoice) is not coming up when I try to reconcile the bank statement? There were 6 in total deposited in the same month and entered, but when I bring up the…
  • Bank account setting up while rebuilding a company.

    I am currently in the process of rebuilding a company in SAGE 50 and have a few inquiries related to setting up the bank accounts, particularly addressing the input of outstanding/uncleared items. Thank you for your time. Appreciate your help in advance…
  • Bank accounts

    Hello, I have opened another bank account and have processed some cheques through it, however, when I do a print out to do a quick look what cheques have gone through.... they aren't showing up, only deposits and transfers. Have I missed something in…
  • Duplicate transactions in the matching transaction window

    I have uploaded an ofx file to bank services. While in the verify screen, it said there were transactions that might be duplicates. I could not see how to delete those specific transactions from in that screen, but I downloaded it anyway because in the…
  • Wrong ending balance in chequing and missing J/E

    I just completed all my journal entries and went to reconcile my clients chequing account. It is appearing as -$3000 when it should be -$17.66. I printed out the g/L went through all the bank statements and the only discrepancy was that there was an amount…
  • I have some transactions that are not showing in my bank reconciliation

    All my A/R Receipts and my A/P Payments are not showing up in my bank reconciliation. I have doubled checked my general ledger for this bank account and all the transactions are there. How can I have these missing transaction appear under my reconciliation…
  • Bank Reconciliation

    How can I reconcile bank statements going 2 years back. Can I do all the entries and then reconcile bank statements? What is the best way?
  • How do I reverse a posted sale and deposit from prior period without affecting taxes owning?

    I accidentally posted 2 sales for the same amounts, once to the prior entity and then again after a name change. The deposit was recorded twice as well. Bank reconciliation still shows the 2nd deposit amount and I'm looking to clear that up, but don't…
  • Post-dated cheque cashed early by bank - how to reconcile bank for that month

    Hi, I just noticed that one of the post-dated December cheques was cashed in November. How should I proceed with bank reconciliation in this situation? Many thanks!!
  • US Bank Rec

    When I go to reconcile my US bank on Sage 50 it shows that I am reconciled , I process but it does not complete the step. It goes back to the screen as if I never processed. It has happened the last few months, so according to Sage I haven't reconciled…
  • Money Transfer auto deposit for rent

    We have multiple properties and most of our rents are paid using Interact e-transfer which is now set up as Auto Deposit. What is the easiest way to track and reconcile in bank as it only show amount and the company name in the account and we have multiple…
  • Account reconciliation

    Hi everyone, I am new to Sage. I am able to get the Account Reconciliation Detail Report for my US account but not the Reconciliation report. I am able to get both for my Canadian account. Has anyone had this problem? Thanks, Gary
  • Bank Reconciliation

    I am trying to reconcile a bank account and it states that another user has locked account for reconciliation. I have never done this before and not sure how to proceed to unlock.
  • Account Reconciliation Report Showing Up With Outstanding Deposits that aren't Outstanding

    Hi there! I was reconciling my bank account for the last month of the fiscal year and when I went to print out the reconciliation report (summary with outstanding transaction detail) it is now showing deposits that are outstanding with a little * beside…
  • How to match multiple GL entries to one bank statement entry in the Match Transaction window?

    How do you match multiple GL entries to one bank statement entry in the Match Transaction window? Do you have to make a proxy account to accumulate the GL balances so they can be matched to one bank statement amount?
  • Bank rec issues of unresolved amt of previous month's closing bank balance before I start.

    Bank rec issues of unresolved amt showing of previous month's closing bank balance before I even get started. Checked data integrity all is fine. No JE postings were missed. Has this happened to anyone else.
  • Unresolved Bank Reconcilation

    So I am trying to reconcile my bank statement. and it shows unresolved $4,955.38. I am not out, I went through everything and redid it and still shows unresolved. So i google and it says sometimes when you close the previous month an error may appear…
  • Discrepancy of 0.01 and Unresolved -$0.01

    I have reconciled my bank account, however, the Discrepancy is 0.01 and the unresolved is -0.01. I reset the Reconciliation to the previous month that balanced and now it won't balance and has the same discrepancy and unresolved amounts as the current…
  • Transaction not showing up for matching

    I am matching my bank download to my transactions on sage for the first time. I have come across several transactions, all invoices paid to my business by customers using a credit card and then being transferred to my bank account by my credit card processing…
  • Bank Reconciliation Entries Duplicated by Sage 50 System

    HI, I 've experienced an error from an update made by Sage 50 back around April. For some reason 2 entries re-appeared after the update in the next month's bank reconciliation module. When I dug through the details, I realized that it was an automated…