Statement end date vs year end date

SOLVED

Hi -- I'm very new to Sage 50 premium. My December reconciliation is all correct, but Sage won't accept a statement end date later than December 31, 2021 (the bank statement is Dec17 to Jan 19), so I can't process the reconciliation. I've gone through forum questions, but I'm still stumped as to how to address this.

Thanks!

  • 0

    Is there any error message?  These can be helpful.

    What version are you using?

    If you are using a pre-2018 version do you display 2 or 4 digit years?  If 2, then change it to 4 (Setup, Settings, Company, Date Format) and enter the full year.

    Have you moved the session date to the new calendar year yet?

  • 0 in reply to Richard S. Ridings

    I'm using 2021. The error message reads: "Invalid date. The statement end date must be between 12/18/2021 and 12/31/2021." I have transactions on the statement from Dec 22 to Jan 10. I haven't moved the session date to the new calendar year yet, as I wasn't sure if I would lose any data in doing so. But I wondered if that's what I need to do.

  • 0 in reply to Thomas Knutson

    It's my guess then that you need to start the New Calendar Year.  Take a backup of the file from the File, Backup menu so you can restore it if something does go wrong.

    Then select Maintenance, Start New Year and follow the prompts to start a new Calendar Year.  I assume your fiscal year is not Jan-Dec and that those entries to Jan 10 are also currently in your books.  Please be sure you do not start a new Fiscal Year in this case.

    This process does have an effect on the Payroll module because it resets T4 information to zero for 2022 and archives 2021 into a previous year so you can print your T4's later (if applicable).

  • 0 in reply to Richard S. Ridings

    Our fiscal year is Jan-Dec -- should I have not entered the Jan transactions in that case?

  • 0 in reply to Thomas Knutson
    SUGGESTED

    Based on your fiscal year, I can only assume the entries you posted in January are either General Journal entries or Payroll.

    What I believe is happening at this point is that you have stopped moving your session date forward on Dec 31 because you are trying to clean up and complete your year end.  This is not necessary.  As long as you have posted Dec 31/20 year end adjusting entries, you can move forward and start a new Fiscal Year any time.

    The program allows you to post into three fiscal years, Next Year (only in Payroll and General Journal and I believe only in Premium and Higher but I haven't tested in years), Current Year and Last Year.  You can continue moving forward and doing day to day bookkeeping while continuing to complete your year end entries to get the books to your accountant for tax preparation.

    Once you send your books to your accountant, I recommend highly that you go to Setup, Settings, Company, System and do not allow any entries prior to Jan 1/22.

    Because the program does not allow posting any future year entry in any module other than the General Journal and Payroll, the program will stop you from doing a bank bank rec unless you start a new calendar and fiscal year.  Same instructions as above.

    Take a backup of the file from the File, Backup menu so you can restore it if something does go wrong.

    Then select Maintenance, Start New Year

  • +1 in reply to Richard S. Ridings
    verified answer

    That did the trick. Many thanks -- I really appreciate your help!

  • 0 in reply to Thomas Knutson

    Hi Thomas, if the above suggested answer helped, please do mark it as verified White check mark for the benefit of others in this forum :). Thank you!

     If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey