Configuring Account Statement 


Account Statement in Receivables provides an overview of the customer's outstanding invoices and transactions for a duration. By generating account statement, you can view open invoices, credit notes, payments, and financial information of a customer. Receivables gives you an option to generate account statement for a customer in pdf or excel format for a specific time period. The account statement configuration allows you to manage the data columns including rearrangement of the columns, and configure additional properties of the statement such document type, date range, and more.

In Receivables, merchant/user can send account statement to the customer in the following ways:

  • Via Email Reminder
  • Via Self Serve Client Portal

Via Email Reminder

Receivables provide predefined template variables to generate the account statement directly from the email reminders. Use the template variables {{accountStatementLink}} and {{accountStatementPDFLink}} in the email template to generate Excel/CSV and PDF based statement. You can also set the date-range of account statement using the account statement configurations.

Via Self Serve Client Portal

A Self Serve Client portal comes with various features and components that allow customers to view and manage their individual invoices and account receivables data. Your customers can download their account statements (Excel/CSV, or PDF) for a specific time period.
To enable this feature, follow these steps:

  1. Click Settings > Configurations > Client Portal Settings page.

  2. In the Client Portal Settings page, enable the Allow Account Statement Download option to allow your customers to download the account statement.
    For more information, see client portal settings.

Configuring Account Statement Property 

The account statement properties allow customers to view additional details in their account statement. You can configure the following options to make the information available on the account statement.

  • Show Total: Enable this option to show the total of Amount and Balance columns in the account statement.
  • Show Only Customer Currency: Enable this option to show invoices/transactions in customer's currency only. If there are invoices in multiple currency, then enabling this option will show invoices that have customer's default currency.

To configure the account statement property, follow these steps:

  1. Login to your Receivables account.
  2. Click Settings > Configuration > Account Statement.
  3. Under the Configuration section, toggle on/off the account statement properties.

Managing Data columns of Account Statement 

For a downloadable account statement (Excel/CSV or PDF), you can insert, delete, and rearrange the columns as required.

You can perform the following operations to manage the data columns of account statement:

  • Rearrange Columns: To rearrange the data columns of the account statement, click and drag the columns to a specific position. The other columns will automatically adjust their positions and appear in the account statement accordingly.
  • Manage Columns: This allows you to manage and view the required columns in an account statement. This is beneficial if you want to keep track of a certain type of information or if you need to hide a specific column from the statement.

To manage the data column of the account statement, follow these steps:

  1. Login to Receivables.
  2. Click Settings > Configuration > Account Statement.
  3. On the Account Statement tab, in a specific account statement(Excel/CSV, or PDF) click Manage Columns. For the PDF statement, you can select maximum of seven columns due to the space constraint in PDF.
  4. In the Select Columns page, select the columns that you want to show or hide in the account statement.
  5. Click Update.

Configuring additional properties of Account Statement 

An account statement can have additional columns such as document type, document status, and so on. With account statement configuration, you can configure the properties of additional data columns that are explicitly included in the account statement.

To configure the additional data properties for the account statement, follow these steps:

  1. Click Settings > Configuration > Account Statement.

  2. In the Account Statement tab, select the properties (in any order) and specify the details for it:

    • Document Type: Select the checkboxes for document type that you want to show in the account statement. You can select the document type such invoice, debit note, credit note, and payments.
    • Status: Select the status as open, closed, and all for the document type.
    • Data Range: Select the date range based on which you want to display data in a particular document.
    • Sort By: You can sort data for account statement based on specific criteria, such as document date, due date, amount, and balance.

The changes will be saved automatically after configuring the account statement properties.

Was this article helpful?