KB CloudERP - Help Center
Feature RequestRoadmapAPICompany
  • Overview
    • About
    • Changelog
    • Support
  • Knowledge Base
    • Get Started
      • How to register your business in KB CloudERP?
      • How to do a quick setup of business settings?
      • How to setup your company details?
      • How to setup multiple business locations/warehouse?
      • How to set up a bank/cash?
      • How to add payment accounts in KB CloudERP?
      • How to setup and edit payment methods?
      • How to setup tax rates, tax groups & disable tax?
      • How to setup an invoice scheme?
      • How to setup invoice layout?
      • How to add types of service?
      • How to change the theme color?
    • Import
      • Import products using Excel file templates
      • Import opening stock using Excel template
      • Import contacts using Excel file templates
      • Import sales using Excel file templates
    • Users
      • How do you setup roles?
      • How to add user?
      • How to assign location to user?
      • How to add commission agents?
    • Contacts
      • Add supplier & customers
      • Add customer groups
      • Add opening balance & payments
      • Add advanced balance
      • Add credit limit for customers
      • View customer & supplier ledger
    • Products
      • Add product category
      • Add product units
      • Add product variations
      • Add products
      • Add product types
      • Add opening stock
      • Duplicate product
      • Product warranty
      • Printing labels/barcode
      • Product selling price groups
      • Product expiry settings
      • What is stock transfer?
      • What is stock adjustment?
      • Product stock history
      • Edit products (bulk edit)
      • Delete products (bulk delete)
      • How to do price update?
      • Product tax types
    • Purchase
      • Adding purchase
      • Purchase order
      • Purchase requisition
      • Purchase payment
      • Purchase invoice
      • Different purchase price
      • Purchase with excise/custom duty
    • Sales/Sell
      • POS screen guide
        • Finalize sales options
        • Tender change
        • Adding payments from contact
        • Previous sale amount in sales
        • Use case of suspended sales
        • Rounding mechanism explained
        • Adding bonus or free items at sale
        • Featured products in the POS screen
        • Display product unit price in POS
        • Shipments, home delivery, or parcel management
        • Cash denomination
      • Sales subscriptions
      • Sales services
      • Sales return
      • Sales order
      • Discounts by brand, category, location
      • Displaying QR code in invoice
      • Gift receipt
      • Proforma invoice
      • Invoice external URL
    • Expenses
      • Add expense categories
      • Add expenses
      • Add recurring expenses
      • Add expenses refund
      • Add payroll expenses
    • Reports
      • How to check reports?
      • Cash register report
      • Stock expiry report
      • How to export your data/reports?
    • Notifications
      • Notifications templates
        • Ledger notifications
        • Customer notifications
        • Supplier notifications
      • How to setup SMS notifications
      • How to setup email notifications
      • Auto send notifications
    • Custom Labels
      • Custom payments
      • Contact custom fields
      • Products custom fields
      • Location custom fields
      • User custom fields
      • Purchase custom fields
      • Purchase shipping custom fields
      • Sell custom fields
      • Sale shipping custom fields
      • Type of service custom fields
    • Settings
      • How to search in settings?
      • Disable tax rates
      • Decimal precision for currency & quantity
      • Disabling printing receipts on the POS screen
      • Enable customer reward points
      • Stock accounting methods
      • Lot number/IMEI serial tracking
    • Modules
      • Accounting Module
      • Restaurant Module
        • Add tables
        • Add modifiers
        • Add table bookings
        • Enable service staff
        • Enable service staff pin
        • Kitchen dashboard
        • Kitchen orders
        • All orders & line orders
      • HRM Module
        • Payroll management
        • Shift management
        • Holidays management
        • Leave management
        • Attendance management
        • Essentials module
        • What is a sales target?
      • Project Management
      • CRM Module
      • Advance Repair
      • HMS Module
      • Manufacturing
        • Settings
        • Permissions
        • Using for repackaging and selling
      • WooCommerce
      • Spreadsheet
      • Catalogue QR
      • Partnership
    • Integrations
      • Google Map
      • Chat GPT
      • WooCommerce
      • Khalti
    • Tips & Tricks
      • Keyboard shortcuts for POS
      • Improve browser based print (Receipts or other)
      • Create shortcuts for web
      • Browser full-screen mode or distraction-free mode
      • Barcode scanner trick
      • Reusing product barcodes
  • Help and FAQ
    • Troubleshoot
    • Hardware Support
      • How to add a barcode scanner?
      • How setup label weighing scale?
      • How to setup thermal printer for receipt printing
      • Barcode printer support
      • How to setup a printer to open cash drawer automatically?
    • FAQ
Powered by GitBook
On this page
  • Features
  • Creating Folders
  • Creating Spreadsheets
  • Editing Folder Name
  1. Knowledge Base
  2. Modules

Spreadsheet

Using this module you can create powerful spreadsheets inside KB CloudERP.

Without leaving the system and using Excel. It will be safely stored in the cloud.

Features

  1. Spreadsheet Editor: Create powerful spreadsheets inside KB CloudERP using an inbuilt feature-rich spreadsheet editor.

  2. Import & Export: Import & Export spreadsheet

  3. Sharing: Share it with other Roles or other Users

  4. Organise: Organise spreadsheet into folders using the folder structure, with easy searching & one-click expand/collapse.

Creating Folders

Folders can be created in the spreadsheet module.

To create a folder, click the add folder button, provide an appropriate name to the folder, and save it.

The created folders will be displayed as a tree structure.

Creating Spreadsheets

Once the folder is created, an option to create a spreadsheet under each folder is provided.

You can click the ‘+’ symbol and add a spreadsheet.

The spreadsheet will be similar to Google Sheets. You can add sheets, download or save sheets, and upload Excel files.

Editing Folder Name

You can click the edit symbol and edit a folder name.

PreviousWooCommerceNextCatalogue QR

Last updated 11 months ago