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

How to Resolve Period and Date Mismatches

Posted by Mariella Marquez, Consultant on Jul 12, 2022 1:30:00 PM
Find me on:

pexels-rodnae-productions-7821675

Have you ever noticed that your Balanced Sheet and Income Statement have different month end balances?

The primary source of confusion is that Income Statements and Balance Sheets can be ran by Date or by Period, if you are not reporting on the same date range you are likely to see variances. The other issue can be that you have Period and Date mismatches. This will only happen is you have the Accounting Preferences to warn or allow dates outside of the designated periods. Below I will show you how to build the saved search to identify and resolve the mismatches.

1. Navigate to Reports > New Search
2. Select Transaction
3. Click Create Saved Search
4. Add a Search Title – Resolve Period and Date Mismatch


Picture1-Jul-12-2022-07-29-35-96-PM

5. Under Criteria Filters:

  1. Add Main Line is true
  2. Add Period is This Period
  3. Add Date is Before end of last month

Picture2-3

Picture3-1

6. Under Results Fields:
  1. Add Order Type
  2. Add Date
  3. Add Period
  4. Add Type
  5. Add Document Number
  6. Add Name
  7. Add Memo
  8. Add Amount

Picture4-1

7. Click Save & Run on the top left corner.

 

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, Accounting, Accounting Periods, Saved Search, Transactions, Date Mismatch

Subscribe to our blog!

Recent Posts

Posts by Topic

see all

Request a quote