Sales receipt import error

Hello Amy, If you edit the number to be the next one in the sequence does it allow you to upload? If so could you try that and then go to the sales receipt and edit the number back to 9664 manually and save it. If you get the same error let us know:smiling_face_with_smiling_eyes:

Hi,

I'm having sort of the same problem:

The Deposit Account field is invalid on the following sales receipts. Go back to your CSV and add the info before trying again.

I've tried different sales receipts numbers: the next number in line, a number much higher, I've added text even 'dontknow' but I can't seem to get passed this step. Nothing I add is accepted...

Any ideas?

Thanks, Marieke

Hello MariekePellerin, Thanks for posting on this thread, could you try clearing your cache and cookies this link will help you, to all time, close the browser down, reload it and log into your account does the same thing still happen or not for you? 

Hi, I am having the same problem - I imported some sales receipts earlier, but now it keeps rejecting the sales receipts numbers - I have tried higher numbers and cleared the cache and cookies and reloaded safari.

Any ideas/suggestions, please?

Thanks,

Tony

I can share with you some ways to import sales receipts successfully in QuickBooks, @Tony Roberts.

We can turn off the Custom transaction numbers in your account. This way, you can import the transactions without rejecting the sales receipts numbers.  

Let me show you how:

1. Sign in to your account.
2. Go to the Gear icon.
3. Select Account and Settings or Company Settings if you're using the Accountant module.
4. Choose Sales on the left panel.
5. Click the edit icon for Sales form content.
6. Choose the Custom transaction numbers checkbox, and then click Save.

Then, import  again your sales receipts in QuickBooks.

For more insights on how to manage transaction quantities in the sales receipt, please check out this article: Change the number on invoices or other transactions.

If the issue persists, we can perform some troubleshooting steps to fix this. There are times that the browser is full of frequently accessed page resources, which causes some errors or unusual responses. Let's start accessing your account using a different or a private browser. You can use either of these shortcut keys:

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

Once you have successfully import sales receipts, go back to your regular browser and clear its cache. This is done to speed up the process next time you do a transaction in QuickBooks. Also, an alternative way is to use other compatible browsers.

Additionally, I've attached an article to guide you personalise and add specific info to your sales forms: Customise invoices, estimates, and sales receipts.

Feel free to add a reply below if you encounter issues importing sales receipts in QuickBooks. I'll get back to you as soon as I can. Stay safe and take care.

Hi Rubielyn,

I had the Custom Transaction numbers on already. Also cleared the cache, but still no succcess. Also tried with Chrome instead of Safari.

See screenshot I get.

Thanks,

Tony

I have also tried using much bigger numbers 5010 instead of 2010 for example, but no success.

There were some sales receipts in earlier, which I deleted as they had been put in incorrectly (on date of receipt of funds not date of sale, net of credit card charges, etc..) - could that be having an impact?

Also, is there anywhere I can see all Sales Receipts in QBO, other than running a P&L report?

Thanks again,

Tony

Hello, Tony. 

Thanks for getting back to us after doing the suggestions mentioned by my colleague. I'll elaborate some more details about what causes the error messages when importing your sales receipts. 

Yes, the sales receipts on your file with incorrect formatting can cause issues when you import them to QuickBooks. 

Before importing them, check your file and see if there are any zeroes for quantity, incorrect date format, or customer names. 

Also, there are other factors that can cause the error messages. Open this article and expand the Things to know before you get started section for more details: How to import sales receipts.

Regarding the sales receipt report, you can use the Sales by Customer Detail (or Summary) or the Transaction List by Customer report. You'll want to customise it to show only the sales receipt you have imported or recorded. Here's how: 

1. Go to the Reports menu. 
2. In the search box, type Sales by Customer Detail or Transaction List by Customer.
3. On the report's overview, click the Customise button. 
4. Expand the Filter section, then check Transaction Type.
5. Set it to Sales Receipt.
6. Click Run report. 

You can memorise the report if you need to pull it up in the future. That way, you won't have to customise it again. 

Do you also need help categorising or matching your bank transactions with your sales receipts? Check out this article for a guide: Categorise and match online bank transactions in QuickBooks Online.

I'm here to back you up again if you have more questions about importing your data to QuickBooks Online. Just leave the details here and I'll get back to you as soon as possible. 

Hi James,

thanks for getting back so quickly.

I have been through the steps and can't see anything obviously wrong with the file - it worked initially when I did the first few days (one day at a time to ensure it was working correctly), but then I started to get the error messages about the Sales Receipt Numbers.

I tried to attach the file for one day for you to look at, but won't allow CSV files to upload...

I will look at the reports you suggested - thanks!

Tony

Hi James,

I am also wondering if it would be better to start a new clean installation? the person who set it up did so with VAT enabled, which it should not be for us, and also entered many transactions incorrectly (sales receipts, expenses using journals or bills, etc...). Whilst I am correcting the mistakes, it could be part of the problem; also, it is not possible to turn off the VAT, just set it all to "No VAT", but that is annoying, to be honest...

Can we do a new, clean install?

Thanks,

Tony

Thanks for returning to this conversation and for sharing your results, @Tony Roberts. I'm here to further help and guide you to get your sales receipts imported in QuickBooks Online (QBO).

Before proceeding to the troubleshooting steps, may I know if you're referring to deleting your QBO account and start over with a new one? If so, you have the option to purge your company file to delete all the data. This is only possible if your account is less than 90 days old and once the process is done, you can't restore the information. Here's how to do it:

1. Sign in to your QBO Company.
2. Next, edit the URL and include /purgecompany
   Example: From https://sg.qbo.intuit.com/app/homepage change it to https://sg.qbo.intuit.com/app/purgecompany
3. Once done, you'll be routed to the screen that shows a summary of the items to delete.
4. Enter YES to delete the data, then click OK.

However, if your QBO company is more than 90 days old, you can only cancel it and start a new subscription. Once cancelled, you'll have read-only access to your data within a year. When that ends, the system will automatically delete your company. 

For more details about this, please see this article: Delete your data and start over in QuickBooks Online. It also includes the link you can use to start a new account. 

Once everything is fine, you can now import your sales receipts again. 

Personalising your sales receipt forms to widen your business relationship with your customer is also a breeze in QBO. To get this done, you can utilize the Custom Form Styles feature within the program. 

If you have any further questions about importing your sales receipt, I'm here to help. Simply leave a reply below, and I'll respond as soon as possible.

Divina,

thanks for the info - I will keep trying for a while to get the current installation in shape.

Would you have any more ideas about how to fix my problems with the sales receipts download not working (rejecting the Sales Receipt Numbers)?

Hi James,

I'm still not able to download the sales receipts - any more thoughts? Anyone I can call?

Thanks,

Tony

Thank you for letting us know the troubleshooting steps you've tried, @Tony Roberts.

Since you're still unable to download or import a list of your sales receipts even after following the suggestions shared by my colleague, I'd recommend contacting our Customer Care Support. Our specialist online has the tool to determine why you receive such an error message. I'll show you how.

1. Go to Help.
2. Choose Search.
3. Select Contact Us.
4. Enter a few words describing the issue while importing your sales receipts or the exact error code if there is.
5. Click Continue.
6. Pick a channel where you wanted to connect with our dedicated team.

I'm adding this article with the step-by-step guide about bank transactions and reconciling bank accounts: Banking in QuickBooks Online.

Let me know how it goes in the comments below or if you've got other questions with sales receipts. I'll be here to lend a helping hand. Stay safe!

EDIT- Just to add the customer did contact us and the issue was resolved  it was caused by, on the file they used repeating the customer and Deposit Account on each line, but only needed on first line. We just thought we'd add the resolution in case it was helpful to future viewers of the thread

I'm having the same issue; Deposit Account is invalid, but the import selects the *SalesReceiptNo column. I tried clearing the cache, and we have tried different browsers, but it still has the same issue.

We have used the sample provided.

Hi Isaah, thanks for joining this thread - does the deposit account already exist in your chart of account in QB, and does the name match exactly the name entered on the CSV file? 

We have been trying to use 'Undeposited Funds' under Accounting > Chart of Accounts, as advised.

I just tried to import the data it has worked

Hi Isaah,  that is great to hear your all sorted now. Have a nice afternoon and weekend