Home | Contact
whichnas.com

Run a Shared Stock Sheet From Your Own Network Attached Storage

Small retailers in Melbourne and Brisbane often keep a master stock count in a single spreadsheet that gets emailed around, overwritten, and lost. A network-attached storage unit sitting in the back office can hold that file and let several staff open the same workbook over the office Wi-Fi. Because the device lives on the premises, there is no monthly subscription climbing every time a new branch is added. The hardware pays for itself in a year or two for most operations with more than three stockkeepers.

Synology DiskStation and QNAP Turbo NAS models both speak the SMB protocol that Windows, macOS, and Linux use to open shared documents. A worksheet saved as .xlsx or .ods behaves like any other file on the share, which means staff do not need to learn a new program. The trick is to configure the folder so the right people have read or write access, and to keep versions of the workbook so yesterday's figures can be recovered when someone deletes a column by mistake.

Keeping that workbook inside Australia also sidesteps a few worries that surfaced when the Privacy Act 1988 was tightened through the Australian Privacy Principles. A local box is not a silver bullet, but it makes the audit conversation shorter when a wholesale customer asks where their order history is held.

Why a NAS beats a monthly subscription for stock lists

For most small operations, the cheapest tier of a popular cloud spreadsheet service caps at a handful of editors and charges per extra seat. A four-bay Synology or QNAP box bought outright costs less than two years of those per-user fees and continues running long after. A spreadsheet with hundreds of SKUs and several thousand rows opens faster from a local LAN share than from a remote server, especially on the patchy NBN connections found around parts of regional Victoria and South Australia.

Power draw is modest too. A two-bay unit pulling 15 to 20 watts adds only a few dollars a quarter to the bill, far less than the hidden cost of cloud licences for a team of five or six. Storage can grow by swapping in larger drives, which suits warehouses that expand SKU ranges seasonally, such as Adelaide retailers stocking extra lines before the Christmas rush.

The other quiet benefit is independence. When the office internet drops, work on the inventory file continues because the share lives inside the building. Staff in the Sydney head office can keep counting pallets while the Perth branch reconnects.

Picking the right platform and RAID level

Synology's DSM and QNAP's QTS both expose a graphical control panel for creating shared folders, mapping them to network drives, and managing user accounts. For a stock sheet that is updated daily but holds relatively little data, a two-bay model in RAID 1 is plenty. The second drive mirrors the first, and the file stays reachable even if one disk fails.

If the inventory database is expected to grow into hundreds of thousands of rows, or if the business plans to add surveillance footage or a media library to the same box, a four-bay unit in RAID 5 or SHR offers more headroom. SSD caching is optional for spreadsheet workloads but helpful when several staff open the workbook at once during a morning stocktake.

RAM matters less than disk choice for this job, though 4 GB is a sensible floor. Australian retailers who already run an Uninterruptible Power Supply on their point-of-sale gear should plug the NAS into the same UPS so a sudden blackout does not corrupt the open file.

Setting up the shared folder and permissions

Create a dedicated volume or folder named something like Inventory, then enable SMB sharing from the control panel. A separate user account for each stockkeeper keeps the access list tidy, and group permissions make it easy to grant read-only access to the accountant who only needs to see totals.

Mapping the share as a network drive on each workstation lets the workbook sit at a consistent path, which matters when a macro or formula references another sheet. A simple convention such as Z:\Inventory\master-stock.xlsx removes the guesswork for new hires.

Versioning deserves attention too. Synology Snapshot Replication and QNAP's version manager can keep hourly or daily copies of the shared folder, so a wrong keystroke at 4 p.m. does not ruin the morning count. Schedule snapshots during quiet hours to avoid slowing edits when the floor staff are busiest.

Concurrent edits, file locking, and avoiding clashes

Spreadsheets are not designed for live multi-user editing the way a database is, so coordination matters. Microsoft Excel relies on a lock file placed alongside the workbook to warn the second opener that someone else is editing. LibreOffice Calc behaves similarly through its own lock mechanism. Staff should be told to close the file when they finish a session rather than leaving it locked overnight.

For tighter teamwork, a database front-end such as FileMaker or Airtable exports to a spreadsheet shape but handles concurrent writes properly. A small business that has outgrown the shared workbook can move the same data onto MariaDB running on the NAS, with the spreadsheet kept as a reporting view.

Audit fields inside the sheet also help. Columns for last edited by, timestamp, and change reason create a paper trail when a discrepancy appears between the physical count and the recorded figure. The combination of file versioning and audit columns has resolved more than a few arguments in Brisbane warehouses during end-of-financial-year stocktakes.

Backing up the workbook and recovering from mistakes

The 3-2-1 rule still applies: keep three copies, on two kinds of media, with one offsite. The NAS itself is the first copy. A second Synology or QNAP unit at a branch in another city, such as a Melbourne site backing up to a Sydney box, covers the offsite requirement over the office VPN. Cloud snapshots to Backblaze B2 or Wasabi provide a third tier at low cost.

Test the restore path every quarter. A backup that has never been restored is just a hope. Pull a single file from the offsite copy and open it on a spare laptop to confirm the version history is intact and the data is readable.

Snapshot retention should match how far back stockkeepers ever need to revisit. Thirty daily snapshots cover most seasonal queries, while weekly snapshots going back a year handle the slower drift of discontinued SKUs and supplier rebates. Pruning older snapshots keeps the storage pool from filling with duplicates.

Privacy, compliance, and Australian data rules

The Privacy Act 1988 and the Australian Privacy Principles apply to businesses with an annual turnover above AUD 3 million, plus a few specific categories below that threshold. A stock sheet holding customer names, delivery addresses, or order histories tied to identifiable people sits inside that definition. Storing the file on local hardware does not exempt the business from the Notifiable Data Breaches scheme, but it does keep the data inside Australian jurisdiction.

Encrypt the shared folder at rest and require SMB signing if the NAS supports it. Disable the default admin account, force strong passwords, and switch the management portal to HTTPS. Two-factor authentication on the NAS admin login is a small step that blocks the most common credential-stuffing attacks aimed at exposed internet interfaces.

If the business also handles credit card data, the same workbook may need to comply with the Payment Card Industry Data Security Standard. Keeping card numbers out of the inventory file entirely is the simplest answer; reference an order ID instead and look up payments in the dedicated POS system.

Practical settings for the shared inventory folder

Daily habits that keep the stock sheet healthy

Browse the WhichNAS.com product tables to compare two-bay and four-bay Synology and QNAP models suited to spreadsheet hosting, and read the archived buyer guides for RAID layouts, SSD caching trade-offs, and SMB tuning tips that suit regional NBN links. The reference section links back to earlier material on rack mounting for taller server cabinets in retail back rooms, and the buyer guides list current Australian pricing and warranty terms for stocktaking season and beyond.