Hi everyone, I’m trying to automate a scenario in ...
# general
v
Hi everyone, I’m trying to automate a scenario in NetSuite where prepaid rent is paid at the beginning of the period, and then expensed monthly over the next few months. I’d like to use memorized transactions or any suitable alternative NetSuite feature to handle this efficiently. Scenario: Rent Period: 1st January to 30th June (6 months) On 1st January, I want to record: Debit: Prepaid Rent (Asset) Credit: Bank Then, for each month from February to June, I want to record: Debit: Rent Expense Credit: Prepaid Rent Essentially, it’s a one-time payment in January, followed by monthly entries for 5 months. When I use the memorized transaction feature, it only repeats the exact GL impact from the original transaction — in this case, the initial Prepaid Rent vs Bank entry. What I really need is for future months to instead debit Rent Expense and credit Prepaid Rent — a different account effect from the original transaction. Is it possible to change the account impact dynamically in a memorized transaction after the first entry? Or should I use two separate memorized transactions — one for the initial payment and another for the monthly rent amortization? Is there a better or more standard approach to handle this scenario?
l
The amortization feature handles this if you have the advanced financial module.
If you don't have that future, you should probably manually create the first amortization journal entry and memorize it (not the source transaction).
c
NetClose by Netgain has an amortization module built in as well that would handle this.