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
Should artists hire a bookkeeper?
Artists with gallery sales, consignment inventory, and irregular income often reach a point where professional bookkeeping pays for itself in time saved and taxes handled correctly.
Read answerWhat documents do I need to catch up my books?
Bank statements are the essential foundation for any catch-up project. Add credit card statements, payment processor records, and whatever invoices or receipts you have. Missing some documents shouldn't stop you from getting started.
Read answerHow do I calculate cost per mile for my trucking business?
Add up every expense tied to running your truck and divide by total miles driven. The challenge is capturing all costs, not just the obvious ones like fuel and maintenance.
Read answerDo I need separate bookkeeping for each short-term rental?
It depends on your legal structure. If each property is in a separate LLC, yes. If they're all under one entity, you can use one set of books with class tracking to see each property's performance individually.
Read answerHow do I set up payroll for my small business?
Setting up payroll requires a federal EIN, New Mexico state tax registration, unemployment insurance registration, and W-4s from employees. Most small businesses use payroll software or outsource to handle calculations and compliance automatically.
Read answerHow do I track maintenance and repair costs by truck?
Use classes, tags, or locations in your accounting software to assign each maintenance expense to a specific truck. Capture the truck number, mileage, and repair type for every expense so you can run reports showing total costs per vehicle.
Read answer
