Downloading Account Statements

In addition to printing account statements, BC OnLine customers can also download their account statements and import them into an Excel worksheet or an accounting program. The account statement data is stored in Comma Separated Values (CSV) files (plain text files that use commas to separate data).

The following instructions show how to download your statement and import it into an Excel worksheet. If you use software other than Excel for accounting purposes, please refer to that software’s documentation for proper import procedures.

These instructions clearly demonstrate one way of downloading an account statement and importing it into a software package. You may discover other methods to achieve the same purpose. You are encouraged to adapt these procedures for your own environment.

Note
If you have a different version of Excel than the one used for this demonstration, the screens you encounter may be slightly different, but the process is the same.

The steps to import your statement into a software package are:

1. Generate the statement as a CSV file.

2. Email the CSV file to yourself.

3. Open the CSV file with your word processor (such as Word).

4. Save the CSV file as a TXT file.

5. Use your software (in this example Excel) to import the TXT file.