← Help

Loans and debts: set up a loan and let its payments split themselves

Set up the debt with its rate and term, then split each bank payment into interest and principal.

This is for money the business owes: a car or truck loan, an SBA loan, equipment, a mortgage, a line of credit. RunGrid does not lend anything; this is bookkeeping.

Where it is

Accounting → Loans and debts. The page opens with the total you owe (loans plus credit cards), what the loans cost you per month, and how much you have paid so far in principal and in interest. Each loan shows its payment, what is left, the principal and interest paid, and the next payment.

Adding a loan

Press Add a loan. The first question is where the money went:

·Into a bank account. The lender deposited it. Your bank goes up and the debt appears.
·It bought something. A car financed at the dealer never touches your bank. Choose the asset or let RunGrid create one (Vehicles for a car loan, Machinery & Equipment for equipment, Buildings for a mortgage). If you paid a down payment from the bank, file that bank line to the same asset.
·I already had it. A loan from before RunGrid. Type what you owe today, the months left, the next payment date and the payment. The balance comes in against Opening Balance Equity, like any opening balance. If that balance is already in your books, tick This balance is already in my books and choose its account; nothing new is posted.

Then the rate as a percentage (7.5 means 7.5% a year), the term, how often you pay and, if the lender charges a different amount, the payment. Before saving you see the payment, the total interest, the payoff date and the whole amortization table.

A liability account is created for the loan: long term when the term is over twelve months, current when it is twelve or under, the standard rule.

Payments from the bank split themselves

When the payment shows up in Banking, RunGrid recognises it by the amount, the lender's name or the account it is headed for, and shows Loan payment with the interest and the principal. Press Apply.

Filing the line to the loan's own account, by hand or with a bank rule, does the same: the interest is this period's interest on what the books say you owe today, the rest is principal. One entry: the principal comes off the debt, the interest goes to Interest Expense, and the payment is recorded against the loan.

If the lender's statement says something different, press Change the split and type their figures. Their letter wins.

Write the lender's name the way it appears on your bank statement; that is how the payment is recognised.

Credit cards

The cards connected in Banking appear here too, with what the bank says you owe and what your books say. A credit card account you keep by hand appears as well. The two figures differ until every card purchase is categorized.

Tied to the balance sheet

Total liabilities at the top is read from the same ledger as the Balance Sheet, on the same day, so it is the balance sheet's Total Liabilities to the cent: loans, plus cards, plus everything else. The rest is listed under Other liabilities on the balance sheet: bills to pay, sales tax, payroll, a note brought over from your old books. A debt there that is not set up as a loan has Set up as a loan, which brings its balance in as a loan you already had, without posting it twice.

Why the split matters

Putting the whole payment into one account is the most common mistake in small-business books. As an expense it overstates your costs by the principal, and the balance sheet still shows the original debt years later. As a debt repayment it hides the interest, which is the part you can deduct.

Paid off

When the balance reaches zero the loan is marked paid off. Nothing is deleted; the history stays.

¿Todavía lo estás pensando?

Cuéntanos a qué te dedicas y te decimos con honestidad si esto te sirve. Lo lee una persona, y responde.

Contacto →
info@tmadvisorsgroup.com
Habla con nosotros
Loans and debts: set up a loan and let its payments split themselves | RunGrid