Study tips: FAPR Accounting adjustments when partnerships dissolve

Run through a scenario with our tutor on final accounts preparation after a partnership dissolves, and the accounting adjustments necessary to record significant changes in the ownership of a partnership.

Final accounts preparation when partnerships dissolve

  • Part 1 – FAPR when partnerships dissolve, taking goodwill into account
  • Part 2 – Accounting adjustments for significant changes in partnerships

This is the last of a number of articles I’ve written on partnership accounts.  Previous pieces have looked at appropriation and current accounts and this article concludes the topic of goodwill and capital accounts, for those studying towards the AAT Advanced Diploma in Accounting.

By the end of part 1 – Final accounts preparation when partnerships dissolve, we had considered what goodwill is and how, as an intangible asset, it’s different to, and therefore accounted for separately from, the tangible assets of a business.

The articles are all based on a scenario in which you and I are in partnership. However, you’re leaving at the end of our fourth year of trading. This article therefore, focuses on the accounting adjustments required to record significant changes in the ownership of a partnership.

Example Partnership Scenario

Let’s just quickly re-cap how much the business owes you. You have £30,000 of long-term capital invested in the partnership:

The current accounts have been updated as part of the year end processes and show the partnership owes you £250 of short-term capital:

So the ‘financed by’ section of the statement of financial position shows that at the end of the year, your share of the business’s tangible assets is £30,250.

We also had the goodwill of the business valued at £12,000 and calculated that you’re owed £8,000 of it, which means you want to leave the partnership with £38,250 in total.

I haven’t got enough resources to buy you out though so we’ve reached an agreement whereby you will leave with £25,000 cash and lend the partnership the rest of your investment to be paid off over 12 months. I have also agreed with another local cafe owner that we will collaborate, so Sty will buy into the business for £18,000 and we will share the profits equally.

Significant changes within a partnership

I think you’ll agree we are now in the realms of significant changes with a partner leaving, another joining and a new profit sharing ratio. And when significant changes occur the business’s goodwill is valued and the capital accounts are utilised. Let’s see how it all works in practice, starting with you leaving and then, the following day, Sty joining.

We said in the previous article that goodwill is an intangible asset with a theoretical value and as such it is subjective and also changeable. Just think about the impact a few negative reviews on social media can have on a business’s reputation and you’ll understand what I mean. It’s because of the changeable nature of goodwill, that it’s only valued at a given time and for a specific purpose. It’s also why, in partnerships, it is accounted for in an account which is opened purely for the purpose of dividing it between the partners and dealing with the change. Then it is closed. 

Free Excel webinar

Learn how to present effectively in Excel from expert Deborah Ashby. To view the recorded webinar please register your details below

View webinar

Step 1 – Introducing goodwill

As goodwill is an asset, albeit intangible, its value is entered into the goodwill account on the debit side and double entered into the partner’s capital accounts as it increases the amount the partnership owes us. It’s shared between us using the existing profit ratio, in our case, 2:1 with you getting two thirds and me one third:

Step 2 – Consolidating the leaving partner’s capital

You want to take all of your investment out of the partnership so we need to consolidate what you’re owed in the short-term, with what you’re owed in the long-term. This is done by closing your current account and transferring the balance to your capital account:

Step 3 – Partner leaves

Now all of your capital is in the same place, we can make the adjustments to pay you off and set up the loan account, the combination of which will enable your capital account to be closed:

Step 4 – Eliminating goodwill

So that’s you gone! However, the goodwill account is still open and must be closed. Goodwill is always eliminated using the new profit sharing ratio. As I’m temporarily the sole owner, this means reducing the balance on both the goodwill and my capital account by the full £12,000:

You can see that the goodwill account is now closed and that the £8,000 of goodwill you have taken out of the partnership has been paid for out of my long-term capital which was increased by £4,000 but then reduced by £12,000.

Note: when a partner leaves they are not necessarily replaced, therefore, I have shown step 4 as an end point so that the following steps can be seen as the start of a separate process (although in this scenario, steps 4 and 5 could have been combined).

If we look afresh at the accounts we can see that there is a £12,000 balance on my capital account:

Replacing your previous partner…

Step 5 – Introducing goodwill before a new partner joins

A new partner joining is a significant change so the goodwill needs introducing before Sty can join. This is because he will buy a share of the goodwill as part of buying into the partnership:

Step 6 – New partner joins

Sty invests in the partnership:

Step 7 – Eliminating goodwill

Our new profit sharing ratio of 50:50 is now used to eliminate the goodwill:

You can see that the goodwill account is closed and that whilst Sty paid £18,000 into the bank account, his initial investment is only £12,000.  This is because he has in effect paid me £6,000 in recognition of the goodwill at this time.

Hopefully, the new partnership will flourish and our profitability and reputation will grow. If they do, the value of the partnership’s intangible assets will increase and when there is another significant change this will be reflected in the value of the goodwill.

Read more on final accounts preparation;

What was Britain’s best year in the past decade?

It was 2012 of course! But why? What made 2012 stand out? And how did all the other years do?

2012 was officially named the ‘Best Year’ of the 2010s, according to a new survey commissioned by AAT. The survey, which saw Opinium Research speak with 2,005 adults, saw 37% of Britons name 2012 – the year of the Queen’s Diamond Jubilee and the London Olympics – as the best year for Britain since the start of the decade. 2011, the year in which Prince William married Kate Middleton, was named the second best year (14%), followed by 2013 and 2016 (12% each).

Meanwhile 2017 was named the ‘Worst Year’ for Britain over the past decade. The year, voted the worst by 31% of those surveyed, saw Britain return to a hung parliament while both Manchester and London were rocked by terror attacks. 2016, the year of the EU referendum, was named ‘worst year’ by 19% of respondents, while 16% said that 2010 was worst for Britain.

“The fact that the top two years for Britain in the past decade contained significant events affecting royalty – in Prince William’s marriage and the Queen’s Diamond Jubilee – suggests that the Royal Family’s national popularity endures,” says Andrew Williamson, Director of Marketing and Commercial, AAT.

“However, the golden fortnight of the London 2012 Olympics saw Britain’s star shine brightest, and perhaps did more to bring the country together than any other single event.

“It’s interesting that 2016 was ranked in both the best and worst years of the decade, presumably depending on the stance of those surveyed related to the EU referendum that year. As we now move into a new decade, it’s a moment for Britons to consider how they wish to develop both personally and professionally, to keep pace with the changing world around them.”

In summary

As we head towards the end of 2019, it’s a time for reflection on the years behind us. Have a think on your best year of the past decade; maybe it was the year you passed your AAT exams? Or the year you decided to spend more time with family?

Bring a little of that winning strategy into 2020, and make it another one for the leaderboard.

Read more from AAT Comment;

The Doctor will see you now: how your practice can benefit from a time lord’s advice

Doctor Who is one of the BBC’s biggest global exports. So are there business lessons that can be learnt from the show?

“What we’ve seen over the last decade with the introduction of online accounting and the ecosystems around it is the biggest level of change in the shortest level of time we’ve ever seen in accountancy,” says Carl Reader, chartered accountant and author of The Franchising Handbook. “Accountants were doing these things manually for so long and there wasn’t much pace; that pace has picked up dramatically in the last ten years.”

If you had a TARDIS and could see into the future, where do you think that technology is going to go? “The time bomb, of course, is the imminent automation of tasks which don’t need humans to do them. Routine bookkeeping, routine analysis of the competition and accounting of financial regulations that are currently performed by humans with the assistance of technology.”

Key takeout: There is no reason why technology can’t take a bigger role – “other than the refusal of some accountants to let that happen, and the need for vendors to choose accountants as their channel to market.”

Technology revolution

Back in the 1960s, the Doctor encountered a race of aliens called the Krotons. Whilst not aesthetically the most attractive of creatures, in silver skirts and equipped with hoover parts for weapons, they did happen to be pioneers of machine learning.   

This is stage two of the technology revolution for accountants, Reader says. “The technology will not only identify and allocate financial transactions but will also be able to identify trends; not just within the business that’s been identified but also, the landscape.”

Key takeout: The machinery will do these things much sooner than a human would. “At the moment, an accountant has to look manually to identify when things have happened.”

Where does all this lead businesses?

“It’s leading to a real-time tax environment; certainly with the removal of cash that is going to happen. And potentially, a real-time financial reporting environment.” The hypothetical end situation “is that financial reporting could be published day-to-day, instead of waiting for it.”

For Reader, “advisory was a topic in the accountancy world 30 years ago and not much has happened. More than ever before, accountants really need to understand what advisory is. It’s not slightly more advanced compliance work. It’s a reason to use an accountant, rather than relying on technology.”

Does this not give problems for bookkeeping – might the profession find itself redundant? “Not at all,” says Joanne Routh, an AAT accountant. “I started off just doing bookkeeping and quickly realised that technology enables me to do a lot more – tax returns and management reports as well.” Routh is a qualified accountant, “but increasing automation is not a problem for bookkeepers – as long as you move with the times.”

Key take-out: Bookkeepers can broaden their scope by embracing the technology and thinking outside the box.

An awareness of diversity

Famously, Doctor Who regenerates every few years. Whilst this concept was invented to enable the lead actor to move on, it gives creative momentum to the series, keeping the brand fresh. And as Reader points out, it’s doing more than that.

“The move to a female Doctor demonstrates an awareness of the diversity that accountancy firms need to lead the charge within professional services,” he says. “It’s shocking that we have roughly 50/50 female at male at entry-level, but there are – to paraphrase – 60-year-old white men at the top. It’s a change the profession needs to keep working at; it will happen over time, but we need to keep driving it.”

What’s your USP?

And in terms of regenerating yourself with a rebrand? “The very simple answer is yes. In the customer’s eyes, you need to stand out. You need to think of ten other accountancy firms, and think – why should the customer choose you?”

“What’s your USP? What’s your particular difference? It might be something very simple like your processes being faster than the competition; you could have a turnaround promise, or a guarantee, or depth of knowledge in a particular specialism.”

As Doctor Who learnt to its cost in the 80s, question marks on collars or stunt casting comedians is not innovation. “When you are looking at how to stand out, see the difference between what is a trend for everyone, and what is a true differentiator.”

Key take-out: Innovation doesn’t need flashing lights. “But it does need to be something tangibly different in your service offering. That’s what makes you stand out if you want to exterminate the competition.”

Creating stand out

In the 1970s, besieged by rising inflation and the expensive move into colour, TV execs had a problem – making spaceships and futuristic settings was getting too expensive. But instead of cancelling the series, the creative decision was made to exile Doctor Who to contemporary Earth. Is there a lesson here for SMEs, who might think they don’t have enough money to stand out?

“There’s increasing consolidation from large accounting firms and brands, and at the same time, an increase in boutique firms – essentially a way of branding individuals who are really working by themselves,” says Reader. “And there’s increasing polarisation between the two.”

Boutique vs large corporations

But being boutique can work, Reader says, “if you remember the lessons about having a reason to stand out. You have the flexibility, you can be agile because you have no corporate structure around you, and you can find out where you want to focus yourself, make your name and drive it upwards.” It’s not easy or a quick win, Reader says, “but it’s the strength of the small firm; capitalise on it.”

In summary

Joanne Routh adds, “as long as accountants and bookkeepers embrace the new technology, it’s really easy to give more value to clients and keep them happy. You hear about some accountants not doing this, and still getting out notebooks.” For Routh, “I don’t understand that at all, in this day and age, when all the technology is here and now – it’s not sci-fi any more.”

Doctor Who returns New Years’ Day on BBC1 (and on a technological device near you).

Further reading:

Michael Crowe: 3 tips on moving from the private sector to the public sector

There are lots of exciting opportunities for trained accountants within the public sector. According to Finance Isle of Man chief executive Michael Crowe, getting involved with local trade bodies is the best way to find out if working in the public sector is for you.

A qualified chartered accountant since 1994, Michael Crowe joined the newly set up Executive Agency of the Department for Enterprise – a public-private sector partnership designed to promote and develop the island’s financial services sector – last year.

Michael Crowe, Chief Executive Finance Isle of Man

Finance Isle of Man is a key decision making and advisory body supporting the Government’s ambition for long term economic prosperity for the sector.

A new challenge

The appointment meant leaving the world of professional accountancy after more than 25 years as a chartered accountant and auditor. “I trained at what is now PricewaterhouseCoopers on the Isle of Man, and qualified as a chartered accountant in 1994,” said Crowe, who moved to the island with his family at the age of five.

“I then joined PKF Isle of Man where I was an audit partner, before moving on to be a director at Grant Thornton about five years ago.” He believes working as an auditor was good training for his current role.

However, it is the time he has spent working with local trade bodies that he thinks best prepared him to take on the responsibility of representing the financial services sector on the Isle of Man.“I have been quite heavily involved in the local Chamber of Commerce for some time, both on the board and as a former President,” Crowe said.

“So when I was offered the chance to work on this new Government Agency, I knew I would find it a very interesting opportunity. “That’s why I would advise anyone looking to move into the public sector to get involved in their local trade bodies.

“It’s a natural way to move towards working for the Government and is a good way to see if this sort of role would suit you. “It’s also a great way to meet people and bring about positive change for your sector.”

A varied and interesting role

Finance Isle of Man’s mission is to “promote and develop the Isle of Man’s significant financial and professional services industry and ensure its recognition as an international business centre of excellence”.

For Crowe and his team, this means having a foot in two camps: the financial services sector and the Government.

“I regularly meet with business leaders and other Government departments, as well as representatives of local trade bodies,” Crowe said.

“Finance Isle of Man is also involved in event planning and looking at different ways to promote the Isle of Man around the world.”

“The job involves some travel: I was recently in London and will be visiting Hong Kong next year, but I don’t have to be away too much. “It also involves resource management and looking at policy, so it’s very varied and gives me a really interesting perspective on the local economy.”

Michael Crowe’s top 3 tips:

1. Ensure you have an internationally recognised qualification

“It’s very important to pass qualifications that are recognised internationally, for example via AAT.

“In the future, you may want to work somewhere other than the UK; you might even be tempted by the great opportunities and work-life balance we have here on the Isle of Man.

2. Get involved with local trade bodies

“It’s definitely a good idea to work with local trade bodies if you think you might be interested in moving into the public sector.

“I found it very interesting and a great introduction to liaising with the Government on behalf of my sector.”

3. Make sure you understand the role

‘Whenever someone is considering a change of direction in their career, it’s very important that they understand what will be required of them in their new role.

“If you are interested in doing the type of job I do, working with trade bodies is a natural way to gain a greater understanding of how the public sector works.”

In summary

From trainee positions to finance director openings, there are lots of opportunities for trained accountants and financial service professionals within the public sector – both in the UK and overseas.

AAT qualifications will enable you to apply for many of them, and experience of working with bodies such as your local Chamber of Commerce will increase your chances of success.

For more on careers:

Study tips: Final accounts preparation when partnerships dissolve

Run through a scenario with our tutor on how to prepare final accounts when a partnership dissolves, taking goodwill value into account.

Final accounts preparation when partnerships dissolve

  • Part 1 – FAPR when partnerships dissolve, taking goodwill into account
  • Part 2 – Accounting adjustments for significant changes in partnerships

In previous articles we’ve looked at the subject of how to appropriate the profit or loss generated by a partnership that is operating as a going concern. We’ve considered the concept of capital, the role of the appropriation account and how to update partners’ current accounts at year-end.

In those articles we clarified the difference between a partners’ long-term capital, recorded in their capital account, and their short-term capital, recorded in their current account. We stated that the current accounts record the routine changes to the amount a business owes each partner that comes about in the normal course of business, and that the capital accounts record each partners’ initial investment. We’ve said that the capital accounts are only adjusted if significant capital injections or withdrawals are made.

When ownership of a partnership changes

It is these circumstances that we are now going to consider, and look at what happens when there are significant changes in the ownership of a partnership, such as partners leaving or joining.

Let’s continue our previous scenario where you and I are in partnership. If you remember our third year of trading was slow, so let’s imagine that in year four business didn’t really pick up and we decided it was time for a change. You work part time in the partnership and your other interests are becoming more time consuming so you have decided to leave at the end of the financial year.

Leaving a business is more complicated than handing in your notice and leaving a job. There probably still needs to be a notice period and practical arrangements but the key difference is that you don’t want to just walk out with a box containing your personal belongings, you want to leave with your share of the partnership’s value as well.

We know the statement of financial position (SoFP) calculates the net assets of an organisation, in other words, what it is worth at that point in time. We also know that the ‘financed by’ section on the SoFP shows how the net assets are comprised of the elements of the owner(s) equity and on a partnerships’ SoFP those are the balances on both the capital and current accounts.

The financial statements for the fourth year have been prepared and our current accounts updated. 

An extract from the SoFP shows:

The written down value of the partnership is £55,875 of which £30,250 is owed to you. But would you be happy walking away with that amount?

I wouldn’t if I were you! We’ve been in partnership for four years and whilst things are slow at the moment we are still generating profit and are expecting to trade into the foreseeable future. We have both invested more than money into building the business and all that time, effort and  expertise has value. 

Goodwill value of a business

The name for that value is goodwill.  It can be understood as the worth of a business over and above that of its written down assets. In other words, on paper our partnership is worth £55,875, a figure that is calculated by deducting the business’s liabilities from its assets. However, it is worth more than that. 

Assets are not just current and non-current they are also tangible and intangible. The difference is that tangible assets have actual monetary value, for example:

  • vehicles
  • shop fittings
  • and the balance on the receivables account.

Whilst intangible assets have theoretical value, for example:

  • a good location
  • well trained staff
  • and repeat customers.

We haven’t said what our business is but let’s say its a cafe on the high street of a picturesque village which attracts both regular locals and tourists. The kitchen equipment, tables, chairs, crockery and glassware are all examples of tangible assets. However, the fact that the cafe is located on the sunny side of the street, with safe seating set back from the road, and has a reputation for good service and delicious food, undoubtedly attracts customers and generates sales. These, therefore, are intangible assets and examples of goodwill.

So, the next question is how much is the goodwill of our partnership worth? 

Determining the goodwill value

This is a hard question to answer as goodwill is subjective and you may think it’s worth more than I do. In reality the best course of action is to seek professional advice because valuing a business is a complex and specialised area.

For arguments sake let’s assume that we have sought help and been advised that the value of goodwill is currently £12,000.  We both agree this is a fair figure and can now work out how much the partnership owes you.

Dividing up the partnership

We already know you are owed £30,250 which is your share of the tangible assets and by using the profit sharing ratio, from our partnership agreement, we can calculate your share of the intangible assets. The ratio is 2:1 which means you get two thirds of our profits, losses and goodwill. Therefore, that you are owed a further £8,000, which gives £38,250 in total.

In the second part of this article, we’ll look at the accounting adjustment required to record you leaving the partnership, how I’m going to be able to buy you out and what I’m going to do without you.

Read more on final accounts preparation;

Tax avoidance: under the microscope

If accountants fail to report tax avoidance, they could face a tarnished reputation, a hefty financial penalty or even end up in jail. But how do you know if your client is doing something dodgy? Here are some red flags to watch out for…

As anybody who actually does the job will tell you, being an accountant involves much more than totting up somebody’s income before putting it in the post to HMRC. It’s a role that requires being part data analyst, part financial adviser and, increasingly, part detective too.  

That’s right. Although accountants are trained to find any irregularities on a balance sheet, a new law set to be introduced next year (July 2020) will see them channelling their inner Eve Polastri/DS Steve Arnott /Jimmy McNulty a whole lot more.

This new law comes from the European Union and could see accountants, bankers and lawyers face penalties if they fail to report tax avoidance schemes that involve companies/individuals shifting their money to offshore accounts (the UK will still follow this law whatever happens with Brexit).

There are some big penalties for assisting tax avoidance: should HMRC find you guilty of being a “professional enabler”, you could be fined up to 100 per cent of the tax their client avoided.

  • Tax avoidance has been a hot topic in recent years. The Panama Papers data leaks, along with scandals involving Jimmy Carr, Wayne Rooney and Geri Halliwell, has seen some accountants accused of getting too cosy with their clients by concocting complicated schemes to help clients dodge paying their fair share of tax.

To avoid landing in hot water with the HMRC, here are the red flags to look out for

Things seem a little… fishy

Before you even set eyes upon your customer’s balance sheet, try acting upon your gut instinct first. Does the client seem evasive or slightly secretive? Are there any inconsistencies in the information they’ve provided? Do they seem a bit hazy when questioned about their business expenses? Of course, none of these gestures indicate your client is guilty and you should shop them to HMRC pronto. But it can make you more vigilant about anything dodgy that could appear in their accounts.

Also, be on the lookout for sudden lavish displays of wealth. In 2012, some people who appeared in Channel 4’s My Big Fat Gypsy Wedding came under scrutiny from HMRC for spending thousands of pounds on ostentatious weddings, after they’d been spotted spending money on ostentatious weddings in the TV show. If at all suspicious, don’t be afraid to have a snoop on social media, or check Companies House to see if your client has ever been disqualified as a director.

Undeclared earnings

Moonlighters’ are one of the targets on HMRC’s hit-list. These are people who have a hidden income that the government’s tax-collectors don’t know about yet. Their earnings could come from owning a buy-to-let rental property, having a second job such as driving taxis, or even selling crafts on Etsy.

  • If your client is moonlighting, they’ll need to pay tax on any profits, so check if they do have any extra payments aside from their salary.     

Inflated revenues

In 2001, the consulting giant Enron collapsed due to an accounting scandal that still causes financiers to shudder to this day. Its downfall was due to some fraudulent accounting, with its impressive figures for revenue growth (which jumped from $13bn to $100bn in the space of four years) setting Wall Street’s alarm bells ringing.

  • Be prepared to look out for any suspiciously high revenues. Any sudden increases in their inventory/sales ratio should also be noted: it could indicate your client has inflated its stock.

Loan schemes

Loan schemes are used by some people to avoid paying income tax. They’re primarily used by workers in the ‘business services’ industry, such as IT contractors, financial advisers and management consultants. These professionals are usually advised to use an employee benefit trust (EBT) where their earnings for a specific job are paid back to them in the form of a loan. There is no tax paid on these loans (despite the fact it is clearly income) and they are usually never repaid.

  • HMRC is cracking down on these ‘disguised remuneration schemes’ (as it calls them), by applying a 2019 loan charge that has resulted in hefty tax bills for some workers. If your client is using an EBT, it’s worth informing them about these risks.  

Offshore structures

Offshore tax havens are something that only your super-wealthy clients are likely to use. In recent years, there’s been a global crackdown on individuals and businesses who bypass tax through using offshore structures. The leak of the Paradise Papers in 2017 showed the extent of the problem, revealing, for example, how private jet-owners had set up offshore companies so they could rent the aircraft from themselves, therefore sidestepping the need to pay hefty VAT bills. Meanwhile, the likes of Google, Amazon and Facebook have rarely been out of the news due to accusations that they’ve used offshore tax rules to avoid paying taxes in the UK. 

Comb through notes and footnotes

The notes (or footnotes) on a balance sheet usually tell readers about the company potential liabilities and losses, as well as explaining any irregularities. It’s also where you’ll find details about pensions, joint ventures and unconsolidated subsidiaries. And as one accounting guru recently told us, it’s also where “all the naughty stuff is hidden” too.

If your client is dabbling in illegal offshore activity, you’re likely to find any warning signs, such as payments to offshore entities that aren’t part of the group, in these end-of-statement after-thoughts. Your suspicion should also be triggered if you stumble across the vague-sounding term ‘Development Costs’ too.

In summary

If you suspect evidence of tax avoidance, then ignoring it in the hope it’ll go away isn’t a good idea: the 2017 Money Laundering Regulations means professional advisers (such as accountants) are legally obliged to file a suspicious activity report (SAR) to the National Crime Agency if they come across any dubious balance sheet activity.

SARs are available to download here.

Further reading on ethics:

Winner stories: Andrew Sullivan FMAAT of the year

Andrew Sullivan, AAT’s Fellow Member of the Year, never had any intention of becoming an accountant. But his modern approach to accountancy is what has driven his success

When Andrew Sullivan, FMAAT left school, he didn’t know what he wanted to do with his life. “I went and worked a part-time job for a little while, and then when I was about 18, I went to college to do a business course,” he explains. “When I did that business course, I noticed I was pretty good with numbers.

I think numbers had always been a strong point of mine. So my college just basically put me into an AAT course and said, ‘see how you get on with this’.” 

Becoming an apprentice

When Sullivan started studying AAT and found it quite fun, he decided to go for it. He got an apprenticeship at an accountancy practice and stayed there for 14 years. “I had no intention of doing accounting as a career choice,” says Sullivan. “I didn’t know a lot about it. However, I knew I was never going to go down a standard route.” 

Applying what he had learned to real business scenarios was something Sullivan particularly enjoyed about accounting. He also found business owners interesting – and he still does. “I find it interesting how people get a great idea and then try to apply it and just figure it out along the way,” he says. So Sullivan took the aspects he enjoyed about accounting and made it the focus of his business.

“I work with business owners on implementing ideas and putting all their systems and processes in place,” he says. “They come to me because they know I’m an accountant, but that’s only a small element of what they want.”  

Showing business impacts

A lot of what he does isn’t what you’d typically ask from your accountant. His clients want reassurance and help with planning for what they are looking to do. “I help them make sure that they aren’t going into something that is going to impact massively on the rest of their business,” Sullivan explains. “I managed to pick up a few clients that want that level of service. I do all that remotely for them. I’m trying to build the practice up on that basis. Not general accountancy services.”  

Based in Cornwall, he deals with most of his clients on a remote basis – they’re the types of businesses that he wants to work with. “They’re flexible, and they have a modern approach to business, which is how I look to do things,” says Sullivan. “It’s a fluid environment that’s always changing and always moving. I’m probably the most informal accountant you will meet, to an extent. I don’t do the ‘traditional’ way of working.”  

A passion for technology

A passion for technology coincides with his modern approach to accounting. “I’ve always been massively keen on using technology,” says Sullivan. “I always thought when I was growing up that I would work in technology, or software or some form of the tech industry. So I’ve got a big interest in technology and software. That’s helped me to build my business.” Sullivan has a virtual assistant that does administration work for him, and he subcontracts accountants to do compliance work.

The business is growing organically. “I’m probably taking on a client every week at the moment,” he says. “I’m planning the next phase of the business now. I’m starting to explore some office space, and the potential of bringing on a part-time employee.” He is also working on building a full-scale website to handle all his leads. 

Starting his own business

The 32-year-old branched out on his own earlier this year, after 14 years at the same accounting practice. He moved up the career ladder in that practice – from apprentice to manager to director and shareholder. He was motivated to start his own business by the opportunity to be more flexible so that he could spend time with his two young children. It was the right decision for his health, too.

“I have Crohn’s disease, so it made sense for me to not be in a stressful environment,” says Sullivan. “Although having your own business is a different type of stressful environment.”  

“I’m planning the next phase of the business now. I’m starting to explore some office space, and the potential of bringing on a part-time employee.” 

Becoming self-employed with AAT

If you’re an AAT professional member, you can apply for an AAT licence to become self-employed. This entitles you to start taking on clients and offering professional services on a self-employed basis.

If you’re interested in becoming an AAT Licensed Bookkeeper or Accountant and starting up your own business, the first step is to check out the information online to ensure it’s right for you, then download the AAT licensed member application form, and follow the guidance on how to complete the form.

Further reading

AAT ethics helpline: 5 toughest ethical dilemmas

Ethics is one of the most important aspects of being an accountant. Clients need to trust your professional integrity, and the public needs to have confidence in your standards and principles.

Being a member of AAT is a mark of high standards, high quality training, and professionalism. But there may come a time when you face an ethical dilemma in the course of your work.

This could involve:

  • a threat to your professional reputation
  • a demand from a client or employer to do something which you consider unethical, unprofessional or even illegal
  • or a problem with a client which makes you consider whether you wish to work with them in the future.

To help members maintain standards and provide high levels of professional service at all times, the AAT publishes a Code of Professional Ethics. This sets out guiding principles and gives members of the public the assurance that when using an AAT member’s services, they can expect a professional service.

AAT recognises that sometimes ethical dilemmas can be problematic and difficult to deal with on your own. By being a member of the AAT, you have access to the ethical helpline (details at the end) which enables you to speak to one of our professional standards officers.

They can give you confidential advice on your situation and advise you on your options. They can also direct you towards other organisations which could help or suggest that you take legal advice.

Calls tend to peak around year-end when members are reviewing accounts and receiving emails from clients.

We met with the team behind the AAT ethics helpline to hear about the toughest and most common ethical dilemmas they’re hearing from our members. We also found out how the AAT ethics helpline may be able to help you resolve these issues in case you encounter them yourself.

1. What rights do I have when I’m disengaging from a client?

If you’ve made the decision to stop working with a client, and they haven’t paid you, should you tell the incoming accountant? Are you able to retain documents that belong to the client if they have not settled the invoice?

“These are both issues that could arise in day to day work and we are here to help members navigate the code of professional ethics,” says Adam White, Professional Standards Officer, AAT.

“The first step when a member calls is to ask whether they have reviewed AAT’s Code of Professional Ethics. We want them to consider the issue in light of the five fundamental principles of the code, and then decide which of those principles are in jeopardy.”

“By talking with the member, we get to understand what the dilemma is,” he says.  

“Right of Lien – where a client has not paid and the AAT member wants to retain records or certain documents from them – is a subject about which we receive many calls,” says Donna Drew, Professional Standards Officer.

“We look at the issue on a case by case basis, but it may be that we recommend that they seek legal advice.”

2.You’re working at a company and you’re asked to do something which you feel is wrong or illegal

This dilemma frequently involves a person who is employed and has been asked to do something that they consider unethical or illegal, often by a manager or business owner. It might happen in a small company where the managing director or owner has a lot of control. For this reason, it can be very awkward and they might eventually have to leave the company if they’ve tried other options.

“It depends on the situation, but if you are asked to do something unethical or wrong, and you’ve got to the end of the line in terms of raising it within the company, you may have to determine whether you want to continue acting for that client, or working for that employer,” says Adam White. “It can be very difficult for a person who is employed, as they may be sacked or have their employment terminated.

“From the point of view of anti-money laundering, we have a helpline for people who have questions or concerns. Anything that’s related to the proceeds of crime, and that might include the underpayment of tax, could fall under the remit of anti-money laundering.”

Find out what you can do when clients don’t tell you everything…

Issues often arise in relation to tax, and the Professional Conduct in Relation to Taxation (PCRT) can be used for specific guidance on matters that relate to tax.

This could include tax avoidance schemes, or if a member knows that there is an error or omission in a client’s VAT. It could include also historical issues regarding underpayment of VAT.

Members may need some guidance on how to bring this to the attention of the client, as you have to get the client’s permission to report because of confidentiality issues, Adam White says.

3. Should I work for someone who is being investigated by the police?

Marlene Prentice APCIP, Professional Standards Officer, says she was called by an AAT member who had read in the local newspaper that one of his clients had been called before the Crown Court regarding NHS overclaims for his dental practice.

What should he do and how should he approach the client?

“We advised him that the information was in the public domain so he could let the client know that he had seen the report and he could express his concerns,” she says.

Although some people might think that you have to disengage in such a situation, it’s for members to assess on a case by case basis, she says.

“It’s important to speak with the client and find out all the information. Don’t jump to conclusions. Make a decision weighing up the information you have, and what you need to do to safeguard your position.”

Another member was contacted by a man who was being investigated by the police because he had been growing cannabis from his home. The man claimed it was the first time he had ever done it and he wanted to show the police evidence of his finances, and that he hadn’t had unusual deposits into his bank account which might have been the proceeds of drug crime.

He wanted to find an accountant who would prepare a report for the police .In this situation, the client was entitled to ask an accountant for help.

“We can’t tell members what to do but we can help them make an informed decision,” she says.

4. I work with two directors at a company and they’ve fallen out and are giving me different instructions

Another common issue is warring or divorcing partners in a business.

“Everything may start off amicable, but then the accountant finds themselves caught in the middle when things turn sour,” says Marlene Prentice.

“The question is, from whom should I be taking instructions? You need to make it clear to both parties that instructions need to be clear and not contradictory. You can decide whether to disengage or continue, based on their response.”

She says there’s not a right or wrong answer and that the situation changes depending on the information that you have.

“Generally, we act as a sounding board for the member – often they already know what they need to do but are just looking for some help and guidance.”

“With warring directors, you would need to manage the situation,” says Dharmila Bhanji, Professional Standards Officer. “Email both parties and ask for clear direction. You can call us the minute you feel uncomfortable and we can help you identify what next steps you want to take.”

5. I’m thinking of disengaging from a client because I have ethical concerns

Errors in accounts prepared by previous accountants, or difficult behaviour from owner-managers, can be problems when working with limited companies says Donna Drew, Professional Standards Officer.

“I dealt with one case where a client of an AAT member was refusing to submit their company accounts because they knew they had tax liabilities and they couldn’t afford to pay. In that case, the AAT member had to give them the final opportunity to submit their accounts, and then disengaged.”

Another issue arose when a member was in the process of disengaging from a client. The client asked the accountant to leave all the documentation behind an unlocked side gate.

“The member felt that this was not sufficiently secure and that they might be contravening GDPR and security of data rules if they left the files unattended,” she explains.

Contact the ethics helpline

To discuss any ethical questions you might have, call us on +44 (0)20 7397 3014 or email [email protected].

The guidance that the Ethics Code provides covers a number of important issues:

  1. Threats and safeguards – a threat might potentially compromise a member’s compliance with the fundamental principles
  2. Conflicts of interest  – when it would be difficult for a member to be objective in certain circumstances
  3. Integrity – the obligation to be straightforward and honest
  4. Objectivity – not to compromise professional or business judgement because of bias, conflict of interest or the undue influence of others
  5. Professional competence and due care – ensuring that your professional knowledge and skill are maintained at the level required to ensure that clients or employers receive competent professional service. It requires members to act diligently in accordance with technical and professional standards
  6. Confidentiality – not disclosing information obtained in the course of your work, even in a social setting
  7. Professional behaviour – adhering to competent and professional standards at all times

Further reading on ethics:

Excel tips: How to amend a CSV file without a direct bank feed

The rapid development of direct bank feeds into cloud-based accounting software has dramatically changed the way accounts can be reconciled these days.

The thought of returning to reconciliations with physical bank statements or matching transactions on a spreadsheet, fills me with horror! 

Unfortunately, I have come across situations recently where a direct bank feed isn’t available. The next best option is therefore to import a statement, but often the raw data that’s available doesn’t match the format required by the software.

Large organisations will find a software solution, but small businesses will make the adjustments manually. The upshot is that some basic excel skills and techniques are required to make suitable adjustments in these situations.

Working with a factoring company

One of my clients uses a factoring company. This means that sales invoices are generated on the clients accounting software and then uploaded to the factoring company’s portal. The client can then draw down funds in advance of customer receipts in order to aid cash flow.

Customers pay invoices in accordance with the client’s terms but payments are made to the factoring company’s bank account rather than the client’s. All of the transactions, including details of various fees, are recorded by the factoring company on a transaction report that can be downloaded from the portal. This is the nearest equivalent of a bank statement available.

In order to account for the transactions that go through the factoring company, a dummy bank account has been created in the accounting software. The transaction report needs tweaking before it can be uploaded and reconciled. This must be done mindfully with the aid of Excel’s functionality, in order to minimise opportunities for human errors. For example, if we overtype numbers or use a formula, we could end up with rounding discrepancies. 

Free Excel webinar

Learn how to present effectively in Excel from expert Deborah Ashby. To view the recorded webinar please register your details below

View webinar

Manually adjusting the raw data

An example of the raw data can be downloaded by clicking here if you would like to have a go at making some adjustments. It will take some time initially, however I have found that, once it is routine, it only takes a few minutes.

Firstly, because the report downloads as a csv file, the columns widths are all the same size regardless of their content;

and need expanding to reveal the full details:

In order to record each statement line, the client’s accounting software’s minimum requirements are the date and amount, which must be in a single column with payments showing as negative figures and income as positive ones. Details of the payee, description and reference are optional.

Step 1 – delete unneeded columns

Delete any unneeded columns, in this case A, D and I.

Step 2 – delete entries for invoices/credit

Step 2 is to delete entries for invoices and credit notes if there are any. This is because whilst the factoring company records these on the report, they are generated in the accounting software so will already be recorded in the sales ledger and must not be duplicated.

The filter function works well at this stage and, as long as you click in a cell in row 1, it will be applied to all the columns containing data:

Once the invoices have been selected, the rows can be highlighted and deleted:

Step 3 – combine the VAT with the net transaction

Combine the VAT with the net transactions it has been charged on, namely services and inter-account transfer fees. This is because direct posts to the VAT account are not possible in the accounting software, so a sensible solution is to combine them at this stage and apply a bank rule once the transactions are imported. The filter can be used to good effect again here as it reduces the chance of transactions being missed through manual error:

It is important to use Excel’s functionality to create the gross figures rather than adjusting them manually. This can be done by dragging the VAT figures into column E (as there are figures in column D that just hidden due to the filter) on the corresponding row.

Note that the pairs of services fees and their corresponding VAT are ordered in reverse. Therefore, be very careful to match up the correct cells, in this case row 2’s VAT is was row 5 and row 3’s VAT is in row 4.

Next, delete the now empty VAT rows then write a formula to calculate the gross amount in F2, and drag it down the column:

Then use copy and paste values to update column C. You will need to do this is in three sections (rows 2-5, 7-9 and 13) because of the hidden rows: 

Note that the figures in column F will alter due to the formula but that’s irrelevant as columns E & F are no longer needed and be deleted. The filter can be removed as well.

Step 4 – combine into one column

The final step is to combine the figures into a single column. As the payments need to be shown as negative figures the easiest way is to use the copy and paste special function. Type -1 into an empty cell and copy it:

Highlight all the figures in column C, then click on the Paste button so it shows the drop down menu and select paste special. This will open the paste special box, where ‘All’ should be selected from the Paste section and ‘Multiply’ from the Operation section:

Selecting OK will result in all the payments showing with minus signs. The -1 can be deleted and the receipts, which are currently in column D, can be dragged into column C.

The final adjustment is to remove the CR from D1 and change the DR in C1 to Amount:

Save the amended CSV file with a new name, so that you still have the original data in case you need to check it in the future, and upload it to the accounting software.

In summary

Technology is transforming accounting and making fundamental tasks, such as reconciliations, much quicker, easier and accurate. That said, it is vital to maintain our knowledge and skills of accounting theory and spreadsheets, as well as learn how accounting software works, so that when an automated function isn’t available a manual solution can be found.

Browse the full range of AAT study support resources here

5 anti-fraud tips for millennials

New research says that despite being digitally savvy, millennials are actually the age group most likely to fall victim to financial scams. What are the mistakes they are prone to, and how can accountants help?

“The reason is quite straightforward,” says Lucy Cohen, author of The Millennial Renaissance, “which is that young people are used to digital communications – we live our lives there.” When smartphones are used for everything, Cohen says, “it’s easy to miss something fraudulent amongst all the real communications.”

1. Consider any unexpected tasks

Not only are younger people on more apps and sites, but they are also more likely to trust those services; perhaps older people are more instinctively suspicious, Cohen suggests. “The advice for young people is to know yourself – know what you have coming in and are expecting, and be cautious of anything that looks unusual, unexpected or which rushes you into a decision.”

Key takeout: Millennials are so used to life online that there’s a need to take a step back and consider anything unexpected.

2. Be aware of the implications of giving away data

Is there more of a willingness on the part of young people to surrender data, and is that contributing to the problem? “Yes, definitely. The younger generation is more used to giving data up in exchange for benefits. It’s not that different to the previous generation, those familiar with Facebook and Twitter; but the pace is much faster.”

Go back a couple more generations, Cohen says, “and your phone number and your name on the electoral register was all that was public – you could apply to be ex-directory, that was a thing!” Today, things could not be more different. “Companies want your data to make money, and the question for young people is: how willing are you to do that; how much are you comfortable to live with? The issue then is to be more aware of it, and know your boundaries.”

Key take-out: Data is far more of a commodity than it was just two generations ago, and people need to consider the implications of this. 

3. Double check anything unfamiliar

Sharing too much data can lead to identity theft: recent research from Lloyds suggest that there was almost a four-fold increase in the number of 18 to 34-year-olds being caught out by impersonation scams in the year to July.

Going forward, will things get better or worse – will there be more or less cyber fraud? “This is a moveable feast,” says Cohen. “As you close one hole, another opens; it’s the nature of criminality, which is opportunistic. You owe it to yourself to have a bit of awareness, know about scams and remember the fact that someone will want to cheat and exploit opportunities.”

Key take-out: Rather than assuming that something’s safe unless proved otherwise, assume nothing is safe unless you’re reasonably confident about it.

4. Take your time – don’t rush

Awareness, rather than alarm, is the watchword. “These scams have always existed – it used to be postal scams, or people on the doorstep. They’ve always been there, it’s just that the format has changed. 

Young people might be targeted by fraudsters who know what their particular interests and tastes are, and so disguise themselves as being from a legitimate company. To address this, “go and check. Most big companies will have phishing policies on their websites. If you’re savvy, you can identify whether an email is real or not.”

Never follow a link on an email, Cohen says. “Instead, go independently – look the company up yourself.” And if you realise there’s a potential phishing scam happening, “report it. The genuine company will want to know what’s happening.”

Key take-out: If something demands immediate action, it is very likely to be fraudulent. “Nothing needs to be done instantly,” Cohen argues. “There is never a legitimate reason to tell someone, you have to do this straight away – it can always wait until you have checked its veracity.” 

5. Take personal responsibility

Whilst accountants and financial services companies can help by educating young people, there is also the need to take personal responsibility for understanding the mechanics and risks – and of understanding finances more generally. “I was lucky in that I took business studies which make you think about your finances,” says Alexandra Bond Burnett, MD of Blue Arrow Accounting.

“If young people don’t have that, they can get stuck; they might have no idea what an invoice is, or understand what tax is. The differences between tax and NI, for example, can floor people.”

Key take-out: There’s an ‘arms race’ between customers identifying what the scams are and avoiding them, and criminals finding new ways of tricking people. Staying on top of this means staying alert, thinking carefully and never being rushed into anything.  

In summary

Finally, what about the future? “Facial recognition and AI payments are becoming more commonplace”, says Bond Burnett. As with most technologies, “this can be scary, to begin with, but it does mean a boost particularly for local economies.” Such changes in the ways we pay for things are likely to help in the drive against financial crime and online scams. But we all, young and old, need to educate ourselves and be aware of the dangers.

Further reading on fraud: