Dear,
I want to make auto Tally random amount entries from Excel. (like.. receipts, payments, sales, purchases, contra, journal) with specified different criteria.. Like Data Range, Amount Range.
Kindly help.
HeMaN (B.Com) (33 Points)
07 June 2022Dear,
I want to make auto Tally random amount entries from Excel. (like.. receipts, payments, sales, purchases, contra, journal) with specified different criteria.. Like Data Range, Amount Range.
Kindly help.
Babita Jain
(Personal Assistant)
(276 Points)
Replied 07 June 2022
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 -
sabyasachi mukherjee
(27574 Points)
Replied 07 June 2022