Quote: (10-23-2015 10:09 PM)Numbers Man Wrote:
If you need to construct a basic Excel spreadsheet to track cashflow, work with this:
Current Cash at Bank
Plus Receipts (Inflows)
Income / Billings
Interest income
Less Expenses (Outflows)
Rent
Electricity
Phone
License fees (if using any software)
Tax
Net Receipts / (Loss)
Forgot to include this in my last post, then add the net receipts or loss to the opening cash at bank to get your closing cash at bank for the week.
This figure then becomes your new opening cash at bank figure for the following week.
Then rinse & repeat.