How to Create a Balance Sheet in Management Reporter Without Closing Out the Year in GP

When you get to a new year in GP and have not yet closed your fiscal year, you will need to make some modifications to your column on your management reporter to run a balance sheet.  When you close your fiscal year in GP, this is the process that rolls the beginning balance forward for the new year.  If you have started your new year and have not yet closed the fiscal year, it is still possible to run a balance sheet with the beginning balance.  You will need to make modifications to your column on your balance sheet report.

First you want to open your column that you currently use for the balance sheet and do a file save and rename the column.

You are going to want to add no print columns where you get the prior year ending balance.

Next, leave your original column for YTD current year alone and make it a NP column.

Add a third column as a calculated column and add column B and C together to get the current year balance.

Once you have this column, you can select it on your report definition and your balance sheet will show a true balance for the year-to-date on your balance sheet accounts.

With the logic built into the column, you can swap this column into your report each year.


Colleen graduated with a Bachelors of Science Degree in Accounting from California State University San Bernardino. She has extensive accounting experience over the past years working as staff accounting and controller. Colleen has over 10 years Great Plains experience which includes many implementations for private companies. She also has extensive experience with Business Intelligence, budgeting and report writing while working on BI360, QuickBooks, Oracle, PeopleSoft, Timberline and Solomon. Colleen has worked in various industries that include: real estate, property management, timeshare sales, publishing and insurance. These various industries have given her the necessary experience to handle large company consolidations and report writing, budgeting and forecasting, project accounting, sales invoice processing, and fixed assets.

Share this post

Related Posts

Checking Your CMMC Progress

Written by Alec Toloczko With Cybersecurity Maturity Model Certification (CMMC) requirements on the horizon, it’s crucial for organizations handling Controlled Unclassified Information (CUI) to adhere

Read More »