建材卸の拠点間移送 発送・受入CSV照合表 / Building Materials Wholesale: Inter-Site Ship/Receive CSV Matching Sheet

建材卸の拠点間移送 発送・受入CSV照合表 建材・金属材料の発送と分割受入を移送明細IDで照合する、日本語のExcelマクロ形式（.xlsm）の企画です。自社2倉庫間の小規模な移送を想定し、繰り返しの記録確認を減らすことを目指します。 指定列に整えた発送・受入のUTF-8 CSVを読み込み、受入数量の合計と発送数量の差を確認。元記録に共通IDが必要です。入力の確認・訂正と結果の確認を同じシート内で行う設計です。 同じ単位で100発送し、60と30を受け入れれば残り10、追加で10を受け入れて再照合すれば未受入が解消します（架空の例）。不足・超過・到着予定日超過・重複ID・不明IDを、該当IDや理由とともに示し、倉庫への確認や原資料の見直しを支援する予定です。 現在は企画段階で製造未着手。機能は予定で、実機動作・時間削減効果は未検証です。Windows 11・Microsoft 365デスクトップ版Excel（64bit・日本語）、マクロ許可環境での1人編集が前提。結果は画面上で確認します。在庫全体の管理・在庫評価・運送手配・単位換算・外部連携・同時編集・印刷対応は対象外です。 お仕事の依頼：ramaya08010801@gmail.com Inter-Warehouse Transfer Reconciliation for Building Materials Wholesalers A planned Japanese macro-enabled Excel workbook (.xlsm) to match building material and metal supply dispatches with partial receipts by transfer line ID. It targets small batches between two warehouses in one company, aiming to reduce repeated record searches. Import dispatch and receipt UTF-8 CSVs with the required columns and matching source IDs. Compare total receipts with dispatch quantities; review/correct inputs and check results on the same worksheet. Illustrative example, in the same unit: dispatch 100, receive 60 and 30, leaving 10; receive the final 10 and reconcile again to clear the balance. Planned results flag shortages, excess receipts, overdue arrivals, and duplicate or unknown IDs, with IDs and reasons to guide warehouse inquiries and source-record review. Planning only: development has not started; operation and time savings are untested. Requires Windows 11, Japanese 64-bit Microsoft 365 desktop Excel, macros permitted, and one editor. Prepare CSVs in the specified format; review results on screen. Excludes overall inventory management/valuation, transport arrangements, unit conversion, external integration, simultaneous editing and print layouts. Work inquiries/collaborations: ramaya08010801@gmail.com