Sales Invoice Totals by Customer — Complete User Guide — Two Accounts Web

Comprehensive guide for generating, analysing, and understanding the Sales Invoice Totals by Customer report — per-customer sales totals grouped by currency across multiple comparative periods

Table of Contents

1. What Is the Sales Invoice Totals by Customer Report?
   • Purpose and Structure
2. Enabling from the Customize Menu
3. Field-by-Field Guide
   • Report Header Fields
   • Report Columns (Periods)
4. Settings Configuration
   • Customers
5. Creating a Sales Invoice Totals by Customer Report
6. How the Report Is Calculated
   • Transaction Reads
   • Transaction Types Included
   • Amount Calculation
   • Currency Grouping
   • Customer Sorting
   • Single Currency Flattening
7. Drill-Down Capabilities
8. Sample Data and Report Output
   • Sample Setup
   • Report Output
   • Verification of Calculation
9. Common Issues and Solutions
10. Accounting Regulation Compliance

1. What Is the Sales Invoice Totals by Customer Report?

The Sales Invoice Totals by Customer report shows total sales amounts (invoices, credit notes, and export LC receipts) grouped by customer, with separate columns for each comparative period. Customers are grouped by currency, and totals are shown for each period.

This report helps you analyse sales performance per customer across multiple periods — for example, comparing Q1 sales vs Q2 sales for each customer.

1.1 Purpose and Structure

The report shows for each customer:

• Total per period column — the net sales amount (invoices minus credit notes) for each period
• Currency grouping — customers are grouped by their transaction currency
• Sorted by highest total first — within each currency group, customers are sorted by their first period total descending

If all customers use the same currency, the currency group headings are hidden and a flat list with a total row is shown.

2. Enabling from the Customize Menu

The Sales Invoice Totals by Customer report appears under:

• Reports → Customers → Sales Invoice Totals by Customer

The report is only visible when the Customers tab is enabled in Customize Menu. No additional toggle is needed.

3. Field-by-Field Guide

3.1 Report Header Fields

Location: Reports → Customers → Sales Invoice Totals by Customer → New Report

3.2 Report Columns (Periods)

Each report can contain one or more period columns for comparative analysis.

4. Settings Configuration

4.1 Customers

Location: Settings → Customers

Each customer's name and code are used in the report. Customers without any sales invoices, credit notes, or export LC receipts in the selected period are not shown.

5. Creating a Sales Invoice Totals by Customer Report

1. Go to Reports → Customers → Sales Invoice Totals by Customer
2. Click New Report
3. Enter a Description (optional)
4. Add Periods:
   • Click Add to add a period column
   • Enter the From Date and To Date
   • Optionally enter a custom Column Name
   • Add additional periods for comparative analysis
5. Click Save
6. The report generates showing each customer's sales totals per period, grouped by currency

6. How the Report Is Calculated

6.1 Transaction Reads

The system reads all General Ledger transactions where the GL account is an Accounts Receivable account and the source transaction is a supported type. The amounts use the account currency amount — for foreign currency customers, amounts are shown in the customer's currency.

6.2 Transaction Types Included

6.3 Amount Calculation

Customer Total per Period = Sum of (account currency amount)
    for all AR transactions where:
    • Transaction type is Sales Invoice, Credit Note, or Export LC Receipt (with SI link)
    • Customer matches this customer
    • Date is between FromDate and ToDate

The amount is used as-is (no sign inversion). Sales Invoices produce positive amounts (debits to AR), Credit Notes produce negative amounts (credits to AR), and Export LC Receipts produce negative amounts (credits to AR via LC settlement).

6.4 Currency Grouping

Transactions are grouped by their account currency. The base currency group appears first, followed by foreign currency groups sorted alphabetically by currency code. Each currency group has a heading showing the currency code (e.g. "BDT", "USD").

6.5 Customer Sorting

Within each currency group, customers are sorted by their first period total in descending order (highest sales first). This highlights your top-performing customers automatically.

6.6 Single Currency Flattening

If all customers use the same currency (including base currency), the currency group headings are removed and the report shows a flat list with a total row at the bottom for a cleaner presentation.

7. Drill-Down Capabilities

Each customer total in any period column is clickable. Clicking any cell opens a transaction viewer showing the individual Sales Invoices, Credit Notes, and Export LC Receipts behind that customer's total for that period.

8. Sample Data and Report Output

8.1 Sample Setup

A trading company has three customers. The following sales transactions occurred during Q1 2026:

Customers

Sales Transactions

8.2 Report Output

Sales Invoice Totals by Customer
For the period: 1-Jan-2026 to 31-Mar-2026

                   Jan-2026     Feb-2026     Mar-2026       Total
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Customer A         333,500      115,000      575,000    1,023,500  ¹
Customer B         115,000       57,500      172,500      345,000  ²
Customer C               0      230,000      115,000      345,000  ³
                   ───────      ───────      ───────     ─────────
Total              448,500      402,500      862,500    1,713,500  ⁴

Notes:

1. Customer A: Jan = SI-001 345,000 − CN-001 11,500 = 333,500. Feb = SI-004 115,000. Mar = SI-006 575,000. Total = 1,023,500.
2. Customer B: Jan = SI-002 115,000. Feb = SI-005 57,500. Mar = SI-008 172,500. Total = 345,000.
3. Customer C: Jan = 0. Feb = SI-003 230,000. Mar = SI-007 115,000. Total = 345,000.
4. Grand Total: 333,500 + 115,000 + 0 = 448,500 in Jan. 115,000 + 57,500 + 230,000 = 402,500 in Feb. 575,000 + 172,500 + 115,000 = 862,500 in Mar. Total = 1,023,500 + 345,000 + 345,000 = 1,713,500.

8.3 Verification of Calculation

PER-CUSTOMER VERIFICATION:

  Customer A:
    SI-001:     345,000 (Jan)
    CN-001:    (11,500) (Jan)
    SI-004:     115,000 (Feb)
    SI-006:     575,000 (Mar)
    Total:      345,000 − 11,500 + 115,000 + 575,000 = 1,023,500 ✓

  Customer B:
    SI-002:     115,000 (Jan)
    SI-005:      57,500 (Feb)
    SI-008:     172,500 (Mar)
    Total:      115,000 + 57,500 + 172,500 = 345,000 ✓

  Customer C:
    SI-003:     230,000 (Feb)
    SI-007:     115,000 (Mar)
    Total:      230,000 + 115,000 = 345,000 ✓

PERIOD VERIFICATION:

  Jan:     333,500 + 115,000 + 0 = 448,500 ✓
  Feb:     115,000 + 57,500 + 230,000 = 402,500 ✓
  Mar:     575,000 + 172,500 + 115,000 = 862,500 ✓
  Total:   1,023,500 + 345,000 + 345,000 = 1,713,500 ✓

DR = CR (each transaction):
  SI-001:      Dr AR 345,000 / Cr Revenue 300,000 + Cr Tax 45,000 ✓
  CN-001:      Dr Revenue 10,000 + Dr Tax 1,500 / Cr AR 11,500 ✓
  SI-002:      Dr AR 115,000 / Cr Revenue 100,000 + Cr Tax 15,000 ✓
  SI-003:      Dr AR 230,000 / Cr Revenue 200,000 + Cr Tax 30,000 ✓
  SI-004:      Dr AR 115,000 / Cr Revenue 100,000 + Cr Tax 15,000 ✓
  SI-005:      Dr AR 57,500 / Cr Revenue 50,000 + Cr Tax 7,500 ✓
  SI-006:      Dr AR 575,000 / Cr Revenue 500,000 + Cr Tax 75,000 ✓
  SI-007:      Dr AR 115,000 / Cr Revenue 100,000 + Cr Tax 15,000 ✓
  SI-008:      Dr AR 172,500 / Cr Revenue 150,000 + Cr Tax 22,500 ✓

  Total AR change: 1,713,500 Dr ✓
  Report total: 1,713,500 ✓

9. Common Issues and Solutions

9.1 No Customers Appear

Cause: No customers have sales invoices, credit notes, or export LC receipts in the selected date range.

Solution: Broaden the date range. Verify that sales invoices exist for customers in the period.

9.2 Amounts Are Negative

Cause: Credit Notes or Export LC Receipts produce negative amounts (they reduce AR). If a customer had more credit notes than invoices in a period, the total will be negative.

Solution: This is correct — the report shows the net position. A negative total means more credits were issued than invoices raised in that period.

9.3 Amounts Show in Wrong Currency

Cause: The report uses the account currency amount from the GL transaction. If a customer's transactions are in a foreign currency, amounts are shown in that currency.

Solution: Each currency group shows amounts in that currency. The base currency group shows amounts in the business's base currency. Verify the customer's currency setting in Settings → Customers.

9.4 Customer Sorting Seems Random

Cause: Customers are sorted by their first period total in descending order. If the first period has no activity for a customer (zero total), the sort order may appear random.

Solution: Sort order is by first period column descending. Customers with higher sales in the first period appear first.

9.5 No Total Row

Cause: When multiple currencies are present, each currency group has its own subtotal but no grand total row is shown at the bottom. A total row only appears when all customers use the same currency.

Solution: This is correct. When multiple currencies are present, comparing totals across currencies is not meaningful. Each currency group shows its own subtotal.

10. Accounting Regulation Compliance

10.1 IFRS 15 — Revenue from Contracts with Customers

10.2 IFRS 8 — Operating Segments

10.3 DR = CR Verification

Sample Data Verification:

  Customer A: 1,023,500 ✓
  Customer B:   345,000 ✓
  Customer C:   345,000 ✓
  Grand Total: 1,713,500 ✓

  All transactions DR = CR ✓
  Report total matches GL AR increase ✓

End of Sales Invoice Totals by Customer Guide