HubSpot's payments and subscriptions properties

When a buyer makes a payment, HubSpot stores details about the payment in specific properties. HubSpot will also store details about a subscription if a subscription record is created.

Payment properties

You can use payment properties to segment payment records on the index page. Users in a Marketing Hub, Sales Hub, Service Hub, or Operations Hub Professional or Enterprise account can use payment properties in workflows.

• Amount paid: the total amount collected from the customer after refunds.
• Amount paid in company currency: the total amount collected from the customer after refunds, in the account's default currency.
• Associated records: other records the payment is associated with. For example, a payment could be associated to a subscription.
• Bank or issuer: the name of the bank or card issuer that the buyer used to make a payment.
• Billing address: the street address, city, state, zip code, and country for the payment method that the buyer used to make a payment. 
• Billing address city: the city for the payment method that the buyer used to make a payment.
• Billing address country: the country for the payment method that the buyer used to make a payment.
• Billing address line 1: the street address for the payment method that the buyer used to make a payment.
• Billing address line 2: the apartment, unit number, or building for the payment method that the buyer used to make a payment. This is an optional field.
• Billing address state:
• Billing address zip: the zip code for the payment method that the buyer used to make a payment. 
• Created by user ID: the user who created the payment. This value is set automatically by HubSpot.
• Currency code: the currency code for the payment. This will be in USD. 
• Customer: the email address of the buyer who made the payment.
• Gross amount: the total amount the customer was charged.
• Gross amount in company currency: the total amount the customer was charged in the account's default currency.
• Internal comment: an internal note/comment made by a user when a payment is made from an invoice.
• Last four digits: the last four digits of the bank account or card used as the payment method.
• Line item discount amount: the line item discount amount.
• Line item discount amount in company currency: the line item discount amount in the account's default currency.
• Max refundable amount in company currency: the maximum amount that can be refunded in the account's default currency.
• Net amount: the total amount you collected after fees and any refunds. It's possible for this amount to be negative if you refund the payment, since fees aren't returned.
• Net amount in company currency: the total amount you collected after fees and any refunds, in the account's default currency. It's possible for this amount to be negative if you refund the payment, since fees aren't returned.
• Net amount in settlement currency: the total amount you collected after fees in the settlement currency.
• Object ID: the unique HubSpot record ID generated for each payment. This value is automatically set by HubSpot and may not be modified.
• Object create date/time: the date and time at which this record was created. This value is automatically set by HubSpot and may not be modified.
• Object last modified date/time: most recent timestamp of any property update for this record. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
• Order discount amount: the discount amount on the total order.
• Order discount amount in company currency: the discount amount on the total order, in the account's default currency.
• Order discount code: the discount code used on the order.
• Order discount percentage: the discount percentage on the order.
• Owner: the HubSpot owner of the payment.
• Owner assigned date: the most recent timestamp of when an owner was assigned to the payment. This value is set automatically by HubSpot.
• Owner's main team: the main team of the owner of the payment. This value is set automatically by HubSpot.
• Payment ID: the unique payment ID generated for your billing records and receipts. This value is automatically set by HubSpot and may not be modified.
• Payment date: the date the customer submitted the payment or was charged by HubSpot for a recurring payment.
• Payment method: the way the customer made the payment (e.g., credit card).
• Payment source name: the internal name of the payment link that created the payment.
• Payment type: the line item types on the payment (one-time/initial, or recurring).
• Platform fee: the total amount charged to facilitate this payment. To see the current rates, select Payments in Settings, then in the upper right, click Actions, then select View commerce fees.
• Platform fee in company currency: the total amount charged to facilitate this payment in the portal's default currency. To see the current rates, select Payments in Settings, then in the upper right, click Actions, then select View commerce fees.
• Platform fee in settlement currency: the total amount charged to facilitate this payment in the settlement currency. To see the current rates, select Payments in Settings, then in the upper right, click Actions, then select View commerce fees.
• Processing fees: the total amount charged to process this payment. To see the current rates, select Payments in Settings, then in the upper right, click Actions, then select View commerce fees.
• Processing fees amount in company currency: the total amount charged to process this payment in the settlement currency. To see the current rates, select Payments in Settings, then in the upper right, click Actions, then select View commerce fees.
• Processing fees amount in settlement currency: the total amount charged to process this payment in the settlement currency. To see the current rates, select Payments in Settings, then in the upper right, click Actions, then select View commerce fees.
• Processor: the processor used to collect the payment.
• Record Source: how this record was created.
• Record Source Detail 1: first level of detail on how this record was created.
• Record Source Detail 2: second level of detail on how this record was created.
• Record Source Detail 3: third level of detail on how this record was created.
• Reference number: the reference number associated with the external payment.
• Refunded: the total amount refunded to the customer.
• Refunded amount in company currency: the total amount refunded to the customer in the portal's default currency.
• Settlement currency code: the currency code that the merchant's payments will settle in.
• Shipping address: the street address, city, state, zip code, and country where the buyer will receive the goods that they purchased. 
• Shipping address city: the city where the buyer will receive the goods that they purchased. 
• Shipping address country: the country where the buyer will receive the goods that they purchased. 
• Shipping address line 1: the street address where the buyer will receive the goods that they purchased. 
• Shipping address line 2: the apartment, unit number, or building where the buyer will receive the goods that they purchased. This is an optional field. 
• Shipping address state: the state where the buyer will receive the goods that they purchased. 
• Shipping address zip: the zip code where the buyer will receive the goods that they purchased. 
• Source: the object, tool, or integration that created the payment.
• Source ID: the unique ID for the object, tool, or integration that created the payment.
• Source URL: the URL for the object, tool, or integration that created the payment.
• Status: the current status of the payment. 
  • Processing: payment processing time will depend on the payment method used. Once the payment is processed, the status will either change to Succeeded or Failed. If using a bank debit method, such as ACH, the processing times are:
    • ACH: it can take up to four business days to debit a buyer's bank account, during which time the status will appear as Processing.
    • BACs: it can take up to five business days to debit a buyer's bank account, during which time the status will appear as Processing.
    • PADs: it can take up to five business days to debit a buyer's bank account, during which time the status will appear as Processing.
    • SEPA: it can take up to 14 business days to debit a buyer's bank account, with an average of five business days.
  • Succeeded: the payment was successfully collected from the buyer.
  • Failed: the buyer's payment method wasn't successfully charged. This status only applies payments made via bank debit, such as ACH, or subscription payments.
  • Partially refunded: the payment was refunded for an amount less than what the buyer originally paid.
  • Refunded: the total amount of the original payment was refunded. 
    Processing refund: a refund request was submitted. Refunds for payments made with bank debit, such as ACH, can take five to ten business days to process. 
• Status updated on: the last time the status of the payment was updated.
• Total discount amount: the sum of all discounts on a payment collected from the buyer, including line-item and order discounts.
• Total discount amount in company currency:
• Total Fees: the sum total amount of all fee line items paid. This property is only available in reporting and won't appear on payment records.
• Total fees in company currency:
• Total Taxes: the sum of all collected taxes in a single payment charged by a merchant.
• Total taxes in company currency: the sum of all collected taxes in a single payment charged by a merchant, in the portal's default currency.
• Updated by user ID: the user who last updated the payment. This value is set automatically by HubSpot.

Subscription properties

You can use subscription properties in lists. Users in a Marketing Hub, Sales Hub, Service Hub, or Operations Hub Professional or Enterprise account can use subscription properties in workflows and custom reports.

• Annual recurring revenue: the annual recurring revenue from the subscription.
• Annual recurring revenue in company currency: the annual recurring revenue from the subscription, in your company's currency.
• Associated records: other records the subscription is associated with. For example, a subscription could be associated to a payment.
• Churn date: shows when the subscription status has changed to Inactive or Unpaid.
• Collection process: describes the payment collection process for the subscription (e.g., automatic vs manual).
• Contact email: the email address of the contact associated to the subscription. This is the primary email address used for subscription related emails.
• Created by user ID: the user who created the subscription. This value is set automatically by HubSpot.
• Currency code: the currency code of the subscription. This will be in USD. 
• End date: the date the subscription will end.
• Last modification reason: reason for last subscription edit.
• Last payment amount: the amount that was charged for the subscription during the most recent billing period.
• Last Payment Date: when the last payment processed for the subscription.
• Merged record IDs: the list of record IDs that have been merged into this record. This value is automatically set by HubSpot and can't be changed.
• Monthly recurring revenue: the monthly recurring revenue from the subscription.
• Monthly recurring revenue in company currency:
• Name: the name of the subscription.
• Net Payment Terms: the amount due at the start of the next billing period.
• Next billing date: the next billing date where the subscription will be invoiced. If the collection method value is automatic_payments, the subscription will be automatically charged. If the collection method value is manual_payments, an invoice will be created.
• Next payment amount: the value to be processed on next payment date. If next payment date is null, the property is set to empty.
• Number of completed payments: the number of payments that have been successfully processed for the subscription.
• Number of expected payments: the number of total payments expected for the subscription.
• Object create date/time: the date and time at which this record was created. This value is automatically set by HubSpot and can't be changed.
• Owner: the owner of the subscription.
• Owner assigned date: the most recent timestamp of when an owner was assigned to the subscription. This value is set automatically by HubSpot.
• Owner's main team: the main team of the owner of the subscription. This value is set automatically by HubSpot.
• Payment method: the payment method on file for this subscription.
• Payment source: the object or tool that created the subscription.
• Payment source ID: the unique ID for the object or tool that created the subscription. This value is automatically set by HubSpot and can't be changed.
• Processor: the processor for collecting subscription payments.
• Recipient company city: the city of the recipient's company or organization.
• Recipient company postal code: the postal or zip code of the recipient's company or organization.
• Recipient company state/region: the state or region of the recipient's company or organization.
• Recipient company street address: the address of the recipient's company or organization.
• Recipient company street address 2: additional address of the recipient's company or organization.
• Record ID: the unique ID for this record. This value is set automatically by HubSpot.
• Record Source: how this record was created.
• Record Source Detail 1: first level of detail on how this record was created.
• Record Source Detail 2: second level of detail on how this record was created.
• Record Source Detail 3: third level of detail on how this record was created.
• Recurring billing frequency: how often the customer is billed for the subscription.
• Start date: the date the subscription is scheduled to start, which is the day of the first payment. 
• Status: the status of the subscription. The subscription status can be Active, Past due, Unpaid, Canceled, Scheduled, or Expired. 
• Subscription modified on: the timestamp in epoch milliseconds for when a subscription was last changed.
• Total collected amount: the total amount collected from the subscription. 
• Total Remaining Amount: the total amount remaining to be collected for subscriptions with a fixed number of payments. The amount is in the currency of the subscription.
• Update payment method link: link to update payment method on this subscription.
• Updated by user ID: the user who last updated the subscription. This value is set automatically by HubSpot.