Sometimes you may find a small variance between the generated lease schedule in AssetAccountant and your finance company’s calculation, in terms of allocation of Principal and Interest.
You may like to import the lease schedule for Principal and Interest amount for each monthly payment so you can match the resultant schedule supplied by the leasing company.
It is possible to copy and paste these financier supplied lease schedules into AssetAccountant. To do this, manually create a lease in the AssetAccountant system from "Add Asset > Single Asset".
Choose to enter a lease and pick the "Custom" option as shown in the red box in the screenshot below.
You will need a spreadsheet with the columns:
- Payment date
- Capital component of the payment
- Interest component of the payment
If you copy this, you can paste it into the yellow highlighted cell below and it will populate the table with the calculated split:
