Solved

How to record an AP Bill purchasing a service that needs to be amortized in 1 year?

  • 20 December 2021
  • 14 replies
  • 266 views

Userlevel 4
Badge

Hi.

So the brief story is this:

Our company purchased a service that has a validation for 1 year, from DEC 10 2021 to DEC 10 2022 (as shown in the picture below). And I want to record the amount into “Paid in Advance” account, then amortize it monthly. 

The problem is, I couldn’t find anywhere to set it. I tried to set it by creating a new “Non-stock Item” or a new “Posting Class” (shown below), but I’m not sure where to key in the “Paid in Advance” account. Could anyone please tell me how to do it, or if I’m using the wrong form here? Many thanks.

Best regards,

Shuang.

icon

Best answer by ChandraM 21 December 2021, 17:50

View original

14 replies

Userlevel 7
Badge +9

Hi @shuang57 You will see the Prepayment Account on the Vendors Screen as shown below.

 

Userlevel 7
Badge +9

Hi @shuang57  If this is the only case you have, then you can

  1. Create a Prepayment using the Prepayments in the “Checks and Payments” screen. Book it to Prepayments Account.
  2. Create a recurring AP Bill for 12 Months.
  3. Generate the Recurring Transaction every month
  4. Apply the prepayment to the Invoice generated each Month

Thanks

Userlevel 7
Badge +9

Hi @shuang57 If this is very frequent scenario, then you can have the Deferred Revenue Module in Acumatica. This Module takes care of both Deferred revenue(AR) and Expense(AP).

Let me know if you need more details.

Screenshot for reference:

Thanks

Userlevel 4
Badge

Hi @ChandrasekharM Thank you for your answer for different scenarios. For now it is the only case I have, and I’d appreciate it if you could specify on how to generate a Prepayment and then a recurring AP Bill. For the 4 steps you mentioned, could you please reply with an exemple using screenshot demonstration? Thank you very much.

Best regards,

Shuang.

Userlevel 7
Badge +9

Hi @shuang57 Sure will keep you posted shortly.

Userlevel 7
Badge +9

Hi @shuang57 Please find the below screenshots with the steps to create prepayment.

Screenshots for reference:

 

 

Userlevel 7
Badge +9

Hi @shuang57 Please find the below accounting entries for the prepayment transaction, for your reference.
 

 

Userlevel 7
Badge +9

 

Hi @shuang57 Here is the steps to create a recurring transactions in payables. Kindly review and let us know for any queries.

  1. Create Bill. Do not release it. This will be the source template for Recurring Bills every month
  1. Add Schedule to convert the above AP bills to recurring 

 

  1. Every Month. to generate the recurring bill, goto the Recurring Transaction screen and selected the transaction to run/generate the bill for the month. Open recurring transaction and click on “Run Now”. This process can be automated in Automation schedule to run every month.

 

  1. The new Bill generated can be released and applied to the Prepayment that created before. 

Note: The original AP bill template will show as Scheduled. (Screenshot below)

 

Thanks

Userlevel 7
Badge +11

Hi @shuang57 

Deferred expense feature works better in this scenario. I did notice that @ChandrasekharM has mentioned this on this thread. 

Here is how it works.

  • Lets take Insurance as an example, paid for full year on 1st Jan
  • Expense need to be spread across 12 periods (equal installment in this case)
  • Create a Deferral schedule for Insurance expense 
  • Note I have setup an asset account ‘Prepaid insurance’ on the schedule
  • Create an AP bill for Insurance expense. Select deferral schedule code on detail line
  • On release of AP bill, it debits Prepaid Insurance asset account instead of Expense account linked to the non stock item I have selected for Insurance on AP bill 

Note the amount is debited to ‘Prepaid insurance’ account linked to the deferral schedule and not above Insurance expense account

 

Click on ‘view deferrals’, it opens the schedule and reflects the date and amount that would be moved to ‘insurance expense’ account.

Run recognition for each period

Here is the document linked GL batch generated to recognize the expense for first period

Hope this helps,

Regards,

Userlevel 4
Badge

Thanks a lot for the help @ChandrasekharM @vkumar. I can get the logic for both methods.

Just another question for @vkumar pelase. I noticed that you ran recognition on the date of FEB 1. But is it possible to set this date at JAN 31(could I run recognition at the end of each month/period)? Becasue in the Deferral Schedule page I saw the Rec.Date is JAN 31, FEB 28...so I’m a bit confused here. Thanks again.

Best regards,

Shuang.

Userlevel 7
Badge +9

Hi @shuang57 Please find the below screenshot and the flow to answer your question on running the Deferral schedule in end of Feb. 

Self explaining screenshots

  1. Next Schedule is 03/31/21

 

  1. Run Recognition Steps: Able to run the recognition on end of Feb. The grid is loaded based on the Rec.Date selected

 

 

Userlevel 7
Badge +11

Hi @shuang57 

You can select the method of date selection for deferral document generated on Deferral code profile. Its not possible to select Jan 31st for recognition document generated for Feb. Here are the options available :

Hope this clarifies,

Regards,

Userlevel 4
Badge

Thanks for the further explanation @ChandrasekharM @vkumar . Really helpful.

Merry Christmas,

Shuang.

Userlevel 7
Badge +11

you are most welcome, Merry Christmas and Seasons greetings.

Regards,

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved