Deferral templates and how they work...
I was talking to a client the other day, all full of confidence, and she asked me a question about Deferral Templates that caught me out.
What she wanted to know was how deferrals work in NAV/BC if the invoice is posted in the middle of the month. Is there an element of pro rata or does the deferred amount just get posted back into the beginning of the month on a date earlier than the original invoice.
My mind went blank. It’s a few years since I’d set up a deferral template and, whilst I knew that I knew, I simply couldn’t remember.
I immediately fessed up and told her I’d go and brush up and get back to her (never try to bluff. It’s always best to confess and come back when you’ve found out the answer). so I did and I thought I’d share the result.
I did this in NAV 2019 but it’s pretty much unchanged in BC.
Deferral will take the amount of an invoice or journal and spread it across the current and following periods according to a set of rules. The rules are set in a Deferral Template. The Template looks like this:
It’s good practice to name your template in such a way as you don’t get mixed up. This one is for deferral across six months in a straight line and is using a sales G/L for the Deferral Account.
Deferral %: This determines the amount of the invoice that will be deferred. Here we’re deferring all of it. But if you were to set this to 80, it would post 20% of the invoice value directly and the defer the rest over the following months
Calc. Method and Start Date: These two fields tell NAV how you want to calculate the deferral. Specifically:
Straight Line: Defers by dividing the amount to be deferred by the number of periods specified depending upon the Start Date. Here, we’re using Posting Date so it will make seven deferral postings. The first and last are pro rata and the middle five will be equal and posted on the first day of the period. The last, pro rata’d posting will also be dated at the start of the final period.
It will do a similar Pro rata calc if you choose End Of Period as the start date in that it will calculate the amount left to the end of the period, defer that first, then five equal payments followed by a final pro rata payment to make up the remaining sum. Whereas Beginning of period and Beginning of Next Period will do exactly what they say they will.
Equal Per Period: This is pretty self-explanatory. The amount to be deferred is split equally by period but again it pro rata’s if the posting date is in the middle of the period
Days Per Period: Will divide up the deferral by the number of days and allocate the amount according to the number of days in each accounting period. So if you are using calendar months it will calculate a different amount for February and March. Similarly if you use a 5-4-4 pattern to each quarter it will calculate a higher amount in the five week period.
No. of Periods: This is simply the number of periods over which you wish to calculate the deferral. Bear in mind that, as shown above, some combinations of Calc Method and Start Date will pro rata the first and last months of the deferral giving you an extra month.
Period Desc: This allows for you to provide a dynamic posting description for your deferral entries as seen in the G/L entries above. The text in the template here is “Sales Deferred for %4 %6”.
- %4 returns the Month name of the period in which the entry is posted
- %6 returns the fiscal year of the posting date
Other codes are
- %1 = Day number
- %2 = Week number
- %5 = Accounting period name (from the account period table)