Hi Eva,

When you are in the Financial Reporter, from the View menu, pick Account Data. This is the place that lists all of the available Field Codes and what amounts will be reported on.

If you look in the section 'Account Balance as of', you will find:
BAL_Y is the 'Opening Balance This Year'
BAL is the 'Bal. Ending Selected Period'

So it would seem to be an easy fix.
- If you are using a SmartSheet, Collapse it.
- Highlight the column with this formula
- From the Edit menu, pick Replace. Replace .BAL_Y with .BAL

Now you should see the ending balance in your selected fiscal period, rather than the opening balance.