How to import bills from vendors with Fixed Asset Item?

Derek38 · ‎January 16, 2024

Hi I have been using iif uploading it has been successful for me. But recently I encountered this issue that I could not work it out.

So basically my company purchased a bunch of fixed asset (I have loaded those into the Fixed asset manager and have synced those asset to Fixed asset list in QB.)

Apparently, if I input bills in "Enter Bill" function and select "Items", the fixed asset items can be attached to the bill.

See the screenshot below.

Then I am trying to import all the bills that are issuing to us into Quickbooks and map those bills to the asset that are in the list. Basically do what manual input can achieve. Somehow I could not do it.

Here are the headers that I use (this is for another different bill)

Importing above item it went successful. But however the bill shows up in QB has a $0 due, with nothing in Expenses or Items. Memo is empty as well.

Anybody know why this is the case? Any possible solution? Thanks!!

Rasa-LilaM · ‎January 16, 2024

Thank you for dropping by the Community today, Derek38.

I can see how challenging it must be to come across this unexpected result while importing your bills, as it can disrupt your business workflow. Let's work together to resolve this issue by going through some troubleshooting steps. This is to ensure transactions imported into QuickBooks Desktop (QBDT) are accurate.

We'll have to review the file before importing your bills to make sure it's accurate, especially the IIF headers. It's important to have the correct spelling and proper placement of these headers to avoid any errors during the import process.

Let's download and install the.IIF import kit, so you'll have a reference guide on how to create the file. Here's how:

Click here to access the kit.
Select the Save button to download the IIF_Import_Kit.zip file to your Windows desktop.
Use WinZip or any compatible file compression utility to extract the contents of the downloaded file. The contents will automatically extract into a subfolder called.IIF Import Kit.
Open the IIF Import Kit folder to view its contents.

To gain a deeper understanding of the process and make the most of the tool, take a look at this reference: IIF Overview: import kit, sample files, and headers.

Furthermore, these resources offer in-depth insights into the import and export limitations of the IIF tool, along with practical resolutions for resolving errors:

Should you have any further QuickBooks concerns or questions regarding importing your bills via.IIF and managing your vendor transactions, don't hesitate to reach out to me again. I'd be delighted to assist you. Have a pleasant day, Derek38.

Topics

Training

Community

Resources

How to import bills from vendors with Fixed Asset Item?

How to import bills from vendors with Fixed Asset Item?

Need to get in touch?