Combo 2 – Accounting with Tally Prime + Automation of BS and P&L
About Bundle
What is this Course?
By CA Pooja Gupta and CA Pankaj Goel.
This course is divided in following parts :
1 Accounting Basic and Introduction
2 Journal Entry Overview and 3 methods of Entry
3 Ist Method – Modern Approach with examples
4 IInd Method – Give and Take Approach with examples
5 IIIrd Method – Traditional Approach (Golden Rule of Accounting) with examples
6 Financial Statement Overview
7 Cash Book, Ledgers, Bank Book, Bank Reconciliation, Depreciation, Provisions, Prepaid Expenses
8 Profit & Loss Statement, Balance Sheet
9 Basic introduction of Tally Prime (with Basic Questions)
10 Sale Entry in Tally Prime with Examples
11 Purchase Entry in Tally Prime with Examples
12 Stock Entry in Tally Prime with Examples
13 Basic Concept of GST
14 Points to be remembered before recording GST transactions
15 Sale, Purchase Entry in Tally with GST for Trading Business (Retail, Wholesale)
16 Accounting Entries of Purchase from Unregistered Business / Composition Business
17 Accounting Entries of Credit / Debit Note (Sale/Purchase)
18 RCM Transactions in GST
19 Accounting of Manufacturing Unit
20 Accounting of Composition Dealer
21 Accounting of Import & Export
22 Accounting of Job Work
23 Accounting of Multiple GSTIN of Single Customer/ Vendor
24 Detailed discussion on Grouping
25 Records of Stock (Raw Material, Work in Progress and Finished Goods)
26 TDS & TCS Detailed Concept knowledge (All Section coverage with Late fee, Interest, Due date of Payment etc. )
27 TDS Accounting in the books of Deductor
28 TDS Accounting in the books of Deductee
29 TDS in Tally (for Deductor and Deductee separately)
30 TCS in Tally
31 Payroll concept knowledge with Salary calculation sheet, TDS Calculation and Salary slip
32 Payroll in Tally
33 Concept knowledge of Cash transaction Limit
34 Accounting of Loan and interest on loan
35 Accounting of FD with TDS
36 Closing and Finalisation of Financial Statements
37 Accounting of year end Adjustments (Provisions/Prepaid etc)
38 Depreciation Working
39 Personal Balance Sheet Working (only on the basis of Bank statement etc.)
40 Other Misc. Important concept coverage
Excel is most powerful tool and if you use it in Accounting it work like wonders and help you to save lots of your time. This course provides you learning of Automation of balance sheet and Profit & loss on the basis of Trial Balance by using excel. Make sure your Trial Balance should be in excel format.
This course will also help you to match opening and closing balances in 5 minutes. Also you can prepare MIS reports, comparative reports etc. with the help of this course. you will gain so much knowledge that you can prepare balance sheet on daily basis just in 5 minutes.
It is very easy to understand.
Content of Course :
- Powerful Excel Formulas (Most powerful Excel formula sikhaye jayenge jo aapko sirf B.Sheet banane mein hi nhi balki har jagah kaam aayenge)
- Checking of Trial Balance to correct mistake if any within 2 minutes
- Trial Balance arrangements using Excel for Automation
- Creation of Masters and Groups
- Preparation of Balance Sheet and Profit & Loss automatically with Trial Balance
- Full automation of B.Sheet ( iska matlab ek baar automation ke baad aap chahen toh daily balance sheet bana sakte hain woh bhi bus 5 minute mein, yaani agar Trial mein koi change ho jaaye toh bhi aapko koi pareshani nhi hogi,Ghanto ka kaam minuto mein hone lagega)
- Checking of Opening Trial Balance with Closing Trail Balance before finalization of Balance sheet is must and we will let you know how you can do this in minutes