Belongs to the sale
Date · Revenue · Sale type
Clipping
Stock footage sales tracking that stops asking you to retype the same clip twelve fields at a time.
The problem
A sales spreadsheet has fifteen columns, but only three of them describe a sale.
Belongs to the clip
Name, vertical, editorial, resolution, category, sub-category,
camera, curator, country, owner, people — and ~48 keywords
In a spreadsheet
Every re-sale repeats all twelve clip columns, because a
flat sheet has nowhere else to keep them.
In Clipping
The clip is entered once. A sale is a clip,
a date and an amount.
Recording a sale
N → type part of the clip name → ↵ → type the amount → ↵. Focus returns to the search box, so a morning's worth of sales is one continuous run.
Fuzzy clip search
“sg gard” finds the Gardens by the Bay clips. Repeat sellers rank first, with their sale count and lifetime revenue alongside.
Names fill in the blanks
A new clip called SG_…05 - Vertical already knows it is
Singapore and vertical. If a sibling in the same numbered series exists,
one click copies the rest.
Keywords, capped
Paste the whole comma list. Duplicates drop out, the counter stops at 49, and past entries autocomplete.
What the spreadsheet could not tell you
Revenue per curated clip
Divides each curator's earnings by how many clips they keyworded — so a small, effective curator stops being hidden behind a large one.
Volume without value
Share of revenue against share of sale count, side by side, on one axis. Discount packs show up immediately.
Clips that never sold
Invisible in a sales sheet — a clip only appears there once it has already earned. Add the catalogue and the dead inventory becomes visible.
Installing
This build is not signed with an Apple Developer certificate, so
macOS will refuse it on first open. That is Gatekeeper reacting to the missing
certificate, not to anything wrong with the app. It takes one extra click, once.
- Open the downloaded
.dmgand drag Clipping into Applications. - Right-click (or Control-click) the app in Applications and choose Open — do not double-click it the first time.
- Click Open again in the dialog. macOS remembers the choice; from then on it opens normally.
- If macOS says the app is “damaged”, run once in Terminal:
xattr -dr com.apple.quarantine /Applications/Clipping.app
Your data
Everything lives in one SQLite file on your Mac. Nothing is uploaded, and the app works with the network off.
Starts with your spreadsheet
Drag the .xlsx onto the window on first launch. Every
worksheet is read — a workbook with a tab per year contributes all of
them. Repeated clips collapse into one library entry, 4k and
4K merge, and each sheet's SUM row is recognised rather than
imported as a sale.
Nothing is written until you confirm
You get a full count first — rows read, new clips, sales to create, and anything skipped with the reason. Running it twice is safe: clips are matched by name rather than duplicated.
Export any time
Writes the original column layout back out, so anyone expecting the old file still gets it. Plus a one-click database backup.