Although the Financial Statements Rollback feature allows a selection of up to 25, most financial statement designs use balance fields that are not able to rollback and calculate prior to the first period of the prior fiscal year.

You can modify a financial statement to use prior fiscal year-end balances (Setup, Accounts, Balances). Alternatively, rather than modifying your statements, if you have a backup or archive copy of your folder, you can restore the folder and print the statements from the archive.

If you need reports for periods in the current fiscal year or prior fiscal year, you can use the solutions in the following knowledgebase articles instead:

• How do I print a trial balance for a prior period or Year?
• How do I print financial statements or a year-to-date ledger for prior periods after the first period of the prior fiscal year?

Follow the steps below to modify the default financial statements to print the fiscal year-end balances for any of your prior fiscal years:
Note: Do not use the Rollback setting with these modified designs. A rollback is automatically built into the design when you select the End Balance [number] years ago fields.

Section 1: Create a new accumulator

1. In Financial Statement Designer, from the Tools menu, select Accumulators.
2. Select Default Net Income - Accrual or Default Net Income - Cash and click Copy.
   Note: Choose the accumlator that matches your accounting method.
3. Enter an accumulator name and click OK.
4. In the Field column, select the first line and click List.
5. Select End Balance [number] years ago or CEnd Balance [number] Years ago and click OK.
6. Repeat the previous two steps for each line in the accumulator.
7. Click Save and then Close.

Section 2: Modify the default balance sheet

1. Open the default balance sheet (File, Open, BalSAccr.fsd or BalCash.fsd, Open).
2. Save the balance sheet under a different name (File, Save As).
3. Double-click the Current Balance column heading.
4. Click GL Field.
5. Select End balance [number] years ago or CEnd Balance [number] Years ago and click OK.
6. Enter a description in the Heading box. This is optional.
7. Click OK.
8. Scroll down to the Equity section of the statement and double-click Net Income.
9. Click Cell overrides.
10. In the Current column list, select End balance [number] years ago or CEnd Balance [number] Years ago.
11. Click Change field.
12. Click Accumulators and select the accumulator created above.
13. Click OK twice.
14. Click Save and then Close.
15. From the View menu, select Header.
16. Select <Period ending date>.
17. From the Edit menu, select Delete Instruction.
18. Click Yes.
19. From the View menu, select Body.
20. From the File menu, select Save.
21. From the File menu, select Close.

Section 3: Modify the default income statement

1. Open the default income statement (File, Open, IncSAccr.fsd or IncCash.fsd, Open).
2. Save the income statement under a different name (File, Save As).
3. Double-click the Current Activity column heading.
4. Click Delete and click Yes twice.
5. Click GL Field.
6. Select End Balance [number] years ago or CEnd Balance [number] Years ago and click OK.
7. Enter a description in the Heading box. This is optional.
8. Click OK.
9. From the View menu, select Header.
10. Select For the Period Ended <date>.
11. From the Edit menu, select Delete Instruction.
12. Click Yes.
13. From the View menu, select Body.
14. From the File menu, select Save.
15. From the File menu, select Close.

Section 4: Modify the default trial balance statement

1. Open the default trial balance statement (File, Open, TBalAccr.fsd or TBalCash.fsd, Open).
2. Save the trial balance statement under a different name (File, Save As).
3. Double-click the Beginning Balance column heading.
4. Click Delete and click Yes twice to remove the Beginning Balance column.
5. Click Delete and click Yes twice again to remove the Current Period Activity column.
6. Click GL Field.
7. Select End Balance [number] years ago or CEnd Balance [number] Years ago and click OK.
8. Enter a description in the Heading box. This is optional.
9. Click OK.
10. From the View menu, select Header.
11. Select <Period ending date>.
12. From the Edit menu, select Delete Instruction.
13. Click Yes.
14. From the View menu, select Body.
15. From the File menu, select Save.
16. From the File menu, select Close.

Tip: To make reporting easier you can create a Statement group to run all of the prior year statements at once. For detailed directions on creating Statement Groups, see How do I set up a statement group in Financial Statement Designer?

Sage Office Connector gives you the flexibility to run financials for prior years with the familiarity of Microsoft Excel. Breaking down the constraints of running these financials from backups. Contact our Sales team at 1-800-858-7095 or by email at [email protected] today for more information!

How do I print a YTD ledger for prior periods before the first period of the prior fiscal year?
Asterisks appear in financial statement columns
How do I use ODBC to fill in the Activity Balances and Debit Activity fields on General Ledger Accounts?
How do I copy my files to another data folder for testing or historical reporting in versions 16.1 and later?