Manage Cash Forecast

To view a cash forecast, select the forecasting criteria you wish to see in the filters below and click Update Forecast. To get started with cash forecasting, click a link to import or manually add data, forecast using historical data or set SinglePoint transaction settings.

Import Data | Manually Add Data | Forecast Using Historical Data | SinglePoint Transaction Settings | View History

Select Forecast Filters Select Forecast Filters

Printable format

View Forecast For Account Select Account U.S. Bank Minnesota - Sample Account A - 123456789012 U.S. Bank Wisconsin - Sample Account B - 234567890123 U.S. Bank East GF - Sample Account C - 345678901234 U.S. Bank Washington - Sample Account D - 456789012345 U.S. Bank Ohio - Sample Account E - 567890123456 Data Exchange Bank - Sample Account F - 678901234567 Sample Bank - External Account 1 - 0011223344 Sample Bank - External Account 2 - 1122334455 Group     All Groups Sample Group 1 Sample Group 2 Sample Group 3

Select Forecast View Account List Group List Category List

Forecast Time Period

View One Time Period Compare Two Date Ranges	Time Period This Week Next Week This Month Next Month This Quarter Next Quarter This Year Select Date Range	Date Range 1	Beginning Date (MM/DD/YYYY)	To	Ending Date (MM/DD/YYYY)
		Date Range 2	Beginning Date (MM/DD/YYYY)	To	Ending Date (MM/DD/YYYY)

Display Time Period By Day Day Week Day Week Month Day Week Month Quarter

Time Period Options    View Exact Time Period View Full Weeks

View Forecasting Scenario
None Sample Scenario 1 Sample Scenario 2 Sample Scenario 3   Manage Scenarios

Show only categories that have data
Save these forecast filter selections as defaults

 

Forecast for All Accounts for Next Month by Week

Export Format Summary View Expanded View

Search Account Name or Number

Display   Week 1 (11/16/20XX) Week 2 (11/23/20XX) Week 3 (11/30/20XX) Week 4 (12/07/20XX) Scroll Table

	Bank Name / Account Name / Account Number	Week 1 Ending 11/16/20XX (Forecast)	Week 2 Ending 11/23/20XX (Forecast)	Week 3 Ending 11/30/20XX (Forecast)	Week 4 Ending 12/07/20XX (Forecast)
	Summary of All Accounts	$13,189,883.78	$15,197,916.35	$12,203,026.94	$12,165,699.10
	U.S. Bank Minnesota Sample Account A 123456789012 U.S. Bank Minnesota Sample Account A 123456789012	$9,924,883.78	$12,197,916.35	$9,283,026.94	$8,975,699.10
	Opening Available Balance (Week Beginning)	$9,724,883.78	$9,924,883.78	$12,197,916.35	$9,283,026.94
	Plus Cash In
	Sample Category 1	$150,000.00	$2,373,032.57	$2,964,889.41	$407,327.84
	Total Cash In	$150,000.00	$2,373,032.57	$2,964,889.41	$407,327.84
	Less Cash Out
	Sample Category 5	$350,000.00	$100,000.00	$50,000.00	$100,000.00
	Total Cash Out	$350,000.00	$100,000.00	$50,000.00	$100,000.00
	Net Flows	$200,000.00	$2,273,032.57	$2,914,889.41	$307,327.84
	Closing Balance (Week Ending)	$9,924,883.78	$12,197,916.35	$9,283,026.94	$8,975,699.10
	U.S. Bank Wisconsin Sample Account B 234567890123	$310,000.00	$290,000.00	$275,000.00	$305,000.00
	U.S. Bank East GF Sample Account C 345678901224	$490,000.00	$485,000.00	$500,000.00	$535,000.00
	U.S. Bank Washington Sample Account D 456789012345	$1,375,000.00	$1,240,000.00	$1,190,000.00	$1,310,000.00
	U.S. Bank Ohio Sample Account E 567890123456	$840,000.00	$750,000.00	$785,000.00	$820,000.00
	Data Exchange Bank Sample Account F 678901234567	$250,000.00	$235,000.00	$170,000.00	$220,000.00

Export Format Summary View Expanded View

Scroll Table   Display   Week 1 (11/16/20XX) Week 2 (11/23/20XX) Week 3 (11/30/20XX) Week 4 (12/07/20XX)

Cash Forecasting uses Adobe Reader for printable format and for report PDF format. If you don't have Adobe Reader installed on your system, you can download it by clicking on the Get Adobe Reader button. This button will open a new window and bring you to the Adobe website. U.S. Bank is not responsible for the content of or products and services provided by the site you will be entering, nor does it guarantee the accuracy of information contained in the site.