You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Prepaid amortization schedules

Accepted answer
edited Feb 3, 2022 2:11PM in Account Reconciliation 3 comments


Is there a way to bulk upload amortization schedules? (Multiple schedules at a time)

Content (required):

Updating this idea to show findings:

Straight line can be imported in bulk by the following:

  1.  From inside the recon (1 recon at a time)
  2. From the Reconciliations >> Actions menu (across 1 or more recons as needed)
  3. From Excel directly using the Smart View adapter (on the back-end the import for this is actually the same as 2)
  4. From Data Management (and the source here could be a subledger or text file, etc. since DM supports all that)

If the amort transaction requires a custom schedule there is one extra step…you have to first create the transaction in any of the ways mentioned above, then the extra step for each transaction edit it to upload the custom amort schedule.   

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!