Sausage Casings'  Transactions Spreadsheet
Originally published: 21/09/2020 12:12
Publication number: ELQ-60826-1
View all versions & Certificate

Sausage Casings' Transactions Spreadsheet

This template will help you to manage your inventory in purchasing, return and resale transactions...

This template will help you to manage your inventory in purchasing, return and resale transactions...
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.

This Best Practice includes
1 Excel File

Ilgar Zarbaliyev offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

To help startups to follow their inventory who specifically deal with the sausage casings purchasing and resale.

If startup is cooperating on cash basis with Suppliers.

If Startup is granted to purchase goods for further resale on credit basis, spreadsheet is subject to some changes in formulas.

5.0 / 5 (1 votes)

please wait...