Click here to Skip to main content
15,999,410 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Development oddity Pin
Matt Bond19-Aug-24 6:05
Matt Bond19-Aug-24 6:05 
GeneralRe: Development oddity Pin
Mike Hankey19-Aug-24 6:17
mveMike Hankey19-Aug-24 6:17 
GeneralWell, it finally happened (adventures in software design) Pin
honey the codewitch12-Aug-24 9:21
mvahoney the codewitch12-Aug-24 9:21 
GeneralRe: Well, it finally happened (adventures in software design) Pin
pkfox12-Aug-24 9:36
professionalpkfox12-Aug-24 9:36 
GeneralWhat are the Odds Pin
BernardIE531712-Aug-24 7:21
BernardIE531712-Aug-24 7:21 
GeneralRe: What are the Odds Pin
PIEBALDconsult12-Aug-24 8:18
mvePIEBALDconsult12-Aug-24 8:18 
GeneralRe: What are the Odds Pin
BernardIE531712-Aug-24 9:51
BernardIE531712-Aug-24 9:51 
GeneralHMRC is confusing ... and so is the bank! Pin
OriginalGriff12-Aug-24 2:34
mveOriginalGriff12-Aug-24 2:34 
... or "the Taxman" since it's only HMRC in the UK.

Last week (The Lounge[^]) I got a tax rebate cheque for £1600 for an overpayment Michelle made.
And today the postman delivered another letter ... and I joked to myself "it's probably a demand for £1800 this time!" Laugh | :laugh: Laugh | :laugh:

Nope. A demand for £1900 ... Sigh | :sigh:

So now I have to go back through all her bank statements, pay slips, P60's and suchlike (which would have been easier if she's kept them in some form of organisation (or indeed, kept them at all in many cases) to try and work out why HMRC appears to have used the same income to get two wildly different results.
So back to the bank and download the statements. And that's where is gets nasty: I can download in Excel, Quicken, Money, PDF, Text, or CSV. Except ... CSV will only give you the last 12 months, nothing before that. Quicken and Money I don't use; PDF is a PITA to extract data from if you want to manipulate it; Excel is XLS(!) and both XSL and Text are restricted to 600 transactions, but you have no idea how many there might be in a tax year ... 2 a day will take you over that limit!

OK, so monthly downloads in XLS it is (because I can process it in a spreadsheet and directly import it to SQL via SSMS). 53 separate monthly downloads later ... and Excel says the files are "damaged or corrupt" but will open them. SSMS says they are "damaged or corrupt, I'm not touching that!".
Try a couple of Excel to DataTable solutions, and they all say "sod off, that's a bad file" Sigh | :sigh:

OK, Text it is another 53 separate downloads ... it's a nice simple format, so processing the text with Regex isn't difficult. Except ... iOK for me, because there are less than 600 transactions per month, but they don't include any form of transaction ID (despite the original bank data guaranteed to have them in some form) so you can't easily spot duplicates if you do have to break a month into smaller parts.

Come on guys! If you have data which uniquely identifies a transaction and you are compiling a transaction report INCLUDE IT! If you have an "industry standard format" like Excel, use the modern version, not one 15 years out of date! Don't restrict the transaction count to an arbitrary number, restrict it to an arbitrary number or the end of a month / week / year whichever is appropriate! And whatever you do, don't add a further length limit to one particular format!

Grrr ... and now back to the financial news ... Dead | X| Once I've finished converting the text to SQL for analysis / sorting / filtering that is.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

GeneralRe: HMRC is confusing ... and so is the bank! Pin
Richard Deeming12-Aug-24 3:39
mveRichard Deeming12-Aug-24 3:39 
GeneralRe: HMRC is confusing ... and so is the bank! Pin
OriginalGriff12-Aug-24 3:52
mveOriginalGriff12-Aug-24 3:52 
GeneralRe: HMRC is confusing ... and so is the bank! Pin
OriginalGriff12-Aug-24 3:55
mveOriginalGriff12-Aug-24 3:55 
GeneralRe: HMRC is confusing ... and so is the bank! Pin
Richard MacCutchan12-Aug-24 4:56
mveRichard MacCutchan12-Aug-24 4:56 
GeneralRe: HMRC is confusing ... and so is the bank! Pin
OriginalGriff12-Aug-24 5:20
mveOriginalGriff12-Aug-24 5:20 
GeneralRe: HMRC is confusing ... and so is the bank! Pin
MarkTJohnson12-Aug-24 5:42
professionalMarkTJohnson12-Aug-24 5:42 
GeneralRe: HMRC is confusing ... and so is the bank! Pin
pkfox12-Aug-24 9:39
professionalpkfox12-Aug-24 9:39 
GeneralRe: HMRC is confusing ... and so is the bank! Pin
charlieg12-Aug-24 11:48
charlieg12-Aug-24 11:48 
GeneralRe: HMRC is confusing ... and so is the bank! Pin
pkfox12-Aug-24 21:42
professionalpkfox12-Aug-24 21:42 
GeneralRe: HMRC is confusing ... and so is the bank! Pin
charlieg13-Aug-24 1:54
charlieg13-Aug-24 1:54 
GeneralRe: HMRC is confusing ... and so is the bank! Pin
charlieg12-Aug-24 11:44
charlieg12-Aug-24 11:44 
GeneralRe: HMRC is confusing ... and so is the bank! Pin
jschell14-Aug-24 15:01
jschell14-Aug-24 15:01 
GeneralThe Nostalgia black hole Pin
theoldfool12-Aug-24 0:48
professionaltheoldfool12-Aug-24 0:48 
GeneralRe: The Nostalgia black hole Pin
Richard MacCutchan12-Aug-24 2:18
mveRichard MacCutchan12-Aug-24 2:18 
GeneralRe: The Nostalgia black hole Pin
jeron112-Aug-24 7:58
jeron112-Aug-24 7:58 
GeneralRe: The Nostalgia black hole Pin
Bob Griswold13-Aug-24 4:32
Bob Griswold13-Aug-24 4:32 
GeneralRe: The Nostalgia black hole Pin
theoldfool13-Aug-24 5:10
professionaltheoldfool13-Aug-24 5:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.