Sometimes you need to add more information in your stock items in tally GST invoice. Because buyers need to learn more information for stock items.
Eg: If you sell HP LAPTOP, you may add more information related to that stock item (ie. RAM, Harddisk, Warranty, etc.,) This information very useful for the buyer
Tally allows you to add more details in Stock items in GST invoice.
> Open sale invoice
> From the Bottom Right side panel, click on Configure button
> Provide additional descriptions for stock items name: Change to YES
Press CTRL+A to save the change.
> Select Party Name
> Select stock items
> Now new window will appear [Description for items]
> In this window enter details (Eg: RAM: 8GM, Hard disk: 1TB, Warranty: 1 Year, etc.,)
how to add a description to the stock item in tally
> Enter remaining details as per your requirement.
how to add a description in tally invoice
Hope this information was useful for you. Just comment/say thanks if you are satisfied.
This tip is very useful and speeds up your work when raise gst invoice. Just enter stock item total unit price (Inclusive of GST), then tally automatically calculate the Taxable Value.
For Eg: HP LAPTOP Total Sale Value Rs.30,000/Unit. Just Enter Rs.30,000 (Incl. of Tax) column. Tally automatically calculate Taxable Value i.e: Rs.25,423.73
> Open sale invoice
> From the Bottom Right side panel, click on Configure button
> Allow entry of rate inclusive of tax for stock items: Change to YES
how to set inclusive of gst in tally invoice configure
Press CTRL+A to save change.
Now you can view addtional column in sale voucer [Rate (Incl. of Tax)]
In the [Rate (Incl. of Tax)] coloumn enter total unit Value (Inclusive of GST) Eg: Rs.30,000
how to set inclusive of gst in tally invoice
Now tally calculate Taxable value unit price i.e: Rs.25,423.73
> Open any sale invoice. > From Top Left Side panel Click on P:Print > From the Bottom Right side panel, click on C: Copies Number of copies: Enter the required Number. Type of copy: Select All
How to print original and duplicate invoice copies in tally
NUMBER OF COPIES
TYPE OF COPY
PRINT RESULT
2
ALL
ORIGINAL & DUPLICATE
3
ALL
ORIGINAL, DUPLICATE &
TRIPLICATE
4
ALL
ORIGINAL, DUPLICATE,
TRIPLICATE & EXTRA COPY
5
ALL
ORIGINAL, DUPLICATE,
TRIPLICATE, EXTRA COPY & EXTRA COPY
1
ALL
BLANK COPY
You can also print Individual copies as you required.
Number of copies: Enter 1/2/3 as required. Type of copy: Select as required (Eg: Original, Duplicate, Triplicate, Extra copy)
NUMBER OF COPIES
TYPE OF COPY
PRINT RESULT
1
ORIGINAL
ONE ORIGINAL INVOICE COPY
2
ORIGINAL
TWO ORIGINAL INVOICE
COPIES
3
ORIGINAL
THREE ORIGINAL INVOICE
COPIES
1
DUPLICATE
ONE DUPLICATE INVOICE
COPY
2
DUPLICATE
TWO DUPLICATE INVOICE
COPIES
3
DUPLICATE
THREE DUPLICATE INVOICE
COPIES
1
TRIPLICATE
ONE TRIPLICATE INVOICE
COPY
2
TRIPLICATE
TWO TRIPLICATE INVOICE
COPIES
3
TRIPLICATE
THREE TRIPLICATE INVOICE COPIES
4
TRIPLICATE
FOUR TRIPLICATE INVOICE COPIES
1
QUADRUPLICATE/EXTRA
ONE EXTRA INVOICE COPY
2
QUADRUPLICATE/EXTRA
TWO EXTRA INVOICE COPIES
3
QUADRUPLICATE/EXTRA
THREE EXTRA INVOICE
COPIES
Press Enter then click on print.
Now tally print as per selected option.
how to print original invoice in tally
Questions & Answers
1) Can I print Original & Duplicate Sales Invoices? Ans) Yes
Number of copies: 2. Type of copy: Select All
------------------------------
2) Can I print Original, Duplicate & Triplicate Sales Invoices? Ans) Yes
Number of copies : 3. Type of copy: Select All
------------------------------
3) Can I print Two Original Sales Invoice copies? Ans) Yes
Number of copies: 2. Type of copy: Original
------------------------------
4) Can I print Two Duplicate Sales Invoice copies? Ans) Yes
Number of copies: 2. Type of copy: Duplicate
------------------------------
5) Can I print One Extra Sales Invoice copy? Ans) Yes
Number of copies: 1. Type of copy: Quadruplicate/Extra
------------------------------
6) Can I print One Triplicate Sales Invoice copy? Ans) Yes
Number of copies: 1. Type of copy: Triplicate
------------------------------
7) Can I print Original, Duplicate, Triplicate & Extra Sales Invoices? Ans) Yes
Number of copies: 4. Type of copy: Select All
------------------------------
8) Can I print Two Blank Sales Invoice copies? Ans) Yes
A lot of Tally users asked us, how to send statements (Ledgers, Trial Balance, Stock Statements, Debtors list, Creditors list, with Gridlines/Borders)
In this tutorial, we will explain, how to add Lines/Borders in the Ledger statement (All Statements) in Tally. By default tally not shows Lines/Borders in the leger statement. But our simple tip is helpful for insert Lines/Borders in the ledger statement. Just Export ledger statement in excel format and apply Lines/Borders.
ledger statement with lines in tally erp 9
The above image clearly shows statement with Lines/Borders is perfectly good and better understand by readers.
From Gateway of Tally select:
> Display
> Account Books
> Ledger
> Enter required Ledger Name
> From Right Side Panel Click on F2: Period (Short Cutkey: Alt+F2)
> Enter Required Month Date: Eg: From: 01.04.2020 To 31.10.2020
Click on E: Export button on TOP Panel.
Click on backspace and set as follows:
Language: Default (All Languages)
Format: Excel (Spreadsheet)
Export Location: Enter Export Location
Out file Name: Enter Excel File name (Eg: Prakash Dis.xlsx)
Note: (.xlsx) must be added at the end [as per your excel version]
Output sheet name: Enter name as per your requirement
Update existing file: No
Excel (Spreadsheet) formatting: Yes
with colour: set as per your requirement
Open Exported File: Yes
and set other options as per your requirements.
ledger statement excel export configuration in tally
Press Ctrl+A to save
Now Tally shows the Selected ledger statement in excel format.
Select required cells to apply borders/lines, then select Borders option from Home Tab as required
tally ledger statement formating
After modifying the excel sheet save the file and mail/print/ convert to PDF format etc as required.
After filing the GSTR-3B returns, you must save the Total Month Purchase details in excel file. Because After filing GSTR-3B returns, by mistake if you will make any the following changes in tally, the TAXABLE VALUE & INPUT VALUE also change in Monthly GSTR-3B Reports.
If purchase entry passed in the previous date.
If purchase entry date/month changed.
If any stock items/stock group GST Percentage changed.
If Supplier GST Registration Type changed
If Supplier State Name changed
If any Debit Note issued in a previous date etc.,
Follow the following steps to export GSTR-3B ITC details.
From Gateway of Tally select Display From Display: Select StatutOry Reports From Statutory Reports: Select GST From GST Reports: Select GSTR-3B From Right Side Panel Click on F2: Period (Short Cutkey: Alt+F2) Enter Required Month Start and End Date: Eg:From 1.10.2020 To 31.10.2020
Two Types of Views GSTR-3B is available in Tally
GSTR-3B Summary View in tally
GSTR-3B Return Format View in tally
Select Return Format View from Left side panel
Clcik on F1: Detailed from Left side panel
Clcik on 4 Eligible ITC, then click on (5) All other ITC and also others (Eg: 1 to 4 if you have any ITC)
gstr-3b ITC details in tally
Now tally shows Selected Month details i.e Invoice date, supplier name and GST No, Taxable Value, IGST, CGST, SGST, CESS, Total Tax.
gstr-3b ITC details in tally
click on E: Export button on TOP Panel.
click on backspace and set as follows:
gstr-3b exported excel file configuration in tally
