The NetSuite Accountant

How to build a monthly spend by vendor saved search in NetSuite

Paul Giese Mar 9, 2020 8:15:00 AM
0

For an accounting team explaining the spending changes, having a report that quickly shows vendor spending is helpful. In this blog post, I will walk you through how to build this with a NetSuite saved search. 

Read More

Five NetSuite preferences you need to know

Paul Giese Mar 2, 2020 8:15:00 AM
0

NetSuite is a flexible accounting solution that has many preferences available to individual users. While an individual setting rarely makes-or-breaks the system, over time, optimizing many small experiences can lead to large efficiencies. In this blog post, I highlight five preferences to improve your NetSuite experience.

Read More

NetSuite saved search for accounts payable review

Paul Giese Aug 26, 2019 8:15:00 AM
0

When managing accounts payable (AP), team members are often asked about the status of an invoice, payment date, the coding for a specific invoice, and other questions about AP activity. Utilizing a NetSuite saved search is a perfect use case for helping answer these vendor questions quickly. Saved Searches are one of my favorite features of NetSuite. Today, I am going to walk through a transaction saved search for getting answers to questions about vendor activity.

Read More

Using SUMIFS and NetSuite saved searches to automate reconciliations

Paul Giese Jul 8, 2019 8:15:00 AM
0

The SUMIFS formula is a powerful formula that every biotech accountant should be able to use. Today, I am going to walk through how to use this formula with a NetSuite saved search to automate an accrual monthly reconciliation. This setup has worked well for preparing preclinical, clinical and CMC accruals.

Read More

1099 saved search in NetSuite

Paul Giese Jan 14, 2019 8:30:00 AM
0

With the start of tax season comes the task of preparing and filing 1099s. In NetSuite, the combination of the vendor record and the GL account is how 1099 activity is tracked. Within the vendor record, users add the tax ID and enter if the vendor is 1099 eligible or not. Users enter the 1099 category on the GL account record.

Read More

Setting up a biotech chart of accounts

Paul Giese Aug 8, 2018 9:18:00 AM
0

One of the first accounting decisions made by early-stage biotech is how the chart of accounts is structured. The chart of accounts is critical for producing meaningful financial statements - a balance sheet, income statement, and statement of cash flows. Setting up a correct chart of accounts will provide useful reports to internal and external stakeholders.

Read More