Exporting files

The export of files is particularly useful during the preparation stages of invoicing. It allows for quick verification of the consistency of an invoicing set, for example, after pre-production invoicing and before launching the final invoicing.

The export is in the form of an Excel file, presenting the following information:

  • Company name, contact person’s first and last name, and company contact details.
  • File number and its status.
  • Recurring amount excluding taxes.
  • Number of invoices issued for the file.
  • Total amount including all taxes for all invoices.
  • Amount including all taxes for the penultimate invoice.
  • Amount including all taxes for the last invoice, as well as the net amount to be paid.
  • Payment method.
  • IBAN and BIC of the account from which the direct debit will be issued.

The amounts are presented including taxes because this export is part of the invoicing preparation logic and the submission of payment deadlines to the bank.

Exporting recurring charges

As a reseller of telephony solutions, it is important for you to know which services may be causing you losses and which ones are profitable. The recurring export addresses this need by providing a detailed breakdown, service by service, for the last invoiced month. It includes:

  • Invoiced reference
  • Description
  • Purchase prices for the service and usage, along with the total
  • Selling prices for the service and usage, along with the total
  • Margin achieved on the service, usage, and overall
  • A “tracking code” to indicate whether or not corrections are needed in case of anomalies. For example, you may intentionally maintain a deficit situation for a service (e.g., as a commercial gesture).

The export of recurring charges also includes the name of the sales representative responsible for the file, allowing the relevant person to take corrective measures if necessary.

Find out about all BlueRockTEL features.

Photo by Campaign Creators on Unsplash.