@dkuhn_art Have you exported your last year’s sales and totaled them (price column) in a Google Spreadsheet? You can also view and total any shipping, sales tax, DPW auction commissions, and PayPal fees paid.
I suspect the discrepancy you are seeing in last year’s sales totals between DPW and PayPal is due to either not having all of last year’s sold art marked as sold in DPW and/or having some of the sold dates not being correct. If you were paid for a work last year then PayPal will include that in their total, however if the work has a sold date in DPW other than in last year, then it won’t be in your DPW total.
The export feature (from theExport drop down in the toolbar above your Art Tracking Grid) will export all the art currently in your Art Tracking Grid. To view and export last year’s sales, run a search using the search panel to the left of the grid, which may be collapsed.
Select the following in the search panel:
- Search On Date: Sold
- Date Range: Last Year
- Sold Status: yes
Then click the Search button.
Now your grid will have just the work that is sold with a sold (artwork status change) date in last year.
Finally, click on the Export drop down above the grid and select the Export my Artwork & Sales (for Taxes, etc.) item. Click the Export button and save the file to your computer.
From there you can open it in a spreadsheet program, such as Excel or Google Sheets, and total the Price, Shipping, and Sales Tax columns and add them up.