Art Gallery Management - Artists, Artworks, Customers & Transactions

• Dashboard – Key performance indicators: revenue, profit, sales rate, debt, low inventory warnings, and overdue transaction alerts. Charts by material and status.
• Artwork List – Manage 500 artworks: status (Available / Sold / On hold / On loan), purchase price, selling price, profit margin %, display location, condition, and certification.
• Artist – 100 artist profiles: commission based on 3 models (consignment %, exclusive contract, outright purchase), automatic commission calculation, artwork count, and revenue.
• Transaction – 500 transactions: sales, consignment, returns. Track partial payments, debt, and overdue days. Automatically update the Artwork List.
• Customer – 100 customers: manage customer relationships with art preferences, membership levels, purchase history, and automatic total spending.
• Exhibition – 100 exhibition events: revenue, expenses, net profit, number of guests, participating artists, evaluation.
• Settings – 19 selection lists: material, theme, status, payment method, cooperation type, artist level…
• User Guide – 6-step data entry guide, code conventions, detailed process.
• Cover Page – Product cover page.

Design: 9 interconnected sheets in real-time. Sell artwork — automatically update status, record buyer, calculate artist commission. Color coding: blue = manual entry, yellow = configuration, green = automated.

• Gallery Owner – Manage artworks, artists, and transactions
• Art collector – Track personal collections, values, and locations
• Art Dealer – Manage consignments, commissions, payments
• Art Curator – Plan exhibitions, track loaned artwork
• Art Studio – Manage output products and customers

Scale: Art galleries with 50–500 artworks, 10–100 collaborating artists. Suitable for both physical and online galleries.

• Template file (.xlsx) — empty structure, ready to use
• Sample File (.xlsx) – includes sample art gallery data for reference
• 9 professionally linked sheets
• Pre-created and optimized Google Sheets template
• Detailed usage guide (Guide sheet)
• Available in both English and Vietnamese

• Minimum: Microsoft Excel 2016+ (Windows or Mac)
• Recommended: Excel 2021 or Microsoft 365
• Also compatible: Google Sheets (some advanced features may be limited — we recommend using the provided URLs in our package)

Do small art galleries with fewer than 50 artworks need this?
Yes. Even with few artworks, tracking artist commissions, customer debt, and transaction history requires a system. The template supports up to 500 artworks, allowing for future expansion.

Can consignment commission be tracked?
Yes. The Artist Sheet supports 3 models: consignment (gallery commission), exclusive contract, and outright purchase. Automatic artist commission calculation after each transaction.

Is there an English version?
Yes. Choose English or Vietnamese version when ordering. The product package includes both.

Technical support?
Email support@beup.space – free support for the first 30 days.