How to populate the Statement of Cash Flows from Excel - with QuickVid

1. Click on the question mark to expand the help text.

2. To download the Cashflow Excel document, click on the small globe as highlighted below.

3. Once clicked, this will direct you to the Cashflow Excel worksheet download here.

Once downloaded copy it to the Document Manager and rename the Document Number to CASHFLOW-LINK.

4. Copy the spreadsheet into your Document Manager for the engagement file being worked on.

5. Rename the document number by right-clicking on the Cashflow document (within the document manager) and selecting Properties.

6. Change the document number to CASHFLOW-LINK, as shown below.

7. This will then appear as follows in the Document Manager.

8. Open the Cashflow Excel document by double-clicking it.

9. Expand the help text and you will be presented with a tick box to add the Excel function:

Once ticked, this will pull through the Excel figures to the Statement of Cash Flows.

Visit our Client Services YouTube Channel for more QuickVids.