The Spectrum: Customer Billings dataset provides a consolidated source of all customer billings. This dataset is intended for the Controller or Accounting staff. It includes summary information such as Billed (amounts before taxes and retention), Invoiced (includes taxes), Paid, Retention, Retention Paid, Sales Tax, VAT. Customer, Customer Information, Customer Type and Transaction Source. This dataset contains posted transactions only; no unposted costs.

Customer Invoices

Customer Billed

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

Customer Billed To Date

This is the year-to-date billed before backing off the current period's retention amounts. It does not include sales tax or VAT.

Customer Invoiced

This is the current month sum of invoice for the contract. It is calculated as Billed + Taxes.

Customer Invoiced To Date

This is the year-to-date sum of invoices for the contract. It is calculated as Billed To Date + Taxes To Date.

Customer Retention

This is the sum of the current retention plus retention VAT amounts for the contract. (Note other than the portion of VAT associated with retention, this amount does not include any other Taxes.)

Customer Retention To Date

This is the year-to-date sum of retention plus JTD retention VAT amounts for the contract.

Customer Sales Tax

This is the current month’s sales tax.

Customer Sales Tax To Date

This is the year-to-date sales tax.

Customer VAT

This represents the current period's VAT.

Customer VAT To Date

This represents the year-to-date VAT.

Customer Payments

Customer Paid

This includes all monies paid against Invoiced plus any Discounts Taken. This also includes any finance charges assessed to the customer.

Customer Paid To Date

This includes all year-to-date monies paid against Invoiced To Date plus any Discounts Taken. This also includes any finance charges assessed to the customer.

Customer Retention Paid

This includes all monies paid for retention.

Customer Retention Paid To Date

This includes all to date monies paid for retention. This also includes any finance charges assessed to the customer.

Cost Center

Cost Center

This code represents the cost center, profit center, or other way of grouping of the organization.

Cost Center Description

The description for the specific cost center.

Cost Groups

This code represents the cost center, profit center, or other way of grouping of the organization.

Customers

Address 1

Customer address information from Accounts Receivable.

Address 2

Customer address information from Accounts Receivable.

City

Customer address information from Accounts Receivable.

Company Code

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

Country

Customer address information from Accounts Receivable.

Customer Code

This represents the specific customer.

Customer Type

The customer type is used to group customers by any desired classification.

Fax

Customer fax information from Accounts Receivable.

Main Contact Name

This is the customer's contact from Contract File Maintenance. When a customer has multiple contracts, only one contact will display.

Phone

Customer contact information from Accounts Receivable.

State/Province

Customer address information from Accounts Receivable.

Zip/Postal Code

Customer address information from Accounts Receivable.

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.

Sales Tax

Current Sales Tax Rate

The current rate for a particular sales tax code.

Sales Tax Code

This represents the customer sales tax code.

Sales Tax Description

The description for a particular sales tax.

Transaction Type

Transaction Type

This is the source of the billing. Includes A/R Invoices, Draw Requests, Time + Materials, Service Contract and Work Order.

VAT

Current VAT Rate

The current rate for the value-added-tax (VAT) code.

VAT Code

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

VAT Code Description

The description for the value-added-tax (VAT) code.