Pay at pump + Xero = terrible

Feedback & Ideas
1

Hi guys

Just venting my frustration and disappointment at how Monzo business reports pay at pump in Xero.

I’ve pushed a message to chat a couple of times but the support people don’t understand the issue.

This is how it seems to work (or not work) for me.

  • Pump authorisation is generic amount, usually about £85)

  • Card transaction then shows as settled and a different amount

  • Xero shows both transactions in the reconciliation field; but both reported amounts are completely wrong.

I’ve attached Xero feed below and the receipt of the actual transaction for clarity, but this is hopeless. It adds more work for me to try and make sure the Xero balances correctly.

This definitely needs improving.

IMG_9287
IMG_92871290×2796 195 KB

73642694170__56A730B8-4648-4A9D-AB33-590AFD88EBC8
73642694170__56A730B8-4648-4A9D-AB33-590AFD88EBC83024×4032 2.5 MB

2

Wouldnt this more be on Xero not cancelling the non settled payment?
Are xero saying its reported as settled?

1 Like
3

Problem to me is that Monzo reports it too quickly to Xero rather than allow the correct transaction to settle. That being said the reported amounts aren’t correct in either case, which is definitely a Monzo issue in my opinion.

4

The amounts seem like a monzo issue but the pull would be something for xero to check to be honest.

Have you queried it with Xero to see what they see?

We went with Freeagent and it does a daily sync which is nice and its UK based unlike Xero, even though Xero had some nice features.

5

I don’t do xero, but the first is the generic pay at pump charge shown as a debit. The second is a credit for the bit you didn’t use, which nets off to the amount on the receipt.

Seems perfectly reasonable to me.

8 Likes
6

Wow how did I not spot that!

7

It makes the transaction a pain though because you can’t contribute the partial credit against the debit as a single statement line so I’d have to create a bill and add them as separate transactions which takes time I shouldn’t have to when reporting an expense.

Whilst the explanation is valid; I still feel this is a bad way of reporting it to Xero.

8

Appreciate this post is quite old now but I’m very new to accounting/ bookkeeping and I’m just wondering if anyone is able to help me reconcile a Pay at Pump prepayment/ refund on Xero. My accountant has advised me of how to do it but I’m unsure of this is correct as it’s allocated to an account code with no VAT meaning we’re missing out on claiming back VAT. Our MD and myself use Pay at Pump all the time so I really need to know how we should be reconciling both the £120 prepayment and the refunded amount correctly, with the correct account codes for VAT. If anyone has found the best way to do it, I would really appreciate your help. Thanks, Lux