puddleduck
Member of DD Central
Posts: 537
Likes: 489
|
Post by puddleduck on Jun 26, 2018 17:45:18 GMT
Sorry if this seems a daft question, but it's occured to me that Assetz Capital seems to be about the only platform I use that doesn't display the total interest earned anywhere. I've played around before I typed this as I thought I must be missing something and it'd be buried there, but I can't see it.
I could export a statement into a spreadsheet and sum it, but thats inefficient use of my time - have I missed this somewhere.
Almost embarrassed to ask this, as I'm sure it's hidden somewhere and I've got a blindspot.
EDIT - Oh I think I've found a way, messing about in reports / tax statement and changing the date range, but that doesn't give me a per account breakdown.
|
|
Steerpike
Member of DD Central
Posts: 1,977 
Likes: 1,687
|
Post by Steerpike on Jun 26, 2018 17:51:50 GMT
Sorry if this seems a daft question, but it's occured to me that Assetz Capital seems to be about the only platform I use that doesn't display the total interest earned anywhere. I've played around before I typed this as I thought I must be missing something and it'd be buried there, but I can't see it. I could export a statement into a spreadsheet and sum it, but thats inefficient use of my time - have I missed this somewhere. Almost embarrassed to ask this, as I'm sure it's hidden somewhere and I've got a blindspot. EDIT - Oh I think I've found a way, messing about in reports / tax statement and changing the date range, but that doesn't give me a per account breakdown. I add up the ins and outs and compare with the balance, the difference is interest, probably.
|
|
puddleduck
Member of DD Central
Posts: 537
Likes: 489
|
Post by puddleduck on Jun 26, 2018 17:55:18 GMT
Sorry if this seems a daft question, but it's occured to me that Assetz Capital seems to be about the only platform I use that doesn't display the total interest earned anywhere. I've played around before I typed this as I thought I must be missing something and it'd be buried there, but I can't see it. I could export a statement into a spreadsheet and sum it, but thats inefficient use of my time - have I missed this somewhere. Almost embarrassed to ask this, as I'm sure it's hidden somewhere and I've got a blindspot. EDIT - Oh I think I've found a way, messing about in reports / tax statement and changing the date range, but that doesn't give me a per account breakdown. I add up the ins and outs and compare with the balance, the difference is interest, probably. So you are confirming this isn't automated on Assetz? I've not missed anything? I could certainly do that, it just seems remarkably inefficient!
|
|
|
|
Post by pmjenkins on Jun 26, 2018 18:36:52 GMT
As far as I know there isn't an easy way to do what you want.
As I think you've found, Reports -> Tax Statement -> [define custom date range] would show you the total interest for all accounts, EXCEPT I usually get the error "Ooops! Unfortunately the servers must be extremely busy for you to see this timeout message"
Alternatively, select Reports -> Account Statements -> [select account] -> [define custom date range] -> Go -> Download as CSV.
Extract the lines containing the phrase "Interest pay"; load into a spreadsheet and sum the values. (I have a Windows script that semi-automates the filtering of the CSV files)
|
|
dave2
Member of DD Central
Posts: 177
Likes: 163
|
Post by dave2 on Jun 27, 2018 7:40:28 GMT
Extract the lines containing the phrase "Interest pay"; load into a spreadsheet and sum the values. (I have a Windows script that semi-automates the filtering of the CSV files) The GBBA also has the following interest posting narratives:
- "Provision fund interest payment for loan xxxxx...."
- "Compound interest on late payment from provision fund for loan xxxxx...."
Are there any others?
|
|
aligibbs
Member of DD Central
Posts: 69
Likes: 25
|
Post by aligibbs on Jun 27, 2018 8:10:14 GMT
Maybe I'm wrong, but I'm sure one of the fields at the top used to be customised to show "interest earned previous tax year". This isn't here now anyway. I keep a spreadsheet with figures I update on a monthly basis.
|
|
benaj
Member of DD Central
N/A
Posts: 5,610
Likes: 1,739
|
Post by benaj on Jun 28, 2018 12:05:10 GMT
As far as I know there isn't an easy way to do what you want.
As I think you've found, Reports -> Tax Statement -> [define custom date range] would show you the total interest for all accounts, EXCEPT I usually get the error "Ooops! Unfortunately the servers must be extremely busy for you to see this timeout message"
Alternatively, select Reports -> Account Statements -> [select account] -> [define custom date range] -> Go -> Download as CSV.
Extract the lines containing the phrase "Interest pay"; load into a spreadsheet and sum the values. (I have a Windows script that semi-automates the filtering of the CSV files)
I wish AC can display these figures on its portal. It's a pain to download a file, and fiddle with it. For example, I recently downloaded a file for PSA (90 days file), it has more than 30k rows and roughly 500 rows for interest in 127 different business. 
|
|
