It would be nice to be updated at all but it is what it is. I guess they keep this here and no one knows what is happening in the wider world but for me this kind of issue always makes one worry if a company is up to the job with these types of gaffs assuming they are not designed out of the system on purpose. Worse than this begs the question what other things are lurking that these people miss under the hood (It's the main reason i keep such close tabs on all places where my money is being stored).
I can download the files but sadly there is still no change in the data that is being downloaded as described previously. I checked all 3 again yesterday (I only have tools that work with csv) to check what state its in and it has not changed since it was first reported the others i just looked at the first few lines in a simple text editor. It seems that Tesco developers perhaps do not know what they are doing or worse the systems have been trashed in some way and its taking time to unpick what caused it. Worse the people helping here should easily be connected to the developer teams and to be honest should bee able to come back in days not weeks with a prognosis.
As an ex developer in a previous life when tools were more basic and things were easier to work with we never ever allowed something to be released into live environments without thorough testing but I guess times have changed with more on the hoof updating these days. I'm sort of assuming that it will no longer be available for the moment and have moved onto changing my spread sheets to use a simple scrape from the visible screens - way more cumbersome but at least i can manage it again with other web tools until they fix this if they do.
As this also when wrong a few months earlier I am assuming Tesco views this feature as a nice to have rather than key business logic. After the last issue tests should have been added to the release process to catch this but obviously they did not.
I don't actually use the .TSV version i use the .csv one but since all 3 are broken since they changed things and I needed to know where i was I did the following. I think that's what I did ... ;-) The simple answer is text copy and replace but hopefully this procedure helps.
1. Open up the current cc screen and make it show the full amount of data down to the end of the SYLS (Since your last statement) screen. I went back as far as the error but to get it correct, balance wise, I eventually went back as far as the last months whole list.
2. From the bottom of the list I just grabbed the whole lot each section so that all i had was the data with the section titles. and copied it using right click on my PC not sure on a tablet or phone I would never use these things for banking. I then opened up an new Excel table, selected the top left cell and just pasted the items in.
Sadly my version of excel (2007) scrunches everything but i just changed all the items to simple text. Also when I tested this procedure I noticed that the whole lot (Pending and SYLS) can be copied complete - well almost!.
3. I then spread the columns slightly so all info fitted into a single line and double clicked on the line markers to scrunch them to single rows. (You need to select the whole page for this action)
4. There may be a a little bit of further juggling with excel formatting.
5. I then created a balance column and starting from the previous months final balance I just did a simple balance = previous balance + in - out etc depending on how you like to see a rolling balance if you do.
I created the upper section in a similar way and joined the two to get a true current balance but you may not need that bit depending on your needs. The thing i am expecting at the end of this month where the current SYLS is copied to the whole month and we start all over again, well they do if i'm right, then the same problems may occur till they fix it. In my case I don't care anymore as i'll just carry on with the lower half being populated with the top half as and when they move from top to bottom. (I just use simple text copy - bit long winded if wife spends a lot in a day! but it works.
In my case also I've noticed that stuff i'm expecting from receipts appears in the pending section but then sometime times gets dropped but does not appear in the current SYLS for quite some time - I Leave them in my top section marked in red and make them remain part of the balance. I'm guessing a lot of that is due to outside transaction dropouts caused by donor ends.
Anyway not sure i've got it 100% but my wife is spending quite a bit on our card since we gained a grandchild and i keep up with the top half and moving them down manually - it is a bit of a juggle making sure the inserts and subtotals are correct but one gets used to this very quickly with a wife like mine ;-).
Thanks for that. I'll give it a try. I was hoping that you had found some little trick that would make it simple.
I've just tried it. There are, of course, some problems with it, mainly the dating
The Transaction Date copies as 'Day DD MMM YY' and there is no Posting Date.
But that method helps a great deal.
I use .tsv because if a retailer includes a comma in the trading name (e.g. Smith, Jones & Co) then a .csv will add an extra column. Tabs won't occur in trader's names.
I currently have a rolling spread sheet that I slot the download into. At the end of the month I summarize all my categorized transaction in a Quicken database, a great way of keeping track of where and how we are spending our money.
Thanks for the tip.
Since I started writing this (I'm playing with the copied transactions whilst writing) I've found a simple way to automate converting 'Day DD MMM YY' to DD/MM/YY, slightly clunky but I don't have to re-enter all the dates. Now the only serious missing bit is the posting date but I guess that's only important around the billing date.
Glad you got something out of it. I wasn't so bothered about the dates as like you i'm hoping they will fixit. My solution whilst a fully fledged spread sheet was only to be able to see how much i owed, pay and move on.
In case they don't fix it then i might consider reworking the dates issue. I'm intrigued what happens when the month is finished and it appears in the month section but to be honest i'm only really interested in the actual spend per month.
Anyway fingers crossed they fix it soon if not then when the eight weeks is up for me then i'll poke it at the regulators.
@JoeC and @RossM, it's been painfully long already, is there any update that can be provided?
As I've mentioned in a different thread on the same problem, this really is essential functionality for many people. For me, it's just an annoyance as I have a set of automated scripts that classify transactions based on that CSV. For others though, it could even be a UK GDPR "Right to data portability" concern.
There have been some changes over time, you used to be able to download csv's of all past statements but that disappeared awhile ago this suggests to me that Tesco are in middle of an process upgrade and something has fallen through the gap. Very annoying as it means I have to type data in to my tracker manually now
@unwina...
I use .tsv because if a retailer includes a comma in the trading name (e.g. Smith, Jones & Co) then a .csv will add an extra column. Tabs won't occur in trader's names.
...
.
The fields, except for the transaction value, are enclosed in quotes "Smith, Jones & Co" should be correctly recognised as a single field.
Last edited by Johnny_Mo; 17-04-22 at 20:50.
Reason: Formatting
Is it fixed, doesn't look like it to me so I assume this is either a gentle dig at Tesco or just a thank-you for all of us that are trying to work with the mess. 😉
BTW, i noticed the other day that, sometimes items skip the pending screen completely and go straight to the SYLS section - depending when one checks although most seem to come through very quickly and may disappear altogether for a few days too. In particular i noticed this with a recent Tesco Petrol entry, they always seem problematic from our location. Fortunately with my new spreadsheet i was able to notice it as I put all my expected items in my pending section and mark them in Orange until they appear in the pending screen. If it were not for my version of the SLYS (I think i will keep it as rolling if it doesn't get fixed soon) adding up different to the onscreen available credit and onscreen balance items i might have missed it altogether!
Of course if one is simply loading all the csv/tsv/qif data then this would probably not be an issue. The new process does not seem to cater for a complete list or at least the last 3 months as it used to!.
Tesco Personal Finance plc, trading as Tesco Bank as part of the Tesco Group take the security of your data seriously. We want you to be confident that your data is safe and secure with us and understand how we use it.
We collect data when you browse our website (e.g. your IP address) and register for the Community. To find out more about how we use your data, our legal basis for processing your data and your rights under data protection laws please view our Privacy Policy.
How we collect and use your personal data
Tesco Personal Finance plc, trading as Tesco Bank as part of the Tesco Group take the security of your data seriously. We want you to be confident that your data is safe and secure with us and understand how we use it.
We collect data when you browse our website (e.g. your IP address) and register for the Community. To find out more about how we use your data, our legal basis for processing your data and your rights under data protection laws please view our Privacy Policy.
Terms of Service
Registration to this forum is free! We do insist that you abide by the rules and policies detailedbelow. If you agree to the terms, please check the 'I agree' checkbox and press the 'Complete Registration' button below. If you would like to cancel the registration, click here to return to the forums index.
Tesco Bank Community Terms of Service v 1.0
The Tesco Bank online community ('Your Community') is for Tesco Bank customers, staff, contributors and supporters to discuss products, services, issues and matters of general interest. Your Community content may be viewed by both members and non-members.
We encourage you to enjoy Your Community. However, please note that by using Your Community, you're confirming to us that you've read and have agreed to be bound by these Terms of Service and our House Rules. If you're unable to accept these Terms of Service and/or our House Rules for any reason, please do not use Your Community.
To the extent that there's any conflict between these Terms of Service, our House Rules, or any other document, posting or communication connected to Your Community, these Terms of Service will prevail.
Any reference to 'we,' 'us,', 'our' is a reference to Tesco Bank which is a trading name of Tesco Personal Finance plc. We are part of the Tesco plc group. For information about our group of companies please visit www.tescoplc.com and click on 'About Us'.
Registration
The information you provide during the registration process must be true, accurate and complete. You must not register under the name of another person or organisation and you must not register under more than one name. If we've reasonable grounds to suspect that the registration information you provided is untrue, inaccurate, or incomplete, we may suspend or terminate your account and prohibit your future use of Your Community.
When registering, you'll be required to select a username that will be seen by all people who visit Your Community. The username you select must:
not be the same as, or similar to, your Tesco Bank internet banking username or password (if you're a Tesco Bank customer) or the username or password for any other sites you may use;
not contain any details you don't wish to be viewed by the general public; and
not be defamatory, offensive, impersonate any other person or entity, infringe the intellectual property rights of any person or entity, or otherwise mislead or deceive others.
We reserve the right to reject any username or remove any image that we determine in our sole discretion is unacceptable for use as a username or image in Your Community.
Personal responsibility
You're responsible for all content posted or communicated under your username, including the use of your username by others. You're responsible for keeping your password confidential and you agree that you'll not share your login details with anyone, let anyone else access your account, or do anything else that may compromise the security of your password or user account. You may use Your Community for lawful purposes only. It is your obligation to ensure that when operating your user account and posting content, you'll comply with the laws of the United Kingdom.
Your reliance on content
You use Your Community at your own risk. You are solely responsible for your use of Your Community and reliance on the content
The views expressed within Your Community are not our views and are not endorsed by us, unless provided by a Tesco Bank representative designated as a Moderator, Your Community Expert or Community Manager. We do not vouch for the accuracy or authenticity of posts or communications and do not take responsibility for any opinions you or other users choose to provide.
The posts and other communications do not represent financial advice from Tesco Bank and must not be treated as such, even if they are directed to you. Posts are general information only and you must carefully consider any decisions you make based on the content of Your Community. Before relying on any other user's posts or communications, you should make your own enquiries and ensure that any action you take as a result is right for you. Note that opinions and advice in relation to financial products and services on Your Community are not personalised to you or other users.
From time to time, staff members of Tesco Bank, our suppliers and affiliates, may be present on Your Community. In doing so, unless designated as a Moderator, Your Community Expert or Community Manager these staff members are acting in their personal capacity and not as an employee, adviser, representative or agent of Tesco Bank and are personally responsible for the content of their posts and communications. The content of such posts and communications don't constitute our views.
Third Party Websites
Your Community may contain or reference links to non-Tesco websites ('Third Party Websites'). By accessing links to Third Party Websites, you may be exposed to content that you consider inaccurate, offensive or inappropriate. We are not responsible for the content of any Third Party Website or any link contained in a Third Party Website. The inclusion of a link within Your Community does not imply any endorsement by or any affiliation with us. Access to any Third Party Website is at your own risk, and you should be aware that Third Party Websites may contain terms and privacy policies that are different from Your Community. We're not responsible for loss, costs or liability arising from accessing or using such Third Party Websites.
Marketing
Your Community must not be used by you or any other user as a marketing platform. However, we acknowledge that from time to time, some content may contain references to products, services, articles, offers and promotions offered by third parties (not by us). These third-party offerings are not endorsed by us. If you decide to use these third-party offerings, you're responsible for reviewing and understanding the terms and conditions governing those products or services and ensuring you understand the risks. You agree that the third party, and not us, is responsible for performance of the services or the quality of any product.
Misuse
You must comply with our House Rules; please review them carefully and regularly. In particular, you must not post any content or communication that is inappropriate, threatening, abusive, offensive, or misleading, or use Your Community or its features to engage in any advertising, marketing or solicitation, including activities such as spamming or phishing. You must not post or communicate any content, or do anything, which would overburden, disrupt or disable the proper working or appearance of Your Community. Your Community relies upon its users to identify and report content or conduct that does not align with the House Rules or these Terms of Service. Therefore, it is each user's responsibility to report objectionable content by utilising the 'Report Inappropriate Content' functionality available throughout Your Community.
Monitoring and moderation
Your Community has moderators who aim to ensure that these Terms of Service and our House Rules are followed. Moderators do not pre-screen postings or communications. Moderators have the right to edit or remove content at their discretion and for any purpose. Moderators are under no obligation to provide a reason for removing any content or to enter into discussion regarding the removal.
Moderators may or may not investigate any complaint that is brought to their attention, and may or may not take appropriate action, including, but not limited to issuing warnings, moving or removing content, or suspending or terminating any user name and user account. Because situations and interpretations vary, it is possible that we may take no action whatsoever. The failure to act with respect to a violation by you or others does not waive the ability to act differently with respect to subsequent or similar violations.
Warnings, suspensions, and terminations
Moderators may communicate with you personally concerning Your Community or related matters. Those communications are confidential between you and us and are not intended to be made public. As such you agree not to post or otherwise disseminate those communications within Your Community or elsewhere, on the Internet or otherwise.
You agree that your registration and access to Your Community may be immediately suspended or terminated without explanation or prior notice. Without limiting the foregoing, the following may, at our sole discretion, lead to a termination of a user's registration and access to Tesco Bank Community:
breach of these Terms of Service, the House Rules or other related agreements or guidelines;
request by law enforcement or other government agencies;
a request by you;
unexpected technical issue or problem; and
extended periods of inactivity.
Termination of your registration includes removal of access to all offerings within Your Community and may also prevent you from engaging in further use of Your Community. Furthermore, you agree that neither us nor the moderators shall be liable to you or any third-party for any termination of your registration or access to Your Community.
Rights to content
When you upload or submit content (such as text, data, images or names, when permitted) to Your Community, you grant us a right to use, copy, modify, publish or otherwise distribute that content, including any personal information that may be included in the content, for any purpose, including, without limiting the foregoing, the administration and management of Your Community, marketing including in social media, analytical purposes, and new product or service development. The licence you grant us is perpetual, irrevocable, royalty-free, transferable, worldwide, and we'll not be required to obtain your permission for any such use or attribute any content to you.
In submitting content to Your Community, you expressly release us from any and all present and future claims that we have made unauthorised use of your idea.
Your Community and all content on it (including all Tesco Bank logos, trademarks, the look and feel of Your Community, and content posted or communicated by other users) remains the intellectual property of Tesco Bank and/or our licensors and, in the case of content posted or communicated by other users, the relevant user(s). You may not use any such content for any purpose other than to access and use Your Community as envisaged by, and in accordance with, these Terms of Service.
Security
We do not warrant that Your Community is secure, free from bugs, viruses, interruptions, errors, or other limitations. Any content that you place on Your Community is posted at your own risk, and could be obtained and used by others. You should think before posting or communicating any personal or financial details about yourself on Your Community. You should not reveal information that you don't want to make public, such as posts or communications including your contact information or email address. We'll not be responsible or liable for any loss arising from your disclosure of personal information, or any other information, in any profile, post or communication.
Privacy
We ask that you do not post any personal information to Your Community, such as your full name, contact details or account numbers. We also ask that you do not post personal information about others, or ask others to disclose their own personal information on Your Community. In some specific and rare circumstances we may offer you the option to provide us with personal information via the private messaging function of Your Community. You will not be under any obligation to do this, but it may assist us in helping you.
Consent
By using Your Community and accepting these Terms of Service, you consent to the collection, use, disclosure, storage and processing of your personal information in accordance with these Terms of Service and Tesco Bank's web privacy policy.
Access and correction
We reserve the right to instruct the moderators to remove any posts in Your Community containing phone numbers, street addresses, or otherwise personally identifying information on the grounds that we're not able to verify the information as being your personal information or that of a third party.
By submitting your email address to register, you agree that our third party service providers and the moderators may use your email address to contact you directly about your profile or any content you post on User Community and for other administrative purposes related to Your Community.
You further agree that if you wish to collect or use information or content posted or relating to other Your Community users, you must first obtain the relevant user's consent and make it clear that you (and not Tesco Bank) are collecting their information, the reason for which you're collecting their information and explain the purpose for which the information will be used.
Indemnification
You agree to indemnify, defend, and hold harmless from and against any and all losses, damages, liabilities and costs (including, without limitation, settlement costs and any legal or other fees and expenses for investigating or defending any actions or threatened actions) incurred by the Indemnified Parties in connection with any claim arising out of any breach by you of these Terms of Service or the House Rules or claims arising from your content or conduct. 'Indemnified Parties' includes us, the moderators, and all respective officers, directors, owners, employees, agents, representatives, and assigns.
You agree to cooperate with us in the defence of any claim. We reserve the right, at our own expense, to employ separate legal representation and assume the exclusive defence and control of any matter subject to indemnification by you.
All third party content (content posted or communicated by registered users including any content) is the sole responsibility of the registered user posting or communicating the content. You acknowledge and agree that we don't control and are not responsible for the third party content. As such, you shall fully indemnify us against any claim (including solicitor fees) arising out of content you post or otherwise make available on Your Community or your use of Your Community.
Limitation of liability
You agree that, to the maximum extent permitted by law, at no time will we (including our officers, directors, owners, employees, agents, representatives and assigns and the moderators) be liable for any costs, direct or indirect loss or damages, consequential loss, howsoever arising out of your use of Your Community, the content you or other users post or otherwise make available on Your Community (including, but not limited to, damages relating to loss of business, loss of money, telecommunications matters, exposure to any form of virus, bugs or such other malicious code, theft, damages or other losses you or any third party may suffer) regardless of whether the claim is based on breach of contract, breach of warranty, tort (including negligence), product liability or otherwise.
Choice of law and location for resolving disputes
You agree that the laws of Scotland govern these Terms of Service and any claim or dispute that you may have against us will be resolved in Scottish courts only.
Modifying these Terms of Service
We reserve the right, in our sole discretion, to modify these Terms of Service at any time without notice. Modified Terms of Service are effective as soon as they are posted. We also reserve the right to waive or modify any of these Terms of Service as they apply to a specific posting, communication or user without affecting the application of these Terms of Service to all other postings, communications and users. Your continued use of Your Community, or any content or services accessible through it, after modified Terms of Service are posted means you accept the modifications. We may also make any changes to the look and feel of Your Community at any time without notice.