Use case

Finance questions,
answered from your sheets

Budgets, expense logs and revenue roll-ups often live in Google Sheets. Share them with wuup as a viewer and ask for budget vs actual, the fastest-growing cost or a month's variance; answers come as tables that cite the tab and range they read.

Who it's for

Finance leads, founders and accountants who report from Google Sheets

Sources

  • Google Sheets: Budget
  • Google Sheets: Expenses
  • PDF: board pack

The problem today

  • Month-end questions mean rebuilding the same formulas.
  • Variance explanations live in someone's head.
  • Numbers in a board pack PDF can't be cross-checked quickly.

Six questions,
and what wuup does

Ask in plain English. Here is what happens behind each answer, including the query when there is one.

  1. 01

    What's budget vs actual by department?

    Reads both tabs, joins on department and computes the variance.

    Reads: Budget!A1:N40 and Actuals!A1:N40

  2. 02

    What are the top expense categories this quarter?

    Filters the quarter's rows and sums by category.

    Reads: Expenses!A1:F480 (Date, Category, Amount)

  3. 03

    Which costs grew fastest?

    Compares month totals per category and ranks the change.

    Reads: Expenses!A1:F480

  4. 04

    How much did we pay each vendor?

    Groups expense rows by vendor and totals them.

    Reads: Expenses!A1:F480 (Vendor, Amount)

  5. 05

    What's the revenue run rate?

    Reads the latest month from the Summary tab and annualises it.

    Reads: Summary!A1:D13

  6. 06

    Does the board pack match the sheet?

    Reads the figures cited in the PDF and compares them with the sheet, citing both.

    Reads: Board-pack-Q3.pdf passages + Summary!A1:D13

From question
to answer

  1. 1

    Share the finance sheets

    Viewer access for wuup's service account.

  2. 2

    Ask the month-end questions

    "Budget vs actual by department for September."

  3. 3

    Cross-check the board pack

    Upload the PDF and ask whether its figures match the sheet.

Why it works
for this job

Variance in one question

wuup lines up budget and actual tabs by their headers and computes the difference.

Sheets and PDFs together

Cite the board pack and the sheet in the same answer.

Range on every answer

Auditors and colleagues can open the exact cells behind a number.

What changes

  • Month-end questions answered in minutes.
  • Cross-checks between documents and sheets.
  • A clear trail from every number to its cells.
How the connector works

Questions,
answered

Bring the data.
Ask the question.