Rootworks 1099 Process

Rootworks 1099 Process

RootWorks 1099 Process

This document is designed to cover the RootWorks method for generating 1099’s in Accounting CS. RootWorks uses Quickbooks as a General Ledger but imports balances into Accounting CS for Financial Statements so this document covers generating the 1099’s without causing issues to your balances. This document will cover the following:

  1. Proper setup of the client in ACS
  2. Entering the 1099 Information
  3. Report available to send to clients to gather 1099 information (when the data isn’t accessible)

NOTE: A document in the Resource Center labeled Payroll Process Year End covers the final processing of the 1099’s.

Table of Contents

RootWorks 1099 Process

Client/Vendor Setup

Enter 1099 Information

Client/Vendor Setup

You have a few things to make sure your client and vendors are setup to do 1099’s.

Each client you do 1099’s for needs to be setup with the Accounting Module and have a bank account setup. Follow these steps to setup the client. NOTE: If the client is already setup because you do payroll or financials for them, you do not need to setup a new client.

  1. Click on Setup/Clients
  2. Click Add (you do not need to select a template)
  3. Put in a Client ID and Client Name
  4. Select the state the client is located in
  5. Select Accountingand Payroll (After-the-Fact) from the choice of services
  6. Click Add at the bottom
  1. Put in the Payroll Name (same as Client Name, EIN, and Address of the client and click Enter to Save

  1. Select the Bank Accounts from the left Navigation Pane
  1. Add a bank account. NOTE: If you are using ACS to produce financial statements or doing payroll, you should already have a bank account. Your bank account should have no G/L account in it or have the Undistributed Account entered
  2. Enter a Name for the Bank – That is all that is necessary.

  1. Click Enter to Save
  2. Select Vendors on the left navigation pane
  1. Click Add (and repeat this step for each vendor you need a 1099 for)
  2. On the Main Tab enter the following information:
  3. Vendor Name
  4. Vendor EIN/SSN
  5. Vendor Type of 1099 Recipient
  6. Vendor Address

  1. On the 1099 Properties Tab Enter the 1099 Form and Box Number for this vendor

NOTE: If the vendor has more than one distribution or form then enter each on a separate line. IE: If you have a vendor with NonEmployee Compensation on a 1099-Misc and Interest on a 1099-Int, enter as separate lines.

  1. Click Enter to Save the Vendor

Enter 1099 Information

Each 1099 you produce needs to be entered as an after the fact check with the total amount for the vendors. Follow these steps to enter the 1099 Amounts.

  1. Click on Enter Transactions
  1. Click Add at the bottom
  2. Select Type as Check and enter the following information
  3. Date of the year end for the 1099’s (ie. 12/31/XX where XX is the year)
  4. Select the ID of the Vendor
  5. In the Distributions Area at the bottom, enter a line for each 1099 for that vendor and enter the following:
  6. Account – 999
  7. Put an amount on that line
  8. Put which 1099 item from the vendor setup that needs to post to
  9. Click Enter to Save

Report Available to Gather 1099’s

There is a report in the resource center in the All ACS Reports Zipped called 1099 information report. This report is designed to show each Vendor, Address, last year amount and give the client a spot to put in the current year amount. To use this report do the following:

  1. Restore the report into the Report Designer
  2. When you print the report do the following
  3. Make sure your date range includes last years dates to get the prior year amounts
  4. Filter by type is 1099-Recipient

  1. This will give you a report similar to the screenshot below:

1

RootWorks 1099 Process

Top View