For Interest Debt Calculation Service contact info@percentyourinterest.com
Three files are needed (i.e. CSV, Excel)
service payment is 9.99GBP/5MB (multiple files up to 5MB all together; costs more for larger files)
First is Due Payment Sheet; the table is shown as an example
Payment Date | Transaction Description | Payment Amount |
---|---|---|
2020-05-17 | SPA Service | 24 |
2020-05-19 | SPA Service | 25 |
2020-05-22 | SPA Service | 22 |
Second is Debt Repayment Sheet; the table is shown as an example
Transaction Date | Transaction Description | Debit Amount |
---|---|---|
2020-05-17 | SPA Service | 23 |
2020-05-19 | SPA Service | 25 |
2020-05-24 | SPA Service | 22 |
Third is Interest Rate Sheet; the table is shown as an example
Date | Interest Rate |
---|---|
2020-05-17 | 10 |
2020-05-18 | 10 |
... | ... |
Generated Resulting Sheet (i.e. CSV) will be provided; the table is shown as an example
Date | Payment Date | Transaction Date | Transaction Description | Payment Amount | Debit Amount | Interest | Debt |
---|---|---|---|---|---|---|---|
2020-05-17 | 2020-05-17 | 2020-05-17 | SPA Service | 24 | 23 | 0 | 1 |
2020-05-18 | 0 | 0 | 0.1 | 1.1 | |||
2020-05-19 | 2020-05-19 | 2020-05-19 | SPA Service | 25 | 25 | 0.1 | 1.2 |
2020-05-20 | 0 | 0 | 0.1 | 1.3 | |||
2020-05-21 | 0 | 0 | 0.1 | 1.4 | |||
2020-05-22 | 2020-05-22 | SPA Service | 22 | 0 | 0.1 | 23.5 | |
2020-05-23 | 0 | 0 | 2.35 | 25.85 | |||
2020-05-24 | 2020-05-24 | SPA Service | 0 | 22 | 2.35 | 6.2 | |
2020-05-25 | 0 | 0 | 0.62 | 6.82 | |||
2020-05-26 | 0 | 0 | 0.62 | 7.44 | |||
... | ... | ... | ... | ... | ... | ... | ... |