Do you have a bustling bank account with lots of pending checks or bills? Always know exactly where you're at by automatically calculating the difference between everything that's pending and your current bank balance. Ability to organize by bills that are already pending, bills that are upcoming, as well as future expenses.

Instructions: Download the PDF and open it. Click the button on the document to open the spreadsheet and make a copy. You must be signed into Google. Google accounts are free.

This spreadsheet uses a combination of the SUM function, accounting number format and negative data values to display sums and differences. Note: Sometimes the rearranging of multiple rows can disrupt the SUM formula’s data ranges.

For questions or assistance with this tool, contact us.