Skip to main content

Invoice Management (Sales)

Invoice management in Hbl's simpleBillBook allows you to create sales invoices, track customer transactions, and manage receivables. This guide covers creating sales invoices, configuring invoice settings, and managing the complete sales cycle.

Overview of Sales Invoices

Sales invoices are formal documents issued to customers for goods sold or services rendered. They serve as:

  • Legal records of sale
  • Payment requests
  • Tax documentation
  • Inventory reduction triggers

Viewing Sales Invoices

To view all sales invoices:

  1. Navigate to Manage Sales → Invoice from the main sidebar
  2. You'll see a table listing all sales transactions

Sales Invoices List Figure 1: Sales invoices list showing all transactions with payment status

Sales Invoice Table Columns:

Transaction Details:

  • Sales Number: Unique invoice number (e.g., HBL1, HBL2)
  • Sale Date: Date of sale
  • Customer: Customer name
  • Qty: Total quantity of items sold

Financial Information:

  • Total: Total invoice amount
  • Amount Paid: Amount received from customer
  • Payment Status: Paid/Unpaid/Partial status
  • Created By: User who created the invoice

Search and Navigation:

  • Type to search: Search by sales number, customer, or date
  • Pagination: Navigate through invoice pages
  • Status Filters: Filter by payment status if available

Creating a New Sales Invoice

Step 1: Access Invoice Creation

From the sales invoices page, click Create Sale or similar button.

Step 2: Fill Invoice Details

Create Sale Form Figure 2: Form for creating new sales invoices

Header Information:

  • Customer*: Select customer from dropdown (required)
  • Invoice Number: Auto-generated based on settings (e.g., HBL 2)
  • E-way Bill Number: For GST compliance (if applicable)
  • Company Details: Auto-filled from company settings

Item Selection:

  1. Click + Add Item to add products to the invoice
  2. Select Product from dropdown
  3. Enter quantity, unit price, and other details:

Item Columns:

  • Product: Item name from inventory
  • Qty*: Quantity sold (required)
  • Unit Price*: Selling price per unit (required)
  • Discount %: Percentage discount applied
  • Tax %: Applicable tax rate
  • Total: Line item total (auto-calculated)

Payment Information:

  • Payment Method: Select payment type (Cash, Card, Bank Transfer, etc.)
  • Amount Paid: Enter amount received at time of sale
  • Payment Status: Auto-updates based on amount paid vs. total

Tax Calculations:

  • VAT Rate: Value Added Tax rate
  • VAT Amount: Calculated tax amount
  • VAT Due Date: Tax payment deadline
  • Total with Tax: Final amount including taxes

Step 3: Save Invoice

  • Save as Draft: Save for later completion
  • Save and Print: Save and generate printable invoice
  • Save and Send: Save and email to customer
  • Cancel: Discard the invoice

Invoice Actions and Management

Available Invoice Actions:

Invoice Actions Figure 3: Sales invoice with available action buttons

Common Actions on Invoices:

  • View: See complete invoice details
  • Edit: Modify invoice (if not finalized)
  • Print: Generate printable version
  • Email: Send to customer electronically
  • Duplicate: Create similar invoice quickly
  • Void/Cancel: Mark as cancelled
  • Payment: Record additional payments

Payment Processing:

  1. Locate invoice in list
  2. Click Payment or similar action
  3. Enter payment amount and method
  4. Update payment status
  5. Generate receipt if needed

Invoice Settings Configuration

Accessing Invoice Settings

From the sales management section, access settings via gear icon or Settings menu.

Sales Settings Figure 4: Invoice numbering and configuration settings

Configurable Settings:

Invoice Numbering:

  • Sales Prefix*: Custom prefix for invoice numbers (default: HBL)
  • Start Number*: Beginning sequence number (required)
  • Last Used Number: System tracks last generated number
  • Next Sales Number: Preview of next auto-generated number

Terms and Conditions:

  • Default Terms: Standard terms for all invoices
  • Payment Terms: Default payment conditions (Net 30, Due on receipt, etc.)
  • Return Policy: Standard return conditions

Tax Configuration:

  • Default Tax Rate: Standard tax rate for items
  • Tax Calculations: Configure tax inclusion/exclusion
  • Tax Identification: Company tax details

Display Settings:

  • Invoice Template: Select invoice layout and design
  • Company Logo: Upload logo for invoice header
  • Footer Text: Custom footer text

Saving Settings:

  • Click Save Settings to apply changes
  • Use Cancel to discard modifications
  • Settings affect all future invoices

Sales Invoice Workflow

Complete Sales Process:

1. Preparation Stage:

  • Ensure customer exists in system
  • Verify product availability
  • Check pricing and discounts

2. Invoice Creation:

  • Select customer
  • Add items with quantities and prices
  • Apply discounts if applicable
  • Calculate taxes

3. Payment Processing:

  • Record payment method
  • Enter amount paid
  • Generate payment receipt
  • Update inventory stock

4. Documentation:

  • Print or email invoice
  • File copy for records
  • Update customer account

5. Post-Sale:

  • Track outstanding payments
  • Send payment reminders
  • Handle returns if needed
  • Update sales reports

Types of Sales Transactions

1. Cash Sales

  • Immediate payment received
  • Inventory updates immediately
  • Simple transaction flow

2. Credit Sales

  • Payment deferred to future date
  • Customer account charged
  • Payment terms apply

3. Partial Payment Sales

  • Some amount paid at time of sale
  • Balance recorded as receivable
  • Follow-up required for balance

4. Proforma Invoices

  • Preliminary invoices for quotation
  • No inventory impact
  • Can convert to actual invoice

Best Practices for Invoice Management

Creating Accurate Invoices:

  1. Complete Customer Information: Ensure all customer details are correct
  2. Accurate Item Selection: Double-check products and quantities
  3. Correct Pricing: Verify selling prices and discounts
  4. Tax Compliance: Ensure proper tax calculations
  5. Clear Terms: State payment terms clearly

Payment Management:

  1. Immediate Recording: Record payments as soon as received
  2. Receipt Issuance: Provide receipts for all payments
  3. Outstanding Tracking: Monitor unpaid invoices regularly
  4. Payment Reminders: Send timely payment reminders

Customer Communication:

  1. Prompt Invoicing: Send invoices immediately after sale
  2. Clear Documentation: Ensure invoices are easy to understand
  3. Professional Format: Use professional invoice templates
  4. Multiple Channels: Offer print and electronic options

Record Keeping:

  1. Organized Filing: Maintain organized invoice records
  2. Backup Systems: Keep digital and physical backups
  3. Audit Trail: Maintain complete transaction history
  4. Regular Reconciliation: Reconcile sales with bank deposits

Integration with Other Modules

Customer Management:

  • Sales History: Tracks all transactions with each customer
  • Credit Limits: Monitors customer credit utilization
  • Payment Patterns: Analyzes customer payment behavior

Inventory Management:

  • Stock Reduction: Inventory automatically decreases on sale
  • Stock Alerts: Can trigger low stock warnings
  • Sales Analysis: Identifies fast-moving vs. slow-moving items

Financial Accounting:

  • Revenue Recording: Sales recorded as income
  • Receivable Tracking: Monitors outstanding customer balances
  • Tax Reporting: Captures output tax liabilities

Reporting and Analytics:

  • Sales Reports: Daily, weekly, monthly sales summaries
  • Customer Analysis: Sales by customer category
  • Product Performance: Best-selling items analysis
  • Payment Collection: Collection efficiency metrics

Common Scenarios and Solutions

Scenario 1: Partial Delivery

Solution:

  1. Create invoice for delivered items only
  2. Note pending items for future delivery
  3. Create separate invoice when remaining items delivered

Scenario 2: Price Negotiation After Sale

Solution:

  1. Create credit note for price difference
  2. Or issue refund if already paid
  3. Document reason for adjustment

Scenario 3: Customer Requests Proforma

Solution:

  1. Create proforma invoice with estimated amounts
  2. Mark clearly as "Proforma" or "Quotation"
  3. Convert to actual invoice when order confirmed

Scenario 4: Bulk Order with Discount

Solution:

  1. Apply percentage discount to entire invoice
  2. Or apply fixed amount discount
  3. Ensure discount calculation is clear on invoice

Scenario 5: Tax-Exempt Customer

Solution:

  1. Verify customer tax exemption certificate
  2. Set tax rate to 0% for that customer
  3. Document exemption details

Reports and Analytics

Available Sales Reports:

  1. Sales Summary: Total sales by period
  2. Outstanding Invoices: All unpaid invoices aging report
  3. Customer Statements: Detailed statements per customer
  4. Product Sales: Sales performance by product
  5. Tax Reports: Sales tax collected and payable
  6. Collection Efficiency: Payment collection performance

Key Metrics to Monitor:

  • Days Sales Outstanding (DSO): Average collection period
  • Sales Growth: Month-over-month sales increase
  • Collection Rate: Percentage of invoices paid on time
  • Average Invoice Value: Average sale amount
  • Customer Retention: Repeat customer sales