We generally recommend tracking loans with a manual account. Connected loan accounts often don't sync reliably, and most lenders report each payment as a single amount without splitting out principal and interest. That makes it hard for Ambrook to keep the loan balance right.
There are some instances where the connected loan accounts do properly sync. If one of your loans is already connected, review the information below to decide whether to keep the connection or manage the account manually.
Check what's syncing
Go to the Accounts page and click the connected loan account.
Choose View Transactions.
Look at how the payments come in, then find your situation below.
What you see | Go to Section |
Each payment is one amount (principal and interest together) | |
Principal and interest come in as separate transactions | |
A line of credit with purchases, checks or card charges, not just payments | |
Little or nothing has synced | Payments sync as one amount (treat it the same way) |
Payments sync as one amount
Keeping this account connected doesn't help, because Ambrook can't tell how much of each payment went to principal. Switch to tracking the loan manually.
If you haven't tagged anything to this loan yet
Set up a manual loan account. See Adding a Loan Account.
Hide the connected account. See Adding, Editing and Deleting Balance Sheet Accounts
If you've already tagged payments to this loan
Stop the account from syncing, instead of hiding it. That way you keep the account and the tagging you've already done.
Go to Settings → Connections, click the three dots next to the loan account, choose Remove, then Stop Sync.
Clean up what already synced. Look for payments that show up twice on the loan account: once from the connection, and once from a payment you tagged from your bank account. Exclude the copy that synced from the bank connection.
From now on, treat it like a manual account. Itemize each loan payment from your bank account, tag the principal as a Liability Adjustment to the loan, and tag the interest to your interest expense category. See Tagging Loan Payments or Tagging Mortgage Payments.
Check that the balance matches your lender's statement. If it doesn't, see Troubleshooting Loan Balances.
Stop Sync or Hide? Stop Sync keeps the account and its tagged transactions, but no new transactions come in. Hiding the account removes the account entirely, including any tagging you've already done. If you've tagged anything to the loan that you want to keep, choose Stop Sync.
Principal and interest sync separately
Keeping the account connected can make sense here. For each payment:
Principal: On the payment from your bank account, use the Account Transfer tag and match it to the principal transaction in the loan account. Don't tag it as a Liability Adjustment, or the principal is counted twice.
Interest in the loan account: Exclude the interest transaction that synced into the loan account.
Interest from your bank account: Tag the interest withdrawal to your interest expense category, such as Non-Mortgage Interest. If principal and interest left your bank as one withdrawal, itemize it first and tag the interest line.
If your loan payments include escrow for taxes or insurance, see Tagging Mortgage Payments for how to tag that part.
If the account stops syncing reliably, follow the process in section Payments sync as one amount above.
A line of credit you spend from
Some lines of credit work like a checking account: you write checks, use a card, or have your lender pay vendors straight from the line. These don't often sync reliably either, but if yours does, the line of credit account will have purchases on it as well as payments and draws. Treat it a little differently from a loan:
Purchases, checks and card charges: Tag each one to its expense or asset category, like any other transaction. Because it happened on a liability account, it raises what you owe. Don't exclude these.
Interest added to the line: If your lender adds interest to the line's balance and it syncs as its own transaction, tag it to your interest expense category. Don't exclude it, because it's part of what you owe.
Payments from your bank account: Tag the bank-side payment as an Account Transfer and match it to the payment on the line of credit account. Tag it once, not on both accounts.
Draws into your bank account: Tag the deposit as an Account Transfer and match it to the draw on the line of credit account.
If transactions start going missing, stop sync (see above) and add the missing ones yourself from your lender statement manually from your Ledger or via CSV import. For more, see Managing a Line of Credit.
Exclude or tag the interest? It depends on how the interest is paid. If you pay interest from your bank account, exclude the interest transaction on the loan account and tag the bank withdrawal instead. If your lender adds the interest to the balance you owe, tag it on the loan account.
If you have both a connected and a manual account for the same loan
This happens when a loan comes in through your bank connection and you also add it by hand. Payments end up split between the two accounts, or the loan shows up twice on your balance sheet and your total liabilities look too high.
How to tell: On the Accounts page, look for two accounts with similar names or balances for the same loan. Open each one and choose View Transactions to see which payments are tagged to it.
Keep one account. Keep the manual one unless principal and interest sync separately, or it's a line of credit you spend from that syncs reliably.
Decide which account to keep.
Check that the Starting Date and Starting Balance on the account you're keeping are right. See "Which Starting Date and Starting Balance should I use?" in Adding a Loan Account.
On the account you're not keeping, open View Transactions and retag its payments to the account you're keeping. If a payment is matched as a transfer, remove that tag first. See Unlinking Transfer Tags.
Remove the account you're not keeping. Once any necessary transactions have been re-tagged, go to Accounts, click the duplicate account you're not keeping, scroll to the bottom, and click Remove Account. Choose Hide Account if it's a connected account, or Delete Account if it's a manual account
Not sure which one to keep? Contact our support team through the in-app chat or at support@ambrook.com.
