cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
jtetlak
Level 1

Import your invoices and bills to QuickBooks

I've seen that link and when you go there, it gives a list of things you can import. Invoices are not on that list.

Or is that what is meant by "Customer Type"...?

 

EmmaM
QuickBooks Team

Import your invoices and bills to QuickBooks

Hi jtetlak:smiling_face_with_smiling_eyes:, The post you originally commented on was to do with importing invoices and bills into QuickBooks Online. The import of IIF files and what you can import depends on the edition you have of the desktop product. If you have pro desktop you can import customers, suppliers, and stock items. The invoice import is available in the Premier accountant desktop version only.

L Davies
Level 1

Import your invoices and bills to QuickBooks

can I import PDF sales invoice files into QB's? If so how!? 

Fiat Lux - ASIA
Level 15

Import your invoices and bills to QuickBooks

@L Davies  

You may need a 3rd app to do so.

Ashleigh1
QuickBooks Team

Import your invoices and bills to QuickBooks

Hello L Davies, 

 

Thanks for posting on this thread, 

 

You cant import by PDF you would need to change it to a CSV file then you will be able to import it into Quickbooks. 

 

Jolanta Zeglinska
Level 1

Import your invoices and bills to QuickBooks

Can developers add column for Class on csv template for bills importing? import should offer the same options as manual data entry- I'm surprised this has been omitted. 

 

Can you please add import template for "Cheque" payment as well? this would be massive help with processing csv bank / credit cards statements. All we need is the same options as for manual cheque entry - please don't forget about Class and currency boxes. 

 

 

 

 

 

 

RenjolynC
QuickBooks Team

Import your invoices and bills to QuickBooks

I can direct you to our developers page, Jolanta Zeglinska.

 

You can share your concerns by going to the Intuit Developer forum. There are engineers, developers, and other QuickBooks users that can provide details about adding columns in the template.

 

Please feel free to visit us again if you have any additional questions, or other concerns with QuickBooks. I'm always around to help. 

Fiat Lux - ASIA
Level 15

Import your invoices and bills to QuickBooks

@Jolanta Zeglinska 

Utilize the trial period of TPImporter

https://transactionpro.grsm.io/qbo

 

Prepare your Bills data with the following template

RefNumberAPAccountVendorPrintOnCheckNameTxnDateDueDateSalesTermLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office SuppliesFor Anne25,1           
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  TelephonePhone Cards50,25           
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use        MP3 PlayerBlue MP3 Player255    
185 Green's Taxi Service ######### Net 30 1 Main Street   San DiegoCA12345    Transportation 125,13           
akhalid
Level 1

Import your invoices and bills to QuickBooks

Hi,

 

Has this feature been updated? I have the track class activated in my settings. I can assign a class when I manually enter a bill, however, when uploading, it the column is not available in my upload template. Could you please let me know how I can upload a list of  bills assigned to a particular class ?

 

Kind regards, 

MirriamM
Moderator

Import your invoices and bills to QuickBooks

Hi there, akhalid.

 

As of this time, able to upload bills assigned to a particular class is unavailable in QuickBooks Online (QBO). I can see how this feature would be beneficial to you and other businesses. If this is what you need, I suggest checking a third-party app that could help you import it. You may also consider the suggestion provided by Fiat Lux - ASIA.

 

While we continue to make your experience with us even better, in the meantime, I encourage you to star our blog to keep up with any product updates or improvements on the online version:  QuickBooks Online Blog.

 

For more information about importing bills, check out this article: Import your bills in QuickBooks Online.

 

If there's anything else you need help with, let me know by adding a comment. I'm more than happy to assist you. Have a great day!

Fiat Lux - ASIA
Level 15

Import your invoices and bills to QuickBooks

@akhalid 

Utilize the trial period of an importer tool as I mentioned earlier.

Clive Cawood
Level 1

Import your invoices and bills to QuickBooks

I changed banks and did not realise in switching banks, my old bank closed my account and know I only have bank statements to upload in csv. how can I do this

Fiat Lux - ASIA
Level 15

Import your invoices and bills to QuickBooks

@Clive Cawood 

Utilize the trial period of TPImporter

https://transactionpro.grsm.io/qbo

 

Prepaare the Bank Statement data with the following template

TxnDatePrivateNoteCurrencyExchangeRateDepositToAccountEntityLineDescLineAmountAccount
28/07/2020Manual Feed  CheckingJane SmithMonthly Dues25Account1
29/07/2020Manual Feed  CheckingBank of the WestJuly Fees-15Office Expenses
30/07/2020Manual Feed  CheckingStaplesPaper for Copier-50Office Expenses
01/08/2020Manual Feed  CheckingTeddy JonesCharitable Contribution500

Account1

 

RichardGH
Level 1

Import your invoices and bills to QuickBooks

Is there a bulk method of adding the Class to imported invoices?  Or must you change them individually?

Richard

Fiat Lux - ASIA
Level 15

Import your invoices and bills to QuickBooks

@RichardGH 

You may export the data out by using the exporter tool, modify the class, and reimport it back in bulk. Check the link as I mentioned in earlier post.

sk33
Level 1

Import your invoices and bills to QuickBooks

Hi,

 

Is it possible to import the same invoices twice into QuickBooks and system will allow this to happened?

Especially when those invoices have the same numbers and amounts.

Is there any way I can get a report from QuickBooks to check if I imported the same spreadsheet twice or was this a QB error. 

How can I prevent this from happening in the future? I'm using the function terms: End of the Month.

 

Thank you.  

 

JasroV
QuickBooks Team

Import your invoices and bills to QuickBooks

Nice to have you join this thread, @sk33

 

Importing same invoices number in QuickBooks Desktop (QBDT) isn’t possible. You’ll want to change the invoice number if you wish to import the duplicates.

 

Also, you can run a Custom Transaction Detail Report and customize it to show all invoices recorded in the program. This way, we can check if the invoices are already imported to the software. Let me show you how.

 

  1. Go to the Reports menu.
  2. Select Custom Reports.
  3. Click Transaction Details.
  4. Select Customise Report.
  5. Go to the Filters tab.
  6. Type in transaction type under the filter field.
  7. Select Invoice from the drop-down menu.
  8. Then click OK.1.JPG

 

You can also check this resource for more details about customising reports in QBDT: Customise customer, job, and sales reports in QuickBooks Desktop

 

I’ve also added this link that you can read for additional reference in importing data to your software: Import and export data in QuickBooks Desktop.

 

Please let me know if need further assistance importing your invoices to QBDT, I’m more than happy to work with you again. Have a great day ahead.

info1200
Level 1

Import your invoices and bills to QuickBooks

That's a bit poor. How can this not be possible in Quickbooks? It is creating double handling of info....

Emon
Level 1

Import your invoices and bills to QuickBooks

My question is how do i import bulk expenses by a single csv to my current QBO from another QBO ?

Fiat Lux - ASIA
Level 15

Import your invoices and bills to QuickBooks

@Emon 

Utilize a migration tool as I mentioned earlier.

https://transactionpro.grsm.io/qbo

 

Newton Ftwr
Level 2

Import your invoices and bills to QuickBooks

Hi, 

 

I have been regularly importing my bills into quickbooks for a while without problems. I use your standard template. 

Just today it has stopped working. it keeps telling me the date format is wrong. the date format is the same as it was last week, and i have amended it several times to make sure it isnt user error or hasn't become corrupted. 

 

Please can you check whether something has changed with QBO? That is messing with this function? 

this is very frustrating! 

I look forward to your reply. 

Ashleigh1
QuickBooks Team

Import your invoices and bills to QuickBooks

Hello Newton Ftwr, thanks for commenting on this post, can you clear your cache and cookies to all time, close the browser down, reload it and try upload it again into your account and see if that works or if you still have an issue please let us know. 

 

 

Newton Ftwr
Level 2

Import your invoices and bills to QuickBooks

Hello, 

 

I did do that, It didnt work, sorry...

 

Still not uploading, with the same error message. 

Ashleigh1
QuickBooks Team

Import your invoices and bills to QuickBooks

Thanks for trying that Newton Ftwr, i suggest that you ring the helpline on 0808 234 5337 line is open mon to fri 8am to 7pm and then can set up a screen share with the agent so they can have a look into why it will not upload for you, there has not been any changes that we are aware of so it should upload for you but the agent on the phone will be able to assist you and look at it for you. 

Christine Martin
Level 1

Import your invoices and bills to QuickBooks

Ive followed all the Fields everything is good, Select Import - Will import Customers but not my Invoices.

message 0 of 77 invoices imported 

Not sure why.... Help

Need to get in touch?

Contact us