Note: this topic is not exclusively related to Tiller, but may be helpful for those individuals wanting to track their Apple Card transactions with Tiller.
For those stuck on older iOS devices (e.g., iPhone 6, iPhone 5, etc) which can no longer update to the latest iOS version (i.e., devices running v12.4.5 and earlier), I have created a web app for converting your Apple Card PDF statements to CSV, which can then be imported into Tiller.
, @kgryte! Thank you. I’m sure this will be helpful to some customers! Would you be willing to include Tiller Money with a URL at the list at the bottom of this page?
Also, just want to confirm that if someone uses this service their personal transaction data or any personally identifiable (name, email, or physical address) or sensitive (i.e. Apple Card account number) that’s available in the statement or output CSV is not collected nor stored anywhere per your privacy policy here? https://app.termly.io/document/privacy-policy/d3a63558-285a-473a-a8e3-dc9338e5ceb1#infocollect
Re: Privacy Policy. That is correct. All statement conversion happens directly in the web browser and no personal transaction data is collected per the Privacy Policy. The web application is served by a static server and uses a JavaScript PDF parser written by Mozilla (see https://github.com/mozilla/pdfjs-dist) to parse the Apple Card statements, so no data transmission is needed for parsing, etc. The web app does use Google Analytics to track how users are referred to the site, but the information is limited to IP address, referrer, browser, etc.
If individuals are interested in viewing the source code, I can provide a link. Additionally, if someone wants to perform due diligence and confirm that no data is being posted back to the host server, they can open the dev console in their browser and monitor the network requests.
Hi tiller peeps, I’m new to community. Loving the system and the discussions are very helpful.
Heads up, Apple PDF and CSV exports of monthly statements has Debit/Purchase transactions show as Positive numbers and Payments as Negative numbers in their Amount column.
What this means - You’ll need to change those amounts to be Negative for Debit/Purchase and Positive for Payments for tiller to import/paste into Transactions correctly. My solution was to create 1 formula column (multiply Amount by -1), then a 2nd column to paste that column’s formula results as Values only.
Then I continued formatting the sheet using the new column with correct Values as the “Amounts” column for import.
Attaching a screenshot, hope this helps some of y’all.
, 