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

Justin Myung, Consultant

Justin Myung, Consultant
Find me on:

Recent Posts

Create an EBITDA Income Statement Layout

Posted by Justin Myung, Consultant on Dec 6, 2022 10:34:06 AM

In a continuing series of customizing your Income Statement Layout, I wanted to show you how you can get a Statement with EBITDA calculated after Net Income.  First, please review my previous blog here (or https://blog.concentrus.com/create-a-new-income-statement-layout).  

Read More

Tags: NetSuite, NetSuite How To's, NetSuite Tips, Income Statement, Financial Report, Layout, Customization, EBITDA

Create a New Income Statement Layout

Posted by Justin Myung, Consultant on Nov 22, 2022 1:50:46 PM

Is your Income Statement in need of a face lift?  If you are not able to over-haul your Chart of Accounts, you can update your Income Statement Layout directly in NetSuite.  I will walk you through some steps that will consolidate the GL accounts on your Income Statement.  From this walk through, you should have enough information for you to customize your own report.

Read More

Tags: NetSuite, NetSuite How To's, NetSuite Tips, Financial, Income Statement, Financial Report, Layout, Customization

CASE STATEMENT use case – Intercompany Reconciliation

Posted by Justin Myung, Consultant on Oct 27, 2022 10:40:39 AM

Have you ever wanted or needed a quick comparative view of your Intercompany transactions between your subsidiaries?  One way to achieve this is through the use of CASE Statements in Saved Searches.  What is a CASE Statement?  A CASE Statement is similar to that of an if-then-else statement.  You may have encountered this in spreadsheetsIn NetSuite, it’s an available function that allows you to program conditions to return values when those conditions are met.  So, when a condition is true, NetSuite will provide the results based on those conditions.  You can have multiple conditions in one CASE Statement.

Read More

Tags: NetSuite, Reporting, NetSuite How To's, NetSuite Tips, Saved Search, Reconciliation, CASE, Formula, If-Then

Date/Period Mismatch – Life-to-Date

Posted by Justin Myung, Consultant on Oct 6, 2022 9:45:05 AM

There are many reasons why a company may want to have dates and periods not match-up.  One common reason may be related to the month-end close processA company may want to enter the actual date (which is in a prior period) of a vendor bill, but since the previous period has already been closed, they will post to the current period for financial purposes.  NetSuite can allowtransaction dates outside of the posting periods through the company’s Accounting Preferences.  This can increase the risk of unwanted date/period mismatches as well as cause headaches for reconciliations between AR/AP Aging reports to the Balance Sheet.  One way to monitor this is through a Saved Search. 

Read More

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Accounting Periods, Saved Search, Transactions, Date Mismatch

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

Posted by Justin Myung, Consultant on Sep 20, 2022 9:00:00 AM

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.  

Read More

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

Get an Undeposited Funds as of Date Report

Posted by Justin Myung, Consultant on Sep 6, 2022 10:59:29 AM

Have you ever wondered if there was an easier way to get a detail report of Undeposited Funds for a previous Date?  If you have a lot of transactions that flow in and out of this account, it can be a daunting task if you don’t reconcile this right after month-end close or even if there happened to be back-dated transactions after you month-end bank reconciliation.   The following search will help you download a saved search report to solve that issue. 

Read More

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Financial, Bank Reconciliation, Bank Account, Saved Search, Transactions, Undeposited Funds

Content not found

Subscribe to our blog!

Recent Posts

Posts by Topic

see all