ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
ARTSMART CALCULATOR TEMPLATE
3
4
PLEASE MAKE SURE TO COPY AND SAVE UNDER A NEW NAME FIRST!
5
6
7
8
9
10
11
12
ARTSMART CALCULATOR INSTRUCTIONS:
13
14
When you get to the ArtSmart Calculator Googlesheet, please create a copy and rename it for your private use.
15
16
17
Step 1: UNDERSTAND the scenario and SAVE for future reference
18
19
You are invoicing a gallery for your portion of a sale.
20
Enter the Title and Save so you can refer back to complex calculations in the future.
21
Only enter amounts in the cells highlighted Yellow.
22
23
24
Step 2: RETAIL PRICE
25
26
Enter the Retail Price of the work in cell C14
27
28
29
Step 3: DISCOUNT
30
31
Enter the Discount as a percentage in cell B15
32
33
34
Step 4: PRODUCTION
35
36
Enter the amount the gallery paid towards production / frame in cell C17. Enter as a negative number. If nothing was paid enter a zero.
37
38
Enter the amount the gallery paid towards production / frame in cell C18. Enter as a negative number. If nothing was paid enter a zero.
39
40
41
Step 5: COMMISSION SPLIT 50/50
42
43
Typical gallery / artist commission split is 50%. If the split is not 50/50 then enter the percentage due to the artist.
44
45
46
Step 6: TOTALS SHOUD EQUAL
47
48
Totals on cells C22 and E22 should equal.
49
This is the amount that will go on the Artist Invoice to the gallery. And this should match the amount due to the artist on the corresponding Artist Statement sent from the gallery to the artist.
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