Spreadsheets often get a bad rap, painted as outdated tools that modern accounting practices should leave behind. Yet, as Dave Sellick demonstrated at the recent Growth Club Summit, when combined with smart automation and integrations, spreadsheets can become incredibly efficient month-end powerhouses.
Dave’s session outlined how to "appify" spreadsheets—essentially blending the flexibility of spreadsheets with the connectivity of modern web apps. This approach allows accountants to automate routine tasks, minimise errors, and scale personalised reporting easily.
Here’s your guide to transforming your spreadsheets based on Dave’s practical insights.
The "appification" of spreadsheets
Dave introduced the concept of "appifying" spreadsheets—turning them into intuitive, flexible applications. Rather than viewing spreadsheets as outdated, Dave suggests embracing their unique strengths.
“Appifying spreadsheets merges the best aspects of cloud apps with the flexibility and customisation of spreadsheets.” – Dave Sellick
Automating data extraction and uploads
Dave showcased using tools like G-Accon to pull unreconciled items directly from accounting platforms like Xero into spreadsheets, automating the tedious month-end data extraction process. This reduces manual input and significantly cuts down the risk of errors.
“Automating data extraction and uploads from spreadsheets can save substantial amounts of time each month.” – Dave Sellick
Leveraging API connectors
To seamlessly integrate spreadsheets with accounting systems and payroll platforms, Dave recommended API connectors like G-Accon and Mix Analytics’ API Connector. These tools bridge the gap, allowing accountants to pull and push data effortlessly.
“API connectors bridge the gap between your spreadsheets and any system with an open API, enabling sophisticated automation.” – Dave Sellick
Enhancing client collaboration with Slack
Integrating spreadsheets with Slack helps streamline client interactions, making collaboration quicker and clearer. Notifications and actions can be shared instantly, ensuring that issues are resolved faster.
“Integrating spreadsheets with Slack creates a collaborative, streamlined environment that significantly improves client interactions.” – Dave Sellick
Flexible, real-time reporting and forecasting
Dave illustrated how automated spreadsheets, using tools like Google Sheets and Excel's Power Query, deliver highly customisable, real-time reports and forecasts. These reports can be tailored precisely to client needs, ensuring relevance and accuracy.
“Using these automated spreadsheet tools, you can provide highly customised, real-time reporting and forecasting at scale.” – Dave Sellick
Your spreadsheet transformation action plan
• Evaluate month-end workflows: Identify repetitive manual data entry tasks that could be automated.
• Explore automation tools: Try out integrations such as G-Accon and API Connector to streamline data flows.
• Start small: Create a basic automated spreadsheet to pull data into your accounting system as a test case.
• Integrate collaboration tools: Consider linking spreadsheets with Slack to improve client communication.
Stay informed:
Follow Dave Sellick’s LinkedIn and upcoming community for ongoing tips and templates.
Final thoughts
Spreadsheets can do far more than basic number crunching. By combining them with automation, API connectors, and collaboration tools, you can create a month-end process that is faster, more accurate, and easier for clients to engage with. Follow Dave Sellick’s action plan, start with small changes, and build momentum as you see results. The path to efficient, appified spreadsheets is open to every firm willing to rethink how they work.
