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:
Windows
Functionality
CTRL + Alt + R
Rewrite data for a Company
ALT + 2
To Duplicate a voucher
ALT + A
To Add a voucher
To Alter the column in columnar report
ALT + C
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
ALT + D
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)
ALT + E
To export the report in ASCII, Excel, HTML OR XML format
ALT + R
To repeat the narration in different voucher type
ALT + S
To bring back a line you removed using ALT + R
ALT + U
To retrieve the last line which is deleted using Alt + R
ALT + X
To cancel a voucher in Day Book/List of Vouchers
CTRL + A
To accept a form – wherever you use this key combination, that screen or report gets accepted as it is
CTRL + ALT + B
To check the Company Statutory details
Ctrl + Alt + I
To import statutory masters
CTRL + Q
To abandon a form – wherever you use this key combination, it quits that screen without making any changes to it.
CTRL + R
To repeat narration in the same voucher type
Alt + Enter
To view the Voucher display
CTRL + H
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

September 4, 2017

SBI Balance on Mobile


How to register for SBI Quick:

One can send an SMS to number 09223488888 in the format 'REGAccount Number'.

For example:

REG 12345678901

Use your registered mobile number for that particular account. A confirmation message will be received indicating successful/unsuccessful registration.

If successful, you can start using the services. If unsuccessful, you should check the SMS format and the destination mobile number.

You must ensure that your mobile number from which the SMS is sent is updated with SBI for that account number, according to the SBI website.

Do you need an internet connection for SBI Quick?

If one has an Android, Windows, iOS or Blackberry phone, he or she can download the SBI Quick app from the respective App store. Those having this app on their phone need not remember the various keywords and destination mobile numbers. A special feature of this app is that one can use it even without an internet connection, as the communication would happen over SMS or missed calls. Besides, the mobile app is not mandatory for using this facility, states the website.

How to block ATM Card

You can block your ATM Card linked to the registered account in case of loss/theft.

To block the card, send an SMS from your registered mobile number to 567676 in the following format:

'BLOCKXXXX'

(XXXX represents the last 4 digits of the card number)

On acceptance of the request for blocking, you will get a confirmatory SMS alert containing the ticket number, date and time of blocking. Note that the ATM Card can also be blocked through the following means:

By visiting the nearest SBI Branch

By logging on to the SBI website (only for personal segment customers)

Other services

Balance Enquiry

To get the last 'clear' balance on your account, you may give a missed call or send an SMS with text 'BAL' to the number 09223766666

Mini Statement

To get a mini statement, which contains the last five transactions from the account, you may give a missed call or send an SMS 'MSTMT' to 09223866666

E-Statement - last 6 months

You can avail an e-statement for the last six months of your savings bank account. The statement will be sent on your registered email ID with password encrypted PDF file, the portal noted.

For this, you can SMS 'ESTMT' to 09223588888

Education Loan Interest Certificate

To avail interest certificate of your education loan for a financial year, SMS 'ELI' to 09223588888

Home Loan Interest Certificate

To avail interest certificate of your home loan for a financial year, SMS 'HLI' 09223588888

Charges

For a 6-digit number, i.e. 567676, premium charges will apply. For 10-digit numbers, SMS charges will be as per the customer's mobile bill plan. For missed call, there is no charge. If the customer listens to IVR of 3 seconds which will be played after 4-5 rings, he or she will be charged as per the mobile bill plan for three seconds, SBI noted.

How to de-register

SMS DREG to 09223488888. You will receive a confirmation message indicating successful/unsuccessful de-registration. If successful, you will not be able to use the services until you register again. If unsuccessful, check the format and destination mobile number and try again, SBI added.

SBI Quick also helps the user to generate an ATM pin, get details on home and car loans, and on the Prime Minister's social security schemes.