Application / Statement Page

Support /Tutorials /Application /Statement Page /Statement Excel
 

Statement Excel

Download Statement Excel from the Statement Page

To download a Customer Statement in Excel format, go to the Customer Statement page and click Download Statement Excel from the show more menu.

Delete

Note

You cannot customize the design of the provided Excel statement, unlike the statement PDF. However, you can use several YayPay settings to adjust its content. For more information, see the Settings Affecting Statement Excel Content‍ section.

Download Statement Excel from the Customer Portal

On the Customer Portal, to download a Statement in Excel format, select the Excel option from the Download Statement PDF/Excel. Below, see the settings affecting the displayed data.

Statement Excel Components

The downloaded Excel file has the following components:

  • Your company name/address, customer's name/address
  • Statement date
  • Customer statement data (including invoice-level ERP custom fields configured in Settings | ERP/CRM Custom Fields with Display on Customer Portal enabled)
  • Totals
  • Currency
  • Invoice data by buckets
  • Disputed invoices (if any), indicated by an asterisk (*)
  • Custom text (if configured under Settings | Business)

  • Invoice level system custom fields, if configured in Settings | System Custom Fields | INVOICE LEVEL.

Note: the row number limit in the Excel file is 200k.

Delete

Note

For a parent company with child companies linked in YayPay (and provided that the consolidated mode* is enabled!), the table data will additionally include all invoice data for each child company. Also, an additional column Customer Name will appear.

*Note: to enable the consolidated mode, go to the Statement page of the parent company and enable Parent level collections in the SETTINGS tab:

Settings That Affect Statement Excel Content

Business settings (found under Settings > Business):

  • Customer Statement PDF - include other adjustments to balances

If enabled, the Other Adjustments data is included in the balances.

  • Customer Portal - Hide Invoice Due Date

If enabled, the Due Date column is hidden from the table.

  • Customer Portal - Show Customer’s ERP ID

If enabled, the Customer ERP ID column is displayed in the table.

  • Customer Statement PDF: Custom text 

If custom text is set up under this setting, it will appear in Statement Excel.

ERP/CRM Custom Fields

If the Display on Customer Portal option is enabled for invoice-level custom fields, those fields are displayed in Statement Excel.

Security Groups Settings

Users having restricted access to the Download Statement PDF function in Settings > Security Groups, cannot download Statement excel from the Statement page.

Hidden Invoices (set up under Settings > Hide Invoices)

In case some invoices are hidden, the calculation of totals and aging buckets in Statement Excel is done without them, i.e. they are excluded.

Attach Statement Excel to Manual Email Reminders

To attach the Statement Excel to a manual email reminder (e.g. from the Statement page/Aging report/Invoices/To-Do/Communications/etc.), in the Send Email modal click Attach Files and select Attach Customer Statement Excel and/or Attach Child Company Statement Excel(s) (provided that the consolidated mode is enabled, see above). 



Attach Statement Excel to Automatic Email Reminders

To attach Statement Excel to the email reminders sent automatically from Workflows/Global Rules, go to the rule setup and select Attach Customer Statement Excel and/or Attach Child Customer Statement Excel (provided that the consolidated mode is enabled, see above).


Can't find what you need?

Contact our support team support@yaypay.com for help.