Skip to content
cccskills
FreePublished on GitHub

automate-finance-reporting

Use to connect a number source, map an export into the finance ledger, or QA a sheet: the column mapping, the dedupe key, the load summary, and the checks that must pass before a read ships.

The English summary is being prepared. Showing the original description.

Run score Not tested

See how to install

Files included (1)

  • SKILL.md2.5 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Automate finance reporting

Run this when numbers have to move from somewhere else into the finance ledger, or when a sheet needs checking before anyone reads from it. A number that arrives unchecked is not a fact yet.

Inputs

The source — a sheet, a saved query export from the business intelligence (BI) workspace, a report email, or a plain export file — and the target ledger shape.

Map the columns before loading anything

Source column to ledger column, one row per mapping, with the transform written out next to it. Unmapped columns get listed, not dropped silently. Show the mapping table before the first load, not after.

Dedupe on a natural key

Replace on the natural key — date plus line plus source — newest wins. Log how many rows were replaced so the load is auditable afterwards.

Derive ratios in the open

Write the formula next to the value on first build. Unparseable rows go to a needs-a-look list with their row numbers; they never land in the totals.

QA every write with a live re-read

Row counts match, rollups reconcile to the source total, and dates cover the period claimed. If any check fails, say which one and hold the read. A read shipped on a failed check is worse than a late read.

Name the refresh path

What triggers the refresh, who owns the source, and what stale looks like. A ledger older than its own refresh promise gets called stale in every read that uses it.

Keep the automation boring

One source of truth, one writer per sheet, and a dated snapshot before any structural change. Clever automation is the thing that breaks quietly in month four.

Output

The mapping table, the load summary with its counts and the needs-a-look list, and the QA result with each check named.

Fallbacks

A connector fails: take the export path and keep the same mapping and the same QA. The source has no usable key: build the read in chat only and do not write the ledger — a load you cannot dedupe will double a number later.

Approval gate

Structural changes to a sheet, new writers, and anything that leaves the team wait for the owner's yes.

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Use when a support account wobbles or a quarterly business review looms: read the health signals, run the success plan, and prep the review from evidence.

The English summary is being prepared. Showing the original description.

Significant-Gravitas/skills-catalog2Updated Oct 22, 2026

Reconcile accounts by comparing GL balances to subledgers, bank statements, or third-party data. Use when performing bank reconciliations, GL-to-subledger recs, intercompany reconciliations, or identifying and categorizing reconciling items.

The English summary is being prepared. Showing the original description.

Significant-Gravitas/skills-catalog2Updated Oct 22, 2026

Review open receivables and draft factual, staged payment follow-ups without inventing status or contacting a customer.

The English summary is being prepared. Showing the original description.

Significant-Gravitas/skills-catalog2Updated Oct 22, 2026

Write ad variants that each test one idea, within platform limits and supported claims.

The English summary is being prepared. Showing the original description.

Significant-Gravitas/skills-catalog2Updated Oct 22, 2026

Use on the first conversation with Alex, or whenever their memory has no product preferences yet: learn what the user is building and who for, where specs, roadmap and numbers live, who decides dates and scope, and get them to a first real product deliverable.

The English summary is being prepared. Showing the original description.

Significant-Gravitas/skills-catalog2Updated Oct 22, 2026

Use when a strategic alliance needs joint selling governance: operating model, joint targeting, steering prep, and milestone accountability.

The English summary is being prepared. Showing the original description.

Significant-Gravitas/skills-catalog2Updated Oct 22, 2026

See all skills by Significant-Gravitas

Report a problem with this skill