Accounts Receivable Report

Managing cash flow is critical for any business, and tracking accounts receivable is a key part of that. To streamline this process, I built an automated report that fetches data from a Google Sheet using the Google Sheets API. The report pulls invoice details—such as invoice number, amount, client name, and status (current or past due)—and sorts them from oldest to newest.

The script runs on an AWS server using nohup -u to ensure continuous operation, with an output log available via tail -f for monitoring. It checks the spreadsheet daily, Monday through Friday, and sends an email summary at 7:30 AM. While this schedule is great for staying on top of accounts, the pace of my business suggests a weekly notification might be more appropriate. Small tweaks like this keep the system efficient and aligned with my workflow.