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.
Menu
How to make random amount Tally accounting Entries from Excel?
Replies (2)
Quick Summary
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.
A person who is adept with the above can easily perform them.
Recent Topics :
- NIC codes for FIRMS registration of entity
- Register on Income Tax as CA
- Deduction In Employee Provident Fund
- This is a gift for all Chartered Accountants and P
- NRI, ITR-2 FY 2025-26: AIS Part B2 (SFT) shows hig
- Wallet query for GST.
- 25-26 exempted sales
- Hotel stay below Rs.1000/- GST applicable or exemp
- NRI, ITR-2 FY 2025-26: AIS Part B2 (SFT) shows hig
- Generate E-Way Bill for 4 Nos. Suppliers Involveme
Related Topics :
CAclubindia
