Browse By Tags

  • Cleared cheque #1 from reconciliation thinking it was cheque #2, now need to reissue #1

    We issued a handful of sequential cheques in identical amounts in September for increases to our rent. When I did the November bank reconciliation, I mistakenly marked cheque #1 as cleared, when in fact it was #2 that had been cashed. This wouldn…
  • Account Reconciliation - Account Blank (no data showing)

    When we come to close the prior month, we are finding that certain accounts (in particular our 'Operating Account') is showing no data when we attempt to reconcile the account. We can select other accounts from the drop down and the data displays, however…
  • 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…
  • date changes for deposits in reconciliation

    since the last update, when we reconcile the bank statement, the deposits show up for different years. the amount is correct for the current year but it has a different date in the reconciliation than when it was entered. Need help how to fix this.
  • Bank Reconciliation Resolved amount

    I have a resolved amount of -$9829.88.. but no discrepancies or unresolved amounts. Is this going to cause problems down the road, what can I do? What causes this?
  • Intercompany Transaction - Check Deposited to wrong entity, need help with AR Offset

    Hello all. Not sure why this issue is giving me fits, but I desperately need transaction advice. Background: We have 2 businesses: MYC & SHO. SHO is a non-operating entity, MYC has all operations. Problem: My CEO deposited an MYC customer…
  • Visa statement overlapping two different months

    My visa statement runs from the 2nd of one month to the 3rd of the next month. Do I always enter these transactions from the first few days of the next month even though they are not my normal monthly reconciliation I use for the regular bank account…
  • Reconcile A/P Aging and A/P GL acct

    I'm tasked with reconciling the A/P aging report with the A/P GL account on the Balance Sheet. Going way back in time, the last date that it was balance was 07/2019. Does anyone have any tips on an easy way to reconcile the two totals? I've have found…
  • 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…
  • Reconciliation for Previous Year Not Closed, Transactions Show in January Statement

    Hi In attempting to reconcile January 2019, I've realized that the Reconciliation Report 'START DATE' is December 1, 2018. The only issue is that I already closed off 2018. Now, Reconciliation & Deposits shows Last month end balance, along with last…
  • Bank recs posted even though they were not correct

    FormerMember
    FormerMember
    I took over accounting from someone who clearly did not know what they were doing. I have compared the G/L bank account with the bank statements, and having gone back 3 months now, the bank account closing balance in Sage is out by a large amount each…
  • Payroll checks not showing up in the bank rec

    All the January payroll checks are missing from the bank reconciliation. Any ideas of why we see all the checks outstanding, but not the ones from payroll?
  • Bank Reconciliation warnings

    I don't understand why I am getting this warning when trying to check off a deposit.
  • First Credit Card Reconciliation

    I am doing my first ever credit card reconciliation in Sage 50 but when I clear everything it gives me an unresolved amount which is the same as my opening balance, Outstanding is 0.00. I saw a previous post that said to adjust the opening balance to…
  • Clearing with bank error and write off

    when a deposit or withdrawal is cleared with bank error or Write off, what happens to it? does it show in the GL account which is selected i bank setup for Write off?
  • 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…
  • Credit Card Reconciliation - Technical Error with Moneris

    FormerMember
    FormerMember
    Our credit card processing service had a technical error communicating with our accounting software back in February. Sage Exchange gave us an error when processing a credit card transaction and didn’t give us an approval code. I processed the transaction…
  • Bank Reconciliation for next month transactions (bi-weekly pay)

    Hi all, hoping someone can help me here. This is my first year using Sage, and my bank reconciliations have worked great until now. We switched to a bi-weekly pay schedule, with the hours to midnight Saturday being paid out on the following Friday.…
  • How do you set up a line of credit in Sage 50?

    HI everyone, I'm not an accounting Guru,so, wondering if anyone could help me when it comes to setting up a line of credit account in sage 50? Basically, what I have is: - A LOC of $XX,XXX.00 where money is automatically taken from it when there…
  • Process Bank Rec from prior year

    I started the new year before I processed the December 2016 bank recs. I can't change my session date back to December 31st so can i process the Dec Bank Rec in the January session date? The warning tells me it will affect my prior year reports and current…
  • The Security Deposit for utilities was shown wrongly in deposit in transit instead of GL

    The Security Deposit for utilities was not brought over to new fiscal year as it is $0 in the opening balance. When I check the account in the account reconciliation, the amount appears as 'deposit in transit' but it should not be the case. Please help…
  • AP GL vs AP Vendor Trial Balance vs AP Aged Payables.

    I am new to Sage and my company and just starting to dig in. I am looking at the AP general ledger and comparing it to the subledgers and they do not agree. AP GL = 3,085,390. AP Vendor trial balance = 3,087,464. AP Aged payables = 3,338,490. I would…
  • 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…
  • Credit Card (CC) Import files from Credit Card companies for Sage 500

    Hello, We are looking to restructure our Credit Card Payables process. Currently we enter a voucher to a Credit Card Vendor and pay it through the AP that way. We can continue to do that if we can get a decent transactions download that can be easily…
  • Account Reconciliation

    Can someone help me please! I use Sage 50 Premium Accounting CA and I am doing my Account Reconciliation for the first time. My opening balance and end balance are correct. Here is my problem... My opening balance matches my unresolved $20,892.26 but…