Six Week Cash Flow Forecast Template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a six week cash flow template which includes the following:

Beginning checking account balance
Accounts Receivable:
30 day
60 day
90 day
over 90

Payroll is biweekly
Payroll taxes (due on the 15th of each month)
ABC Vendor total amount due)
(amount is current, terms 2/10 net 30)
CBS Vendor total due (currently on COD)
Monthly truck lease
Payment on building
Accountant
Telephone, (average) due on the 20th of the month
Utilities, (average) due on the 4th of each month

All sales are posted to Accounts Receivable, averages sales of $6000 per
week.
Cost of goods sold is evenly split between the two vendors.


Thanks

(e-mail address removed)
 
Thndrchf said:
I need a six week cash flow template which includes the following:

Beginning checking account balance
Accounts Receivable:
30 day
60 day
90 day
over 90

Payroll is biweekly
Payroll taxes (due on the 15th of each month)
ABC Vendor total amount due)
(amount is current, terms 2/10 net 30)
CBS Vendor total due (currently on COD)
Monthly truck lease
Payment on building
Accountant
Telephone, (average) due on the 20th of the month
Utilities, (average) due on the 4th of each month

All sales are posted to Accounts Receivable, averages sales of $6000 per
week.
Cost of goods sold is evenly split between the two vendors.
Click to expand...

Well you've just done one! Set up rows with the legend as above, and put in
your values!
 
Gordon said:
Well you've just done one! Set up rows with the legend as above, and put in
your values!
Click to expand...

And don't forget, enter the payments on the estimated day they are cleared
through your bank, NOT on the day you pay the bill
 
: : > : > > I need a six week cash flow template which includes the following:
: > >
: > > Beginning checking account balance
: > > Accounts Receivable:
: > > 30 day
: > > 60 day
: > > 90 day
: > > over 90
: > >
: > > Payroll is biweekly
: > > Payroll taxes (due on the 15th of each month)
: > > ABC Vendor total amount due)
: > > (amount is current, terms 2/10 net 30)
: > > CBS Vendor total due (currently on COD)
: > > Monthly truck lease
: > > Payment on building
: > > Accountant
: > > Telephone, (average) due on the 20th of the month
: > > Utilities, (average) due on the 4th of each month
: > >
: > > All sales are posted to Accounts Receivable, averages sales of $6000 per
: > > week.
: > > Cost of goods sold is evenly split between the two vendors.
: >
: > Well you've just done one! Set up rows with the legend as above, and put
: in
: > your values!
: >
: >
:
: And don't forget, enter the payments on the estimated day they are cleared
: through your bank, NOT on the day you pay the bill

Why would you add this afterthought?
 
Lady Layla cogitated deeply and scribbled thusly:
: : > : > > I need a six week cash flow template which includes the following:
: > >
: > > Beginning checking account balance
: > > Accounts Receivable:
: > > 30 day
: > > 60 day
: > > 90 day
: > > over 90
: > >
: > > Payroll is biweekly
: > > Payroll taxes (due on the 15th of each month)
: > > ABC Vendor total amount due)
: > > (amount is current, terms 2/10 net 30)
: > > CBS Vendor total due (currently on COD)
: > > Monthly truck lease
: > > Payment on building
: > > Accountant
: > > Telephone, (average) due on the 20th of the month
: > > Utilities, (average) due on the 4th of each month
: > >
: > > All sales are posted to Accounts Receivable, averages sales of $6000 per
: > > week.
: > > Cost of goods sold is evenly split between the two vendors.
: >
: > Well you've just done one! Set up rows with the legend as above, and put
: in
: > your values!
: >
: >
:
: And don't forget, enter the payments on the estimated day they are cleared
: through your bank, NOT on the day you pay the bill

Why would you add this afterthought?
Click to expand...
Because the OP is obviously not familiar with cashflow forecasting,
otherwise they would not have made the original post!
 
Back
Top