Show how much cash is really free
Combine what's owed, what's due and payroll dates so you see spendable cash, not just the bank balance.
Finance · Manufacturing · When you ask · Updated
Works with
- Slack
- QuickBooks
- Xero
- Airtable
- Microsoft 365
Slack
QuickBooks
Xero
Airtable
Microsoft 365How do you see how much cash is really free?
To see how much cash is really free, ask Maito in Slack. It reads your accounting software and spreadsheets, combines what customers owe, bills that are due and upcoming payroll, and shows the spendable amount by date next to the bank balance. It lists the assumptions it used.
How it's done today
The owner reads the bank balance and forgets the payroll and tax payments coming due.
What Maito does
- Pull receivables, payables and payroll dates
- Lay out the next 6 weeks
- Show best and cautious timing
- List the assumptions
Example
Loop run: None
@Maito what cash do we really have through Nov 30?
Bank balance is $64,200, but only about $9,100 is free through Nov 30. • Payables due: $31,400 (supplier invoices, rent and the Oct 28 sales tax payment) • Payroll: $27,800 on Oct 30 and $27,800 on Nov 13 (two runs, one more on Nov 27) • Receivables expected: $41,600. Cautious case counts only invoices not past 30 days: $27,200. Catch: Pied Piper owes $14,400, already 52 days late. In the cautious case I left it out; if it arrives, free cash rises to $23,500. Source: accounting software balances and due dates. Attached: cash-outlook.xlsx, assumptions in the first tab.
@Maito rerun with the Nov 27 payroll included.
With the Nov 27 run, free cash drops to minus $18,700 in the cautious case and $4,000 if Pied Piper pays. Updated file is attached. Want a draft note to Pied Piper?
Omar (11:02 AM):
what cash do we really have through Nov 30?
Maito (11:10 AM):
Bank balance is $64,200, but only about $9,100 is free through Nov 30.
• Payables due: $31,400 (supplier invoices, rent and the Oct 28 sales tax payment)
• Payroll: $27,800 on Oct 30 and $27,800 on Nov 13 (two runs, one more on Nov 27)
• Receivables expected: $41,600. Cautious case counts only invoices not past 30 days: $27,200.
Catch: Pied Piper owes $14,400, already 52 days late. In the cautious case I left it out; if it arrives, free cash rises to $23,500.
Source: accounting software balances and due dates. Attached: cash-outlook.xlsx, assumptions in the first tab.
Omar (11:14 AM):
rerun with the Nov 27 payroll included.
Maito (11:16 AM):
With the Nov 27 run, free cash drops to minus $18,700 in the cautious case and $4,000 if Pied Piper pays. Updated file is attached. Want a draft note to Pied Piper?
How to set it up
- Set up
Nothing to set up. Ask in Slack or by email whenever you need it.
- Connect accounting software
- QuickBooks
- Xero
- Connect spreadsheet
- Airtable
- Microsoft 365
Not connected yet? Your agent sends you a link to sign in.
What it won't do
Maito can't know about payments nobody recorded, and it doesn't give financial advice. Treat the figure as a starting point.
Questions
QuickBooks or Xero for balances, bills and invoices, and a spreadsheet in Airtable or Microsoft 365 for payroll dates.
It uses the due dates and states that assumption. You can ask for a cautious view that delays them.
It's a working view of known money in and out, for you to check before a decision.
