Inward Outward Register Format In: Excel Free Portable Download

| Column Name | Description | |-------------|-------------| | | Serial number for unique record ID. | | Date | Date of receipt or dispatch. Use =TODAY() for auto-entry. | | Type | Dropdown: “Inward” or “Outward”. | | Reference No. | Invoice, GRN, or Gate Pass number. | | From/To Party | Supplier name (inward) or Customer name (outward). | | Description of Goods/Document | Clear details of item (e.g., “Invoice #234,” “Steel sheets 2mm”). | | Quantity | Number of units or boxes. | | Received/Dispatched By | Employee name handling the transaction. | | Remarks | Special notes (e.g., “Damaged packaging,” “Urgent”). |

Add a column for “Document Scanning Link” – paste the file path or OneDrive link to the scanned copy of the document. This turns your Excel register into a lightweight document management system. Inward Outward Register Format In Excel Free Download

This template is provided as-is. Always maintain data backups and restrict edit access in shared environments. For advanced cloud-based tracking (QR codes, mobile entry), consider upgrading to ERP software. But for 90% of SMEs, this Excel register is more than enough. | | Type | Dropdown: “Inward” or “Outward”

This sheet tracks everything going out of your office. | | From/To Party | Supplier name (inward)