<img src="https://ws.zoominfo.com/pixel/5BFMW73xT6Cu70sN1cUt" width="1" height="1" style="display: none;">

Creating a Month-By-Month Balance Sheet for Last 3 Periods

Posted by Justin Myung, Consultant on Sep 20, 2022 9:00:00 AM
Justin Myung, Consultant
Find me on:
pexels-olia-danilevich-5466812

You want to review month over month movement of your Balance Sheet.  You will notice in order to see a month-by-month trend, you can add the Accounting Period on the columns, but it shows all the historical periods.  Are there times you would like a quick view of the Balance Sheet for recent periods.  Your options could be running it for all periods and deleting the columns you don’t need in excel or manually set the periods using custom periods.  The process below will help you run a dynamic balance sheet by month for the last 3 periods by changing the date on the Reports Page without having to go back to the customization page.  

 

Let’s get started. 

  1. Navigate to Reports > Financial > Balance Sheet > Customize Summary 
  2. Click on Edit Columns on the Financial Report Builder Menu 
  3. On the Add Fields Section under the Financial drop down, select Amount twice 

 


4. You should now have 3 columns of Amount

 

 

5. On the last Amount (furthest right) field. Rename the Column Label to Current 

Graphical user interface, application

Description automatically generated

 

6. On the second Amount (Middle) field. 

      1. Rename the Column Label to Prior Month  
      2. Change the Alternate Period Range Type to Relative to report date  
      3. On the Alternate Period Range, select Last Period 

 

Graphical user interface, application

Description automatically generated

7. On the first Amount (left) field 

      1. Rename the Column Label to Period Before Prior  
      2. Change the Alternate Period Range Type to Relative to report date  
      3. On the Alternate Period Range, select Period Before Last 

 

Graphical user interface, application

Description automatically generated

8. Click Save 

9. Now you can run this report and change the Period on this page as needed.    

      1. If you want to make this report a little more dynamic, you can select the END OF filter to Last Period or This Period.

 

Graphical user interface, text, application, email

Description automatically generated

  1.  

If you need any help with customizing reports and saved searches in NetSuite, feel free to contact Concentrus.  Our consultants would be happy to guide you through the process. 

 

 

About Us

 

Concentrus is a complete NetSuite solutions provider that guides organizations through how to use NetSuite to reach highly focused business goals and objectives. We provide NetSuite implementation, developer, integration, and customization services to ensure that you have a long-term solution that is tailored to fit your systems, people, and processes.

 

Read About Our Implementation Methodology

 

Want more NetSuite Tips and Tricks? Check out our Short & 'Suite videos

 

 

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Trend, Balance Sheet, Statement

Subscribe to our blog!

Recent Posts

Posts by Topic

see all

Request a quote