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.

Parents
  • +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)

Reply
  • +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)

Children