• 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…
  • check cashed twice

    I'm reconciling one month and my worker cashes checks by phone. So while doing this they had check lying around and cashed again so i cant reconcile that amount since that check was already cashed and bank cashed the check a second time again only to…
  • 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…
  • Box 14 Blank on one employee

    In reviewing our T4's for 2023 I have found one of our employee's Box 14 blank but should have a value. The income classification is used by all employees, there is nothing special about this staff member.
  • 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…
  • Accounts Payable don't match Balance sheet

    The accounts payable is out by close to $87000 on December 31, 2023. On December 30, 2023 it is perfect right on. How can this happen. No accounts payable entries were done on the 31st. This is the first time on 28 years this has ever happened. Data integrity…
  • 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?
  • Bank Matching not working

    so I cannot import my bank transactions for my bank account anymore. it works with my credit card suddenly there are two options for the bank account now since the 2024.0 update one doesnt do anything, if I select the other bank account a warnign…
  • 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…
  • How to post directly to the AR account to fix an old mistake

    It's been pointed out to me that we had a discrepancy of $200-something between our AR account and the total of our customers' outstanding invoices so I looked into the issue to find out the source of the problem. Unfortunately, I can only browse the…
  • 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?