HowTo #028

How to post an invoice on an accrual basis?

Use Case:

You are working in the finance department and receive an insurance invoice which includes the costs for a complete year. You would like to post a purchase invoice but one of your goals is to post the costs in the books on an accrual basis. In the case of the insurance invoice, the costs should be divided by twelve to have it per month. One possibility would be to enter 12 lines but then we have only one posting date. We can also post one value and do afterwards a correction, but the more effective way would be to use Deferral Templates.

Let’s see how to do the setup and try an example to know how to defer revenues and expenses.

HowTo: Set up Deferral Templates and use it in Purchase Invoices

01

First, we start with the setup and therefore you open Deferral Templates.

02

Press + New in the top menu.

03

A new Deferral Template Card will be opened. Here we will first fill the General FastTab as follows:

  • Deferral Code: 12M
  • Description: 12 Months
  • Deferral Account: please enter the one which is used in your company
04

Next, we fill the Deferral Schedule FastTab as written below:

  • Deferral %: 100
  • Calc. Method: Straight-Line
  • Start Date: Posting Date
  • No. of Periods: 12
  • Period Desc.: Deferral %4 %6
05

After closing the Deferral Template Card, we will now start a test. Therefore, please create a new Purchase Invoice.

06

Fill the mandatory fields in the General FastTab, like Vendor Name.

07

Enter a Line with Type: G/L Account and No. e.g. Insurance costs.

08

For Quantity we fill 1 and in the Direct Unit Cost per PU the sum of the invoice.

09

Now we enter the Deferral Code 12M which we just created. You may need to personalize the columns in the Lines section first.

Extra tip: You can also enter a Default Deferral Template on the G/L Account Card to make it easier for you to use the function.
10

In the Lines section, click on Deferral Schedule.

11

Now you can check the Deferral Schedule and, if necessary, adjust it.

12

In our case, for example, we change the Start Date to 1-1-2025 as the insurance costs are for the complete year and our fiscal year starts on the first of January.

13

After the adjustment click on Calculate Schedule.

14

If the allocation is as you expect now, click Close.

15

As a last step, you Post your Purchase Invoice.

16

In the background the following entries have been posted additionally to the usual entries:

  • Credit on the insurance G/L Account on the posting date
  • Debit on the Deferral G/L Account on the posting date
  • Credit on the Deferral G/L Account on the first day of each month
  • Debit on the insurance G/L Account on the first day of each month
Conclusion

Since this is a standard functionality in Business Central, some information is available from Microsoft. For example, check out the following video and website, there you can also find the placeholder for the Period Desc.:

Leave a Reply

    Feature of the Week

    No ads: A new HowTo for acadon Software every week.

    Wood be nice to have

    You have an idea for a new function or feature?

    Only for acadon customers

    OnRoute App
    Try our new OnRoute app free for 30 days!
    timber tree
    timber tree
    acadon logo
    The acadon AG has 40 years of experience in ERP software for the wood industry. As business optimizers, we develop tailored solutions and strategies for your company.
    © 2024 acadon AG. All rights reserved.

    Webinar registration

    Request free demo now!