[BCB:5:Third-party support:ECB] Modify the default financial statements to print the fiscal year-end balances Note: Don’t use the Rollback setting with these modified designs. When you select the End Balance [number] years ago fields, it builds in a rollback function. Create a new accumulator - In Financial Statement Designer, from the Tools menu, select Accumulators.
- Select Default Net Income - Accrual or Default Net Income - Cash and click Copy.
Note: Choose the accumulator that matches your accounting method. - Enter an accumulator name and click OK.
- In the Field column, select the first line and click List.
- Select End Balance [number] years ago or CEnd Balance [number] Years ago and click OK.
- Repeat the previous two steps for each line in the accumulator.
- Click Save and then Close.
Modify the default balance sheet - Open the default balance sheet (File, Open, BalSAccr.fsd or BalCash.fsd, Open).
- Save the balance sheet under a different name (File, Save As).
- Double-click the Current Balance column heading.
- Click GL Field.
- Select End balance [number] years ago or CEnd Balance [number] Years ago and click OK.
- Enter a description in the Heading box. This is optional.
- Click OK.
- Scroll down to the Equity section of the statement and double-click Net Income.
- Click Cell overrides.
- In the Current column list, select End balance [number] years ago or CEnd Balance [number] Years ago.
- Click Change field.
- Click Accumulators and select the accumulator created above.
- Click OK twice.
- Click Save and then Close.
- From the View menu, select Header.
- Select <Period ending date>.
- From the Edit menu, select Delete Instruction.
- Click Yes.
- From the View menu, select Body.
- From the File menu, select Save.
- From the File menu, select Close.
Modify the default income statement - Open the default income statement (File, Open, IncSAccr.fsd or IncCash.fsd, Open).
- Save the income statement under a different name (File, Save As).
- Double-click the Current Activity column heading.
- Click Delete and click Yes twice.
- Click GL Field.
- Select End Balance [number] years ago or CEnd Balance [number] Years ago and click OK.
- Enter a description in the Heading box. This is optional.
- Click OK.
- From the View menu, select Header.
- Select For the Period Ended <date>.
- From the Edit menu, select Delete Instruction.
- Click Yes.
- From the View menu, select Body.
- From the File menu, select Save.
- From the File menu, select Close.
Modify the default trial balance statement - Open the default trial balance statement (File, Open, TBalAccr.fsd or TBalCash.fsd, Open).
- Save the trial balance statement under a different name (File, Save As).
- Double-click the Beginning Balance column heading.
- Click Delete and click Yes twice to remove the Beginning Balance column.
- Click Delete and click Yes twice again to remove the Current Period Activity column.
- Click GL Field.
- Select End Balance [number] years ago or CEnd Balance [number] Years ago and click OK.
- Enter a description in the Heading box. This is optional.
- Click OK.
- From the View menu, select Header.
- Select <Period ending date>.
- From the Edit menu, select Delete Instruction.
- Click Yes.
- From the View menu, select Body.
- From the File menu, select Save.
- From the File menu, select Close.
Tip: To make reporting easier, you can create a Statement group to run all prior year statements at once. See detailed directions on creating Statement Groups. |