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. 

#integrations