# Fishbowl Inventory Import Worksheet (Excel and CSV) > Source: https://netray.co/tools/fishbowl-inventory-import-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable opening-inventory worksheet with part, location, quantity and cost columns and a valuation total to reconcile before importing into Fishbowl. ## Category other-erp ## Erp Fishbowl ## Industry Small Manufacturing ## Audience - Inventory manager - ERP admin - Controller ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Part number **Key:** part **Type:** text #### Description **Key:** desc **Type:** text #### UoM **Key:** uom **Type:** select **Options:** - ea - ft - lb - kg - box - m #### Location **Key:** location **Type:** text #### Tracking **Key:** tracking **Type:** select **Options:** - None - Lot - Serial - Expiration #### Counted qty **Key:** qty **Type:** number #### Unit cost **Key:** cost **Type:** number **Format:** currency #### Extended value **Key:** value **Type:** number **Expr:** qty * cost **Format:** currency **Rows:** **Part:** RM-AL-6061-1IN **Desc:** Aluminum bar 6061 1 inch **Uom:** ft **Location:** RACK-A1 **Tracking:** Lot **Qty:** 420 **Cost:** 3.85 **Part:** HW-BOLT-M8-25 **Desc:** Bolt M8 x 25 zinc **Uom:** ea **Location:** BIN-C14 **Tracking:** None **Qty:** 5200 **Cost:** 0.11 **Part:** FG-HANDLE-200 **Desc:** Handle assembly 200 mm **Uom:** ea **Location:** FG-ROW2 **Tracking:** Serial **Qty:** 64 **Cost:** 12.4 **Part:** PK-BOX-M **Desc:** Carton medium **Uom:** ea **Location:** PACK-1 **Tracking:** None **Qty:** 800 **Cost:** 0.62 **Part:** CH-ADH-500 **Desc:** Adhesive 500 ml **Uom:** ea **Location:** CHEM-1 **Tracking:** Expiration **Qty:** 36 **Cost:** 9.75 **Totals:** #### Total inventory value **Key:** value **Agg:** sum **Format:** currency #### Total units counted **Key:** qty **Agg:** sum **Format:** number **Summary:** #### Average value per line **Key:** avg_value **Expr:** sum_value / count **Format:** currency #### Largest line value **Key:** top_line **Expr:** max_value **Format:** currency **Notes:** Column names are for planning. Fishbowl's import accepts specific headers per import type, so confirm them against the import help in your version before exporting. Lot, serial and expiration parts need their tracking values supplied during the inventory load. ## Content **Intro:** Loading opening stock is the step that decides whether your first month in Fishbowl is calm or full of corrections. The goal is an exact physical count, valued consistently, imported once. This worksheet helps you assemble and reconcile that file. **Sections:** #### How to use the worksheet **Body:** Count stock after a production and shipping freeze, then enter one row per part and location. Enter unit cost on the same basis your accountant will use for the opening balance. The Extended value column multiplies counted quantity by cost, and the total should match the inventory value you plan to post in the general ledger. Export to CSV when the numbers reconcile, then map columns to the import you are using. **Bullets:** - Create parts and locations in Fishbowl before importing quantities. - Keep part numbers identical to the part master. - Count in the part's base unit of measure. #### How inventory loads work **Body:** Fishbowl tracks quantity by part, location and, where configured, by lot, serial or expiration. An opening load increases on-hand quantity and sets cost, so every line becomes an adjustment against an offset account. This means two things: the file must be complete, because missing lines mean missing stock, and it must be loaded once, because a second load doubles the quantities. Parts with tracking need those details in the file, so decide tracking before you count. #### Worked example and reconciliation **Body:** In the sample, aluminum bar is 420 ft at 3.85, bolts are 5,200 at 0.11, and handle assemblies are 64 at 12.40. The sheet totals to a few thousand dollars. Reconcile it against your accounting balance for raw materials, work in process and finished goods. A gap points to uncounted stock, pricing differences or items that sit on another entity's books. Resolve differences in the spreadsheet, not after posting. #### Common mistakes **Body:** Mixed units of measure are the top cause of wrong stock, for example counting boxes but costing per each. Another is importing stock for parts that are not yet set as inventory type, or placing everything in one default location, which defeats picking later. Do not carry negative or zero-cost lines without a decision. Run the import in a test company or copy first and compare on-hand reports to the sheet. **Bullets:** - Round costs consistently to the same decimals. - Exclude obsolete parts you intend to scrap. - Keep the signed count sheet for audit. **Cta:** If your stock data comes from several spreadsheets or a legacy ERP, Netray can help consolidate it and check the load before go-live. **Faq:** #### How do I import inventory into Fishbowl? **Answer:** Create the parts and locations, then use Fishbowl's import function for inventory or run adjustments with a prepared file. Use the exact header names from the import help in your version. Test with a small file in a copy first. #### Should I import costs with quantities? **Answer:** Yes, set a starting cost for each part so valuation is right from day one. Use a basis your accountant agrees, such as last purchase cost or standard cost, and apply it consistently across all parts. #### What about lot and serial tracked parts? **Answer:** You must supply the lot, serial or expiration details when stock is loaded, so count those parts with their identifiers. Decide the tracking flag on each part before the load, because changing it later is harder. #### Can I load inventory more than once? **Answer:** Technically yes, but every load adds to on-hand quantity. Treat the first load as final, or reverse it with a documented adjustment first. Duplicate loads are a frequent cause of inflated stock at go-live. ## Search terms fishbowl inventory import, fishbowl import inventory excel, fishbowl opening inventory template, fishbowl csv import parts, fishbowl initial inventory load, fishbowl import locations quantities, fishbowl inventory valuation, fishbowl go live inventory --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json