How do I determine which transactions are prior year adjustments for all accounts in General Ledger?
Description
Did you know Sage has a solution that can notify you when there are Prior Year Adjustments to close in General Ledger? Sage MyAssistant can automatically notify you when Prior Year Adjustments are available to close. Reducing the amount of verification and time needed by your staff to rectify this information. Contact our CRE Sales Team at 1-800-858-7095 or email at [email protected] for more information.
Cause
Resolution

Determine when the fiscal year was last closed:

  1. In General Ledger, from the Inquiry menu, select Entries.
  2. Select History and click OK.
  3. Click Select.
  4. Select Add column after this column and click OK.
  5. Select Date Stamp and click OK.
  6. Click Select.
  7. Select Add column after this column and click OK.
  8. Select Time Stamp and click OK.
  9. Click Conditions.
  10. In the Field section, select Source.
  11. In the Operator section, select Equal to.
  12. In the Value section, select Close fiscal year and click OK.
  13. Click Add.
  14. In the Field section, select Accounting Date.
  15. In the Operator section, select Equal to.
  16. In the Value section, type the date of your last fiscal year-end.
  17. Click OK twice.
  18. Make a note of the Date Stamp and Time Stamp for the transaction that remains. The Date Stamp and Time Stamp for the transaction that remains indicates the actual date and time that you used the Close Fiscal Year task to close your previous year. Click Close.

Print the General Ledger Entries by Batch report to see all prior year adjusting entries made after you closed your fiscal year:

Note:You can apply the same conditions listed below to Entries By Account or to the Entries Inquiry.

  1. From the Reports menu, select Entries, Entries by Batch.
  2. Select Current and then click OK.
  3. Click Conditions.
  4. In the Field section, select Accounting Date.
  5. In the Operator section, select Less or equal to.
  6. In the Value section, type the date of your last fiscal year-end. This is the same date you used in step 1.16 (above).
  7. Click OK.
  8. Click Add.
  9. In the Field section, select Date Stamp.
  10. In the Operator section, select Greater than.
  11. In the Value section, type the date you previously used the Close Fiscal Year task. This is the date you noted in step 2 (above).
  12. Click OK.
  13. Click Add.
  14. In the Field section, select Time Stamp.
  15. In the Operator section, select Greater than.
  16. In the Value section, type the time that you previously used the Close Fiscal Year task. This is the time you noted in step 2 (above).
  17. Click OK twice.
  18. Click Print Preview to review the report, or click Start to print the report to a file or printer.

If these are valid prior year adjustments, refer to article  How do I close prior year adjustments to retained earnings?"


Steps to duplicate
Related Solutions

How do I close prior year adjustments to retained earnings?