Sunday 19 July 2015

choosing a UK business bank account



Related:
Choosing a UK business bank account <this page
https://veg-buildlog.blogspot.com/2015/07/setting-up-shop-with-uk-business-bank.html
Free, Fast and Pretty: shopping cart software for ecommerce <links back
https://veg-buildlog.blogspot.com/2015/06/shopping-cart-software-for-ecommerce.html
Simple Bookkeeping and Account Agregators <links back
https://veg-buildlog.blogspot.com/2015/12/simple-book-keeping-and-account.html
Free Online Bookkeeping Software for Simple Accounts <links back
https://veg-buildlog.blogspot.com/2016/08/free-online-book-keeping-software-for.html
Boring Economics is Interesting - long rambling post about being a UK economics student during the 1980s recession - no link back
https://veg-buildlog.blogspot.com/2015/10/boring-economics-teaching-is-interesting.html

Choosing a UK business bank account - introduction

"How do I choose a bank account for a tech startup in East London? I have no money." This question came-up somewhere and I had a go at answering:  A couple of other answers were "I have been refused". Maybe that refusal helps both sides. 
Do you need a business overdraft? No. Do you need funding for assets? - Do you need a business name on a bank account? maybe not - Do you want to book-keeping aids to tag categories like costs and sales to pay tax? Yes. -  Merchant accounts and currency conversion - What government can do

Do you need a business overdraft? No.



You've read the news. You know the name Fred Goodwin. If you didn't work for him directly, selling dodgy banking products to avoid being sacked, you worked for him indirectly because your taxes bail-out his creations. Maybe you have dealt with firms that are crippled by dodgy banking products sold by the likes of Goodwin. Nobody needs the trouble of doing business with a UK bank.

P2Pmoney.co.uk
has some better ideas for business borrowing. The one they like to promote is for established businesses on P2Pmoney.co.uk/compare/business.htm - not that it is a good one for lenders.


I've read that Handelsbanken.co.uk and Aldermore.co.uk banks are un-typical if you really must get an overdraft, but working from home and spending nothing is a cheaper option. Handelsbanken are staff-owned, and use HSBC for their back-end software so the usual software could make sense of their statements for your accounts. The new Oaknorth Bank hope to lend to smaller businesses too.


Business funding without funding


Better still, keep a part-time day job until some money comes-in.

If the business is a good one, money will come-in to re-invest and if not, not; a business plan may disagree but there is no need to agonise or pay money for more business plans.


Porridge oats are under a pound a kilo as is pasta and some well-known root vegetables. If your new-found business partners are not amused at an offer to spli bulk packs of vegetables from Iceland, maybe they are not good at business. Unless they have some knowledge of value brands - that's another test.

If you need to cover your own living costs while the business is small, you could try moving somewhere cheaper than Shoreditch like Ayreshire, County Durham, Bolton or Gwent where you will also find more available staff, but not probably not a day-job unless it is something you can do remotely.
hair clippers

You could look-out for hair clippers like the picture on the right, and save the cost of haircuts. They come with a few clip-on things to cut at lengths an eighth of an inch apart, and you can get extra ones to cut up to an inch, which is called a number eight.

You could look at builders and copy their style of clothes as well - some of them wear quick-dry clothes that dry on a hanger after washing in the sink.

If your startup has anything to do with manufacturing, it would be good to be near the factories in your trade and save having to own loads of stock while it's on the boat from China. If it needs graduates in accountancy or computer science, you could experiment with Unistats to find clues about the areas with the cheapest graduate accountants or computer scientists. For accountants the areas are Colerane and Hull. If your business plans to sell stretch-fabric clothes, there is a factory in Gwent that makes them, in a postcode where Zoopla quotes 20% of the range housing sales under £50,000 and £500 a month an average rental price.   There is a list of factories like that on the new PantstoPoverty.org.uk web site. And in some postcodes it's worth trying to understand obscure government grants which don't apply in most areas and tend to be very specific. There is a map of postcodes in assisted areas.

If your business plan says "spend a million pounds mainly on advertising a brand so we can sell our £30 T shirts before the competition", ask yourself: wouldn't people prefer to buy cheaper for lack of a million pound debt at the supplier? And when tech-hub startups move to Shoreditch they just put-up property prices and discourage the shoe wholesalers and bag factories that still survive there. If you have to move there, maybe you should sell shoes and bags from the wholesalers and factories in Shoreditch alongside your tech startup. The wholesalers sell blingey Italian shoes along Shoreditch high street.This guide to buying looks a bit complicated but everyone has their own style; you have to do a lot of work finding a supplier, and find out what they want to make in terms of what designs they are used to churning-out on their machines, what their minimums are for free set-up or free delivery, and what's a typical lead time. There was a childrens-wear sewing factory in Bentley Road off Balls Pond Road for example. They had no web site and were had to track-down, but if you wanted the quantities and products the wanted to make, they'd probably work-out a price and save you importing a container-load from China with a 3-month lead time. I think they were called Figgins and have moved to Essex; I don't know if they still want orders. Jumping back to tech startups, it might be cheaper to move to the welsh valleys or the north east for cheap housing when you go full-time, so you have lower costs and you don't crowd-out the firms already operating in Shoreditch.

If you want a business loan for a small amount like £3,000, now that you have sourced your products from the UK and kept your day job part-time, you might try the loans available to lure the unwary into debt. There are lots of them. Cash transfer credit card offers are a good search, because balance transfer cards only allow you to transfer debt from another credit card, and it usually costs something like 2.4% via Paypal to take that credit limit out of the credit card account. Exceptions have cropped-up in the past, called "mule cards" apparently, but not very often as the Smiths lyric says.

Credit cards for personal use try to make themselves hard to use for business. The statement data might be down-load-able to an accounts programme, but it will build-up a debt between the statement date and the date of the direct debt, and the columns will be presented in a bamboozling way. Some kind of accounts software is probably necessary to fight back. Or maybe a system of using two credit cards - one for the first two weeks of the month, paid-off in week four, and another for the second two weeks of the month, paid-off in week two. This is so much easier to write than to do in practice that I suggest software to keep track with the other idea as a sideline.

Oh, an afterthought about cheap eating. It has to be fairly quick as well, if you are earning and possibly doing two jobs, so things like wholesale markets and grow-your-own don't really help, but there is a list of some cheap food shops at the end of another post about selling surplus food.
Do you need a business overdraft? No. Do you need funding for assets? - Do you need a business name on a bank account? maybe not - Do you want to book-keeping aids to tag categories like costs and sales to pay tax? Yes. -  Merchant accounts and currency conversion - What government can do


Do you need funding for assets?


victorian machine sketched in black and whiteThis is an asset. You can see that it has scrap value and a possibly higher value as a second-hand machine, minus high transport costs and depending on the right market for sale at short notice. Like cars, but much more awkward with a narrower market and harder to move.

If value can be demonstrated with photos and links to sites where such machines are traded, there is a good case to persuade people on a P2P funding site to finance your asset. Thinking of which, you should also buy your machines at the same places where your receiver would sell them, so you don't have to borrow so much money. This is a big deal and everyone has their own style.

  • Recession-people agonise for days and months about how to get things for next to nothing. They quite enjoy it, but it takes away time from other bits of the work. The process helps them understand the market for things relevant to their business, like the cost of repairs.
  • Boom people save days and months by buying things new on credit and earn the money back in time saved, or not, and they somehow expect creditors to go-along with this one-way bet in which everybody wins if things go well and the creditor looses if things go badly. Boom people tend to think that they have some niche market  like gastro-pub or super-soft matrass which allows an implausible mark-up.
Sometimes conditions make recession people or boom people feel that they made the right decision, but I think the decision is bred-in from life experience and upbringing; reality doesn't change it and I don't know if boom people or recession people do better at business. You tend to find boom people on Crowdcube or Seedrs asking for another funding round; you tend not to find recession people; they are hidden at home or in cheap workspace. There's an article about some matress manufacturers who are just about in the middle - half way between recession people and boom people - and they seem to do OK. On the gross side, a company called Eve charges £500 per matrass, mainly for advertising on borrowed money. Another mattress manufacturer can sell a retail double for £50 £60 or £70 including VAT, and an ebay search for new double "matress made in" comes-up with similar prices.

One piece of evidence is the number of stories of refugees doing well in business, often in Hackney or Leicester or inner-city areas and often by knowing how to do something in a smaller workshop, for smaller batch-sizes, and on a lower pay-scale than is normal in more established companies. Hugenots and Jews set the tradition. If you can find a Syrian refugee with factory experience making cotton or whatever else they do on Syria, you might be on to something. In any case, the workshop that can make things on a smaller scale than Ford or NASSA is quite likely in an inner city. Somewhere that council would like to demolish for car-parking and tech hubs, and move to an industrial estate a bus-ride away outside the ring road.

Stock

Making-it-up-as-you-go-along is a phrase we learn as children, and learn again in business to avoid the cost of stock finance.

When making objects, it's good to be able to make top-ups and trials on the kitchen table while having a more efficient factory make batches of what sells. That keeps the factory happier and your stock cheaper to maintain, because you don't have a load of extreme sizes of a piece of clothing, hanging around, costing you credit. Buying from a wholesaler could be another option. Restaurant kitchens have intricate breakdowns of what is freezable or food, what is prepared before people order, and what is mixed-together and cooked on the day after the orders come-in, or maybe put on a buffet where people can see what's left as the food runs-out.

Rent

If you can't find a workshop to sell  anything at all like what you want, and still need an asset, then rent could be a problem as well. Ideally, you live somewhere with spare space like a farm or a place with a garage you can clear for your asset. This is unlikely in Shoreditch so there comes a point when your mum / flatmate / landlord / hostel / tent becomes full of the assets needed for heavy industry.

You could google terms like "hackerspace" and "makerlab" looking for people who will let you store your asset or let you use theirs. Hackney is a hotbed for this. I have not joined any of these but can add a few early search results - http://openworkshopnetwork.com - http://www.hackspace.org.uk/ - https://www.nesta.org.uk/sites/default/files/open_dataset_of_uk_makerspaces_users_guide.pdf -
https://maps.london.gov.uk/workspaces/

You could, a last resort, you could try renting the cheapest space on Estates Gazette near Shoreditch, but that raises the problem of commuting to the darn place or leaving it empty when not needed, and of dealing with landlords. From a very little bit of experience,  I think London landlords will not get out of bed to pay-in a cheque for under £1,000 a month and some of them put every concievable unfair clause into the lease so you need to find a cheap virtual lawyer to check and try to get those clauses taken-out of the contract before you sign.

Repairs

If you have time, you should find out as much as you can about servicing the machines you have bought on ebay or apex auctions or for-sale co uk or whatever site. Otherwise you are asking lenders to fund a dealers' markup, which can't be sold if things go wrong. It's like something lost down the drain.

IT and coms costs

The lobbeys of concert halls and libraries are full, stuffed with people using free wifi. Whoever they are and whatever they are doing, some of them might be saving startup costs. On which point, Pete Foreman's PAYG tariffs guide is the best link on an otherwise rather vague page on this same blog about cheap used phones and pay as you go chips, which are another communications cost. The pay-as-you-go site sometimes lists options for a little free data roaming as well as low-tariff sim cards.
It lists deals that change every year or two as well as more stable ones which I guess are the ones directly from Three or O2 classic.

While thinking, you should sign-up with a free cashback site in case it happens to have cashback on something you would have bought anyway.

A brand for increasing the price of T shirts

If your asset is something like "a brand for increasing the price of T shirts", then it costs nothing to dream-up and might earn nothing if sold fast. This is why people tend to work in trades and professions and intellectual property; they hope to become self-employed without massive amounts of capital, rent, or staff, by living on their wits; they should not need funding. They should be able to do other things like doing a part-time day job and maybe sharing customers with others in the same position (I am going from T shirts to things like law and accountancy here but there is probably an equivalent for T shirts).

There was a time when a brand like Clarks Shoes was worth more than expected and could be even more valuable if separated from expensive factories in the UK. That was a nieve time, and I hope that consumers are more savvy to the fact that the brand feels nice to wear because staff are paid a UK wage; another brand on a UK-made shoe should sell almost as well, while the famous brand on a Chinese shoe should sell much worse. I hope that's where the market is heading.
Do you need a business overdraft? No. Do you need funding for assets? - Do you need a business name on a bank account? maybe not - Do you want to book-keeping aids to tag categories like costs and sales to pay tax? Yes. -  Merchant accounts and currency conversion - What government can do

Do you need a business name on a bank account? - maybe not.


I run an online shop selling nonleather footwear with a separate but personal-name account. A lot of bitcoin brokers do the same. I asked Bittylicious, the web site that works with bitcoin brokers, what personal accounts they recommended and was told that Santander is a favourite. My personal account is at another bank again, so there's no need to trouble one bank with a request for two similar but separate accounts. Separate bank accounts are required by common sense and minimum legal standards of tax reporting. I've never found banking a problem. If you set-up a face-to-face stall, then cash payments might be a problem and cheap cash sorting machines make it easier to bag and pay-in. Metrobank offers use of their machines free. If you want an account for vanishingly rare cheques made-out to your business name, then maybe someone with a business bank account can ask their bank to call it "trading as... x y and z" on the software. Once a customer has made the decision to pay them so-much-a-month, banks are less fussy about what's written on the name of the account. They might even write "trading as... x y and z" on the software title of your personal account, but their desire to get money for nothing might prevent them doing that and even prompt them to close your personal account.

If your existing account allows you do download a spreadsheet of a years' transactions in midata format, that can be used to make account comparison web sites more accurate. TSB and Halifax came at the top of my lists, but Halifax prove a bit awkward for the overseas spending card I have with them so that leaves TSB.
https://www.gov.uk/government/news/the-midata-vision-of-consumer-empowerment has the background and https://money.gocompare.com/currentaccounts/midata#/ does the comparison.

If you limit your liability with a registered company, it's more usual to have a company account. You want people to know what they are dealing-with and that liablity is limited, just as they do. There is a work-around. Say your name is J Blogs (if that is your name - I don't know - but you don't have to say it aloud) you could have a company called J Blogs Ltd. That might help make things look cool to everyone, if you are using an account called "J Blogs". Maybe the bank will pay in cheques to "J Blogs" without the "Ltd", or more likely nobody will ever send you a cheque.

The VAT system requires a bank account that any rebates can be paid-in to. "This must be an account held in the UK and the account name must match the business name you are registering with VAT", according to the guidance notes to the VAT1 registration form, on un-known authority and without detail about the closeness of "match". I emailed to ask, and got a helpful phone call a week later: "I can't say any more than what's in the handbook ... if we have to pay a company, then the bank account has to match the company name, and it's a company account then it would have 'ltd' as part of the name of the account". I guess that means it's worth a try calling a company J Blogs with a bank account called J Blogs. If there is an insurmountable problem worth more than the cost of a business bank account, then you can open one. Maybe in the future there will be a free business bank account available somewhere.

You might expect a law that the account must be in a company name because there's law about letters emails and faxes, but not the name of the bank account. People here seem to have researched the subject and think the same. They and the staff of Companies House are sure that any law would be in the Companies Act, which you'd want to look at if you set-up a company. I think there are more general laws about not decieving people, and advisers like this accountant in brighton list some things to be guard against, somehow, if you look like the same thing as the limited company.
1) Limited liability, maybe if a supplier doesn't update invoice information and calls you by the non-limited name. Then they can try to argue that they didn't know you were limited.
2) Requests for extra information during a tax inspection of an inspector thinks it worth checking your personal accounts as well.
3) Decisions about the rate of tax, if for some reason the company pays a lower tax than you do and HMRC think there's a false distinction.

I don't know enough about tax to know what that situation would be, and the accountant's advice is to keep things simple-looking rather than have an account with "ltd" in the name in all cases.

There's also a point made about grabbing money out of the account which gets interpreted later as something unexpected - a director's loan for example - which I don't understand, and applies whatever bank account you have.

Update mid 2018 - Starling Bank now offer free accounts in a business name to smaller limited companies - I think the limit is something like ten staff and one director. The account looks as though it works on IoS and Android but probably not Windows. There is a free opening offer to other limited companies. Starling Bank works on MoneyDashboard for automatic categorising of expenses, although that program is aimed at private customers and doesn't do anything quite the way you want for business; there are probably accounts programs that work with Starling too.   Update mid 2017: Tide.co, Transferwise Borderless Bank Account, Bunq for Eurozone residents, and the more expensive Fire.com that has a £100 setup fee. Coconut hope to have accounts for limited companies in the future, after starting on freelancers.

Tide.co costs 20p for most transactions in or out and includes a mastercard that can be used without charge. BACS inbound payments are a free exception, apparently, but as you have no control over whether banks use BACS or Faster Payments, that's not much help to know. Bank transfers to other currencies aren't yet available this July 2017, although rival Fire.com does offer them.

There is a discussion on their comments page about when they might be able to accept HMRC refund payments such as VAT or whether there is any way of paying them in. The answer is yes.

Just to be different, you share part of their Barclays bank account rather than having your own, but I imagine that you can pay-in cheques in your company name, and their logon page has a little bit of book-keeping software to categorise transactions built-in, so that's a good thing.
Transferwise
Allows payments into its borderless bank account, but there is backlog of applicants and id-checking is slow. If you have a personal account and want to register again as a director of a business in the business name, the process stops on screen; the "save" button doesn't work. If another director does it, then the application goes OK if done from another browser.

If you just need a business-name bank account for VAT refunds, maybe you could g

When I first tried to sign-up it said
Your GBP details
Account Number
1000xxxx
UK Sort Code
23-xx-xx
Account Holder
TW/J ROBERTSON
Transferwise also has some odd terms in its agreement for European Economic Area applicans. None of these may use the bank account too obviously,

1.3

  • (a) charities (unless they are established in Canada, European Economic Area (“EEA”), Switzerland, US or New Zealand);
  • (b) unregistered UK charities; or
  • (c) trusts (unless they are established in Canada, EEA or Switzerland).
1.4  banary options, bitcoin and alternative currencies ... seeds and plants.
1.5 You may only use your TransferWise Account Number (as we provided to you) to receive funds into your TransferWise Account for the following purposes:
  • (a) Receiving your own salary and/or wages;
  • (b) Receiving payouts from e-commerce and freelancer platforms;
  • (c) Receiving payments from family, friends or other people you know for personal purposes; or
  • (d) Receiving payments from your clients and other third parties for the purpose of business payments.
1.6 You shall not use your TransferWise Account for the following purposes:
  • (a) receiving payouts or withdrawals from electronic money platforms/services/providers;
  • (b) receiving payouts from short term lenders; or
  • (c) setting up direct debits on your TransferWise Account.
The "Can I pay by card?" page says yes for 1.7%  on a "business card", 0.3% on other sterling visa and mastercard, and 0% for debit cards. Similar slightly higher rates for euro.

The pricing page mentions a 50p charge for transferring money to a UK bank account, or .6€ or US$1.30.  Inbound payments are the same unless made by debit card by the look of it. The page urls this summer 2017 are
https://transferwise.com/borderless-account/
https://transferwise.com/terms-and-conditions
https://transferwise.com/help/topics/99/questions/2736136/borderless-account-pricing-limits
...but I hope you will use
Transferwise to sign-up for the usual reasons.
http://www.bankingtech.com/570702/uk-challenger-banks-whos-who-and-whats-their-tech/ is a list. You'd think that someone could do it on the cheap or take-over part of a bank that's pulling out of the market, like Airdriesavingsbank.com, but no. (Airdre tried to offer a bundle of face to face services to a shrinking, aging customer base near Airdrie in Scotland. They required new customers to come to Airdrie for a face to face interview. They were last heard-of promising a merger with TSB after a marathon history as an independent bank after they lost the will to live a year or so ago).
A glance at fees this August 2017 suggests £1.50 per withdrawal but generally pretty cheap and geared to currency transfer, and accepting payments from overseas bank accounts. I didn't get to the bit about debit cards but there seems to be one.

https://www.bunq.com/en/business offer free eurozone personal bank accounts by the look of it, to residents of the European Union, and €12 a year company accounts in Austria Germany and the Netherlands this July 2017..
Business customers have to meet some conditions on here:
https://together.bunq.com/topic/who-can-use-bunq : "...

- You are an authorised representative of the company.
- You have a personal bunq account
- You have an active registration number from the Chamber of Commerce in The Netherlands, a Handelregisternummer in Germany or a Firmenbucheintragung in Austria.
- Less than 50% of the entity gross income consists of passive income. "
https://together.bunq.com/topic/how-do-i-open-a-business-account-with-bunq_1
" We also assess companies based on the risk profile, and can thus decide whether or not a company can open a business account based on certain characteristics (activities, shareholders, etc.). "


https://www.metrobankonline.co.uk business instant access deposit account
£5 a cheque but free online banking. So if you needed a cheque, which is unlikely, you could transfer money some other private account that offers a cheque book.   The spec. is a long piece of stuff that reads like the script of a childrens' TV program and doesn't get to the nitty-gritty. Or maybe something from a housing association. Does online banking include online payments to suppliers, or just something that "deposit account" implies, like transfer to another metrobank account? Could they change it at a whim with a bit of annoying language? You'd have to ask them, but the account could be good. It also pays just enough interest to cause extra book-keeping without being enough to buy a cup of tea to drink while you are doing the books.

https://moneyfacts.co.uk/business/business-prepaid-cards/ includes cashplus, which sells itself as an alternative to a business bank account, able to work in a company name for invoices and mastercard payments or tax rebates, so long as you don't need to pay-in a paper cheque. It comes-up on the same searches as Tide.co and Transferwise Borderless Bank account. The fee turns out to be "
Card issue fee £69.00" in very small print on the back of the online statement, with a footnote "payable annually therafter".
Business Account Finder - British Bankers Association is the link for comparing accounts in a business name. There used to be some "free forever" ones at RBS, Santander and HBOS, but after reading the first 21 pages of a moneysavingexpert thread I see that each bank withdrew their offer and they now charge £5.50-£7.50ish a month, sometimes with free extra automated transactions if you don't use any manual ones. Business Account Finder does not sort accounts for the cheapest standing charge, so you have to look at every single entry to find a free one and then check the bank's web site to see if the thing is still free.

I have some hopes of an online-only Metrobank account but haven't checked yet.

One user on moneysavingexpert suggested Cumberland Building Society's Business Bank Account - at the time they had a free offer to locals. There is still a free offer for schools on their web site, otherwise a calculator to work out monthly charges charging options for cash or electronic businesses with slightly different charges plus five or three pounds a month. "
If you are looking to discuss a current account outside of the Society’s operating area, please call our Customer Service Team on 01228 403141".

Another money saving expert suggested Carter Allen who "traditionally have offered free banking to IT contractors, however you would now need to be recommeneded by an intermediary". A third mentioned ICCI who have a business account that seems to have no monthly fees but is geared to import / export companies and doesn't have much clarity attached about whether someone like a plumber in the UK can use it. There is a long PDF application form that asks for a solicitor or accountant to witness one or two things, and asks your existing turnover in thousands. It also asks you to repeat various names as directors, people of significant financial control, and so-on. All on a form that converts numbers into currency by mistake. I decided after a while that this free bank account wasn't available to me, but you may have better luck.

Company Formation


If your business registers as a limited company, there is a list of company formation agents that are sometimes cheaper than Companies House's own £13 charge and sometimes have cashback offers at banks. http://www.planwriter.co.uk/company-formation-agent.php has one or two, that turn-out not to exist any more on search engines, but if you search every now and then for a day or two then good offers come-up on the bing and google ads. If you search Companies House web pages for "company formation agents and secretarial agents", they have a full list of people hooked-up to their software. The most expensive was over £500; no cheaper ones emerged. If you have time to shop around, a better use of it is to use bing and google for a few minutes a day over a day or two. After a while, offers appear in the paid-for ads - my cheapest turned up on Bing, quoting £5 at The Formations Company.

Bundled legal insurance and business banking with Co-Op and FSB

If your business is large enough to employ staff, it might benefit from the bundle of services including a Co-Op business bank account (usually £5 a month after the first 18 months) from Federation of Small Businesses, who have a minimum charge that rises with turnover. You have to ring them to find out the charge. This bunch called Business Banking Insight phoned to do a business banking user survey, which didn't quite fit reality because if you have an own-name account and don't use business banking services, it's hard to rate your business banking services out of ten. People who actively chose their business bank and use it tend to give high scores. Whores bank is top of the list.
Do you need a business overdraft? No. Do you need funding for assets? - Do you need a business name on a bank account? maybe not - Do you want to book-keeping aids to tag categories like costs and sales to pay tax? Yes. -  Merchant accounts and currency conversion - What government can do

Do you want book-keeping aids tagging categories like costs & sales to pay tax? Yes.

Online accounts software probably appeals to a low-budget tech startup more. It's easier to share with an accountant if you need to pay for help, or with colleagues if you aren't renting an office or working near each other. This link is to a separate post, just about free online accounts software. Isn't that good?

Thanks for paying tax. You help pay for my government services.
The bank statement is the most accurate and automated book-keeping aid for tax payers.

https://www.gov.uk/simpler-income-tax-cash-basis suits small business

If your turnover crosses the gov.uk/vat-registration-thresholds you have to do
https://www.gov.uk/vat-record-keeping


You need to download the bank statement each month (1507.xls as a file name for month seven in 2015 for example) and tag each line to a category before you forget what that mystery paypal payment was.

Bank software often downloads bank statements in particular flavours of an un-documented format called .qif - Quicken Interchange Format - which is best avoided. Download a file in every other available format in case one such as .pdf or .csv has detail which another lacks.

You also need one credit card per type of transaction paid with a credit card, such as one credit card for delivery costs and one for travel. Otherwise you need to account for each line of the credit card statements as well, and how they interact with the bank statement, which is fiddly work for no benefit. Look on moneysavingexpert for cashback visa and mastercards in personal names that might give you .5% cashback and up to one months' credit. These need have nothing to do with the business bank account except being set to withdraw the full balance from it each month by direct debit. If you try to include their statements in your accounting systems you'll discover gotchas to discourage business use, like the direct debit day being different from the statement day, but if you keep one card per type of transaction such as one for travel and one for postage, you don't need to worry so much about their statements.

Barclays private accounts do allow some categorization on their online bank statements. Co-op / Smile used to be hard to download; you needed to cut and paste or trust waveaps to do it for you (see below) but most accounts now let you download a .csv file each month.

Talking of accounting, a free spreadsheet for keeping track of each line of account is useful.
Different software and different accounts programs go together better or worse.
Specialised ones will recognise regular transactions. Extra-good ones will track enough for you to do a VAT return, which I've never done. There are free ones for your hard disc here and there. I once tried Acemoney which is free for a single bank account and nicely designed for PC or Mac; programs like Quicken that I used for a few years were a pain with their closed-source file formats designed to keep you loyal and their "sunset policy" to try to force you to buy more of their software every-time the sun sets. Grisbi Gnucash & Turbocash were a bit compicated for what I needed, but entirely open source and free.

Waveaps is one of the few free online accounting programs on the tech radar list to have kept going for a few years, and it can scrape data from a large number of bank accounts. It states that it's working on systems to double-check data for errors caused by changes of format on online bank statements. Update - Pandle has a long-term free version too, without an automatic bank feed but with more carefully--expert-checked systems for UK VAT records. It's online like Waveapps and the bank feed costgs £5 a month with a few other bonus extras

https://mybrightbook.com/ is another free online accounting app that has kept going for a few years. It accepts bank statement files as .ofx or .qif with a special converter for Co-op files. 

Quickfile.co.uk, the online service, is the free accounts software that I use. Quickfile now charges £50 if you have more than 1000 transactions a year. The average is calculated each month, like VAT. That compares to zero for free software on your hard disc, zero for Waveapps, and zero for Brightbooks.

When I used to use Quickfile I discovered this. It likes to set-up accounts for money invoiced and not yet paid or received; you have to try to stop it doing that or things get complicated. It also helps if you have pretend customers like "paypal", and "merchant account", to save electronic accounting of those accounts, and to have pretend suppliers like "office stuff", rather than build-up a list of every stationary shop you've ever used your debit card at. VAT accounting might complicate things a bit.

Lastly, Quickfile will automatically download statements from one or two of the major UK banks: Barclays, Lloyds TSB Business Banking, HSBC Business Banking, Natwest, Royal Bank of Scotland, Santander Business Banking. These are done through their own Chrome browser plug-in.

That list of banks is worth checking-out, because it saves you downloading and up-loading the data from your bank to quickfile each month. If you do, most banks and probably all business banks let you download the data manually, while more of them let you keep a copy via Waveapps. These are formats for uploading to quickfile: Excel (csv), Microsoft Money (ofx), Quickbooks (qbo), Quicken (qif), Text file (txt) - Santander only - Santander personal accounts provide this
Do you need a business overdraft? No. Do you need funding for assets? - Do you need a business name on a bank account? maybe not - Do you want to book-keeping aids to tag categories like costs and sales to pay tax? Yes. -  Merchant accounts and currency conversion - What government can do

Do you need an accountant? I don't have one.

I don't know why people have accountants. Likely reasons include statutory account-signing for limited liability on a larger turnover, tax advice, spotting mistakes before the tax office, and out-sourcing of office work that is so routine that accountants know how to automate it.

On the other hand, Waveapps is free and does a lot of the book-keeping work except payroll. [update: Waveapps stopped automated European bank data upload in September 2019, because of the hassle of transferring to the new open bank data system, and say they will not work with UK government's Making Tax Digital requirements, both because their income comes from america and they don't want to spend time on customers in Europe. Open Banking sounds cheap to go-along-with but anyway it's up to them]

I've just come back with a meeting at Tax Assist who charge from £1295 per year for business accounts. This Guardian article suggests that a lot of people get deals around £10+VAT a month if paid annually, for one-person income tax returns under the VAT threshold, which could be good value for someone who's earning a lot and doesn't have a lot of time. Search "cheapest accountants" on Google or Bing to find H & Co at the same price - £8.34 a month + VAT minimum price for income tax.. This is H&C's price list, that's published with a hefty referral fee after each item.

Limited Company Accounts
£1,000

Sole Trader Accounts
£200

Contractors and Taxi Drivers (Under 12k PA)
£150

Contractors and Taxi Drivers (Up to 50k PA)
£200

Similar searches come-up with the same kind of price, but presumably the name of the accounts package ought to be part of the search if you want someone who can log-on and get the gist quickly. Not much comes-up under "cheap accountant waveapps". Wave's own advert pages ought to be a place to look - specially in areas of high accountancy graduate unemployment like Hull and Coleraine, but the results are more restrained and often out of date.

I have another blog post called "star courses" that says something about finding cheap accountancy graduates from Unistats data about their earnings, and don't know why the two findings don't match. I would expect to see people from Coleraine and Hull advertising on the pages of Waveapps and on Gumtree to offer themselves as book keepers and accountants, but that doesn't much happen. There is one cheap accountancy firm in Hull advertising on Waveapps. It could be that I am searching for the wrong things; one review site says that Waveapps is no good for VAT, so maybe the cheap accountants are busy on another piece of software.

Merchant accounts and currency conversion. 

Outfits like Paypal are a good start until you have some turnover. There is a new one for direct debits called Gocardless.co.uk which has one or two others working alongside for small commission between them. Whichever route you choose the charge to you is 1% 
Stripe are a good bet for card conversion. Before them I used Elavon Merchant Services who, towards the end, offered a web service with no need to hire a terminal. Apparently this is called the mobile pay-as-you-go version and they tell me that I now pay as much for it as I do for Paypal on some cards - the fees are broken down by card with debit cards cheapest. Worldpay has just emailed to say that they offer pay-as-you-go prices as well. I don't know if they have a deal that lets you use a web logon to their mobile version and save the price of terminal, or not, but that's what I do with Elavon. A thid provider cropped-up when I told Wave Apps that I had a limited company. Their online offer to Stripe suddenly got cheaper, with the headline rate at 1.4% but higher rates for overseas cards and no cheap rate for debit cards, so it is more expensive than the 1.4% figure first looks.

I don't know a site to publish prices given for card processing, but under 2% for credit cards is respectable, plus an amount for each transaction, and usually plus £15 a month for a terminal. There's a growing market in smartphone payment systems from the likes of SumUp, but they all assume you want to pay more than 2%, often plus a monthly payment, which personally I do not want to do. I want to sell UK-made goods on a lowish margin, and pay a little tax. I do not want to sell Chinese goods on a huge margin and not care how much paypal take, if there's a choice.

If you can get customers to pay by bank transfer, that's free to most accounts but don't advertise bank details if it's easy for people to set-up fraudulent direct debits. They appear on your account with plausible names like "£30 National Trust" or "£29.45 Virgin Media", and you have to contact your bank to cancel them straight away. Usually you get your money back.

Currency conversion. The P2P outfits Transferwise or Currencyfair will do a better job than any bank. Thomas Running's blog post about banking for nomads lists one or two "bank accounts for international travellers and nomads", excluding the UK's Ivobank which survived a year before it closed, but others may last longer. LHV Bank of Lithuania looked likely to offer a free euro account but needed an id.ee proof of identity, which costs just over €100. Then I discovered I was wrong, after buying the id but that was my fault.

For import and export companies, a new outfit called something like B2B Euro Account offer a minimal euro account with next to no fees except 1% currency conversion - I don't know if it's useful to anyone but found it by accident.
Good luck
Do you need a business overdraft? No. Do you need funding for assets? - Do you need a business name on a bank account? maybe not - Do you want to book-keeping aids to tag categories like costs and sales to pay tax? Yes. -  Merchant accounts and currency conversion - What government can do

What government can do

This is mainly for businesses that make things or buy from businesses that make things.


The Planning Act requires us not to do anything commercial in
residential zones unless we have been doing it since 1964, This
under-estimates the advantages to residential areas of seeing
people at work and having a variety of people about. The act is
less enforced than it might be; work at home is tolerated. But
landlords can still put clauses in their tenancies to say that
you should not run an alkaline works in your bedsit, or something
like that, which makes things harder for tenants, ant it's hard
for people with neighbours who complain about smelting or tyre
recycling or perfectly useful things on their doorstep.

A second problem is that businesses cannot find each other. Government
has information about who pays taxes for what, whether companies
or sole traders registered for VAT. Government doesn't find any
way to get this information for free into trade directories so
that someone who wants twelve pairs of shoes made in the UK, or
a special widget, can't get it done in the UK. At the moment the
Revenue and Customs Act forbids this kind of tax information being
used for any other purpose - even tp answer freedom of infomation
requests or go in something like Kompass Directory. The answer
is to release it next to each company on the Companies House web
site.

A third problem is that something can be made in China, without
the costs of a welfare state, and shipped to the UK practically
free under an International Postal Union treaty that's meant to
help developing countries, apparently. When the goods come-in,
there is no way that anyone can check each envelope for VAT liability.
These goods compete with goods sold in shops that have to pay
VAT, rent, rates, insurance, and employ staff. There is no way
that shops with these costs can compete with online imports that
don't. You can't even compete on ebay if you try to sell the same
thing second hand: your postage costs are too high. The answer
is to have postage from China set at the commercial rate, plus
a tax to reflect the lower costs of Chinese production that come
from unfair competition; from the lack of democracy or a welfare
state that are expensive.


A fourth problem sounds a bit like the first one. Government often
subsidises imports, sometimes, to reduce prices and inflation,
and shouldn't do it in future.

It's called Monetary Policy, it's managed by the Bank of England,
and it works by government paying a higher rate of interest than
it needs to do on government debt. So we all pay a bit more, overseas
investors buy pounds to lend, and the value of pounds goes up.
That makes it unfairly difficult for people to make things in
the UK and compete with imports or when selling abroad. So: economists
need to come-up with a better system for reducing inflation and
admit that the previous one was not ideal if you live in the north
of England or Wales or Scotland or you want to work in manufacturing.
Nobody has ever apologised for this policy that closed a fifth
of manufacturing in the five years after 1979 leaving a quarter
of the workforce unemployed, sick, or on government schemes. According
to economists and newspapers it was a success.


Magenta 14's guide to security, from a post on Rebuildingsociety, posted here so that I have somewhere to read it more carefully - I haven't really got the hang. Rebuildingsociety now publish a guide to borrowers and lenders about security, linked straight from their front page.

Magenta14: A wee guide to Security for reference.

  • magenta14
    Hi all,
    When I 1st joined ReBS in late February 2014 I found myself bewildered by the types of Guarantees, or combinations thereof, offered to secure my family’s funds. Like many perhaps it’s a rapid learning curve resulting in my largest single Default £400 + sustained in 2014. 18 months on those funds with Mowbray & Son’s are still outstanding. [Please take a wee look at that loan site for information on the work recoveries have done on behalf of myself and other Lenders...

    Though oft times a very tricky task to decide who to lend to so to help you make up your minds if you wish to lend then here's a guide to the Guarantee's to help you reduce your risk and give you a better chance of getting a little, some, some more. Or all of your funds back in the event of a default.
    Lending can be a seriously risky business so [when NOT if a 'marital breakdown' occurs make sure you are using the best protection to secure your assets.
    Happy reading and take care,
    James.

    A] Personal Guarantee.

    Note: Very Commonly offered to ‘protect’ a loan here at ReBS…You may wish to consider how financially secure the person[s] are when this level of protection is offered to protect your funds, would they be able to meet their obligations in the event of a Default.

    Is the Business Owner capable, really know their market, is their Business model built on a strong foundation.


    Definition – What does Personal Guarantee mean?

    A personal guarantee is an arrangement that is signed and verified by a borrower, or a third party, in order to accept the liability for one’s own or a third party’s obligations or funds payable. The lender, or the first party, that takes this guarantee from the borrower, or a third party acting on the borrower’s behalf, can attach the guarantor’s personal assets in case the borrower fails to repay the debt or fails to meet any of the obligations covered by the guarantee. The personal guarantee is significant because it acts as a signed blank check. If the borrower defaults on a payment, the lender is directly eligible for the named property or asset without being required to attempt to recover the payment from the borrower. This guarantee is the basis of lending to startups in the absence of collaterals.

    Divestopedia explains Personal Guarantee:
    When a firm wishes to borrow funds, a personal guarantee signed by the owners or promoters as well as a third person, in some cases, may be insisted upon by the lender. This is especially true for a startup. This guarantee is demanded in order to reduce the risk of a loan default. Many firms have a limited liability status, in which case the partners and shareholders have a very nominal liability. In such cases, the assets of the firm are pledged for a loan, and a personal guarantee, signed by the owners or directors, is the backup for a larger quantum of borrowing. If there is a personal guarantee given by a third party or the partners or directors of the firm, the personal assets of the guarantors can be attached immediately, which ensures the quick recovery of debts and other obligations, without even seeking recovery from the original borrowing firm. Normally, liquidating assets and recovering cash is a lengthy and complicated process, and a personal guarantee provides additional convenience to lenders. From the borrower’s point of view, personal guarantee is not the preferred option. Instead of signing a personal guarantee, a pledging of some specific assets as collateral can be considered by the borrower, in which case the borrower may save some of his or her assets and spousal assets, in case the loan is not repaid in time.

    A.1] What is Personal Guarantee Insurance?

    Here’s a link to follow to provide a wee guide on this product, hope it helps?
    http://www.begbies-traynorgroup.com/articles/director-advice/what-is-personal-guarantee-insurance .

    B] Corporate Guarantee

    Note: Certain Lenders at ReBS actively seek to secure this type of guarantee because of the enhanced protection it affords to their own and other peoples Lent Funds.

    Definition of “Corporate Guarantee”:
    A Corporate Guarantee is a guarantee in which a corporation agrees to be held responsible for completing the duties and obligations of a debtor to a lender, in the event that the debtor fails to fulfill the terms of the debtor-lender contract. Also known as a corporate guaranty.

    C] Cross Guarantee:

    Note: Certain Lenders at ReBS actively seek to secure this type of guarantee because of the enhanced protection it affords to their own and other peoples Lent Funds.

    Definition – What does Cross Guarantee mean?:

    A cross guarantee is an arrangement between two or more related firms to provide reciprocal guarantees for each other’s liabilities, fulfillment of promises, or obligations. This guarantee is agreed upon among related companies, such as groups of companies or a parent company and subsidiaries and affiliates. A creditor of any one firm of the group becomes the creditor of every other firm of the group.

    It is significant because the contractual promise reduces the risk of the lenders, thus enabling borrowers to negotiate for a better deal. Cross guarantee may be beneficial to borrower with respect to better interest rates, tenure of repayment, and/ or quantum of loan.

    Divestopedia explains Cross Guarantee:
    The place where cross guarantees become cross border guarantees might invite scrutiny of regulators of different countries. Cross guarantees must be disclosed under contingent liability, along with lawsuits and warranties with the balance sheets. Sometimes implicit cross guarantee may be implied merely by the passive association of a firm with a firm of global or regional reputation, and a higher credit rating may result from this situation.
    While drafting the guarantee agreement, it is customary to include a clause of indemnity to give additional advantage to the lender. In such cases, the courts may favor the lender by interpreting the agreement as an indemnity bond, which makes it unfavorable from the guarantor’s point of view. The capacity to give cross guarantee should be based on the article of association of the firms. If the directors are the beneficiaries of the guarantee, then the shareholders approval may be required. The lender can enforce a guarantee even if the security of principal borrowers’ assets is held by him.

    D] First Charge [Exceptionally rare here at ReBS].

    Note: Affords Lenders a high degree of protection in return for receiving a very favourable loan rate.
    A legal right under which the owner of the first charge has the right to decide on what to do with a property if the borrower fails to maintain the repayments i.e. the mortgage lender will in most cases hold the first charge on a property until the mortgage is fully repaid.

    E] What is a ‘Second Charge’? [Commonly offered at ReBS].

    Note: You wish to look for a high equity value in the Property or Properties being offered as 2nd charge security because in a default situation the 1st charge holder may choose to sell the Property below market value Just to recover their own funds. Please consider that the 1st charge holder is under no obligation to protect the interests of the 2nd charge holder.
    A Second Charge is a legal charge put on a property in favour of a lender, or creditor. A Second Charge comes second in line to a ‘First Charge’, which would normally be your mortgage.
    When the property gets sold, the First Charge – i.e. the mortgage, will be cleared in full before the Second Charge receives any money. The Second Charge would then be in line to receive funds from the sale, up to the full outstanding balance of the Second Charge.
    Any funds remaining from the sale at this point would be passed to the seller.
    In closing:
    For those of you like me who may struggle with all the various security types offered to you by prospective Borrowers at ReBS I have spent some time today seeking out the definitions that have been presented in the clearest English rather than something more complicated.
    [Life's too short, keep it simple, keep safe].
    Hope you find the information helpful, please feel free to retain for future reference.
    With Best regards, James.
    Vote This Post DownVote This Post Up (+4 rating, 4 votes)

    F] Debentures:

    Note: A strong form of lender Security provided the assets covered by the Debenture are Really worth something under an auction or ‘Fire Sale’ situation following on from a Company Insolvency.
    Some fellow Members will check to see what’s covered [Captured] by the Debenture [to work out it's value] Before lending their funds.

    When lending money to a company (or indeed a limited liability partnership), lenders want to ensure that their interests are protected as securely as possible. Debentures are a common method of obtaining security, under which a lender is typically granted both fixed and floating charges over all of a company’s assets and undertakings.

    With their combination of fixed and floating charges, debentures are intended to meet the need of companies for increased working capital by allowing additional borrowing secured on the circulating assets of a trading business. A debenture is widely accepted as a necessity for many corporate lending arrangements, in particular where there is not enough security over property alone for the lender to feel comfortable.

    The key distinction between a fixed and floating charge is that a lender has control of the assets subject to a fixed charge, whereas the borrower retains control over those assets subject to a floating charge.

    Fixed charges are typically granted by a borrower over assets such as freehold and leasehold properties, and fixtures such as plant and machinery if these are owned by the borrower. Fixed charges can also be granted over book debts, uncalled capital, goodwill and shares.A debenture will also typically include floating charges over present and future move able assets such as stock and unsecured fixtures. Floating charges are less attractive to a lender than fixed charges as they rank behind preferential creditors and certain other creditors in the event of a default by a borrower. The borrower is also able to deal with the assets subject to the charge in the ordinary course of business, by selling stock for example, without obtaining the lender’s consent, subject to any restrictions to the contrary in the debenture itself. Bank debentures are normally expressed to be “all monies” debentures: that is to say, they secure not only existing loans but all present and future loan advances. The all-encompassing nature of debentures makes them an attractive form of security for lenders, but equally unattractive to borrowers.
    Unfortunately for the borrower, in the event of a default, the lender has the right to appoint an administrator or administrative receiver to realise any assets subject to a fixed charge, and will be paid out of the proceeds in preference to other creditors. In such circumstances the lender would normally gain control over the assets which were subject to floating charges, which would crystallise to become fixed charges, leaving the borrower unable to deal with the assets in the ordinary course of business.

    In order to be enforceable, security under a debenture needs to be perfected. This involves registering the debenture document at Companies House, and may also involve obtaining prior consent by giving notice of the security interests to third parties and the registration of the security interest in other public registers such as the Land Registry.
    [Life's too short, keep it simple, keep your assets safe].
    Best regards, James.


    Bad economics degrees

    International Student Course Satisfaction
    Table of feedback scores for the economics degrees for the universities that take most international students. Most of the courses are at the bottom of the league table for student feedback, but presumably make most money because non-EU fees tend to be double EU fees.

    Blog on a single page
    the author sells vegan shoes online at Veganline.com
    , a UK online vegan shoe shop. Many of them are UK-made or European-made.

    O
    h I've just done a post about Keele Uni Economics teaching in the early 80s which was so bad it becomes interesting to know how bad an economics course can be. One reason seems to the that the McGraw Hill Company publishes stuff like lesson plans and lecture notes to anyone to use while teaching from the textbook, so if as a teacher you make some excuse to cancel the more interesting bits of the course


    By the way I have just done a blog post about Lord Sewell, who seems to have done nothing wrong except stating that his colleagues earn £300 a day for turning-up and dong F-all, which everybody knows but his colleagues don't want published in The Sun

Thursday 25 June 2015

Is Drupal Commerce still a pig for adding products?


Sometimes when walking around, it's easy to re-run an old journey just to see if anything has changed. It seems to happen on autopilot. I really meant to see if X-cart installs from Drupal, from among the shopping carts mentioned on another page, but I think it only links in some way.

I remembered why I started writing this blog about Drupal for ecommrece a few years ago, thinking it would be a temporary set of notes kept for a month until I could get a better veggie shoe shop site online - hence the blog name "buildlog". I remembered that Drupal plugins are rather exciting in inviting you to a techie world rather like the script installer on your web host. Drupal has a pre-arranged "distribution" for daily deals and another for a hotel selling bookings. It's easy to hope that there will be some module soon for whatever trade you are in, or maybe a developer could write something for you that would be much harder to write for standard shopping cart software, like a link to your accounts program or something more exciting perhaps. There is a chance to collabrate, which is more interesting than just competing. I remembered that you can install Drupal from there, then go to its admin page to install more modules. You can see the "Modules" link near the top right of the picture. Click on it and this is what you get:


You can find modules and themes on drupal.org.
The following file extensions are supported: zip tar tgz gz bz2.

For example: http://ftp.drupal.org/files/projects/name.tar.gz


If you can find the right module from the modules link, right-click to "copy link location", then go back to paste it into the "Install from a URL" box. Press "enter". If all goes well you get a barbour's-shop bar accross the screen for a while, then some message that includes a linke to "install new modules", which takes you back to the modules section of your admin screen.

Names of required but now missing modules are in red that you now have to track-down and install from the same site (it's not automatic). Then you can tick the box next to Drupal Commerce, press enter, and automatically the thing installs all the relevant modules with a the odd hickup where you have to press control+backarrow and try again. Finally you have a new admin column called "store" and an option to "add product".


It's not a lot of good is it? A bit liked a stipped-down racing car or a quadbike for someone who really wants a delivery van or a market stall or some other wheeled retail thing as a metaphor. In the USA where they watch films of cowboys and covered wagons or carts, they call the things shopping carts. The term is well-know in the internet retail trade. It is not what you write from the screen shown shown above.

There's no help about related issues like the categories of the catalogue and how they are laid-out, nor attributes, nor any warning on the page about this instruction:
On a clean install of Drupal Commerce, simply adding products to the backend is not enough to display them for sale with an Add to Cart form. Drupal Commerce separates the definition (on the back end) from the display (on the front end) of a product.

I tried a google search by date in case there's anything recent to say "this new module irons-out the techie awkwardness of doing the most basic things on this software", but not much came-up. Only one thing came-up in the last 12 months from 2015.06 .26 backwards.
No results. Except something 10-months old about writing your own php code, which very few shopkeepers are likely to want to do, unless they are sick of being shopkeepers and want to build a new career in php code-writing. Not many people would want to do both at once for long.

I tried searching modules on Drupal.org but find the search system hard to use. The Drupal Commerce site itself has a list of modules so I tried reading the title of every single one, loosing track a little.

DrupalCommerce.org still set themselves a dual role in bidding for big-budget work while promoting Drupal Commerce for the cheap or DIY work of which they have no direct experience to keep them up-to-date. If they could somehow find enthusiasts from among developers who do this kind of work to keep that part of the site up to date, that would be great.

They have a "distribution" category. They don't mention whether you can use a script installer on your web server and then press a button to upgrade Drupal to the full distribution; I don't know.
  • drupalcommerce.org/extensions/distribution/project/telekonsum
  • http://www.louisvillewebgroup.com/project/ecommify
  • they don't mention a new one - Drupalife Store mainly in Russian.
  • I doubt these are a first choice for a shopkeeper looking for a cheap e-commerce system because of the fiddleyness of installing Drupal without being able to use a script installer, but they may be good for shopkeepers who want a bit of this and that and some integration.
Drupal Commerce themselves have a "utilities" category. These can be installed onto a Drupal installation that comes from a script installer on a host site. Drupal Commerce mention a module as well as providing a screencast of how to use it, but it remains in Alpha release with no further development planned:
  • drupal.org/project/commerce_product_display_manager (thanks danielhjalmarson.com/wordpress)
  • drupal.org/project/commerce_simple got further (thanks w3shaman.com)
  • drupal.org/project/commerce_auto_product_display is actively maintained I think - this page is a note in progress and I may change it in a day or two. 
      • If the module is perfect, there's still the problem of the people who write Drupal-based shopping cart software, usually for a living as part of some company and think it OK to promote software to small business which is no good for small business; it is a kit for web developers. I don't know if it's chance that Wordpress shopping carts have problems fitting-in to their market too. I haven't tried Joomla-based shopping carts but maybe they don't know what their prospects want either. A bit like most of us in other parts of life but I shall stick to technical discussion of shopping cart software.

Wednesday 24 June 2015

A tourist guide to Royal Mail for small ecommerce shops & web developers

Introduction: Royal Mail for ecommerce


picture of a letter box
A frustration of using ecommerce software in the UK or outside the US is that so few web developers write a postage module for the simplest basic postal service. They don't even write a tablequote kit so that a shopkeeper can fill-in a managable small table of their own prices for zones and weights, like this:
  • UK - where a 2nd class 2kg parcel can be posted for £2.80 and there is a 2.5cm "large letter size" that goes cheaper up to 750g
  • "Europe" with a fiddly "UK zone B" for the Channel Islands, and 64 other countries
  • "Worldwide Zone 1", which is everything else except
  • "Worldwide Zone 2" with 34 countries.
    The zones outside the UK have detailed price / weight tables.
    There is a table further down this page for converting Royal Mail's names to ISO country codes.
I tried to change one shopping cart module so that "Afghanestan" became UK, "Andorra" became Europe, "American Samoa" bacame Worldwide Zone 1, and "Aruba" became Worldwide Zone 2. It felt like being Napoleon without the war crimes, but I didn't quite manage to make it work. Recently, I've discovered that the Drupal Ubercart module imports a country once and then keeps the name on the database. If you can find the right program on the control panel of your web host to poke into the database, sufficient trial and error brings you to the names of countries which you can change by hand to anything you like.

I wished that someone used-to modules and code could have done it for me. Maybe the shopping cart developers think "I'll make a living selling add-ons on commission, and someone is bound to write a Royal Mail add-on". Then module developers look at Royal Mail's web site with all its complicated extra services like franking, and its whimsical change, and decide not to write a module. Nobody wants to get caught between a sprawling set of services that can change at any time, and an irate customer who has only paid £10 for a module but expects some kind of support.

From what I can see of other post offices' web sites in Europe, they follow the same pattern of a few world zones priced by weight, with a fixed size and price for 0-2kg parcels that they like to post on home ground, plus letters, large letters, and sprawling web sites with loads of decoy mail services that no sane person would use, special jargon words like "docket", trademarked premium services such as Like-To-Pay-More ® - all sorts of things. Names like "delivered ®" or"here to there with a stamp on ®" are common. Big courier web sites are similar. I've just found another page where emergency closures and delays are listed Royalmail.com/service-update/international. There seem always to be more pages to find.
Puzzling trademark ®
Large-scale UK shopkeepers or their warehouse contractors will know the kaleidoscope of  prices & services; they will simply tell a developer what they want. They may even know what franking machines are good for. This page isn't for large-scal shopkeepers. This page is just is a tourist guide to every-day Royal Mail services for individuals, ebayers, stallholders, crafters, smaller-scale shopkeepers, and developers who write for them. The stuff that ebay sellers and shopkeepers have picked-up just by living in the UK and hope that software developers around the world will happen to know too. They might post in a forum or send you an email. This is what they take for granted.

I've just watched a video that says "we live in an Amazon world. The customers' expectation is 2 days". But the bloke says this in front of a graph saying that customers are content for the first week, even in the US where people seem to expect chinese goods sold on a huge shop margin. People know that they can't download physical goods and have them now. He also says "fight with your suppliers", which could be why his goods turned-up late.

I've got a shortlist of shopping carts on another post: https://veg-buildlog.blogspot.com/2015/06/shopping-cart-software-for-ecommerce.html Most don't help much with shipping or even hinder in order to sell you an over-priced module. Individuals are offered a kaleidoscope of options from Royal Mail, that seem to overwhelm the people who try to make the clear on Royal Mail's web site let alone the people who have to read all this detail. Most of these prices and services are decoys designed to charge more for the person who doesn't care how much something costs. Basically Royal Mail sends 2nd Class 0-2kg Small Parcels to the UK at a fixed price for delivery in 3-5 working days and airmail to three other world zones with a table of prices by wieght. Simple as that. Other shopkeepers might have other favourite services like the 2.5cm thick large letter, but probably not many more. The prices are low for everyone. The only discounts are 0.5% cashback on some visa / mastercards held in individuals' names, (no Amex) and lower prices for bulk sorted mail to Royal Mail direct or some companies that feed-in to their sorting offices.
  • You might think that Royal Mail would offer to write modules for free. No.
  • You might think that the Department for Business and its gov.uk/e-exporting drive would make sure it's easy, given that the taxpayer still owns most of Royal Mail and the Department for Business is there to sort-out market failures, but no.There are now several departments for business or for economic development, because devolution is fashionable, and any one of these development agencies or departments could do a bit of lobbying or funding, but no.
  • You might hope that the people who write shopping cart software would make it easy, but no: they're often based in the USA and get tied-up in obscure US tax rates before they have time to think about obscure non-US post offices. Sometimes they are the sort of people who buy a T-shirt by UPS. Americans can be like that.

 Zones - Royal Mail has 4 of them plus the fiddley Channel Islands.


royalmail.com/international-zones
Royal Mail has 4 world zones: UK including Isle of Mann and Northern Ireland (with a fiddley exception for the channel islands - a tiny extra zone), Europe, Worldwide Zone 1 and Worldwide Zone 2.
It's rather hard work for the shopkeeper to attach prices by weight to every single country, and for the customer to choose a country from a long alphabetical list including countries like Aruba and American Samoa which I only discovered from these lists. A module to assemble these countries into 4 zones for a table quote by price or weight might be enough of the job done to get your software company a hug from a UK merchant, or their business anyway.
(There used to be a cheap and green rate for surface mail outside the UK that could 3 months to New Zealand. A vestige survives in "economy" mail, but it is only a few pence cheaper usually; there is more or less one price now to most places. I guess that container-size loads are still be sent privately that way.)
royalmail.com/surcharges
Highlands and Islands postcodes can attract a fuel surcharge on contract prices while courier quotes can be slower or more expensive. I haven't come-across this myself; it doesn't apply to the rate that most people pay.
Northern Ireland is in the UK postal zone.. Royal Mail and Parcelforce couriers are the same company and you'll probably get the same postal zone for Parcelforce too.

Zones - ISO country names to Royal Mail country names



I've asked Royal Mail for this list, then found that it's in the source code of a Drupal module which I don't know how to use any other way for Ubercart. I installed and used FTP to find the right file and read it in a text editor from the drupal/sites/all/modules/rmzone/rmzone.inc . There are probably similar modules for programs like Abantecart or Prestashop or Cubecart and the rest which can be read in a similar way.

    'AL', // Albania
    'AD', // Andorra
    'AM', // Armenia
    'AT', // Austria
    'AZ', // Azerbaijan
    // Belearic Islands: Spain
    'BY', // Belarus
    'BE', //Belgium
    'BA', // Bosnia Herzegovina
    'BG', // Bulgaria
    // Canary Islands: Spain
    // Corsica's French
    'HR', // Croatia
    'CY', // Cyprus
    'CZ', // Czech Republic
    'DK', // Denmark
    'EE', // Estonia
    'FO', // Faroe Islands
    'SF', // Finland
    'FR', // France
    'GE', // Georgia
    'DE', // Germany
    'GI', // Gibraltar
    'GR', // Greece
    'GL', // Greenland
    'HU', // Hungary
    'IS', // Iceland
    'IE', // Irish Republic
    'IT', // Italy
    'KZ', // Kazakhstan
    // Kosovo doesn't have an agreed code, and Drupal's iso.inc doesn't include it.
    'KG', // Kyrgyzstan
    'LV', // Latvia
    'LI', // Liechtenstein
    'LT', // Lithuania
    'LU', // Luxembourg
    'MK', // Macedonia
    // Madeira: Portugal
    'MT', // Malta
    'MD', // Moldova
    'MC', // Monaco
    'ME', // Montenegro
    'NL', // Netherlands
    'NO', // Norway
    'PL', // Poland
    'PT', // Portugal
    'RO', // Romania
    'RU', // Russia
    'SM', // San Marino
    'RS', // Serbia
    'SK', // Slovakia
    'SI', // Slovenia
    'ES', // Spain
    'SE', // Sweden
    'CH', // Switzerland
    'TJ', // Tajikistan
    'TR', // Turkey
    'TM', // Turkmenistan
    'UA', // Ukraine
    'UZ', // Uzbekistan
    'VA', // Vatican City State


The software doesn't list zone 1: it's everything but the others.


/**
 * Returns a list of countries in the Royal Mail zone: World zone 2. Note that
 * there seem to be two islands that are part of the Norwegian Antarctic
 * Territory that don't have ISO 3166-1 codes: Peter I Island and Queen Maud
 * Land.
 *
 * @see https://en.wikipedia.org/wiki/Dependent_territory#Norway
 * @see http://www.iso.org/iso/iso-3166-1_decoding_table
 */
https://www.iso.org/obp/ui/#search replaces the iso decoding table mantioned above
with this explanation

   
    'AU', // Australia
    'PW', // Belau
    'IO', // British Indian Ocean Territory
    'CX', // Christmas Island (Indian Ocean)
    // Christmas Island (Pacific Ocean)
    'CC', // Cocos Islands
    'CK', // Cook Island
    // Coral Sea Island: Australia
    'FJ', // Fiji
    'PF', // French Polynesia
    'TF', // French South Antarctic Territory
    // Keeling: Cocos Islands
    'KI', // Kiribati
    'MO', // Macao
    'NR', // Nauru Island
    'NC', // New Caledonia
    'NZ', // New Zealand
    // New Zealand Antarctic Territory: New Zealand
    'NU', // Niue Island
    'NF', // Norfolk Island
    'BV', // Norwegian Antarctic Territory (NB this excludes Peter I Island and
    // Queen Maud Land, which don't have ISO codes - see
    // https://en.wikipedia.org/wiki/Dependent_territory#Norway).
    'PG', // Papua New Guinea
    'LA', // People's Democratic Republic of Laos
    'PN', // Pitcairn Island
    'SG', // Republic of Singapore
    'SB', // Solomon Islands
    // Tahiti: French Polynesia
    'TK', // Tokelau Island
    'TO', // Tonga
    'TV', // Tuvalu
    'AS', // US Samoa
    'WS', // Western Samoa


UK private couriers for parcels over 2kg


veganline.com/parcel.htm
lists sites that sell pre-paid labels for private courier services. There is an ever-changing kaleidoscope of services including obscure shop-to-shop services, shop-to-door, and the upmarket quick and signed-for ones, and a locker-based one which may accept your returns and not loose them forever with luck. The rule of thumb is that they are cheaper for parcels over 2kg and offer tracking. Everybody knows this except the one person  at the front of every post office queue who asks very slowly "how much would 2.1kg to Aruba be? - oh, that seems a lot. Does it include tracking?".

Private couriers are unlikely to become cheaper for 2kg parcels because their staff don't do a delivery round down the street; they drive from street to street delivering a parcel here and a parcel there, ringing a doorbell for each one and most likely leaving half their parcels with neighbours when customers are not in. They also miss a VAT tax break that Royal Mail enjoys (in exchange for delivering all-over the UK for one price). Their best known services involve two van-parking and doorbell-ringing trips because people are used to them collecting as well as delivering, while Royal Mail only collects sacks; you have to go to a post office and drop-off your parcels or use a letter box.

The courier that comes closest to Royal Mail prices is a cheapskate operation in handling standards, delivery speed, and pay scales. They encourage recipients to suggest a porch or safe place where a parcel can be left late at night or while the customer is out, but customers ignore this, just as they ignore services like CollectPlus and UPS collection points which allow them to pick-up a product at a local shop. Customers prefer to sit at home and grumble that the courier didn't come when hoped-for. The service is better value and quicker if you drop-off parcels at one of their agents, which are places like newsagents and garages that can give a receipt and keep a parcel for the daily collection. Maybe in a few years more people will be used to picking-up parcels at places like this as well as dropping-off.
There is a consensus that £30kg is about the most that a single courier with a trolly and a van can carry, and the usual maximum size is 56cm x 46cm x 36cm. Pallets cost more again. Rolls and matrasses are hard to shift. Worldwide container shipping is another market again.

Addressing - no need for counties or bar codes for Royal Mail


royalmail.com/addressing
Within the UK, the administrative list of areas isn't used by Royal Mail nor couriers; there's no need to ask the customer their county or any local government area from any drop-down list, nor worry about whether an area is part of  "greater london", or "london". Just leave-out the whole process of selecting an area. There is a Royal Mail recommendation to write the post-town, in capital letters, to help sort mail where the postcode is wrong or illegible, but it's not necessary. If you do want to add an optional area to an address, use post towns if you can find a way, or a paid-for module that gets the customer to match an address and postcode from Royal Mail's database. http://m.royalmail.com/mt/www.royalmail.com/find-a-postcode does the same thing by hand - if you want to double check an address - and is free for a limited number of searches per period.

Customers have a number or name for each letterbox, and a postcode. Just write anything sensible in between if you want, as any address format is accepted. When pushed, Royal Mail say they need a "thoroughfare" next to the number or name of the letterbox, again as a backup.
name
John Smith,  Deputy Assistant Director of Dockets, Northern Irish Grant Artist Federation,
address and thoroughfare - on one or more lines
Unit 1 Grant Artist House, Verycranky Trading Estate, Long Road, Verycranky, Antrim
last line postcode
AN1 1AA

John Smith, Rose Cottage Rose Lane, AN1 1AB would be another example

I often see bar codes on large-scale mailings of bills. I don't know if there is any way to use them to get tracking thrown-in to the price. For smaller scale mailings, any clear typeface works well. Mail very seldom gets lost if the address is clear; I can't remember the last time. Automated scanners are replacing more of the hand-sorting at sorting office for pacels now, just as they did years ago for letters. royalmail.com/sites/default/files/Guide_for_clear_addressing_August2012.pdf gives more detail for larger customers, with astrisks next to the typefaces they suggest for printing but are unable to print themselves. Do you miss working for big organisations like this? No? It's good that somebody still works for them. They also ignore their own advice on the software that lets you print and pay-for postage online. It uses a sans-serif font with the kerning reduced so that letters merge into each other, and prints on a grey patterned background like a watermark.
Bold fonts must not be used. Recommended fonts as follows. Arial 10-12pt, Avant Garde 11-15, Century School Book 10-11, Courier 10-15, Courier new 10-15, Frankfurt Gothic 10-12, Franklin Gothic (Book) 11-14, Geneva 10-12, Helvetica 10-14, Letter Gothic 12, Lucida Console 12, Lucidea Sans Typewriter 12, Monaco 12, News Gothic MT 10-12, OCR B 12, Univers 10-15, Verdana 10-12,














































Pricing & paying:
UK 2nd class 2kg parcels have one price; 3 zones of weight tables ex-UK
Proof of postage is free but fiddly and effects the system to use:
online / drop&go


royalmail.com/prices
royalmail.com/help-and-support/tell-me-about-size-and-weight-formats
..quote dozens of sizes weights and services in a format called "handyguide.pdf" that changes at whim year to year; the Royalmailtechnical web has released a spreadsheet, but only for large scale services so far and the firm refused to publish a clear spreadsheet of prices in the past.

royalmail.com/price-finder is a route into
royalmail.com/discounts-payment/online-postage/create
https://parcel.royalmail.com/ is a new shorter form to do the same thing:
print a stamp and address from an address and postcode, and tell you a clear price if you don't buy. It can also import addresses, but only from ebay according to the help page. Ebay and Paypal also have a system of printing-out pre-paid addresses on your home printer without going to the Royal Mail web site.

Royal Mail no longer has a cash-on-delivery service, even for the annoying packages priced at over £15 that arrive from outside the EU and so have a tarrif plus VAT tax plus collection fee to pay.
Online postal payment systems demonstrate the pointlessness of weighing your post and printing a stamp with an expensively hired and serviced machine from approved suppliers. There is a small discount on franked post for no reason except to keep this pointless industry going and after a brief experiment I decided that no discount is worth the trouble.
The first /pricefinder url gives more information about sizes: Second class 1-2kg small parcels are the best value, along with letters and a thing called a large letter which is 2.5cm thick. There's probably some way of getting a robot on the customers' computer to transfer names, postcodes, and first lines of addresses onto the online postage page but no need. You can also put  pre-stamped mail in letter boxes or drop it in a sack without queing a lot of post offices. Most of them are independent franchises and capable of ignoring instructions from head office about whether to leave an open sack on your side of the counter for dropping-off mail.

Tracking is only available on expensive signed-for services, so proof of posting can be important. You have to queue-up and ask for proof of postage, which the staff do for no fee by printing-out a receipt for £0 showing the destination of the parcel. If you use ebay's Paypal postage, the old Certificate of Posting system survives, which is rubber-stamped and squiggled at the counter. Staff are polite about doing this work for no money and other systems may survive for proof of posting several parcels. They used to hide blank certificate of posting forms, though, to discourage people from using them.
postoffice.co.uk/drop-and-go-branch-service
is run by Post Office Counters and tried to integrate charging and reports into Royal Mail's web site, without success; it's still a manual system and the Royal Mail side of the firm have introduced a simlar one in competition. Anyway, shopkeepers can open an account, then then jump the queue at a post ofice branch and leave addressed parcels to have stamps stuck-on by the staff who's branch makes a small profit on them. Happy post office. May remain open. They can print form headed "manifest" on which to list postcodes and addresses for them to stamp as proof of postage. It's possible to download the form as a pdf and to made it editable so that you can cut-and paste the three columns of 2nd class / street number / address that are most used.
Free collections at the ground floor exist for sacks, or more precisely "free weekly collections for customers who spend over £15,000 a year with us". If you only send the cheapest £2.80 parcels, five days a week, 50 weeks a year, that's nearly 22 parcels a working day. Comments on message boards say that the £15,000 limit isn't strictly enforced, and of course the customers who opt of for first class or export parcels will reduce the minimum number, as will use of a specialist pick-and-pack mailing warehouse in some cheap part of the UK, or collaboration with one or two neigbouring firms to collect shared mail from the ground floor: I don't know if there's a way to make that work.

Bulk customers can get small discounts for doing some of the sorting but I don't know how much that takes-away from the benefit of having a sack of mixed mail collected. They also have a long pre-computerised tradition which may still have its odd jargon or options for manual book-keeping. I don't know what a "docket book" is for example, but they do.

Royal Mail's Europe zone is very large, including non-EU countries like Ukraine for which a customs sticker is needed and possibly a tariff paid by the recipient.

Neighbouring post offices that speak English -
Netherlands,  Ireland, Channel Islands, Isle of Mann


Anyone who writes about how Royal Mail works has to mention the Isle of Mann and Channel Islands. So why not write about a couple of bigger neighbours first? These two speak english.
Postnl.com or Post.nl serves the Netherlands, a country of 16.8 million mercantile & well-educated people next to the UK's 61 million people. I think people in the main dutch towns often do business in English by default; a client's IT department is likely to accept sales contacts English, with Dutch and Flemish more common at home, in the country, or when buying rather than selling. Signs at Schipol Airport are all in English. I don't live in the Netherlands and might have got this wrong, but the main postal service seems to be for 3.5cm "letterbox size" 0-2kg parcels delivered cheaply in Holland or the Benelux countries, with another zone for Europe and I think another for "world".

Cash on delivery is available. That's different to the UK.
Online stamping and addressing isn't obviously available. I might have missed it.
Postnl.com own the TNT Post courier service in other countries, and briefly tried doing a door-to-door delivery round in parts of London, as well as touting for the sack collection trade under the name whistl.co.uk. Door-to-door delivery staff were made redundant with zero warning, but UK sack collection continues with a minimum of 250 items per collection.
ANPost.ie for the Republic of Ireland's 4.6m people is like Post.nl in using €uro & speaking english. Fewer Irish people speak other languages than in most countries of the world I guess, but politicians have diverted resources from social insurance, including education and health, into making sure that, should people suddenly start speaking Gaelic all at once in the future, pubic services will be ready for them. That's the sort of thing that politicians do with your social insurance payments if you don't watch the bastards. Signs at Dublin Airport are in Gaelic and English, as at Knock airport, where you can go to see the miracle of priests evading prosecution for false statements or worse. It's a great place to visit in other ways though: living there is the problem and unfortunately, UK politicians are picking-up these tricks just as Irish ones try to get rid of them.

ANPost collects sacks from senders of 30 parcels a more a week outside Dublin - and an unstated amount inside - and from post offices and letter boxes in the southern Irish counties. wikipedia.org/wiki/An_Post says that collection services outside the republic have been sold-off.
ANPost delivery price zones are Ireland - north is the same price, GB, Europe, World.
ANPost addressing guide is at http://correctaddress.anpost.ie
There is no online address and stamp printing service, but large customers can use a machine for printing normal-looking stamps and a database of addresses can be hired.
The pointless franking industry survives in Ireland as in the UK, with small discounts and perhaps some purpose for the bulk mailers.

Just recently I had a parcel returned as insuffiently addressed to putting two lines together and ommitting the new postcode; I don't know which triggured the return, but they now use postcodes slightly longer than the UK ones, so best to check from their site what's happening. It will suggest a printed format in roman letters that's hard to cut and paste into your own software, but there is bound to be a way.

I don't think they've got up to the UK / Canada pattern of six letters and numbers. Counties are named after the county town, so you can leave out "County Limerick" if the town is "Limerick".

The Channel Islands' 164,000 people use UK currency in three independent EU states, sharing some services like embassies with the UK. They do not have a Channel Islands postal service. They have two:
Guernseypost.com
Jerseypost.com
E-commerce is a regular business in the Channel Islands.
For a while this meant that you could sell your ebay items from a Channel Islands warehouse and not pay VAT. More recenlty the state-owned Royal Mail has added a separate "sub zone" price to all mail from the UK to the Channel Islands, and all goods from the channel islands now have to pay UK VAT on entry - not just goods valued under the usual £15 threshold.

The Isle of Mann's IOMpost.com is a separate post office for the 80,000 people who live there. The island has its own EU government and tax rates but shares the UK pound while its post office seems to share the same postal zones of UK, Europe, and world. Like AMPost, it offers signage in Gaelic. Letters cost less to send than from the Royal Mail; parcels more.

Gibralter's Post.gi serves 30,000 people in the EU who speak English first and have regular air deliveries of mail to the UK & US as well as land deliveries via Spain.
Other neighbouring countries have english-language post office web pages and english-speaking clients, but I don't live in any of them or have any off-the-cuff knowledge to add to what you find. In Europe, the northern countries and those with coastlines are the more mercantile but have worse weather. I guess that most have a handful of world zones priced by weight and a favourite size of 2kg parcel that they like posting so much that they do it very cheaply.

Oh here's a thing. The Italian post office is not yet as reliable as the others - see Time Out Guides, Rough Guide, Lonely Planet, or google phrases like "ex pat guide to life in..." for details about the Italian post office and whether it has got any better. Items I send to Italy are more often delayed than to other countries, although they turn-up in the end. An ebay seller might choose "everywhere in the EU but Italy" as a choice for where to post.

I began by writing about Royal Mail and neighbouring services as though you were selling your software at a trade show in the UK. The Indian post office is further away and different in pricing for more different weights and countries. It serves a population of 1252 million.