You're offline, showing the last version we saved.

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.

Sponsored

Vinyl: client meetings, minuted, with actions in your workflow. Start for free.

Accounting

Was this useful?
Thanks — noted.
Free template

Get the editable month-end close checklist

A five-working-day month-end close for client files: cash, receivables, payables, payroll, GST, VAT and sales tax, adjustments, review and lock. Free with a firm profile: enter your email and we will send a code. No password. Read it in full first.

Have a password? Sign in

By continuing you agree to our terms and privacy policy.

Or build it with AI

Open Claude or ChatGPT with the prompt filled in. It writes the finished document for your firm straight away, then asks a few questions to tailor it. No client data needed.

Open in ClaudeOpen in ChatGPT

Works without client data. Don't paste client names, tax file numbers or ledgers into an AI tool your firm hasn't approved for them. AI data safety playbook.

Sponsored

Vinyl: client meetings, minuted, with actions in your workflow. Start for free.
Read next
Related
Listen next