Accountancy issue over pence
Discussion
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" (
). 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?
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" (
). 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?
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.
That was the main reason I left. 1 HKD = £0.081 btw.
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
Simples
bigandclever said:
I'm very confused (and possibly a bit thick!) ... where's the rounding issue?
Presumably rounding down £301.125 to £301.12 before sticking the VAT on.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
18.25 hours @ £16.50/hr = £301.125 * 1.2 = 361.35
Other VATable charges = £3 * 1.2 = 3.60
Total = £787.35
Gassing Station | Business | Top of Page | What's New | My Stuff


