Sales Reports
Customer Balance Letter
OverviewUser can generate this letter to present a clear statement of what the customer owes. This is particularly useful for periodic audits or before initiating debt recovery. Since the system allows for flexible layouts, the user can create and use their own customized templates to match the company's branding and communication style.
The report typically includes the following key details:
- Customer Details: Name and address of the customer for whom the balance is being confirmed.
- Reference & Date: The specific tracking number and the date the letter was generated.
- Outstanding Balance: A clearly stated total amount that remains unpaid in the system as of the report date.
- Transaction Summary: A breakdown of invoices and payments that contribute to the final balance.
To generate this letter, user should navigate to Reports > Sales > Editor. On the Editor page, user must select Customer Balance Letter from the available report options. From the filter panel, user can then select the specific customer and the desired template. Once the filters are applied, clicking the Print button will generate the letter.
Sales Summary Item Detailed
OverviewThis report is designed to give the user visibility into what was sold, to whom, and whether the transaction has been settled. It combines high-level summary data with granular item-level information, making it easier to analyze product movement and cash flow.
To access this report, user should navigate to Reports > Sales > Sales Summary Item Detailed. Using the filter panel on the right side of the page, user can specify the Date Range and other parameters to pull the required records.
- Date Range: User can select a specific start and end date to define the reporting period.
- Customer: User can filter the report for a specific customer or select "All Customers" to see a complete list.
- Customer Branch: If a customer has multiple branches, user can filter by a specific location or select "All branches."
- Sales Areas & Sales Folk: User can apply filters based on specific geographical areas or individual salespersons to track localized performance.
- Currency Filter: User can choose to view the report in the "Home Currency" or other available currency options.
- Suppress Zeros: User can select "Yes" to hide rows with zero values, making the report cleaner and easier to read.
- Comments: User can add specific notes in the Comment field which will be printed on the final document.
- Destination: User can choose the output format by selecting PDF or Excel from the destination dropdown before printing.
The generated report typically displays the following information for detailed tracking:
- Invoice Reference: The unique ID for each sales transaction.
- Customer Name: The specific customer involved in the sale.
- Item Details: A breakdown of individual products, including quantities and rates.
- Paid and Unpaid Status: A clear display of the amount received versus the balance remaining for each entry.
- Total Amount: The final value of the transaction including taxes.
General Sales Report
OverviewThis report allows the user to monitor the flow of funds for each customer by detailing specific debit and credit entries. It is an essential tool for reconciling customer accounts and understanding the net position of receivables at any given time.
To access this report, user should navigate to Reports > Sales > General Sales Report. Using the filter panel on the right side of the page, user can define the reporting period and specific customer parameters before clicking the Print button.
- Date: User can select a specific date range to filter the financial transactions for that period.
- Customer: User can filter the report for a single customer or view "All Customers".
- Our Branch & Department: These filters allow the user to narrow down the data based on specific business units or internal departments.
- Sales Areas: User can filter by geographical regions to analyze customer balances by area.
- Payment Terms: Allows the user to filter transactions based on the agreed-upon payment conditions.
- Currency Filter: User can toggle between the "Home Currency" or specific foreign currencies.
- Suppress Zeros: Setting this to "Yes" hides accounts with no activity or a zero balance for a cleaner report.
- Comments: Any text entered in this field will be included in the generated PDF or Excel document.
- Destination: User can select the desired output format, such as PDF/Printer or Excel.
The generated report includes the following columns for clear financial tracking:
- Customer Name: Identifies the customer for each set of transactions.
- Sale Area: Shows the assigned region for the customer.
- Currency: The currency in which the transactions are recorded.
- Debit: Reflects the total value of invoices or charges issued to the customer.
- Credit: Reflects the total payments or deposits received from the customer.
- Customer Balance: The calculated net balance (Debit minus Credit) for the customer.
Customer Balance with Last Transactions
OverviewThe Customer Balance with Last Transactions report is a professional document designed to provide a snapshot of a customer's current outstanding balance alongside their most recent transaction history. It allows the user to quickly verify the latest account movements and the final net balance recorded in the system.
To access this report, user should navigate to Reports > Sales > Customer Balance with Last Transactions. Using the filter panel on the right side of the page, user can define the specific customer and the date range before clicking the Print button to generate the report.
- Date Range: User can select the start and end dates to define the period for the last transactions.
- Customer: User can filter the report for a specific customer or select "All Customers" to see a complete list.
- Destination: User can choose the output format by selecting PDF or Excel from the destination dropdown before printing.
The generated report typically displays the following information for clear financial tracking:
- Date: The specific date of the last recorded transactions or payments.
- Reference: The unique identification number for the most recent sales invoices or credit entries.
- Debit: Reflects the total value of invoices or charges issued to the customer in the recent period.
- Credit: Reflects the total payments or deposits received from the customer during that time.
- Customer Balance: The final calculated net balance currently outstanding for the customer.
Customer Branch Balances
OverviewThe Customer Branch Balances report is designed to provide a clear financial breakdown of customer accounts specifically organized by branch. It allows the user to monitor the debit and credit activities of various customer branches, showing how individual branch transactions contribute to the overall customer balance.
To access this report, user should navigate to Reports > Sales > Customer Branch Balances. Using the filter panel on the right side of the page, user can specify the reporting period, customer, and branch parameters before clicking the Print button.
- Date: User can select the specific date range to capture branch-wise transactions for a defined period.
- Customer: User can filter the report for a specific customer or select "All Customers" to view branch balances across the entire client base.
- Customer Branch: User can narrow down the results to a specific branch or select "All branches" for a consolidated view.
- Show Branch Wise: User can choose to enable or disable the branch-level grouping for more granular reporting.
- Currency Filter: User can define the reporting currency, such as "Home Currency," to ensure financial accuracy.
- Suppress Zeros: User can select "Yes" to hide branches with zero balances, making the report easier to read.
The generated report, titled "Customer Balance Branch Based," typically displays the following columns for detailed tracking:
- Customer Name: Displays the main customer and the individual branches associated with their account.
- Open Balance: The balance carried forward for each branch from the start of the period.
- Debit: Reflects the total value of charges or invoices issued to the specific branch.
- Credit: Reflects the total payments or deposits received from the specific branch.
- Outstanding: The final calculated net balance for each branch after accounting for all movements.
Customer Balances Transaction
OverviewThe Customer Balances Transaction report provides a detailed view of outstanding balances by tracking received payments against specific transactions. It helps the user identify the remaining balance for each entry, ensuring accurate monitoring of what has been paid and what is left to be settled.
To access this report, user should navigate to Reports > Sales > Customer Balances Transaction. Using the filter panel on the right side of the page, user can set the necessary parameters and click the Print button to generate the data.
- Date: User can select the start and end dates to filter transactions within a specific timeframe.
- Customer: User can filter by a specific customer or view balances for "All Customers."
- Our Branch: User can apply a filter based on the internal company branch associated with the sales.
- Sales Areas & Sales Man: User can narrow the report down to specific geographical areas or individual sales personnel.
- Show Balance: User can toggle this option to customize how the balance figures are presented.
- Orientation & Destination: User can choose between Portrait or Landscape and set the output to PDF or Excel.
The generated report, titled "Customer Balances Transaction Based," displays the following columns for in-depth analysis:
- Trans Type: Indicates the type of transaction, such as an invoice or payment.
- Customer Ref #: The unique reference number associated with the customer's transaction.
- Date & Due Date: Displays when the transaction occurred and the date by which payment is expected.
- Debits: The total amount charged to the customer for the transaction.
- Credits: The total payments or credits applied to the account.
- Allocated: The portion of payments that has been specifically linked to an invoice.
- Outstanding: The remaining amount left to be paid for that specific entry.
Customer Balances - Item Detailed
OverviewThe Customer Balances - Item Detailed report offers an enhanced view of customer balances by providing granular details at the item and tax levels. This report allows the user to gain better insights into financial records by linking specific product quantities and rates directly to the outstanding balance calculations.
To access this report, user should navigate to Reports > Sales > Customer Balances - Item Detailed. Using the filter panel on the right side of the page, user can specify the required reporting parameters and click the Print button to generate the detailed statement.
- Date: User can define the specific start and end dates for the reporting period.
- Customer: User can filter for a specific customer or select "All Customers" to see a comprehensive detailed list.
- Location: User can filter the report based on specific warehouse or inventory locations.
- Sales Areas & Sales Man: User can narrow the results by geographical zones or specific sales personnel to track performance and balances.
- Suppress Zeros: User can choose to hide entries with zero balances to maintain a clean report view.
- Orientation & Destination: User can select Portrait or Landscape orientation and choose PDF or Excel as the final output.
The generated report provides the following columns for high-precision financial and item tracking:
- Ref: The unique reference number for the transaction (e.g., Invoice or Payment number).
- Date/Narration: The date of the entry along with a brief description or transaction type.
- Rate & Qty: Displays the unit price and the number of items involved in the specific transaction.
- Disc: Shows any discounts applied to the line items.
- Total: The gross total for the line items before debit/credit adjustments.
- Dr (Debit): The amount charged to the customer account.
- Cr (Credit): The amount credited to the customer account (e.g., payments received).
- Balance: The running net balance for the customer as of that specific entry.
Aged Customer Analysis
OverviewThe Aged Customer Analysis report is a critical financial tool used to monitor and manage accounts receivable by categorizing outstanding balances based on how long they have remained unpaid. This report provides a date-level classified view of over-due payments and paid transactions, allowing the user to assess credit risk and prioritize collection efforts effectively.
To access this report, user should navigate to Reports > Sales > Aged Customer Analysis. On the filter panel located on the right side of the page, user can set the analysis parameters and click the Print button to generate the report. Detailed Filter Options
- End Date: User can specify the cutoff date to calculate the age of outstanding balances as of that specific day.
- Customer & Branch: User can filter the analysis for a single customer and specific branch, or view a consolidated list for the entire organization.
- Sales Group & Department: User can narrow the results down to specific internal teams or departments for targeted financial tracking.
- Show Also Allocated: User can toggle this option to include or exclude payments that have already been matched with invoices.
- Summary Only: User can select "Yes" for a high-level overview or "No" to see every individual transaction contributing to the aged balance.
- Analysis Based on: User can choose to age the balances based on the Due Date or the Invoice Date.
- Graphics: User can choose to include visual charts to represent the aging data by selecting the available graphics options.
- Orientation & Destination: User can select Landscape (recommended for multiple columns) and set the output to PDF or Excel.
The generated report displays a detailed table with the following aging buckets and transaction information:
- Transaction Details: Lists the type (Sales Invoice, Credit Note, Payment), reference number, and date for each entry.
- Current: Displays balances that are not yet past their due date.
- 1-30 Days: Balances that are overdue by up to one month.
- 31-60 Days: Balances that have remained unpaid for one to two months past the due date.
- Over 60 Days: Long-term outstanding amounts that require immediate attention.
- Total Balance: The cumulative net amount owed by the customer across all aging periods.
Customer Outstanding Summary Report
OverviewThe Customer Outstanding Summary Report provides a high-level financial overview of customer balances and overall transaction totals. It condenses complex transaction data into a summarized format, allowing the user to quickly see opening balances, total sales, returns, and net outstanding amounts for each customer.
To access this report, user should navigate to Reports > Sales > Customer Outstanding Summary Report. Using the filter panel on the right side of the page, user can define the reporting period and specific customer parameters before clicking the Print button.
- Date: User can select the start and end dates to define the summarized reporting period.
- Customer: User can filter for a specific customer or select "All Customers" to generate a complete summary list.
- Customer Branch & Our Branch: User can narrow the results by specific customer branches or internal company branches.
- Sales Areas & Sales Man: User can filter the summary based on geographical regions or specific sales personnel.
- Currency Filter: User can choose to view the balances in the "Home Currency" or other configured options.
- Suppress Zeros: User can select "Yes" to exclude customers with no outstanding balance from the report.
- Orientation & Destination: User can select Landscape for better visibility of columns and set the output to PDF or Excel.
The generated report displays the following summarized columns for each customer:
- Customer Name: The name of the customer account being summarized.
- Opening: The outstanding balance brought forward from before the selected start date.
- Sales Invoices: The total value of all sales invoices issued during the selected period.
- Sales Return: The total value of credit notes or items returned by the customer.
- Debit: Reflects other debit adjustments or charges applied to the account.
- Credit: Reflects total payments received or other credit adjustments.
- Balance: The final net outstanding amount calculated for the customer as of the end date.
Customer Receipts
OverviewThe Customer Receipts report provides a detailed listing of payments received from each customer, along with specific information regarding payment allocations to invoices. It allows the user to track exactly how much has been paid, which invoices the payments were applied to, and any unallocated balances remaining on the receipts.
To access this report, user should navigate to Reports > Sales > Customer Receipts. Using the filter panel on the right side of the page, user can select the desired date range and customer parameters before clicking the Print button. Detailed Filter Options
- Date: User can define the start and end dates to capture all receipts recorded within that period.
- Customer: User can filter the report for a single customer or select "All Customers" for a broad payment overview.
- Sales Areas & Sales Man: User can filter receipts based on specific regions or the sales personnel responsible for the accounts.
- Summary Only: User can select "Yes" for a high-level total or "No" to see every individual receipt and allocation detail.
- Suppress Zeros: User can hide entries with zero amounts to keep the report concise.
- Orientation & Destination: User can select Portrait or Landscape and choose between PDF or Excel output.
The generated report displays the following columns for comprehensive payment tracking:
- Payment Ref & Date: The unique identification number for the receipt and the date it was issued.
- Amount: The total value of the payment received from the customer.
- Allocated: The portion of the payment that has been applied to specific sales invoices.
- Balance: The remaining amount of the receipt that has not yet been allocated to an invoice.
- Memo: Any internal notes or references recorded alongside the payment.
- Invoice Ref & Date: Details of the specific invoice(s) that were settled by this receipt.
- Inv Amount: The total amount of the associated invoice being paid.
Customer Sales History
OverviewThe Customer Sales History report is a monthly performance tracking tool that classifies sales data to help the user identify peak sales periods and customer purchasing trends. It provides a month-by-month breakdown of sales values for each customer, facilitating a clear comparison of performance throughout the financial year.
To access this report, user should navigate to Reports > Sales > Customer Sales History. Using the filter panel on the right side of the page, user can select the financial year and customer criteria before clicking the Print button to generate the history.
- Year: User can select the specific financial year to pull the monthly sales data records.
- Customer: User can filter the report for a specific customer or select "All Customers" to see a comparative list.
- Customer Branch: User can filter the sales history based on specific branches associated with the customer.
- Sales Areas & Sales Man: User can narrow down the performance data by geographical zones or individual sales personnel.
- Currency Filter: User can view the values in "Indian Rupee (INR)" or other configured local currencies.
- Destination: User can choose the output format, such as PDF or Excel, for reporting purposes.
The generated report displays a horizontal monthly grid with the following columns for detailed performance tracking:
- SNo & Customer Name: The serial number and the name of the customer account being analyzed.
- Monthly Columns (Apr - Mar): A column for each month of the financial year showing the total sales value recorded in that period.
- Total: The cumulative sales value for the entire selected financial year for each customer.
- Grand Total: The sum of all customer sales for each month and the final total for the entire period.
Salesman Recovery - Summary
OverviewThe Salesman Recovery - Summary report is a specialized tracking tool designed to monitor the efficiency of payment collections based on individual salesman performance. It provides a concise summary of total sales made and the corresponding payments recovered from customers, helping the user identify outstanding balances that are yet to be recovered by each sales representative.
To access this report, user should navigate to Reports > Sales > Salesman Recovery - Summary. From the filter panel on the right, user can select the relevant period and salesman filters before clicking the Print button. Detailed Filter Options
- Date: User can specify the date range to analyze sales and recovery activities within a particular date range.
- Sales Man: User can filter the report for a specific "Sales Folk" or select "No Sales Folk Filter" to view a combined recovery summary for the entire team.
- Our Branch: User can narrow the results based on internal company branches.
- Currency Filter: User can choose to display the financial figures in the "Home Currency" for consistent accounting.
- Suppress Zeros: User can select "Yes" to hide customers or salesmen with no active sales or recovery amounts during the period.
- Orientation & Destination: User can set the report to Portrait or Landscape and export it as a PDF or Excel file.
The generated report, titled "Salesman Recovery Report - Summary," lists each customer under their respective sales representative with the following columns:
- Customer Name: Lists the individual customer accounts assigned to the salesman.
- Sales: Displays the total value of sales invoices generated for the customer during the period.
- Payment Received: Reflects the total amount successfully collected and recorded for those transactions.
- Balance: Shows the remaining amount yet to be recovered from the customer.
- Grand Total: Provides a final sum of all Sales, Payments Received, and net Balances across the entire filtered list.
Customer Trial Balance
OverviewThe Customer Trial Balance report provides a specialized financial snapshot of the accounts receivable ledger at a specific point in time. It serves as a verification tool for the user to ensure that the total of all individual customer debit and credit balances is accurately reflected in the system's accounting records.
To access this report, user should navigate to Reports > Sales > Customer Trial Balance. From the filter panel, user can define the reporting date and customer parameters before clicking the Print button to generate the balance statement. Detailed Filter Options
- Date: User can specify the exact date to view the trial balance as of that moment.
- Customer: User can filter for a specific customer or select "All Customers" for a full ledger view.
- Customer Branch: User can narrow the trial balance data by specific customer branches.
- Sales Areas & Sales Man: User can filter results based on geographical regions or assigned sales personnel.
- Currency Filter: User can choose to display balances in the "Home Currency" or other configured local currencies.
- Suppress Zeros: User can hide customers with zero total balances to keep the report focused on active accounts.
- Orientation & Destination: User can select Portrait or Landscape and export the file as PDF or Excel.
The generated report displays the following columns for clear financial reconciliation:
- Customer Name: The name of the customer account being listed.
- Debit: The total outstanding amount owed by the customer.
- Credit: The total payments or credit adjustments recorded for the customer.
- Balance: The net difference between debits and credits for each account.
- Grand Total: The final sum of all debits, credits, and net balances across the entire filtered customer list.
Customer Detail Listing
OverviewThe Customer Detail Listing report serves as a comprehensive directory that provides a complete profile of all customers registered in the system. It is used by the user to verify contact information, tax registration details, and credit settings, ensuring that the customer master data is accurate and up to date.
To access this report, user should navigate to Reports > Sales > Customer Detail Listing. Using the filter panel on the right side of the page, user can select the specific customer criteria and click the Print button to generate the list. Detailed Filter Options
- Customer: User can filter for a specific customer or select "All Customers" to generate a full master list.
- Customer Branch: User can narrow the listing down to specific branches to view localized contact data.
- Sales Areas & Sales Man: User can filter the directory by geographical regions or the specific sales personnel assigned to the accounts.
- Orientation & Destination: User can choose between Portrait or Landscape and set the output to PDF or Excel.
The generated report provides the following detailed information for each customer entry:
- Customer/Branch: Displays the primary customer name and the associated branch name.
- Contact Details: Includes the registered physical address, phone numbers, and email addresses for communication.
- Tax/GST Details: Lists the Tax Group and the GST number (if applicable) for tax compliance verification.
- Sales Settings: Shows the assigned Sales Man and the specific Sales Area for the customer.
- Credit & Terms: Displays the approved Credit Limit and the Payment Terms (e.g., 15th of the following month) assigned to the account.
- Currency: The default transaction currency used for the customer's account.
Sales Order Summary
OverviewThe Sales Order Summary report provides a status tracking overview of all sales orders recorded in the system. It helps the user monitor the progress of orders by identifying which are still outstanding, partially completed, or fully processed, ensuring that no customer request is overlooked in the fulfillment pipeline. How to Access and Generate
To access this report, user should navigate to Reports > Sales > Sales Order Summary. Using the filter panel on the right side of the page, user can define the specific order criteria and click the Print button to generate the summary data. Detailed Filter Options
- Date: User can select the start and end dates to filter orders created within a specific timeframe.
- Customer: User can filter for a specific customer or select "All Customers" to see all active orders.
- Location: User can filter by the specific warehouse or stock location from which the items are expected to be shipped.
- Stock Item: User can narrow the report to show only orders containing a specific product.
- Category: User can filter orders based on item categories for a more organized view.
- Orientation & Destination: User can select Portrait or Landscape and export the final report as PDF or Excel.
The generated report displays the following columns to help the user trace non-completed orders:
- Order #: The unique identification number assigned to the sales order.
- Customer: The name of the customer who placed the order.
- Branch: The specific customer branch associated with the delivery.
- Cust Order Ref: The reference number provided by the customer (e.g., their Purchase Order number).
- Ord Date: The date the sales order was officially recorded in the system.
- Delivery To: The specific location or warehouse designated for the shipment.
- Order Total: The total monetary value of the items listed in the sales order.
Sales Quotes Summary
OverviewThe Sales Quotes Summary report provides a detailed tracking mechanism for all quotations issued to customers. It allows the user to monitor the status of pending proposals, helping the sales team follow up on open quotes and trace those that have not yet been converted into active sales orders.
To access this report, user should navigate to Reports > Sales > Sales Quotes Summary. Using the filter panel on the right side of the page, user can specify the required date range and customer filters before clicking the Print button. Detailed Filter Options
- Date: User can select the start and end dates to filter quotations generated within a specific period.
- Customer: User can filter the report for a specific customer or select "All Customers" for a global view of all proposals.
- Location: User can filter quotes based on the specific inventory or business location associated with the offer.
- Stock Item & Category: User can narrow the summary to show only quotes containing specific items or product categories.
- Orientation & Destination: User can choose between Portrait or Landscape and export the summary as a PDF or Excel file.
The generated report displays the following key columns for tracing non-completed orders and proposals:
- Quote #: The unique reference number assigned to the sales quotation.
- Customer: The name of the customer for whom the quote was prepared.
- Branch: The specific customer branch linked to the quotation.
- Cust Order Ref: Any external reference provided by the customer during the inquiry phase.
- Quote Date: The date on which the quotation was officially issued.
- Delivery To: The intended delivery location specified in the proposal.
- Quote Total: The total estimated value of the goods or services quoted.
Sales Return Summary
OverviewThe Sales Return Summary report provides an organized overview of all credit notes and sales returns processed within the system. It helps the user monitor the frequency and value of returned goods, allowing for better analysis of product quality, customer satisfaction, and the resulting financial adjustments to customer accounts.
To access this report, user should navigate to Reports > Sales > Sales Return Summary. Using the filter panel on the right side of the page, user can define the specific return criteria and click the Print button to generate the summary. Detailed Filter Options
- Date: User can select the start and end dates to filter returns recorded within a specific timeframe.
- Customer: User can filter for a specific customer or select "All Customers" to view all return transactions.
- Location: User can filter the report based on the specific warehouse or inventory location where the returned goods were received.
- Stock Item & Category: User can narrow the summary to show returns for specific products or entire item categories.
- Orientation & Destination: User can select Portrait or Landscape and export the report as a PDF or Excel file.
The generated report displays the following key columns for tracking sales returns and credits:
- Return #: The unique identification number assigned to the sales return or credit note.
- Customer: The name of the customer who returned the items.
- Branch: The specific customer branch associated with the return transaction.
- Return Date: The date on which the return was officially recorded in the system.
- Delivery To: The warehouse location that received the returned stock.
- Return Total: The total monetary value of the goods returned and credited to the customer.
Salesman Listing
OverviewThe Salesman Listing report is a performance tracking tool used to evaluate the effectiveness of each salesperson within the organization. It provides a detailed breakdown of the performance of each salesman and their sales ranges per person, allowing the user to identify top performers and analyze sales distribution across the team.
To access this report, user should navigate to Reports > Sales > Salesman Listing. Using the filter panel on the right side of the page, user can define the specific period and branch parameters before clicking the Print button to generate the list. Detailed Filter Options
- Date: User can select the start and end dates to define the performance evaluation period.
- Our Branch: User can filter the results by internal company branches to see localized sales team performance.
- Currency Filter: User can choose to view the sales figures in the "Home Currency" for standard reporting.
- Orientation & Destination: User can select Portrait or Landscape and choose between PDF or Excel output formats.
The generated report displays the following columns to provide a clear view of sales contribution:
- Salesman Name: The name of the sales representative being tracked.
- Total Sales: The cumulative value of all sales invoices generated by the salesman during the selected period.
- Sales Percentage (%): Displays the salesman's contribution as a percentage of the total company sales for the period.
- Transaction Count: The total number of individual sales transactions handled by the person.
- Average Sale Value: A calculated field showing the average value per transaction for that specific salesman.
Sales Summary Report
OverviewThe Sales Summary Report provides a high-level financial consolidation of sales activities, offering a summary of sales along with tax dividend and earnings classified for a specific period. This report is essential for the user to understand the net revenue generated after accounting for various tax components and discounts, ensuring a clear view of the actual earnings from sales operations.
To access this report, user should navigate to Reports > Sales > Sales Summary Report. Using the filter panel on the right side of the page, user can define the reporting period and other parameters before clicking the Print button. Detailed Filter Options
- Date Range: User can select the start and end dates to capture the sales data for a specific financial window.
- Customer: User can filter for a specific customer or select "All Customers" for a total company sales summary.
- Our Branch: User can narrow down the summary to sales recorded by a specific internal branch.
- Currency Filter: User can choose to display values in the "Home Currency" to maintain consistency in financial reporting.
- Suppress Zeros: User can select "Yes" to exclude entries with no sales value, providing a more concise report.
- Orientation & Destination: User can choose Portrait or Landscape and export the summary as a PDF or Excel file.
The generated report categorizes financial data into the following columns for clear classification of earnings:
- Customer Name: The name of the customer associated with the summarized sales transactions.
- Total Sales: The gross value of all sales invoices issued during the period.
- Tax Details (e.g., GST, CGST, SGST): A breakdown of the different tax components applied to the sales.
- Discount: The total value of discounts provided to the customer on their purchases.
- Net Sales: The final earning value calculated as Total Sales minus Taxes and Discounts.
- Grand Total: The cumulative sum of all sales, taxes, and net earnings for the entire filtered list.
Sales Profitability Report
OverviewThe Sales Profitability Report is a high-level analytical tool that provides a summary of sales along with gross profit and earnings classified. It allows the user to evaluate the financial health of sales operations by comparing the cost of goods sold against the net sales value, helping to identify which customers or transactions are most profitable for the business.
To access this report, user should navigate to Reports > Sales > Sales Profitability Report. Using the filter panel on the right side of the page, user can define the reporting period and specific parameters before clicking the Print button. Detailed Filter Options
- Date Range: User can select the start and end dates to define the profitability analysis period.
- Customer: User can filter the report for a specific customer or select "All Customers" for a global profitability summary.
- Our Branch: User can narrow the results down to sales recorded by a specific internal company branch.
- Currency Filter: User can choose to display the figures in the "Home Currency" for accurate profit margin calculations.
- Suppress Zeros: User can select "Yes" to hide entries with no sales or profit data, keeping the report clean.
- Orientation & Destination: User can select Portrait or Landscape and export the final report as PDF or Excel.
The generated report categorizes transaction data into the following columns to provide a clear view of earnings:
- Customer Name: The name of the customer account associated with the sales and profit data.
- Net Sales: The total revenue generated from sales after deducting taxes and discounts.
- Cost: The total cost of the goods sold (COGS) for the items included in the sales.
- Gross Profit: The calculated earnings (Net Sales minus Cost) for each customer.
- GP Percentage (%): Displays the profit margin as a percentage, allowing the user to compare profitability across different accounts.
- Grand Total: Provides the cumulative Net Sales, Total Cost, and overall Gross Profit for the filtered period.
