Easy accounting for loans

SystemSystem Posts: 371 admin

imageEasy accounting for loans

Here's how to use transactions to enter a loan into Wave and record payments to it.

Accounting for receiving your loan:

Under the Accounting tab in the left-hand navigation menu, select Chart of ...

Read the full story here


edited April 11, 2020 in Help Center Discussion

Comments

  • BluJBluJ Member Posts: 5

    This does not seem to work when doing a transfer from a Checking account to a Loan account. It does not recognize that to total outgoing is equal to the split.

    edited April 11, 2020
  • BarsinBarsin Administrator Posts: 1,811 admin

    Hey there @BluJ

    Would you mind kindly elaborating on what the real-world use case scenario would be here? Any additional info would be super helpful in trying to help you account for a loan. Thanks in advance!

  • GinjaGinja Member Posts: 5

    How do I account for the loan if it was issued a couple years before I began using Wave?

    Below are the details:
    I am new to Wave, so setting everything up now. I am entering all transactions from 2019 onward, so Jan. 1, 2019 is where my accounting in Wave will begin. I received a loan in 2017 for 25,000€ for farm machinery and have been making monthly payments. I paid the loan off early, in 2020. There was a fee of 300€ charged for paying the loan off early.
    1) How do I set this loan up?
    2) How do I register the monthly payments?
    3) How do I register the interest?
    4) How do I register the 300€ early payment fee?

    edited May 15, 2020
  • BarsinBarsin Administrator Posts: 1,811 admin

    Hey there @Ginja

    The same principles should come into play except for your dates which will need to reflect when the loan was received.

    Have you entered in your transactions as far back as 2017? If you don't wish to do this you can just enter the balance of the loan from when you created your Wave account in in 2019. Click Add income to create a transaction for the remaining balance of that loan. For the Account you’ll add the checking account the loan proceeds were deposited into, and for the Category you'll select Transfer from Bank, Credit Card, or Loan, select the new loan account you just added, and click Save.

    The monthly payments with interest would be made by splitting the payment transactions as such:

  • Simon_Pierre1985Simon_Pierre1985 Member Posts: 1

    I have a vehicle loan of $76 000 which includes the interest. The repayment is made in 60 equal payments which include interest. If I split my repayments in transfer to loan and interest expense... at the end of the 60 months my loan will not be paid off. Do I have to exclude the Interest when I add the Loan account?

  • ConnorMConnorM Member, Administrator Posts: 1,229 admin

    Hey @Simon_Pierre1985! While we are able to tell you how to do something in Wave, we aren't able to necessarily tell you the right way of doing it when it comes to the principles of accounting.

    I would highly recommend reaching out to a registered CPA to ensure that you don't get incorrect advice on how to do your accounting here!

  • NKIMNKIM Member Posts: 1

    When I try to split the amount of principle and interest from both the Created Transfer Log (on Checking account) and from Loan Account Payment Log side, I keep getting an Error Message "Transfer account should have an equal amount of debit and credit in the transaction currency." The transactions are downloaded from a linked account. How can we fix this?
    Thank you,
    NK

  • CalliePCallieP Administrator Posts: 439 admin

    Hi @NKIM , thanks for reaching out. Am I right in thinking that you mean you have created an expense from the Checking account, categorized it as a transfer to the Loan account, and are trying to categorize the transfer? If so, this isn't possible, as the category is the transfer. So, you have two options.

    1. The simpler way is to use income/expense transactions to account for your loan, which is what you seem to be working toward. When you pay off a loan, the Account field is still the Checking account, since that's where the payment is coming from. You then split this expense, with one category as the Loan account for repaying the principal, and the other category as the interest expense. If you follow the directions to set up the initial loan deposit in Wave, then this categorization would account as a repayment of the Loan! https://support.waveapps.com/hc/en-us/articles/360039281032-How-to-account-for-loans-with-income-expense-transactions
    2. Alternatively, you can use a journal transaction to account for your loan repayment, which you can learn about here: https://support.waveapps.com/hc/en-us/articles/360000041883-How-to-account-for-a-loan-with-journal-transactions
  • Shaz2020Shaz2020 Member Posts: 1

    I have tried given steps but i still get error saving message. I dont know what to do anymore.

  • JordanDJordanD Administrator, Moderator Posts: 515 admin

    Hey @Shaz2020 and welcome to Wave's Community Forum! Sorry to hear that you are unable to save something within Wave. Are you able to clarify what it is that you are attempting to do when you see this message? Additionally, can you provide a screenshot of the actual error code? This would be helpful for us to know when we look to help you troubleshoot this. Thanks in advance! :)

  • GinjaGinja Member Posts: 5

    @BarsinA If I do as you suggested: "Click Add income to create a transaction for the remaining balance of that loan. For the Account you’ll add the checking account the loan proceeds were deposited into, and for the Category you'll select Transfer from Bank, Credit Card, or Loan, select the new loan account you just added."...wouldn't this create a deposit into the bank account that the loan proceeds were deposited into? If so, this would cause an issue during reconciliation, bc the actual loan deposit was made in earlier years, prior to me using Wave, and I am not going to add transactions for those earlier years into the system (just entering starting balances for each account as of 2019). Could you clarify?

  • CalliePCallieP Administrator Posts: 439 admin

    Hi @Ginja , thanks for getting back! To confirm: yes, what @BarsinA described is correct. If you need to record the loan in Wave, you need to also record the loan deposit so that the system has a record of where the funds are coming from. You can back-date the transaction to when it occurred/the year it occurred if that helps you. You can still do this while only entering starting balances for prior years.

  • NoNameNoName Member Posts: 1

    Just a note: For "Personal" accounts, Interest Expense does not exist as a category by default. You'll need to create it yourself.

Sign In or Register to comment.