Slide 1

Slide notes: When we receive an electronic Bank Page from the Bank or download it from Internet Banking, it will be similar to what we see here. Banks usually provide a CSV format option, and that is a format that we can open in a spreadsheet like this.

Slide 2

Slide notes: Note the Open Balance at the top and the Closing Balance at the bottom. We will not use these Items.

Slide 3

Slide notes:

Slide 4

Slide notes: In fact, we can refer to electronic Bank Pages as virtual pages, because we can download data regularly and apply it to our Recon without waiting for the Bank Statement to arrive, if we want.

Slide 5

Slide notes: And in such cases where we do downloads, we may often have data included that we have imported before into our Recon. For example, if the highlighted data are lines that we have already imported, then we can just delete the section.

Slide 6

Slide notes:

Slide 7

Slide notes: And use only the rest, as highlighted now.

Slide 8

Slide notes: Let's go to our Recon now and note the Opening Bank Page balance for the next Page.

Slide 9

Slide notes:

Slide 10

Slide notes:

Slide 11

Slide notes:

Slide 12

Slide notes:

Slide 13

Slide notes:

Slide 14

Slide notes: Note the Page Balance.

Slide 15

Slide notes:

Slide 16

Slide notes: It is the same as on our electronic Page. However, the electronic page format can be different, and if we download part pages regularly, the opening Balance may not agree because then we may work with data portions that do not agree with exact Bank Pages. Nonetheless, it is perfectly fine to do so, as long as we load the correct entries, without skipping any, and without duplicating any.

Slide 17

Slide notes:

Slide 18

Slide notes: Note that we are working with our HSBC Recon Master, and if we want to import Bank Pages without having to capture manually, then we will usually have an Import Template that tells the system what the Bank Pages from HSBC look like, i.e. how to interpret the data.

Slide 19

Slide notes:

Slide 20

Slide notes:

Slide 21

Slide notes:

Slide 22

Slide notes:

Slide 23

Slide notes:

Slide 24

Slide notes:

Slide 25

Slide notes: And here is our Template for HSBC Pages. Each time when we import Bank Pages for an HSBC Recon, we just use this Template.

Slide 26

Slide notes:

Slide 27

Slide notes:

Slide 28

Slide notes:

Slide 29

Slide notes: Before we will import, we have to tidy the import file, because we want only the Line Entries, and no headers or opening or closing balances.

Slide 30

Slide notes:

Slide 31

Slide notes:

Slide 32

Slide notes:

Slide 33

Slide notes:

Slide 34

Slide notes:

Slide 35

Slide notes:

Slide 36

Slide notes:

Slide 37

Slide notes:

Slide 38

Slide notes:

Slide 39

Slide notes:

Slide 40

Slide notes:

Slide 41

Slide notes: Now our Bank Page includes only the data we want, i.e. the Transaction Lines. We now have to save the Page as a CSV file on the BRIDGE folder on our Server.

Slide 42

Slide notes:

Slide 43

Slide notes:

Slide 44

Slide notes:

Slide 45

Slide notes:

Slide 46

Slide notes:

Slide 47

Slide notes:

Slide 48

Slide notes:

Slide 49

Slide notes:

Slide 50

Slide notes: On our Bank Page, we choose 'Import'.

Slide 51

Slide notes: And we select the correct Template to use.

Slide 52

Slide notes:

Slide 53

Slide notes: The system offers available import file options, and we select our Bank Page file.

Slide 54

Slide notes:

Slide 55

Slide notes: The Bank Page is imported instantaneously and the Page closing balance should agree with the actual Bank Page closing balance.

Slide 56

Slide notes:

Slide 57

Slide notes:

Slide 58

Slide notes:

Slide 59

Slide notes: If our closing balance is correct, we can just save the Bank Page. Importing is much less work than capturing.

Slide 60

Slide notes: