Business account integrations and features?

(Mirella Deocadiz) #1

On last week’s post, Jason wrote “I’d love everything under one roof. Invoicing, payments, accounting, reporting, analysis, and VAT-return through MTD to HRMC.” While he did mention that this was “pie in the sky dreaming”, this isn’t too far off from what we want to do… eventually. (Thanks for sharing your thoughts, Jason!)

While we’d love to build everything immediately, we unfortunately can’t :disappointed: That’s why we’d like to dig a bit deeper and try to understand what things are the most important to you.

Here’s what we’d like to know

Out of the following, which of these things are the most essential to your business? And which things aren’t as high a priority for you?

  • Accounting software integration
  • Partner perks as a business
  • Invoicing and billing clients
  • International payments / foreign exchange
  • Expense management
  • Budgeting categories
  • Cashflow management
  • Tax calculation

Are there any specific integrations that you absolutely must have? What are they, and why do you use them? What other tools do you use?

Thanks in advance for all your responses!

(Sarcasm is the finest form of wit.) #2

Tax calculation and Budgeting categories (pots?!) for sure.
Accounting software integration - even and export/import would be fine.

But I’m a contractor with a business account, not someone running a business.

(Caspar) #3
  • Accounting software integration

Literally that. I wouldn’t want anything else in my banking app, but being able to connect the account to FreeAgent so it can import all my transactions and do the rest of your stuff on my list. I have very little interest in my bank doing all those other bits for me and would need a very compelling reason to switch things around.

(Jason Artemis Winstanley) #4

…Hehehe. I didn’t think that line would warrant an official Monzo response. :stuck_out_tongue: Thank you for making me smile on what has been a terrible day so far!

Of that list, I’d agree so far that in the first place external API connection to my existing accounting platform would be most important, but definitely when you have everything in place I would use Monzo’s tools instead, if they work efficiently and smoothly!

(Mirella Deocadiz) #5

:wave: Thanks for responding! Are you using any tools to do your accounting currently? Or are you just relying on exports?

(Sarcasm is the finest form of wit.) #6

just exports and an accountant but I want to get to the point I’m managing all that myself!

Mostly just Tax and VAT I need to worry about, and expenses. I don’t ‘sell’ anything.

(Mirella Deocadiz) #7

I’m glad that I made you smile today! :smile:

Could you tell me a little more about what you’re using your existing accounting platform for specifically? (e.g. which features do you use the most? What would be the most important thing you would need if you were to use another tool instead?)

(Jason Artemis Winstanley) #8

The day for progressively better after your post! :slight_smile:

At the moment, I’m primarily using my accounting platform for invoices (plus tracking and payments via Paypal or Stripe), and VAT Returns (via MTD). Towards the end of next year, I’ll also be looking to consolidate all my info for self-assessment and other relevant HMRC filings too.

The most important thing for me to move across would be the invoicing and MTD integration. I rely on it so much now that I have it, and QuickFile sends me reminders when I have a task or due date coming up with HMRC!

(Stephen Early) #9

Accounting software integration (Xero, in our case) is absolutely essential, everything else is optional.

Being able to upload batch payment files from Xero is strongly desirable.

(Mirella Deocadiz) #10

:wave: Stephen! Thanks for your response. Can you tell me a little about what you use Xero specifically for? I’d love to understand if there are specific things that you rely heavily on it for.

(Stephen Early) #11

We run pubs. We’re paid by our customers both in cash and by card, and we spend money with our suppliers in cash, by card, and by bank transfer or direct debit. Xero is where the information about all these money flows ends up for checking, cross-referencing and reporting.

Our chart of accounts in Xero is fairly simple, and is very close to the chart of accounts you can see if you create a Xero login and play around with “Demo Company (UK)”.

The main points of difference are that we have accounts corresponding to our various different real bank accounts (multiple Barclays current accounts, a Handelsbanken current account and a Santander savings account), and also fake “bank” accounts for the cash on hand at each of our pubs.

We’ve added separate “Sales” and “Purchases” accounts for each department in our point of sale system (“Real Ale”, “Cider”, “Spirits”, etc.) - we use these to track our gross profit per department, and we use Xero’s “Tracking cagegories” feature when we need to split sales and purchases out per pub.

There are 136 accounts in our chart of accounts, compared with 90 in the Demo Company chart, so it’s not a huge difference.

We’ve been using Xero since December 2016. To give you some idea how much information goes through Xero, to date we have 3326 invoices (money in) and 7553 bills (money out). There are also some number of “spend money” and “receive money” transactions that are like bills and invoices except they are simpler: they have a single payment to or from a bank account and don’t make use of the Accounts Payable or Accounts Receivable accounts, i.e. split payments aren’t possible and the transaction only has one date associated with it. I don’t have an easy way of getting a count of those out of Xero (that I know about!) but I reckon there are probably about 10,000 of them: we generally use them to describe small cash purchases. (“£1 for lemons at Tesco” etc.)

When we’re paid by our customers:

  1. The point of sale system at the pub records what we sold and how we were paid.
  2. At the end of each day, after the cash is counted and the card machine totals are printed, the POS system uses the Xero API to create an “invoice” in Xero for all the sales that day, broken down by department, and payments are recorded against the invoice into the pub’s cash account and (three working days in the future) the Barclays current account, for card payments.
  3. A couple of times per week, money is transferred from the pub’s cash account to one of our current accounts by paying cash in at the bank.
  4. Usually three working days later, the money for card payments arrives in the main Barclays current account by direct credit. Information about this transaction arrives in Xero through the direct feed from Barclays, and it’s reconciled against the expected amount submitted by the POS system. Any discrepancies are investigated and corrected (they usually turn out to be typoes, although we have seen some more bizarre errors).
  5. At regular intervals (but probably not as often as we should!) the pub’s cash book is reconciled against Xero, the cash is counted, and any discrepancies are investigated.

When we buy stock from our suppliers:

  1. The delivery note is entered into the POS system.
  2. The POS system prints out stock labels for each item in the delivery. If you end up with labels left over, you know something’s missing!
  3. Once the delivery has been checked, the POS system uses the Xero API to create a draft “bill” in Xero for the delivery.
  4. Eventually the invoice for the delivery arrives: usually by email from the supplier, but sometimes by post and then we scan it in. We upload the invoice to Xero so it appears in the “Files Inbox”.
  5. When we’re doing paperwork, we match up draft bills in Xero against uploaded invoices. The file from the inbox is attached to the bill. When the invoice appears to be correct (it matches the information sent from the POS system), we hit the “Approve” button and the bill is queued for payment. If the invoice doesn’t appear to be correct, we work out why and sort out the differences with the supplier.
  6. Xero lets us set up a planned payment schedule for our bills. Each day we have payments planned it gives us a list of bills to pay. We generally pay by bank transfer, although we also have direct debit arrangements with some suppliers. Once we’ve paid a bill by bank transfer, we enter this into Xero so it knows the bill is paid.
  7. The bank transactions we’ve made arrive back in Xero through the direct feed from Barclays, along with any direct debits. We use Xero’s bank reconciliation interface to check these against the payments we intended to make, and to mark bills paid by direct debit as paid. If there are any differences it’s usually because we made a typo while entering the payment into the Barclays website, although it’s not unknown for our suppliers paid by direct debit to make mistakes too.

When we get other bills (utilities, etc.) we deal with them in a similar way, except there usually isn’t a draft bill waiting in Xero to match them up with. (Some suppliers bill us very consistently and we can set up a repeating bill in Xero to match those, just to save a bit of typing.)

If we receive a delivery and don’t receive an invoice for it, we’re left with a draft bill in Xero that we can chase up with the supplier.

If we receive an invoice but didn’t receive the corresponding delivery, we can’t find the draft bill in Xero and we can chase this up with the pub staff (who may have forgotten to enter it) or the supplier (who may have billed us incorrectly).

Every month we pay our staff. We don’t use Xero’s payroll system at the moment (because they haven’t released their UK payroll API yet, so we have no way to get figures from our online timesheet system into Xero) but the system we use ultimately sends details of all the payments we need to make as bills using the Xero API. We then have a very tedious hour or two with the Barclays website making all the separate payments!

Every quarter we use Xero to make our VAT return. This takes under 5 minutes.

Every year we make sure everything is up to date and then say to our accountant “everything is in Xero, help yourself!” — since scans of the original documents are stored in Xero alongside the transactions, he usually doesn’t have to come back and ask us many questions.

So: why do we like Xero?

It makes it very easy to stay in control. API access from our POS system to create invoices and bills means that there’s very little data entry to do. The direct feed of transactions from our banks into its reconciliation interface is very convenient, and unexpected or incorrect transactions are made very obvious. We never end up with a backlog of things to chase up at the end of the year, we can keep on top of things from day to day.

What’s not so good?

The missing UK payroll API is the main thing, really. There are features Xero has that our banks don’t support which would save us time if they worked (eg. being able to export a batch file to the bank to make all the payments we need to do for the payroll each month).

We’d like to give Xero access to more of our pub managers, but its permissions system is very basic and we think it’d be too easy for a manager at one pub to make mistakes that affect another.

Why do we have so many current accounts?

Mostly it’s a workaround for a Barclays problem. We want our pub managers to have debit cards for business spending, but we want these cards to have fairly low spending limits. Barclays sets spending limits per account, not per card, so we can’t have the cards issued against our main current account: that needs a high limit so we can pay our staff, HMRC, and our suppliers. It would be great if a Monzo business account could have configurable spending limits per card…

(Kenny Grant) #12

In order of importance for me (software consulting ltd):

  • Business categories
  • Expense management
  • Tax estimates
  • Cashflow projections (nice to have)

I use some desktop software currently to categorise expenses/income for my accountants. Doesn’t seem very complex for a small business and I’d rather my bank just took care of it as you do personal categories. For many freelancers/contractors with an ltd it would be enough if expenses and income could be auto0classified using expense categories appropriate for business. Currently evaluating coconut for this reason - really like their UI and guidance so far for this.

For larger businesses of course integration with accounting software is probably a must. Xero seems the most popular and basic integrations are straightforward (have written one for work).

(Mirella Deocadiz) #13

Wow - thank you so much for this very detailed response, Stephen! Just took a quick glance right now and really appreciate the time that you took to write this all out.

(Mirella Deocadiz) #14

Thanks so much for your comment, Kenny!

(benjaminlbowles) #15

The only thing I really need you to do:

(Mirella Deocadiz) #16

Hi Benjamin! We’ve got a ton of feedback about integrating with Xero. Could you tell me a little bit more about how you use it? (e.g. are you using it to pay bills, manage expenses, do invoicing etc.?)

(benjaminlbowles) #17

We use it to do all of our accounting, simply all the bank needs to do is have a real time feed into Xero, and then ultimately allow Xero to make payments out of the account when that functionality is ready.

(Brenton Hill) #18

It isn’t on your list but… functionality would be great for me. It would prove a really slick way to charge clients via a link and would mean I don’t have to pay paypal etc fees or mess around with sending potential clients, account numbers and sort codes!

If it could be integrated into the business account it would need:
Unlimited amounts that could be paid into it (the personal account is capped at £100)
A address
The option to make a unique link with a fixed amount owed
The option to make a unique link with a reference number built in

Sorry if this is a little off topic! I’m only just getting started and don’t have any accounting software line xero yet.

I was hoping that my Monzo account might make everything so simple that I wouldn’t necessarily need it. That may well be wishful thinking though, although it sounds like your plans aren’t too far off my dreams!

(Matt Stibbs (#1195)) #19

Accounting software integration (Xero for me).

I pretty much need the account to process payments for me, and provide that data to Xero where I do literally everything else.

(Brenton Hill) #20

Hey @jrdn and @mirelladeocadiz .

Do you know if is somthing you plan to launch soon?