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
  • 3 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

MarsStephanieL
MarsStephanieL
Level 6
November 24, 2020

I did look at the Set Up FAM article you linked to. It does not provide any info on importing existing fixed assets.

That is great that we can combine the import into 1 file.  But every csv file I have ever used for an import has specified column numbers that linked to specific fields.  It doesn't seem like it can just be a free for all.  Or are the column headings what links the data, meaning the column headings have to be typed exactly correct? Can you refer me to where you got to the screenshot below where it showed the required and optional fields for the import.  That would be helpful.

And lastly, do I still need an import file for each Federal, State, Book, etc?  Or can that all be in one import file with a leading descriptor (Federal) in the column headings. That is where it would be  helpful to see ALL of the optional fields that are available.  That way if the column heading is the key for the import, I can make sure I have the column headings exaclty correct.  When I exported the files, they did not include "Federal" or Book" in the heading names to differenciate between the different "books".

Thank you so much for your help!

Michelle


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.

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