Browse categories
Explore
Fiverr Pro
English
$
USD
I will create an excel small business management system
About this Gig
A complete business management system on Excel. You will be able to use it to do the following:
- Log in your daily transactions smoothly, with a minimal amount of manual data entry to reduce human error and save time.
- See your current inventory status, and get a warning for items with lower inventory than a specified level [specified by you]
- See how your business is performing, how the sales are going, your revenue and your gross profit, through an interactive dashboard.
Qualities of the system:
- Works on Excel. No need to download or learn a new program.
- Contains safety features to prevent users [other than owner] from editing formulas or breaking the sheet.
- Auto-filling of data
- Inventory auto-updating based on the logged in transactions; sales = inventory goes down, returns/restocks = inventory goes up
What you will get:
- A full functional sheet you can immediately use
- A short video explaining how to use the sheet and how to add new data
- After sale support for a full month - till you get completely used to the new sheet
Technology:
Excel
Data type:
Numeric
•
String
•
Date
•
Phone
•
Free text
My Portfolio
FAQ
What type of data do you work with?
Any type of data. Get in touch, tell me how do you store your store's data, and we will work it out together.
I don't want the employees to have access to the dashboard, or to the formulas in the sheets
No problem. These areas can be locked from employees and accessed only using a password
What if the sheet doesn't work as intended after delivery?
Get in touch, and I will fix it for no extra charges
Can you create a sheet for the transactions for the employees, and another dashboard sheet for the owner?
Absolutely. Excel allows the connection of multiple separate sheets. Whenever the source [transactions] sheet is updated, the child sheets [dashboard] will get updated automatically.
