Accountancy issue over pence
Accountancy issue over pence
Author
Discussion

All that jazz

Original Poster:

7,632 posts

177 months

Monday 4th November 2013
quotequote all
Hi folks,

I've got an issue with a client over the rounding of part pence on my invoices. I understand from reading online that it is standard industry practice to round up to the nearest pence if 0.5p or greater.

I recently generated an invoice for work completed which totalled £787.35. The breakdown of which being :

32 hours @ £11/hr = £352
18.25 hours @ £16.50/hr = £301.125
Other VATable charges = £3

Total = £656.125
+ VAT @ 20%
Total = £787.35

This is what Excel automatically works it out to be to 2 decimal places too from using the appropriate standard formulas for doing the calculations, however the client is refusing to entertain the issue, claiming that my "accounting software is outdated and needs replacing with something more modern" ( confused ). Obviously I'm not bothered about the fact it's "only" pence, but more the point that this is now the 3rd time it's happened and my accounts are not balancing due to them paying what they feel like rather than what's on my invoice.

Can anyone advise how best to sort this issue out please?

mybrainhurts

90,809 posts

286 months

Monday 4th November 2013
quotequote all
Aye, write off the penny with a journal entry. Or just leave it out of balance.

PS...singular of pence is penny.

Devilstreak

8,088 posts

212 months

Monday 4th November 2013
quotequote all
Write the penny off via credit/journal, your accountant will only do this anyway so it saves them a job!


It'll save your debtors lists looking messy too.

trickywoo

14,287 posts

261 months

Monday 4th November 2013
quotequote all
Slightly off topic but I used to administer a $100 million + fund and due to our computer system every month there would be a discrepancy of a few Hong Kong cents - usually between 12 and 15 cents. It was my job to track down each of the rounding issues which led to the total of 15 cents and 'correct' them. This could easily take a day or so. Apparently writing it off wasn't acceptable to the client.

That was the main reason I left. 1 HKD = £0.081 btw.


Mr Overheads

2,635 posts

207 months

Monday 4th November 2013
quotequote all
Give them a 1p credit on the following months invoice and let them handle the accounting journal!

Simon Brooks

1,527 posts

282 months

Monday 4th November 2013
quotequote all
Just post a journal entry for 1p credit (narrative rounding adj) and use said credit amount to clear invoice from sales ledger when posting payment from client If you want to be really anal print the credit note (using original invoice number if your program allows it) and attach to original invoice copy with copy of remittance paperwork to satisfy vat inspection (they love little details like that)

Simples

All that jazz

Original Poster:

7,632 posts

177 months

Tuesday 5th November 2013
quotequote all
Thanks chaps. What is the legal stance (if one exists) in accountancy as far as part pence totals go? Is it right that 0.5 or above is rounded up and <0.5 gets rounded down or is either acceptable and you just have to suck it up?

Devilstreak

8,088 posts

212 months

Tuesday 5th November 2013
quotequote all
Officially sales rounded down and purchases rounded up.

Saying that though, no ones cares about a penny.

sumo69

2,164 posts

251 months

Tuesday 5th November 2013
quotequote all
I can't believe the OP has a client that has nothing better to do than argue over a 0.5p rounding!!

David

bigandclever

14,423 posts

269 months

Tuesday 5th November 2013
quotequote all
I'm very confused (and possibly a bit thick!) ... where's the rounding issue?
All that jazz said:
32 hours @ £11/hr = £352 * 1.2 = 422.40
18.25 hours @ £16.50/hr = £301.125 * 1.2 = 361.35
Other VATable charges = £3 * 1.2 = 3.60

Total = £787.35

All that jazz

Original Poster:

7,632 posts

177 months

Tuesday 5th November 2013
quotequote all
bigandclever said:
I'm very confused (and possibly a bit thick!) ... where's the rounding issue?
All that jazz said:
32 hours @ £11/hr = £352 * 1.2 = 422.40
18.25 hours @ £16.50/hr = £301.125 * 1.2 = 361.35
Other VATable charges = £3 * 1.2 = 3.60

Total = £787.35
Presumably rounding down £301.125 to £301.12 before sticking the VAT on.

Ali_D

1,115 posts

315 months

Tuesday 5th November 2013
quotequote all
Sounds like you need to bill in whole hours. So round up to 19 next time.