How to Import your Opening Balance

How to Import your Opening Balance

How to Import your Opening Balance

To begin your warehouses opening balance you MUST have the following;

1. You must have the Warehousing and Purchasing Modules activated 

2. Departmental Posting: To properly use SpendaStock you will need to be posting inventory departmentally. Direct inventory posting is not supported with warehousing.

3. Cost Price: All tracked items will need a cost price ex GST.

4. Non-tracked items: Some items you can not track within Synkd/Spenda. Such items include freight, fees, labour, drum deposits, etc.

5. Non-tracked class: Any non-tracked or GST free items will need to be assigned to a separate inventory class than the tracked items.

Cirralto Support will provide an "Opening Balance Count Sheet" that contains all your tracked inventory. When you perform your stocktake you will easily be able to use the barcode scanner to update the count sheet.

---See "How to Perform a Stocktake in Synkd" for more information.---

Once the stocktake is complete you can begin to upload the CSV provided by Spenda Support into Synkd.

1. Open and log into Synkd

2. Use the side menu and navigate to "Inventory Management" and select Warehouses.

3. Now choose your desired warehouse to import the opening balance into.

4. Next, select the opening balance button.

5. You will now be navigated to the Stocktake menu. You will see three main objects within this menu

      a. Import .CSV and cancel stocktake buttons

      b. Stocktake details including warehouse name, stocktake type, stocktake name, date created and current status.

      c. Inventory approval area

6. Begin by selecting Import .CSV and upload your opening balance CSV

IMPORTANT NOTE: Do not open and save the CSV. If barcodes are saved within the CSV they will be converted to scientific format and destroy the barcode. If changes need to be made to the opening balance sheet, please contact Cirralto Support.

7. Once uploaded inventory will land in two out of the three data areas. Either Requires attention or ready for approval.

      a. Requires attention means Synkd could not approve the items. This could be due to new items or duplicate items.

      b. Ready for approval is the area where Synkd was able to approve the products by default. They now require a human to approve the products and counts as well.

8. Once the counts have been approved by Synkd and yourself, they will populate the approved tab. This will give you one last chance to check your stocktake. If you approve of the results select Approve. If you wish to cancel and recount select Cancel Stocktake.

9. Once approved you will be given a snapshot of your total inventory and inventory cost. You can use the snapshot button to take a .jpg of the results.

10. Once you select approve your stocktake is now finalised and can not be undone. SOH counts will now be affected by Spenda sales, service jobs and receiving inventory in Spenda.

    • Related Articles

    • How to Perform a Stocktake in Synkd

      How to Perform a Stocktake in Synkd You will be provided with a Warehouse Sheet Validation Import Tool by Cirralto Support.  It will be prefilled with all your tracked inventory from Synkd.  This sheet will allow you to add missing barcodes, UOM, SOH ...
    • How to set up your products for Automatic SOH suggestions

      The following prerequisites are required to be able to use the Automatic Purchasing Suggestions feature. Products must exist within your warehouse. Products must have an opening balance in your warehouse. Products must have a MIN/MAX value set on ...
    • How to Transfer Stock between Warehouses

      How to Transfer Stock between Warehouses PLEASE NOTE: Each warehouse MUST COMPLETE an opening balance before stock transfers can take place To transfer stock between warehouse or restock a van, follow the below steps.       1. Open Spenda and from ...
    • How to Add Features to my Account (POS, Warehousing, Purchasing etc)

      How to Add Features to my Account (POS, Warehousing, Purchasing etc) To add features to your account, such as POS, Warehousing, Purchasing etc. Please email or call 1300 682 108 (Option 1).
    • Create a Departmental Posting Item

      Create a Departmental Posting Item Departmental Posting can be used for the following purpose; Multiple items within Synkd can be allocated into a Product Class in your financial system. This will aggregate revenue increases as a group total. Keep in ...