Tally Prime Course + Advance Excel Combo Training Pack

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.

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.

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

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.

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.

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.

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

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.

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.

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

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.

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.

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.

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

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

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.

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.

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.

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.

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.

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 Tally by validating opening balances, generating trial balance, balance sheet, and profit and loss, and viewing ledger details with Alt+F1.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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 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.

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.

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

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.

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 2 by creating ledgers, posting salary payments by cheque, and handling dividend receipts and rent under indirect expenses.

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.

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

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.

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.

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.

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.

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 using the purchases voucher in item invoice mode, entering inventory items, supplier invoices (invoice no. 25), and trader party accounts to reflect stock movements.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

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.

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.

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.