Versions Compared

Version Old Version 1 New Version Current
Changes made by

Joseph Yarborough

Anastasia Medovkina

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Invoice Report and the Line Item Report are available for download, for users with the appropriate permissions. These reports provide users with pertinent invoice information. Each of the reports are customizable. Users can configure the results using filters to only return the invoices of interest.

 

INVOICE REPORT

LINE ITEM REPORT

Address

Address

Amount

ApprCodeMajor

ApprCodeMajor

ApprCodeMinor

ApprCodeMinor

Approved By

Approved By

Approved By UserID

Approved By UserID

Approved Date

Approved Date

Batch ID

Batch ID

CAPITAL EX

CAPITAL EX

Category

Category

City

Comments

Comments

Completed Date

Completed Date

Currency

Currency

Freight

Freight

Hourly Rate

Inv. Date

Inv. Date

Inv. Transf. Date

Inv. Transf. Date

Inv.Status

Inv.Status

Inv.Text

Inv.Text

Inv.Total

Inv.Total

Invoice Number

Invoice Number

Labor Amount

Labor OffShore

Labor Type

Labor Material

Last Payment Date

Last Payment Date

Last Payment Number

Last Payment Number

Location ID

Location ID

Location Name

Location Name

Marked for Audit

Marked for Audit

Other

Material

Material Description

Other Charges - Amount

Others Charges - Comments

Other Charges - Description

Part # Units

Payment Amount

Payment Amount

Performed

PM-009

PM-009

PO #

PO #

Posted By

Posted By

Posted Date

Posted Date

Priority ProblemDescription

Provider

Price per Unit

Price per Unit Qty

Priority ProblemCode

ProblemDescription

Qty

Record Type

Region District Travel

Region District Provider

TagID

REPAIR APPROVAL CODE

REPAIR APPROVAL CODE

Sales Tax

Sales Tax

Sales Tax 2

Sales Tax 2

Service Type

Skill Level

Total Hours

Trade

Trade

Travel Amount

Travel Description

Travel OffShore

Units

UserID

Vendor ID

Vendor ID

W.O. Transf. Date

W.O. Transf. Date

W.O.# Tr.#

W.O.# Tr.#

30

30

# of Techs

From the Invoices List, you can download an Excel report on invoices. Since there are two types of invoices — standard and line-item invoices — that your providers may submit to you, you can export a report on standard and line-item invoices separately.

These reports provide you with pertinent invoice information, including invoice numbers, costs, related work order details, and more. You can customize your reports by adding the desired location note headers that will serve as column headers in your file. Besides, you can filter invoices by the required criteria before downloading the file. Thus, the exported file will include information only on those invoices you are most interested in.

Invoice reports that you can download from the Invoices ListImage Added

Fields Available on Invoice Reports

Below is the list of fields available on all standard invoice reports. However, based on your company account settings, you may have additional columns in your invoice report that are not described here, for example, additional approval codes or line-item GL codes.

Note

Please, contact your ServiceChannel representative should you need to change the decimal point (.) to decimal comma (,) on non-monetary amounts, such as: 

  • Hours and Duration 
  • Quantity Amounts 
  • Weight. 

Image Added


Expand
titleExpand the section to view information on the invoice standard report.


COLUMN IN A STANDARD REPORT DESCRIPTION
Location IDIdentification number of the location for which the invoiced work order was created
Location NameName of the location for which the invoiced work order was created
AddressMain address of the work order location
ProviderCompany name of the provider who performed the requested work and submitted the invoice
TradeTrade of the invoiced work order
W.O #Number of the invoiced work order
Tr. #Tracking number of the invoiced work order
CategoryCategory the invoiced work order belongs to
PriorityPriority of the invoiced work order
ProblemCodeProblem code of the invoiced work order
ProblemDescriptionIssue description provided upon creating a work order 
TagIDTag ID of the asset associated with the work order the invoice was created for
InvoiceNumberNumber of the invoice
Inv.DateInvoice date selected upon creating the invoice
Posted DateDate when the invoice was actually submitted — can be different from the invoice date 
Posted ByUser ID of a person who created the invoice
Inv.TextProblem resolution entered by the provider upon creating the invoice
Inv.StatusInvoice status at the moment of exporting the invoice report
Approved ByUsername of a person who approved the invoice
Approved By UserIDUser ID of a person who approved the invoice
Approve DateDate and time when the invoice was approved
Batch IDIdentification number of the payment batch the invoice is added to
ApprCodeMajorInvoice approval code, also known as GL code
ApprCodeMinorWhen ApprCodeMajor is empty, this column will contain an automatically generated invoice approval code
CurrencyCurrency of the invoice total amount
Inv.TotalTotal amount to be paid to the provider for the performed service
Vendor IDIdentification number given to the provider by their subscriber
Last Payment DateDate when the invoice was paid
Last Payment NumberPayment number that is generated after the invoice is paid
Payment Amount

Invoice amount that was paid

Note

Should you need to change the decimal point (.) to decimal comma (,) on monetary amounts, contact your ServiceChannel representative. 


CommentsComment the subscriber left upon taking action on the invoice. The comment is required upon rejecting an invoice but can be skipped upon approving or putting the invoice on hold.
Marked for AuditShows whether or not the invoice was marked for an audit via dashboard
Completed DateDate when the related work order was moved to a “Completed” status
RegionRegion of the location for which the invoiced work order was created
DistrictDistrict of the location for which the invoiced work order was created
Travel AmountAmount of travel charges
Labor Amount of labor charges
MaterialAmount of material charges
FreightAmount of freight charges
OtherAmount of other charges
Sales TaxSales tax amount
Sales Tax 2Invoice second tax amount (typically PST, QST, or HST for Canada). Multiple taxes are required for some Canadian locations.
Total IVR/Check-in HrsTotal time in hours a provider spent on site based on check-in/out records.
Invoice billed HrsTotal labor time in hours a provider specified in the invoice.
W.O. Transf. DateTransfer date of the work order for which the invoice was created
Inv. Transf. DateDate when the approved invoice was transferred to the client’s accounting department for payment. Learn more about transferred invoices.
PO #Purchase order number of the invoiced work order
Rejected DateThe date when the invoice was rejected. If the invoice was not rejected, the field under the column is empty.



Expand
titleExpand this section to view information on the line-item invoice report.


COLUMN IN A LINE-ITEM REPORTDESCRIPTION
Location IDIdentification number of the location for which the invoiced work order was created
Location NameName of the location for which the invoiced work order was created
AddressMain address of the work order location
RegionRegion of the location for which the invoiced work order was created
DistrictDistrict of the location for which the invoiced work order was created
ProviderCompany name of the provider who performed the requested work and submitted an invoice
Vendor IDIdentification number given to the provider by their subscriber
TradeTrade of the invoiced work order
W.O #Number of the invoiced work order
Tr. #Tracking number of the invoiced work order
PO #Purchase order number of the invoiced work order
CategoryCategory the invoiced work order belongs to
PriorityPriority of the invoiced work order
ProblemCodeProblem code of the invoiced work order
ProblemDescriptionIssue description provided upon creating a work order 
InvoiceNumberNumber of the invoice
Completed DateDate when the related work order was moved to a “Completed” status
Inv.DateInvoice date selected upon creating the invoice
Posted DateDate when the invoice was actually submitted — can be different from the invoice date 
Posted ByUser ID of a person who created the invoice
Inv.TextProblem resolution entered by the provider upon creating the invoice
Inv.StatusInvoice status at the moment of exporting the invoice report
Approved ByUsername of a person who approved the invoice
Approved By UserIDUser ID of a person who approved the invoice
Approve DateDate and time when the invoice was approved
Batch IDIdentification number of the payment batch the invoice is added to
ApprCodeMajorInvoice approval code, also known as GL code
ApprCodeMinorWhen ApprCodeMajor is empty, this column will contain an automatically generated invoice approval code
CurrencyCurrency of invoice total amount
Inv.Total

Total amount to be paid to the provider for the performed service

Note

Should you need to change the decimal point (.) to decimal comma (,) on monetary amounts, contact your ServiceChannel representative. 


Last Payment DateDate when the invoice was paid
Last Payment NumberPayment number that is generated after the invoice is paid
Payment AmountInvoice amount that was paid
CommentsComment the subscriber left upon taking action on the invoice. The comment is required upon rejecting an invoice but can be skipped upon approving or putting the invoice on hold.
Marked for AuditShows whether or not the invoice was marked for an audit via dashboard
Record TypeThis field identifies if a spreadsheet row is for line items or for a summary. Learn more about the row types.
Skill LevelSkill level of the employee who performed the service, for example, Supervisor, Technician, or Helper
Labor TypeLabor type of the employee who performed the service, for example, Regular, Overtime, or Double Time
# of TechsNumber of employees of the specified skill level and labor type who worked on the service request
Hourly RateCost per one hour for the specified skill level and labor type
Total HoursNumber of hours spent on-site for the entered skill level, labor type, and hourly rate
Labor AmountTotal amount of labor charges
Travel AmountTotal amount of travel charges
Material DescriptionTextual description of the material used
Part #Part (serial or manufacturer) number for a material line item
UnitsUnit of measure, for example, each, box, feet
Price per UnitUnit price
QtyQuantity of the material used
MaterialTotal amount of material charges
FreightTotal amount of freight charges
Other Charges - DescriptionDescription of a charge that belongs to the “Other” type of costs. For example, Discount, Management Fee, etc.
Other Charges - CommentsComments on a charge that belongs to the “Other” type of costs
Other Charges - AmountAmount of a charge that belongs to the “Other” type of costs
Additional Approval Code (Name) Additional Approval Code (AAC) Name. It has the AAC name in the title as you configured in the Admin module.
For example, Internal Work, PM-006, and others. 
Sales TaxSales tax amount
Sales Tax 2Invoice second tax amount (typically PST, QST, or HST for Canada). Multiple taxes are required for some Canadian locations.
W.O. Transf. DateTransfer date of the work order for which the invoice was created
Inv. Transf. DateDate when the approved invoice was transferred to the client’s accounting department for payment. Learn more about transferred invoices.
Rejected DateThe date when the invoice was rejected. If the invoice was not rejected, the field under the column is empty.


Downloading Invoice Reports

When necessary, you can download the required invoice report to your device.

  • Click the  Invoices link.
    Image Removed
    • Panel
    bgColor#F9F9F9
    titleColor#0e3367
    titleBGColor#EAEAEA
    borderStylenone
    title⦿ How to Download an Invoice Reports
    Report
    1. On the Invoices screen, page, manually select the invoices that you want to include, or use the filters to return the desired Invoices.
      Image Removed
      In the example below, the Date Range filter has been set to One Year and the Trade filter has been set to the trade of  Audio Visual.
      Image Removed      hone in on the desired invoices.
    2. From the Download / Upload drop-down menu, select one of the Invoice Reportsthe report you want to download.
      Image Removed
      On the pop-up screen, Invoice ReportsImage Added
    3. (Optional) In the overlay that appears, select the Weather Type checkbox to add the corresponding field to the report and select the Location Notes that should be included in the report.
      Image RemovedDownload Invoice ReportImage Added
    4. Click the Download button to download the selected report.Open the downloaded report(s) in your preferred spreadsheet readerDownload. The selected report is downloaded to your device.


    Live Search
    spaceKeySCU
    additionalpage excerpt
    placeholderSearch our Knowledge Base
    typepage

    Panel
    titleColor#ffffff
    titleBGColor#5fa7d0
    borderStylegroove
    titleIn this Article

    Table of Contents
    maxLevel3
    minLevel2
    indent20px

    Panel
    titleColorwhite
    titleBGColor#75a346
    titleRelated Articles

    Filter by label (Content by label)
    showLabelsfalse
    max8
    showSpacefalse
    sorttitle
    cqllabel = in ( "label" , "invoice" , "invoiceadmin" , "invoicerates" , "invoicesettings" ) and space = currentSpace ( )