top of page
Search

Mastering the NetSuite 1099 Process with Six Easy Steps

Writer's picture: Black Forge ConsultingBlack Forge Consulting

Although NetSuite doesn't provide an integrated feature for printing 1099 forms, did you know that you can effortlessly generate the necessary data using custom-saved searches?


By utilizing these searches, you can export the data to Excel, ensuring a smooth 1099 filing process. Simply follow these six steps to prepare your 1099 forms with accuracy and efficiency through NetSuite.


Step 1: Update Vendor Record Attributes


Before generating 1099 forms, it's essential to ensure that the correct attributes are set for your vendors.

  • Ensure the 1099 Eligible Checkbox is checked for each vendor that should receive a 1099 form.

  • Tax IDs must be filled in for all eligible vendors. This can be done manually or with a CSV import for bulk updates.

Step 2: Update G/L Account Attributes


Next, you'll need to ensure that the proper attributes are assigned to your General Ledger (G/L) accounts.

  • Ensure the appropriate box is selected in the 1099 Misc Category field for each relevant G/L account. This can also be done in bulk through a CSV import.


Note: G/L accounts have a one-for-one relationship to 1099-Misc categories, meaning that accurate account mapping is crucial for ensuring that payments are categorized correctly.

Step 3: Install the 1099 Bundle


To make the 1099 process easier, you will need to install a 1099 bundle from SuiteBundler.


  1. Navigate to: Customization > SuiteBundler > Search and Install Bundles

  2. Search for the “Yearli” bundle and click the hyperlink to begin the installation process.


Note: This bundle will automatically create a series of saved searches to streamline the 1099 data generation.

Step 4: Configure the Saved Searches


Once the Yearli bundle is installed, you will configure the saved searches to reflect your organization’s details.


  1. Search for "Yearli" in NetSuite’s global search bar.

  2. Open the following saved searches in Edit mode:

    • 1099 Vendor Payment Report – Yearli MISC

    • 1099 Vendor Payment Report – Yearli NEC

  3. Prepend your organization name to the saved search name.

  4. Customize the results by editing the fields in the “Results” tab. Insert information relevant to your organization in the appropriate fields, between apostrophes.

Example Before:

Example After:

Step 5: Run the Searches and Export to Excel


After configuring the searches, you can run the searches to generate the data for your 1099 forms.

  1. Run the searches to pull the data.

  2. Export the data to Excel.

  3. Validate the data: Validation is critical!


Note: NetSuite will display all paid bills, but it won’t automatically limit amounts to a $600 threshold for a single vendor. This validation step is critical.


Step 6: Choose a 1099 Provider


After verifying and finalizing the data, you can choose a provider to file your 1099 forms. One common provider is Yearli, which works well with NetSuite and allows for the direct import of your finalized Excel data.


  1. Select a provider such as Yearli to support data imports directly from NetSuite.

  2. Upload the finalized Excel file to your chosen provider and complete the filing process.



With these six steps, you'll have everything you need for seamless 1099 filing. If you have any questions or require further assistance with this process, Black Forge Consulting is ready to support you. Feel free to reach out to us at steve@blackforgeconsulting.com.

51 views0 comments

Recent Posts

See All

Comments


Commenting has been turned off.
bottom of page