Welcome to Community @88daly2, Let me share with you some of my ideas when importing transactions in QuickBooks Desktop. You are not able to import transactions like estimates through Excel files. I can suggest to look for a third-party app that can help you import estimate using Excel file. You can follow these steps on how to search for a third-party app in QuickBooks Desktop. Here's how: Go to the QuickBooks Desktop Apps Store.Select the All Applications tab.You can add filters by Categories, QuickBooks Compatibility, and Developer.Enter the processor in the Search field. Also, the other option to import estimates in your QuickBooks Desktop account is to create an IIF file. I recommend contacting an IT professional to assist you create an IIF file. If you'll need further assistance, just notify me by leaving a message in the comment section. I'll be happier to help. Have a good one!

Question

Can i import my excel estimate into quickbooks without doing any changes

Forum|Forum|6 years ago
June 8, 2020
16 replies
41 views

No text available

QuickBooks Desktop

R

Rejeil_O

Welcome to Community @88daly2,

Let me share with you some of my ideas when importing transactions in QuickBooks Desktop. You are not able to import transactions like estimates through Excel files. I can suggest to look for a third-party app that can help you import estimate using Excel file.

You can follow these steps on how to search for a third-party app in QuickBooks Desktop. Here's how:

Go to the QuickBooks Desktop Apps Store.
Select the All Applications tab.
You can add filters by Categories, QuickBooks Compatibility, and Developer.
Enter the processor in the Search field.

Also, the other option to import estimates in your QuickBooks Desktop account is to create an IIF file. I recommend contacting an IT professional to assist you create an IIF file.

If you'll need further assistance, just notify me by leaving a message in the comment section. I'll be happier to help. Have a good one!

D

Dellis51

I believe this answer is incorrect. I contacted Quickbooks support yesterday and was told that you cannot use IIF to import or export transactions, only lists. On my utilities options there is no choice for exporting transactions. Is this only available to Enterprise?

M

mv32

Level 8

ok got it. As for the restrictions for the controller....for her to import IIF files whether via qkbks or third party....does she need to be an admin?

Hi @radgc.

Yes, she needs to be an admin or you can give her all the privilege to access your QuickBooks Desktop company file. This way, the user can import the IIF file for estimates successfully. Also, you can back up your company file before importing IIF files so that you can restore the changes in case you run into an error.

Here's the sample IIF file for an estimate: Estimate.iif.

Additionally, you can reference the articles that are shared by my colleague, Maybelle_S for more details about creating and importing IIF files in QuickBooks Desktop.

If you have other concerns about importing lists and files, please fill me in. I'll make sure to get back to you.

Fiat Lux - ASIA

Level 14

...

S

ShulyM

I'm looking into streamlining our agency client billing process, from the time of client billing submission by the media team to creating the invoice in our QB desktop by accounting team.

Currently, our process is as such:

media team provides accounting with the SOW (pdf format) via email
Invoice is created and info from SOW is manually typed to an invoice in QB, (each media buy separately)

However, if media buys are different from the SOW, media team types the changes in the email. And again, the accounting team copies/paste into an invoice created in the system (QB).

As you can imagine it is extremely time consuming, error prone, and inefficient. There must be a better way and it is time for a change!

My question is - if the SOW is submitted in a different format, which format should it be so we would be able to be in order to upload to QB desktop?

However if there are any recommendation in how to make our processes more efficient that would be extremely helpful.

Much thanks!

S

ShulyM

to add on here -

Is there a template to prepare the client invoice with the data? where do I find various templates if so?

as for templates for credit card transactions to upload into the QBDT, is that something I find within the online banking transaction, e.g. JP Morgan credit card, Amex?

Sign up

Login with SSO

Let's get you signed in

Login with SSO