Customer ledger reports - overview

With the wide variety of reports available for the Customer ledger workspace, you can promptly get vital information, analyse financial data by various criteria, review transactions efficiently, and track data edits. Some reports have a standard version and a multi-currency version.

Because the Customer ledger workspace is tightly integrated with other workspaces, such as General ledger and Cash management, you can find and analyse the exact information you need. By using flexible selection options and data links, you can easily drill down from a financial report to any supporting details.

Because the Customer ledger reports are generated by user request, they run on only accounts and subaccounts that the user is authorised to access, based on the user's roles and membership in restriction groups.

The reports can be generated in multiple formats, including PDF and HTML.
Also, you can print the report you generated or send the report by email.

When you print a customer document and send it by email, the system will use the notification template set on the Mailing settings tab in the Customers (AR303000).

The Customer ledger workspace includes the following reports:

  • Aged past due (AR631000):
    Lists the customers with outstanding balances, which are broken down by days past due.
  • Aged past due (currency) (AR631100):
    Displays the customers with outstanding foreign currency balances.
    The balances are broken down by days past due.
  • Aged outstanding (AR631500):
    Shows the list of customers with outstanding balances, with balances arranged by days outstanding.
  • Aged outstanding (currency) (AR631600):
    Displays the list of customers with outstanding balances, with balances arranged by days outstanding.
    The foreign currency balances and amounts are shown in their original currency.
  • Aged period sensitive (AR630500):
    Displays the list of customers with outstanding balances.
    The balances are arranged by days past due on the last day of the specified period.
  • Balance by customer (AR632500):
    Displays the outstanding balances of the selected customer (or all customers) during the chosen period.
    For each customer, documents are grouped by account and subaccount pair and listed by their reference numbers.
    All the amounts are shown in the base currency.
  • Balance by customer (currency) (AR633000):
    Displays the outstanding foreign currency balances of the selected customer (or all customers) during the chosen period.
  • Balance by general ledger account (AR632000):
    Displays the balances of the customer ledger accounts and activities on the accounts for the chosen period.
    Documents are grouped by account and subaccount pair and listed by their reference numbers.
  • Daily sales profitability (AR676000):
    Displays the net sales amounts, costs, margins, and margin percentages calculated on the sales to each customer during the specified date range.
    The report in detailed format shows the profitability data for each day within the specified date range.
  • Sales profitability by salesperson and customer (AR673000):
    Shows the net sales amounts, costs, margins, and margin percentages calculated for the sales performed by particular salespersons during the specified date range.
    The report in detailed format shows the data broken down by customer.
  • Sales profitability by customer and order (AR672000):
    Shows the net sales amounts, costs, margins, and margin percentages on all sales to each customer during the specified date range. The report in detailed format shows the data broken down by sales order.
  • Sales profitability by customer class and customer (AR675000):
    Displays the net sales amounts, costs, margins, and margin percentages on all sales to customers of each customer class during the specified date range.
    In detailed format, this report shows the data broken down by sales to particular customers.
  • Sales profitability by item and order (AR671000):
    Displays the net sales amounts, costs, margins, and margin percentages for the items that were listed on the sales orders created in Visma.net ERP during the specified date range.
    The report in detailed format shows the data broken down by sales orders.
  • Sales profitability by customer class and customer (AR675000):
    Displays the net sales amounts, costs, margins, and margin percentages on all sales to customers of each customer class during the specified date range.
    In detailed format, this report shows the data broken down by sales to particular customers.
  • Sales profitability by item and order (AR671000):
    Displays the net sales amounts, costs, margins, and margin percentages for the items that were listed on the sales orders created in Visma.net ERP during the specified date range.
    The report in detailed format shows the data broken down by sales orders.
  • Sales profitability by item class and item (AR674000):
    Shows the net sales amounts, costs, margins, and margin percentages calculated on item class basis on the sales occurred during the specified date range.
    The report in detailed format shows the data broken down by stock items.