This template allows you to capture the last four weeks of cash activity and projects out the next 13 weeks to give an acute view of inflows and outflows.

The tab that organizes all the data is aptly named “13-Week Projection”. It draws information from other tabs including the bank account, A/R, A/P, and GL reports, each of which have their own supporting tab. In this template, all of these reports are flowing from Quickbooks Online using Amalgam, but as you’d imagine can be sourced from any general ledger tool that Amalgam connects to.

Along with these tabs, there is a “Projections” tab which is a placeholder for other expected cash movements like payroll, rent, and other expenses. It uses a clever formula that updates the forward-looking dates everytime the file is updated so a complete reconstruction isn’t needed every week.