Skip to main content

Editing CSV file of the bank statement

In the sipcall user account, under the Reports menu, you can access the connection overview and download it as a CSV file. This article explains how to display the CSV file in an organized and clear manner.

Editing CSV file

note

If you want to download the overview for an entire month, we recommend entering the data query as follows: e.g. 01.01.2024 00:01:00 to 01.02.2024 00:01:00
Reason: Subscription fees for the previous month are charged to the account between midnight and 1:00 AM on the following day.

Select column A:

Click on the Data tab, then select Text to columns:

Click Next immediately:

Select Comma as the delimiter and click Next:

Click Finish immediately:

For optimal display, apply the Number Format to your phone numbers and remove the decimal places.
Adjust the column widths as needed, and finally save the document in Excel format.