IT and Taxation Practice Lecture Notes

Comprehensive vocabulary flashcards covering MS Office suite (Word, Excel, PowerPoint), database management (Access, SQL), auditing tools (CaseWare IDEA), and cloud accounting/ERP systems (Zoho, Tally, Oracle Fusion).

Gutter Margin

A margin setting that adds extra space to the side or top margin of a document intended for binding.

Portrait Orientation

A page layout setting where the document is oriented vertically; it is the default for business correspondence in Word, often sized at $8 \frac{1}{2} \times 11$ inches.

Section Break

A feature in Word that allows for different formatting across parts of a document; an even or odd numbered page section break starts the new section on the next corresponding page.

Tight Text Wrapping

A formatting option in Word where text flows around an image and hugs its specific shape.

Slide Master

A template in MS PowerPoint used to create consistent layouts and positions for objects, such as logos, throughout a presentation.

Placeholders

Objects on a PowerPoint slide specifically designed to hold text.

Motion Path

A type of animation in PowerPoint that provides a method of moving items along a specific path on a slide.

Format Painter

A tool used to apply formatting from text, shapes, or pictures to another selection in MS-PowerPoint.

VLOOKUP

An Excel function used to search for a value in the leftmost column of a table and return a corresponding value from a specified column.

Pivot Tables

Dynamic data management and analysis tools in Excel used for exploratory analysis and reporting of large datasets.

Slicers

Interactive visual filters used in Excel to filter data in tables or Pivot Tables.

Goal Seek

A What-If Analysis tool in Excel used to find the specific input value needed to achieve a predefined target or output value.

Internal Rate of Return (IRR)

The financial function in Excel representing the rate of return for a series of cash flows.

Absolute Cell Reference

A cell reference denoted by the $symbol (e.g.,$A$1$$) that remains fixed and does not adjust when copied to another location.

Primary Key

A field in a database table in MS Access used to uniquely identify every record; it cannot be blank or contain duplicate values.

SQL

Structured Query Language; a standardized language used to retrieve (via SELECT), update, insert, and delete data from databases.

AIS

Annual Information Statement; a comprehensive statement used in the taxation process in India.

GST TRN

Goods and Services Tax Taxpayer Registration Number; a temporary number required during the GST registration process.

PPOB

Principal Place of Business; a required entry in the GST registration process in India.

HSN/SAC Codes

Codes used in the Goods and Services section of tax filing to classify various products and services specifically.

UAN

Universal Account Number; a unique $12$ digit number used for EPF (Employee Provident Fund) registration.

ODBC

Open Database Connectivity; a standard application programming interface for accessing database management systems, used for importing data in CaseWare IDEA.

Benford's Law

A mathematical law used in auditing software like CaseWare IDEA to detect anomalies by identifying deviations from the expected frequency distribution of leading digits.

Stratified Sampling

A sampling method in CaseWare IDEA that ensures a sample is representative by dividing the population into sub-groups and sampling proportionally from each.

BRS

Bank Reconciliation Statement; a feature in Zoho Books and Tally used to align bank account transactions with internal accounting records.

P2P Process

Procure-to-Pay; an Oracle Fusion process involving procurement through a purchase requisition and concluding with payment processing.

Three-Way Matching

An accounting process in Oracle Fusion that involves matching purchase orders with receipts and invoices to validate payments.

O2C

Order-to-Cash; a business process in Oracle Fusion managing customer interactions from order entry through payment collection.

H2R

Hire-to-Retire; a Human Capital Management process in Oracle Fusion that manages the entire employee lifecycle.