Saturday 31 August 2024

Create Voucher Tally TDL+MS Access Utility




Offer Price Till 30-09-2024

offer Price :- 50/-

Actual Price:- 399/-

Validity:- Permanent


Must Read

 

Before paying, read Note and term & condition carefully. 

Note:- I have an unregistered firm. So, I issue invoice only in the name of consumer not for firms due to GST registration issues.

Term & Condition

1. Check first provide video carefully if you understand well and feel that it will help for you then you can buy. After payment made amount not refundable. So watch carefully video first.

2. No Implementation/changes possible in tdl/Utility after payment is made. 

3. TDL will work only with your Tally serial number.

4. Above mentioned TDL is tcp file (Tally compile file) not txt file.

5. Tally TDL tested on Tally Prime 4.1 that is latest tally release, Tally Erp 9 Released 6.6.1, 6.4, 6.5 & tally prime 2.1 on Windows 7 & 10 and ms access Utilities tested on MS Office 2010/2013. “Permanent” means with tested versions of window/tally/office TDL/Utility will work for life time. So first check carefully trial on your system & tally versions.

7. File will provide with in 48 hr after purchase.

If you are agree above terms you may pay

Payment Details:-

Google Pay UPI

aasansolution@okhdfcbank

After payment mail us confirmation of payment Screen shot and tally serial number on

Contact.aasansolution@gmail.com





Saturday 24 August 2024

9.GST Mismatch Report :- GSTR2A Reconciliation Fastest Utility | Get Mismatch With in Seconds

This article related to following query if you searching

gstr 3b and gstr 1 mismatch
gst mismatch
mismatch in the nature of transaction and place of supply
gstr 9 itc mismatch
gstr 2a mismatch


gstr 3b and gstr 2a mismatch
itc mismatch in gstr 9
mismatch in gst return
itc mismatch
mismatch in gstr 2a
mismatch in gst


Quickly GST Mismatch Report
Question:-  जब हम Press to continue बटन पर क्लिक करते हैं तो यूटिलिटी काम नहीं कर रही है
( when I click on press to continue button utility not working) 
Solution:-  please check given video I answered in this video



Complete Solution GSTR2A Reconciliation
In this article me and my friend created a utility in ms access in which you can insert your portal and books GST2A. This utility will produce GSTR2A reconciliation within seconds. This Utility different to other because of no user actions required to generate data format mean user efforts are negligible. 



You can not also watch mismatch but also print and export to excel your all mismatch type report  and invoice mismatch type report. This is a very beautiful utility because of very user friendly and free of cost.

Requirements to use this utility:-
1. Ms Access must be install on your system
2. Portal GSTR2A and books GSTR2A
3. download this utility from below given link

Advantages:-
1. Free of Cost
2. Effortless reconciliation
3. Easy to print result on A4 Size sheet no need to settle.
4. Separate reports for only invoice mismatch etc.



This is first version of this utility. so may be some limitation. so track problems and send to me on my mail address :- contact.aasansolution@gmail.com for further corrections.

for more information about this utility watch given below video

Version 7-8-3 Release Dated 14-09-2020

1.Reconcile Monthly/ Annually etc.
2.Reconcile B2B as well as CDNR
3.Multi Rate Invoices will show only in single row
4.Match Invoices if invoice number string incorrect
5.All Reports into Excel Export facility
6.computax Problems solved


Password of zip file is : 1124082024

Download Version 7-8-4
check below video to know features of version 7-8


























Friday 23 August 2024

5.Import Sales With Inventory Data from Busy Win to Tally


 Import Sales With Inventory Data from Busy Win to Tally


Download TDL

Password of Zip file 2408202423

To import data from Busy software to Tally, you can follow these general steps:

Export the data from Busy software in the required format Excel as per Tally's import format guidelines.

1. Open Tally software and navigate to the gateway of Tally.

2. Select the option 'Import Busy Data' from the gateway of Tally.

3. Select the appropriate company where you want to import the data and Set the file path that you want to import Excel Sales Data of Busy win.

4.Insert full path with proper file extension and set sheet number of excel file in given field.

5. Tally will then display the details of the data that will be imported. Check the details and confirm the import.

Once the import is complete, Tally will display the status of the import process. Verify the imported data in the Tally company and make any necessary corrections.


In this tdl you can import Busy win Sales Invoice Data into Tally.

Q. Is directly import data into Tally?

Answer. No., It first convert data from busywin to excel then excel to tally data import.



4.GSTR1 Correction Return "HsnRate" Problem Solution

Friends,

I think you will finding errors when you filing GSTR1 of Month May due to lot of changes done by GST Network Portal in GSTR1.

In this article i am providing to a solution for filing GSTR1 from Month May 2021 to further using Json generating from tally then upload on portal.

As you know tally erp9 old versions not make properly json for GSTR1 so i providing a tally tdl after using this tdl you can file your GSTR1 without any error.

You have to follow steps:-

How to Install the TDL File in Tally

Step 1. Go to Gateway of Tally.
Step 2. Then Press Ctrl+Alt+T button
Step 3. Now Press F4 Button or Click on “Manage Local TDL” button
Step 4. Now do “Yes” to “Loan TDL Files on Startup” option
Step 5. Now in the next line “List of TDL Files to preload on Startup” Enter the TDL File Path or Location Like “E:\File.tdl”
Step 6. Now save the settings
Your TDL File is ready to use.

How to Generate GSTR1 Json from tally

Step 1. Go to Gateway of Tally > Display Menu >Statutory  Reports > GST Reports >GSTR1
Step 2. Select Correct Date from and To Date by usning Alt+F2 Key
Step 3. Click on button Ctrl+E "Export GSTR1" Right Hand Side

Step 4. Input Format must be JSON & select properly export location then save the settings by press Ctrl+A

Step 5. It will export on desired location
Your JSON GSTR1 File is ready to upload on portal.


Q. How this tally tdl will work?

You may watch following video






Q. How to download this tally tdl?

You may download this tally tdl below link


Password zip file :- 2408202413

Download Now







Download Now

If you want to buy this tally tdl or others tdl you may mail us. If you want to customize your tally as per your requirement you can also mail us on below.

Contact.aasansolution@gmail.com


Thursday 1 August 2024

6.Item with GST Hsn/Rate in Invoice | Stock Summary | Columner Report | Excel Export


This is Combination of my previous TDLs. So, Before using it turn off all previous Tdl.


Introduction
With this Add-on, you can display Item with GST Hsn code/ Rate in an invoice, Stock Summary and columner Report. It will act as a helper for the customer. It also helps you to make sure that the Item Hsn Code and GST Rate.

This Add-on supports Credit Note, Debit Note, Sales, Purchase, Delivery Note, Purchase Order, Sales Order Receipt Note etc.



Benefits
With the help of this Add-on 
·     you can watch GST hsncode and gst Rate at the time of invoice entry.      
·     you can watch/check/display GST hsncode and gst Rate on invoice after invoice entry.
·     You can get/check/watch/display gst%/hsn code in stock summary with item
·     You can Gst%/hsn code in columnar register also.
·     You can export Gst%/hsn code form columnar register to excel/other format for creating reports.
·     You can check GST Rate/hsn code in stock item list table at the time of invoice entry and voucher entry.
·   You can check or calculate manually Gst% wise sales or Gst hsn code wise sales by exporting sales columnar register in excel also.

Setup Guide
1.    Download tdl file at the end of this post.
2.    Open Tallyà F12: Configuration à

hut down and Restart Tally.ERP 9 and open your company.
3.     Get Add-on help and open user manual.
For Tally.ERP Series A versions lower than Release 5.0
Go to H: Help à Add-on Help to open the user manual.
For Tally.ERP Series A release 5.0 and above
Press Ctrl + Alt + H to get Add-on help..
4.     Activate the Add-on
Go to Gateway of Tally > F11: Features > Add-on Features
Set “Yes” to the option “Enable Party Previous Balance






















Export to Excel GST Rate & GST % in Sales Columner












For more info watch this youtube video

Extra feature for Tally Prime

Tally Prime & Erp 9
Password of zip file :- 0309242141