This spreadsheet is consisted of the following 11 (eleven) worksheets:

1 - Cover

2 - Chart

3 - Rates

4 - Assumptions

5 - Set_Up_Process

6 - Suppliers

7 - Products

8 - Customers

9 - Transactions

10 - Cash

11 - Reports


  • Chart sheet gives you brief information about Sausage Casings Types.


  • Rates worksheet gets daily rates using Power Query. Depending on National Bank of Azerbaijan's web site, user must manually enter date in source step of Power Query to refresh the rates.  Please look at attached photo.
    You may find assumptions in the assumptions worksheet
  • Chart of Setup Process step by step can be found in the form of Organizational Chart in Set_Up_Process worksheet
  • Casings Suppliers with their contact information in Suppliers Worksheet
  • Products information in Products Worksheet
  • Customers in Azerbaijan in Customers Worksheet
  • Import, Sale, Return Transactions are done in Transactions Worksheet.
  • Cash based transactions can be found in Cash Worksheet
  • Three reports (Suppliers Based, Customers Based and Products Based) are shown in Reports Worksheet.

    Unique drop-down lists like Investors, Customers, Suppliers gathered using Power Query.  Some excel functions including Sumifs, Xlookup, If, etc. used in this spreadsheet.
    Wish you good luck in your business.

Reviews Add a review

I found this template very useful. It can be used for small-size companies to follow and control their inventory.
However, some points are subject to improvement.

More From Ilgar Zarbaliyev

Browse our top rated business templates. See All
Row, Column, Index, Match, Offset Functions. Excel Tutorial
 “It's Excel's world, we just live in it.” “To be an accountant in the age of spreadsheet program is —…
New Dynamic Functions. Excel Tutorial
In September, 2018, we released dynamic array formulas for Excel for Microsoft 365. The differences between dynamic arrays and legacy…
Fill Series. Data Validation. Excel Tutorial
 If you have inherited workbooks from someone else or if you have imported data from external data sources, you have…
 This report includes the necessary analyzes according to some characteristics of the people who made and participated in the job…
 Hello, This report is consisted of four pages. 1-Supplier Quality Metrics 2-Supplier Quality Regional 3-Top - Bottom Analysis 4-Downtime Analysis…
Sales_Analysis_Reportin Power BI
Hello, After participating in Enterprise DNA programs, I prepared reports on three topics in Power BI. The first report I…
See All