What bookkeeping software is best for art galleries?
QuickBooks Online is the most practical choice for most art galleries. It handles core bookkeeping needs, integrates with common payment processors, and makes working with a bookkeeper straightforward.
That said, gallery bookkeeping has quirks that general software doesn’t address out of the box. Consignment artwork, artist payouts, and tracking individual pieces all require thoughtful setup. The software matters less than how it’s configured for your specific operations.
Consignment sales present the biggest challenge. When you sell a piece on consignment, you don’t recognize the full sale amount as revenue. You record your commission only. The rest belongs to the artist and needs to be tracked as a payable until you remit it. QuickBooks handles this fine, but the transactions need to be recorded correctly. Getting this wrong inflates your reported revenue and understates what you owe.
Artist 1099 reporting at year end requires tracking every payout throughout the year. Any QuickBooks bookkeeper in Santa Fe will tell you the same thing. Set up each artist as a vendor from the start and categorize payments properly. Trying to reconstruct this in January is tedious and error-prone.
Inventory tracking for unique pieces works differently than tracking products with SKUs. Some galleries skip formal inventory tracking and just record purchases and sales as they happen. Others want to track each piece by title and artist. QuickBooks supports both approaches, though detailed piece-by-piece tracking adds administrative work that may not be worth it for smaller operations.
Gallery-specific software like Artlogic, ArtBase, or Artwork Archive handles consignment and inventory tracking natively. These tools are built for gallery operations but vary in their accounting capabilities. Many galleries use specialized software for gallery management alongside QuickBooks for actual bookkeeping. This creates some duplicate data entry but keeps the financial records clean.
For most small to mid-sized galleries, QuickBooks Online works well when configured correctly. The key is proper QuickBooks setup from the start. That means a chart of accounts that reflects gallery operations, vendor records for every consigning artist, and clear processes for recording different types of sales. Starting with professional configuration saves you from building problems into your records that become expensive to fix later.
Santa Fe's Small Business Bookkeeper
The Next Step:
A Quick Conversation
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
How do I handle fluctuating income from seasonal rentals?
Build cash reserves during peak season to cover slow months, budget based on annual income rather than monthly, and track patterns year-over-year so you can predict and plan instead of react.
Read answerWhat reports should a construction company run monthly?
Construction companies need job cost reports, work in progress reports, AR aging, and profit and loss by job. These reports show profitability by project instead of just overall revenue.
Read answerWhat bookkeeping mistakes do landlords commonly make?
Landlords often commingle personal and rental funds, fail to track income and expenses by property, and misclassify repairs versus capital improvements. Security deposit handling and depreciation tracking also trip up many property owners.
Read answerWhat bookkeeping mistakes do contractors commonly make?
The biggest mistake is not tracking costs by job, which makes it impossible to know which projects actually make money. Other common errors include mixing personal and business expenses, mishandling subcontractor 1099s, and waiting too long to reconcile accounts.
Read answerHow do I track fuel costs and mileage for my trucking business?
Fuel cards capture purchase data automatically, while ELD or GPS systems track mileage by truck and by state. Organize everything by unit number so you can calculate cost per mile and have clean records for IFTA reporting.
Read answerHow often do I need to file GRT returns in New Mexico?
Your GRT filing frequency in New Mexico depends on your average monthly tax liability. Most small businesses file monthly or quarterly, though semi-annual and annual options exist for lower-volume operations.
Read answer



