Paste the movements
Paste the receipt and issue lists separately. You can also paste opening quantities for stock held before the first movement.
Excel Tools
Excel Stock In / Stock Out Balance Sheet
Turn your receipts and issues into an editable Excel stock balance sheet. Keep every SKU and movement traceable.
Processed in your browser · Editable .xlsx download
How to Build Your Stock Balance Sheet
Match the columns
Choose the SKU and quantity columns in each list. Check whether the first row contains headings or data.
Review and export
Check balances and resolve highlighted input errors. Download your workbook and continue recording movements in Excel.
Key Features
Independent column mapping
Use different column names or column orders in the two logs.
Exact SKU matching
Keep 001 and 1 separate, along with codes that differ in capitalization.
Optional opening stock
Set a starting quantity for selected SKUs, including items with no movements yet.
Row-level checks
Locate invalid quantities, missing codes and repeated opening entries before export.
Negative balance warnings
Spot items where issues exceed receipts plus opening stock.
Editable Excel tables
Change past quantities or add rows to a movement table to recalculate existing SKU balances.
Reconciling inventory by SKU
Start each SKU with the quantity physically on hand just before the first movement in your lists. A blank opening counts as zero. If a balance looks low, compare the original receipt and dispatch lines before adjusting the starting count.
When two systems use different product lists, compare the SKU columns before combining them. Leading zeros, capitalization and units matter when you reconcile individual items.
Frequently asked questions
Will 001 and 1 stay separate?
Yes. The tool keeps codes as text and matches case exactly. If Excel already removed leading zeros in the source, restore them before pasting.
What if I only have receipts or issues?
Paste the list you have. An empty movement list contributes zero. Add opening stock when your records start after inventory was already on hand.
Can I paste a list without column headings?
Yes. Set First row to Data and choose the SKU and quantity columns. Excel cells, tab-separated text and comma-separated CSV are supported.
How do I update the workbook later?
Edit quantities in Stock In or Stock Out. To append a movement, press Tab from the last table cell or insert a table row. For a new SKU, also add it to Balance and copy the three formulas down.
Which quantity formats are supported?
Use positive receipt and issue quantities and nonnegative opening stock. Quantities support up to nine whole digits and six decimal places, with a period as the decimal separator. Use one unit per SKU.
How much data can I paste?
Each list supports 5,000 data rows, 100 columns and 1.5 million characters. A workbook can contain up to 1,000 distinct SKUs. Processing takes place in your browser.