1099-Misc Tracking and Reporting

1099-Misc Tracking and Reporting

1099-Misc Transaction Tracking

If you need to have 1099-MISC forms prepared and sent out to vendors that are not employees, CustomBooks™ can assist you by tracking the amounts spent for 1099 Vendors throughout the year. When it’s time to send them, run a report in CustomBooks™ and upload the data electronically using our partner, Track1099.com for the simplified online creation and distribution of the forms to your 1099 vendors. No more expensive forms or envelopes to buy. No forms to manually fill out. Everything is done electronically for your convenience!

Setting up CustomBooks™ to Track non-employee compensation

There are three main steps to complete in CustomBooks™ to ensure proper reporting. Once these three items are in place, getting the data needed to export and upload to Track1099.com is quick and easy.

Step 1: Set up the Vendor Card

When a vendor card is created or edited in CustomBooks™, ensure that the information on the 1099 tab has been completed and that the vendor’s primary mailing and email addresses have been entered on the Vendor card.  Completing this information when the vendor is created will save time at the end of the year. All this information can be found on the I-9 form that you had your vendor fill out when establishing the relationship.

For each vendor that will need a 1099 form produced, check the the 1099 Vendor checkbox (1, below). Next,  ensure that following items are completed on the 1099 tab on the Customer / Vendor card:



  • The Name  of the person (not the DBA or business name)  (2).
  • The Federal ID Type (SSN or EIN)  (3).
  • The Federal ID Number (4). 

In addition, a valid address will need to be entered on the Addresses / Contacts tab and should be the vendor’s primary mailing address

You can view the vendors that have have been marked as 1099 vendors by navigating to Customer/Vendor Central and sorting by the 1099 Vendor column.


Step 2:  Set up 1099 Accounts

Any accounts that are used to track 1099 related expenses will need to have a 1099 category assigned to them. This step may have been completed when the chart of accounts was created for your company. If you are not sure, please consult with your CPA or Accountant.

To enter a 1099 category on an account:

  1. Navigate to Accounting → Chart of Accounts
  2. Open the account by double-clicking on it in the list.   
  3. Choose the appropriate 1099 category from the drop-down list. Each category is associated with a box on the 1099 form. [/jmlnotification]
  4. Click Save and Close.


You can view the accounts that have categories already assigned by navigating to the Chart of Accounts as described above and sorting by the 1099 category.  Click on the column name to sort by that column.

Step 3: Excluding payment methods

Certain methods of payment may handle 1099 reporting requirements for you. To avoid double reporting, these payment methods may be excluded from 1099 reporting in CustomBooks™.

Important:  It’s important to understand the 1099 requirements when using this feature. Please consult with a tax specialist or check the rules and regulations with the IRS or a tax specialist for more information regarding your specific situation.
To exclude a payment method from 1099 reporting in CustomBooks™,  navigate to the payment method (Lists →  Payment Methods) and check the checkbox labeled “Exclude from 1099”.


Running the Vendors 1099 Report

With the preceding setup steps completed, the 1099 report may be run at any prior to the reporting deadlines. For more information, see Instructions for Form 1099-Misc. on the IRS website.

To run the Vendors 1099 Report:

  1. Navigate to Reports → Accounting → Vendors 1099 Report.
  2. Choose a Tax Year (typically last year) from the drop-down list.
  3. Choose an option from the Show drop-down:
    1. the 1099 Vendors that meet threshold option will only include those 1099 vendors for which the payment amount threshold has been reached.
    2. the 1099 Vendors below threshold option will include those vendors for which the threshold has not been met.
    3. the Non-1099 Vendors will include all vendors that do not have the 1099 Vendor checkbox check on the Customer / Vendor. card.
  4. Click Run Report.
  5. In preparation to upload to Track 1099, export the report to excel by clicking Export to Excel.
  6. Go to Track 1099 (http://track1099.com/) and follow the instructions to prepare the data for upload.

    • Related Articles

    • Reporting

      Reporting CustomBooks™ has a complete set of financial, operational and project based reports. Our advanced reporting customization features allow you to create the report you want. To run a report, Navigate to Reports → Report Category → Report ...

    • Time-tracking

      Time-tracking Time-tracking allows the users of CustomBooks™ to log hours against a project. The tasks are items, just items that aren’t tracked in inventory. They are known as service items. In order to track time, the following tasks must be ...

    • Expense Reports (extension)

      Overview The Expense Reports extension allows users of your organization to submit expense reports and managers to approve the expense reports. Installation Please view this article for installation instructions. Setup A few setup tasks are needed In ...

    • Projects/Jobs

      Project / Jobs The Projects/Jobs module allow the user to group transactions in the system for the purposes of reporting and tracking. Usually, a project/job is created for a short term grouping need. For grouping transactions for a more permanent ...

    • Projects / Time Tracking Overview

      Overview With Project and Timetracking, keeping on top of costs associated with a project has never been easier. Our Projects functionality spans the application and projects created here can be tagged on quotes, orders, invoices, bills, payments, ...