Improving Cash Flow
The basis of improving cash flow is in knowing your cash position daily, forecasting realistically, and knowing
how well you've met that forecast. Here's a form to help with that.
Remember, it's a weekly form for forecasting, but I want you to know your actual cash position and bank balance daily.
Right-click below to save a printable, editable version.
PDF
Word HTML (can be saved as .doc)
Text File with tabs
Weekly Cash Forecast
Your company name:
Fiscal Year begins:
IMPORTANT: THIS IS AN EXAMPLE! The data shown just indicates how the information carries forward. Use your own data, of
course.
| |
Pre-Start UP
|
Week 1
|
Week-2
|
Week-3
|
Week-4
|
Week-5
|
Total Item Est.
|
|
Cash on Hand (beginning of month)
|
|
-400
|
-549
|
-549
|
-549
|
-549
|
-549
|
| |
|
|
|
|
|
|
|
|
CASH RECEIPTS
|
|
|
|
|
|
|
|
|
Cash Sales
|
100
|
50
|
|
|
|
|
|
|
Collections fm CR accounts
|
|
|
|
|
|
|
|
|
Loan/ other cash inj.
|
|
|
|
|
|
|
|
|
TOTAL CASH RECEIPTS
|
100
|
50
|
0
|
0
|
0
|
0
|
0
|
|
Total Cash Available (before cash out)
|
100
|
-350
|
-549
|
-549
|
-549
|
-549
|
-549
|
| |
|
CASH PAID OUT
|
|
|
|
|
|
|
|
|
Purchases (merchandise)
|
500
|
|
|
|
|
|
|
|
Purchases (specify)
|
|
|
|
|
|
|
|
|
Purchases (specify)
|
|
|
|
|
|
|
|
|
Gross wages (exact withdrawal)
|
|
|
|
|
|
|
|
|
Payroll expenses (taxes, etc.)
|
|
|
|
|
|
|
|
|
Outside services
|
|
|
|
|
|
|
|
|
Supplies (office & oper.)
|
199
|
|
|
|
|
|
|
|
Repairs & maintenance
|
|
|
|
|
|
|
|
|
Advertising
|
|
|
|
|
|
|
|
|
Car, delivery & travel
|
|
|
|
|
|
|
|
|
Accounting & legal
|
|
|
|
|
|
|
|
|
Rent
|
|
|
|
|
|
|
|
|
Telephone
|
|
|
|
|
|
|
|
|
Utilities
|
|
|
|
|
|
|
|
|
Insurance
|
|
|
|
|
|
|
|
|
Taxes (real estate, etc.)
|
|
|
|
|
|
|
|
|
Interest
|
|
|
|
|
|
|
|
|
Other expenses (specify)
|
|
|
|
|
|
|
|
|
Other (specify)
|
|
|
|
|
|
|
|
|
Other (specify)
|
|
|
|
|
|
|
|
|
Miscellaneous
|
|
|
|
|
|
|
|
|
SUBTOTAL
|
500
|
199
|
0
|
0
|
0
|
0
|
0
|
|
Loan principal payment
|
|
|
|
|
|
|
|
|
Capital purchase (specify)
|
|
|
|
|
|
|
|
|
Other startup costs
|
|
|
|
|
|
|
|
|
Reserve and/or Escrow
|
|
|
|
|
|
|
|
|
Owners' Withdrawal
|
|
|
|
|
|
|
|
|
TOTAL CASH PAID OUT
|
500
|
199
|
0
|
0
|
0
|
0
|
0
|
|
Cash Position (end of month)
|
-400
|
-549
|
-549
|
-549
|
-549
|
-549
|
-549
|
| |
|
ESSENTIAL OPERATING DATA (non cash flow information)
|
|
|
|
|
|
|
|
|
Sales Volume (dollars)
|
|
|
|
|
|
|
|
|
Accounts Receivable
|
|
|
|
|
|
|
|
|
Bad Debt (end of month)
|
|
|
|
|
|
|
|
|
Inventory on hand (eom)
|
|
|
|
|
|
|
|
|
Accounts Payable (eom)
|
|
|
|
|
|
|
|
|
Depreciation
|
|
|
|
|
|
|
|
Copyright © William Vardeman All Rights Reserved - Business-Help-Now.com
Click to learn about Debt Workouts.
|
