Compare
Amortivo vs running your book in spreadsheets
Spreadsheets are where most private lenders start. Here is what changes when the book grows past what one workbook — and one person — can safely hold.
| Task | Spreadsheets | Amortivo |
|---|---|---|
| Loan register | One workbook, edited by several people, with no history of who changed what | Every loan, its ledger and its documents, with a full audit trail |
| Interest and payouts | Formulas copied between files; per diem and penalties calculated differently each time | One tested calculation engine for interest, arrears, payouts and penalties |
| PAD payments | Debit list rebuilt each month and keyed into online banking | CPA-005 file built from the payment schedule |
| NSFs and arrears | Noticed when someone checks the bank | Returned payment opens a collections case with fees, notices and follow-ups |
| Investor distributions | A share calculation rebuilt each month; held amounts tracked from memory | Calculated per lender, held and released automatically, approved by a second person |
| Trust reconciliation | Bank statement ticked off by hand | Statement import, auto-matching and three-way reconciliation with sign-off |
| Accounting | Everything re-keyed into QuickBooks | Journals post automatically; export if your accountant needs them |
| Renewals | Found by scanning the maturity column | 90-day maturity pipeline and renewal offers |
| Compliance | Files in folders and inboxes | KYC, ownership and FINTRAC records with the client |
| Investor and borrower questions | Phone calls and emails | Secure portals for statements, balances and requests |
FAQ
Common questions
When should a private lender move off spreadsheets?
Usually when there is more than one person updating the book, when investors are paid monthly from collected interest, or when trust reconciliation starts taking days. At that point the time and error risk of re-keying outweighs the cost of software.
Can we import our existing spreadsheets?
Yes. Amortivo imports contacts, loans, lender positions, payment history and documents from spreadsheets, with a test run first and a reconciliation checklist before you go live.
See your loan book in Amortivo.
A 30-minute walkthrough with your own scenarios — origination to investor payout.