Guide: Cooking the Books
How do core concepts map to Tenzo?
Key: ✅ Supported 🚸 Work in Progress ❌ Not supported
 |
|
|---|---|
| Location | ✅ Outlet |
| Vendor | ✅ Supplier |
| Category | ✅ Category |
| Item | ✅ Stock Item |
| Purchases | ✅ Purchases |
| Actual Usage | ✅ Actual Usage |
| Theoretical Usage | ✅ Theoretical Usage |
| Stock Counts | ❌ Not supported |
| Recorded Wastage | ✅ Wastage |
Data Ingestion
| Real-time optionally available? | ❌ |
| Default polling frequency | Daily overnight |
| Data retrieved on each poll | Last 2 weeks of Purchases and Wastage sent daily. Actual Usage is sent on stock counts for data since the last stock count. Theoretical Usage is sent daily for the last day. Purchases and Actual Usage is also sent once per month. |
| Historical data | Last 2 weeks from date of setting up integration. |
How do I connect this data to Tenzo?
Cooking the Books needs to send data to Tenzo via an SFTP. Talk to your Tenzo Customer Service Manager and they'll work with Cooking the Books to setup this data flow
How do I compare Cooking the Books data to data in Tenzo?
Purchases
Purchases in Tenzo can be viewed by going to the Inventory module then choosing 'Purchases' from the drop down:
In Cooking the Books, this data can be viewed in the Item Spent Report, usually found under Stock -> Report.
Actual Usage
Actual Usage can be found in Tenzo in the Inventory module by choosing 'Actual Usage' from the drop down (see Purchases above).
In Cooking the Books, this data can be viewed in the Stock Used Report, also under Stock -> Report (see above).
Theoretical Usage
Theoretical Usage can be found in Tenzo in the Inventory module by choosing 'Theoretical Usage' from the drop down (see Purchases above).
In Cooking the Books, this data can be viewed in the Theoretical Usage Report, under Financial -> Report.
Wastage Usage
Wastage can be found in Tenzo in the Inventory module by choosing 'Waste and Unrecorded Usage' from the drop down (see Purchases above).
In Cooking the Books, this data can be viewed in the Wastage Report, under Financial -> Wastage Records.
Exceptions
- Actual Usage can be slightly mismatching. This is because the cost of the items at the time of viewing the Stock Used Report can be different to the cost of the items when the data was exported from Cooking the Books.