• AR and Unpaid Customer Invoice amounts don't balance, and I can't start my new year!

    I can't start my new year because they don't balance! I don't know where to look, or how to add in a temp fix so I can move forward. I have an accounting firm go through my books at the end of every year, and I generally just make the changes and additions…
  • Sage 50 CA Premium -- error in how Sage 50 calculates balances re home currency vs foreign (USD) currency?

    We have a USD account for Paypal. We enter the relevant date and exchange rate in the list used for that purpose (under Settings / Company / Currency). For example, at 30 Dec 2016, the Bank of Canada rate is C$1.3427 = USD$1.00, and in the FX list, we…
  • Exchange gain/loss - revenue vs expense and GST/HST filing "sales and other revenue" line 101

    Should we actually be using 2 different accounts for exchange gain vs exchange loss? It doesn't matter for the bottom line, net income will end up the same either way: Hmm... seems you can only configure one for the program to use automatically for adjustments…
  • How do you manually zero out or adjust CAD balance in USD account ?

    Similar too this post - it seems Sage does an automatic transaction if it finds a 0 balance at year end because it is quite obvious that if an account has $0 US funds in it, it must equate to $0 CA funds... https://sagecity.na.sage.com/support_communities…
  • How do I correct a wrongfully posted exchange rate?

    I have an issue with a previously filed tax year where the US exchange rate was posted extremely wrong ($537.61USD = $3016.97CAD). Since it was not corrected when the filing was done, how do I now correct it? I am assuming I need to make an adjustment…
  • cheque replacement

    Hi, I paid 2 invoices with 1 cheque. One of the invoices on the cheque was cancelled by the vendor and the vendor returned my cheque to me. I reversed both invoices by creating negative invoices with the same invoice number/ same info/same accounts…
  • write off receivables in Sage 50 CA

    Help, Here is our situation: An old sale invoice became uncollectable, our accountant made a year end adjusting journal: 1xxx: Allowance for doubtful accts: CR 10,000; 5xxx: Bad Debt Expense DR: 10,000; But, this invoice is still in our system…
  • Multi Year Data Input and Adjustments

    Hi, Situation : My client recently lost all access to their old accounting software (the only access they have is to their data is via excel reports). It is my job to import their trial balance from 2008FY to 2015FY into Sage 50 2016 CA. My next step…
  • old items in bank reconciliation

    I have 3 items appearing in my bank reconciliation from 2013 that I would like to remove. 1 is an item that was entered as an expense paid by cash from the chequing account but it was actually paid by cash from an employees personal account. The other…
  • Adjusting Entries in General Journal that relate to A/P and A/R from Prior Year

    FormerMember
    FormerMember
    I need to enter year end adjusting entries from 2014 YE before I do my 2015 YE. When my accountant gave me the 2013 adjusting entries, I guess some were not made. So the 2014 adjusting entries contain some that are "to record prior year JE#..." The…
  • YR END Closing Owners Drawings?

    Hi All, I am a bookkeeper for a sole proprietorship. When I took over last year I was basically left to figure everything out on my own and told to go off what had already been taking place. The business has never closed out Drawings at year end. I…
  • Year End ADJ Entries to Accounts Receivable / Meals ???

    Hi, I am entering the Year End Adjusting Entries from the Accountant. I am almost done. I have one problem left though. My A/R is out by $0.09 interestingly, so is my Meals Expense account. If I could Dr. the A/R and Cr. the Meals everything should…
  • RE: First time doing Y/E adjusting entries by myself and I'm scared to mess up my linked account entries.. can someone refresh my memory so I do it correctly?

    for the vacation payable the accountant just gave me this answer: "I don’t have much experience with linked accounts, but it looks like you would need to adjust each employee’s records in Simply to the balance in the vacation tracker as at April 30…
  • RE: First time doing Y/E adjusting entries by myself and I'm scared to mess up my linked account entries.. can someone refresh my memory so I do it correctly?

    I got an answer from my accountant...: "This entry was primarily for classification purposes for the financial statements, since we have to classify all principal repayments in the next 12 months as a current portion of long-term debt. It’s not totally…
  • Issue posting a journal entry

    I am trying to record dividends for fiscal year end. In doing so, I tried to post against a G/L account 3600 'Current Earnings' which is already created and active, it is on the chart of accounts but, not listed for posting? Each time I try to post the…
  • Data Integrity Error

    Hello, I'm attempting to do my first year - end and I'm coming across an issue with the data integrity check. I am showing that my advances / loans recieved and vacation pay balance do not match with the advances / loans paid and vacation pay owed…
  • Year-End adjusting entries to Accounts Payable

    Hello, I know this is an old topic, but just wondering if someone could give some advises. I'm using Premium 2011, and the year end entries I got from the accountant is : Cr. 2100 Accounts Payable xxxxx, Dr. Retained Earnings -Previous year xxxx Simply…
  • 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…
  • bank balance

    How do I reset my bank balance. The acoount has never been reconciled and I have an outrageous amount as a bank balance. I want to enter my bank balnce on my new statement date ..can you help ??
  • 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…