Scribd Logo
Upload

Welcome to Scribd!

  • 12 views

    Stock in Out Balance Excel Template

    Uploaded by

    Ade Ramdani

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Stock in Out Balance Excel Template

    Uploaded by

    Ade Ramdani
    12 views6 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    12 views6 pages

    Stock in Out Balance Excel Template

    Uploaded by

    Ade Ramdani

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 6

    Stock In Out Balance Tracker (Inventory Management)

    Stock IN Stock Out (Sales)


    Date of
    Item Name In Qty Date of Sales Item Name
    Purchase
    6/1/2023 Item AB 24 6/1/2023 Item AB
    7/3/2023 Item IJ 48 6/2/2023 Item CD
    6/5/2023 Item AB
    6/30/2023 Item CD
    6/30/2023 Item IJ
    7/7/2023 Item IJ
    6/19/2023 Item AB
    gement)
    ales) Stock Balance
    Safety
    GIT
    Sales Qty Item Name Opening Stock Balance Qty Stock

    12 Item AB 72 50 15 72
    12 Item CD 36 9 12 0
    40 Item EF 77 77 12 0
    15 Item GH 89 89 25 0
    26 Item IJ 32 30 7 0
    24 Item KL 172 172 30 0
    66 Item MN 230 230 50 0
    0 0 0
    0 0 0
    0 0 0
    0 0 0
    Stock
    Suggestion

    Re Order
    Item Data
    Item Code Item Name Case Load Unit Price
    P0001 Item AB 12 120
    P0002 Item CD 36 78
    P0003 Item EF 72 55
    P0004 Item GH 120 38
    P0005 Item IJ 48 65
    P0006 Item KL 36 45
    P0007 Item MN 48 64
    Goods in Transit Tracker
    Rec/Trn Status Rec Trn Rec Trn
    Order Date 5/30/2023 6/5/2023 6/30/2023 6/14/2023

    Item Code Item Name Qty Qty Qty Qty Qty

    P0001 Item AB 24 36 36
    P0002 Item CD
    P0003 Item EF
    P0004 Item GH
    P0005 Item IJ 48
    P0006 Item KL
    P0007 Item MN
    0 0
    0 0
    0 0
    0 0
    0 0
    Total transit Bal Stock Safety Stock
    Qty Qty Qty
    Goods for Ref for REF
    72 50 15
    0 9 12
    0 77 12
    0 89 25
    0 30 7
    0 172 30
    0 230 50
    0 0 0
    0 0 0
    0 0 0
    0 0 0
    0 0 0

    You might also like