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)
(235 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
(26089 Points)
Replied 07 June 2022
"Live class on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance"
GST Live Certification Course (39th Batch) - April 2024 (Weekend Batch) (With Certificate)