|
Post by MoneyThing on May 25, 2017 8:15:52 GMT
I agree with the points made by am further up the thread. I have previously stated and will reiterate, when on holiday, I don't use internet access to log in to password protected sites. Anything less than 2 weeks notice would be a disaster for me if I was on holiday this week. Maybe I'm paranoid but I won't access secure sites. Fortunately I've already been away and returned last week so that isn't an issue to me this time but it might happen some time in the future. Whilst here MoneyThing , I assume you'll be consolidating loan parts as part of this process. Will you also take the opportunity to merge equivalent tranches of the same loan? Again this is something I've harped on about in the past but it has been more for tidiness but with the glut of SM availability recently, I've found it cumbersome navigating around what parts I need and don't need. Morning Spiral, We are looking at a way of merging loan parts into a more streamlined format, however we will probably look at this separately so that we can keep it more straightforward for the migration project. It is on the list though! Regards, Ed
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Jun 1, 2017 10:11:41 GMT
MoneyThing Morning Ed, Just done an EoM reconciliation on my account and noticed that the 3 re-new New Terms loans numbering and descriptions are deviating from the now established formats which will confuse Mr Excel once the payment dates roll around this month. On both the Statement and Live Loans downloads the Loan descriptions are still using the previous number (not in brackets as other previous Loan descriptions) with an 'N' appended. The Live Loans download shows the loans all have a new Loan id (not reflected in the description): Loan id Borrower code Asset details 715 MTAQ MTAQ634N-W********* Bridging Loan (New Terms) 716 RCC RCC633N-Business Finance (New Terms) 717 RCC RCC690N 2011 Ferrari 458 Italia Coupe (New Terms) The Statement has only the Details as above (previous Loan no) so extracting the Loan id and reconciliation of payments will be tricky ............. Could you confirm the standard to be used going forward ? The I can fiddle with Excel to avoid a head-spin later in the month by which time there'll no doubt be plenty more on New Terms. I'm not too bothered as long as I know - but preferably keep the New Terms loans in the same format as the rest - in the interests of me not having to do anything
|
|
|
Post by adspence on Jun 1, 2017 10:36:48 GMT
Ideally the LoanID would be in a completely separate field in the downloadable statements. The constant renewal, changing loan numbers and changing asset descriptions means no matter how good my Excel skills are I end up manually rejigging these renewed loans. I spend more time on reconciling these MT loans than any other platform. A sell of the old LoanId and a buy of the new LoanId clearly denoted in a separate field would be so much easier to deal with - rather than hunting for "(LoanId)" somewhere in the description.
|
|
spiral
Member of DD Central
Posts: 895
Likes: 450
|
Post by spiral on Jun 2, 2017 7:36:37 GMT
Yep, my spreadsheet is kaput too. I extracted the loan ID by stripping away the brackets. Now all my new term loans have an ID of "New terms". Unfortunately fixing is a bit of a pain as there are 2 different label types in existence and as treeman has said, we need to understand how the descriptions will be going forward before effecting a fix. Just realised there isn't even consistency in what they've done to date. 2 numbers have an N suffix followed by a - whereas the other has an N suffix without a - .
|
|
|
Post by GSV3MIaC on Jun 2, 2017 10:32:26 GMT
I'm not even interested in the tranche number, assuming all tranches repay at same time, rank pare-passu, etc. That is just an avoidable level of extra complexity for most loans (eg MH etc), where you have to strip out various bits of extra info (' tranche 2', 'second advance', 'further loan', 'final extension', 'WC and chain .. ooops, I made that one up) to get to a clean loan ID you can key off to work out your total exposure(s).
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Jun 2, 2017 13:34:56 GMT
I'm not even interested in the tranche number, assuming all tranches repay at same time, rank pare-passu, etc. That is just an avoidable level of extra complexity for most loans (eg MH etc), where you have to strip out various bits of extra info (' tranche 2', 'second advance', 'further loan', 'final extension', 'WC and chain .. ooops, I made that one up) to get to a clean loan ID you can key off to work out your total exposure(s). Agreed - consistant formats for loan nos and descriptions plus a Loan ID field on the statement would be fine - then we can all get on with whatever level of further jiggery-pokery we have a mind to. Any comments Ed? MoneyThing <EDIT> just seen the 'Holiday' thread - no worries, Ed - it'll keep.
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Jun 7, 2017 22:17:51 GMT
Yep, my spreadsheet is kaput too. I extracted the loan ID by stripping away the brackets. Now all my new term loans have an ID of "New terms". Unfortunately fixing is a bit of a pain as there are 2 different label types in existence and as treeman has said, we need to understand how the descriptions will be going forward before effecting a fix. Just realised there isn't even consistency in what they've done to date. 2 numbers have an N suffix followed by a - whereas the other has an N suffix without a - . The latest New Loan has moved things on a bit ............ On the Statement the Loan No is back in brackets in the details field, no '-', but it's still the old loan no. with 'N' appended. Oakey Dokey - no problem fetching the 3 digits out, however...... .......The My Loans download gives it a new Loan id, which obviously can't be used to cross-reference the Statement. Hmmmm......
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Jun 15, 2017 13:59:57 GMT
MoneyThing Morning Ed, Just done an EoM reconciliation on my account and noticed that the 3 re-new New Terms loans numbering and descriptions are deviating from the now established formats which will confuse Mr Excel once the payment dates roll around this month. On both the Statement and Live Loans downloads the Loan descriptions are still using the previous number (not in brackets as other previous Loan descriptions) with an 'N' appended. The Live Loans download shows the loans all have a new Loan id (not reflected in the description): Loan id Borrower code Asset details 715 MTAQ MTAQ634N-W********* Bridging Loan (New Terms) 716 RCC RCC633N-Business Finance (New Terms) 717 RCC RCC690N 2011 Ferrari 458 Italia Coupe (New Terms) The Statement has only the Details as above (previous Loan no) so extracting the Loan id and reconciliation of payments will be tricky ............. Could you confirm the standard to be used going forward ? The I can fiddle with Excel to avoid a head-spin later in the month by which time there'll no doubt be plenty more on New Terms. I'm not too bothered as long as I know - but preferably keep the New Terms loans in the same format as the rest - in the interests of me not having to do anything MoneyThing Hi Ed, Having just received an email about further renewals tomorrow - could you provide an update regarding the Loan numbering conventions going forward with respect to the 'New Terms' loans?
|
|
|
Post by MoneyThing on Jun 15, 2017 14:05:05 GMT
MoneyThing Morning Ed, Just done an EoM reconciliation on my account and noticed that the 3 re-new New Terms loans numbering and descriptions are deviating from the now established formats which will confuse Mr Excel once the payment dates roll around this month. On both the Statement and Live Loans downloads the Loan descriptions are still using the previous number (not in brackets as other previous Loan descriptions) with an 'N' appended. The Live Loans download shows the loans all have a new Loan id (not reflected in the description): Loan id Borrower code Asset details 715 MTAQ MTAQ634N-W********* Bridging Loan (New Terms) 716 RCC RCC633N-Business Finance (New Terms) 717 RCC RCC690N 2011 Ferrari 458 Italia Coupe (New Terms) The Statement has only the Details as above (previous Loan no) so extracting the Loan id and reconciliation of payments will be tricky ............. Could you confirm the standard to be used going forward ? The I can fiddle with Excel to avoid a head-spin later in the month by which time there'll no doubt be plenty more on New Terms. I'm not too bothered as long as I know - but preferably keep the New Terms loans in the same format as the rest - in the interests of me not having to do anything MoneyThing Hi Ed, Having just received an email about further renewals tomorrow - could you provide an update regarding the Loan numbering conventions going forward with respect to the 'New Terms' loans? Apologies treeman, I now recall your original question which I meant to pick up upon my return. Let me have a think and get back to you (and all). Regards, Ed.
|
|
|
Post by MoneyThing on Jun 15, 2017 15:25:14 GMT
MoneyThing Morning Ed, Just done an EoM reconciliation on my account and noticed that the 3 re-new New Terms loans numbering and descriptions are deviating from the now established formats which will confuse Mr Excel once the payment dates roll around this month. On both the Statement and Live Loans downloads the Loan descriptions are still using the previous number (not in brackets as other previous Loan descriptions) with an 'N' appended. The Live Loans download shows the loans all have a new Loan id (not reflected in the description): Loan id Borrower code Asset details 715 MTAQ MTAQ634N-W********* Bridging Loan (New Terms) 716 RCC RCC633N-Business Finance (New Terms) 717 RCC RCC690N 2011 Ferrari 458 Italia Coupe (New Terms) The Statement has only the Details as above (previous Loan no) so extracting the Loan id and reconciliation of payments will be tricky ............. Could you confirm the standard to be used going forward ? The I can fiddle with Excel to avoid a head-spin later in the month by which time there'll no doubt be plenty more on New Terms. I'm not too bothered as long as I know - but preferably keep the New Terms loans in the same format as the rest - in the interests of me not having to do anything MoneyThing Hi Ed, Having just received an email about further renewals tomorrow - could you provide an update regarding the Loan numbering conventions going forward with respect to the 'New Terms' loans? I have been speaking to TheShuang and we think we have a solution which should make things easier (also incorporating a 'loanpart id'). Should have something to release in a few days... Regards, Ed.
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Jun 15, 2017 17:14:19 GMT
MoneyThing Hi Ed, Having just received an email about further renewals tomorrow - could you provide an update regarding the Loan numbering conventions going forward with respect to the 'New Terms' loans? I have been speaking to TheShuang and we think we have a solution which should make things easier (also incorporating a 'loanpart id'). Should have something to release in a few days... Regards, Ed. Thanks - I shall look forward to seeing what you come up with !
|
|
treeman
Member of DD Central
Posts: 1,026
Likes: 557
|
Post by treeman on Jun 18, 2017 22:23:19 GMT
Aha! Sneaked in under the radar ......... new columns on Statement download - Loan id and Loanpart id.
Nice ! Thanks MoneyThing and ShuangThing !
Was looking at doing my quick weekly spreadsheet reconciliation but looks like a complete re-vamp is in order. Certainly won't be trying that on top of the evenings Ale !
|
|
toast
Member of DD Central
Posts: 158
Likes: 90
|
Post by toast on Jun 24, 2017 18:31:15 GMT
Hmm, I assumed that the "renew all" button would tick all boxes in the renew column, but it didn't tick the boxes that were in the CSP***N range. Is that intentional? Manually ticking them seems to have worked.
|
|
david42
Member of DD Central
Posts: 419
Likes: 346
|
Post by david42 on Jun 25, 2017 13:21:00 GMT
Could that be because the CSP loans have already renewed? The CSP loans renewed on 16 June. If you ticked the "renew all" box before 16 June, I don't know whether the tick rolls across to the new loan.Edit: My theory is wrong. See post from theshape below.
|
|
theshape
Member of DD Central
Posts: 153
Likes: 109
|
Post by theshape on Jun 25, 2017 14:10:00 GMT
Could that be because the CSP loans have already renewed? The CSP loans renewed on 16 June. If you ticked the "renew all" box before 16 June, I don't know whether the tick rolls across to the new loan. I ticked the 'renew all' box before 16 June and the tick box remains ticked for me on the CSP loans following renewal.
|
|