If you find yourself reconciling monthly bank statements but the Reconciliation reports keep showing a difference, then it means you have not successfully reconciled one or more previous months.

Tags: NetSuite, NetSuite How To's, Bank Reconciliation, Bank Account, Bank Reconciliation Errors

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.  

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

Mass Update function is normally used for data updates to entity and transaction records. In addition, Mass Update can be used to send transactional emails in bulk. For instance, a simple way of sending customers overdue invoice reminders is to send it through Mass Update. You can set criteria of what invoices to send, create a standard message, and attach the invoice to the email. Here is a quick guide on how to do that.

Tags: NetSuite How To's, NetSuite Tips

As much as we try, companies still end up with multiple email accounts and data storage. There are several ways to connect or integrate all these sources so that NetSuite continues to be your system of record. One particular product is Celigo's CloudExtend Google Workspace. This is a simple SuiteApp that connects popular Google applications with NetSuite records.

Tags: NetSuite How To's, NetSuite Tips

It's easy to track who brought in a sale if there is a one sales rep to one transaction relationship. NetSuite easily accommodates for that with the sales rep field on all quote, opportunity, and sales transactions records. For many companies, it takes a whole team to close a sales opportunity; the team can consist of any combination of the sales rep, accounting person, sales operations person, or even the sales manager. Wouldn't it be great to compensate and track each person's contribution to a sale? NetSuite has a team selling feature that will do just that.

Tags: NetSuite How To's, NetSuite Tips

NetSuite is a very powerful and adaptable ERP platform.  There are some fundamental processes that NetSuite is built around, such as Order to Cash and Procure to Pay.  These fundamental processes make sure the transactions are validated, related, and traceable.  The adaptable part is the countless customizations you can make to the system to help mold and improve the system to your business needs.  As a rule of thumb and best practice, it’s best to maximize the native functionality.  If there is a need for customization, then here are some guidelines to help you decide if the customization is adding value or not.   

Tags: NetSuite How To's, NetSuite Tips

How do you know if you need intercompany transactions: Intercompany Sales Orders and Purchase Orders? Typically if you have multiple subsidiaries that provide goods and services between subsidiaries, you will need intercompany transactions in NetSuite. Many companies use spreadsheets to track the amounts to remove from financial statements so that the revenue or expenses are not double counted when multiple subsidiaries’ financial statements are consolidated. NetSuite has native functionality to help record, manage and reconcile these types of intercompany transactions automatically.

Tags: Project Management, NetSuite How To's

As a NetSuite User, Administrator or Implementor, you don’t have to be a professional accountant. However, knowing some basic concepts helps you understand how your department or function impacts the company’s financials. With some basic accounting knowledge, you can validate if the item or transaction is configured correctly, meaning is it hitting your financial statements the way that it should. For the non accountants, there are 2 accounting concepts that are helpful: a basic accounting equation that always have to balance plus the use of debits and credits.

Tags: Project Management, NetSuite How To's

How many times have you created an intercompany bill and lost track of if you created the corresponding intercompany invoice to offset? Or you are doing your audits and take forever to find the corresponding intercompany transaction?

 

Tags: Project Management, NetSuite How To's

A common headache for our Client's accounting departments month end process is expense allocations. It's often time consuming and having to remember or keep track of the allocation methodology used each time. NetSuite has an Advance Financial tool that does just that automatically.

 

Tags: Project Management, NetSuite How To's