Loan Manager

Track every business loan from origination to payoff. BizBooks Pro calculates your amortization schedule automatically, records each payment with the correct principal and interest split, and keeps your balance sheet liability up to date.

Overview

Business loans create obligations that span months or years. Tracking them properly means maintaining an accurate liability balance on the balance sheet, recording interest expense on the income statement each period, and reconciling your payments against what the lender expects. Doing that manually — or in a spreadsheet disconnected from your books — leads to errors and mismatches that only surface at year-end.

The BizBooks Pro Loan Manager handles all of this inside your accounting data. Enter your loan terms once, and the software builds a complete payment schedule using the standard amortization formula. Each time you record a payment, the principal and interest amounts are calculated automatically and posted to your general ledger without any manual intervention.

The loan dashboard gives you a real-time view of every active loan: current outstanding balance, total interest paid to date, number of payments remaining, and projected payoff date. Your balance sheet reflects the correct liability at all times.

Creating a New Loan

To add a loan to BizBooks Pro, navigate to Banking → Loan Manager and click Add New Loan. Fill in the loan details on the form that appears.

Required Fields

• Loan Name — A descriptive label for this loan (e.g., "SBA Equipment Loan" or "Ford F-250 Vehicle Loan")
• Lender Name — The name of the bank, credit union, or financing institution
• Loan Type — Select from the seven supported categories (see Supported Loan Types)
• Original Principal — The full loan amount at origination
• Annual Interest Rate — The stated annual rate as a percentage (e.g., 6.5 for 6.5%)
• Origination Date — The date the loan was funded or the first payment period begins
• Loan Term — Total repayment period in months
• Payment Frequency — Monthly, quarterly, semi-annual, or annual

Optional Fields

• Loan Account Number — For reference and reconciliation with lender statements
• Opening Balance Override — If you are entering a loan that is already partially paid down, enter the current outstanding principal here instead of the original amount
• First Payment Date — Defaults to one payment period after the origination date; override if your loan has a different first payment date
• Notes — Internal notes about the loan (collateral, contact info, etc.)

Click Save Loan. BizBooks Pro immediately generates the full amortization schedule and adds the loan to your dashboard.

Amortization Schedule

Once a loan is created, click its name in the loan list to open the detail view. The Amortization Schedule tab shows the complete payment-by-payment breakdown from the first installment to the final payoff.

Reading the Schedule

Each row in the schedule represents one payment period and shows:

• Payment # — Sequential payment number
• Due Date — The date this installment is due
• Payment Amount — Total payment (principal + interest)
• Principal — Portion of this payment that reduces the outstanding balance
• Interest — Portion of this payment that is interest expense
• Remaining Balance — Outstanding principal after this payment is applied
• Status — Paid, Due, or Upcoming

Early payments in an amortizing loan will show a higher interest component and a lower principal component. As the balance decreases over time, each successive payment contains more principal and less interest. This is expected behavior and matches how standard amortizing loans work.

Making Payments

When a scheduled payment is due, BizBooks Pro highlights it on the loan dashboard. To record the payment:

1. Open the loan from Banking → Loan Manager.
2. Click the Record Payment button on the dashboard or click the Pay link next to the specific installment in the amortization schedule.
3. Confirm the payment date (defaults to today) and the bank account the payment is drawn from.
4. Review the pre-filled principal and interest amounts. These are calculated automatically from the amortization schedule.
5. Click Record Payment.

BizBooks Pro creates a journal entry with the following debits and credits:

The loan's outstanding balance on the dashboard decreases by the principal component immediately after the payment is recorded. The payment row in the amortization schedule is marked as Paid with the recorded date.

Recording Additional Principal Payments

If you make a payment above and beyond your scheduled installment — a lump-sum principal reduction, for example — record it separately from the regular installment payment.

1. Open the loan detail view.
2. Click Additional Principal Payment.
3. Enter the date, the extra principal amount, and the bank account to draw from.
4. Click Save.

BizBooks Pro deducts the extra amount from the outstanding balance and recalculates the remaining amortization schedule. Future payments will show reduced interest amounts because the balance is now lower. The projected payoff date updates automatically to reflect the accelerated paydown.

GL Account Setup

Each loan in BizBooks Pro maps to three accounts in your chart of accounts:

BizBooks Pro will suggest accounts from your existing chart of accounts when you create a loan. You can accept the defaults or choose different accounts from the dropdown. If the account you need doesn't exist yet, create it in your Chart of Accounts first, then return to the loan setup.

Current vs. Long-Term Liability Split

For balance sheet presentation, the portion of a loan's principal that is due within the next 12 months should appear as a Current Liability, while the remainder should appear as Long-Term Liability. BizBooks Pro can handle this split automatically if you set up two separate liability accounts and configure the loan to allocate accordingly. Consult your accountant for the correct presentation standard for your business.

Supported Loan Types

BizBooks Pro supports seven loan categories. Select the type that most closely matches your loan when creating it — this label is used for filtering and reporting but does not change the amortization calculation.

Frequently Asked Questions

Can I enter a loan that is already partially paid down?

Yes. When creating the loan, enter the original terms but set the Opening Balance Override to the current outstanding principal. BizBooks Pro will calculate the remaining schedule from that balance. Set the origination date to match the first payment you plan to record in the software, not the original loan date, so your payment numbers align correctly.

What if my loan has a variable interest rate?

BizBooks Pro currently calculates schedules using a fixed rate. If your loan has a variable rate, enter the current rate when setting up the loan. When the rate changes, you can edit the loan and update the interest rate — BizBooks Pro will recalculate the remaining schedule from that point forward using the new rate.

Will the loan show up on my balance sheet automatically?

Yes. As soon as you create a loan and assign it to a liability account, that account's balance reflects the outstanding principal. As you record payments, the balance decreases automatically. Your balance sheet will always show the current amount owed without any manual adjustment.

Can I track multiple loans at the same time?

Yes. BizBooks Pro has no limit on the number of active loans. Each loan has its own amortization schedule and GL account mapping. The loan dashboard lists all active loans so you can see your total debt picture at a glance.

What happens when a loan is fully paid off?

When the final payment is recorded and the outstanding balance reaches zero, BizBooks Pro marks the loan as Closed. It disappears from the active dashboard but remains in your records for historical reporting. The associated liability account will also show a zero balance, which is reflected on your balance sheet.