Cash Flow Survey | QuestionPro

What is your current job title?

What studio or production company do you currently work for?

Do you start the task of preparing cash flow by exporting information (or copying and pasting) from your budgeting software?

Yes

No

At what level of the budget do you prepare cash flow? Please select all that apply:

Summary

Account

Detail Line Item

Are you ever given a spreadsheet template by a studio or network to prepare cash flow?

Yes

No

Please select all the items that were included in the most recent spreadsheet template that you were provided by a studio or network to prepare cash flow:

Chart-of-accounts

Account description

Formulas to spread the various account totals

Subtotals for production levels

Weekly columns for spreading costs

Monthly columns for spreading costs

Weekly columns that roll into monthly columns

Costs-to-date column

Deposits column

Were there any other important items not listed above? If so, please describe:

Do you currently use your own spreadsheet--which you created--to prepare cash flow?

Yes

No

As your budget is revised, are you required to update your cash flow?

Yes

No

Are you required to reconcile the actual cash spent per week or month with cash flow projections?

Yes

No

On the accounting side, what reports do you use for cash flow reconciliation? Please select all that apply:

Cost Report

Cash Account Ledger Inquiry

General Ledger

Bank Reconciliation

Original Cash Flow spreadsheet

Original Budget

Other (please describe)

For reporting and reconciliation, are you required to consolidate your cash flow?

Yes

No

How are you asked to consolidate?

From weeks to months

From months to quarters

From account level to topsheet

Other (please describe)

Is your cash flow updated by anyone other than yourself?

Yes

No

Other than you, who updates your cash flow?

Staff member

Production Finance Executive

Treasury

Other (please describe)

Are you required to adjust your cash flow for the next period?

Yes

No

Are you required to re-do your cash flow to reflect cash needed to complete the project?

Yes

No

Are you required to provide explanations for the variances between cash requested and actual cash in bank?

Yes

No

When providing explanations for the variances, at what level are you required to do so? Please select all that apply:

Summary

Account

Line Item

Do you have any additional comments regarding the process of preparing cash flow that you would like to share with us? (For example, your likes and/or dislikes, your thoughts on how the process could be made easier, your suggestions on how the process could be better integrated with your budgeting software, etc.)