The best of both worlds – combining Excel and Silverfin

The best of both worlds - combining Excel and Silverfin
7min Read

Look, we get it. Not every accountant out there is ready to ditch their trusted, proficiently built spreadsheets. In fact, 1 in 6 UK accountancy firms still recommend Excel for their clients to keep track of their bookkeeping.

Well, at least they were in 2019 – which is when research consultants at Censuswide carried out that survey. But we’re sure some firms still use Excel.

It might surprise you, but many of our clients do as well. And we don’t blame them. Excel is still a useful, versatile programme, and for many of them it’s the first tool they mastered – and the one their clients are familiar with.

Interestingly, they understand where Excel performs well for them, and keep using it to enhance support in specific, niche cases. Combining it with Silverfin, they’re leveraging the strengths of both tools. Smart, right?

Striking the right balance for your firm

Clients who want to make the most out of the winning combo usually do so by using Excel to support their core Silverfin records. This way, they can leverage the comprehensive benefits of Silverfin (such as standardised working papers, cloud access and automation) while still accommodating specific client needs with customised Excel schedules.data synchronisation.

Read more: Moving beyond Excel for working papers – an introduction

Answer to unique requirements

Silverfin is designed to handle 100% of client files, ensuring accuracy and compliance across the board. For clients with bespoke needs or specific workflows, Excel can be utilised to create custom schedules that complement the Silverfin core records.

This integration allows for extensive customisation without sacrificing the streamlined efficiencies provided by Silverfin.

Add-ons to client files

If a client prefers a particular format for their fixed asset register, complex and customised Excel sheets can easily be attached to the client file within Silverfin.

This approach maintains the integrity and accessibility of Silverfin while incorporating the use of Excel.

Excel in your workflow

Once you get started with Silverfin, Excel can still play a role in your life for bespoke calculations and custom schedules.

However, it’s worth considering whether these are genuinely necessary or remnants of past habits and inefficient processes. Silverfin’s robust features may render many of these Excel uses obsolete.

It’s all about the journey

Change is most effective when implemented gradually, step by step. So, we recommend starting with the most significant, simplest changes to see immediate gains. Evaluate how Silverfin performs for your firm and, as you experience its benefits, continue migrating more processes. Our per-file pricing model supports this gradual transition, ensuring you only pay for what you use.

One of our clients recently talked about this type of journey:

“WE LET SILVERFIN SOFTWARE HANDLE THE HEAVY LIFTING”

“From the beginning of our journey with Silverfin, we knew we wanted working papers and accounts production to be seamlessly integrated. Now, we’re continuing our journey to include corporation tax as well, all within one product. The idea is to duplicate less work by doing everything within the same system. It’s all nicely linked, and if we need to export information out of Silverfin, we can reimport it into QuickBooks easily.

There’s also another crucial aspect we wanted. I’m talking about the triggers enabled by the Silverfin Insights functionality. Although we haven’t started using them extensively yet, these triggers allow us to set metrics. For instance, if a client’s cash balance drops below a penny, it can trigger an alert, prompting us to offer additional services like cashflow management or advice. Similarly, if a director’s loan account is overdrawn, it can alert us to consider the risk and take necessary actions.

The prospect of all these functionalities prompted our step-by-step journey, as we wouldn’t have gotten this with Caseware. We aim to use Silverfin software to handle the heavy lifting, rather than hiring more people to do that work.” Martin Bugg, Partner at Larkin Gowen

Key functionality using Excel or Silverfin across key

Wrapping things up

Why the time for change is now.

Excel has served us all well over the years, but it’s time to embrace the enhancements available in other tools now. With client demands increasing, competition growing fiercer and the complexity of your business inflating over time, Excel simply can’t meet those needs and a complete reliance on it will damage client and employee satisfaction.

To power your long-term growth and drive success in the digital age, the time has come to embrace the benefits of cloud-based financial reporting and compliance software.

Download Whitepaper now: Do you deserve more than Excel? Moving working papers beyond spreadsheets

We are in this together

Change can be daunting. You might dread the learning curve, hesitate to alter your current workflow or maybe feel intimidated by new software with all its bells and whistles. But it doesn’t have to be that way!

With Silverfin, the process is streamlined and straightforward right from the start:

• Our platform is designed to be intuitive and user-friendly, ensuring that you can start using it effectively without the need for extensive customisation.

• Whether you’re a tech-savvy enthusiast or someone who prefers simplicity, Silverfin caters to your needs.

• With a plethora of pre-designed templates to choose from, you can effortlessly select the one that best suits your requirements.

Moreover, we’re here every step of the way to make sure you and your team get familiar with Silverfin at your own pace.

To do so, we’ve developed a specialised onboarding and change management methodology. It’s all about:

• guiding you through the transition,

• providing the right hands-on training,

• smoothing change through process mapping,

• and day-to-day personal support.

By guiding you at every step of the way, we’re sure your new software will be rolled out hassle-free and effectively. You’ll be up and running in no time, ready to reduce the strain of manual work, improve data accuracy, and give your firm the competitive edge needed in today’s market.

Our method works – we’ve used it with hundreds of firms just like yours. And they’re all avid Silverfin users by now. Of course, don’t just take our word for it.

Find out what our customers say

“Previously, we used Excel for our working papers. Every manager and preparer probably had their own way of doing things. With Silverfin, being highly standardised, getting our people comfortable with it and having them properly trained was key. Nonetheless, we immediately saw a significant improvement in consistency”. Mark Thurston, Director of Gascoynes

“We just knew that having everything flow in from the working papers in Silverfin would save us an incredible amount of time”. Henry Micks, Accounting Team Manager at Kinore

“We realised we were too reliant on paper-based processes, and worse, we had inconsistent working practices. There were even instances where work would be duplicated. This was a big no-no, so we needed to shape up our internal processes to take our business to the next level. That’s where Silverfin came in”. Lynne Walker, Vice-Chair and Head of Business Advisory at Johnston Carmichael

“Standardisation allows us to train our staff more efficiently and complete our working papers faster at month end. I also like the small optimisations Silverfin brings to the workflow, like pulling data live from the accounting system, eliminating the need for manual uploads or refreshes”. Luke Streeter, COO and co-founder of flinder

“I know if the data is in Silverfin, and all the screens light up and boxes get ticked automatically, I can trust it’s the right set of numbers. It makes us much more efficient”. Darren Austin, Director and co-founder of Synergee

Keen to explore the possibilities of moving beyond Excel in more detail? Download. and read the full Excel guide here. 

More Posts

How BKL Maximises Efficiency and Profit With Client Automation Software for Accounting Firms

Is your firm struggling with human errors, duplication of work, and a lack of available resources? Client automation software for accounting firms is the solution. ...
Read More

The limitations of Excel for accounting: why it’s no longer the go-to choice for Working Papers 

Excel for accounting firms has long been a staple. Its flexibility and accessibility make it an easy-to-use and essential tool for financial management.  However, as ...
Read More

Using standardised data to unlock greater accounting firm profit margins

No one knows better than accountants that profit margins are what’s left when your salaries and costs (like rent and software subscriptions) are deducted from ...
Read More

Navigating AI adoption: insights from Dan Boyles

Discover expert insights from Dan Boyles on successful AI adoption, common mistakes businesses make, and how AI can enhance productivity.
Read More

The AI Adoption Paradox: Why Older Accountants Are Leading the Charge

A recent Silverfin survey reveals a surprising trend: one cohort of accountants are adopting AI technology at a faster rate than other cohorts, and it’s ...
Read More
silverfin

How UK firms can overcome the challenges of cloud accounting adoption

Discover how to boost accounting firm team collaboration with cloud platforms like Silverfin, streamlining communication and tasks, and improving efficiency.
Read More

iXBRL Tagging Tool: Ensuring Compliance and Precision in Reporting 

iXBRL, or Interactive eXtensible Business Reporting Language, ensures that financial reports are precise and compliant.  However, the process can be intricate and time-consuming.  Unless you ...
Read More

How cloud-based accounting software can improve your firm

Discover the benefits of cloud-based accounting software—improve accuracy, efficiency, and collaboration with real-time data and automation.
Read More
Don't risk your reputation

Reputation at Risk: Why Delaying Your Firm’s Accounting Cloud Migration is a Reputational Timebomb

Delaying your accounting firm’s migration to the cloud may seem like a negligible risk at first, but it could have potential repercussions that could harm ...
Read More

EP 5 – Why AI is your new best friend | Chris Downing, Sage

In this episode, Chris Downing from Sage explores how AI is transforming accounting – making compliance simpler, improving efficiency, and even enhancing work-life balance. He ...
Read More

Practical applications of machine learning in accounting

Discover how machine learning enhances accuracy and efficiency in accounting with practical use cases. Learn more at Silverfin UK.
Read More

IRIS & Silverfin: Key Differences You Need to Know

Bid farewell to the drudgery of manual data and spreadsheet management and say hello to intelligent digital templates. Learn more today.
Read More

Let’s Chat

Scroll to Top
This site is registered on wpml.org as a development site. Switch to a production site key to remove this banner.