Skip to main content

Getting Started with Loan Amortization

This guide walks you through setting up your first loan in Double so you can generate an amortization schedule, post journal entries automatically to QuickBooks Online, and keep your loan balances audit-ready.

🔒 Private beta: Loan Amortization is currently in private beta. If you'd like access, please contact our support team. Only available for Scale tiers (including Scale trials) connected to QBO.


Understanding the Loan Amortization feature

The Loan Amortization feature lets you manage loan schedules directly inside your close. Instead of maintaining amortization spreadsheets and manually booking the principal/interest split each month, Double generates the full schedule for you and posts the journal entries to QuickBooks Online with a click.

With Loan Amortization you can:

  • Build an amortization schedule from your loan's terms

  • Post payment journal entries directly to QuickBooks Online

  • See which payments have already been posted

  • Update the schedule when payment amounts or interest amounts change


Adding a loan

You can add a new loan directly from the Close page.

When adding a loan, enter the following details:

  1. Lender – select the vendor for the loan

  2. Loan origination date

  3. First payment date

  4. Term (in months)

  5. Payment amount

  6. Loan amount

  7. Annual interest rate

Then connect the related accounts so Double knows where to post:

  • Interest expense account

  • Loan payable account

  • Cash/bank account

Once saved (Create schedule), Double automatically generates the full amortization schedule, showing the principal and interest breakdown for every payment over the life of the loan.


Posting payments to QuickBooks Online

When you're ready to book a payment, click Post Payments (+).

  • Double posts the journal entries directly to QuickBooks Online.

  • Posted payments are clearly marked in the schedule, so you can always see what's already in the ledger versus what's upcoming.

You can review the journal entries in Double or click into QuickBooks for full details.


Updating a loan schedule

Made an extra payment? Want to true-up to the bank statement? Double keeps the schedule in sync.

  • Changing a future payment amount adjusts the principal portion of that payment, and the change ripples through the rest of the schedule.

  • Changing the interest on a payment adjusts the interest/principal allocation without changing the payment amount.

💡 Note: Edits only affect future, non-posted payments. Payments already posted to QuickBooks are not changed.


Deleting a loan

To remove a loan, Delete the task.

⚠️ Deleting a loan permanently removes the amortization schedule and all future non-posted payments. Journal entries that have already been posted will remain in your ledger.

Did this answer your question?