Suggestions on how to separate Year end aje's? We do not have a 13th period, and I'm not sure we can add one.

As the title says, we'd like to separate our year end aje's.  We'd like to have an unadjusted trial balance, aje's, then the final trial balance.    Sage was not setup with a period 13, and I'm not sure if that can be added at this point.

Our Sage guru suggested using a source code named AJ.  However, this requires quite a bit of work to get our financials the way we want to show pre-aje and post-aje.

Any suggestions about the best way do do this?

Thanks.

  • 0

    Can you export the trial balance before you make the journal entries, then export again once you have made them?

  • 0 in reply to Sage100User

    That is an option.  We'd like to keep track of the AJE's in some way though.   We can make the descriptions as specific as possible, and use a search.   I'd just hoped there was a more apparent way, or an easier way. 

  • +2
    verified answer

    You can add a 13th period to your fiscal year in GL>Setup>Fiscal Year Maintenance, by increasing the number of fiscal periods to 13 and then changing the ending date for Period 12 to be one day less than the fiscal year end and then Period 13 would be only one day.

    For example, if your current year ending date is 12/31/2020 you would do the following:

    1. Change the number of accounting periods to 13
    2. For Period 12, change the ending date to 12/30/2020 (12/1/2020 - 12/30/2020)
    3. For Period 13, change the ending date to 12/31/2020 (12/31/2020 - 12/31/2020) 

    This way you could run pre-aje financials as of 12/30 and then run post-aje financials as of 12/31.

    In order to easily identify these entries, I would suggest creating a Source Journal code specifically for Year-End Adjusting Entries, (i.e. YE -Year-end).  Note: 'AJ ' is the source journal code defined in the system for Allocation Journals.

    Always remember to make a back-up before making changes to fiscal years or test in a copy company first.

    Changing fiscal periods may affect other modules, i.e. Inventory, Sales Order, A/R, A/P, please review Sage 100 Help or KB How fiscal period changes in General Ledger affect other modules in Sage 100 (to be sure to review the articles linked in the Related Resources section as well)

  • 0 in reply to Gina Weathersby

    Thank you!  I didn't realize AJ was a source code since we never use allocation entry.  I'll use YE instead.  Since most of our journal entries this year were made 12/31, I won't be able to use this method this year.  Now that I am aware of creating period 13, it will be an option in future years.

  • 0

    L Energy - I have been asking the same question for 4 months now - so glad you asked it here!  Gina - THANK YOU - this is the answer I needed! It is too late for my 2019 eoy but I am ready to rock & roll for 2020!! THANK YOU!!!