Generate a Yearly Cash Flow Statement?
Marc D Bumble
bumble@isd.net
Fri, 23 Nov 2001 21:22:06 -0500
Using gnucash, is there a method to generate yearly Cash Flow
Statements showing a month-by-month breakdown for 12 months?
I searched the archives and the documentation, but don't see anything.
Bank statements don't seem to generate the appropriate reports. If
such a feature does not exist, is there a Linux solution better than
gnumeric someone can recommend? Is this the proper mailing list for
this question?
Thanks,
marc
Example for just 3 of 12 months:
Start-Up January February
Beginning Balence: $1321921.00 $1181904.00 $1084287.00
Loan Receipts
Capital (Cash) Invested
Total Revenues:
Sales Tax Collected
Total Cash Available
Disbursements
Accounting $150.00 $150.00 $150.00
Advertising $200.00 $200.00 $200.00
Association Dues $300.00 $300.00 $300.00
Auto Expense $1000.00 $1000.00 $1000.00
Insurance $350.00 $350.00 $350.00
Inventory Purchases $0.00 $0.00 $0.00
Legal/Attorney's Fees $6000.00 $0.00 $0.00
Licenses/Permits $300.00 $300.00 $300.00
Loan Interest $0.00 $0.00 $0.00
Loan Principal $0.00 $0.00 $0.00
Manger's Draw $0.00 $0.00 $0.00
Miscellaneous Expenses $18700.00 $18700.00 $18700.00
Payroll $56667.00 $56667.00 $56667.00
Payroll Taxes $17000.00 $17000.00 $17000.00
Phone $300.00 $300.00 $300.00
Rent $2000.00 $2000.00 $2000.00
Repairs/Maintenance $0.00 $0.00 $0.00
Sales Tax Payments $0.00 $0.00 $0.00
Subscription/Manuals $0.00 $0.00 $0.00
Office Supplies $250.00 $250.00 $250.00
Other Supplies $36400.00 $0.00 $0.00
Utilities $400.00 $400.00 $400.00
Total Disbursed $140017.00 $97617.00 $97617.00
Total Cash $1181904.00 $1084287.00 $986670.00
Less Other Disbursements
Security Deposits
Fixed Assets/Capital Equip
Miscellaneous
Total Other Disbursements
Net Cash Flow
Provision for Taxes
--