Automated Dues & Ledger Tracker

I keep separate records of what clients owe me and the running ledger of every payment that comes in or goes out. Updating those sheets by hand is slowing me down, so I’d like a single automated system that works in both Google Sheets and Microsoft Excel. Here’s what I need the finished file(s) to do for me: • Accept a new transaction—whether it’s a client payment, an expense, or an adjustment—and instantly update all balances and ageing summaries. • Show at a glance who still owes me money, how much, and for how long the balance has been outstanding. • Maintain a clean ledger view that I can filter by date, category, or contact. • Generate printable or share-ready reports I can pass straight to my accountant. • Sync or exchange data with my accounting software so I’m not re-keying anything. Because I switch between Excel and Google Sheets during the week, formulas, scripts, or macros must run reliably in both environments (App Script for Sheets, VBA/Power Query or 365-compatible functions for Excel). If something can’t be replicated exactly, please offer a workaround that still gives me a single source of truth. Deliverables 1. A fully-built template in Excel (.xlsx) and the equivalent Google Sheet, pre-loaded with sample data to prove automation works. 2. Clear, step-by-step instructions (or recorded demo) showing how to add transactions, refresh the dashboard, and connect to my accounting package. 3. Light documentation of the code or formulas so I can tweak fields or labels later. I’ll provide a small set of real data once we start so you can test integrations. Let me know your approach, any past examples of similar spreadsheet automation, and how you plan to handle the accounting software link-up.

Project ID: 40435918