When using Leases in FAM is there any other way to...
# accounting
n
When using Leases in FAM is there any other way to link an Asset to a Lease without having to do the whole Asset Proposal process? It's just so many steps!!
s
Nope.
k
no, and every step is important… to accounting.
n
Ok thanks @Karina and @sam1128 I try to run the Asset Proposal and everytime it doesn't make an asset proposal with my lease I can't figure out what step I missed
I need to connect the asset type with the Asset Account on the lease, but I can't figure out where to do that
k
There could be many things. one to check is one GL account for each account type
n
ok thank you so much. @Karina if you don't mind i just have 2 more questions. 1. Will this Lease record eventually make an Invoice each month based on payments I setup on the Lease Amortization tab? 2. Could I use this Lease record for Rentals as well? Like if I Rent equipment to customers as well as Lease equipment to customers?
k
1. what invoices?
2. that is exactly what it is used for, ACS842/IFRS16
n
Maybe I'm thinking of this backwards but ACS has told us that we can use the FAM module to bill our customers for equipment we rent to them
k
I have a feeling you are renting equipment to your customers? this is not for that
this is only for #2
ACS told you, huh….
n
yeah, they came up with this whole convoluted process to do rentals and leases for our customers
k
no, for that you have to use SO module; if you are renting your fixed assets (I assume you do) there is a completely different process, NOT the lease module of FAM
n
it's so annoying, but sounds like FAM is moreso for us to record equipment WE lease from a Vendor
k
it is not “annoying”, this is what this module is for, that’s the only purpose.
n
I meant it's annoying that ACS has pointed us down this path and its completely the wrong path
k
it would be easier to write a script for loan amortization using ChatGPT, mr @nsAI 🙂.
n
Thanks @Karina I will keep working through some other options for this.
k
a script would be your best option, honestly.
1
I did this for customers (equipment rental side) and it had nothing to do with the lease module….
m
Yes if you need to create just invoice based on the payment , a script would be the best option
n
As I was thinking through doing something custom earlier, I was stumped on what to do with the COGS for an item. For example, we purchase receive an Item which has an Inv Value, then when the item ships it hits COGS...however, the revenue doesn't balance with the COGS Like if the item was $200, but we rent it for $20/month then our Gross Profit will be out of whack becasuse we have $200 in COGS vs. $20 in Revenue
k
true, but you recognize revenue differently/monthly, like a subscription, so there is something else at play
n
Would you suggest using Deferred COGS or something like that?
k
aaaah, of course, you came to ARM 🙂. does not everyone LOL
this is not deferred COGS. so you purchase your equipment, you rent it; you depreciate it (or not depending on the value), you record your income from the rental (which is not divided into principal and interest - why should it?), and you are done. Your euipqment depreciates lowering net asset value, you get your income…. there is no lease here, except on the customer side, and you record it via SO…
and you use light ARM (aka basic) to record your revenue ratably, and that’s that
n
But the Item will have a COGS impact when it is picked and shipped
the Item Fulfillment to shiop the item from the SO hits COGS
k
well, you can tie your SO with the asset tag
and fulfillment - well I suppose you need to set your rev rec rule to be on fulfillment if you need to fulfill
now do you have ARM?
n
no
I don't know why Rev Rec is needed. I don't need to change anyhting with Revenue...it's the COGS that is the problem
The monthly revenue from the Rental is ok to post each month direct from an invoice. Why would I need Rev Rec on the monthly invoice?
k
why is COGs a problem? are you saying you have to recognize the cost over time? why? because your contract is actually annual contract and you are invoicing monthly?
n
I guess the problem is "should we be recording COGS" when we ship the product since it's going to be coming back to us and we technically havent' sold it to the customer yet
k
you record your cost via depreciation, it is your equipment, you own it
when you run out of cost/depreciation your income margin is 100%
n
So after thinking about this for awhile it sounds like my issue is that we purchase these items and put them into our inventory, but then when we rent them we should be taking them "out" of inventory and transferring them to be a Fixed Asset we own, this would eliminate the COGS problem i believe
k
i agree; you will have to think of the process of taking each leased inventory asset into FAM and “depreciating” them ratably over the term of your contract for example. Not knowing details your details this seems to be what you need on the expense side.