Daily Cash Position Report to Leadership
Know your cash on hand every morning without logging in.
Nora pulls bank balances and outstanding receivables/payables from QuickBooks, calculates net cash position, and emails a daily report to leadership with forecasts and alerts.
At 6:00 AM every day, Nora queries QuickBooks to pull current balances from all connected bank accounts. It retrieves outstanding unpaid invoices by due date for expected cash in, and outstanding bills payable for expected cash out. Nora then calculates the net cash position, generates a 7-day forecast, compares the figures to the same day last month and year, and emails the summary to leadership. It flags any instance where projected cash drops below the requested minimum threshold.
The finance leader or CEO reads the morning email rather than exporting reports and building a daily spreadsheet. They use the summary to decide if they need to arrange short-term financing, delay vendor payments, or follow up on critical overdue invoices.
Runs daily at 6:00 am using QuickBooks, run by your CEO.
How it works
- Trigger on daily morning schedule — Every morning at 6:00 AM, the scheduled cron job fires. Nora authenticates with the QuickBooks API using the stored OAuth 2.0 credentials and the specific company realm ID to begin the data retrieval sequence.
- Pull current bank account balances — Nora queries the QuickBooks account endpoints to read the current balance of all connected checking and savings accounts. It sums these balances to establish the starting cash on hand for the day.
- Aggregate receivables and payables — Nora requests the accounts receivable and payable aging reports. It extracts outstanding unpaid invoices as expected cash inflows and outstanding bills as expected cash outflows, organizing them by their exact due dates.
- Calculate net cash and forecast — Using the starting balance and the schedule of upcoming inflows and outflows, Nora calculates the projected net cash position for each of the next seven days. It compares today's starting position against the same date last month and last year.
- Evaluate minimum cash threshold — Nora checks the lowest projected point in the 7-day forecast against the minimum cash threshold you told it to monitor. If the projection dips below this number, Nora applies an alert flag to the final report.
- Handle missing or stale data — If bank feeds have not synced in the last 24 hours, Nora notes the stale date next to the account balance. If there are no upcoming bills or invoices, it projects a flat cash position rather than failing.
- Send the final email report — Nora formats the aggregated balances, the 7-day projection, historical comparisons, and any low-cash alerts into a plain-text email. It sends this report directly to the specified leadership email addresses.
What this replaces
A finance manager or founder logs into QuickBooks every morning. They check the bank feed to confirm recent transactions synced, run an accounts receivable aging report to see what money is due, and run an accounts payable report for upcoming bills. They export these figures into a spreadsheet, manually calculate the expected cash flow for the week, and email the resulting summary to the executive team.
- Log into QuickBooks and check bank feed sync status.
- Run and export accounts receivable and payable aging reports.
- Update a cash flow spreadsheet with current balances and due dates.
- Draft and send a summary email to the leadership team.
Rough estimate rather than a measured figure: about 30 minutes a day, based on pulling three separate reports, updating a spreadsheet, and formatting an email.
What it needs to run
Accounts and plans
- QuickBooks Online account
- Email account for sending outgoing reports
Access it asks for
- Accounting API scope to read account balances and run aging reports
- OAuth 2.0 refresh token valid for continuous background access
What Nora reads
- Bank account balances
- Accounts receivable aging details and unpaid invoices
- Accounts payable aging details and unpaid bills
What Nora writes
- Generates and sends an external email report
When it goes wrong
- QuickBooks API rate limit is exceeded during data retrieval The QuickBooks API limits bursts to 10 requests per second. If Nora hits this limit, it pauses, backs off for a few seconds, and retries the specific endpoint until the data is successfully retrieved.
- OAuth refresh token expires after 100 days QuickBooks refresh tokens expire. When the API rejects the connection, Nora stops the run, sends a direct message stating the token expired, and waits for you to re-authenticate the connection.
- Bank feed has not synced recently Nora reads the last synced timestamp for each bank account. If the feed is outdated, it proceeds with the calculation but adds a clear warning note to the email that the starting balance is stale.
- Overdue invoices with dates in the past Nora separates overdue invoices into an independent 'Overdue' line item in the report. It does not blindly add them to the 7-day forecast, as leadership needs to know this cash is not guaranteed.
Who this is for
Worth it if
- Founders at 10-50 person companies who need daily financial visibility without logging into accounting software.
- Finance teams managing tight cash flow runways where a week's difference in vendor payments matters.
- Businesses with high daily transaction volumes and rolling net-30 invoices.
Not worth it if
- Businesses with massive cash reserves where daily fluctuations do not impact operational decisions.
- Companies that do not use QuickBooks for both accounts receivable and accounts payable.
- Teams that require complex scenario modeling and manual adjustments to expected payment dates before reviewing forecasts.
A worked example
A 25-person logistics firm. They told Nora to email the CEO and CFO at 6:00 AM daily, and to flag any scenario where projected cash drops below $40,000 in the next seven days.
Daily Cash Position - Oct 14 Starting Cash: $112,450 (Bank feeds synced 8 hours ago) 7-Day Expected In (AR): $34,200 7-Day Expected Out (AP): $41,100 Projected 7-Day Net: $105,550 Historical Context: Same day last month: $98,200 Same day last year: $85,000 Alerts: None. Cash remains above the $40,000 threshold for the forecast period. Overdue AR Note: $12,500 in invoices are currently past due and not included in the 7-day expected inflows.
Frequently asked questions
How do I change the minimum cash threshold?
You tell Nora in your chat channel. If your required cash buffer increases from $50,000 to $75,000, you send Nora a message stating the new minimum. Nora updates its instructions and uses the $75,000 threshold for all future morning reports.
Does Nora change anything in my QuickBooks account?
No. For this specific workflow, Nora only reads data from your QuickBooks account. It queries account balances, invoices, and bills to perform its calculations, but it does not create, modify, or delete any records in your ledger.
What happens if an expected invoice payment is delayed?
Nora bases its 7-day forecast strictly on the due dates recorded in QuickBooks. If an invoice is due this week but you know the client will pay late, Nora will still count it as expected cash. You must change the due date in QuickBooks for the report to reflect the delay.
Can I add other recipients to the daily email?
Yes. You manage the recipient list by speaking to Nora. If you hire a new finance director, you tell Nora to start including their email address in the morning distribution. Nora will send the next scheduled report to the updated list.
Connects to
Related automations
- Xero Invoice Reminder Automation — Automatically send friendly invoice payment reminders before they become overdue.
- Xero Overdue Invoice Summary Report — Get a daily summary of overdue invoices with aging breakdown and collection priority.
- Xero Bank Reconciliation Check — Verify bank and Xero balances match, flag mismatches for review.
- Xero Weekly Expense Report — Track company spending with categorized expense summaries sent each week.
- Auto-Reconcile Bank Transactions Daily — Close your books in hours instead of days with automatic bank reconciliation.
- Automated Mileage Reimbursement Processing — Process mileage expenses in minutes instead of managing spreadsheets.
- Auto-Categorize Expenses by Pattern Learning — Stop manually categorizing every receipt—Nora learns your patterns.
- Automatic 1099 Contractor Tracking — Never miss a 1099 filing deadline with automated tracking.