Automate NetSuite Vendor Bill Entry from 1099 Contractor Timesheets

This article is relevant if you are using the NetSuite Advanced Projects module and you wish to streamline the work required to process timesheets and their associated vendor bills.

Background

My NetSuite Systems Integration practice, Prolecto Resources, offers expert NetSuite services on a time and materials basis.  As such, we are heavy users of NetSuite’s Advanced Projects module.  All time entered in the timesheet by staff is reviewed for reasonableness and ultimately offered up on our client invoices as evidence of services rendered.

In some respects, this business model is a common practice used by staffing organizations.  I know this business model well because in the year 2000, I sold my eCommerce firm, InterScore, Inc., to an established ERP staffing organization in Southern California.  While running the eCommerce practice in this organization, I studied carefully the overall business practice used in staffing world.

Fundamentally, the staffing organization that purchased my firm offered up individual experts to companies that needed ERP help on an hourly basis.  The practice was simple to understand but often times had high administration costs:

1. Hire Outside Expert: A individual would be hired in a 1099 contractor capacity to engage on a staffing project.
2. Track Time: The individual would produce a weekly timesheet and have it signed by the hiring manager.
3. Submit Tracked Time: The staffed individual would then submit the approved timesheet to the staffing organization for processing.
4. Track Obligation: The staffing organization received the approved timesheet and would then book an obligation to the contractor at an agreed rate.  Manually of course.
5. Bill Customer: Simultaneously, the staffing organization would markup the rate paid to the 1099 contractor and compile a customer invoice requesting payment for services rendered.

How NetSuite Advanced Projects Almost Fits the Staffing Model

The practice above was helpful to outline because NetSuite’s Advanced Projects module gets close to solving many of the coordination and accounting concerns common in staffing organizations.  Here are some of the most important elements:

1. Project Constitution: A customer can have more than one project and each project can have multiple tasks.
2. Assign Individuals and Cost/Price: Each project task can be resourced by individuals at a particular cost and price.
3. Capture Time by All Parties: Projects can be resourced by both internal employees and external (1099) vendors.  NetSuite allows vendors to enter timesheets built into the module subscription price.  Everyone loves this!
4. Timesheet Backs the Invoice: Timesheet entries can be routed for customer billing purposes.

1. NetSuite’s Advanced Projects module already captured the cost for the outside contractor services.
2. If we setup the project correctly, then we have everything we need to properly record the obligation to the outside expert.

How We Create Vendor Bills from Submitted NetSuite Timesheets

At this point, I need to step back and share that I have never been satisfied with the way NetSuite offered timesheet approval practices.  Effectively, each time entry needs to be marked approved.  In addition, there was not a clear event for staff to indicate they were committed to the time entered.

Note, since 2014.1, NetSuite offered a new Time Card (NetSuite calls it Timesheet but it effectively moves from a single time entry model to a grouped model) feature.    However, the Time Card implementation did not fit our model well for various reasons (which is subject to a different article).  We needed to keep the standard timesheet mechanism with individual entries working but add additional capacities.

Create a NetSuite Time Approval and Vendor Payment Workflow

The key way we solved this challenge was to invent a Time Approval mechanism that was not based on NetSuite’s standard logic.  The key capacities we needed were as follows:

1. Submissions: Give staff a clear way to submit a timesheet for approval.
2. Notifications: Produce an email and reminder notification that the submitted timesheet needs to be approved.
3. Late Reminders: Produce reminders to staff if their timesheet is late.
4. Time Review: Give project managers a way to see if the time entered is reasonable.  If not, allow notes to be captured and reject the timesheet.
5. Reject and ReSubmit: Automatically send rejected timesheets back to staff to modify the timesheet to address concerns.
6. Generate Vendor Bill: Once the project manager approves the timesheet, if staff is an outside contractor, generate a NetSuite vendor bill using the project cost definitions.

We solved this challenge using a combination of NetSuite scripting and workflows.   Now with this solution, we have dramatically reduced the effort to manage timesheets and nearly eliminated all the bookkeeping effort.  Click image to get a glimpse of the approval screen and linked Vendor bill.

Getting NetSuite Time Approval and Vendor Submission

Marty Zigman

Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - YouTube