Contents x
    1099 Vendor Report w/ Fund Information
    • 07 Feb 2024
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Contents

    1099 Vendor Report w/ Fund Information

    • Updated on 07 Feb 2024
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    1099 Vendor Report w/ Fund Information

    This report lists 1099 Vendors (those who have the 1099 checkbox selected on the Vendor tab) whose 1099 amounts exceed a user-defined minimum amount.

    This report is identical to the 1099 Vendor Report and Forms, except that it also includes information about the Fund.

    Once you run the report, you can print the 1099 forms for each of the qualifying 1099 vendors directly from the FIMS Viewer. One form is printed for each vendor, and includes the following information: Community Foundation Name, Address, and Federal ID Number; Vendor Name, Full Address, and Tax ID Number, and Total Amount. You can also optionally export this information.

    Note: You can access this report from anywhere in FIMS by selecting Reports > Accounts Payable > 1099 Vendor Report w/ Fund Information.


    1099 Vendor Report w/ Fund Information Fields

    Field

    Description

    ID Code

    The Vendor’s Profile ID code.

    Vendor

    The Vendor’s report name.

    Tax ID

    The Vendor’s Tax ID number.

    Check No.

    The check number associated with each payment on the report.

    Check Date

    The date when the check was printed.

    Apply To

    The Voucher number that the check was applied to.

    Amount

    The total check amount for each check to a Vendor, followed by the grand total for each Vendor.

    Division

    The Division code for the Fund that made the payment.

    Fund ID

    The Fund ID code for the Fund that made the payment.

    Fund Name

    The name of the Fund that made the payment.

    Running the 1099 Vendor Report w/ Fund Information

    1. In Accounts Payable, select Reports > 1099 Vendor Report w/Fund Information.

    1099 Vendor Report Criteria Window

    2. In the Report Selection Criteria section, do the following:

    • In the Payments From / Through fields, enter the date range that you want to run 1099 forms for.
    • Enter the 1099 Lower Limit for the report. This is the amount that a vendor must exceed in order to receive a 1099 form.
    • If you only want to report on vendors that meet or exceed the 1099 Lower Limit, select the Exclude Vendors Under the Limit from Report checkbox. This checkbox is selected by default.
    • If you want to include any adjustments on the report, select the Include 1099 Adjustment Amounts checkbox. This checkbox is cleared by default. Note grantees and vendors share the same database table which is why the table name is Grantee.

    3. In the Fields for Form Creation section, verify that the correct Fed ID, Foundation Name, Address, and Phone Number appear for the organization. This information will appear at the top of any 1099 forms you create.

    4. Configure the desired Selection and Sorting criteria as you would for any standard FIMS report and then click Run Report.

    5. Once you verify that the information on the report is correct, click 1099 Forms on the FIMS Viewer menu bar to either preview or print your 1099 forms. You can also click Export on the menu bar to export the data from this report.

     

    Was this article helpful?
    What's Next