Skip to main content
M
MarkH08
December 9, 2023
Question

Sale Receipt Import Error

  • December 9, 2023
  • 1 reply
  • 0 views

I am currently trying to import 1 months worth of sales receipts from my old website.

 

Everything runs fine, the CSV is formatted as instructed however I receive an error on the "deposit account" column. It states it is not recognised however the column the error shows is actually the "sale receipt number". But as you can see from my screenshot, my import settings are correct and you can see from this attempt I tried putting the "deposit account" as the first column as before it picked up a different column.

 

I have tried using all the suggested actions of a different browser, private mode, reset cache etc.

 

Can anyone help me solve this, I have a years worth to import still 🤓

 

 

1 reply

R
RoseJillB
December 9, 2023

I know a way to fix and rectify the error you’ve encountered when importing sales receipts in QuickBooks Online (QBO), @MarkH08.

 

Before we start, let me acknowledge the effort you exerted in performing the possible troubleshooting, as well as by including a snapshot on your post to get a visual reference of the error.

 

Based on the image you added, I can see that there's an improper order of the data. Although the application shows the Deposit Account in the first column when mapping them, please arrange them based on the following:

 

  • *Sales Receipt No
  • Customer
  • *Sales Receipt Date
  • *Deposit Account
  • Location
  • Memo
  • Item (Product/Service)
  • Item Description              
  • Item Quantity
  • Item Rate
  • *Item Amount
  • *Item Tax Code
  • Item Tax Amount
  • Currency
  • Service Date

 

I’ll also add this sample image as your visual guidance on how your CSV file would look like:

 

Once re-arranged, please re-import your file into the application. This should rectify your concerns about importing your receipts, @MarkH08. If you need additional guidelines, I’ll leave you with this resource for reference: How to import sales receipts.

 

To check if these data are well-imported, you can run various report to see if everything are in. Also, to give you a snapshot of your business, and tell you about different aspects of your business.

 

Beep me up if there’s anything else you need when importing data. Other than that, I can also help you with any of your QuickBooks-related tasks. You can tap the Reply button to post them here. Have a good one!

M
MarkH08Author
December 10, 2023

Hi Rosie,

 

Thank you for your reply. The original CSV was in the format you say to import as with the deposit account 4th in the columns. I used the exact example csv you posted, however the error is still the same and this was the only reason I tried moving the despite account column to try. 

 

The error still shows the error like shown the attached image. The deposit error shows my sales receipt numbers which are not in that column. (this is in the recommended format as you added to my previous reply.

 

I have tried making sure the invoice number column is formatted to number and even as a text but this does not change anything as still shows me the import error.

 

I appreciate your help.

S
SirielJeaB
December 10, 2023

I appreciate your additional details and attachment, @MarkH08. Let me chime in and help you sort this out. 

 

It's possible that the deposit accounts in your QuickBooks Online (QBO) account may not align with what you entered in your CSV file. Please ensure that the deposit accounts in the QBO system match those in the CSV file. For instance, if you entered a deposit account named 11790, ensure that a corresponding bank account exists in your Chart of Accounts. 

 

Once verified, you can then import your sales receipts again.

 

You can also read these articles to manage your bank transactions within the program:

 

 

Leave a comment below if there's anything else you need help with importing your sales receipts. I'm always ready to give you the necessary information. Keep safe.

Terms & ConditionsAccessibility statement