Entering Loan entries

Is it the same amount for your repayment each month?  Take a look at Recurring transactions. 

1. Set up the first bill and take it off hold, get it approved, etc. but do NOT release.  Leave it “Balanced”
2. Under Payables > Profiles > Recurring Transactions set up a recurring transaction and select your Balanced AP Bill.  When you save your schedule, the bill will be updated to “Scheduled” and you won’t release it manually.
3. Then under Payables > Processes > Generate Recurring Transactions, use the Schedules button to create a schedule to automatically run the process.

See this help article for more detailed steps:  https://help.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=b13d4266-171b-4150-9bde-dc6fc6027220

Yes it has the same amount for all. So shall I create the unreleased bill for all the total amount or just the amount for one month?
& in case if it doesnt have the same amount then?

Create the bill just for one month, then set up the schedule for the number of months you want it to run,

In case if the amount is varying for all the months for the single vendor?

Hey @meganfriesen37 
What if the amount is varying for all the months for the single vendor?

Hello,

Recurring transactions are for amounts that are the same every month for the same vendor.

If the amount of the bill changes, consider the following entry choices:

1. “Memorize” the transaction as a Template that may be copied to a new transaction (then change the amount each month) in Cash Transactions, Journal Transactions, or AP Bills or AP - Cash Purchases screen.

2. 

    

3. Use the Bank Feed to enter the new transaction during the Matching Process.

Laura

Hello,

Recurring transactions are for amounts that are the same every month for the same vendor.

If the amount of the bill changes, consider the following entry choices:

1. “Memorize” the transaction as a Template that may be copied to a new transaction (then change the amount each month) in Cash Transactions, Journal Transactions, or AP Bills or AP - Cash Purchases screen.

2. 

    

3. Use the Bank Feed to enter the new transaction during the Matching Process.

Laura

Hello @Laura02 ,

Would it be possible if I setup an Import scenario and an automation schedule for the same. So it would be like the csv file would have all the loan entries for the whole year and for each entry an AP bill should be created at the starting of each month depending on the loan entry period in the csv file.

Edited - I think an automation schedule is not the best solution. If you are importing one bill per month, you will need to update the amounts in your Import scenario - CSV file every month, before the automation schedule imports.   

Why not import the group of loan entries for the year at one time with proper posting periods into the future?

Laura

So at the moment we have a numbering seq setup on auto. So if I would import an AP bill for the future periods too how would that work? I have a Bill with 001 for May period and then I have bills for loans for 4 months listed as 002, 003, 004 & 005 for May, June, July & Aug months. And then I would create a new AP bill for the May period with 006. Is it how it would work?