Random Sale Generator

Generate random sales records based on receipts and available stock for testing and analysis

Stock Available Excel

Click to upload stock Excel file

Expected columns: A=Stock name, B=Unit, L=Available qty, M=Buying price, N=Total amount

Click to upload receipt Excel file

Expected columns: A=Date, D=Credit(Rs.) amount

Gross Profit %

Percentage markup on buying price

Quantity Type

Choose if quantities can be decimal

Max Line Amount (₹)

Maximum amount per line item (optional)

Excel Output Format:

• Series: Always "Main"

• Type: Always "L/GST-Itemwise"

• Party: Always "Unregistered Dealer"

• Main Store: Always "Main Store"

• Date: From receipt data

• Item: Product name from stock

• Qty: Generated quantity (respects max line amount if set)

• Unit Price: Selling price (with gross profit)

• Amount: Qty × Unit Price (will not exceed max line amount)

Please upload stock Excel file first