ZenotiHelp

Donations Data Source

ZTZenoti Docs Team Updated June 28, 2026 5 min readGuide

The donations feature of Zenoti provides feasibility for guests to make donations for various causes. Businesses can add donations at the organization level and enable them for multiple centers. After enabling donations for a center, your business can start collecting donations. The Donations data source stores the donation amount at an invoice level and displays information such as the name of the donation, amount, and payment type.

Note The donation data is also made available in the Collections data source.

You create a donation named ‘Heal a Child Campaign’ and enable it for a center. While paying for the service she took, a guest, Judith Butler, makes a $60 donation for the cause. Out of the $60 donation, an employee, James Hill, collects $50, and another employee, JoshZ Anderson, collects $10. The invoice will list this information as follows:

When this data is moved to analytics, the data is made available in two data sources:

Data source

Points to note

Collections data source

  • Shows the total amount of donations collected for an invoice

  • Does not show the cause to which a donation is made.

  • Does not show the split of donations, if the guest donates to multiple causes.

  • Donations are displayed as a line item with “Amount type = Donations”, as shown in the following screenshot:

Donations data source

Shows information such as donation name, amount and payment type.

Group Field name Field description Example Field type
Center, Zone, Organization center city The city where the center is located. VARCHAR(128)
Center, Zone, Organization center code code associated with the center varchar(40)
Center, Zone, Organization center company name The name with which the center is registered. Center is the center name mentioned in "Center name" field Businesses, especially in a franchisee model, may register each center as a different company, such details are tracked in the Centers > General tab varchar(200)
Center, Zone, Organization center name The center where the record entry is made VARCHAR(128)
Center, Zone, Organization center state name The state where the center is located. VARCHAR(4096)
Center, Zone, Organization center time zone Timezone in which center is located VARCHAR(128)
Center, Zone, Organization center zip The zipcode of the center's location. VARCHAR(32)
Center, Zone, Organization country name The country where the center is located. VARCHAR(4096)
Center, Zone, Organization organization account name The domain name of the organization in Zenoti. VARCHAR(256)
Center, Zone, Organization organization name The formal name of the organization. VARCHAR(512)
Center, Zone, Organization zone name The zone to which the center belongs VARCHAR(800)
guest guest anniversary date Marriage anniversary date of the guest. This is a non-mandatory value and it can be blank timestamp
guest guest base center center where guest account is linked to VARCHAR(256)
guest guest city The city to which the guest belongs. This is a non-mandatory value and it can be blank. VARCHAR(128)
guest guest code code associated with the guest VARCHAR(128)
guest guest country name The country to which the guest belongs. This is a non-mandatory value and it can be blank. varchar(4096)
guest guest dob Date of Birth of the guest. This is a non-mandatory value and it can be blank. timestamp
guest guest email Email ID of the guest. This is a mandatory value and cannot be blank. VARCHAR(256)
guest guest first name First name of the guest. This is a mandatory value and cannot be blank. varchar(160)
guest guest gender Gender of the guest. This is a non-mandatory value and it can be blank. varchar(14)
guest guest home phone home phone number of the guest VARCHAR(64)
guest guest last name Last name of the guest. VARCHAR(256)
guest guest middle name Middle name of the guest. This is a non-mandatory value and it can be blank. VARCHAR(128)
guest guest mobile phone Mobile number of the guest. This is a mandatory value and it cannot be blank. VARCHAR(64)
guest guest phone code Phone country code of the guest. This is a mandatory value and it cannot be blank. integer
guest guest referral source The source from where the guest got to know about the organization. varchar(1600)
guest guest state The state to which the guest belongs. This is a non-mandatory value and it can be blank. varchar(4096)
guest guest tags The tags associated with the guest. varchar(65535)
guest guest type name An indicator of whether the guest is indeed a guest or an employee. VARCHAR(128)
guest guest zipcode The zipcode of the guest. This is a non-mandatory value and it can be blank. VARCHAR(128)
guest is guest inactive A flag indicating if the guest is inactive. A guest is considered inactive if his/her profile has been removed from the system.
  • True indicates that the guest is inactive.

  • False indicates that the guest is active. | | BOOLEAN | | invoice | invoice id | unique identifier for invoice | | varchar(36) | | invoice | InvoiceNo | Invoice number that helps in identifying and tracking the invoice. | | varchar(160) | | invoice | invoice itemid | unique identifier for lineitem in an invoice | | varchar(36) | | donation | donation name | Donation campaign name to which amount is donated | | VARCHAR(256) | | donation | donation amount | Amount donated | | DECIMAL(19,4) | | donation | donation description | Description of the donation campaign | | VARCHAR(4096) | | invoice | payment type | The mode of payment | Possible values:

  • Card: Through a credit card

  • Cash: Through cash

  • Check: Through a cheque

  • Packageusage: Through redemption of a package

  • Membershipusage: Payment done using benefits of a membership

  • MembershipCredit: Payment done using the credit value available through a membership

  • LP: Through redemption of loyalty points

  • GC: Through redemption of a giftcard

  • PPC: Through redemption of a prepaid card

  • Custom: Through a custom payment | varchar(100) | | invoice | payment option type | For card payments, the type of card gets populated here. For cheque payments, the name of the cheque gets populated here | For Card, the following are payment option types:

  • VISA

  • DEBIT CARD

  • DISCOVER

  • CHECK

  • CC

  • DINERS CARD

  • AMEX

  • UNIONPAY

  • DISCOVER CARD

For Cheque, the following are payment option types:

  • RBS

  • BANK OF AMERICA | varchar(40) | | invoice | transactionid | A unique non-blank identifier for each transaction. | If an invoice is paid by using two swipes of a credit card, then two unique transaction IDs get associated with the invoice | varchar(36) | | donation | donation collected date and time | Date and time on which donation is collected | | TIMESTAMP | | donation | donation collected date | Date on which donation is collected | | DATE |

Was this article helpful?
Your feedback helps us improve our documentation.