Accounting Services
Icon-14-2
Outsourced Accounting

Expertly trained accountants with a deep understanding of the software and your industry,

Icon-15-1
Family Office Accounting

High-touch technology family office accounting services that ensure security and privacy.

Icon-16-1
Bill Pay

Outsourced bill pay solution with cash flow reporting and tracked expenses.

RESOURCE CENTER
What Are Outsourced Accounting Services and Do I Need Them?

If you are asking yourself these two questions, you've come to the right place.

What’s the Difference Between CFO and a Controller - and What Do I Need?

Although these two important roles are sometimes viewed as interchangeable there are important differences between them.

Industry Expertise
Icon-17-1
Our Key Industries

Expert knowledge and high-quality software solutions for our 5 key industries.

Icon-18-1
Construction & Real Estate

Real-time financial data and integrated job costing to generate reports and improve accountability.

Icon-19
Manufacturing & Distribution

Track billing of materials, implement inventory control systems, manage supplier base, and reduce unnecessary costs.

Icon-20
E-Commerce

Our team has the expertise needed to navigate deposits, refunds, chargebacks, and processing fees to maximize efficiency.

Icon-21
Professional Services

Streamline financial operation and increase overall profitability to enable faster and smarter decisions.

Icon-15-1
Family Office Accounting

High-touch technology family office accounting services that ensure security and privacy.

RESOURCE CENTER
Why does industry expertise matter?

Industry focus allows us to be experts in the accounting needs of the companies that operate within these industries.

Why Plumb Works With These Industries

This is another one of our favorite questions. The answer is easy: we know these industries.

Software Expertise
Icon-22
Sage Software

Innovative software to manage your accounting, people, payroll, payments, and more.

Icon-23
NetSuite Software

Integrated cloud business software suite, including business accounting, ERP, CRM and ecommerce software.

Icon-24
QuickBooks Software

Scalable solutions for reporting, transactions, month-end close, analysis, and more.

RESOURCE CENTER
QuickBooks to NetSuite Migration: A Comprehensive Guide

Migrating from one accounting software platform to another is a critical undertaking for businesses. This is especially true when considering a transition from QuickBooks to NetSuite.

How do I know which Software is right for my company?

Selecting the "right" software for your company might seem like an overwhelming task, but we'd like to help make this process easier for you.

Sage
Icon-262
Sage Software

Innovative software to manage your accounting, people, payroll, payments, and more.

Icon-26
Sage Intacct

Automate the critical processes, reduce the spreadsheet headaches, and get greater visibility into real-time business performance.

Icon-27
Sage 300 CRE

Sage 300 Construction & Real Estate connects finances and operations to help ensure maximum profit.

Icon-28
Sage 100 Contractor

The all-in-one construction software that goes beyond basic accounting to put you in total command of your projects.

Icon-29
Sage Estimating

Build bids quickly and precisely, plus integrate with other Sage software solutions to streamline operations.

Plumb_Icon-119
Sage Paperless

Easily store, retrieve, and route documents for accounting and operations.

Icon-30
Sage Service

Streamline service calls and construction projects from start to finish with web-based real-time information.

Icon-31
Additional Solutions

Add-on these services to improve workflow and enhance data and analytics.

RESOURCE CENTER
How and When to Choose Construction Accounting Software?

The right tools can help you manage your construction projects efficiently, provide clarity of your finances, and ultimately help improve profitability and job success.

5 Types of Visibility Every Construction Firm Should Have.

Here we list 5 key elements to help capture insights that are pivotal to running an efficient and lucrative constriction firm.

ABOUT
Icon-32-1
About Plumb

Plumb seeks to empower business owners and leaders to gain clarity about their financials to grow their business.

Icon-33-1
Case Studies

Learn more about our work with clients in a variety of different industries.

Icon-34-1
Meet the Team

Learn more about the Plumb leadership team.

Icon-35-1
The Plumb Promise

Icon-36-1
Careers

Want to join us? Check out our current open positions and apply today.

RESOURCE CENTER
What can Plumb Do for Your Business?

At Plumb we pride ourselves on providing "clarity in accounting and stewardship in service." But what does that actually mean?

What's the Plumb Promise and What's in it for You?

We're on a continuous journey to go above and beyond for our clients. Here's how we do that.

How to close year end books in Netsuite

Posted on February 3, 2022 at 8:23 PM
Written by Justin Atneyel

 

When closing the books for month-end and year-end processing in NetSuite, there are a few important things to keep in mind. How to correctly set up periods, how to execute the period close task and what the features and preferences are all included. Aside from these three, a couple other year-end tasks are valuable to understand, such as 1099 processing and record management. 

Managing Accounting Periods

In order to start the process of closing books in NetSuite, the period must be set up in the first place. This requires a fiscal year and base periods to be created before any transactions in NetSuite. This is typically one of these three options: standard calendar months, four weeks or 4-4-5 weeks.


Now that the fiscal year is set up, you can decide if you’d like to allow for Non G/L Changes to transactions in a closed period. This might be updating the memo field on a bill. Every time you see your accounting periods, you’ll see them in one of these three states: unlocked, locked or closed. Unlocked implies there are no restrictions on the posting of transactions, locked only allows users with the “override Period Restriction” permission to edit transactions, and closed means no users, no matter their status, can post or make changes to transactions. 

 

Period Close Checklist

At the end of your transactions in a given month you will go through the Period Close Checklist on the Manage Accounting Periods page. On this page, certain enabled features will determine which tasks you must complete by month end. Below are some common close tasks in NetSuite:

  • Lock A/R: When locked, only Override Period Restriction users can make AR transactions
  • Lock A/P: When locked, only Override Period Restriction users can make AP transactions
  • Lock All: This locks all users from making journal entries or transactions, even those with the override permission.
  • Resolve Date/Period Mismatch: NetSuite requires the notice of the mismatch between transaction date and posting period for transactions. You can proceed with the month end checklist without aligning the two, however, this can cause confusion in reporting. For example, if two users run seemingly the same report but user A runs it on transaction date while user B runs it on Posting period, the users could come to different results. Date/Period Mismatches can be avoided by setting the “Allow Transaction Date Outside of Posting Period” accounting preference to “Disallow.”
  • Review Negative Inventory: While NetSuite requires the acknowledgement of negative inventory balance, you are able to proceed with closing the books with a negative balance. 
  • Review Inventory Cost Accounting: This task ensures that all inventory costing calculations have been completed, and if they have not there is a button to do so.
  • Reevaluate Open Foreign Currency Balances: This calculates currency revaluations for open customer and vendor transactions, foreign currency-denominated accounts and other non-equity balance sheet accounts.
  • Eliminate Intercompany Transactions: This generated elimination journal entries for any transaction lines that are flagged to be eliminated.
  • Close: This is the final step in the close process; once it is done, no user can make any G/L impacting entries or edits

 

Year-End Considerations

As previously discussed, there are a few other factors that will make closing in NetSuite easier to utilize once in practice. The first is 1099 processing NetSuite which requires a certain setup. The steps are as follows:

  • Select a 1099 Misc Category on your Gl accounts
  • Fill in Tax ID and mark “1099 Eligible” checkbox under the Financial subtab.
  • Within NetSuite, there is a free 1099 bundle that can be installed in your environment. This creates a saved search that queries your 1099 data points to report on vendor bill payments. This query can later be used to manually populate 1099’s 

To keep up with data housekeeping, review your Vendors, Customers, GL Accounts, and inactive unused records. Periodically review AR and AP Aging’s for past due transactions and take action if necessary. In NetSuite, you are not required to perform a formal year-end closing in NetSuite. Instead, it automatically closes year-end after all periods are closed. 

Once you’ve practiced using NetSuite for a short while, you will benefit from how straightforward and simple to use it is. If you have any questions, our NetSuite outsourced accounting experts are here to help.

Read more blog posts

Ecommerce professional reviewing accounting books.

6 Ways Ecommerce Companies Should Prep for Financial Audits

E-commerce companies have experienced rapid growth in recent years,...

The 8 Most Important KPIs for a Manufacturing Business

Key Performance Indicators (KPIs) are crucial metrics that help...

What Are Outsourced Accounting Services and Do I Need Them?

If you are asking yourself these two questions, you’ve come to the...

What's the Difference Between a CFO and a Controller - and What Do I Need?

Running a new or growing business without the right financial team in...

Sign up now:

Receive actionable business and accounting insights directly to your inbox.

Submitting this form subscribes you to emails from Plumb. View our privacy policy.