Here it is. I’ve create an Excel Files with a sheet for each financing. In each of these identical sheets I covered all the possible variables that I can get in a loan agreement. Based on the parameters I set the description of each line is automatically generated. I also create a space insert final data from the banks without altering the automatic formulas. In this case the remaining loan mortgage plan automatically updates the remaining installments.
Then I created a reporting tool in a specific sheet that gets data through a VLOOKUP in all those sheets. I set the referal date and I set the code of each financing I want to query (the name of the excel sheet). The tool reminds me all the linked expiring loans at that date.
Each installment is composed of for lines of a journal entry so I linked them to UUIDs of Manager’s Chart of Accounts (and also to the UUID of the tracking codes):
It all ends up with an automatically generated batch create sheet:
with one line for each financing that can be pasted directly in Manager.
Two days of work that will save us at least half day of work each month with manual entry that we all know is very error prone!