Protect your Lenovo Server
Contact WhatsApp
Search Results – Bison Knowledgebase

🔍 Results for “zerodha ledger excel”

How to Download Ledger Statement in Zerodha (Kite & Console)

A ledger statement in Zerodha provides a complete financial record of all debits, credits, charges, and fund movements associated with your trading account. This document is essent…

Zerodha

Introduction Zerodha is one of India's leading discount brokerage firms, known for its innovative technology and user-friendly trading platforms. Founded in 2010, Zerodha has revol…

Excel Files Not Opening on Double-Click in Windows (Opens Only from Inside Excel)

A common issue on Windows systems is when Microsoft Excel files do not open by double-clicking, but open successfully when launched from within Excel using File → Open. This behavi…

Excel Sheet Tabs Not Visible: Complete Technical Guide to Diagnose and Restore Missing Worksheets

Microsoft Excel is widely used for data management, accounting, and reporting. One of its core UI components is the worksheet tab bar, located at the bottom of the workbook. When t…

Excel Sheet Tabs Not Showing: Complete Technical Guide to Diagnose and Fix Missing Worksheet Tabs

Microsoft Excel users occasionally encounter an issue where worksheet tabs (sheet tabs) are not visible at the bottom of the workbook, making it difficult or impossible to navigate…

Microsoft Excel Features and Shortcut Commands for Everyday Productivity

Microsoft Excel is a powerful spreadsheet application used daily for data entry, calculations, reporting, analysis, and decision-making. While many users rely on mouse-driven actio…

How to Use ChatGPT and AI Tools to Build Excel Dashboards Without Remembering Formulas

IntroductionCreating dashboards in Excel is one of the most powerful ways to visualize data and make smarter decisions. However, for many users, remembering complex formulas like V…

Why Your Laptop Fan Goes Crazy During Stock Market Hours — Hidden Secrets Behind Browser-Based Trading on Zerodha, Kotak, Sharekhan, ICICI Direct, Nirmal Bang, Angel One & Others

Have you ever noticed your laptop fan roaring the moment you open your trading platform like Zerodha Kite, Kotak Neo, Sharekhan TradeTiger (Web), ICICI Direct, Angel One, Upstox, o…

How to Export Unicode Data (Hindi & Punjabi) from phpMyAdmin to Excel and Import Back Without Errors

Managing multilingual databases can be challenging, especially when your website stores content in languages like Hindi and Punjabi. Many website administrators face a common issue…

Why Business Owners Should Shift from Excel to Google Sheets ASAP: A Practical Technical Guide

For decades, Microsoft Excel has been the backbone of data management for businesses. From accounting records to inventory tracking, Excel spreadsheets have been used everywhere. H…

Essential Excel Commands for Everyday Office Work — Master Your Spreadsheets Like a Pro!

Whether you're a beginner or a pro, mastering Excel formulas can save you countless hours and boost your productivity. From cleaning data to managing AMC schedules, Excel plays a k…

Fixing “Acknowledgement Number is Invalid” Error in Income Tax e-Filing CSV Upload

While uploading donation details (Section 80G) to the Income Tax e-Filing portal, users often encounter a frustrating error:“Acknowledgement Number is invalid.”At first glance, the…

What Is Power BI for MS Office?

Power BI for MS Office means using Microsoft Power BI together with Microsoft Office apps like Excel, Teams, SharePoint, and Outlook.In simple words, Power BI helps you understand …

Manual Data Entry Errors in Tally Prime – Simple Prevention & Fix Guide

When working in Tally Prime, most data is entered manually. With heavy workloads, mistakes can easily happen.Common issues include:✔ Duplicate vouchers ✔ Wrong dates ✔ Incorrect…

Tally Prime Discount + GST Calculation Mistakes – Causes, Fixes, and Best Practices

In Tally Prime, discount handling directly impacts GST calculation. Incorrect discount configuration or voucher entry often leads to wrong taxable value, incorrect GST amount, GSTR…

GST Reverse Charge Mechanism (RCM) for Hostinger Purchases and Resale in India – Accounting & Tally Prime Implementation Guide

Indian businesses frequently purchase hosting, cloud, and digital services from overseas providers such as Hostinger. When these services are imported into India and later resold t…

Amazon Seller Fee Calculator (Excel & JSON) – India

Selling on Amazon India involves multiple fee components such as referral fees, closing fees, shipping charges, fulfillment fees, and GST.An Amazon Seller Fee Calculator helps sell…

How to Disable Annotations, Comments, and Markups When Printing in Excel and Word

When working with Microsoft Word or Excel, annotations such as comments, tracked changes, and ink markups are useful for collaboration. However, printing these annotations is often…

uBooks Accounting & GST Compliance Software – Technical Knowledge Base Guide

uBooks is an Indian cloud-enabled accounting and GST compliance software developed by Adaequare Info Private Limited. It is designed to help small businesses, professionals, and en…

GST Return Errors in Tally – Causes, Fixes, and Best Practices

GST compliance in India relies heavily on accurate data entry and correct return preparation. Businesses using Tally frequently encounter GST return errors while generating GSTR-1,…

Blockchain Technology: A Practical Technical Guide for IT and Enterprise Use

Blockchain technology is a distributed ledger system designed to record transactions in a secure, transparent, and tamper-resistant manner. Originally introduced as the foundation …

FocusLyte ERP & Accounting Software – Technical Knowledge Base Guide

FocusLyte is an integrated ERP and accounting solution developed by Focus Softnet Private Limited. It is designed to support financial accounting, inventory management, GST complia…

Complete Technical Guide to GST Configuration and Compliance in TallyPrime

Goods and Services Tax (GST) compliance is a critical requirement for businesses operating in India. TallyPrime provides a robust and structured framework to configure GST, manage …

How to Stop the Cost Allocation Screen for Round Off Entries in Tally Prime

Sometimes in Tally Prime, you may see a screen asking you to allocate a small amount like ₹0.45 to a cost centre.If you do not use Cost Centres for Round Off values, this screen ca…

Resolving HSN vs SAC and UQC Errors in GSTR-1 for Subscription-Based Services in Tally Prime

Businesses dealing in computer hardware, software, and subscription-based services such as Google Workspace, Tally licenses, AMC (Annual Maintenance Contracts), and cloud services …

Saral Accounts – Accounting & GST Software | Technical Knowledge Base Guide

Saral Accounts is a desktop-based accounting and GST-compliant business software developed by Relyon Softech Limited. It is designed for small and medium businesses (SMBs) to manag…

CaptainBiz GST Accounting & Compliance Software – Technical Knowledge Base Guide

CaptainBiz is a GST-focused accounting, invoicing, and compliance software developed by IRIS Business Services Limited. It is designed primarily for small and medium businesses (SM…

Types of Microsoft Office Licenses: Complete Guide for Home, Business, and Enterprise Users

Microsoft Office is one of the most widely used software suites in the world. From personal productivity to enterprise collaboration, it offers tools like Word, Excel, PowerPoint, …

Comprehensive Guide to Chart of Accounts (CoA) in India with Practical Implementation in TallyPrime

The Chart of Accounts (CoA) is the backbone of any accounting system. It defines how financial transactions are classified, recorded, and reported. In India, while the term “Chart …

GST & Compliance Errors in Tally Prime – Simple Fix Guide

GST-related errors in Tally Prime can create serious problems like:Wrong tax calculationMismatch in GSTR reportsRejected e-invoicesFailed e-way billsMost of these issues happen due…

Understanding Tally Reporting Capabilities: Standard Features, Configuration Requirements, and Customization Needs

Tally is one of the most widely used accounting and business management software solutions for small and medium enterprises. It provides a strong foundation for financial accountin…

Investment & Trading in India: SEBI-Regulated Companies, Registration Norms, Onboarding Criteria, and “Claim” (Dispute/Grievance) Workflows

Investment and trading in India operate under a regulated market structure overseen primarily by SEBI (Securities and Exchange Board of India). A safe and compliant setup requires …

Top 10 Secret Key Commands in Microsoft Office

Top 10 Secret Key Commands in Microsoft Office (Easy Guide)IntroductionMicrosoft Office (Word, Excel, PowerPoint, Outlook) includes many hidden keyboard shortcuts that can dramatic…

Microsoft Office and Office Productivity Suites: History, Current Versions, Competitors, and Future Direction

Microsoft Office has been one of the most influential productivity software suites in computing history. From standalone desktop applications in the 1990s to today’s cloud-connecte…

Build Your Own Secure Live Stock Market Dashboard in PHP (India NSE/BSE Guide)

Build a Secure Live Stock Market Dashboard in PHP & MySQL Using API (India NSE/BSE, Futures & Options Tracking)IntroductionRetail traders and IT professionals often rely on…

Understanding LST_XXX.dat Files in TallyPrime Data Folder: Structure, Purpose, and Best Practices

In TallyPrime, company data is not stored in a single database file like traditional SQL systems. Instead, Tally uses a proprietary file-based data architecture, where multiple fil…

TallyPrime 2026 Update Guide: New Features, Automation Tools & Webinar Insights for Smarter Accounting

TallyPrime continues to evolve as one of the most powerful business management and accounting platforms in India. With the latest updates for 2026, TallyPrime introduces advanced a…

Why Tally Prime Shows “GST-related details were altered…” Message & What You Should Do?

When using Tally Prime for GST compliance, you may come across a pop-up message that says: “GST-related details were altered in the masters/Return. Hence, opening the report will …

History and Evolution of Function Keys (F1–F12): Origin, Development, and Modern Usage in Computing

Function keys—commonly labeled F1 to F12—are an essential part of modern keyboards, enabling quick access to commands and improving productivity. While today they are used for ever…

Cygnet FACE – GST Compliance, Reconciliation & Automation Platform | Technical Knowledge Base

Cygnet FACE is an enterprise-grade GST compliance and reconciliation platform developed by Cygnet Infotech Private Limited. FACE (Fully Automated Compliance Engine) is designed to …

Microsoft Enterprise Software & Cloud Platforms – Overview of Microsoft Products and Services

Microsoft provides one of the most comprehensive enterprise software ecosystems globally, covering operating systems, productivity tools, cloud infrastructure, databases, ERP/CRM p…

AI Tools for Traders: Powerful Artificial Intelligence Platforms for Smarter Trading

Artificial Intelligence (AI) is rapidly transforming the world of financial trading. Modern traders must analyze enormous amounts of data including price charts, market news, techn…

Stock Market (Share Market): Complete Technical Guide – How It Works, Key Participants & Best Practices

1. Introduction to the Stock Market (Share Market)The stock market, also known as the share market, is a regulated marketplace where shares (equity), bonds, derivatives, and other …

Complete Guide to Creating and Changing Financial Year in Marg ERP

Financial year management in Marg ERP is a crucial accounting process that ensures smooth transition of data, accurate reporting, and compliance with taxation systems like GST.Unli…

How to Change Financial Year in TallyPrime

As businesses step into a new financial year, efficient accounting transitions become critical. For users of TallyPrime, the process is designed to be seamless, eliminating complex…

Cryptocurrency & Blockchain Technology: A Complete Technical Guide to Crypto Markets, History, and Global Exchanges (2026 Edition)

Cryptocurrency represents a decentralized digital financial system built on cryptographic security and distributed ledger technology. Since the launch of Bitcoin in 2009, the crypt…

Finance Software in India (Accounting & Payroll): Vendors, Registration Norms, Procurement, Compliance & Claim Guide

Finance software—specifically Accounting and Payroll systems—is essential for accurate financial management, statutory compliance, reporting, and payroll processing across Indian b…

Reversing an Old Service Invoice Using a Debit Note (India – GST & Accounting Guide)

In real-world business operations—especially in IT services, AMC contracts, and subscription-based services—it is common to encounter scenarios where an invoice raised earlier must…

Zoho Books – Cloud Accounting & GST Compliance Software | Technical Knowledge Base Guide

Zoho Books is a cloud-based accounting and GST-compliant business management software developed by Zoho Corporation Private Limited. It is widely used by startups, small and medium…

Best Mouse Pointer Speed Settings in Windows: Complete Technical Guide for Accuracy, Productivity, and Gaming

Mouse pointer speed is one of the most important yet often overlooked settings in a computer system. Whether you are working on accounting software like Tally, designing graphics, …