Management > Cash Flow > Auto filling your cash flow
Looking for something specific in the page and not quite sure where to find it? You can always press CTRL + F on your keyboard and type a keyword. Or you can do a search (in the top right corner).
Auto filling your cash flow
You can automatically enter cash flow values for entire rows, columns or spreadsheets. If you’re auto filling values for a row or a column, select the appropriate row or column first.
Note: The option is only available for a projected cash flow.
- Click Auto Fill … on the Cash Flow dialogue box. The Auto Fill dialogue box opens.
- To auto fill an entire a row, select the Row tab and select one of the following options:
- Set each period in the current row to the following amount - Enter a dollar amount. The projected value for each cell in the selected row will be set to this amount.
- Set the first amount of the current row to - Enter a dollar amount. It will be entered in the first projected period of the selected row.
- Then successive periods increase by the following percentage - Enter a percentage. Each successive cell in the selected row will be adjusted by this percentage. For example, if you entered $500.00 and a percentage of 10, the first cell would be set to $500.00, the second cell would be set to $550.00 (10% x $500.00 = $50.00. $500.00 + $50.00 = $550.00), and so on.
- Set the first amount of the current row to - Enter a dollar amount. It will be entered in the first projected period of the selected row.
- Then successive periods change by the following amount - Enter a dollar amount. Each successive cell in the selected row will change by this amount. For example, if you entered $500.00 for the first value and $50.00 for the second value, the first cell would be set to $500.00, the second cell would be set to $550.00, and so on.
- Adjust each of the amounts in the current row by the following - Enter a percentage. Any cash flow amounts in the selected row will be adjusted by this percentage. For example, if you entered 10 per cent and the values $100.00, $200.00, $300.00 existed in the row, they’d be adjusted to $110.00, $220.00 and $330.00.
- Set the current row to the budget amounts for this account from the following fiscal year -Enter a year. The values in the selected row will be set to those entered in the budget in the specified year.
- Set the current row to the actual transaction amounts for this account from the following fiscal year - Enter a year. The values in the selected row will be set to the actual values from the specified year.
- To auto fill an entire column, select the Column tab and then select one of the following options:
- Adjust each of the amounts in the current column by the following - Enter a percentage. Any cash flow amounts in the selected column will be adjusted by this percentage. For example, if you entered 10 per cent and the values $100.00, $200.00 and $300.00 existed in the selected column, they’d be adjusted to $110.00, $220.00 and $330.00.
- Set the current column to the budget amounts for this account from the following fiscal year - Enter a year. The values in the selected column will be set to those entered in the budget in the specified year.
- Set the current column to the actual transaction amounts for this account from the following fiscal year - Enter a year. The values in the selected column will be set to the actual values from the specified year.
- To auto fill an entire worksheet, select the Entire Worksheet tab and then select one of the following options:
- Adjust each of the amounts in the current sheet by the following - Enter a percentage. Any cash flow amounts in the worksheet will be adjusted by this percentage. For example, if you entered 10 per cent and the amounts $100.00, $200.00, $300.00 existed in the worksheet, they’d be adjusted to $110.00, $220.00 and $330.00.
- Set the entire worksheet to the budget amounts from the following fiscal year - Enter a year. The values in the worksheet will be set to those entered in the budget in the specified year.
- Set the entire worksheet to the actual transaction amounts from the following fiscal year- Enter a year. The values in the worksheet will be set to the actual values from transactionsentered in the specified year.
- Set the entire worksheet to the projected transaction amounts from the following fiscal year – Enter a year. The values in the worksheet will be set to the projected values for the specified year.
- Click Apply.
Last updated on August 22, 2014 by FCC AgExpert