
- What is a liquidity position report?
- Static vs. dynamic liquidity
- What goes in a liquidity position report
- How to build a liquidity position report in 6 steps
- Liquidity position report template
- Common mistakes when building a liquidity report
- Act on your liquidity report with Ramp Business Banking
When leadership asks about liquidity, they want two numbers: the cash you can spend today and how many weeks it lasts. Knowing how to build a liquidity position report starts with three moves: pull every balance, date committed inflows and outflows, then set views and a review cadence.
What is a liquidity position report?
The liquidity position report is a recurring internal snapshot of your available cash, near-term inflows and outflows, and the cash runway that results. At an operating company, the CFO, CEO, board, and your own finance team all read it, each for a different decision.
You need one after a raise, ahead of large payments, or when collections slow down. Good liquidity reporting puts those moments on a schedule. Start your first liquidity report before you need it, because the first version takes a few weeks to tune.
Static vs. dynamic liquidity
Your report needs both static and dynamic views, because each answers a different question about the same cash. Static liquidity is a point-in-time snapshot of balances and liquid assets against current obligations, while dynamic liquidity layers in expected inflows and outflows over time.
The static view tells you where you stand this morning. Dynamic liquidity planning tells you which week a payroll run collides with a slow collections month.
| Dimension | Static liquidity | Dynamic liquidity |
|---|---|---|
| Question it answers | Where are we today? | When do we get tight? |
| Time horizon | A single point in time | The next 13 weeks, rolling |
| Data inputs | Account balances, liquid assets, current liabilities | Opening balances plus dated inflows and outflows |
| Best audience | Controller and treasury owner | CFO, CEO, and board |
| Update frequency | Every business day | Weekly, with a monthly summary |
Build the static view first, then extend it forward 1 week at a time.
What goes in a liquidity position report
A report for a non-bank operating company tracks six components. Give each one its own block of rows so anyone can trace a total back to its source.
Cash and cash equivalents by account
List each account on its own row with its balance and how fast you can get to the money.
- Operating checking: Available the same day for payroll, bills, and wires
- Reserve or savings accounts: Usually available same day or next day through an internal transfer
- Investment or money market balances: Often 1 to 2 business days to settle, depending on the holding
- Restricted cash: Escrow or collateral balances you can't spend, shown on a separate row
Tag every account with an access time so nobody counts a two-day balance as same-day cash.
Committed inflows
Only count money with a date and a named payer behind it.
- Receivables: Open invoices, dated by each customer's payment history
- Scheduled customer payments: Subscription billings and milestone payments with signed terms
- Confirmed financing: Loan draws or equity closings with a signed agreement and a funding date
Move anything without a date into the forecast block and keep it out of committed totals.
Committed outflows
Outflows are easier to pin down, since you control most of them.
- Payroll: Net pay, payroll taxes, and benefits, dated to the day funds leave your account
- Scheduled vendor bills: Approved bills by due date
- Debt service: Principal and interest payments on every facility
- Taxes: Estimated income tax payments and sales tax remittances
- Rent: Monthly lease payments and any common area charges
- Known one-off payments: Annual software renewals and equipment purchases
Date payroll to the funding date, which is often 1 to 2 business days before payday.
Available credit
Undrawn credit lines and card capacity get their own rows under cash.
- Undrawn line of credit: Total commitment minus the drawn balance, net of any borrowing base limits
- Card capacity: Card limits minus current balances and pending charges
Keep credit out of your cash totals so a drawn line never hides a falling balance.
Liquidity ratio line items
Show the current ratio, quick ratio, and cash ratio as single rows with a 3-month trend. Each row tracks one of the standard liquidity ratios and what its direction signals.
- Current ratio: Signals whether current assets cover current liabilities, with anything under 1.0 worth a note
- Quick ratio: Shows coverage once you strip out inventory and prepaid expenses
- Cash ratio: Shows how much of your current liabilities that cash alone could pay today
Report the trend next to each ratio, because a quick ratio that falls 3 months running matters more than any single value.
Runway and minimum cash threshold
Runway is closing cash divided by average monthly net burn, stated in weeks or months. Compare it with your minimum cash threshold, the balance you've agreed not to go below.
A practical floor is 8 to 12 weeks of operating expenses, set higher if revenue is seasonal. Show the gap between projected cash and the threshold in both dollars and weeks so leadership knows how much room is left.
How to build a liquidity position report in 6 steps
Each step feeds the next. Your audience sets the views, and the data you pull in steps 2 and 3 fills them.
1. Define the audience and the decisions the report supports
Start with who reads the report and what each reader decides. The CFO decides whether to move cash or draw on credit, while the CEO weighs hires and the board checks runway against plan.
Each audience needs a different level of detail and a different cadence. Those differences set the views you build in step 4.
| Audience | Decision they make | Detail level | Cadence |
|---|---|---|---|
| Controller or treasury owner | Which bills to release and when to move cash between accounts | Account and transaction level | Daily |
| CFO | Whether to draw credit, move reserves, or delay spend | Weekly totals by category | Weekly |
| CEO | When to commit to hires and large contracts | Lowest cash point and runway | Monthly |
| Board | Whether runway supports the plan and when to raise | Runway, ratios, and trend | Monthly or quarterly |
Write each reader's decision at the top of their view so every number on the page supports it.
2. Pull current balances from every account
Pull balances from every source at the same cutoff so the totals tie. Use prior-day closing balances pulled at a fixed time, such as 8 AM on business days.
- Operating bank accounts
- Payroll and other sub-accounts
- Reserve, savings, or investment accounts
- Money market fund or Treasury holdings
- Corporate card balances and pending charges
- Lines of credit and other credit facilities
Mark each balance as same-day or delayed, since some investment holdings take 1 to 2 business days to settle. Reconcile each pulled balance to the bank statement weekly to catch timing gaps early.
3. Map committed inflows and outflows by date
Pull accounts receivable (AR) aging for expected collections and your accounts payable (AP) schedule for bills due, then add payroll, taxes, and debt service. Keep committed items, like approved bills and signed contracts, apart from expected items like forecasted sales.
- Customer collections from AR aging
- Scheduled customer payments and confirmed financing
- Payroll and payroll taxes
- Approved vendor bills from your AP schedule
- Debt service
- Tax payments
- Rent and other fixed contract payments
- Known one-off payments
Your daily cash position report uses day-level dates, while the weekly view rolls the same items up by week. Leave expected items out of the committed block until a contract or approval backs them.
4. Set up daily, weekly, and monthly views
Build three views from the same data, one for each cadence. The daily liquidity report goes to the controller and treasury owner. The 13-week forecast goes to the CFO, and the monthly view goes to the CEO and board.
| View | What it shows | Who it's for | Update frequency | Key line items |
|---|---|---|---|---|
| Daily | Where cash ends today | Controller and treasury owner | Every business day by 10 AM | Opening balance, expected receipts, scheduled payments, projected closing balance |
| Weekly | Cash by week for the next 13 weeks | CFO | Every Monday by noon | Weekly inflows and outflows, closing cash, weeks flagged below the minimum threshold |
| Monthly | Trend in balances, ratios, and runway | CEO and board | By business day 5 | Month-end balances, ratio line items, runway, variance vs. last month's forecast |
Feed all three views from one source sheet so your liquidity reporting matches in every meeting.
5. Add scenarios you can act on
Run three scenarios on top of the weekly view using inputs an operator controls. For each one, track the lowest cash point and runway, then name the response.
| Scenario | Assumption you change | Effect on lowest cash balance | Effect on runway | Response |
|---|---|---|---|---|
| Slow collections | Customers pay 15 days past terms | Drops by about half a month of collections, usually in weeks 3 to 6 | Shortens until collections catch up | Draw on the credit line or push discretionary spend out 30 days |
| Delayed fundraise or financing | Funding date slips 90 days | Falls through weeks 10 to 13 with no inflow to offset burn | Measured on existing cash only | Pause open hires and cut discretionary spend |
| Large one-off payment | A tax bill or annual renewal lands earlier | Drops by the full payment in the week it lands | Shortens by the payment divided by monthly net burn | Move reserves to operating cash before the due date |
Agree on each response in advance so you act the week a scenario starts showing up in actuals.
6. Set thresholds, owners, and a review cadence
Set a minimum cash threshold, a trigger for action, and one owner for every input. Then fix the time each view goes out.
- Minimum cash threshold: 8 to 12 weeks of operating expenses, reviewed each quarter
- Action trigger: Any week in the 13-week forecast below threshold goes to the CFO within 1 business day.
- Data owners: One named person each for AR, AP, payroll, and bank balances
- Send times: Daily view by 10 AM, weekly view by Monday noon, monthly view by business day 5
- Variance check: Compare forecast to actual every week and flag gaps above 5% or $50,000.
Review the variance log each month and fix the category that misses most often.
Liquidity position report template
A working liquidity report fits on one spreadsheet tab with a column for today and one for each of the next 4 weeks. Use round example values while you test formulas, then replace them with live data.
| Line item | Today | Week 1 | Week 2 | Week 3 | Week 4 | Notes |
|---|---|---|---|---|---|---|
| Opening cash by account | $5,000,000 | $4,950,000 | $4,850,000 | $4,500,000 | $4,600,000 | Example values. 1 row per account in your sheet |
| Committed inflows | $50,000 | $300,000 | $250,000 | $400,000 | $200,000 | Dated collections and confirmed financing |
| Committed outflows | $100,000 | $400,000 | $600,000 | $300,000 | $600,000 | Payroll weeks run higher |
| Net cash flow | -$50,000 | -$100,000 | -$350,000 | $100,000 | -$400,000 | Inflows minus outflows |
| Closing cash | $4,950,000 | $4,850,000 | $4,500,000 | $4,600,000 | $4,200,000 | Opening cash plus net cash flow |
| Available credit | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | Undrawn line plus card capacity |
| Total available liquidity | $5,450,000 | $5,350,000 | $5,000,000 | $5,100,000 | $4,700,000 | Closing cash plus available credit |
| Minimum threshold | $3,200,000 | $3,200,000 | $3,200,000 | $3,200,000 | $3,200,000 | 8 weeks of operating expenses at $400,000 a week |
| Cushion above threshold | $1,750,000 | $1,650,000 | $1,300,000 | $1,400,000 | $1,000,000 | Closing cash minus threshold, credit excluded |
| Current ratio | 1.8 | Update monthly from the balance sheet | ||||
| Quick ratio | 1.4 | Update monthly from the balance sheet | ||||
| Runway | 6.6 months | 6.5 months | 6.0 months | 6.1 months | 5.6 months | Closing cash divided by $750,000 monthly net burn |
Extend the columns to 13 weeks once the first 4 reconcile to actuals.
Common mistakes when building a liquidity report
Most first versions break in one of three places. Each one is fixable in a single review cycle.
Mixing committed and forecasted cash
Treating hoped-for receipts like confirmed ones overstates your position. A $200,000 deal marked "likely to close" looks like cash right up to the week it slips. Keep forecasted items in their own block and leave them out of runway.
Reporting one view to every audience
The board doesn't need the daily view, and the controller can't run the week on a monthly one. One report for everyone means each reader has to dig for their number. Match each view to the reader's decision from step 1.
Never checking forecast against actual
Without a weekly variance check, errors compound and leadership stops trusting the numbers. A collections assumption that's off by 5 days each week can leave your week-13 balance far from the real number. Log forecast vs. actual every week and fix the assumptions behind the biggest gaps.
Act on your liquidity report with Ramp Business Banking
Your liquidity position report shows where cash stands and which week it gets tight. It doesn't move a dollar, so someone still has to shift funds before payroll or a large bill hits.
Ramp Business Banking keeps operating cash in the Ramp Business Checking Account¹ and longer-term reserves in the Ramp Business Investment Account.⁴ Cash Manager sets balance targets and low-balance alerts, then moves funds between the Checking Account¹ and the Investment Account⁴ as bills come due, following the targets you configure.
Each feature lines up with a step in your report:
- Set balance targets: Keep operating cash near the level your minimum threshold calls for.
- Get low-balance alerts: Know the moment the Checking Account¹ drops under the balance you set.
- Route transfers through approvals: Require CFO sign-off before Cash Manager moves funds between accounts.
- Spot committed outflows early: Approved bills in Bill Pay and committed PO spend in Budgets feed steps 3 and 5.
Ramp doesn't generate the liquidity report or calculate your ratios. You build those, and Ramp helps you act on what they show.
Try an interactive demo to see why more than 85,000 businesses use Ramp.
¹ Ramp Business Corporation is a financial technology company and is not a bank. Bank deposit services provided by First Internet Bank of Indiana, Member FDIC.
⁴ Investment account with portfolios managed by Moment Advisors, LLC. Investing involves risk, including possible loss of principal. Asset allocation does not guarantee profit or protect against loss. Past performance does not guarantee future results. Additional information can be found here. Securities products offered by Apex Clearing Corporation, member FINRA, SIPC. The Investment Account is not insured by the FDIC, not a deposit product, and may lose value.

FAQs
Liquidity reporting is the recurring practice of tracking cash, committed inflows and outflows, and runway on a set schedule. It shows whether your liquidity covers what's due over the next 13 weeks. Assign it an owner and a send time so it happens every week.
Collect receivables faster, negotiate longer payment terms with vendors, trim discretionary spend, and keep reserves you can reach within 1 to 2 business days. Start with collections, since every day you cut from days sales outstanding frees cash you've already earned.
Compare current assets, such as cash and receivables, against current liabilities due within 12 months. Dividing one by the other gives you the current ratio, one of several liquidity ratios worth tracking. A result above 1.0 means current assets cover short-term obligations.
Current ratio: Current assets divided by current liabilities. Quick ratio: Current assets minus inventory and prepaid expenses, divided by current liabilities. Cash ratio: Cash and cash equivalents divided by current liabilities. Track all three liquidity ratios as monthly trend lines in your report.
Update the daily view every business day, the 13-week rolling forecast weekly, and the leadership view monthly. Switch the CFO to a daily forecast when any week's cushion drops below 2 weeks of operating expenses.
“I want to trust the people at our sites to buy what they need, when they need it. With everything in Ramp, they have one place to go and one set of rules to follow. And I can see how all of their spending ties back to the contracts that fund their work.”
Marina Peterson
CFO, Wu Yee Children’s Services

“Finance isn’t just there to keep a record of the past. Are we negotiating with a retail partner? We have a seat at that table. Looking at a brand partnership? We have a seat at that table too. That’s really the big unlock: finance can be a strategic partner across the business, while Ramp keeps day-to-day work from pulling us away.”
Rachel Prescott
CFO, Caraway

“I assumed I would have to choose between speed and control. What I found is that you can have both. A well-designed system takes friction out, for the finance function and for everyone else.”
Justin Webster
CFO, Denver Broncos

“A well-run district should not have to choose between getting work done at the school site and keeping control of the dollars behind it. We're not hiring more people to do more jobs, so we have to be smarter about the process. With Ramp, the purchase, the receipt, and the record stay together from the start. ”
Nick Brizeno
Director of Purchasing, San Marcos Unified School District

“In senior living, scale only works if the communities still feel personal. We needed the back office to carry more of the complexity, not the people serving residents. Ramp helped us build that infrastructure, so the experience in the community could stay human.”
Ryan Cole
CFO, Agemark Senior Living

“AI is moving faster than the finance context around it. Prices change, models change, and the value is not always obvious from an invoice. We needed enough detail to know which bets deserved more investment — and which ones did not.”
Greg Cooley
Controller, AngelList

“Invoices, cards, tokens. The categories change but the principle doesn't: know where the money is going, remove the work around it, and make sure the spend is worth it.”
Maciej Mylik. Finance
ElevenLabs

“We weren’t trying to retrofit an old finance system. We had a blank canvas, and Ramp gave us the foundation to build a global finance function of the future.”
Justin Dourado
Director of Finance, Othership



