ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Multi-Artist Sales Report
2
3
Use this workbook to track sales for multiple artists in one file. Add artist names on the Lists sheet, then enter each sale on the Sales Entry sheet.
4
5
Quick steps
6
1. Add or edit artist names in Lists!A2:A26.
7
2. Enter each transaction in Sales Entry. Artist name has a dropdown.
8
3. Artist report tabs were generated for the current artist list and update automatically from Sales Entry.
9
4. Review totals by artist in Artist Summary or open each artist tab for a printable statement.
10
11
SettingValue
12
Gallery Commission Rate10%
13
Default Reporting Period
14
Default Payment Method
15
NotesSquare processing fees should be entered per sale.
16
Artist report tabsCreated for the artist names that currently appear on Lists!A2:A26.
17
Adding new artists laterAdd the artist to Lists, then duplicate an existing artist report tab or ask for a true Google Apps Script version for automatic tab creation.
18
Best practiceEnter sales only on Sales Entry. Do not type directly into the artist report tabs.
19
20
Artist report tabs now use FILTER to pull matching sales rows from Sales Entry.Artist report detail tabs now use Excel/Google-Sheets-friendly formulas instead of FILTER spill formulas.
21
If a tab looks blank, confirm the artist name in B2 matches the Sales Entry artist name exactly.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100