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
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.