Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am setting up a new account in quickbooks premier 2021. I have downloaded the Donors/Grants Report in excel format (look under the Email tab), however, I need to know if I can upload/import the report in to my new account? Thanks
Hello @Rbible,
Thank you for posting here in the Community. I'd be glad to assist you with your questions about importing data into QuickBooks Desktop.
For donors or customers, it's possible to upload the data directly into our system. QuickBooks can import Customers, Vendors, Items, and Accounts from an Excel spreadsheet.
There are several options available when importing Excel files. For the detailed instructions, visit this link: Import or export MS Excel files.
For transactions like grants (usually entered as Deposits), you'll need an IIF file format or Web Connect file from your bank. These two methods will allow users to upload deposit transactions.
Alternatively, there are third-party apps you can use to import transactions into QuickBooks. Though we can't suggest a specific app, I've found a few apps that offer this type of service.
You can visit the websites to know more about them. Here are the sites:
For your reference, I've attached an article that contains a compilation of links on how to upload lists and transactions in QuickBooks Desktop: Import and export data in QuickBooks Desktop.
Feel free to get back to me anytime you have additional questions about the process or uploading data. I'm always here to help. Take care always.
You can import transactions, not reports into your QBD file. Utilize an importer tool if required
https://transactionpro.grsm.io/qbd
https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here