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.  

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

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. 

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

What is Segmentation in Netsuite? Segmentation or classification are ways to categorize entity (Vendor, Customer, Item) records and transactions amounts in NetSuite.  For instance, you may want to see your Income Statement separated out by Location; Location will be a classification field on your transactions.  There is native reporting function that will automatically break up your Financial Statements in segmentations.  

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Segmentation, Financial, Transactions, Classification, Income Statement, Journal Entry, Trial Balances, Reclass

You might have received a notice last month regarding the news that JP Morgan Chase (JPMC) is moving away from Screen Scraping technology and will no longer support connections to their credential-based sites. Per notification, this change is part of JPMC’s transition to Open Banking technology which aims to improve security and ensure smooth bank feeds connection. If you are using the NetSuite Bank Feeds SuiteApp which may be importing data from the JP Morgan Chase & Co. (JPMC) financial institution, you might have encountered the bank data import errors on or after April 21, 2022.

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Financial, Bank Reconciliation, Bank Account, data, Excel, Bank Statements

Have you noticed small increments of one or two pennies in your A/R Aging report? Do you have some bad debt that you need to write off your books due to unresponsive clients? The following process will walk you through how to enter a Journal and process the customer payment to remove these from your Accounts Receivable reporting.

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Financial

Have you ever found yourself scrolling page after page after page to find the one transaction record you know is in Related Record or under the customer sales tab? You might benefit from adding filters to your view to easily reduce the transactions that populate and really dig into the data you’re searching for.

 

Tags: NetSuite, Reporting, NetSuite How To's, NetSuite Tips

Are you in need of identifying consumer buying patterns and want to quickly view which product is over or under performing? Merchandise Hierarchy helps achieve this plus provides a quick view of your products while allowing for category changes during different time periods. This can be a great tool if you are continuously launching new limited release collections or have multiple seasonal offerings.

Tags: NetSuite, Reporting, NetSuite How To's, Inventory Management, Product Review

Many retailers start their business with a combination of a basic accounting system, inventory management system, and multiple spreadsheets. But as they grow larger, the amount of time and effort it takes to handle a higher volume of orders becomes difficult to handle and prone to human errors.

Tags: Reporting, Inventory Management, eCommerce, Retail

COVID-19 has impacted everyone in the United States personally, professionally, and/or financially. Startups, especially newer retailers, have been hit hard because they do not always have the cash flow, processes and systems in place to handle this drastic of a change.  

Tags: Reporting, Customer Service, Inventory Management, eCommerce, Warehouse Management System (WMS)

CFO’S, Controllers and managers have a lot on their plate.  Managing a business is a challenge on its own.   Imagine running a business without data or information that helps provide a basis for change.  Not having a solid financial reporting structure in your business will prevent you from making the necessary changes, or in some cases, from preventing significant losses.  The same can be said with too much data or “information overload” when that information is not meaningful to your business. 

Tags: NetSuite, Reporting, NetSuite How To's