Managing art galleries with Excel – from artworks to transactions, without missing artist commissions

3 min read

An art gallery in Hanoi with around 200 artworks from 15 collaborating artists sold 8 pieces in the last quarter. The revenue looks impressive on paper. However, when recalculating, the gallery owner discovered: 2 pieces were sold but not yet paid for by customers, 1 piece had incorrect artist commission due to confusion between consignment and outright purchase models, and 3 artworks were on hold for VIP customers but no one remembered when.

Operating an art gallery is more complex than regular retail because each product is unique, each artist has a different commission agreement, and each customer requires long-term relationship building.

3 artist commission models – one mistake can lead to permanent loss of credibility

Each model generates different cash flows. With consignment, galleries don't invest capital but must pay artists after each transaction. With outright purchase, galleries invest upfront and need to know the exact markup percentage and inventory time. Errors in commission calculations aren't just financial issues – they break trust with artists.

Artworks are not ordinary goods — each piece is unique

Unlike retail where each product has a SKU and quantity, art galleries manage unique items. Each artwork has its own attributes: artist, medium, size, year created, condition. The status is also complex: Available, Sold, On Hold, On Loan.

When the scale exceeds 100 artworks, remembering the status of each piece becomes impossible. The inventory system needs to allow filtering by status, artist, medium — and warn when a piece is on hold for too long.

Gallery customers do not buy on impulse — they need nurturing

Buying artwork is not like buying clothes. Gallery customers consider carefully, return multiple times, and decide based on their relationship with the gallery. Gallery CRM should track: art preferences, purchase history, total spending, and membership level. When artist A has a new piece that matches customer B's preferences, the gallery can proactively contact them.

Frequently asked questions

Do small galleries with fewer than 50 artworks need a management system?

Yes. Even with few artworks, tracking artist commissions across 3 different models, customer debt, and the status of each piece requires a system. The template supports up to 500 artworks.

Can consignment commission be tracked?

Yes. Sheet Artists allows setting up a gallery commission % for each artist. When a sale is recorded, the system automatically calculates the payout for the artist. It supports 3 models: consignment, exclusive contract, and outright purchase.

Is there an English version?

Yes. Choose English or Vietnamese version when ordering. The bundle includes both.

Reference: Magnus Resch — Art Gallery Management (2018)