Tracking Projected Balance with Outstanding Checks

Hi there! We are using Excel. I saw a google sheets topic about adding a manual transaction and then reconciling it automatically once the transaction has posted. How can I do this in Excel? For example:
Our balance is $100,000 and we write two $45,000 checks. We want to track our current balance, but take into account the outstanding checks totaling $90,000. Once these have cleared, automatically remove them from outstanding category.

Good question, @jarrodwillis. At this time, we have a few features (like manual transaction reconciliation) in the Google Sheets add-on that are not in the Excel add-in. We plan to built out more features in the Excel add-in.

Awesome! We have tried to work with Google Sheets, but just couldn’t fit it to work like Excel. Is there a timeline of features that will be rolled out for Excel?

Thank you,


Jarrod Willis | REALTOR®

Keller Williams Community Partners | The Willis Group
mobile: 678-230-7377
phone: 678-341-7926

email: jarrodwillis@kw.com
address: 327 Dahlonega Street, Suite 1803B, Cumming, GA 30040