# Physical Count Using Excel

> Source: https://help.getedara.com/en/articles/5240868-physical-count-using-excel · Category: Warehouse › Physical Count · Last updated: 2026-05-04 · العربية: https://help.getedara.com/ar/articles/5240868-%D8%A7%D9%84%D8%AC%D8%B1%D8%AF-%D8%A7%D9%84%D9%85%D8%AE%D8%B2%D9%86%D9%8A-%D8%A8%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85-%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D8%AC-%D8%A7%D9%84%D8%A5%D9%83%D8%B3%D9%8A%D9%84

Physical count is a core process for ensuring the accuracy of Local balances and matching them with the actual balances in warehouses. In some cases, users prefer to rely on Excel during the counting process—whether to organize data, simplify balance entry, or perform the count offline and import it into the system later.

## Physical Count Using Excel

The [physical count](https://help.getedara.com/en/articles/5198882-physical-count) using Excel is completed through the following steps:

### First Step: Exporting the Excel File from “Edara”

1. Go to the “Warehouses” module.
2. Open the “Warehouse stocks” page.

[If the batch number is not used](https://help.getedara.com/en/articles/5198882-physical-count):

1. Select the required columns to be used in the physical count, which are: Item Description and Local on-hand balance.
2. Click on “ **Generate** ”.
3. Hover over the “+” icon.
4. Click on “ **Excel** ”.

![First Step: Exporting the Excel File from “Edara” — Click on “Excel”.](https://help.getedara.com/images/stocktaking/5240868/01.en.gif)

[If the batch number is used](https://help.getedara.com/en/articles/13247753-physical-count-when-using-the-batch-number):

1. Select “Detailed” under the “Batch numbers & expiry dates” section.
2. Select the required columns to be used in the physical count, which are: Item Description, Batch Number, Expiration date, and Local on-hand balance
3. Click on “ **Generate** ”.
4. Hover over the “+” icon.
5. Click on “ **Excel** ”.

![First Step: Exporting the Excel File from “Edara” — Click on “Excel”.](https://help.getedara.com/images/stocktaking/5240868/02.en.gif)

> **Note:** If you want to count a specific classification or brand, apply the required Conditions in the Warehouse stocks Report before clicking on “**Generate**”.

### Second Step: Editing Quantities in the Excel File

1. Rename the “Local Balance” column to “Quantity”.
2. Set all balances in the file to zero.
3. Delete the total value from the last row in the “Quantity” column.

After that, you have two working options:

First Option:

Upload the file after resetting all quantities to zero. Enter the counted quantities directly from the system interface, either by using barcode scanning or manual entry.

> **Note:** Barcode scanning cannot be used for stock items that depend on the batch number.

![Second Step: Editing Quantities in the Excel File — Upload the file after resetting all quantities to zero. Enter the…](https://help.getedara.com/images/stocktaking/5240868/03.en.gif)

Second Option:

Enter the counted quantities directly into the Excel file—either per stock item or per stock item and batch number—then upload the file to the system.

![Second Step: Editing Quantities in the Excel File — Enter the counted quantities directly into the Excel file—either per…](https://help.getedara.com/images/stocktaking/5240868/04.en.gif)

> **Notes:**
>
> - If the number of stock items is not very large, it is recommended to select “All” stock items instead of “Non-zero balance”, to ensure that the physical count includes items with a local balance of zero, but have an actual balance
> - Make sure to delete the contents of the “Total” cell in the “Quantity” column before re-uploading the file, to avoid any upload issues.

### Third Step: Uploading the File into the Physical Count

1. [Create a new Physical Count document or open an existing one.](https://help.getedara.com/en/articles/5198882-physical-count)
2. Click on “ **⇅”** to upload the file and import it into the system.

![Third Step: Uploading the File into the Physical Count — Click on “⇅” to upload the file and import it into the system.](https://help.getedara.com/images/stocktaking/5240868/05.en.gif)