Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Tally Prime, Advanced Excel & Claude AI for Accounting
Rating: 4.4 out of 5(319 ratings)
3,361 students

Tally Prime, Advanced Excel & Claude AI for Accounting

Practice Tally Prime bookkeeping, Excel formulas and reporting, and Claude AI workflows for accountants.
Last updated 11/2026
English
English [Auto],

What you'll learn

  • Set up and navigate Tally Prime, create and manage company accounts, and perform essential accounting functions.
  • Manage inventory, handle GST compliance, generate financial reports, and automate repetitive accounting tasks.
  • Understand Excel interface, perform basic data entry, and use essential formulas and functions.
  • Master data analysis, create pivot tables and charts, use advanced formulas, and automate tasks with macros.
  • Use Claude AI to draft journal entries, reconcile spreadsheet records, and prepare draft financial reports for review.

Course content

3 sections • 143 lectures • 13h 32m total length
  • Introduction to Course4:24
  • Installation of Tally Prime on Your Laptop5:47

    Download and install Tally Prime on your laptop from the telly solutions website, then configure country settings and accounting terminology with data saved on the C drive.

  • Creating New Company and Alternation of Details in Tally2:56

    Create a new company in Tally by entering the name, address, state, country, base currency, and financial year; enable accounting, inventory, and payroll features, then update details.

  • FAQs0:59
  • Important Message1:23

    Explore a post-video pop-up that prompts rating the course with stars and a comment box, then save and exit.

  • Learn to Use Short keys in Tally Prime3:53

    Learn tally prime shortcut keys by blue highlighted letters on the main screen to create ledgers, view balance sheets, and run reports. Use dash notation and escape for quick navigation.

  • Introduction to Assignment2:24

    Learn to set up a new company assignment, record journal entries, and generate ledger, trial balance, balance sheet, and income statement in Excel, then compare automated reports with manual records.

  • Company Creation for New Assignment3:08

    Create a new company in Tally Prime, enter the name Ms Smith and Go Private Limited, set country to United States, and define the financial year beginning April 1, 2019.

  • Dealing With Initial Capital Investment in Business7:45

    Record the initial capital investment in the company using receipt vouchers and ledger creation, and explain when to use journal entries.

  • Dealing with Contra Entries In Tally Prime4:19

    Learn how to record contra entries in Tally Prime by transferring cash to bank using vouchers, switching to double entry, and linking cash with bank accounts.

  • Entering Purchase Invoice as Voucher in Tally5:13

    Learn to enter a purchase invoice as a voucher in Tally, create a vendor, set the invoice number and date, and record debit against accounts payable with narration.

  • Pay for the Purchase Invoice in Cash Agst Ref5:14

    Learn to pay a purchase invoice in cash using the against reference option, settle a 40000 bill, and understand adjustment methods in Tally Prime.

  • Purchase Of Fixed Assets in Tally ERP1:50

    Learn how to record a land purchase as a fixed asset in tally erp, using cash payment, selecting fixed assets, and entering 60000 with price control.

  • Entering Sales Invoice as Voucher in Tally Prime3:05

    Learn to enter a sales invoice as a voucher in Tally Prime, creating the Swathi ledger, handling debit receivable, credit sales, and choosing item invoice or journal voucher.

  • Recording Salaries in Tally2:12

    Learn how to record salaries in Tally by a cash payment voucher, selecting wages and salaries under indirect expenses, adding narration, and reviewing entries through reports.

  • Rent Received By Cash2:00

    Record rent received by cash using a receipt voucher in single entry mode, categorized as indirect income in the daybook, amount 5500 for November.

  • Recording General Purchase Invoice2:48

    Record a general purchase invoice in tally prime, including date, invoice number 254, party name, creditors, debit and credit entries, and related reports.

  • How to Extract Reports in Tally4:38

    Learn to extract trial balance, balance sheet, and income statement reports in Tally, compare manual records with software outputs, and navigate reports to reconcile ledgers.

  • Alter and Edit Tally Groups Ledgers and Transactions4:38

    Learn to alter and edit ledgers, groups, and transactions in tally by using ledger and group settings, modifying names and details, and reviewing changes via daybook and reports.

  • Printing Reports in Tally Prime0:59

    Print reports in tally prime by selecting the report, using Alternate B to choose current or other reports, customize details, percentages, and zero-balance exclusion, then preview and print.

  • Record Opening Balances Part 14:42

    Create a new company in tally and enter opening balances for capital and assets as of April 1, 2020; prepare ledgers and review the opening trial balance.

  • Record Opening Balances Part 25:42

    Learn to create and audit multiple ledgers for opening balances in Tally Prime, using multi create and multi audit in the chart of accounts, and enter balances for indirect expenses.

  • Record Opening Balances Part 34:29

    Enter opening balances for salaries, indirect expenses, fixed assets, and creditors using the multi-ledger feature in Tally Prime, then generate reports like trial balance, gross profit, and balance sheet.

  • Extract Important Reports in Tally2:45

    Extract important reports in Tally by validating opening balances, generating trial balance, balance sheet, and profit and loss, and viewing ledger details with Alt+F1.

  • How to Edit or Alter Ledgers in Tally Prime1:42

    Learn to edit ledgers in Tally Prime by changing names, amounts, or nature, and use single and multi ledger edits via chart of accounts to reclassify expenses.

  • Introduction and Company Creation2:35

    Create a new company in tally prime, enter opening balances for ledgers, set up sundry creditors and debtors with control accounts, and prepare 2019–2020 trial balance and trading account.

  • Entering All Opening Balances Batch Entry6:33

    Create multi ledgers in tally prime and batch enter opening balances for capital, cash in hand, fixed assets, prepaid expenses, and current liabilities along with sundry creditors and debtors.

  • Recording Company Transactions Part 14:23

    Record and classify company transactions in tally prime, using vouchers and cash in hand, create telephone expenses ledgers, and process commission received in double-entry mode.

  • Recording Company Transactions Part 27:02

    Record supplier payments and partial settlements in Tally Prime; set up stock items and bills by bill balances, and decide inventory versus fixed asset treatment.

  • Dealing With Contra Entries in Tally Prime2:25

    Record contra entries in tally prime by transferring between bank and cash with debit and credit. Learn to switch to double-entry mode and delete erroneous ledgers.

  • Wages Payment in Tally1:21

    Record wages payment in tally by creating a wages ledger under direct expenses and paying rupees fifteen hundred in cash through the double entry mode, with narration paid wages.

  • Dealing With Credit Sales In Tally Prime2:32

    Learn how to record a credit sale of goods in tally prime, including creating a debtor under sundry debtors, sealing the invoice, and setting 25-day credit terms.

  • Handling Purchase Returns in Tally2:28

    Record a purchase return in tally by creating a debit note of 5000 against the October 1 bill, settling it with the vendor to leave a 45000 balance.

  • Dealing With Rent Income1:37

    Record rent income of 30,000 as cash received using a receipt voucher in Tally, creating the rent received ledger under indirect incomes via double-entry.

  • Record Other Transactions and Extracting Reports5:58

    Record salary and transactions with vouchers, posting debits and credits to indirect expenses and printing and stationery, reconciling bank entries to generate trial balance, profit and loss, and balance sheet.

  • Introduction to BRS5:23

    Learn to perform bank reconciliation statement (BRS) in Delhi Prime, compare company books with bank statements, and identify differences caused by outstanding checks, deposits in transit, charges, and other errors.

  • Bank Reconcilliation Assignment Scenario Explained1:37

    Demonstrate a practical bank reconciliation scenario using a company bank statement, aligning transactions, deposits, and matching debit and credit entries for April 2020.

  • Create Company and Record Opening Balances5:29

    Create a company in Tally Prime, set country and financial year April 1 2020, then record opening balances using multi ledger creation for capital, cash in hand, bank, and debtors.

  • Record All Transactions Part 14:22

    Perform bank reconciliation by entering all transactions, then match them with the bank statement to explain balance differences and resolve discrepancies, using Tally Prime vouchers for payments and receipts.

  • Record All Transactions Part 24:47

    Record all transactions part 2 by creating ledgers, posting salary payments by cheque, and handling dividend receipts and rent under indirect expenses.

  • Bank Reconcilliation Part 19:27

    Master bank reconciliation by matching bank statements with company records, identify differences, and record missing transactions such as standing orders and campus fees in Tally.

  • Bank Reconcilliation Part 27:48

    Record standing orders and receipts in tally, post vouchers to debit and credit accounts, and reconcile bank statements to verify balances.

  • Godowns and Inventory Creation Introduction7:22

    Learn how to create godowns in Delhi and manage inventory in Tally Prime, including stock groups, units, stock items, and opening and closing stock for trading and manufacturing scenarios.

  • Company Creation and Opening Balances9:05

    Learn to create a new company in Delhi, set opening balances, and manage godown inventory in Tally Prime to prepare journal entries, trial balance, and trading, P&L, and balance sheet.

  • Go downs Creation In Tally2:08

    Learn how to create go-downs in tally by configuring main and secondary locations, enabling address fields, and assigning location names and addresses for inventory storage.

  • Stock Groups and UOM Creation2:23

    Create stock groups like mobile items and memory items, add stock items under the primary group, and define stock units with symbol or compound types for buying and selling.

  • Dealing With Stock Items in Tally Prime5:44

    Create and manage stock items in Tally Prime by defining categories, units, and quantities, assigning items to stores and godowns, updating reports, and correcting misclassifications to ensure accurate stock records.

  • Record All Transactions Part 13:38

    Record all transactions using the purchases voucher in item invoice mode, entering inventory items, supplier invoices (invoice no. 25), and trader party accounts to reflect stock movements.

  • Record All Transactions Part 24:14

    Demonstrates recording a credit sale to Muhammad Traders in tally prime, including creating sundry debtors, a new sales ledger, and entering item lines with quantities, rates, and invoice number 52.

  • Purchase Returns With Multiple Go downs in Tally Prime4:21

    Process purchase returns in Tally Prime by creating debit notes against supplier invoices, linking returns to the original reference, and adjusting pending bills across multiple go-downs.

  • Sales Returns With Multiple Godowns in Tally Prime3:00

    Learn to process sales returns with multiple godowns in tally prime by selecting the invoice, entering items and quantities, and updating narration and ledger entries.

  • Final Reports of The Assignment3:41

    Learn to extract trial balance, balance sheet, and profit and loss in Tally Prime, view details with F1, adjust periods, and review stock items and stock group summaries.

  • Introduction to Manufacturing Accounts4:31

    Explore manufacturing accounts in Tally Prime, using the manufacturing journal to convert raw materials into finished goods and create stock items in a new company.

  • Setting up BOM and Other Config5:23

    Create stock groups, units, and stock items for raw materials and finished goods, configure the bill of materials, and set up manufacturing and stock journals.

  • Manufacturing Finished Goods From Raw Material4:34

    Enter a double bill of material, record supplier invoices and raw material consumption, then assemble finished goods (computers) from the BOM in tally prime to convert components into laptops.

  • Sales of Finished Goods in Tally2:20

    Explains recording a finished goods sale in Tally Prime: create a new customer, enter 19 computers at 25,000 each totaling 75,000, with 30-day credit terms.

  • Final Reports3:28

    Explore trial balloons and profit or loss reports to reconcile totals and view detailed entries. Navigate the balance sheet and drill down to stock groups with the search feature.

  • Payroll Basic Configuration9:25

    Configure payroll basics for Delhi by creating the company Surgical Private Limited, setting opening balances, and detailing allowances, deductions, and provident fund contributions for payroll processing.

  • Units and Attendance Types3:20

    Learn to create payroll units and attendance types, defining RS and minutes as units, linking 60 minutes per hour, and configuring present and overtime attendance under primary rules.

  • Dealing With Pay heads Creation Part 17:55

    Learn to configure payroll pay heads such as basic salary, overtime allowance, dearness allowance, food and medical allowances, and provident fund, using attendance-based, month-wise calculations.

  • Dealing With Payheads Creation Part 29:15

    Configure employer contribution and EPS in Tally, applying 8.33% under 6500 and 541 above, allocate the EPF remainder, and set up loan and travel allowance heads.

  • Group and Individual Salary Details6:53

    Define group salary structure and individual salary details, then copy group values to employees and set basic salary, allowances (dearness, medical, overtime, food, traveling), house loan, and contributions.

  • Finalizing Payroll Process9:18

    Finalize payroll by processing attendance, autofill payroll, calculate salaries and allowances, handle house loan entries, set opening balances, and execute salary payments via bank vouchers and daybook reviews.

  • Generating Payroll Reports4:56

    Generate payroll reports in Tally Prime, preview payslips and payroll statements, export to Excel or PDF, and review attendance, payment advice, and employee profiles.

  • GST Scenario Explained and Company Creation5:41

    Explore GST setup in Tally Prime by creating a Tamil Nadu company, enabling GST, and configuring stock items with GST rates, including monthly GST registration and types.

  • GST and Stock Groups Configuration6:30

    Create stock groups and units of measure, enable GST with 18% and 28% rates for computers and cameras, and set up ledgers for CGST, SGST, and IGST in Tally.

  • Recording GST Transactions Part 16:41

    Learn to record GST transactions in tally prime, including within-state and interstate purchases, entering supplier invoices, creating sundry creditors, and automatic GST calculation across items.

  • Recording GST Transactions Part 25:30

    Learn to record intra state and inter state GST transactions in Tally Prime, create sales ledgers, enter party details, apply DST and YDSTIE, and generate invoices.

Requirements

  • Familiarity with using a computer and navigating software interfaces.
  • Access to Tally Prime, Microsoft Excel, and Claude is helpful for following the hands-on exercises.
  • A stable internet connection to access course materials and video lectures

Description

Learn Tally Prime accounting, Advanced Excel, and Claude AI for accountants through practical exercises. Set up a company in Tally Prime, record transactions, and follow those entries through to accounting reports. Then build the spreadsheet skills to organize, check, and present financial records.


The Tally Prime training starts with company setup and takes you through hands-on bookkeeping assignments. Practice working with ledgers and vouchers, recording business transactions, and reviewing the reports those transactions produce. The exercises help you connect everyday entries with the figures you see at the end of an accounting period.


In Advanced Excel, work with formulas, text functions, worksheet references, and tools such as Flash Fill to clean and organize records. Practice combining and splitting columns and linking information across worksheets so you can build clearer financial spreadsheets.


A dedicated Claude AI for Accountants section shows how to draft journal entries, categorize transactions, and reconcile records using Excel or Google Sheets. You will also see how to compile receivables and payables ledgers, draft financial statements and VAT working papers, build dashboards, and prototype an invoicing app. Explore Claude Skills for repeatable tasks and check AI-generated drafts against source records before using them.


This course is designed for accounting students, bookkeepers, finance teams, and small-business owners who want to learn Tally Prime, improve their Excel skills, and see where Claude can assist with day-to-day accounting work.

Who this course is for:

  • Small Business Owners: Looking to manage their accounting and financial data efficiently using Tally Prime and Excel.
  • Accounting professionals and bookkeepers who want practical Tally Prime, Advanced Excel, and Claude AI workflows.
  • Students and Graduates: Aspiring to build a career in accounting, finance, or data analysis.
  • Freelancers and Consultants: Wanting to offer comprehensive accounting and data management services to clients.
  • Anyone Interested in Accounting and Data Analysis: Regardless of experience level, who wants to streamline their financial management and reporting processes.