WorkGuru Document Template
Non-Table Fields
These fields can be used anywhere on the relevant project template. Please Note: All merge fields are case sensitive.
The fields are related to the type of document they are assigned to, but is generally hierarchical: Quote/Purchase Order -> Project -> Invoice. (E.g. a Project Custom Field can't be displayed on a Quote). Custom Fields availability dependent on what the transaction type the field is assigned to and the relevant document type.
| Merge Field | Merge Field Name | Notes | QUO | INV | SS | PRO | PJ | PO | PG | ASS | CN |
| Asset | [AssetName] | | Y | Y | N | Y | Y | N | N | Y | N |
| Asset | [AssetSerialNumber] | | Y | Y | N | Y | Y | N | N | Y | N |
| Asset | [AssetType] | | Y | Y | N | Y | Y | N | N | Y | N |
| Business | [BusinessAddress] | | Y | Y | Y | Y | Y | Y | Y | N | Y |
| Business | [BusinessLegalName] | | Y | Y | Y | Y | Y | Y | Y | N | Y |
| Business | [BusinessTaxNumber] | | Y | Y | Y | Y | Y | Y | Y | N | Y |
| Client | [ClientABN] | Billable Client | Y | Y | Y | Y | Y | N | Y | Y | Y |
| Client | [ClientAddress1] | Billable Client | Y | Y | Y | Y | Y | N | Y | Y | Y |
| Client | [ClientAddress2] | Billable Client | Y | Y | Y | Y | Y | N | Y | Y | Y |
| Client | [ClientCity] | Billable Client | Y | Y | Y | Y | Y | N | Y | Y | Y |
| Client | [ClientCreditDays] | Credit Terms | Y | Y | Y | Y | Y | N | N | Y | Y |
| Client | [ClientCreditLimit] | | Y | Y | Y | Y | Y | N | N | Y | Y |
| Client | [ClientEmail] | Billable Client | Y | Y | Y | Y | Y | N | Y | Y | Y |
| Client | [ClientFax] | Billable Client | Y | Y | Y | Y | Y | N | Y | Y | Y |
| Client | [ClientName] | Billable Client | Y | Y | Y | Y | Y | N | Y | Y | Y |
| Client | [ClientPhone] | Billable Client | Y | Y | Y | Y | Y | N | Y | Y | Y |
| Client | [ClientPostcode] | Billable Client | Y | Y | Y | Y | Y | N | Y | Y | Y |
| Client | [ClientPurchaseOrder] | Billable Client | N | Y | Y | Y | Y | N | Y | Y | Y |
| Client | [ClientState] | Billable Client | Y | Y | Y | Y | Y | N | Y | Y | Y |
| Client | [ClientWebsite] | Billable Client | Y | Y | Y | Y | Y | N | Y | Y | Y |
| Credit Note | [CreditNoteDate] | | N | N | N | N | N | N | N | N | Y |
| Credit Note | [CreditNoteDescription] | | N | N | N | N | N | N | N | N | Y |
| Credit Note | [CreditNoteNumber] | | N | N | N | N | N | N | N | N | Y |
| Credit Note | [CreditNoteSubTotal] | | N | N | N | N | N | N | N | N | Y |
| Credit Note | [CreditNoteTaxTotal] | | N | N | N | N | N | N | N | N | Y |
| Credit Note | [CreditNoteTotal] | | N | N | N | N | N | N | N | N | Y |
| Custom Fields | [CustomFieldName] | | Y* | Y* | N | Y* | Y* | Y* | Y* | Y* | N |
| Invoice | [AmountOutstanding] | Total minus Payments | N | Y | N | N | N | N | N | N | N |
| Invoice | [InvoiceDate] | | N | Y | N | N | N | N | N | N | N |
| Invoice | [InvoiceDescription] | | N | Y | N | N | N | N | N | N | N |
| Invoice | [InvoiceDueDate] | | N | Y | N | N | N | N | N | N | N |
| Invoice | [InvoiceNumber] | | N | Y | N | N | N | N | N | N | N |
| Invoice | [InvoiceReference] | | N | Y | N | N | N | N | N | N | N |
| Invoice | [InvoiceSubTotal] | | N | Y | N | N | N | N | N | N | N |
| Invoice | [InvoiceTotal] | | N | Y | N | N | N | N | N | N | N |
| Invoice | [InvoiceTotalTax] | | N | Y | N | N | N | N | N | N | N |
| Invoice | [ProjectClientABN] | Project Client | N | Y | N | N | N | N | N | N | N |
| Invoice | [ProjectClientAddress1] | Project Client | N | Y | N | N | N | N | N | N | N |
| Invoice | [ProjectClientAddress2] | Project Client | N | Y | N | N | N | N | N | N | N |
| Invoice | [ProjectClientName] | Project Client | N | Y | N | N | N | N | N | N | N |
| Invoice | [ProjectClientPostcode] | Project Client | N | Y | N | N | N | N | N | N | N |
| Invoice | [ProjectClientState] | Project Client | N | Y | N | N | N | N | N | N | N |
| Project | [ProjectContactEmail] | | N | Y | N | Y | Y | N | N | N | Y |
| Project | [ProjectContactName] | | N | Y | N | Y | Y | N | N | N | Y |
| Project | [ProjectContactPhone1] | | N | Y | N | Y | Y | N | N | N | Y |
| Project | [ProjectContactPhone2] | | N | Y | N | Y | Y | N | N | N | Y |
| Project | [ProjectDescription] | | N | Y | N | Y | Y | N | N | N | Y |
| Project | [ProjectDueDate] | | N | Y | N | Y | Y | N | N | N | Y |
| Project | [ProjectManager] | | N | Y | N | Y | Y | N | N | N | Y |
| Project | [ProjectName] | | N | Y | N | Y | Y | N | N | N | Y |
| Project | [ProjectNumber] | | N | Y | N | Y | Y | N | N | N | Y |
| Project | [ProjectStartDate] | | N | Y | N | Y | Y | N | N | N | Y |
| Project | [ProjectTax] | | N | N | N | Y | Y | N | N | N | Y |
| Project | [ProjectTotal] | | N | N | N | Y | Y | N | N | N | Y |
| Project | [ProjectTotalForecastTime] | | N | N | N | Y | Y | N | N | N | Y |
| Project | [ProjectTotalIncTax] | | N | N | N | Y | Y | N | N | N | Y |
| Purchase Order | [PurchaseOrderDate] | | N | N | N | N | N | Y | N | N | Y |
| Purchase Order | [PurchaseOrderDeliveryAddress1] | | N | N | N | N | N | Y | N | N | Y |
| Purchase Order | [PurchaseOrderDeliveryAddress2] | | N | N | N | N | N | Y | N | N | Y |
| Purchase Order | [PurchaseOrderDeliveryInstructions] | | N | N | N | N | N | Y | N | N | Y |
| Purchase Order | [PurchaseOrderDescription] | | N | N | N | N | N | Y | N | N | Y |
| Purchase Order | [PurchaseOrderExpectedDate] | | N | N | N | N | N | Y | N | N | Y |
| Purchase Order | [PurchaseOrderNumber] | | N | N | N | N | N | Y | N | N | Y |
| Purchase Order | [PurchaseOrderProjectNumber] | | N | Y | N | N | N | N | N | N | Y |
| Purchase Order | [PurchaseOrderState] | | N | N | N | N | N | Y | N | N | Y |
| Purchase Order | [PurchaseOrderSubTotal] | | N | N | N | N | N | Y | N | N | Y |
| Purchase Order | [PurchaseOrderSuburb] | | N | N | N | N | N | Y | N | N | Y |
| Purchase Order | [PurchaseOrderTaxTotal] | | N | N | N | N | N | Y | N | N | Y |
| Purchase Order | [PurchaseOrderTotal] | | N | N | N | N | N | Y | N | N | Y |
| Purchase Order | [PurchaseOrderVolume] | | N | N | N | N | N | Y | N | N | N |
| Purchase Order | [PurchaseOrderWeight] | | N | N | N | N | N | Y | N | N | N |
| Quote | [QuoteContactEmail] | | Y | N | N | N | N | N | N | N | N |
| Quote | [QuoteContactFirstName] | | Y | N | N | N | N | N | N | N | N |
| Quote | [QuoteContactFullName] | | Y | N | N | N | N | N | N | N | N |
| Quote | [QuoteContactLastName] | | Y | N | N | N | N | N | N | N | N |
| Quote | [QuoteContactPhone] | | Y | N | N | N | N | N | N | N | N |
| Quote | [QuoteDate] | | Y | N | N | Y | Y | N | N | N | N |
| Quote | [QuoteDescription] | | Y | N | N | Y | Y | N | N | N | N |
| Quote | [QuoteExpiryDate] | | Y | N | N | Y | Y | N | N | N | N |
| Quote | [QuoteName] | | Y | N | N | Y | Y | N | N | N | N |
| Quote | [QuoteNumber] | | Y | N | N | Y | Y | N | N | N | N |
| Quote | [QuoteRecommendedJobDate] | | Y | N | N | Y | Y | N | N | N | N |
| Quote | [QuoteTax] | | Y | N | N | Y | Y | N | N | N | N |
| Quote | [QuoteTotal] | | Y | N | N | Y | Y | N | N | N | N |
| Quote | [QuoteTotalIncTax] | | Y | N | N | Y | Y | N | N | N | N |
| Quote | [QuoteVolume] | | Y | N | N | N | N | N | N | N | N |
| Quote | [QuoteWeight] | | Y | N | N | N | N | N | N | N | N |
| Stock Sale | [StockSaleContactFirstName] | | N | Y | Y | N | N | N | N | N | Y |
| Stock Sale | [StockSaleContactFullName] | | N | Y | Y | N | N | N | N | N | Y |
| Stock Sale | [StockSaleContactLastName] | | N | Y | Y | N | N | N | N | N | Y |
| Stock Sale | [StockSaleContactPhone] | | N | Y | Y | N | N | N | N | N | Y |
| Stock Sale | [StockSaleDate] | | N | Y | Y | N | N | N | N | N | Y |
| Stock Sale | [StockSaleDescription] | | N | Y | Y | N | N | N | N | N | Y |
| Stock Sale | [StockSaleDispatchDate] | | N | Y | Y | N | N | N | N | N | Y |
| Stock Sale | [StockSaleNumber] | | N | Y | Y | N | N | N | N | N | Y |
| Stock Sale | [StockSaleTax] | | N | Y | Y | N | N | N | N | N | Y |
| Stock Sale | [StockSaleTotal] | | N | Y | Y | N | N | N | N | N | Y |
| Stock Sale | [StockSaleTotalIncTax] | | N | Y | Y | N | N | N | N | N | Y |
| Subtotals | [ProductsSubTotal] | | Y | Y | Y | Y | Y | Y | N | N | Y |
| Subtotals | [ProductsTaxTotal] | | Y | Y | Y | Y | Y | Y | N | N | Y |
| Subtotals | [ProductsTotal] | | Y | Y | Y | Y | Y | Y | N | N | Y |
| Subtotals | [TaskSubTotal] | | Y | Y | N | Y | Y | Y | N | N | Y |
| Subtotals | [TaskTaxTotal] | | Y | Y | N | Y | Y | Y | N | N | Y |
| Subtotals | [TaskTotal] | | Y | Y | N | Y | Y | Y | N | N | Y |
| Supplier | [SupplierABN] | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierAddress1] | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierAddress2] | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierCity] | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierContactEmail] | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierContactName] | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierContactPhone1 | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierContactPhone2 | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierEmail] | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierFax] | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierName] | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierPhone] | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierPostcode] | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierState] | | N | N | N | N | N | Y | N | N | Y |
| Supplier | [SupplierWebsite] | | N | N | N | N | N | Y | N | N | Y |
| User | [UserEmail] | Current Logged in WorkGuru User | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| User | [UserFirstName] | Current Logged in WorkGuru User | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| User | [UserFullName] | Current Logged in WorkGuru User | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| User | [UserLastName] | Current Logged in WorkGuru User | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| User | [UserPhone] | Current Logged in WorkGuru User | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| Warehouse | [WarehouseAddress1] | | N | Y | Y | Y | Y | Y | N | N | N |
| Warehouse | [WarehouseAddress2] | | N | Y | Y | Y | Y | Y | N | N | N |
| Warehouse | [WarehouseName] | | N | Y | Y | Y | Y | Y | N | N | N |
| Warehouse | [WarehousePostcode] | | N | Y | Y | Y | Y | Y | N | N | N |
| Warehouse | [WarehouseState] | | N | Y | Y | Y | Y | Y | N | N | N |
| Warehouse | [WarehouseSuburb] | | N | Y | Y | Y | Y | Y | N | N | N |
Table Fields
The following fields are required to be used within a table on the document, so WorkGuru can recur the rows to match the number of line items on the transaction. Due to this, the table will change in size on the document, so that will need to factored into the document template layout.
The process to setup the tables correctly by ensuring they have a Header and the correct Alt-Text Description is available here.
Products
Tasks
| Merge Field | Merge Field Name | Notes | QUO | INV | SS | PRO | PO | PG | ASS | CN |
| Task | [TaskAmount] | Excl GST Total | Y | Y | Y | Y | N | Y | N | Y |
| Task | [TaskCostPrice] | | N | N | N | N | N | N | N | Y |
| Task | [TaskDescription] | | Y | Y | Y | Y | N | Y | N | Y |
| Task | [TaskForecast] | Forecast/Quoted Amount | N | Y | Y | N | N | N | N | N |
| Task | [TaskInvoicedAmount] | | N | Y | N | N | N | N | | N |
| Task | [TaskInvoicedPercentage] | Percentage of Task Invoiced in Total | N | Y | Y | N | N | N | N | N |
| Task | [TaskName] | | Y | Y | Y | Y | N | Y | N | Y |
| Task | [TaskPercentage] | Percentage of Task Invoiced on this invoice | N | Y | Y | N | N | N | N | N |
| Task | [TaskPrevInvoicedAmount] | | N | Y | N | N | N | N | N | N |
| Task | [TaskQuantity] | | Y | Y | Y | Y | N | Y | N | Y |
| Task | [TaskRate] | | Y | Y | Y | Y | N | Y | N | Y |
| Task | [TaskRemaining] | Amount remaining on Task after this Invoice | N | Y | Y | N | N | N | N | N |
| Task | [TaskStaff] | | N | N | N | Y | N | N | N | N |
| Task | [TaskTaxAmount] | | Y | Y | Y | Y | N | Y | N | Y |
| Task | [TaskTaxName] | | Y | Y | Y | Y | N | Y | N | Y |
| Task | [TaskTotalAmount] | Inc GST Total | Y | Y | Y | Y | N | Y | N | Y |
| Task | [TaskUnitTax] | | Y | Y | N | N | N | N | N | Y |
Timesheets
| Merge Field | Merge Field Name | Notes | QUO | INV | SS | PRO | PO | PG | ASS | CN |
| Invoice Timesheet | [StaffName] | | N | Y | N | N | N | N | N | N |
| Invoice Timesheet | [TSDate] | | N | Y | N | N | N | N | N | N |
| Invoice Timesheet | [TSEndTime] | | N | Y | N | N | N | N | N | N |
| Invoice Timesheet | [TSLength] | | N | Y | N | N | N | N | N | N |
| Invoice Timesheet | [TSNote] | | N | Y | N | N | N | N | N | N |
| Invoice Timesheet | [TSStartTime} | | N | Y | N | N | N | N | N | N |
| Invoice Timesheet | [TSTask] | | N | Y | N | N | N | N | N | N |
Purchases
Purchases fields are used in a table on invoice templates to display billable disbursement lines that have been invoiced.
| Merge Field | Merge Field Name | Notes | QUO | INV | SS | PRO | PO | PG | ASS | CN |
| PO Disbursement | [POAmount] | Ex GST Total | N | Y | N | N | N | N | N | N |
| PO Disbursement | [PODescription] | | N | Y | N | N | N | N | N | N |
| PO Disbursement | [POName] | | N | Y | N | N | N | N | N | N |
| PO Disbursement | [POQuantity] | | N | Y | N | N | N | N | N | N |
| PO Disbursement | [PORate] | | N | Y | N | N | N | N | N | N |
| PO Disbursement | [POTaxAmount] | | N | Y | N | N | N | N | N | N |
| PO Disbursement | [POTaxName] | | N | Y | N | N | N | N | N | N |
| PO Disbursement | [POTotalAmount] | Inc GST Total | N | Y | N | N | N | N | N | N |
| PO Disbursement | [POUnitAmount] | | N | Y | N | N | N | N | N | N |
| PO Disbursement | [POUnitTax] | | N | Y | N | N | N | N | N | N |
PurchaseLines
PurchaseLine fields are used in a table on project briefs to display project purchase order line item information.
| Merge Field | Merge Field Name | Notes | QUO | INV | SS | PRO | PO | PG | ASS | CN |
| PO Line | [PODescription] | | N | N | N | Y | N | N | N | N |
| PO Line | [POName] | | N | N | N | Y | N | N | N | N |
| PO Line | [PONumber] | | N | N | N | Y | N | N | N | N |
| PO Line | [POOrderQuantity] | | N | N | N | Y | N | N | N | N |
| PO Line | [POQuantity] | | N | N | N | Y | N | N | N | N |
| PO Line | [PORecievedQuantity] | | N | N | N | Y | N | N | N | N |
| PO Line | [POSku] | | N | N | N | Y | N | N | N | N |
| PO Line | [POSupplier] | | N | N | N | Y | N | N | N | N |
Payments
The payments table can be used used to display payment type and amounts on invoices. Usually used in conjunction with the [AmountOutstanding] field to show balance owing.
| Merge Field | Merge Field Name | Notes | QUO | INV | SS | PRO | PO | PG | ASS | CN |
| Payments | [PaymentAmount] | | N | Y | N | N | N | N | N | N |
| Payments | [PaymentDate] | | N | Y | N | N | N | N | N | N |
| Payments | [PaymentType] | | N | Y | N | N | N | N | N | N |
