How to Choose Stock Value With or Without Tax in myBillBook

Written By Team Flobiz

Last updated 13 days ago

Overview

Stock value directly impacts your Inventory reports, Profit & Loss, and Balance Sheet.
Different businesses - and accountants - treat GST differently:

  • Some include GST as part of item cost

  • Others exclude GST and treat it as input credit

Earlier, stock value in myBillBook followed a fixed logic, which caused confusion, mismatched reports, and trust issues.

myBillBook now lets you choose how stock value is calculated - with tax or without tax - and applies this choice consistently across all reports and platforms.

What Is Stock Value Calculation?

Stock Value = Selected Price × Current Stock Quantity

You can choose which price is used:

  • Purchase Price with Tax

  • Purchase Price without Tax

  • Sales Price with Tax

  • Sales Price without Tax

Example

If Purchase Price = ₹1,000 with 18% GST
👉 Price without tax = ₹847

Where You’ll See This Setting

1. Item Settings (Web & Mobile)

You’ll find this in Items → Item Settings.

  • Look for Stock Value Calculation

  • A dropdown shows all 4 calculation options

  • The currently selected option is clearly visible

  • Subtext explains how the stock value is derived

📌 Default for new users:
Purchase Price with Tax

2. Items Page – Stock Value Card

On the Items / Inventory dashboard, you’ll see:

  • A Stock Value card at the top

  • An info (ℹ️) icon beside “Stock Value”

When you hover or tap:

  • You’ll see how stock value is currently calculated

  • A “Change settings” CTA takes you directly to Item Settings

This ensures you always know why a certain stock value is shown.

How to Change Stock Value Calculation

Step 1: Open Item Settings

  • Go to Items

  • Click the Settings (⚙️) icon or use Change settings from the tooltip

Step 2: Select Stock Value Calculation

Under Stock Value Calculation, choose one option:

  • Purchase Price with Tax

  • Purchase Price without Tax

  • Sales Price with Tax

  • Sales Price without Tax

You’ll see an explanation below the dropdown showing the exact formula.

Step 3: Confirm the Change

Once confirmed, MyBillBook automatically recalculates everything.

No manual edits required.

What Updates Automatically After You Change This

Your selected method is applied everywhere, including:

Items & Inventory

  • Stock value per item

  • Total stock value shown on the Items page

Stock Summary Report

  • Stock value column updates automatically

  • Same logic applies when downloading reports (even for previous financial years)

Low Stock Summary

  • Stock value reflects the selected calculation method

Profit & Loss (P&L)

Based on your selection, the following values update:

  • Closing Stock

  • Gross Profit

  • Net Profit

Balance Sheet

  • Inventory in Hand value updates based on tax inclusion/exclusion

This ensures P&L and Balance Sheet always match your inventory logic.

Reports Affected by This Setting

You’ll see updated values in:

  • Stock Summary

  • Stock Detail Report

  • Low Stock Summary

  • Profit & Loss

  • Balance Sheet

📊 There is no separate report — the logic is applied uniformly across all existing reports.

Can I Change This Later?

Yes ✅

You can change the stock value calculation anytime from Item Settings.

  • The system recalculates all values automatically

  • Useful if:

    • Your accountant advises a different method

    • You initially selected the wrong option

    • Your GST treatment changes

Important Things to Know

  • This setting affects stock valuation in reports, not past transactions

  • It does not change invoice values

  • Default for new users is Purchase Price with Tax

  • Same experience across Web, Android, and iOS

  • Designed to prevent confusion, mismatched reports, and refunds due to “wrong stock value”

Who Should Use Which Option? (Quick Guidance)

  • Purchase Price without Tax
    👉 If you claim GST input credit (most GST-registered businesses)

  • Purchase Price with Tax
    👉 If GST is treated as part of cost

  • Sales Price options
    👉 Useful for valuation or estimation-based reporting

If unsure, check with your accountant before selecting.