Search This Blog

September 11, 2017

Booking GST on Advance receipts

Before starting Please make sure that your debtors have Country as India and State name specified in them.
Also GST details should be selected at Yes and Consumer.

Focus on Debtors with Credit balance and not having debit for Bills raised.
1)      Go to the concerned receipt and press Alt+V to mark the receipt as Advance receipt.
2)      On clicking the party name > Details of advance receipt window would open.
3)      In advance receipt window, Press ALT+L and select Type of service/income to be included in aforesaid entry.
4)      Enter the advance value as 118.
5)      After entering aforesaid make sure the reference type has been selected as Advance.
6)      Do not book Service charge or GST via ledger in the entry and save the entry.

7)      Complete the aforesaid steps for the debtors with credit balance at the MONTH END for which GST return is being targeted.

8)      Now check GSTR 1 return and the amounts entered via above would be reflecting under Advance receipts > Amount unadjusted against supplies.
9)      Go into the details of Amount unadjusted against supplies and you will see all the debtors entered in Step 7.
10)   Our aim is Taxable value of Unadjusted Advance column should be made equal to Taxable value of Liability Booked.
11)   Press Ctl+L to see if any consolidated Journal has already been passed.
a)       If yes then alter the advance tax detail for the mismatched amount and while entering TAXABLE VALUE (not tax) pay attention.
b)      If no then create a journal entry of
Ad Tax for Gst    Dr
    To  CGST 9%
    To SGST 9%
     To IGST 18%
12)   There would be some balance liability to be booked but we have to ignore that as long as Taxable value of Balance liability to be booked is zero.
13)   Check S No 7 of GST summary there should be figures in 11A(1) and 11A(2).

September 5, 2017

Shortcut for Tally

Important Shortcut keys of Tally:
CTRL + Alt + R
Rewrite data for a Company
ALT + 2
To Duplicate a voucher
To Add a voucher
To Alter the column in columnar report
To create a master at a voucher screen (if it has not been already assigned a different function, as in reports like Balance Sheet, where it adds a new column to the report).
To access Auto Value Calculator in the amount field during voucher entry
To delete a voucher
To delete a master
To delete a column in any columnar report
(if it has not been already assigned a different function, as explained above)
To export the report in ASCII, Excel, HTML OR XML format
To repeat the narration in different voucher type
To bring back a line you removed using ALT + R
To retrieve the last line which is deleted using Alt + R
To cancel a voucher in Day Book/List of Vouchers
To accept a form – wherever you use this key combination, that screen or report gets accepted as it is
To check the Company Statutory details
Ctrl + Alt + I
To import statutory masters
To abandon a form – wherever you use this key combination, it quits that screen without making any changes to it.
To repeat narration in the same voucher type
Alt + Enter
To view the Voucher display
To access Support Centre. Wherein you can directly post your queries on the functional and technical aspects of Tally.ERP9, Shoper and Tally.Developer.

Alt + Z
To zoom in to the print preview to 100% screen
To zoom in to the print preview
To zoom out of the print preview
CTRL + Scroll wheel (Mouse Wheel)
To zoom in to the print preview

Important Shortcuts While Passing Entry
Make Ledger
Alt C
Change Ledger
Ctrl Enter
Enter Enter
Ctrl A
To Hide Ledger 
Alt R
To Unhide Ledger
Alt U