Petty Cash data model
Petty Cash refers to small amounts of cash kept aside for operational expenses such as office lunches, coffee supplies, parking, etc. This data source brings in details about all petty cash transactions- both receipts and expenses.
Example use cases
Petty cash spent over time
Petty cash spent against each expense category
Opening and Closing balance at the end of each transaction
Granularity of the data
At the most basic level, data is organized at a transaction level. Every receipt or expense in the petty cash register is populated in a separate row. Further, if existing transactions are voided, these details are also captured. On Oct 31st, there was a receipt of $100 due to an inflow from 'Business Cash'. The corresponding petty cash register was empty prior to this transaction and the closing balance is $100 post the transaction. On the same day, there was an expense of $50, bringing the closing balance to $50. The next day, there was another receipt of $22 due to an inflow from 'Business Cash', bringing the closing balance to $72. The above transactions are captured in the pink rows. Then on Nov 1st, there was a receipt of $25. This was entered on 17:49:26. A few seconds later at 17:49:32, this transaction was voided. Due to this, a reversal amount of $25 is populated against the same transaction and the opening and closing balance remain the same at $72. This transaction is reflected in the yellow row. In the following few days, there was an expense of $22, a receipt of $100, and another expense of $16. This brings the closing balance from $72 to $134. These transactions are reflected in the gray rows.
 |
Note
This data source is maintained from Jan 1, 2016. If there are transactions in the petty cash register prior to this date, then all the transactions are aggregated to get the opening balance as of Jan 1, 2016 and inserted into the data source with 'entry id' as ‘00000000-0000-0000-0000-000000000000’. Following this entry, individual transactions are captured in the data source. If transactions are added for dates in the past or past transactions are voided, the opening and closing balances of transactions after that date get recomputed to reflect these changes.
Group | Description | Field | Definition | Examples/Notes | Data Type |
|---|---|---|---|---|---|
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the petty cash transaction is recorded. | organization name | The formal name of the organization. | 'Massage Spa Express' is the formal name of an organization. | varchar(512) |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the petty cash transaction is recorded. | organization account name | The domain name of the organization in Zenoti. | If you use this URL to log in to Zenoti 'https://massagespa.zenoti.com', then "massagespa" is your account name. The formal name and domain name may be different. | varchar(256) |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the petty cash transaction is recorded. | center name | The center where the petty cash transaction is recorded. | varchar(128) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the petty cash transaction is recorded. | center company name | The name under which the center is registered. | Businesses, especially in a franchisee model, may register each center as a different company - such details are tracked in the Centers > General tab. | varchar(128) |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the petty cash transaction is recorded. | is center franchise | This flag indicates whether the center is a franchisee. - True: Indicates that it is a franchisee. - False: Indicates it is not a franchisee. | boolean | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the petty cash transaction is recorded. | center cstn number | The center's Central Sales Tax (CST) number. | varchar(80) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the petty cash transaction is recorded. | center tin number | The center's Taxpayer’s Identification Number (TIN). | varchar(80) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the petty cash transaction is recorded. | center tot number | The center's Transient Occupancy Tax (TOT) number. | varchar(80) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the petty cash transaction is recorded. | center service tax number | The center's Service Tax number. | varchar(80) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the petty cash transaction is recorded. | center vat number | The center's Value-Added Tax (VAT) number. | varchar(80) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the petty cash transaction is recorded. | center luxary tax number | The center's Luxury Tax number. | varchar(80) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the petty cash transaction is recorded. | minutes to add | The number of minutes that need to be added to UTC time to get the current time at the center. Timestamps generated by Tableau [E.g. if you use filters such as Today, Tomorrow, etc.] are in UTC, hence this field is needed to arrive at the center time. This is not needed for timestamps that are in the data source directly as these are already in the center time zone. | integer | |
Petty Cash | These fields bring in the details of the petty cash transaction. | petty cash description | The description of the petty cash transaction. | varchar(400) | |
Petty Cash | These fields bring in the details of the petty cash transaction. | category name | The category associated with the petty cash transaction. | Example: Food expenses | varchar(100) |
Petty Cash | These fields bring in the details of the petty cash transaction. | category description | The description of the category associated with the petty cash transaction. | Example: Office lunches and other snacks for employees | varchar(400) |
Petty Cash | These fields bring in the details of the petty cash transaction. | entry type | An indicator of whether the transaction is a receipt or an expense. | varchar(50) | |
Petty Cash | These fields bring in the details of the petty cash transaction. | source | This field indicates the source of a Petty Cash Receipt. Possible Values: - Business Cash: Indicates that the receipt was due to a transfer of cash from Business Cash to the Petty Cash Register. - Other: Indicates that the receipt was from a source other than Business Cash. For Petty Cash Expenses, this field as populated as 'Other' by default. | varchar(50) | |
Petty Cash | These fields bring in the details of the petty cash transaction. | voucher no | A voucher number associated with the petty cash transaction. This is unique within receipts and unique within expenses, but it may not be unique across both together. | varchar(40) | |
Petty Cash | These fields bring in the details of the petty cash transaction. | amount | The amount associated with the petty cash transaction. | float | |
Petty Cash | These fields bring in the details of the petty cash transaction. | reporting date | The date on which the petty cash transaction occurred. | It is possible to enter petty cash transactions for previous days. For example, a transaction occurred on March 1st. But the employee forgot to enter it on March 1st and instead entered it on March 5th. On March 5th, the employee can choose to set the reporting date for the transaction as March 1st. In this case: reporting date = March 1 entered on = March 1 10:55:14 last updated = March 5 10:55:24 | date |
Petty Cash | These fields bring in the details of the petty cash transaction. | entered on | The timestamp at which the petty cash transaction occurred. | It is possible to enter petty cash transactions for previous days. For example, a transaction occurred on March 1st. But the employee forgot to enter it on March 1st and instead entered it on March 5th. On March 5th, the employee can choose to set the reporting date for the transaction as March 1st. In this case: reporting date = March 1 entered on = March 1 10:55:14 last updated = March 5 10:55:24 | timestamp |
Petty Cash | These fields bring in the details of the petty cash transaction. | last updated | The timestamp at which the petty cash transaction is last updated. Transactions may get updated for various reasons such as to change description details or to void entries or to backdate entries. | It is possible to enter petty cash transactions for previous days. For example, a transaction occurred on March 1st. But the employee forgot to enter it on March 1st and instead entered it on March 5th. On March 5th, the employee can choose to set the reporting date for the transaction as March 1st. In this case: reporting date = March 1 entered on = March 1 10:55:14 last updated = March 5 10:55:24 | timestamp |
Petty Cash | These fields bring in the details of the petty cash transaction. | opening balance | The opening balance of the petty cash register prior to the corresponding transaction. | numeric(18,2) | |
Petty Cash | These fields bring in the details of the petty cash transaction. | closing balance | The closing balance of the petty cash register after the corresponding transaction. | numeric(18,2) | |
Petty Cash | These fields bring in the details of the petty cash transaction. | void | Indicates whether a petty cash transaction is voided or not. When an existing transaction is voided, this field gets updated for that transaction along with 'reversal amount' to negate the original transaction. - 1: Void transaction - 0: Valid transaction | integer | |
Petty Cash | These fields bring in the details of the petty cash transaction. | reversal amount | The amount which is reversed from petty cash. This is populated for voided transactions. | numeric(18,2) | |
Petty Cash | These fields bring in the details of the petty cash transaction. | reversal entered on | The timestamp at which the reversal entry occurred. This is populated for voided transactions. | timestamp | |
Petty Cash | These fields bring in the details of the petty cash transaction. | cash register name | The name of the cash register associated with the petty cash transaction. | varchar(512) | |
Petty Cash | These fields bring in the details of the petty cash transaction. | cash register code | The unique code of the cash register associated with the petty cash transaction. | varchar(64) | |
Petty Cash | These fields bring in the details of the petty cash transaction. | entry id | A unique identifier for the petty cash transaction. This is generated in Analytics, it does not exist in the core system. | varchar(36) | |
Petty Cash | These fields bring in the details of the petty cash transaction. | category id | A unique identifier for the category associated with the petty cash transaction. This is generated in Analytics, it does not exist in the core system. | varchar(36) | |
Petty Cash | These fields bring in the details of the petty cash transaction. | cash register id | A unique identifier for the cash register associated with the petty cash transaction. This is generated in Analytics, it does not exist in the core system. | varchar(36) | |
Employee | These fields detail the attributes of the employee who entered a transaction in the petty cash register. | entered by employee first name | The first name of the employee who entered a transaction in the petty cash register. | varchar(160) | |
Employee | These fields detail the attributes of the employee who entered a transaction in the petty cash register. | entered by employee middle name | The middle name of the employee who entered a transaction in the petty cash register. | varchar(256) | |
Employee | These fields detail the attributes of the employee who entered a transaction in the petty cash register. | entered by employee last name | The last name of the employee who entered a transaction in the petty cash register. | varchar(256) | |
Employee | These fields detail the attributes of the employee who entered a transaction in the petty cash register. | entered by employee - code | The unique code of the employee who entered a transaction in the petty cash register. This is the code taken from the employee's profile in Zenoti. | varchar(128) | |
Employee | These fields detail the attributes of the employee who entered a transaction in the petty cash register. | entered by employee code | The unique code of the employee who entered a transaction in the petty cash register. This is the code taken from the employee's guest profile. When an employee's profile is created, Zenoti automatically creates their guest profile. Note: The 'employee code' is usually the same as 'employee - code' unless someone manually changes it in the employee's guest profile. | varchar(128) | |
Employee | These fields detail the attributes of the employee who entered a transaction in the petty cash register. | entered by employee job name | The job name associated with the employee who entered a transaction in the petty cash register. | Therapist, Manager, Aesthetician etc. | varchar(1020) |
Employee | These fields detail the attributes of the employee who entered a transaction in the petty cash register. | entered by employee job code | The unique code associated with the job of the employee who entered a transaction in the petty cash register. | varchar(1020) |