Allow me to step in and help you import invoices to QuickBooks Online (QBO), Joseph.
This error could occur due to an incorrect format in the CSV file or if the template doesn't adhere to specific requirements. Please keep in mind that the maximum file size allowed is 350 KB.
If the file exceeds the limit, shorten the date range and download transactions in smaller batches. To know more about how you can check the format, check out this link: Format CSV files in Excel to get bank transactions into QuickBooks.
Additionally, missing info can be caused by several factors. We can also consider the interrupted connection. When there are connection faults during the download process, some transactions wonβt be downloaded successfully. When importing transactions, there are certain factors to consider.
- Make sure the file is in a CSV (comma-separated values) format.
- Ensure to save your data as a CSV or Comma delimited.
- Check if the file has blank lines if it does delete them.
- Please make sure to select the column header labels (from the dropdowns) that match the column header labels in your CSV file.
- Your CSV file should contain the following information: Date, Description, and Amount.
Check out the additional pointers below that will guide you in reformatting your CSV file:
- 0's are not allowed anywhere in the file, e.g Rs. 0 should be left blank
- Commas for thousands are not allowed either e.g 2,111 should be 2111
- Other special characters such as #, %, and & are not allowed
- Correct any transactions with the amount showing in the description column
Please know that the standard date format is dd/mm/yyyy (01/02/20). I would also recommend shortening your description so the program can easily read your bank transactions.
Once verified, you can re-import your transactions following the correct format. You can use these articles for more detailed steps in importing your transactions:
Leave a comment again if you need more help importing transactions in QBO. Thanks!
