Custom Reports Datasets Cheat Sheet: Billing
Advance Billing Data
Advance Bill Invoice Date
Advance Bill Invoice Number
Advance Bill Invoice Total Amount
Advance Bill Other Sales Tax
Advance Bill Posting Date
Advance Bill Sales Tax Amount 1
Advance Bill Sales Tax Amount 2
Advance Bill Tax Description
Advance Bill Total Sales Tax
Advance Bill Unapplied Amount
Applied Amount
Applied Sales Tax Amount
Client ID
Client Name
Regular Invoice Date
Regular Invoice Number
Regular Invoice Open Amount
Regular Invoice Other Sales Tax
Regular Invoice Posting Date
Regular Invoice Sales Tax Amount
Regular Invoice Sales Tax Description
Regular Invoice Total Amount
Regular Invoice Total Sales Tax
Billing Data
Account Manager
Advance Bill Unapplied
Advance Billing Invoice
Amount Advance Billed
Amount Open
Applied Advance Billings
Approval Comments
AR Account
Bill To Address 1
Bill To Address 2
Bill To Address 3
Bill To City
Bill To Contact
Bill To Country
Bill To Postal Code
Bill To State
Billing Group Code
Billing Item
Campaign Name
Client Full Name
Client ID
Client Name
Client Primary Contact
Client Primary Contact Email
Client Primary Contact Phone 1
Client Primary Contact Phone 2
Client Project Number
Company ID
Company Name
Company Type
Date Paid
Default Client Sales Account
Department
Division Name
Downloaded
Due Date
Emailed
Estimate Total
Header Class ID
Header Class Name
Invoice Adv Bill Amount
Invoice Approver
Invoice Comment
Invoice Date
Invoice Number
Invoice Status
Invoice Total No Tax
Invoice Total Tax
Invoice Total With Tax
Invoice User Defined 1-10
Invoice Writeoff Amount
Line Class ID
Line Class Name
Line Client Project Number
Line Comments
Line Description
Line Item ID
Line Item Name
Line Project Description
Line Project Full Name
Line Project Name
Line Project Number
Line Project Type
Line Quantity
Line 1 Sales Tax Amount
Line 2 Sales Tax Amount
Line Sales Tax 1 Applied
Line Sales Tax 2 Applied
Line Sales Tax Total Amount
Line Total Amount
Line Type
Line Unit Amount
Office ID
Office Name
Opening Transaction
Parent Company
Parent Invoice
Posted
Posting Date
Printed
Printed Name
Product Name
Project Billing Status
Project Full Name
Project Name
Project Number
Sales GL Account
Sales GL Account Number
Sales Person
Task Description
Task ID
Task Name
Terms
Billing Transaction Detail Data
Account Manager
Advance Bill Unapplied
Advance Billing Invoice
Amount Advance Billed
Amount Open
Applied Advance Billings
Approval Comments
AR Account
Bill To Address 1
Bill To Address 2
Bill To Address 3
Bill To City
Bill To Contact
Bill To Country
Bill To Postal Code
Bill To State
Billed Comment
Billing Item
Billing Item ID
Campaign Name
Client Full Name
Client ID
Client Name
Client Primary Contact
Client Project Number
Company ID
Company Name
Company Type
Department
Division Name
Downloaded
Due Date
Emailed
Estimate Total
Header Class ID
Header Class Name
Invoice Adv Billed Amount
Invoice Approver
Invoice Comment
Invoice Date
Invoice Number
Invoice Status
Invoice User Define 1-10
Invoice Writeoff Amount
Line Class ID
Line Class Name
Line Client Project Number
Line Comments
Line Description
Line Project Full Name
Line Project Name
Line Project Number
Line Project Type
Line Quantity
Line Total Amount
Line Unit Amount
Media Estimate ID
Media Estimate Name
Office ID
Office Name
Order Number
Parent Company Name
Posted
Posting Date
Printed
Printed Name
Product Name
Project Full Name
Project Name
Project Number
Sales GL Account
Sales GL Account Number
Sales Person
Task Description
Task ID
Task Name
Task Type
Terms
Transaction Amount Billed
Transaction Billable Amount
Transaction Billed Difference
Transaction Comments
Transaction Date
Transaction Description
Transaction Item ID
Transaction Item Name
Transaction Project Full Name
Transaction Project Name
Transaction Project Number
Transaction Project Type
Transaction Quantity
Transaction Total Amount
Transaction Type
Transaction Unit Amount
Vendor ID
Vendor Name
Billing Transaction Detail Data with COGS
Account Manager
Advance Bill Unapplied
Advance Billing Invoice
Amount Advance Billed
Amount Open
Applied Advance Billed
Amount Open
Applied Advance Billings
Approval Comments
AR Account
AR Account Name
AR Account Number
Bill To Address1
Bill To Address2
Bill To Address3
Bill To City
Bill To Contact
Bill To Country
Bill To Postal Code
Bil To State
Billed Comment
Billing Item
Billing Item ID
Billing Title ID
Billing Title Name
Campaign ID
Campaign Name
Client Full Name
Client ID
Client Name
Client Primary Contact
Client Project Number
Company ID
Company Name
Company Type
Currency
Department
Division ID
Division Name
Downloaded
Due Date
Emailed
Estimate Total
Exchange Rate
Header Class ID
Header Class Name
Invoice Adv Bill Amount
Invoice Approver
Invoice Comment
Invoice Date
Invoice Number
Invoice Status
Invoice User Defined 1
Invoice User Defined 10
Invoice User Defined 2
Invoice User Defined 3
Invoice User Defined 4
Invoice User Defined 5
Invoice User Defined 6
Invoice User Defined 7
Invoice User Defined 8
Invoice User Defined 9
Invoice Writeoff Amount
Item Rate Sheet
Line Class ID
Line Class Name
Line Client Project Number
Line Comments
Line Description
Line Project Full Name
Line Project Name
Line Project Number
Line Project Type
Line Quantity
Line Retainer Name
Line Total Amount
Line Unit Amount
Media Estimate ID
Media Estimate name
Office ID
Office Name
Order Number
Parent Company Name
Parent Invoice
Posted
Posting Date
Printed
Printed Name
Product ID
Product Name
Project Full Name
Project Name
Project Number
Sales GL Account
Sales GL Account Number
Sales Person
Service Rate Sheet
Task Description
Task ID
Task Name
Task Type
Terms
Transaction Amount Billed
Transaction Billable Amount
Transaction Billed Difference
Transaction Comments
Transaction Date
Transaction Description
Transaction Item ID
Transaction Item Name
Transaction Item Type
Transaction Markup
Transaction Office ID
Transaction Office Name
Transaction Project Full Name
Transaction Project Name
Transaction Project Number
Transaction Project Type
Transaction Quantity
Transaction Total Amount
Transaction Total Cost Net Amount
Transaction Type
Transaction Unit Amount
Vendor ID
Vendor Name
Receipt Data
Account Manager
Check Amount
Check Date
Check Header Account Name
Check Header Account Number
Check Posting Date
Check Reference Number
Class ID
Class Name
Client Full Name
Client ID
Client Name
Company ID
Company Name
Invoice Amount Received
Invoice Comment
Invoice Date
Invoice Number
Invoice Posting Date
Line GL Account Name
Line GL Account Number
Non Billable Project
Project Billing Status
Project Name
Project Number
Project Type Name
Receipt Amount
Receipt Description
Sales Person