1099s for vendors

Keywords: Vendor, Account Payable, Reports, Sage

Credit:– Sage Photo By: FP

Struggling to Keep Your Books in Order? 📊📅

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

👉 Click Here for a Free Consultation!

You can tag any vendor as a 1099 vendor and have Sage Intacct track 1099 totals for printing on your 1099 form.

Vendor tab

Identifiers (ID)

Intacct provides two mutually-exclusive ways to add vendor IDs. You can enter your own unique ID, or have Intacct create an ID for you using document sequencing. The Vendor ID can’t be changed after the vendor is created.

Best practices for creating identifiers: An ID enables your company to keep track of a specific type of information, such as GL account, department, location, item, project, class, transaction, vendor, and customer. You can create IDs by adding them on the fly or by having Intacct automatically add them from a preset numbering scheme.

Whichever method you choose, we recommend against using leading zeros as part of an ID. IDs with leading zeros can cause errors when you import information into your company from Excel because Excel removes the leading zeros.

Best practice: Use a character as a prefix to your ID; for example, C0001 for a customer ID.

Workaround: if you must use leading zeros in IDs, convert the column of ID numbers to text format in Excel before importing the file content. Excel won’t remove the leading zeros when you save the file. Remember to do this every time you use a template to import information that requires IDs.

Name

The name of the vendor as it will appear on lists and menus across your company.

One-time use

Designates the vendor as a one-time or occasional use vendor that you do not want to include in standard vendor lists.

Status

Status determines whether you can create, edit, and complete transactions for the vendor and how visible the vendor is within lists and reports.

Active

The vendor can be selected for Accounts Payable and Purchasing transactions. You can make payments to the vendor. The vendor shows up in unfiltered views of the vendor list by default and is included in reports.

Inactive

You cannot select the vendor in transactions or complete existing payments. To see the vendor in the Vendors list, you must adjust your filters.

Active non-posting: You cannot post transactions or complete payments to the vendor, but you can create and complete transactions to child vendors. You can see the vendor in reports and the Vendors list without filters. Active non-posting is helpful with reporting.

State

This field appears when vendor approval is enabled. It shows the approval state.

Submitted: The vendor record is new or was updated and is now awaiting approval. Accounts Payable and Purchasing transactions for this vendor can be saved as drafts but cannot be posted.

Declined

This vendor was declined during the approval process. View the Approval history on the History tab to see any comments left by the reviewer. The vendor can be edited and resubmitted for approval. Until it is approved, you cannot post Accounts Payable or Purchasing transactions for this vendor.

Approved

The vendor has been approved. You can post Accounts Payable and Purchasing transactions for this vendor.

Tax information

This section only applies to companies subscribed to the Taxes application.

Country

The country where payments and statements will be sent.

Tax ID

The tax identification number for the vendor. When you include the Tax ID column in a custom view of the Vendors list, filter using a complete tax ID only. You cannot filter using wildcards, such as %, because the data is encrypted.

If the country is Australia, the United Kingdom, or any of the other countries in the European Union (EU), a government-provided validation service is called when you focus out of the field. The validation service determines whether the tax identification number is valid. For Australia, the number is valid if it’s active. For the United Kingdom and EU countries, the number is valid if it’s active and VAT registered.

If the tax number is valid, additional fields are populated. If the tax number isn’t valid, an error message is displayed.

To save the record, the tax identification number needs to be either valid or left blank.

Company name as registered

The name of the company was returned by the government validation service. The name is displayed in the language in which the validation service returns it.

This field appears only when the Country is Australia, the United Kingdom, or other countries in the European Union (EU) and the validation service has confirmed the tax identification number is valid.

Address

The address of the company was returned by the government validation service. The address is displayed in the language in which the validation service returns it.

This field appears only when the Country is Australia, the United Kingdom, or any of the other countries in the European Union (EU) and the validation service has confirmed the tax identification number is valid.

Date tax number last validated

The date on which the validation service was last called, and the tax identification number was found to be valid.

GST registered

When the country is Australia, identifies whether the tax identification number (the ABN) is GST registered.

Primary contact section

Last name

Last name of the main contact for the vendor.

First name

First name of the main contact for the company.

Middle name

Middle name or initial of the main contact for the company.

Print as

The name that you want to appear on the following printed output for this vendor:

  • bills
  • advances
  • adjustments
  • checks
  • 1099s

If you enter a Print as a name that’s different from the 1099 name, both fields print on the 1099 form with the 1099 name printed on top.

If both fields are the same, only one name is printed.

Country

The country where payments and statements should be sent. Country is mandatory for addresses. It is included on printed checks.

Address line 1

The first address line where payments and statements should be sent.

Address line 2

The second address line where payments and statements should be sent.

Address line 3

The third address line where payments and statements should be sent. This information is not printed on 1099 forms or transmitted when e-filing.

City

The city where payments and statements should be sent.

State or territory

The state or territory where payments and statements should be sent. This field is populated with a list of states, provinces, or territories based on the country selected above.

ZIP or post code

The ZIP or post code for the location where payments and statements should be sent.

Primary phone

No template is applied. Brackets, hyphens, and other symbols will only be shown where you place them.

Mobile phone

No template is applied. Brackets, hyphens, and other symbols will only be shown where you place them.

Pager

No template applied. Brackets, hyphens, and other symbols will only be shown where you place them.

Fax

No template applied. Brackets, hyphens, and other symbols will only be shown where you place them.

Email address

An email address for main company contact. Intacct only accepts a valid email format, which includes an @ symbol and domain.

Secondary email address

An email address for a secondary company contact. Intacct only accepts a valid email format, which includes an @ symbol and domain.

Latitude and Longitude

The latitude and longitude coordinates that identify the location of the contact, which can be useful when a mailing address doesn’t exist.

  • Latitude: A value in decimal degrees from -90 to 90, with a scale of up to 8 decimal places
  • Longitude: A value in decimal degrees from -180 to 180, with scale up to 8 decimal places

These fields appear only if you use Avalara AvaTax and your AvaTax integration is configured to use latitude and longitude coordinates. The Intacct system sends the coordinates to AvaTax to use as the addresses in the tax calculations. AvaTax returns results only if the latitude and longitude coordinates pinpoint a location within the United States.

URL

The URL for the company’s website. This information is for your reference and is not used within standard Intacct applications. Intacct doesn’t validate this field as a URL.

Exclude from the company contact list

Select if the contact listed on this page should not be included in the company contact list. The contact list is on another tab on this page.

This vendor is an individual person

Select this option if the vendor is an individual person. This masks their personal identifying information (PII) for security purposes when you pay them with Vendor Payments powered by CSI.

Additional information tab

Vendor details section

Type ID

You can select or add a vendor type ID. The ID must exist before being added to this vendor. Type IDs are useful for reporting purposes, you can group vendors by type and then report on them. For example, you might create a vendor type Contractors, assign a Form 1099 to that type, and tag all vendors who receive that form with the Contractors vendor type.

1099s: You can assign a default 1099 form and box for a vendor type. The default 1099 form and box on the vendor type overrides what you defined on the vendor record. Learn more about how vendor types interact with 1099s.

Parent

You can look up or add a parent vendor. The vendor must exist before being added to this vendor.

GL group

You can select or add a GL group to be associated with this vendor. The GL group must exist before being added to this vendor.

Lead time default (days)

The number of days it takes the vendor to deliver items to you after receiving the order. You can enter up to 3 characters. This field appears only if replenishment is enabled in the Configure Inventory Control page.

DATEV ID

For vendors associated with German companies or entities. The DATEV ID displays in the DATEV exports.

1099 eligible

Select to designate this vendor as eligible for a 1099.

1099 name

The official name of the company is used on a 1099 form. If the 1099 name is the same as the vendor Print as name, the 1099 name is suppressed during printing (Intacct only prints the name once).

If the 1099 name is different from the vendor Print as name, Intacct prints both names on 1099 forms. The 1099 name appears above the Print as the name on the form.

Form 1099

Select to update existing 1099 information for a vendor.

Attachment

To reference an attached document, you must first load the scanned image, spreadsheet, or word-processor document. You can provide permanent, safe storage of supporting documents by uploading them to the Intacct system as attachments. Learn more about who can add attachments.

You can drag and drop your files to add an attachment. To attach a document to multiple journal entries, see Bulk processing.

Enable TPAR

Select this option to include vendor payments in the Taxable payments annual report (TPAR). For Australian companies and entities. Learn about enabling TPAR for vendors.

TPAR name

For Australian companies and entities only, when the TPAR is enabled. To report vendor payments using a name other than the Print as name, enter that name here.

Enable T5018

Select this option to include vendor payments in the T5018 report. For Canadian companies and entities. Learn about enabling T5018 for vendors.

Billing details section

AP account

This option appears if you enable the default GL AP account to be overridden at transaction entry. Intacct populates the AP override account you select here to every bill or adjustment transaction that includes this vendor. You can override this alternative account as needed.

In Accounts Payable, this feature applies to bills and adjustments only. It doesn’t apply to recurring bills, manual payments, or advances.

Default expense account

Select a default GL expense account for bills for this vendor. You can override this on the Bills page.

Credit limit

Credit limit designates the amount of credit extended to you by the vendor. Depending on how you configure Accounts Payable, if you exceed the vendor credit limit, the system:

  • warns you that you’re exceeding the limit.
  • will not allow transactions to be created that exceed the limit.
  • does nothing.

Bill approver

Appears when the Vendor-based approval rule type is present in the Bill approval policy.

Assigns the vendor-based approver for bills submitted for this vendor. Any unrestricted business or employee user with Approve bills: List permissions can be selected as an approver. For user groups, all members of the group must be unrestricted.

Discount percent

This box accepts a number from 1-100 with up to 2 decimal places. The number represents the percent value, not its mathematical equivalent. For instance, to get “ten percent,” type 10, not 0.10. Don’t enter the percent sign in the field.

Vendor price list

You can select or add a Vendor price list. The Vendor price list must exist before being added to this vendor.

Price schedule

You can select or add a Price schedule to be associated with this vendor. The Price Schedule must exist prior to being added to this vendor.

On hold

No one can enter bills into the system for the vendor.

Do not pay

Stop payments to the vendor from the system.

Comments

Notes regarding the vendor.

Default currency

Only applicable to multi-entity, multi-currency companies. Use the dropdown list to select the default transaction currency for this vendor. Users can override this currency on the transaction.

The dropdown list displays the transaction currencies that are enabled for your company.

Always create AP bills from Automated transactions

Select this checkbox if you want automated transactions to always be created as AP bills, instead of Purchasing vendor invoices.

If you want some transactions for this vendor to be processed through the Accounts Payable workflow and others to be processed through Purchasing, leave this option unselected. Instead, change individual transactions to bills when editing them from the Automated transactions list.

This option appears when you have Automated transaction matching enabled in Purchasing.

Tax calculation

Taxable

Select this checkbox if regular purchases from this vendor are taxable.

Intacct adds sales tax in Purchasing whenever a bill is added from this vendor. This applies to both the Simple Tax and Advanced Tax features.

When applicable transactions are created in Accounts Payable for this vendor, the user selects the appropriate tax detail (category and rate) to apply to each line item. When applicable transactions are created in Purchasing for this vendor, the system automatically calculates the tax.

Tax solution

This setting applies only if the company uses the Taxes application for VAT and GST taxes.

  • Select the tax solution to associate with the vendor.
  • Default tax schedule
  • Select a tax schedule to use as the default when calculating taxes in a transaction for the vendor.

Contact tax group

This setting applies only if you use Advanced Tax in your company.

The contact tax group helps determine which tax maps and tax details are used to calculate tax for this vendor for applicable documents in the Accounts Payable and Purchasing applications.

In Accounts Payable transactions, the contact tax group helps filter the list of tax details from which the user selects the tax category and tax rate to apply to line items.

If the pay-to contact is not the same as the primary contact, the pay-to contact must be marked as taxable and assigned to a contact tax group.

The contact tax group must exist before being added to this vendor.

Email template options

Email template

Select an existing email template or create a new one for the vendor.

Transaction definition

If the email template is for Purchasing transactions, select a Transaction definition for the email template.

Contact list tab

Use contact records to manage multiple addresses for individuals and locations associated with the vendor. If you update vendor contact information, Intacct will also update the associated contact.

Pay to and return to section

Primary contact

Default contact for all transactions if no other vendor contacts are defined. If you do not see the correct name in the dropdown list, add it in the Contact List section.

Pay-to contact

Default contact when paying by checks or creating bills. If you do not see the correct name in the dropdown list, add it to the Contact List tab.

This contact is required for calculating tax in the Purchasing application.

For VAT tax solutions, the system uses the contact tax group associated with the Pay-to contact to:

  • filter the list of tax details from which the user selects the tax category and tax rate to apply to line items in Accounts Payable transactions
  • automatically calculate the tax to apply to line items in Purchasing transactions
  • Did you enter a different pay-to contact on the bill than what’s associated with the vendor record? Learn how to print that pay-to contact on the check.

Return-to contact

Default contact for purchasing transactions. If you do not see the correct name in the dropdown list, add it to the Contact List tab. The return-to contact is used by the system in several vendor-related activities.

Required if you’re using Advanced Tax calculation or Avalara AvaTax in Purchasing unless ‘Deliver to’ contacts are enabled on the Configure Purchasing page. If ‘Deliver to’ contacts are not enabled, the system uses the Return-to contact in the tax calculation in purchasing transactions:

Advanced Tax.

The contact tax group associated with the Return-to contact is used.

Avalara AvaTax.

The address associated with the Return-to contact is used.

1099 Contact

If you want to specify a dedicated 1099 contact for printing purposes, select the appropriate one from the dropdown list. If you do not see the correct name in the dropdown list, add it in the Contact List section.

Contact list section

Category

Category is a user-defined field that allows you to more easily group and sort contacts.

Contact

You can look up or add a Contact. The Contact must exist before being added to this vendor.

Payment information tab

Payment details

Preferred payment method

Select the default preferred payment method for this vendor Use this field to create advanced filters for Pay bills that filter for a specific Preferred payment method.

If you’re subscribed to Vendor Payments powered by CSI, this field is read-only and displays how CSI pays the vendor.

Merge payment requests

You can merge bills into one payment request for this vendor, or you can set one request per bill. You can override this selection on the Pay bills page.

Send automatic payment notification

Select to automatically send an email to the vendor notifying them of their payment. Learn more about automatic payment notifications.

Vendor billing type

To show all bills, adjustments, and payments as line items on a vendor statement, select Open item (default), or to consolidate previous months bills, adjustments, and payments to a single line item, select Balance forward.

Payment priority

Set a payment priority on a per vendor basis, to be applied to new bills. When using Pay bills, you can filter by payment priority to ensure that you’re paying the most urgent bills first.

You can override the payment priority for an individual bill during bill entry.

Term

In the Term field, select the terms extended to you by the vendor.

Standard terms include:

  • Net 30: Due within 30 days.
  • Net 15: Due within 15 days.
  • Upon receipt: Payment to be sent immediately upon receipt of a bill.
  • Display the term discount on the check stub
  • Select to include any associated term discount on the check stub.

Default bill payment date

Select how Intacct calculates the Recommended to pay on date for all bills from this vendor. The Recommended to pay on date suggests when a bill should be paid in order to receive a discount or avoid penalties, but it does not enforce this.

  • To filter by the Recommended to pay on date In Pay bills, create an Advanced filter. Create a Drill down filter for the Bill object and the Recommended to pay attribute.
  • For each Default bill payment date option, the Recommended to pay on date on the bill is calculated as follows:
  • Due date: Uses the Due date that was calculated using the selected Term, then adjusts this based on the number of days you enter as an offset. Requires that you select a Term, either in the vendor record or the bill.
  • Bill date: Uses the date entered for the bill, adjusted for the number of days you enter as an offset. Does not require that a Term be defined.
  • Discount date: Uses the discount details in the selected Term to calculate the discount date. No offset is used. Requires that the selected Term includes a discount.

If you select Discount date as the Default bill payment date and the vendor Term does not include discount details, the Recommended to pay on date will not be populated.

Vendor account number

Number

The account number that a vendor assigns to you. For example, a telephone company might assign your phone number as your vendor account number. This is the number that gets referenced on the vendor check stub.

When you pay by check, the vendor account number appears on the check face or vendor stub. This makes it easy for the vendor to match the payment information with the bill that’s being paid.

  • If the payment is associated with bills from only one entity
  • The vendor account number prints in the Memo field on the check face.
  • If the payment is associated with bills from more than one entity

The vendor stub includes a Vendor Acct # column that displays the vendor account number associated with each payment covered in the check.

Display the vendor-assigned account number, per entity, on the check stub

A multi-entity company often has separate vendor-assigned numbers. For example, a telephone company might assign each entity phone number as a separate vendor account number. Instead of creating a separate vendor for each entity, enter an account number for each location.

To display the account number for an entity on the check stub, select to Display the vendor-assigned account number, per entity, on the check stub and then enter those numbers in the table below.

If you select this checkbox, you must enter a default Number for values to appear in Check runs.

Bank file tab

Enable setup

Enable ACH payments

Enables vendors to be paid by standard ACH.

Select this option to make direct electronic payments to the vendor when both accounts are co-located in the United States. Learn more about setting up a vendor for standard ACH.

Enable bank file payments

Select this option to make direct electronic payments to the vendor when both checking accounts are co-located internationally.

Learn more about setting up a vendor for bank file payments;

None

This is the default option. No ACH or bank file payments are enabled.

ACH payments

The following section appears after you select Enable ACH payments

Routing number

Required for standard ACH payments.

The routing number of the account where the vendor will receive payments.

Account number

Required for standard ACH payments.

The account number of the account where the vendor will receive payments.

Account type

Required for standard ACH payments.

Choose either a checking account or savings account.

Account classification

This field is only used for standard ACH payments.

Specify whether the vendor account is a personal or business account. For business accounts, select the classification code that your bank uses for ACH payments made to business accounts. This determines how line items in a payment file are tagged for processing by the bank.

If the vendor is an individual contractor using a personal account, choose Personal (PPD).

For business accounts, find out from your bank whether to choose Business (CTX) or Business (CCD).

Bank file payments

Payment country

Select the country in which the bank file payment is to be made.

When selecting the Payment country, Sage Intacct shows other bank file fields depending on the country you select. Learn more about vendor bank file details.

Payment providers tab

CSI section

Enable vendor for Vendor Payments powered by CSI

Enables the vendor for Vendor Payments powered by CSI. CSI reaches out to the vendor and the vendor selects how they want to be paid.

Status

The subscription status of the vendor. Only vendors subscribed to the payment service will receive payments from CSI.

Preferred payment method

The preferred payment method for the vendor. This field is read-only and shows you the payment method that the vendor selected for CSI payments.

Restrictions tab

This tab only appears if you have vendors configured for restrictions.

Location groups and department groups that contain dynamic filtering do not appear on the Restrictions tab for selection.

Details

When setting up location groups or department groups, keep in mind that restrictions can be based on groups that contain specific locations or departments, but can’t be based on groups that filter dynamically based on the value of certain fields (such as locations where the status equals “Active”).

Unrestricted vendor

Default. This vendor is available to the top-level company and all entity level locations.

Restricted to top level only

Select this option to only access this vendor record and create transactions against this vendor at the top level.

When you restrict a vendor to the top level, their transactions appear on the aging report only if the report is not filtered by location.

Restricted Vendor

Select this option to only access this vendor record and create transactions against this vendor in the specified locations, location groups, departments, or departments groups.

Locations or location groups

Select Select and choose which locations or location groups to restrict the vendor to. The vendor will only appear in the locations and location groups you select.

Departments or department groups

Select “Select” and choose which departments or department groups to restrict the vendor to. The vendor will only appear in the departments and department groups you select.

Item cross references tab

Your vendors and you often use different identifiers (or SKUs) to refer to the same item. Use item cross references, or aliases, to match the vendor identifier for an item to the item ID you use. These cross references make transaction entry easier and more robust.

For example, when you create a purchase order and select the item ID, you can use the Cross-reference item ID dropdown to find the identifier the vendor uses. Thus, the vendor knows exactly what you want.

Learn more about item cross references;

Item ID

The item in your Sage Intacct company that you’re creating the cross reference for.

Cross-reference item ID

The identifier that the vendor uses in their company to refer to the item.

Cross-reference item description

A description for the cross-reference item.

Unit

The unit for the cross-reference item. The selectable values are the units that are defined for the item’s UOM group. For example: Each, Pair, or Dozen

TPAR tab

For Australian companies and entities, the TPAR tab appears when you enable the Taxable payments annual report (TPAR) for the vendor. If the vendor provided an Australian business number (ABN) where you did not withhold a portion of payment, you do not need to add entries.

Use this tab to do the following:

  • Record tax withheld for the vendor.
  • Record receipt of a Statement by a supplier.
  • Learn how to set up TPAR vendor information.

Location

The entity where the vendor provided services.

Year

The financial year when services were provided or paid.

Form box

  • Total tax withheld: Select this if you are recording tax withheld from a payment to the vendor.
  • Statement by supplier: Select if you are recording that you received a reasonable statement by the vendor that an ABN is not required for their business.

Value

  • For tax withheld, enter the amount withheld.
  • For a statement by the supplier, Yes is automatically selected.

Vendor compliance tab

Use the Vendor compliance tab to add, edit, and delete compliance records. This tab contains insurance, miscellaneous, and lien waiver compliance records associated with a vendor.

Construction subscription is needed. To enable a Construction subscription, contact your Sage Intacct account manager. Regional support for Construction is limited to the United States, Canada, and Australia.

The Vendor Compliance subscription is included with the Construction subscription, but you must enable it. After you enable the Vendor Compliance subscription, assign compliance permissions in Purchasing.

Insurance

Compliance type ID

The compliance type associated with an insurance compliance record.

Compliance record

The insurance compliance record associated with the vendor.

You can select the link to view compliance record information.

Description

The description of an insurance compliance record.

Primary document ID

A primary document associated with the vendor. You can select the link to view primary document information.

Received

  • When this checkbox is selected, the payment is received.
  • When this checkbox is unselected, the payment is not received.

Override compliance notification

  • When this checkbox is selected, Intacct notifies you about the insurance compliance record.
  • When this checkbox is unselected, Intacct does not notify you about the insurance compliance record.

Effective date

The effective date of an insurance compliance record.

Expiration date

The expiration date of an insurance compliance record.

Miscellaneous

Compliance type ID

The compliance type associated with a miscellaneous compliance record.

Compliance record

The miscellaneous compliance record associated with the vendor. You can select the link to view compliance record information.

Description

The description of a miscellaneous compliance record.

Primary document ID

A primary document associated with the vendor. You can select the link to view primary document information.

Received

  • When this checkbox is selected, the payment is received.
  • When this checkbox is unselected, the payment is not received.

Override compliance notification

  • When this checkbox is selected, Intacct notifies you about the miscellaneous compliance record.
  • When this checkbox is unselected, Intacct does not notify you about the miscellaneous compliance record.

Effective date

The effective date of a miscellaneous compliance record.

Expiration date

The expiration date of a miscellaneous compliance record.

Lien waivers

Compliance type ID

The compliance type associated with a lien waiver compliance record.

Compliance record

The lien waiver compliance record associated with the vendor. You can select the link to view compliance record information.

Primary document ID

A primary document associated with the vendor. You can select the link to view primary document information.

AP bill

The Accounts Payable bill associated with the lien waiver compliance record.

AP payment

The Accounts Payable payment associated with the lien waiver compliance record.

Amount

The amount due for the lien waiver compliance record.

Received

  • When this checkbox is selected, the payment is received.
  • When this checkbox is unselected, the payment is not received.

Override compliance notification

  • When this checkbox is selected, Intacct notifies you about the lien waiver compliance record.
  • When this checkbox is unselected, Intacct does not notify you about the lien waiver compliance record.

Effective date

The effective date of a lien waiver compliance record.

Buttons

  • Buttons
  • Description

Add

Select to add an insurance or miscellaneous compliance record to a vendor. Sage Intacct generates lien waiver compliance records.

Pencil icon

Select to edit insurance, miscellaneous, or lien waiver compliance record information from a vendor.

Trash icon

Select to delete an insurance, miscellaneous, or lien waiver compliance record from a vendor.

History tab

This tab appears on the vendor record when vendor approval is enabled.

Approval history

Approval type;

  • Create: The submitted vendor record was new.
  • Update: The submitted vendor record was an update of an existing record.

Submitted date

The date when the vendor was submitted for approval.

Submitter

The user who created or edited the vendor record.

Approval date

The date the vendor was approved or declined.

Approver

The user name of the approver who acted on this vendor.

Action

Whether the vendor was Approved or Declined.

Comments

The person who approved or declined the vendor has the option of leaving a comment to explain their decision. That comment appears here.

Check out our Free Additional Articles