Is it possible to batch export all attachments (PDF bills and other files) that were uploaded to Quickbooks?
If so, will their filename be the journal entry or purchase number?
I am asking because once a fiscal year ended, we would like to make backups of all the files and store them securely on our private servers. If there is a government audit, we would like to easily find the invoices and supporting documents associated with each transactions.
Hello again glcpa,
Having backups of your businesses transactions and data is a great idea, especially for if those audits happen. I know how important it is to be prepared for those situations and will do what I can to help you.
In QuickBooks Online, it's possible to use the Export Data feature to export the following reports and list items.
To use this feature, click the Gear icon and choose Export Data. Toggle the button to green for the ones you'd like to export, and then choose Export to Excel. The data will export as a .zip file with your company name and the date of export. The individual excel documents are named for the report or list they contain information for.
Beyond this feature, you're also able to export other reports in the Reports tab. This will allow you to keep information of your transactions and other business data on record. For instance, the Transaction List by Customer report, and other transaction reports like it, give you the breakdown of transactions and the other relevant information.
To have copies of the transactions themselves, open them up and use the Print or Preview option to download PDF copies. When you hover in the print preview pane, it brings up the option to download.
Take a peek at the export data out of QuickBooks Online article to learn more.
That should get you on your way. I'll be here should you have more questions.
If you don't have the files attached to your transactions already saved on your computer or phone, you can save them by going to a transaction, opening it up, and then clicking the attachment link. This will open the attachment for you to view, at which point you can save it from your browser.
I hear what you're saying and know it's ideal to be able to export all the information you'd like at once, including attachments. I'll share this feedback with the product development team for consideration in future updates. Our goal with QuickBooks Online is to help save you time and keep things simple.
Don't worry about it, mrxchd.
I can give you the steps in exporting the attachments. Here's how to do it:
You can also export other data from your company by following the steps in this link.
Let me know if you need anything else.
That is really helpful - thanks. However;
1) I take it there isn't a way to filter so you only download e.g. sales invoices
2) the zip file puts all the documents in their own folder so it is still a pain to collect them all together. Is there any way to prevent hundreds/thousands of folders being created?
If you'd like to filter the attachments by transaction type for download, click the column that says Type above the list of attachments. Then, check the boxes next to the type of transactions you'd like to export. Then follow the instructions above to export them.
Whether these files go to the same folder or one single folder may depend on your computer and settings. If they come through individually, I recommend creating a 'parent' folder to store them all in the same location for your convenience.
When converting a quicken file to QB Pro Desktop (using utility in QB), it does not seem that the attachments came through (in Quicken, we save a pdf of the invoice when we write a check). What do we need to do to make sure the attachments get into QB?
Great question! It's awesome that you're beginning to use QuickBooks Desktop Pro for your business and I'll do what I can to help you get sorted out.
It sounds like you're using the Import tool by going to File > Utilities > Import in QuickBooks Desktop. If so, that's perfect. There isn't a conversion tool for transferring the Quicken file to QuickBooks Desktop, meaning you may need to reinput some data that isn't imported during the switch. Attachments are one thing you'll likely need to re-add to your transactions. Check out more about importing here: Import/export overview
If you'd like help with setting up your QuickBooks Desktop file, don't be afraid to reach out to our phone support team. They'll be able to get you on track and using the program in no time. Just dial 1-877-772-9158. Support for Desktop Pro is available 24/7, so you can call at your convenience. Learn more about support here: Intuit QuickBooks Desktop software support policies
I hope that helps! Have a great week.
Is there a way to download all the Vendor W9's which have been attached to the vendors master in QB desktop version. We are being audited and they want all Vendor W9's to be sent to them. Also, can I download Vendor Bill attachments?
Based on your mention of W9s, it sounds like you're using the US version of QuickBooks Desktop. This thread is relating to QuickBooks Canada functionalities. Don't worry, I'll get you to the right place. I'll transfer your question over to my US colleagues so they can help you get the information you need for your audit.
In the future, the easiest way to make sure you're in the regional section of the community you need is to check the flag at the top of the community.
Hang tight and someone will be with you as soon as possible!
Hello there, YCORP.
Downloading the W9 form for vendors isn't possible in QuickBooks Desktop. However, you can manually enter your contractor's information in the contractor's profile.
You can also visit this IRS website to get all the information you need to know about W-9: Forms and Associated Taxes for Independent Contractors.
In terms of downloading vendor bill attachments from QuickBooks Desktop, this option unavailable. I'd like to share this idea to our developers. This way, will be able to determine those features that your business need the most.
Should you need more help with anything about QuickBooks, feel free to get back to me and I'd be glad to assist you further.
The batch action exports some attachments into a zip file... But not all of them. Out of hundreds of attachments, only 97 files were downloaded. I can't tell what not downloaded and what were not from the full list of attachments... Please, anyone has a solution for this?
Hi QB Community
This link no longer works.
I urgently need to download ALL my attachments that I have uploaded to QB over the years.
Impossible for me to go into each transaction, find the attachment and save each one separately. I need a bulk button... How do I go about this please??
Hi AM77. Thanks for joining the thread. I can appreciate that opening your zip files and sending information to your bookkeeper is important.
I know sometimes it's easier to work through your troubleshooting over the phone, so you can get in touch with our tech support team to speak to an agent by using the information found here: Get in touch.
They also have the ability to do a remote screen share with you to ensure everything is working properly.
Hello Virginia Wallace,
Thanks for joining us on this thread. I want to make sure I'm on the same page with the information you're looking for and I'd be happy to clarify anything discussed in this thread. Can you please let me know which of these questions you'd like to go over and which version of QuickBooks you're using?