How to make random amount Tally accounting Entries from Excel?

There is no any specific function and formula in Excel to do this work. But you can use RANDBETWEEN(1,100) this formula for limited use. 

I found also one tool generator where you can easily generate fake accounting entries for expenses and receipts with specified date range and amount range.

Download tool - https://www.xltool.in  |  https://www.rdtool.in

Follow these steps to generate random amount Tally accounting entries -

• Open Tally Company
• Open XLTOOL Excel tool
• Enable Excel Macros
• Press F1 Key
• Click RANDOM ENTRY button
• Select the criteria and range as per your requirements
• Click to Generate Button.