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

Removing Journal Entries in A/P Aging Detail Report

Posted by Mariella Marquez, Consultant on Jan 26, 2023 12:14:27 PM

With the new year beginning and accounting teams working busily to close the prior year financials one of the biggest errors we see is offsetting journal entries stuck on your A/P Aging report. If you are posting offsetting journals that post to your Accounts Payable transaction without first adding an “A/P Clearing Vendor” you might be asking how to clean up your reporting. Below we will walk you step by step on how to clear up your A/P Aging and remove these transactions entirely. 

Read More

Tags: NetSuite, ERP, Reporting, NetSuite How To's, Accounting, Financial, General Ledger, GL, Accounting Periods, Transactions, Journal Entry, Transaction Lines, Financial Report, Accounts Payable, AP Aging

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

How to Set Up Vendor Prepayments

Posted by Sara Duong, Consultant on Sep 13, 2022 9:21:44 AM

What are Vendor Prepayments? When Vendor requests a deposit or payment before a Purchase Order is approved or before a Vendor Bill is issued, you can record this payment as a Vendor Prepayment in NetSuite.  

Read More

Tags: NetSuite, NetSuite How To's, Accounting, NetSuite Tips, Financial, Transactions, Vendor, Vendor Payments, Bills, Bill Payment

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

Best Practice for Reclassing General Ledger Account Segmentation

Posted by Sara Duong, Consultant on Sep 1, 2022 12:13:44 PM

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.  

Read More

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

How to Add a Field and Custom Segment to Fixed Asset Record

Posted by Sara Duong, Consultant on Jun 30, 2022 1:55:32 PM

So you are getting ready to implement the Fixed Asset Management (FAM) module in NetSuite. After configurations and set up, you are ready to load your assets. Looking at the Asset Record, you realize there are some additional fields you want to add or some existing fields you want to move around. Below is a quick How To on customizing the Asset Record entry form to best suit your company’s needs.

Read More

Tags: NetSuite, NetSuite How To's, Accounting, NetSuite Tips, Financial, Customize, FAM, Fixed Asset, Asset Record

How to Upload InterCo Open Balances

Posted by Sara Duong, Consultant on Jun 20, 2022 8:53:07 AM

Congratulations! You are ready to go live with NetSuite! Before you start entering live transactions, the Opening Balance Sheet needs to be entered; this is your starting balance for your financial statements. Normally, this is a simple Journal Entry upload of your last closed period’s Balance Sheet. However, if you have Intercompany Accounts with balances, then a simple one step Journal Entry will not be enough. Intercompany Accounts require additional set up and separate Journal Entries for each customer or vendor.

Read More

Tags: NetSuite, NetSuite How To's, Accounting, NetSuite Tips, Financial, Intercompany Accounts, Go Live, Open Balance Upload, Open Transaction Upload

Change in JP Morgan Chase Connections for U.S. Bank Feeds in NetSuite

Posted by Kevin Suh, NetSuite Administrator on May 4, 2022 2:27:54 PM

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.

Read More

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

Write Off Bad Debt

Posted by Mariella Marquez, Consultant on Apr 25, 2022 11:08:46 AM

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.

Read More

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

Is it possible to redesign your Chart of Accounts after go live?

Posted by Sara Duong, Consultant on Feb 2, 2022 4:44:13 PM

In a previous blog we explored Netsuite Purchase Request vs. Purchase Requisition.  In this blog we’ll explore the complexity of chart of accounts redesign. We provide some tips and learnings from a previous chart of accounts redesign project.  

Read More

Tags: NetSuite, Accounting, Segmentation, Financial, COA, General Ledger, Chart of Accounts, GL

Subscribe to our blog!

Recent Posts

Posts by Topic

see all