Missing Toolkit: Templates logo
Missing Toolkit Templates
↑ ↓ navigate ↵ open esc close

Placeholders

Placeholders are tokens in your template that get replaced with live data when you generate a document (Word or PDF). They use the ${PLACEHOLDER_NAME} syntax.

Viewing available placeholders

On the Templates page, click the Available Placeholders button to open a reference panel. Placeholders are grouped by:

  1. Data source (e.g., QuickBooks Online) — with connection status
  2. Entity type (e.g., Invoice, Estimate, Purchase Order) — collapsible sections
  3. Field group (e.g., Invoice, Customer, Line Items) — organized by category

QuickBooks Online — Invoice

Invoice

Placeholder Description
${INVOICE_NUMBER} The invoice document number
${INVOICE_DATE} The transaction date
${DUE_DATE} The payment due date
${SHIP_DATE} The ship, delivery or supply date
${SHIP_VIA} The shipping method (Ship via)
${TRACKING_NUMBER} The shipment tracking number
${PAYMENT_TERMS} Payment terms (e.g. Net 30)
${SUBTOTAL} Subtotal before tax
${TAX_AMOUNT} Total tax amount
${TAX_RATE} The tax rate, such as 7%. Several rates are added together when they were charged on the same amount, and print blank when they were not
${TOTAL_AMOUNT} Total invoice amount
${CURRENCY} The currency code of the amounts, such as EUR
${CURRENCY_SYMBOL} The symbol of the currency, such as $ or €
${BALANCE_DUE} Remaining balance due
${PAYMENT_STATUS} Paid, Partially paid or Unpaid. Not a QuickBooks field: worked out by comparing the balance due with the total
${AMOUNT_PAID} Payments and credits applied so far: the total less the balance due
${PAYMENT_COUNT} How many payments have been applied. A credit applied in QuickBooks counts as one
${LATEST_PAYMENT_DATE} Date of the most recent payment or credit applied
${LATEST_PAYMENT_AMOUNT} How much of the most recent payment went to this invoice
${LATEST_PAYMENT_METHOD} Payment method of the most recent payment, such as Check. Blank for a credit
${LATEST_PAYMENT_REF} Reference or check number of the most recent payment
${PAID_DATE} Date of the most recent payment, only once the invoice is paid in full. Blank until then
${MEMO} Private memo/notes
${CUSTOMER_MESSAGE} Message displayed on invoice

Tax Line Items — Row Placeholders

Placeholder Description
${TAX_LINE_NAME} The tax rate's name in QuickBooks, such as PST (BC) Sales or Tucson City
${TAX_LINE_DESCRIPTION} The tax rate's description in QuickBooks, such as PST (BC). QuickBooks Canada prints this one
${TAX_LINE_RATE} The rate as a percentage, such as 7%
${TAX_LINE_TAXABLE} The amount this tax was charged on
${TAX_LINE_AMOUNT} The tax charged
${TAX_LINE_AGENCY} The tax agency this tax is paid to
${TAX_LINE_NUMBER} Your registration number with that agency, from QuickBooks

Tax Breakdown

Each tax you charge gets its own set of placeholders, named after the tax in your QuickBooks sales tax settings. These examples are from a company in British Columbia that charges GST and PST. They are not a complete list: a company in California sees ${TAX_CALIFORNIA_AMOUNT} instead. To see the placeholders for your own taxes, open any invoice in Missing Toolkit: Templates and look under Tax Breakdown. See Tax breakdown.

Placeholder Description
${TAX_GST_AMOUNT} GST tax amount
${TAX_GST_RATE} GST rate as a percentage (blank when this tax is not on the record)
${TAX_GST_TAXABLE} Amount GST was charged on
${TAX_GST_NUMBER} Your GST registration number from QuickBooks
${TAX_PST_BC_AMOUNT} PST (BC) tax amount
${TAX_PST_BC_RATE} PST (BC) rate as a percentage (blank when this tax is not on the record)
${TAX_PST_BC_TAXABLE} Amount PST (BC) was charged on
${TAX_PST_BC_NUMBER} Your PST (BC) registration number from QuickBooks

Customer

Placeholder Description
${CUSTOMER_NAME} Customer display name
${CUSTOMER_COMPANY} Customer company name
${CUSTOMER_FIRST_NAME} First name of the customer's contact
${CUSTOMER_LAST_NAME} Last name of the customer's contact
${CUSTOMER_TAX_ID} Customer tax registration number
${CUSTOMER_PHONE} Customer phone number
${CUSTOMER_MOBILE} Customer mobile number
${CUSTOMER_WEBSITE} Customer website
${CUSTOMER_NOTES} Customer notes
${BILLING_ADDRESS} Billing address as QuickBooks stores it, on multiple lines. Does not include the name; put CUSTOMER_NAME above it
${BILLING_LINE1} Billing address line 1. If the address was typed into the QuickBooks address box, this is the first line typed
${BILLING_LINE2} Billing address line 2. If the address was typed into the QuickBooks address box, this is the second line typed
${BILLING_CITY} Billing city. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_STATE} Billing state/province. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_ZIP} Billing postal code. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_CITY_LINE} Billing city, state and postal code on one line. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${SHIPPING_ADDRESS} Shipping address as QuickBooks stores it, on multiple lines. Does not include the name; put CUSTOMER_NAME above it
${SHIPPING_LINE1} Shipping address line 1. If the address was typed into the QuickBooks address box, this is the first line typed
${SHIPPING_LINE2} Shipping address line 2. If the address was typed into the QuickBooks address box, this is the second line typed
${SHIPPING_CITY} Shipping city. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${SHIPPING_STATE} Shipping state/province. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${SHIPPING_ZIP} Shipping postal code. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${SHIPPING_CITY_LINE} Shipping city, state and postal code on one line. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${CUSTOMER_EMAIL} Customer email address
${CUSTOMER_EMAIL_CC} Addresses copied (Cc) when this record is emailed, as entered on it in QuickBooks
${CUSTOMER_EMAIL_BCC} Addresses blind copied (Bcc) when this record is emailed, as entered on it in QuickBooks

Line Items — Auto Table

Placeholder Description
${LINE_ITEMS} Generates a complete table with all line items (do not use inside your own table)

Line Items — Row Placeholders

Placeholder Description
${LINE_NUMBER} Line number as QuickBooks numbers the lines (1 for the first)
${LINE_TAX_CODE} The line's tax code in QuickBooks, such as GST/PST BC or Zero-rated
${LINE_NAME} Product/service name (place in a table row — row will be cloned per item)
${LINE_DESCRIPTION} Description (place in a table row — row will be cloned per item)
${LINE_SERVICE_DATE} Service date
${LINE_SKU} SKU
${LINE_QUANTITY} Quantity
${LINE_RATE} Unit price
${LINE_AMOUNT} Total amount

Your Company

Placeholder Description
${COMPANY_NAME} Your company name
${COMPANY_ADDRESS} Your company address as QuickBooks stores it, on multiple lines. Does not include the name; put COMPANY_NAME above it
${COMPANY_LINE1} Your company address line 1, as in your QuickBooks company settings
${COMPANY_LINE2} Your company address line 2, as in your QuickBooks company settings
${COMPANY_CITY} Your company city. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_STATE} Your company state or province. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_ZIP} Your company postal code. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_CITY_LINE} Your company city, state and postal code on one line. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_PHONE} Your company phone number
${COMPANY_EMAIL} Your company email address
${COMPANY_WEBSITE} Your company website
${COMPANY_TAX_ID} Your company tax ID, from Team settings

Box Labels

Placeholder Description
${BOX_NUMBER} This box's number within its line item, 1 for the first (fills on a template set to one label per box)
${BOX_COUNT} How many boxes the line item ships in
${BOX_QUANTITY} Units in this box
${BOX_TOTAL_QUANTITY} Units across all of the line item's boxes

${SHIP_VIA}, ${SHIP_DATE} and ${TRACKING_NUMBER} fill in from the shipping fields on the invoice. QuickBooks only shows those fields once shipping is turned on under Account and Settings > Sales, so they're blank until it is.

${CUSTOMER_FIRST_NAME} and ${CUSTOMER_LAST_NAME} come from the name on the customer record in QuickBooks, which is the contact person rather than the display name. Put them side by side for a contact line: ${CUSTOMER_FIRST_NAME} ${CUSTOMER_LAST_NAME}.

${PAYMENT_STATUS} prints Paid, Partially paid or Unpaid. QuickBooks Online doesn't send a status for invoices, so this isn't a QuickBooks field. We work it out by comparing the invoice's balance due with its total:

  • Paid when nothing is owed. That includes an invoice settled with a deposit or a credit memo, and an invoice with a total of zero.
  • Partially paid when some of the total is still owed.
  • Unpaid when the whole total is still owed.

The status reflects the payments recorded in QuickBooks when you generate the document. A payment recorded afterwards doesn't change a document you already have, so generate it again. A voided invoice has a balance and total of zero, so it prints Paid.

Invoices also have placeholders for the payments applied to them:

  • ${AMOUNT_PAID} is the total less the balance due.
  • ${PAYMENT_COUNT} is how many payments have been applied.
  • ${LATEST_PAYMENT_DATE}, ${LATEST_PAYMENT_AMOUNT}, ${LATEST_PAYMENT_METHOD} and ${LATEST_PAYMENT_REF} describe the most recent one. The amount is the part of that payment that went to this invoice.
  • ${PAID_DATE} is the date of the most recent payment, but only once the invoice is paid in full. Until then it's blank.

A credit memo applied to an invoice counts as a payment. It has no method or reference, so those print blank. For a "PAID" stamp with the date, use ${PAYMENT_STATUS|when:Paid|upper} ${PAID_DATE}. Both are blank until the invoice is paid in full. ${LATEST_PAYMENT_DATE} would print on a partly paid invoice too.

QuickBooks Online — Estimate

Estimate

Placeholder Description
${ESTIMATE_NUMBER} The estimate document number
${ESTIMATE_DATE} The transaction date
${EXPIRATION_DATE} The estimate expiration date
${SHIP_DATE} The ship, delivery or supply date
${SHIP_VIA} The shipping method (Ship via)
${TRACKING_NUMBER} The shipment tracking number
${ESTIMATE_STATUS} Status (Pending, Accepted, Closed, Rejected)
${PAYMENT_TERMS} Payment terms (e.g. Net 30)
${SUBTOTAL} Subtotal before tax
${TAX_AMOUNT} Total tax amount
${TOTAL_AMOUNT} Total estimate amount
${CURRENCY} The currency code of the amounts, such as EUR
${CURRENCY_SYMBOL} The symbol of the currency, such as $ or €
${MEMO} Private memo/notes
${CUSTOMER_MESSAGE} Message displayed on estimate

Tax Line Items — Row Placeholders

Placeholder Description
${TAX_LINE_NAME} The tax rate's name in QuickBooks, such as PST (BC) Sales or Tucson City
${TAX_LINE_DESCRIPTION} The tax rate's description in QuickBooks, such as PST (BC). QuickBooks Canada prints this one
${TAX_LINE_RATE} The rate as a percentage, such as 7%
${TAX_LINE_TAXABLE} The amount this tax was charged on
${TAX_LINE_AMOUNT} The tax charged
${TAX_LINE_AGENCY} The tax agency this tax is paid to
${TAX_LINE_NUMBER} Your registration number with that agency, from QuickBooks

Tax Breakdown

Each tax you charge gets its own set of placeholders, named after the tax in your QuickBooks sales tax settings. These examples are from a company in British Columbia that charges GST and PST. They are not a complete list: a company in California sees ${TAX_CALIFORNIA_AMOUNT} instead. To see the placeholders for your own taxes, open any estimate in Missing Toolkit: Templates and look under Tax Breakdown. See Tax breakdown.

Placeholder Description
${TAX_GST_AMOUNT} GST tax amount
${TAX_GST_RATE} GST rate as a percentage (blank when this tax is not on the record)
${TAX_GST_TAXABLE} Amount GST was charged on
${TAX_GST_NUMBER} Your GST registration number from QuickBooks
${TAX_PST_BC_AMOUNT} PST (BC) tax amount
${TAX_PST_BC_RATE} PST (BC) rate as a percentage (blank when this tax is not on the record)
${TAX_PST_BC_TAXABLE} Amount PST (BC) was charged on
${TAX_PST_BC_NUMBER} Your PST (BC) registration number from QuickBooks

Customer

Placeholder Description
${CUSTOMER_NAME} Customer display name
${CUSTOMER_COMPANY} Customer company name
${CUSTOMER_FIRST_NAME} First name of the customer's contact
${CUSTOMER_LAST_NAME} Last name of the customer's contact
${CUSTOMER_TAX_ID} Customer tax registration number
${CUSTOMER_PHONE} Customer phone number
${CUSTOMER_MOBILE} Customer mobile number
${CUSTOMER_WEBSITE} Customer website
${CUSTOMER_NOTES} Customer notes
${BILLING_ADDRESS} Billing address as QuickBooks stores it, on multiple lines. Does not include the name; put CUSTOMER_NAME above it
${BILLING_LINE1} Billing address line 1. If the address was typed into the QuickBooks address box, this is the first line typed
${BILLING_LINE2} Billing address line 2. If the address was typed into the QuickBooks address box, this is the second line typed
${BILLING_CITY} Billing city. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_STATE} Billing state/province. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_ZIP} Billing postal code. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_CITY_LINE} Billing city, state and postal code on one line. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${SHIPPING_ADDRESS} Shipping address as QuickBooks stores it, on multiple lines. Does not include the name; put CUSTOMER_NAME above it
${SHIPPING_LINE1} Shipping address line 1. If the address was typed into the QuickBooks address box, this is the first line typed
${SHIPPING_LINE2} Shipping address line 2. If the address was typed into the QuickBooks address box, this is the second line typed
${SHIPPING_CITY} Shipping city. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${SHIPPING_STATE} Shipping state/province. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${SHIPPING_ZIP} Shipping postal code. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${SHIPPING_CITY_LINE} Shipping city, state and postal code on one line. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${CUSTOMER_EMAIL} Customer email address
${CUSTOMER_EMAIL_CC} Addresses copied (Cc) when this record is emailed, as entered on it in QuickBooks
${CUSTOMER_EMAIL_BCC} Addresses blind copied (Bcc) when this record is emailed, as entered on it in QuickBooks

Line Items — Auto Table

Placeholder Description
${LINE_ITEMS} Generates a complete table with all line items (do not use inside your own table)

Line Items — Row Placeholders

Placeholder Description
${LINE_NUMBER} Line number as QuickBooks numbers the lines (1 for the first)
${LINE_TAX_CODE} The line's tax code in QuickBooks, such as GST/PST BC or Zero-rated
${LINE_NAME} Product/service name (place in a table row — row will be cloned per item)
${LINE_DESCRIPTION} Description (place in a table row — row will be cloned per item)
${LINE_SERVICE_DATE} Service date
${LINE_SKU} SKU
${LINE_QUANTITY} Quantity
${LINE_RATE} Unit price
${LINE_AMOUNT} Total amount

Your Company

Placeholder Description
${COMPANY_NAME} Your company name
${COMPANY_ADDRESS} Your company address as QuickBooks stores it, on multiple lines. Does not include the name; put COMPANY_NAME above it
${COMPANY_LINE1} Your company address line 1, as in your QuickBooks company settings
${COMPANY_LINE2} Your company address line 2, as in your QuickBooks company settings
${COMPANY_CITY} Your company city. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_STATE} Your company state or province. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_ZIP} Your company postal code. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_CITY_LINE} Your company city, state and postal code on one line. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_PHONE} Your company phone number
${COMPANY_EMAIL} Your company email address
${COMPANY_WEBSITE} Your company website
${COMPANY_TAX_ID} Your company tax ID, from Team settings

Box Labels

Placeholder Description
${BOX_NUMBER} This box's number within its line item, 1 for the first (fills on a template set to one label per box)
${BOX_COUNT} How many boxes the line item ships in
${BOX_QUANTITY} Units in this box
${BOX_TOTAL_QUANTITY} Units across all of the line item's boxes

Estimates have the same ${SHIP_VIA}, ${SHIP_DATE} and ${TRACKING_NUMBER} placeholders as invoices, filled from the estimate's shipping fields once shipping is turned on in QuickBooks.

QuickBooks Online — Purchase Order

Purchase Order

Placeholder Description
${PO_NUMBER} The PO document number
${PO_DATE} The transaction date
${DUE_DATE} The expected delivery date
${PO_STATUS} Status (Open, Closed)
${SUBTOTAL} Subtotal before tax
${TAX_AMOUNT} Total tax amount
${TOTAL_AMOUNT} Total PO amount
${CURRENCY} The currency code of the amounts, such as EUR
${CURRENCY_SYMBOL} The symbol of the currency, such as $ or €
${MEMO} Private memo/notes
${VENDOR_MESSAGE} Message to vendor

Tax Line Items — Row Placeholders

Placeholder Description
${TAX_LINE_NAME} The tax rate's name in QuickBooks, such as PST (BC) Sales or Tucson City
${TAX_LINE_DESCRIPTION} The tax rate's description in QuickBooks, such as PST (BC). QuickBooks Canada prints this one
${TAX_LINE_RATE} The rate as a percentage, such as 7%
${TAX_LINE_TAXABLE} The amount this tax was charged on
${TAX_LINE_AMOUNT} The tax charged
${TAX_LINE_AGENCY} The tax agency this tax is paid to
${TAX_LINE_NUMBER} Your registration number with that agency, from QuickBooks

Tax Breakdown

Each tax you charge gets its own set of placeholders, named after the tax in your QuickBooks sales tax settings. These examples are from a company in British Columbia that charges GST and PST. They are not a complete list: a company in California sees ${TAX_CALIFORNIA_AMOUNT} instead. To see the placeholders for your own taxes, open any purchase order in Missing Toolkit: Templates and look under Tax Breakdown. See Tax breakdown.

Placeholder Description
${TAX_GST_AMOUNT} GST tax amount
${TAX_GST_RATE} GST rate as a percentage (blank when this tax is not on the record)
${TAX_GST_TAXABLE} Amount GST was charged on
${TAX_GST_NUMBER} Your GST registration number from QuickBooks
${TAX_PST_BC_AMOUNT} PST (BC) tax amount
${TAX_PST_BC_RATE} PST (BC) rate as a percentage (blank when this tax is not on the record)
${TAX_PST_BC_TAXABLE} Amount PST (BC) was charged on
${TAX_PST_BC_NUMBER} Your PST (BC) registration number from QuickBooks

Vendor

Placeholder Description
${VENDOR_NAME} Vendor display name
${VENDOR_COMPANY} Vendor company name
${VENDOR_TAX_ID} Vendor tax registration number
${VENDOR_PHONE} Vendor phone number
${VENDOR_MOBILE} Vendor mobile number
${VENDOR_WEBSITE} Vendor website
${VENDOR_CHECK_NAME} Vendor print-on-check name
${VENDOR_ACCOUNT_NUMBER} Your account number with this vendor (their Account no. on the vendor record)
${VENDOR_ADDRESS} Vendor address as QuickBooks stores it, on multiple lines. Does not include the name; put VENDOR_NAME above it
${VENDOR_LINE1} Vendor address line 1. If the address was typed into the QuickBooks address box, this is the first line typed
${VENDOR_LINE2} Vendor address line 2. If the address was typed into the QuickBooks address box, this is the second line typed
${VENDOR_CITY} Vendor city. Blank when the address was typed into the QuickBooks address box; VENDOR_ADDRESS always has it
${VENDOR_STATE} Vendor state/province. Blank when the address was typed into the QuickBooks address box; VENDOR_ADDRESS always has it
${VENDOR_ZIP} Vendor postal code. Blank when the address was typed into the QuickBooks address box; VENDOR_ADDRESS always has it
${VENDOR_CITY_LINE} Vendor city, state and postal code on one line. Blank when the address was typed into the QuickBooks address box; VENDOR_ADDRESS always has it
${VENDOR_EMAIL} Vendor email address
${SHIPPING_ADDRESS} Ship-to address as QuickBooks stores it, on multiple lines. Does not include the name of who it ships to; put it above the address
${SHIPPING_LINE1} Ship-to address line 1. If the address was typed into the QuickBooks address box, this is the first line typed
${SHIPPING_LINE2} Ship-to address line 2. If the address was typed into the QuickBooks address box, this is the second line typed
${SHIPPING_CITY} Ship-to city. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${SHIPPING_STATE} Ship-to state/province. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${SHIPPING_ZIP} Ship-to postal code. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${SHIPPING_CITY_LINE} Ship-to city, state and postal code on one line. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it

Line Items — Auto Table

Placeholder Description
${LINE_ITEMS} Generates a complete table with all line items (do not use inside your own table)

Line Items — Row Placeholders

Placeholder Description
${LINE_NUMBER} Line number as QuickBooks numbers the lines (1 for the first)
${LINE_TAX_CODE} The line's tax code in QuickBooks, such as GST/PST BC or Zero-rated
${LINE_NAME} Product/service name (place in a table row — row will be cloned per item)
${LINE_DESCRIPTION} Description (place in a table row — row will be cloned per item)
${LINE_SERVICE_DATE} Service date
${LINE_SKU} SKU
${LINE_QUANTITY} Quantity
${LINE_RATE} Unit price
${LINE_AMOUNT} Total amount

Your Company

Placeholder Description
${COMPANY_NAME} Your company name
${COMPANY_ADDRESS} Your company address as QuickBooks stores it, on multiple lines. Does not include the name; put COMPANY_NAME above it
${COMPANY_LINE1} Your company address line 1, as in your QuickBooks company settings
${COMPANY_LINE2} Your company address line 2, as in your QuickBooks company settings
${COMPANY_CITY} Your company city. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_STATE} Your company state or province. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_ZIP} Your company postal code. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_CITY_LINE} Your company city, state and postal code on one line. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_PHONE} Your company phone number
${COMPANY_EMAIL} Your company email address
${COMPANY_WEBSITE} Your company website
${COMPANY_TAX_ID} Your company tax ID, from Team settings

Box Labels

Placeholder Description
${BOX_NUMBER} This box's number within its line item, 1 for the first (fills on a template set to one label per box)
${BOX_COUNT} How many boxes the line item ships in
${BOX_QUANTITY} Units in this box
${BOX_TOTAL_QUANTITY} Units across all of the line item's boxes

Purchase orders support both item-based and account-based line items. Account-based lines use the account name as the product/service name.

QuickBooks Online — Bill Payment

A bill payment produces a remittance advice: the document you send a vendor confirming a payment and itemizing the bills it covers.

In the US edition of QuickBooks Online there is no way to send one for a payment you made yourself — pay by ACH from your own bank, by wire, by card, or by plain check and your vendor gets nothing. Payments run through QuickBooks Bill Pay do trigger an automatic notification, but it does not list the bills the payment covers, which is the part your vendor actually needs.

The UK and Canadian editions have a built-in Send remittance option on bill payments. If you're on one of those, use this when you want the document on your own letterhead, in your own format, or with details QuickBooks doesn't include.

Bill payment fields

Placeholder Description
${PAYMENT_NUMBER} The payment reference — the "Ref no." field in QuickBooks
${PAYMENT_DATE} The date the payment was made
${TOTAL_AMOUNT} Total amount paid
${CURRENCY} The currency code of the amounts, such as EUR
${CURRENCY_SYMBOL} The symbol of the currency, such as $ or €
${PAY_TYPE} How the payment was made: Check, or Credit Card
${CHECK_NUMBER} Check number (check payments only)
${BANK_ACCOUNT} Account the payment was drawn from
${PRINT_STATUS} Check print status: Need to print, or Printed (check payments only)
${MEMO} Private memo/notes

QuickBooks stores the check number in the same field as the payment number, so ${CHECK_NUMBER} is only filled in on check payments. On a credit card payment it is blank while ${PAYMENT_NUMBER} still has a value.

${PRINT_STATUS} is blank on any payment QuickBooks was never asked to print — which is most of them, including every payment made by ACH, card or wire. It only fills in once a check has been queued for printing or printed.

${PAY_TYPE} is worth using with care. QuickBooks records only two payment methods on a bill payment — it has no value for ACH, EFT or wire — so a payment drafted from your bank account arrives as "Check". A template that prints "Payment method: ${PAY_TYPE}" will tell a vendor you sent a check when you sent an ACH. If your remittance advice needs to name the method, write it into the template itself, or put it in the payment's Ref no. or Memo field in QuickBooks.

QuickBooks pre-fills Ref no. with a counter that runs per account rather than per company, so every credit card payment in your company can arrive as 1. Ref no. is editable on the payment in QuickBooks — if you want a reference your vendor can quote back to you, such as an ACH trace number or your own payment-run reference, type it there and it flows straight through to ${PAYMENT_NUMBER}. To see what a particular payment will produce, view it in the app before building your template: each placeholder is listed with its current value.

Ref no. is also how bill payments are listed and searched in the app, so what you see in the Doc # filter is what ${PAYMENT_NUMBER} will print. Where two payments share a Ref no., tell them apart by the vendor, date and amount shown alongside. A payment with no Ref no. at all is listed by its QuickBooks id instead, so the entry is never blank.

Vendor fields

Placeholder Description
${VENDOR_NAME} Vendor display name
${VENDOR_COMPANY} Vendor company name
${VENDOR_TAX_ID} Vendor tax registration number
${VENDOR_PHONE} Vendor phone number
${VENDOR_MOBILE} Vendor mobile number
${VENDOR_WEBSITE} Vendor website
${VENDOR_CHECK_NAME} Vendor print-on-check name
${VENDOR_ACCOUNT_NUMBER} Your account number with this vendor (their Account no. on the vendor record)
${VENDOR_ADDRESS} Vendor address as QuickBooks stores it, on multiple lines. Does not include the name; put VENDOR_NAME above it
${VENDOR_LINE1} Vendor address line 1. If the address was typed into the QuickBooks address box, this is the first line typed
${VENDOR_LINE2} Vendor address line 2. If the address was typed into the QuickBooks address box, this is the second line typed
${VENDOR_CITY} Vendor city. Blank when the address was typed into the QuickBooks address box; VENDOR_ADDRESS always has it
${VENDOR_STATE} Vendor state/province. Blank when the address was typed into the QuickBooks address box; VENDOR_ADDRESS always has it
${VENDOR_ZIP} Vendor postal code. Blank when the address was typed into the QuickBooks address box; VENDOR_ADDRESS always has it
${VENDOR_CITY_LINE} Vendor city, state and postal code on one line. Blank when the address was typed into the QuickBooks address box; VENDOR_ADDRESS always has it
${VENDOR_EMAIL} Vendor email address

A bill payment carries no address of its own, so every address placeholder is filled from the vendor record in QuickBooks.

${VENDOR_ACCOUNT_NUMBER} is worth putting on a remittance advice. It comes from the Account no. field on the vendor in QuickBooks — the number that vendor uses to identify your company — and it is how their accounts receivable clerk finds you before they even look at your bill numbers. It's blank unless somebody filled that field in on the vendor record.

Line item fields

On a remittance advice, each line is a bill the payment settles rather than a product sold.

Auto table

Placeholder Description
${LINE_ITEMS} Generates a complete table of the bills this payment covers (do not use inside your own table)

Row placeholders

Placeholder Description
${LINE_BILL_NUMBER} Bill number, or the credit number on a credit row (place in a table row — row will be cloned per line)
${LINE_BILL_DATE} Date of the bill or credit
${LINE_BILL_DUE_DATE} Due date of the bill
${LINE_BILL_TOTAL} Original total of the bill
${LINE_BILL_BALANCE} Bill balance outstanding today (not as of the payment date)
${LINE_PAYMENT_AMOUNT} Amount applied to the bill, or negative on a credit row — the column totals the amount paid
${LINE_TXN_TYPE} What the line settles (Bill, Vendor Credit, Deposit)

Note that ${LINE_BILL_BALANCE} is the bill's balance as it stands today, not as it stood on the payment date — a fully paid bill shows 0.00. QuickBooks does not keep historical balances, and for the same reason this column is left out of the ${LINE_ITEMS} table. Use ${LINE_PAYMENT_AMOUNT} for the figure this payment contributed.

Your company

These fill in your own company's name and contact details, from your QuickBooks company settings.

Placeholder Description
${COMPANY_NAME} Your company name
${COMPANY_ADDRESS} Your company address as QuickBooks stores it, on multiple lines. Does not include the name; put COMPANY_NAME above it
${COMPANY_LINE1} Your company address line 1, as in your QuickBooks company settings
${COMPANY_LINE2} Your company address line 2, as in your QuickBooks company settings
${COMPANY_CITY} Your company city. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_STATE} Your company state or province. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_ZIP} Your company postal code. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_CITY_LINE} Your company city, state and postal code on one line. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_PHONE} Your company phone number
${COMPANY_EMAIL} Your company email address
${COMPANY_WEBSITE} Your company website
${COMPANY_TAX_ID} Your company tax ID, from Team settings

Your remittance advice is only as good as your Bill no.

${LINE_BILL_NUMBER} comes from the Bill no. field on the bill in QuickBooks. That field is where you record the vendor's own invoice number, and it is the column that makes a remittance advice work — it's what lets your vendor match your payment to their invoices without calling you.

QuickBooks does not fill it in for you. Unlike an invoice, a bill is not auto-numbered: if nobody typed a Bill no. when the bill was entered, QuickBooks stores nothing, and ${LINE_BILL_NUMBER} comes out blank on your document. The rest of the row — dates, totals, amount paid — still fills in, so the remittance advice remains usable, but your vendor has more work to do.

If your remittance advice has blank bill numbers, the fix is in QuickBooks, not here: open the bill and enter the vendor's invoice number in Bill no., then generate the document again. Before building your template, view a bill payment in the app — every placeholder is listed with its current value, so you can see straight away whether your bills carry numbers.

Payments that apply a vendor credit

A payment can also apply a vendor credit or a deposit, and those get a row of their own. On such a row:

  • ${LINE_BILL_NUMBER} and ${LINE_BILL_DATE} hold the credit's number and date, so the deduction names itself.
  • ${LINE_PAYMENT_AMOUNT} is negative, because the credit reduces what you actually paid.
  • ${LINE_TXN_TYPE} reads Vendor Credit or Deposit rather than Bill.
  • ${LINE_BILL_DUE_DATE}, ${LINE_BILL_TOTAL} and ${LINE_BILL_BALANCE} are blank — a credit has no due date, bill total or outstanding balance.

Each bill row shows the amount the payment settles that bill for in full, including anything the credit covered, and the credit is then deducted on its own row. So the ${LINE_PAYMENT_AMOUNT} column adds up to ${TOTAL_AMOUNT}, the cash that actually left your account:

Bill No. Bill Date Due Date Bill Total Paid
NL-4471 07/02/2026 08/01/2026 400.00 400.00
NL-4482 07/14/2026 08/13/2026 250.00 250.00
NL-CR-119 07/20/2026 -75.00
Total paid 575.00

This is what a vendor expects to see: both bills confirmed as settled, the credit shown as the deduction that explains why the payment is smaller than their total.

When the rows don't add up

The rows are a claim that they explain the total at the bottom, and that is the first thing your vendor will check. Occasionally they won't: QuickBooks holds an overpayment as a credit rather than as a line, so a payment can be larger than everything it visibly settles.

When that happens the app tells you before you build the document. View the bill payment and you'll see a warning naming both figures — what the rows come to, and what the payment actually was. Open the payment in QuickBooks and confirm what it settles before sending anything to your vendor.

You may occasionally see a different warning saying a transaction could not be read from QuickBooks. That one is not about your data: the amount paid is still right, but the bill number, dates and totals will be blank on those rows because the records behind them didn't come back. Generate the document again in a moment — it usually clears.

QuickBooks Online — Credit Memo

A credit memo is the document you send a customer when you owe them money back — a return, a billing correction, or a goodwill credit.

QuickBooks Online has no custom form style for one. Under Custom form styles you can build a style for an invoice, estimate, sales receipt, sales order or purchase order, but not for a credit memo, and there is no way to import your own. So a business that has carefully branded its invoices still sends a stock QuickBooks credit note alongside them. Use these placeholders to issue the credit on the same letterhead as the invoice it corrects.

Credit Memo

Placeholder Description
${CREDIT_MEMO_NUMBER} The credit memo document number
${CREDIT_MEMO_DATE} The transaction date
${PAYMENT_TERMS} Payment terms (e.g. Net 30)
${SUBTOTAL} Subtotal before tax
${TAX_AMOUNT} Total tax amount
${TOTAL_AMOUNT} Total credit amount
${CURRENCY} The currency code of the amounts, such as EUR
${CURRENCY_SYMBOL} The symbol of the currency, such as $ or €
${REMAINING_CREDIT} Credit still available to apply, as it stands today
${MEMO} Private memo/notes
${CUSTOMER_MESSAGE} Message displayed on credit memo

Tax Line Items — Row Placeholders

Placeholder Description
${TAX_LINE_NAME} The tax rate's name in QuickBooks, such as PST (BC) Sales or Tucson City
${TAX_LINE_DESCRIPTION} The tax rate's description in QuickBooks, such as PST (BC). QuickBooks Canada prints this one
${TAX_LINE_RATE} The rate as a percentage, such as 7%
${TAX_LINE_TAXABLE} The amount this tax was charged on
${TAX_LINE_AMOUNT} The tax charged
${TAX_LINE_AGENCY} The tax agency this tax is paid to
${TAX_LINE_NUMBER} Your registration number with that agency, from QuickBooks

Tax Breakdown

Each tax you charge gets its own set of placeholders, named after the tax in your QuickBooks sales tax settings. These examples are from a company in British Columbia that charges GST and PST. They are not a complete list: a company in California sees ${TAX_CALIFORNIA_AMOUNT} instead. To see the placeholders for your own taxes, open any credit memo in Missing Toolkit: Templates and look under Tax Breakdown. See Tax breakdown.

Placeholder Description
${TAX_GST_AMOUNT} GST tax amount
${TAX_GST_RATE} GST rate as a percentage (blank when this tax is not on the record)
${TAX_GST_TAXABLE} Amount GST was charged on
${TAX_GST_NUMBER} Your GST registration number from QuickBooks
${TAX_PST_BC_AMOUNT} PST (BC) tax amount
${TAX_PST_BC_RATE} PST (BC) rate as a percentage (blank when this tax is not on the record)
${TAX_PST_BC_TAXABLE} Amount PST (BC) was charged on
${TAX_PST_BC_NUMBER} Your PST (BC) registration number from QuickBooks

Customer

Placeholder Description
${CUSTOMER_NAME} Customer display name
${CUSTOMER_COMPANY} Customer company name
${CUSTOMER_FIRST_NAME} First name of the customer's contact
${CUSTOMER_LAST_NAME} Last name of the customer's contact
${CUSTOMER_TAX_ID} Customer tax registration number
${CUSTOMER_PHONE} Customer phone number
${CUSTOMER_MOBILE} Customer mobile number
${CUSTOMER_WEBSITE} Customer website
${CUSTOMER_NOTES} Customer notes
${BILLING_ADDRESS} Billing address as QuickBooks stores it, on multiple lines. Does not include the name; put CUSTOMER_NAME above it
${BILLING_LINE1} Billing address line 1. If the address was typed into the QuickBooks address box, this is the first line typed
${BILLING_LINE2} Billing address line 2. If the address was typed into the QuickBooks address box, this is the second line typed
${BILLING_CITY} Billing city. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_STATE} Billing state/province. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_ZIP} Billing postal code. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_CITY_LINE} Billing city, state and postal code on one line. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${SHIPPING_ADDRESS} Shipping address as QuickBooks stores it, on multiple lines. Does not include the name; put CUSTOMER_NAME above it
${SHIPPING_LINE1} Shipping address line 1. If the address was typed into the QuickBooks address box, this is the first line typed
${SHIPPING_LINE2} Shipping address line 2. If the address was typed into the QuickBooks address box, this is the second line typed
${SHIPPING_CITY} Shipping city. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${SHIPPING_STATE} Shipping state/province. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${SHIPPING_ZIP} Shipping postal code. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${SHIPPING_CITY_LINE} Shipping city, state and postal code on one line. Blank when the address was typed into the QuickBooks address box; SHIPPING_ADDRESS always has it
${CUSTOMER_EMAIL} Customer email address
${CUSTOMER_EMAIL_CC} Addresses copied (Cc) when this record is emailed, as entered on it in QuickBooks
${CUSTOMER_EMAIL_BCC} Addresses blind copied (Bcc) when this record is emailed, as entered on it in QuickBooks

Line Items — Auto Table

Placeholder Description
${LINE_ITEMS} Generates a complete table with all line items (do not use inside your own table)

Line Items — Row Placeholders

Placeholder Description
${LINE_NUMBER} Line number as QuickBooks numbers the lines (1 for the first)
${LINE_TAX_CODE} The line's tax code in QuickBooks, such as GST/PST BC or Zero-rated
${LINE_NAME} Product/service name (place in a table row — row will be cloned per item)
${LINE_DESCRIPTION} Description (place in a table row — row will be cloned per item)
${LINE_SERVICE_DATE} Service date
${LINE_SKU} SKU
${LINE_QUANTITY} Quantity
${LINE_RATE} Unit price
${LINE_AMOUNT} Total amount

Your Company

Placeholder Description
${COMPANY_NAME} Your company name
${COMPANY_ADDRESS} Your company address as QuickBooks stores it, on multiple lines. Does not include the name; put COMPANY_NAME above it
${COMPANY_LINE1} Your company address line 1, as in your QuickBooks company settings
${COMPANY_LINE2} Your company address line 2, as in your QuickBooks company settings
${COMPANY_CITY} Your company city. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_STATE} Your company state or province. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_ZIP} Your company postal code. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_CITY_LINE} Your company city, state and postal code on one line. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_PHONE} Your company phone number
${COMPANY_EMAIL} Your company email address
${COMPANY_WEBSITE} Your company website
${COMPANY_TAX_ID} Your company tax ID, from Team settings

Box Labels

Placeholder Description
${BOX_NUMBER} This box's number within its line item, 1 for the first (fills on a template set to one label per box)
${BOX_COUNT} How many boxes the line item ships in
${BOX_QUANTITY} Units in this box
${BOX_TOTAL_QUANTITY} Units across all of the line item's boxes

${REMAINING_CREDIT} is how much of the credit the customer has not yet used, as it stands today — not as it stood on the credit memo's date. A credit that has since been applied in full reads 0.00, even on a document dated before it was applied. Use ${TOTAL_AMOUNT} for the value of the credit itself.

A credit memo carries no due date, because there is nothing to pay. ${PAYMENT_TERMS} exists and QuickBooks will copy it across from the customer record, but it rarely means anything on a credit — leave it off unless you know you want it.

QuickBooks Online — Customer Statement

A statement is a summary of what a customer owes you — the document you send at the end of the month so somebody in their accounts department knows what to pay.

QuickBooks Online will produce one, but gives you no say in how it looks. Custom form styles does not offer a statement at all, custom fields are unavailable on them, and the columns are fixed. Most visibly, a statement will not show a purchase order number against each invoice.

QuickBooks Online has no P.O. number field on an invoice either, so companies that need one add a custom field and record it there. Those custom fields are available on a statement as row placeholders: a field named P.O. Number becomes ${LINE_CUSTOM_PO_NUMBER}, which puts it in a column of its own. Use the name you gave your own field.

Statements come in two kinds. An open item statement lists every invoice still carrying a balance, whenever it was raised. A balance forward statement opens with what was owed before the period, lists everything that happened during it, and carries a running balance down the page.

Statement

Placeholder Description
${STATEMENT_NUMBER} Statement number assigned when the statement is generated; each statement gets the next number in your sequence
${STATEMENT_DATE} The date the statement covers up to
${STATEMENT_START_DATE} First day of the period, on a balance forward statement
${STATEMENT_END_DATE} Last day of the period, on a balance forward statement
${STATEMENT_TYPE} Open item or balance forward
${PAST_DUE_DAYS} When the statement lists only overdue items, how many days past due; blank otherwise
${PAST_DUE_AMOUNT} How much of the balance is that far past due; blank when the statement lists everything
${BALANCE_FORWARD} What was owed before the period began
${TOTAL_CHARGES} Charges listed on this statement
${TOTAL_PAYMENTS} Payments and credits listed on this statement
${AMOUNT_DUE} Total owed as at the statement date, whatever the statement listed, less any transactions chosen to be left off it

Aging

Placeholder Description
${AGING_CURRENT} Not yet due
${AGING_1_30} Overdue by 1 to 30 days
${AGING_31_60} Overdue by 31 to 60 days
${AGING_61_90} Overdue by 61 to 90 days
${AGING_OVER_90} Overdue by more than 90 days

Customer

Placeholder Description
${CUSTOMER_NAME} Customer display name
${CUSTOMER_COMPANY} Customer company name
${CUSTOMER_FIRST_NAME} First name of the customer's contact
${CUSTOMER_LAST_NAME} Last name of the customer's contact
${CUSTOMER_EMAIL} Customer email address
${CUSTOMER_PHONE} Customer phone number
${BILLING_ADDRESS} Billing address as QuickBooks stores it, on multiple lines. Does not include the name; put CUSTOMER_NAME above it
${BILLING_LINE1} Billing address line 1. If the address was typed into the QuickBooks address box, this is the first line typed
${BILLING_LINE2} Billing address line 2. If the address was typed into the QuickBooks address box, this is the second line typed
${BILLING_CITY} Billing city. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_STATE} Billing state. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_ZIP} Billing postal code. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_CITY_LINE} Billing city, state and postal code on one line. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it

Transaction Rows — Auto Table

Placeholder Description
${LINE_ITEMS} Generates a complete table of the statement rows (do not use inside your own table)

Transaction Rows — Row Placeholders

Placeholder Description
${LINE_DATE} Date of the transaction (place in a table row — row will be cloned per line)
${LINE_TYPE} What the transaction is, as QuickBooks names it
${LINE_NUMBER} Document number of the transaction
${LINE_DUE_DATE} Date the invoice is due
${LINE_DAYS_OVERDUE} Days past due as at the statement date, blank if not yet due
${LINE_MEMO} Message or note on the transaction
${LINE_AMOUNT} Amount of the transaction; payments and credits are negative
${LINE_OPEN_AMOUNT} Unpaid balance on an open item statement, or the running balance on a balance forward statement

Your Company

Placeholder Description
${COMPANY_NAME} Your company name
${COMPANY_ADDRESS} Your company address as QuickBooks stores it, on multiple lines. Does not include the name; put COMPANY_NAME above it
${COMPANY_LINE1} Your company address line 1, as in your QuickBooks company settings
${COMPANY_LINE2} Your company address line 2, as in your QuickBooks company settings
${COMPANY_CITY} Your company city. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_STATE} Your company state or province. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_ZIP} Your company postal code. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_CITY_LINE} Your company city, state and postal code on one line. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_PHONE} Your company phone number
${COMPANY_EMAIL} Your company email address
${COMPANY_WEBSITE} Your company website
${COMPANY_TAX_ID} Your company tax ID, from Team settings

The aging placeholders total what is unpaid into the usual receivables buckets, measured as at the statement date from each transaction's due date — or from its own date where it has none, which is how QuickBooks ages receivables. They are the figures a collections call is made from.

Placeholder Description
${AGING_CURRENT} Not yet due
${AGING_1_30} Overdue by 1 to 30 days
${AGING_31_60} Overdue by 31 to 60 days
${AGING_61_90} Overdue by 61 to 90 days
${AGING_OVER_90} Overdue by more than 90 days
Placeholder Description
${CUSTOMER_NAME} Customer display name
${CUSTOMER_COMPANY} Customer company name
${CUSTOMER_FIRST_NAME} First name of the customer's contact
${CUSTOMER_LAST_NAME} Last name of the customer's contact
${CUSTOMER_EMAIL} Customer email address
${CUSTOMER_PHONE} Customer phone number
${BILLING_ADDRESS} Billing address as QuickBooks stores it, on multiple lines. Does not include the name; put CUSTOMER_NAME above it
${BILLING_LINE1} Billing address line 1. If the address was typed into the QuickBooks address box, this is the first line typed
${BILLING_LINE2} Billing address line 2. If the address was typed into the QuickBooks address box, this is the second line typed
${BILLING_CITY} Billing city. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_STATE} Billing state. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_ZIP} Billing postal code. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it
${BILLING_CITY_LINE} Billing city, state and postal code on one line. Blank when the address was typed into the QuickBooks address box; BILLING_ADDRESS always has it

Each row of the statement is one transaction, and every transaction posted to accounts receivable is there — journal entries, deposits, and refunds as well as invoices, payments, and credits. ${LINE_TYPE} names it the way QuickBooks does. On an open item statement ${LINE_AMOUNT} is the transaction total and ${LINE_OPEN_AMOUNT} is what remains unpaid on it. On a balance forward statement ${LINE_OPEN_AMOUNT} is the running balance after that transaction, and payments and credits appear as negative amounts.

Placeholder Description
${LINE_ITEMS} Generates a complete table of the statement rows (do not use inside your own table)
Placeholder Description
${LINE_DATE} Date of the transaction (place in a table row — row will be cloned per line)
${LINE_TYPE} What the transaction is, as QuickBooks names it
${LINE_NUMBER} Document number of the transaction
${LINE_DUE_DATE} Date the invoice is due
${LINE_DAYS_OVERDUE} Days past due as at the statement date, blank if not yet due
${LINE_MEMO} Message or note on the transaction
${LINE_AMOUNT} Amount of the transaction; payments and credits are negative
${LINE_OPEN_AMOUNT} Unpaid balance on an open item statement, or the running balance on a balance forward statement

These fill in your own company's name and contact details, from your QuickBooks company settings.

Placeholder Description
${COMPANY_NAME} Your company name
${COMPANY_ADDRESS} Your company address as QuickBooks stores it, on multiple lines. Does not include the name; put COMPANY_NAME above it
${COMPANY_LINE1} Your company address line 1, as in your QuickBooks company settings
${COMPANY_LINE2} Your company address line 2, as in your QuickBooks company settings
${COMPANY_CITY} Your company city. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_STATE} Your company state or province. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_ZIP} Your company postal code. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_CITY_LINE} Your company city, state and postal code on one line. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_PHONE} Your company phone number
${COMPANY_EMAIL} Your company email address
${COMPANY_WEBSITE} Your company website
${COMPANY_TAX_ID} Your company tax ID, from Team settings

QuickBooks Online — Sales Register

A sales register lists every invoice, sales receipt and credit memo in a period, one row each. Credit memos are negative, so the totals are what you actually sold. Amounts are in your home currency; ${LINE_CURRENCY} and ${LINE_DOCUMENT_TOTAL} give each document's own currency and total. See Sales Register.

Custom fields work on each row too. A field on your sales prints as ${LINE_CUSTOM_…}, and a field on the customer as ${LINE_CUSTOMER_CUSTOM_…}, so a customer field named TIN becomes ${LINE_CUSTOMER_CUSTOM_TIN}.

Register

Placeholder Description
${PERIOD_START} First day of the period
${PERIOD_END} Last day of the period
${ROW_COUNT} How many documents the register lists
${TOTAL_SUBTOTAL} Total before tax in your home currency; credit memos are subtracted
${TOTAL_TAX} Total tax in your home currency; credit memos are subtracted
${TOTAL_AMOUNT} Total including tax in your home currency; credit memos are subtracted
${GENERATED_DATE} The date the register was made

Register Rows — Auto Table

Placeholder Description
${LINE_ITEMS} Generates a complete table of the register rows (do not use inside your own table)

Register Rows — Row Placeholders

Placeholder Description
${LINE_ROW_NUMBER} Row number, starting at 1 (place in a table row — row will be cloned per document)
${LINE_TYPE} Invoice, Sales receipt or Credit memo
${LINE_DATE} Date of the document
${LINE_NUMBER} Document number
${LINE_CUSTOMER_NAME} Customer display name
${LINE_CUSTOMER_TAX_ID} Customer tax ID from the customer record
${LINE_MEMO} Message on the document, or the first line's description when there is none
${LINE_SUBTOTAL} Amount before tax in your home currency; negative on a credit memo
${LINE_TAX} Tax in your home currency; negative on a credit memo
${LINE_TOTAL} Total including tax in your home currency; negative on a credit memo
${LINE_CURRENCY} Currency the document was written in, like USD; blank when QuickBooks multicurrency is off
${LINE_DOCUMENT_TOTAL} Total in the document's own currency, as printed on it; negative on a credit memo

Your Company

Placeholder Description
${COMPANY_NAME} Your company name
${COMPANY_ADDRESS} Your company address as QuickBooks stores it, on multiple lines. Does not include the name; put COMPANY_NAME above it
${COMPANY_LINE1} Your company address line 1, as in your QuickBooks company settings
${COMPANY_LINE2} Your company address line 2, as in your QuickBooks company settings
${COMPANY_CITY} Your company city. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_STATE} Your company state or province. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_ZIP} Your company postal code. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_CITY_LINE} Your company city, state and postal code on one line. Blank if its own field is empty in your QuickBooks company settings; COMPANY_ADDRESS always has the full address
${COMPANY_PHONE} Your company phone number
${COMPANY_EMAIL} Your company email address
${COMPANY_WEBSITE} Your company website
${COMPANY_TAX_ID} Your company tax ID, from Team settings

Addresses

${BILLING_ADDRESS}, ${SHIPPING_ADDRESS}, ${VENDOR_ADDRESS} and ${COMPANY_ADDRESS} print the address exactly as it is in QuickBooks, one line per line. They do not include a name. Put the name above the address:

${CUSTOMER_NAME} ${BILLING_ADDRESS}

If you type a name into the address box on a QuickBooks invoice, such as Attn: Accounts Payable, it is part of the address and prints with it.

The other address placeholders depend on how the address was entered in QuickBooks:

  • Line 1 and line 2 are the first two lines of the address as QuickBooks stores it. For an address typed into the address box on an invoice, that is the first two lines typed, which may be a name.
  • City, state and postal code are filled only when QuickBooks keeps them in their own fields, such as on a customer or vendor record. For an address typed into the address box, they are blank.

On an invoice, the address box looks the same either way. Open the record in Missing Toolkit: Templates to see what each placeholder holds. To always get the whole address, use the full address placeholder.

Custom fields

If you have custom fields on your QuickBooks invoices, estimates, purchase orders, and credit memos, they are automatically available as placeholders. This includes all custom field types: text, number, date, and dropdown lists.

QuickBooks offers no transaction custom fields on bill payments, customer statements, and sales registers, but vendor and customer custom fields are still available on them.

How custom field placeholders are named

All custom field placeholders are prefixed with CUSTOM_ to clearly distinguish them from built-in fields. The rest of the name is converted to UPPER_CASE with underscores replacing spaces, and special characters (periods, commas, etc.) are removed.

Examples:

Custom field name in QuickBooks Placeholder to use in template
Place of Supply ${CUSTOM_PLACE_OF_SUPPLY}
Customer PO No. ${CUSTOM_CUSTOMER_PO_NO}
Delivery Status ${CUSTOM_DELIVERY_STATUS}
Customer In Charge ${CUSTOM_CUSTOMER_IN_CHARGE}

Dropdown (list) custom fields are fully supported. When you use a dropdown custom field in QuickBooks, the placeholder is populated with the selected option's display text — not the internal ID. For example, if your "Delivery Status" dropdown has options "Customer Arranged" and "Inclusive", the placeholder will contain the text "Customer Arranged", not a number.

Viewing your custom fields

You can see the exact placeholder name and current value for each custom field by opening any entity detail page in the app. Custom fields appear in their own "Custom Fields" section with a copy button so you can paste placeholder names directly into your template.

If you've recently added or changed custom fields in QuickBooks and they aren't appearing correctly, click the refresh button on the Custom Fields section to update.

Adding new custom fields

Any custom field you add in QuickBooks will automatically be available as a placeholder — no configuration needed. Custom fields work on your invoices, estimates, purchase orders, and credit memos.

Customer and vendor custom fields

Custom fields on customer and vendor records in QuickBooks are also supported. These are extracted automatically when generating a document and use the same CUSTOM_ prefix. For example, if you add a "VAT Number" custom field to a customer in QuickBooks, it will be available as ${CUSTOM_VAT_NUMBER} in your template.

Customer custom fields appear in their own "Customer Custom Fields" section on the entity detail page. When viewing your purchase orders and bill payments, vendor custom fields appear in a "Vendor Custom Fields" section instead.

Shorthands

If a placeholder name is too long for your template layout — especially in narrow table columns — you can create a shorthand. A shorthand is a shorter name that maps to a standard placeholder, so you can use either one in your template.

For example, you could create the shorthand POS for CUSTOM_PLACE_OF_SUPPLY, then use ${POS} in your template instead of ${CUSTOM_PLACE_OF_SUPPLY}. Both will produce the same result.

Creating a shorthand

  1. Browse to any entity detail page (e.g., view an invoice)
  2. Find the placeholder you want to shorten
  3. Click the + button next to it
  4. Enter your shorthand name and click Save

Shorthands must use uppercase letters, numbers, and underscores, and cannot conflict with existing placeholder names. They are saved per connection and entity type, so you can define different shorthands for invoices and estimates if needed.

You can add filters after a shorthand, just as after any placeholder: ${POS|upper}.

Editing or removing a shorthand

On the entity detail page, shorthands appear as a green-tinted chip next to the standard placeholder. Click the pencil icon to edit or remove it.

Your company tax ID

${COMPANY_TAX_ID} is the one company placeholder that doesn't come from QuickBooks. QuickBooks doesn't share the tax number on your company profile with apps, so you enter it once under Team > Settings > Tax ID.

If you collect sales tax in QuickBooks, the registration number you entered for each tax agency comes through as well. See Tax breakdown.

Currency

Amounts print as plain numbers, in the currency of the document in QuickBooks. ${CURRENCY} prints that currency's code, such as EUR or GBP, on invoices, estimates, credit memos, purchase orders and bill payments. If you bill in more than one currency, put it beside your totals: ${TOTAL_AMOUNT} ${CURRENCY}. ${CURRENCY_SYMBOL} prints the currency's symbol instead, such as $, £ or €: ${CURRENCY_SYMBOL}${TOTAL_AMOUNT}. A currency without a symbol of its own prints its code.

Tax line items

Tax line items work like line items, but for taxes. Put them in a table row of their own, and the row repeats once for each tax charged on the document. This is the same tax summary QuickBooks prints below the totals on its own invoices.

Placeholder Description
${TAX_LINE_NAME} The tax rate's name in QuickBooks, such as PST (BC) Sales or Tucson City
${TAX_LINE_DESCRIPTION} The tax rate's description in QuickBooks, such as PST (BC). QuickBooks Canada prints this one
${TAX_LINE_RATE} The rate as a percentage, such as 7%
${TAX_LINE_TAXABLE} The amount this tax was charged on
${TAX_LINE_AMOUNT} The tax charged
${TAX_LINE_AGENCY} The tax agency this tax is paid to
${TAX_LINE_NUMBER} Your registration number with that agency, from QuickBooks

For example, a row of ${TAX_LINE_DESCRIPTION} @ ${TAX_LINE_RATE}, ${TAX_LINE_AMOUNT} and ${TAX_LINE_TAXABLE} prints:

Rate Tax Charged on
GST @ 5% 6.00 120.00
PST (BC) @ 7% 8.40 120.00
GST @ 0% 0.00 35.00
  • Keep tax line items in a different table row from your line items. A row repeats either once per item or once per tax, not both.
  • A tax charged at 0%, such as GST on zero-rated items, gets a row, the same as on QuickBooks' own invoices.
  • A document with no tax prints no tax rows.
  • ${TAX_LINE_NAME} is the tax rate's name in QuickBooks and ${TAX_LINE_DESCRIPTION} is its description. Use whichever reads better on your documents. In the US, the name is usually the one that tells the taxes apart.
  • Estimates, credit memos and purchase orders have the same placeholders. CSV templates don't support them.

Tax breakdown

${TAX_AMOUNT} is the total tax on a document. If you charge more than one tax, such as GST and PST, each one also has its own placeholders, named after the tax in your QuickBooks sales tax settings:

Placeholder Prints
${TAX_GST_AMOUNT} The GST charged, such as 8.75
${TAX_GST_RATE} The GST rate, such as 5%
${TAX_GST_TAXABLE} The amount GST was charged on, such as 175.00
${TAX_GST_NUMBER} Your GST registration number

Each tax you charge gets its own set. The names come from your tax rates, so they depend on your company. PST in British Columbia is ${TAX_PST_BC_AMOUNT}, and HST in Ontario is ${TAX_HST_ON_AMOUNT}. To see yours, open any invoice, estimate, credit memo or purchase order and look under Tax Breakdown.

If the taxes on your documents change from one to the next, such as a different county rate for each customer, use tax line items instead.

  • A tax that isn't on a document prints blank, so one template works for every customer. The registration number always prints.
  • If two of your taxes share a description in QuickBooks, such as a state and a city tax both described as "Sales Tax", each is named after its own tax name instead, such as ${TAX_TUCSON_CITY_AMOUNT}.
  • Invoices and purchase orders use the same names, even though QuickBooks keeps separate sales and purchase rates.
  • ${LINE_TAX_CODE} prints each line's tax code, such as GST/PST BC or Zero-rated. Put it in a table row. A bundle shows a tax code when every item in it has the same one.
  • If you add a tax or rename one in QuickBooks, click Connections in the sidebar, open your QuickBooks connection, and click Refresh from QuickBooks. A renamed tax changes its placeholder names, so update your templates to match.

One combined rate

On an invoice, ${TAX_RATE} prints the rate as one figure. If more than one tax was charged on the same amount, such as a 6% state tax and a 1% county tax on 2,600.00, the rates are added together and it prints 7%.

If the taxes were charged on different amounts, ${TAX_RATE} prints blank, because no single rate gives the tax that was charged. This happens when some items are exempt from one tax but not the other, or when a tax only applies up to a limit. If your invoices can look like this, show each tax on its own line with the placeholders above, or with tax line items.

Date formatting

All date placeholders (including ${LINE_SERVICE_DATE}) respect your team's date format setting. To change the format, go to Team > Settings and select your preferred format from the dropdown.

Filters

A filter changes how one placeholder prints. Add it after the placeholder name with a |:

  • ${TOTAL_AMOUNT|plain} prints 1234.50 instead of 1,234.50
  • ${CUSTOMER_NAME|upper} prints ACME TRADING
  • ${INVOICE_DATE|date:Ymd} prints 20261001

You can chain filters. They run left to right, in the order you write them, so ${TOTAL_AMOUNT|abs|plain} prints 1234.50 for a credit of -1,234.50. Each filter works on what the one before it printed, so the order can change the result. Nothing reorders them for you.

You don't have to type filters by hand. In the placeholder lists, open a placeholder's menu and choose Format…. Choose the formatting you want, check the preview, and copy the result into your template. On a record's page, the preview uses that record's real value.

Some filters take a setting after a colon, like |round:0. Don't put quotes around settings: write |default:N/A, not |default:"N/A". Filter names can be upper or lower case.

Available filters

Filter Use on Example Prints
plain amounts, numbers ${TOTAL_AMOUNT|plain} 1234.50
round:n amounts, numbers ${TOTAL_AMOUNT|round:0} 1,235
abs amounts, numbers ${TOTAL_AMOUNT|abs} on a credit memo 1,234.50
words amounts ${TOTAL_AMOUNT|words} One thousand two hundred thirty-four and 50/100
words:CUR amounts ${TOTAL_AMOUNT|words:LKR} Rupees one thousand two hundred thirty-four and cents fifty only
date:format dates ${INVOICE_DATE|date:d/m/Y} 01/10/2026
upper, lower, title text ${CUSTOMER_NAME|upper} ACME TRADING
default:text anything ${CUSTOM_PO|default:N/A} N/A when blank
when:text anything ${PAYMENT_STATUS|when:Paid} Paid on a paid invoice, blank otherwise
pad:n anything ${INVOICE_NUMBER|pad:5} 00042
truncate:n text ${LINE_DESCRIPTION|truncate:40} The first 40 characters
quarter:m dates ${INVOICE_DATE|quarter:4} 3 for October
month_of_quarter:m dates ${INVOICE_DATE|month_of_quarter:4} 1 for October
fiscal_year:m,digits dates ${INVOICE_DATE|fiscal_year:4,2} 26 for April 2026 to March 2027

Filters work in table rows too: ${LINE_AMOUNT|abs} fills every row.

when prints the value only if it matches the text after the colon. Otherwise it prints nothing. Upper and lower case don't matter, so |when:paid matches Paid.

  • ${PAYMENT_STATUS|when:Paid|upper} prints PAID on a paid invoice and nothing on any other. Use it for a "PAID" mark on a packing slip or receipt.
  • Add default after it to print something else when the value doesn't match: ${PAYMENT_STATUS|when:Paid|default:Payment due}.

In the Format… dialog, type the value in Only print when it is.

when compares the whole value, so |when:Paid doesn't match Partially paid. It compares the value as it stands at that point in the chain, so put it before filters that shorten or pad the text, such as truncate or pad.

Write when before default. In the other order, default only fills a blank value, then when blanks everything that doesn't match, including the default text. ${PAYMENT_STATUS|default:Payment due|when:Paid} never prints "Payment due".

Amounts in words

words spells out an amount. On its own it uses the style printed on US checks. Add a currency code for that currency's wording: USD, LKR, INR, GBP or AUD.

A negative amount starts with "Minus". To spell a credit as a positive amount, put abs first: ${TOTAL_AMOUNT|abs|words:GBP}.

Dates

date takes the same letters PHP uses for dates. The most useful are d (day, 01), j (day, 1), m (month, 10), F (October), M (Oct), Y (year, 2026) and y (26).

The fiscal filters take the month your fiscal year starts, from 1 to 12. A fiscal year is named by the calendar year it starts in. For a year starting in April, ${INVOICE_DATE|fiscal_year:4,2}${INVOICE_DATE|quarter:4} prints 263 for an invoice dated October 2026.

Mistakes

When you upload a template, we check its filters. A misspelled filter, a missing setting, or a filter that doesn't suit its placeholder (like words on a customer name) shows as a warning. Until you fix it, that placeholder prints without the filter.