Attitude

12-02-2019  Sales Invoice details and entries in Tally.  The procedure for sales invoice – PO should be attached which is received through mail  Advance payment of sales order – Proforma Invoice (order voucher)  Bank Reconciliation Statement (Account) – Balance sheet – Current Asset ( it should be tally and balance as per the bank and as per book for others TDS is available (No limit – its fully taxable)  INR – Online advertisement – Equalisation levy- 6%

13-02-2019 – Tally  

     

 

    

Entry of Cheque deposit in tally Its recorded in voucher, bank receipt. To pass the entry BOE and Invoice number with Invoice date. – Alt I ( F5)  To copy the same entry in tally - Alt 2 Alt E (export) Payment Order - RTGS is for more than 2,00,000/- NEFT is for less than 2,00,000/While paying Invoice amount slip should be seen before paying ( Custom duty + Bill of entry ) P & L a/c – Direct Expenses – Commission Charges Loan Agreement Purchase entry/inward -Germany currency – Entry in excel sheet to convert into INR cost . Exchange Rate / EURO currency / ER * EC / Quantity unit / QU*(3) Or Basic Value Shortcuts – Ctrl +shift + } -Ctrl } Excel Sheet - ctrl +shift + } Bill of Entry – Expenses Documentation While purchasing - payment will be made – check the goods and its Invoice 14-02-2019 Service Bill Expenses TDS – 194 H } Commission 5% - Service charges Sales bill – Payment procedure to Bank – when it is imported it is given to bank { Bill of Entry + Transport document } To entry invoice in tally Display – A/c Book – ledger{F4} – company name - Alt I – F8 { Sales} – journal Debit Note F7 After making payment –print copy of that should be maintained with other invoice. TDS should be deducted as per its section while making payment to supplier .

Important –   

The amount which is payable under GST it should be maintained in excel before entering into tally to cross verify it. For every sales invoice there will be only one invoice number is provided. For 2 bills one invoice number is given but not more than one is provided.

  

While importing Germany Currency / goods it ill be converted into INR { Purchase bill } Debit Note { F9} Before availing invoice it should be checked properly.

15-02-2019    

Stock summary – Inventory reports – godown – warehouse (VLOOKUP,) Lock - F4 TDS for employee – its paid once in a year - TDS will be filed ( FORM 16 )

For other challans or items -Its paid in next month on or before of 7th of next month – yearly 4 times - (FORM 16A ) return file.

19-02-2019   



  

Checking entries in Ledger as a cash voucher in journal. Sundry Debtors Entry ( 2 Reports - Bill due date & Period over due ) Display – Statement of Accounts – Outstanding – Group ( Sundry Debtors, Sundry Creditors, etc.) after this bill party wise –( F7) then period (01-02-2019) then export to tally with path name then export into excel. Opening balance should be deleted before calculating , the value which has date(ex: 01-022019) and number should be write of , the value / invoice number which has Credit Note should be taken off . Alt F7 – for Summary / Bill wise party. Bank Receipt – F6 Balance sheet amount should be written off - it should be credited.

20-02-2012  Stock – Warehouse.  Entries for stock - Stock Summary – Item wise( F5) – Article Number (F12) – VLOOKUP – Export to Excel – Alt E – Alt D ( path save ) – Ctrl + C – ( Ctrl +Alt +V ) – Ctrl +S.  VLOOKUP = Copy order number – Next sheet – amount value – ( F4,3,0)  In warehouse goods should be debited (+) – under journal (3)  Books of entry – Free of cost -Demo warranty with customer – 5 - Goods sent but invoice due – 6  Reconciliation.  To verify the entry – Gate way of tally – summary – Inventory Report – Godown summary( Stock invoice tally ) – New godown – Details – F12 – Part no (applied) – Yes.

27-02-2018  Purchase Register Display –Accounts book – Ledger – Purchase Register – Month – Alt F2 – Company.name. 

Perquisites –



Opening Balance – Loan given – repayment – Closing balance – Max^ amount outstanding – Rate of Interest – Notional Interest. 28-02-2019. Order sheet Formula –

     

For date – Ctrl G – Special – Blank – ok - = - up-arrow – enter Voucher no – Ctrl G – special – blank – ok - = - up-arrow – enter. Payroll - TDS rates and computation details. Salary entry – payslip – entry in tally. Sales spilt detailed – to Germany. For 2nd = Alt-semi column – ctrl +d Cash voucher Inward

March 2019 From 06/02 – 13/02/2019  

ESIC workings of 240 employees. EPFO of 240 employees.

14/02/2019