web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Prepayment/Unearned Income Amortization

(0) ShareShare
ReportReport
Posted on by

Hello Everyone!

I've been mulling over how to amortize in NAV 2013 R2 for 2 weeks now. I've actually done a simulation on what I believe to be a good workaround on it so I am posting this for you guys to comment if it's good or not. Here goes!

My client is into leasing office space. We've agreed to have the lease rates in the Item card and have the billing coursed through the Sales Order and Sales Invoices. However, they collect advance rent and security deposit from their lessee.

  • The security deposit is charged at three (3) months worth of rent. It is returned to the lessee at the end of the lease term.
  • The advance rental is charged at three (3) months worth of rent as well. It is amortized at the start of the lease making the first three months or the rent "free".
  • Vendor cards were set up for both the security deposit and advance rental for the lessee to keep them separate. The posting groups are mapped to the Security Deposit and Advance Rental (one Vendor Card, one Posting Group).
    • Both the security deposit and advance rental were recorded in the Cash Receipts Journal by selecting the appropriate vendor and the appropriate balancing cash account.
      • Upon return of the Security Deposit, the transaction is recorded in the Cash Payments Journal by selecting the vendor for the security deposit and the appropriate balancing cash account.
      • The advance rental is "amortized" by recording it in the General Journal. The vendor for the advance rental is selected and the balancing account selected is Rent Income (G/L Account).

All comments are very much welcome!


Thank you! :)

Marco

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Hi,

    In the above case i assume you can use the allocation concept. When you receive advance rent, make an entry for the advance for the particular date. When you amortize the rental part use the recurring journal to apportionate the income.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans