Loans and Interest
Roll the loan schedule forward, agree it to the ledger, recompute interest and test the current portion.
- Ledger + loan schedule
- Key analysis in Cash & financing
How the result is read
The loan schedule is the sub-ledger of the debt. Each loan is rolled forward on its own arithmetic, its movement agreed to the ledger lines that name it, and its interest recomputed on the average balance at the stated rate. A facility drawn per the schedule that nothing in the ledger names is unrecorded debt. Repayments due within twelve months are a current liability: when the ledger holds less short-term debt than the schedule says is due, the split of the balance sheet is wrong even if the total is right.
In the application
Loans and Interest is filed under Cash & financing, index letter G. "Run all analyses" runs it with every other analysis the ledger and the documents loaded can answer. The worksheet states the population it tested on its face — or "Not applicable" with the reason when a column it depends on is empty — and the Excel workbook the engagement exports files it under G, beside an index of the source files with their SHA-256 fingerprints.
Read it with
Run your next audit file test without the Excel crash.
One free engagement to evaluate, valid 60 days. The ledger never leaves the machine.
- 20 minutes
- Runs on a fictional engagement
- No client data required