Updated:

How to build a liquidity position report in 6 steps

Explore this topicOpen ChatGPT

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.

DimensionStatic liquidityDynamic liquidity
Question it answersWhere are we today?When do we get tight?
Time horizonA single point in timeThe next 13 weeks, rolling
Data inputsAccount balances, liquid assets, current liabilitiesOpening balances plus dated inflows and outflows
Best audienceController and treasury ownerCFO, CEO, and board
Update frequencyEvery business dayWeekly, 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.

AudienceDecision they makeDetail levelCadence
Controller or treasury ownerWhich bills to release and when to move cash between accountsAccount and transaction levelDaily
CFOWhether to draw credit, move reserves, or delay spendWeekly totals by categoryWeekly
CEOWhen to commit to hires and large contractsLowest cash point and runwayMonthly
BoardWhether runway supports the plan and when to raiseRunway, ratios, and trendMonthly 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.

  1. Customer collections from AR aging
  2. Scheduled customer payments and confirmed financing
  3. Payroll and payroll taxes
  4. Approved vendor bills from your AP schedule
  5. Debt service
  6. Tax payments
  7. Rent and other fixed contract payments
  8. 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.

ViewWhat it showsWho it's forUpdate frequencyKey line items
DailyWhere cash ends todayController and treasury ownerEvery business day by 10 AMOpening balance, expected receipts, scheduled payments, projected closing balance
WeeklyCash by week for the next 13 weeksCFOEvery Monday by noonWeekly inflows and outflows, closing cash, weeks flagged below the minimum threshold
MonthlyTrend in balances, ratios, and runwayCEO and boardBy business day 5Month-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.

ScenarioAssumption you changeEffect on lowest cash balanceEffect on runwayResponse
Slow collectionsCustomers pay 15 days past termsDrops by about half a month of collections, usually in weeks 3 to 6Shortens until collections catch upDraw on the credit line or push discretionary spend out 30 days
Delayed fundraise or financingFunding date slips 90 daysFalls through weeks 10 to 13 with no inflow to offset burnMeasured on existing cash onlyPause open hires and cut discretionary spend
Large one-off paymentA tax bill or annual renewal lands earlierDrops by the full payment in the week it landsShortens by the payment divided by monthly net burnMove 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 itemTodayWeek 1Week 2Week 3Week 4Notes
Opening cash by account$5,000,000$4,950,000$4,850,000$4,500,000$4,600,000Example values. 1 row per account in your sheet
Committed inflows$50,000$300,000$250,000$400,000$200,000Dated collections and confirmed financing
Committed outflows$100,000$400,000$600,000$300,000$600,000Payroll weeks run higher
Net cash flow-$50,000-$100,000-$350,000$100,000-$400,000Inflows minus outflows
Closing cash$4,950,000$4,850,000$4,500,000$4,600,000$4,200,000Opening cash plus net cash flow
Available credit$500,000$500,000$500,000$500,000$500,000Undrawn line plus card capacity
Total available liquidity$5,450,000$5,350,000$5,000,000$5,100,000$4,700,000Closing cash plus available credit
Minimum threshold$3,200,000$3,200,000$3,200,000$3,200,000$3,200,0008 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,000Closing cash minus threshold, credit excluded
Current ratio1.8Update monthly from the balance sheet
Quick ratio1.4Update monthly from the balance sheet
Runway6.6 months6.5 months6.0 months6.1 months5.6 monthsClosing 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.

Try Ramp for free

¹ 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.

Share with
Ali Mercieca•Finance Writer and Editor
Ali is a finance writer, editor, and SEO strategist. In addition to working with the Ramp team, Ali worked with Robinhood on the editorial strategy for their financial literacy articles and with Nearside, an online banking platform, overseeing their banking and finance blog. Ali holds a B.A. in Psychology and Philosophy from York University and writes about editorial content strategy and SEO on her Substack.
Ramp is dedicated to helping businesses of all sizes make informed decisions. We adhere to strict editorial guidelines to ensure that our content meets and maintains our high standards.

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

How Wu Yee keeps 12 Head Start sites on one grant plan, one purchase at a time

“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

How cutting 20 days from close helped give Caraway’s finance team a seat at every table

“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

What it takes to pay for an NFL season: inside the Denver Broncos’ finance rebuild

“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

San Marcos Unified gives maintenance teams room to act — and finance a clear record of their spend across 19 schools

“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

How the family-owned business behind 28 senior living communities rebuilt finance to close 19 days faster

“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

From purchase requests to 409 API keys: How AngelList puts spend under owner-level control

“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

ElevenLabs speaks more than 70 languages but its money speaks the same one

“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

How Othership’s first finance hires built one operation across Canada and the U.S.