SAGE 50 - How to bring forward accounts receivable after starting a new company/package?

Hello,

I am hoping you can help me with an issue I am having.

In Jan 2022, I started using a new Sage program. I did not carry over all the previous balances, AR, AP, etc...from 2021. This is causing issues with account reconciliation of my bank statements.

I have $17,000 outstanding to bring forward to 2022 however I cannot enter it as "sales" since I have already paid my HST/GST and claimed in as income for the 2021 tax season.

So, if a customer purchased something in December 2021 but didn't pay until Jan 2022, then I have already claimed that in my 2021 tax season so I cannot put it as another "sale" in 2022 since it wouldn't work out correctly. But I do need to show it was paid to my bank account so I don't know how to set up the general journal to show that.

  • 0

    you need to carryover balances for your new year.  If payments made on these receivables or payables you have to record them.  Your TB and that of that accountant will not match at this fiscal y/e.  These must match otherwise you are out of CRA compliance. 

  • 0

    In your new Sage data file, when you set up the bank reconciliation you are given the opportunity to add deposits and withdrawals from prior periods. This does not affect your sales or expenses. You will need a complete list of all items not previously reconciled.

    More specifically, from your December 2021 bank reconciliation you will need the report showing outstanding transactions. Using this information when you start to setup reconciliations in the new 2022 data you will click on the box to Add Prior Outstanding... This appears near the bottom of the first window after entering the bank account to be reconciled. It only appears on the window for a first time reconciliation set up. If this is not done you will probably have a discrepancy which should be Zero. Any other amount highlights a concern which needs to be corrected.

    If this was not done I would suggest starting over with the January 2022 reconciliation set up.