Strategies for Immediate Transaction Tracking & Avoiding Duplicates with Bank Sync Delays

[rhowell]

Hi @MNK214 !

I had this exact challenge and created a sheet that tracks scheduled transactions and calculates future balances. It was originally called Short Term Cash Flow, but I’ve added a number of features (including automatic reconciliation and credit card balances) and renamed it Scheduled Transactions:

Short Term Cash Flow template - project an account balance over future months, reconcile checks

@sskennel and others who may be interested: I’ve re-worked the Short Term Cash Flow template to add ability to track multiple accounts automatic reconciliation of transactions (complete with links to the Transactions sheet) and automated credit card balance calculation. The changes are substantial enough that I’m renaming the template (to Scheduled Transactions) and re-starting the versioning. Please check it out: [image] [image] [image] [image] I’ll formally release it when I have …