Module 2 · CashLens

Know your cash today, and 13 weeks ahead.

Upload your bank statements and a list of your customers and suppliers. CashLens shows where every dollar came from and went, forecasts your balance day by day, and warns you weeks before cash falls below your minimum.

CashLens forecast with minimum cash warning, key figures and daily cash chart

Sample company data. Amounts in USD.

Reads statements from any bankin ExcelCSVor PDF, in any currency
See it in action

CashLens in one minute.

From bank statements to a checked cash summary and a 13-week forecast, shown with a demonstration company.

What you get

Your cash, explained and planned.

Actual cash summary

Receipts and payments by category for every month, with opening and closing cash and exchange differences.

Customers and suppliers

Every bank line matched to a party, so you see who paid you, whom you paid and your top 10 of each.

Minimum cash warning

Set the lowest balance you're comfortable with. CashLens tells you when cash comes close or falls below it.

13-week and 12-month forecast

Usable cash day by day from your open receivables, payables, budget, loans and regular costs.

Collection analysis

How fast each customer pays, the share paid on time and what is overdue now.

Excel pack

The cash summary, the forecast and every item behind it, ready to share with the owner or board.

A closer look

From bank statements to decisions.

Where your cash came from and went

A bridge from opening cash to cash available above your minimum, the month-end balance against your minimum, and cash received and paid by month.

  • Every chart has a one-line takeaway
  • Top 10 customers and suppliers by cash
  • Plain-English list of what needs attention
Cash overview charts: cash bridge, balance against the minimum, and cash received and paid by month

Every receipt and payment, by category

The actual cash summary for each month, with closing cash. Click any line to see it by customer or supplier.

Actual cash summary by category and month

A 13-week forecast you can trace

Cash in and cash out by category for each week, or by month for 3, 6 or 12 months. Click a line to see the invoices, bills and items behind it.

  • Built from your own receivables, payables and budget
  • Rent, salaries and other regular costs from your bank history
  • Recurring and one-off costs shown separately
13-week cash forecast table by category and week

How fast each customer really pays

Collection days for every customer, weighted by amount, the trend by month, and the share of each customer's payments that arrived on time.

Collection analysis with collection days by customer

Fix gaps and try options

Overdue or undated items are listed, never silently left out. Change one item with a reason, spread a supplier's bills, or try a scenario without touching your main forecast.

  • Save versions and compare them with actual cash
  • Viewer, editor and approver roles
Forecast review page listing exceptions

Checked before anything is built

Every statement must tie out: opening balance plus the bank lines equals the closing balance, with no gaps between months. Foreign currency months need a rate, and every bank line is matched.

Cash checks page with every check passing

On your phone too

Your cash position and forecast in any browser, on desktop, tablet or phone, with the same sign-in as LedgerLens.

CashLens forecast on a phone
How it works

Three steps each month.

Upload

Download the month's bank statements and upload them, with your open receivables and payables for the forecast.

Check

CashLens ties out every statement, matches every bank line and lists anything the forecast is missing.

Plan

Read the warning, clear the exceptions, try options and download the Excel pack.

Accuracy

Calculated, not guessed.

Every figure is calculated by tested code from your own statements and files. If the forecast is missing something, such as a date for an overdue invoice, it says so and marks itself Provisional until it's fixed.

Security

Your company only.

Each client login sees only its own company. Passwords are stored as salted hashes, the app runs over HTTPS, and your data is never shared or used to train anything.

See CashLens on your own bank statements.

Send us a few months of statements and your open items, and we'll set up a pilot so you can judge the result yourself.