overview

Commercial Banks can be extremely complex especially if the number of transactions is quite extensive. Reporting can become even more challenging when having foreign currencies and multiple companies. Through the integration of  Jet Reports with Microsoft Excel, we are aiming at getting all this information within 1 single sheet.

Topics to be covered:

1. List of Banks per company, including both foreign as well as local balance

2. The movement of bank accounts over a set period

3. An analysis of the unreconciled entries per bank per company

4. Analysis of unreconciled bank entries related to customers

5. An analysis of the charges

6. Getting the bank entries linked to every bank statement

download this webinar's

resource pack

EXCEL SHEETS USED

PRESENTATION