Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
M
MichelleSCR
November 24, 2020
Question

Fixed Assets manager

  • November 24, 2020
  • 1 reply
  • 6 views

Does anyone have any experience with importing a file with existing fixed assets into fixed asset manager?  We are starting from scratch so have no current assets in FAM.

The instructions say that the Wizard will walk you through how to import a file, but I can't find anything that explains what fields of date should be included in the file.  Seems there should be a template that maps the data.

 

1 reply

JessT
JessTModerator
Moderator
November 24, 2020

Hi Michelle,

 

You can use data on the sample company file named sample product-based business. You can export it Excel (Comma Separated Value), delete the editing list of assets, and replace them by importing the exported one. That way, you can practice with the mapping.

 

You can also click Help on the Fixed Asset Manager window to look for references.

 

Let me know if you need more help. Have a good one!

M
MichelleSCRAuthor
November 24, 2020

Thank you Jess. That was a big help to get the export files for the template.

I have a further question about the imports.

For starters, I see now that I need to do a separate file for Federal, State, Book, etc.

But there are 3 View Column Sets (Asset Listing, Lead Schedule and Category).  I am not going to worry about Category for now, but do I have to upload files for both Asset Listing and Lead Schedule Views?  It seems much of that info is a duplicate so I am afraid I will overwrite something I don't want to.

Also, is it necessary to include the G/L Asset Description for the Cost, A/D and Deprec Expense accounts, or can I just populate the GL Acct # and leave the description blank. Those accounts already exist in our G/L.

You referred to the Fixed Asset Manager help available,  I have read all I can find and it all seems to fall short of providing any details for when you actually are trying to do it.

Thank you

M
MichelleSCRAuthor
November 30, 2020

Hi there, @MichelleSCR.

 

Allow me to share some details about the Fixed Asset Manager.

 

The option to combine all the data into one file is unavailable. The system will not accept the format if you add another column headings. Also, the screenshot my colleague attached is found in the Fixed Asset Manager. To open this window, please be guided by the steps below:

 

  1. Open your QuickBooks Desktop company and go to the Accountant menu.
  2. Select Manager Fixed Assets.
  3. Follow the on-screen instructions until you reach the homepage.

 

I'd also suggest contacting your accountant to ensure that the accounts and the data are assigned properly to avoid errors in the future.

 

In addition to the article given by my colleague, here's another one to be familiar with the terminologies: Manage fixed assets using Fixed Asset Manager (FAM). This will help you manage your data effectively.

 

I've added this reference page that will help you on your future task, you can look for any similar articles for your concerns: Self-Help Articles for QuickBooks Desktop.

 

Feel free to tag my name in the comment section if you have other questions with QuickBooks. I'd be happy to assist you further. Take care.


I am confused. Jamespaul said I should add the columns from both files (asset listing and lead schedule view) to the main csv file for import.  But you said that the option to combine all the data into 1 file is not an option.

So does that mean, I am back to having to upload multiple files?  I exported all the files as was originally suggested and there are several, for the different views and the different books (federal vs state vs book vs amt).

Also, in all of the instructions that I have found, it refers to going to the Accountant Tab, then Fixed Asset Manager.  We are on desktop Enterprise and have to instead go to Company and then Fixed Asset Manager.  I mention that in case we have a different version that doesn't have all the functionality.

Also, can you send me a screen shot of what you referred to below when you said to go to the home screen.  I don't get any instructions when I go into FAM, but that might be because I already set up the tax and gl account info and tax year.

 

It still seems like there should be import instructions somewhere that explain what data is required, optional and how the csv file should be set up.  It can't be a free for all.  Don't certain fields have to be in certain columns. 

Thanks for any help you can give me.

 

 

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement