Statements of transactions may be downloaded in delimited text format (CSV) and imported into your favourite program.
The following table describes the field format with the type, length, number of decimal points and a description of the field.
Caisse, Folio, PCA, Date, Sequence, Description, Cheque, Withdrawal, Deposit, Balance |
Caisse, Folio, RS, Date, Sequence, Description, Withdrawal, Deposit, Balance |
Caisse, Folio, TS, Date, Sequence, Description, Withdrawal, Deposit, Balance |
Caisse, Folio, CS, Date, Sequence, Description, Withdrawal, Deposit, Balance |
Caisse, Folio, LN, Date, Sequence, Description, Interest, Capital paid, , Reimbursement, Balance |
Caisse, Folio, LC, Date, Sequence, Description, Interest, Advance, Reimbursement, Balance |
The following table provides information on the format of each field (its type, its length, the number of decimal places it contains and a brief description).
Field | Type | Length | Decimal | Description |
Institution | C | 25 | No | Abbreviated name of Caisse populaire |
Folio | C | 7 | No | Folio number |
Type_account | C | 5 | No | Type of account: PCA, RS, TS, LN, LC, CS |
Date | C | 10 | No | Format: YYYY/MM/DD |
Sequence | N | 3 | 0 | Sequential number for sorting |
Descriptif | C | 90 | No | Description of transactions |
Cheque | N | 8 | 0 | Cheque number (PCA) |
Withdrawal | N | 13 | 2 | Withdrawal amount (PCA,RS,TS,CS) |
Deposit | N | 13 | 2 | Deposit amount (PCA,RS,TS,CS) |
Interest | N | 13 | 2 | Interest (LN,LC) |
Capital paid | N | 13 | 2 | Capital paid (LN) |
Advance | N | 13 | 2 | Cash advance (LC, ) |
Reimbursement | N | 13 | 2 | Reimbursement (LN,LC, ) |
Balance | N | 13 | 2 | Balance |
« C.P. Ste-Edith », »27656âł, »EOP », »1997/06/16âł,1, »Retrait au comptoir »,125.75, » », » », » », » », » »,678.65 |
« C.P. Ste-Edith », »27656âł, »EOP », »1997/06/17âł,1, »Depot au comptoir », » »,654.87, » », » », » », » »,2774.65 |
We have designed templates (models) into which you will be able to insert your first downloaded file. This ensures that you will have a good definition of the data in the software program of your choice. Therefore, you will not have to worry about correctly defining the width of columns in your spreadsheet or the right type of data in your database.
The following templates accept this format:
You may download the template of your choice by clicking on the name of the software that you like to use from the previous list.
Since we strive to satisfy your needs, we ask that you tell us the name of the software program that you use if it does not accept the previously mentioned templates.
You must first download the template which corresponds to the software you use. Then, you can download your âStatement of Transactionsâ in a CSV format.
We suggest that you always keep a previous version of your working document. To do so, before starting to import any data, save your file under another name. That way, if you make a mistake, you wonât lose all the information.
Lotus 1-2-3, hereâs how to proceed: (detailed procedure)
Microsoft Excel, hereâs how to proceed: (detailed procedure)
Microsoft Access, hereâs how to proceed: (detailed procedure)
Note :
Borland dBase and other compatible software programs: