Owner loan payment showing in Sales by Customer Report

Hi, @sharon79. 

I'm here  to lend a hand on how you can handle  your loan deposit. 

I was able to replicate  here on my end and I'm not seeing the deposit on the Sales by a customer report. 

There is a possibility that the account that was chosen when making the deposit isn't the right account that you set up. Please ensure to select the liability account. 

On the other hand, you can create a journal entry to record the loan, not only to record what the company owes you but also to record expenses for year-end reporting as well as tax purposes.

Here's how:

1. Select + New.
2. Under Other, select Journal Entry.
3. Enter the amount of the loan and log the proper amounts to the appropriate expense accounts.
4. Select Save and close.

Also, you can check this article to learn more about how to Set up a loan in QuickBooks Online.

Message us back if you need more help with QuickBooks or click on the Help menu in QuickBooks Online and click Contact Us. Have a great day!

Hi Abegail,

It has definitely been allocated to a liability account on the balance sheet but is still showing in the Sales by Customer report.  

You said you weren't able to replicate the problem.  If you were able to allocate a deposit to a liability account that did not show in the Sales by Customer report, are you able to advise how you entered the deposit?

Hello, @sharon79. 

I can provide additional information about recording loan payments.

The Sales by Customer report shows your sales, grouped by customer. It also includes the date, type, amount, and total.

Try to review the transactions you've recorded for this loan. To record your loan in QuickBooks Online (QBO), you must set a liability account to record what you owe from the Chart of Accounts. Once you're done, create a journal entry if you put all the loan money right into the bank.

You can record the repayment by creating a cheque. Consider using a liability account for the loan and expense account for the interest. 

Check out this article for more information about recording a loan in QBO: Set up a loan in QuickBooks Online. This will guide you create, set up a liability account, and recording the loan payments. 

See this reference for detailed guidance in creating and recording cheques in QuickBooks Online.

Here's an article that can guide you further in running, customizing, and sharing your reports in QBO: Customise reports in QuickBooks Online.

I'm always here if you need more help about recording your loan and reports in QBO. Keep safe and have a wonderful day!

I have the same problem. I have 3 separate loan amounts. Two of them are not included in sales, but one of them is. As far as I can see there no difference between the three items, so I don't understand why one is treated differently.

Hello there, Paul.

I understand the urgency to get this resolved as soon as possible. QuickBooks Online (QBO) can occasionally stop working properly since locally stored internet cache files can cause the product to behave unexpectedly due to overloaded site data. I recommend opening a different browser or a private window to isolate possible issues. This can help us remove any cache-related matters that may have contributed to the problems. 

Here's how to activate incognito mode in some of the most common online browsers:
 

• Google Chrome: Ctrl+ Shift + N
• Mozilla Firefox: Ctrl + Shift + P
• Microsoft Edge: Ctrl + Shift + P
• Safari: Command + Option + P

If your recorded loan payment finally shows in your liability account, it's safe to say that the browser has caused it. This can be fixed by clearing your cache and cookies.

Moreover, I'll also share this link where you can search for articles that can serve as your reference to guide you in managing your QBO account: QuickBooks Online Help Articles.

Feel free to leave a reply if you have additional QuickBooks-related queries. The Community team always has your back. Have a good one.

OK, so I tried in incognito and no difference.

I was wrong when I said that the loan amounts are treated differently - they're all included in sales. I was just looking at the amounts for this month before which is why I thought only one was being treated this way.

There must be a way of excluding these from sales figures...

Hi, @PaulRudin.

Allow me to step in and share additional information about loan amounts shown in the Sales by Customer Report.

In QBO, the loans will not show in the Sales by Customer Report if you choose the correct account upon entering the loan. You can review the transaction to ensure you've chosen the liability account, not the income account. 

If you assign a loan to an income account, it'll show up on the sales by customer report. You'll want to edit the transaction or delete/recreate the transaction to start over.

Let me also share these articles in case you need more guidance and references when running reports in QBO:

• Common Custom Reports in QuickBooks Online
• Memorise Reports in QuickBooks Online

Feel free to reply and keep me posted if that helped with your loan reports in QBO. You can also post more questions if you need anything else. 

I'm not sure I follow. You say "it will usually show in the Sales by Customer Report..." . But it's *not* sales: it's a loan - nothing has been sold...

I appreciate you returning to this thread, PaulRudin. I'm here to provide further clarification.

It is unusual for the loan to show up in the sales by customer report. Possibly, we accidentally used an incorrect account when recording the loan instead of using a liability account. That could be the reason they are showing in the Sales by Customer report.

We can review the transaction to ensure the correct category has been set up. You can click the amount from the report to review the details of the transaction. If we need to correct that one, you can edit or delete and recreate the deposit to start over fresh, as advised by my peer above. 
 

I'd also recommend checking this article for the complete steps of recording the owner loan payment in QuickBooks: How to record a company loan from a company officer or owner. This article will guide you in thoroughly tracking the loan amounts. Ensure the data generate accurately in the report.

If you recorded it correctly or tracked them accurately but still shows on the Sales report. Please give us a short call. We'd like to check your account in detail and investigate this further. Go to the Help icon and select Contact us.

Still, I'd recommend visiting the articles shared by my peer above. It contains information about personalising and handling reports according to your need.

• Customise reports
• Memorise reports

Please let me know if you have further questions about tracking loans and QuickBooks reports. I'll be here to help you. Take care and stay safe.

Just to follow up on this, I have the exact same problem. My director's loan account deposits are showing as Sales on the 'Sales by Customer detail' report. 

I have tried the various suggestions above and none work. Here are the details

- The transactions are recorded as deposits into my Director's Loan account (liability account).

- The transactions are recorded as deposits in my main Bank Account, from the Director's loan account.

- My balance sheet correctly shows the liability against my Director's loan account.

- The director's loan liability account is type  'Current Liabilities / Short Term Loans from Related Parties'.

Hello pariah66,

Since you used the correct account, this time, let's reach out to our phone experts so we can investigate the issue.

Here's how:

1. Click the ? Help icon.
2. On the Assistant tab, enter Talk to a human.
3. You can use My director's loan account deposits are showing as Sales on the Sales by Customer detail report as your keywords.
4. Select how you'll want to contact us.

Moreover, I'll also share this link where you can search for articles that can serve as your reference to guide you in managing your QBO account: QuickBooks Online Help Articles.

I'm always around whenever you have concerns.

I had similar and checked the VAT allocated. I had No VAT (Sales) and changed to Exempt (Purchase) and it no longer showed up in sales report.

Awesome, thanks for letting me know