[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/08\/UrbanGlass.webp” alt=”UrbanGlass” title_text=”UrbanGlass” _builder_version=”4.17.4″ _module_preset=”default” width=”100%” max_width=”600px” max_height=”360px” border_radii=”on|12px|12px|12px|12px” box_shadow_style=”preset1″ box_shadow_horizontal=”6px” box_shadow_vertical=”0px” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
UrbanGlass is a leading artist-access glass center with a passion for connecting with creatives from all walks of life.<\/p>\n
UrbanGlass uses Sheetgo to automatically convert bookkeeping spreadsheets to PDF and disseminate via email. They used to spend 2 hours every fortnight on manual data distribution. With Sheetgo this has been reduced to just 30 minutes.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Needed a fresh alternative to IMPORTRANGE<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- Data-critical payroll and bookkeeping for multiple artists<\/li>\n
- Needed extra automation of Google Workspace solutions<\/li>\n
- Irregular payments caused significant manual entry<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
UrbanGlass was using Google Workspace but found IMPORTRANGE and syncing errors were causing issues with billing and payroll.<\/p>\n
This resulted in significant manual rework and gave their previous system a reputation for unreliability and inaccuracy.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” hover_enabled=”0″ border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}” sticky_enabled=”0″]\u201cSheetgo works! It is dependable, bullet-proof, and support is always there when you need it.\u201d<\/b><\/span><\/p>\n
Jeff Bush, Director of Finance, UrbanGlass<\/span><\/i>[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
UrbanGlass wanted a reliable, intuitive and reliable solution that would never let them down. They also wanted it to be highly automated to save time and reduce the likelihood of manual entry errors occurring.<\/p>\n
Because artists are only paid commission when a sale is made, significant manual time was spent making and processing irregular payments. Automating this process would save time and eliminate errors.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Smart bookkeeping using Sheetgo<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- Invoicing based around flexible variables, no presets<\/li>\n
- Glass artists need accurate biweekly payroll details<\/li>\n
- Departmental data automatically added to master budget <\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
UrbanGlass uses Sheetgo to automatically update their master budget by moving department data to the relevant input fields. By converting all docs to PDF, and automatically sending out payroll to the respective artist via Gmail, they can streamline data distribution throughout the business.<\/p>\n
Invoicing is now flexible and no longer based around restrictive preset variables as this is not reflective of how they work as a business. By automatically adding departmental data to the master budget, they can see at glance how the overall business is performing.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” hover_enabled=”0″ border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n
\u201cIt’s a god’s gift really, it works really well!\u201d<\/span><\/p>\n
Jeff Bush, Director of Finance, UrbanGlass<\/span><\/i><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
The Sheetgo solution allows each artist to be sent a fortnightly PDF via Gmail that itemizes where their money comes from: what they sold, their hourly rate, etc.<\/p>\n
They are also creating a second implementation to ensure irregular payments to artists are paid quickly and accurately, eliminating delays and errors due to manual entry constraints.<\/p>\n
[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
75% reduction in bookkeeping time<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- 2 hours a fortnight reduced to just 30 minutes<\/li>\n
- No more manual entry errors or delays due to manual correction<\/li>\n
- Data readily available to key decision makers<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Sheetgo enables UrbanGlass to reduce their bookkeeping time by 75%, giving them back 3 hours a month to spend on higher value tasks.<\/p>\n
They have also been able to move beyond the uncertainty and lack of information the artists had about their payrolls.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]<\/p>\n
\u201cIn the past, I devoted 2 hours every 2 weeks just to do payroll. Now because of Sheetgo and other Google Sheets improvements it’s down to half an hour.\u201d<\/span><\/p>\n
Jeff Bush, Director of Finance, UrbanGlass<\/span><\/i><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
By using Sheetgo, UrbanGlass is now able to reduce their bookkeeping time by 3 hours per month while eliminating manual entry errors. This has resulted in a much more accurate master budget that\u2019s always up to date and reflective of the true performance of the business.<\/p>\n
They have also laid the groundwork for an automated artist reimbursement function that will allow them to pay commissions at irregular intervals.<\/p>\n
[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/08\/UrbanGlass-logo-1.webp” alt=”UrbanGlass logo” title_text=”UrbanGlass logo 1″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” width=”200px” max_width=”200px” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
UrbanGlass fosters experimentation and advances the use and critical understanding of glass as a creative medium. They were the first, and now the largest, artist-access glass center in America.
<\/span><\/p>\n[\/et_pb_text][et_pb_icon font_icon=”||fa||900″ icon_width=”16px” align=”left” _builder_version=”4.16″ _module_preset=”default” custom_margin=”|20px|10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” width=”85%” custom_margin=”||10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]<\/p>\n
New York, United States of America<\/span><\/p>\n
[\/et_pb_text][et_pb_icon font_icon=”||fa||900″ icon_width=”16px” align=”left” _builder_version=”4.16″ _module_preset=”default” custom_margin=”|20px|||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” width=”85%” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]https:\/\/urbanglass.org\/<\/span><\/a>[\/et_pb_text][et_pb_divider _builder_version=”4.16″ _module_preset=”default” custom_margin=”||20px||false|false” global_colors_info=”{}”][\/et_pb_divider][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Industry<\/strong>
Glass manufacturing
<\/span><\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]Features used<\/strong><\/span><\/p>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-google-sheets.svg\")
Google Sheets<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/icon-split.webp\")
Split<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/icon-filter.webp\")
Filter<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/08\/icon-generate-doc.webp\")
Google Docs<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/08\/icon-generate-pdf.webp\")
PDF<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/08\/icon-send-mail.webp\")
Gmail<\/div>\n[\/et_pb_text][\/et_pb_column][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
UrbanGlass: Automated bookkeeping and payroll management with SheetgoSheetgo is the no-code spreadsheet automation platform that turns the data your team already keeps in Sheets, Excel, and CSVs into pipelines, dashboards, and AI-ready datasets.UrbanGlass is a leading artist-access glass center with a passion for connecting with creatives from all walks of life. UrbanGlass uses Sheetgo to […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":6600,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"difl_page_category":[],"class_list":["post-228133","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/228133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=228133"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/228133\/revisions"}],"predecessor-version":[{"id":260772,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/228133\/revisions\/260772"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/pages\/6600"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=228133"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/difl_page_category?post=228133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}