
Sharing the records with a partner or employee
If several people make entries, everyone must follow the same rules or the table turns into a mess.
When one person keeps the records, the table lives in his head: only he knows what each column means and what "a set" refers to. Once a second person joins, whether a partner, a salesperson or a family member, everything changes. The table becomes shared while the rules stay in one person's memory. The result shows within weeks: rows get duplicated, balances do not match and "who wrote this?" becomes a daily question. Below is not a complex manual but five simple rules. As an example, take a home-textile shop in Andijan: blankets, bedspreads, bed-linen sets, two partners and one salesperson.
Three people, three methods
The first partner enters bed linen as "set", the second as "piece" and the salesperson as "bundle". One product splits into three rows in the table, each with its own balance. On top of that, one evening the first partner makes five changes to the table, and the next day the second opens an old copy on his phone and writes over it. Five changes vanish in an instant and nobody notices. The problem is not the people: there is no single rule.
Five rules
Each rule is small, but together they make a table for three as accurate as a table for one.
Rule 1: one file, one place
Do not send the file to each other through Telegram or WhatsApp. Every file sent is a new copy and every copy is a new "truth". Work in a shared online sheet (for example Google Sheets or the cloud version of Excel): one copy, one address, and changes visible to everyone at once. Move old files to an archive folder and agree not to open them.
Rule 2: who may write what
Not everybody should be able to change everything. A typical split:
- the salesperson only adds new rows on the "sales" and "receiving" sheets;
- balances, prices and formulas are protected and only the responsible partner changes them;
- the second partner sees everything and can leave comments.
Spreadsheet programs let you protect sheets and cells, a one-off setup.
Rule 3: one form of entry
Use drop-down lists instead of free text: product name, unit and status are chosen from a list. Each row should have four things: date, who entered it, code, quantity. Write the units down at the edge of the sheet: "1 set = 1 sheet + 2 duvet covers + 2 pillowcases". The "set, piece or bundle" argument then disappears.
Rule 4: leave a trace of changes
If you find a mistake, do not delete the old row but write a correcting row beneath it: "−3 pieces, reason: entered twice". The version history in spreadsheet programs shows who changed a cell and when. This is not for blaming but for finding out: more often than not the author of the edit explains the cause within a minute.
Rule 5: close the day together
Have the day's entries made by 9 p.m. In the morning a second person spends five minutes comparing the till with the sales table. If a partner or employee takes goods for personal use, record it as "against share" or "own use" rather than taking it silently.
Money and shares between partners
Separate the stock records from the division of money. If a partner takes cash from the shop, it is recorded on a separate sheet as "drawn by owner" and counted when profit is shared. For example, the month's profit is 14 million so'm, the partners get 50 percent each, so each share is 7 million. The first partner drew 3 million during the month, the second 1 million. At month end the first is owed 7 − 3 = 4 million and the second 7 − 1 = 6 million so'm. Without this calculation on paper, disagreements arise not from stock but from memory. Hold a half-hour meeting once a month and go through three figures: takings, profit and the value of stock.
Conclusion
Shared records do not need a powerful tool, they need an agreed rule: one file, clear roles, one form of entry, a trace of changes and closing the day together. Then a table for three is as accurate as a table for one. If you need help drafting the rules or training staff in them, the AniqHisob team can run a starting count and help set up how you work with employees.