Import Inventory Ending Balances

Overview

GoldFinch offers a convenient feature to import inventory ending balances from a .csv file. This allows the system to calculate and post adjustments between imported balances and existing inventory records. This functionality is especially beneficial for updating inventory based on manual cycle counts or month-end inventory balances from third-party logistics (3PL) providers.

Prepare the Import Template

Use the provided Import Inventory Ending Balance Template to enter your ending inventory balances. Mandatory fields required for creating a record are highlighted in red.

Import Inventory Ending Balance Template 011625.csv

Ensure all required fields (highlighted in red) are completed:

• Warehouse: Required

• Bin: Required

• Item: Required

• Item Lot: Required (if the item is lot-tracked)

• Unit of Measure: Required

• Quantity: Required (must be a positive number)

• Unit Cost: Optional. You can enter Unit Cost later on the Import Inventory page.

• Lot Manufacturer Date: Required (if the item is lot-tracked)

• Lot Expiration Date: Required (if the item is lot-tracked)

• Serial No.: Required (if the item is serial-tracked)

• Reason: Optional

Create a separate template for each warehouse.

Save the file in .csv format.

Import Inventory Ending Balances

• Open the App Launcher and search for Import Inventory.

• Click the Import Inventory CSV button.

• Select the .csv file to upload and click Upload File.

• The system will import the data into the Import Inventory object.

Calculate Adjustments

• Open the Not Processed list view to access imported data.

• DO NOT select any records; click the Calculate Adjustments button.

• Specify the warehouse to compare and calculate adjustments.

  • Review the displayed summary:

    • Counted Lines: Number of cycle count lines imported.

    • Counted Quantity: Total cycle count quantities imported.

    • Calculated Lines: Number of system records for the selected warehouse (grouped by Warehouse, Bin, Item, Unit of Measure, Lot No., and Serial No.).

    • Calculated Quantity: Total quantities in the system for the selected warehouse.

• Confirm the following before proceeding:

  • Counted Lines and Calculated Lines should generally align, reflecting consistent inventory records. Significant discrepancies may indicate your inventory is out of sync.

  • Counted Quantity and Calculated Quantity should generally align, reflecting consistent inventory records. Significant discrepancies may indicate your inventory is out of sync.

• Click Calculate Adjustments to generate adjustment lines based on the comparison.

Error Resolutions

• If errors are detected, they will be displayed in the Error Text field.

• Edit the Import Inventory lines to correct errors.

• Once all errors are resolved, click Calculate Adjustments again.

  • Insert adjustment lines with the Calculated Adjustment field checked.

  • Update the original imported lines with the Processed field checked.

Review Adjustment Lines

• In the Not Processed view, ensure all Import Inventory Lines have the Calculated Adjustment field checked.

• Verify Unit Cost:

  • For items with pre-existing inventory:

    • The system uses the Average Inventory Cost if inventory is available.

    • It uses the Last Invoice Cost if no inventory is available.

  • For items without pre-existing inventory:

    • The Unit Cost defaults to 0.

  • Update the Unit Cost as needed.

Create and Post Item Journals

Click the Create Item Journals button to generate item journals.

• Review the created journals:

  • Verify the number of lines and the total line cost.

  • Update the posting date to the month-end date.

• Post the item journals.

• Proceed with the inventory template for the next warehouse.

Mass Delete Records

• Select the records to delete.

• Click the Mass Delete button to remove them.

Article Import-Inventory-Ending-Balances  ·  Last updated October 08, 2025 · GoldFinch ERP Help Center