![]() Sometimes you must open all files at once in order for the numbers to get updated correctly. As we all know, this process in Excel doesn’t work smoothly all the time. The hard part here is interlinking all these individual sheets. Your second option is to interlink all spreadsheets and calculate the summary in one master spreadsheet. One way to sum up all individual amounts is doing so manually. Then at the month-end you take the principal and interest amounts of each lease and sum it up.Īnd here is where the problem starts. ![]() The typical scenario is like that: You maintain separate amortization spreadsheets for each lease. How Capital / Finance Lease Accounting Usually Works In case of just few loans or leases this isn’t a big issue.īut if you maintain several dozens of amortization schedules then the task can become quite time consuming. What you need to work out are the principal and interest amounts for each lease and then summarize them. If you are an Accountant for a small or medium sized company with multiple leases (or loans) then you probably experience problems with generating accounting entries every month.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |