The Spectrum: Vendor Financials dataset provides a consolidated source of all vendor transactions. This dataset is intended for the Controller or Accounting staff. It includes summary information such as Billed (amounts before taxes and retention), Invoiced (includes sales tax), Paid, Retention, Retention Paid, Sales Tax, VAT, and Use Tax. Vendor, Vendor Information, Vendor Type are included as well. This dataset contains posted transactions only; no unposted cost support.

Vendor Invoices

Vendor Billed

This is the current period's billing, before backing off the current period's retention amounts. It does not include sales/use tax or VAT.

Vendor Billed To Date

This is the year-to-date billed before backing off retention amounts. It does not include sales/use tax or VAT amounts.

Vendor Invoiced

This is the current month sum of invoice for the subcontract. It is calculated as Billed + Taxes. It does not include use tax.

Vendor Invoiced To Date

This is the year-to-date sum of invoice for the subcontract. It is calculated as Billed + Taxes. It does not include use tax.

Vendor Retention

This includes all monies paid against Invoiced plus any Discounts Taken. It includes any Retention paid.

Vendor Retention To Date

This includes all year-to-date monies paid against Invoiced To Date plus any Discounts Taken. It includes any Retention Paid To Date.

Vendor Sales Tax

This is the current month’s sales tax.

Vendor Sales Tax To Date

This is the year-to-date sales tax.

Vendor Use Tax

This represents the current period's use tax accrued.

Vendor Use Tax To Date

This represents the year-to-date use tax accrued.

Vendor VAT

This represents the current period's VAT.

Vendor VAT To Date

This represents the year-to-date VAT.

Vendor Payments

Vendor Paid

This includes all monies paid against invoiced plus any discounts taken. It includes any retention paid.

Vendor Paid To Date

This includes all year-to-date monies paid against invoiced plus any discounts taken. It includes any retention paid.

Vendor Retention Paid

This includes all monies paid for retention.

Vendor Retention Paid To Date

This includes all to-date monies paid for retention.

Cost Center

Cost Center

This represents the cost center, profit center or some other way to group the organization.

Cost Center Description

The description for a particular cost center.

Cost Groups

This represents the cost centers, profit centers or some other way to group the organization.

Fiscal Date

Month

Includes all dates from the start of the month through the end of the month. Note that this value is based on the actual date of each record.

Period

Includes all dates from the start of the month through the end of the month.

Year

Based on the Company's fiscal calendar, this is the fiscal year.

VAT

Current VAT Rate

The current rate for a particular VAT code.

VAT Code

This represents the value-added-tax (VAT) code.

VAT Code Description

The description for a particular VAT code.

Vendor Sales/Use Tax

Current Sales/Use Tax Rate

The current rate for a particular vendor sales or use tax code.

Type

The type (either Sales or Use) for a particular vendor sales or use tax code.

Vendor Sales/Use Tax Code

This represents the vendor sales or use tax code.

Vendor Sales/Use Tax Description

The description for a particular vendor sales or use tax code.

Vendors

Address 1

Vendor address information from Accounts Payable.

Address 2

Vendor address information from Accounts Payable.

City

Vendor address information from Accounts Payable.

Company Code

This code represents the Spectrum Company or Spectrum Group of Entities.

Country

Vendor address information from Accounts Payable.

Disadvantaged Business

Indicates that this vendor is classified as a disadvantaged business for certain government reporting.

Minority Business

Indicates that this vendor is classified as a minority business for certain government reporting.

Phone

Vendor phone information from Accounts Payable.

Small Business

Indicates that this vendor is classified as a small business for certain government reporting.

Sate/Province

Vendor address information from Accounts Payable.

Vendor Code

This represents a specific vendor.

Vendor Name

This is the name of the vendor associated with a particular vendor code.

Veteran Business

Indicates that this vendor is classified as a veteran business for certain government reporting.

Woman Business

Indicates that this vendor is classified as a woman business for certain government reporting.

Zip/Postal Code

Vendor address information from Accounts Payable.