VCG will provide complimentary data export services upon request. Please allow up to five (5) business days for us to complete the request. To submit your request, please email VCG Support.
Invoice data is provided in three (3) separate CSV files
Invoices
Invoice Taxes
Invoice Line Items
Each of the individual files will include a unique alphanumeric invoiceID value that can be cross-referenced among the three CSV files. A highlighted field in the list below indicates that it can be cross-referenced with other unique alphanumeric data in other related CSV files provided by VCG
The following fields are provided in each of the above referenced files:
Invoices
customerID
locationid
jobID
invoiceID
jobname
jobInternalnotes
jobaddress
jobcity
joblocality
jobpostal
jobpostalext
jobcountry
jobaddress2
shippingaddress
shippingcity
shippinglocality
shippingpostal
shippingpostalext
shippingcountry
shippingaddress2
date_added
addedBy
jobType
stage
contactFirstname
contactLastName
contactPhone
contactPhoneext
contactEmail
contactmobile
invoiceDate
invoiceDueDate
invoiceExpiry
invoiceNo
ownerID
salesRepUserID
invoiceArchived
terms
notes
subtotal
tax
shipping
deposit
deposit_type
lastupdated
lastupdatedby
term
invoice_id
PONumber
trackingno
Invoice Taxes
invoiceID
tax
rate
lastupdated
Invoice Line Items
invoiceID
invoiceitemID
inventoryID
item
sku
invoice_text
description
internal_notes
taxable
discount
discount_percentage
unitcost
minprice
type
dimension
height
width
hourly
qty
markup
shipping
quantity
lastupdated
lastupdatedby