cancel
Showing results for 
Search instead for 
Did you mean: 
NMichRocks
Level 2

Depreciation and Fixed Assets

I'm looking for software or a spreadsheet that will track fixed assets and monthly depreciation expense, additions, disposals, etc.  I have a spreadsheet that I created but it is a little clunky and time consuming.  Can you suggest a better option?  We are a small manufacturing company under $50M in sales.  Using QB Desktop Enterprise Manufacturing and Wholesale. Appreciate the help.

4 Comments 4
Fiat Lux - ASIA
Level 15
ShaniamarieC
QuickBooks Team

Depreciation and Fixed Assets

Hi there, @NMichRocks.

 

Allow me to share some insights into how to track fixed assets and monthly depreciation expense, additions, disposals, etc, in QuickBooks Desktop.

 

Tracking your fixed assets should start by learning to perform key tasks in Fixed Asset Manager (FAM). One of these tasks is assigning an account to multiple assets. It is important to note that when converting asset data from one version of QuickBooks Desktop to another or importing assets into FAM, some General Ledger accounts (G/L accounts) may be left unassigned. To avoid any issues, these accounts must be manually assigned in FAM.

 

  1. Open Fixed Asset Manager.
  2. In the Schedule tab, highlight all the assets that need to be assigned to a specific account.
  3. Right-click the selected assets and choose Assign G/L Accounts to Assets.
  4. Select the account, then OK.

 

Change or add depreciation method/setting.

You may need to change or add the Depreciation Method for a fixed asset in order for FAM to calculate the current and prior depreciation correctly.

 

Depreciate an old asset.

Your business might have already had some fixed assets even before you decided to use FAM. Follow these steps to record your fixed assets with correct depreciation.

 

Export QuickBooks Fixed Asset Items into ProSeries Form 4562

QuickBooks Fixed Asset Manager can only export data to the same year of ProSeries. This is because QuickBooks Desktop is based on the Calendar year, while Fixed Asset Manager and ProSeries are based on the Tax year. This means that QuickBooks Desktop 2017 comes with FAM 2016, which can be exported to ProSeries 2016.

 

Import Fixed Assets from Excel into the Fixed Asset Manager

You can transfer information from third-party applications to FAM as long as they can export data as a Comma Separated Value (.CSV) file.

 

Select the basis on which to post a journal entry.

In Fixed Asset Manager, it is possible to change the basis (Federal, Book, AMT, ACE, State, Other) you are posting journal entries on.

 

You can transfer information from third-party applications to FAM as long as they can export data as a Comma Separated Value (.CSV) file.

 

For more detailed instructions, check out this article: Use Fixed Asset Manager in QuickBooks Desktop.

 

Moreover, you can integrate a third-party tool with the desktop software to track fixed assets, monthly depreciation expenses, additions, disposals, and more on a spreadsheet. This way, you'll be able to consume less time.

 

You can always get back to us if you have other concerns or questions about Depreciation and Fixed Assets in QuickBooks Desktop. We'll make sure to respond as soon as we can. Keep safe always!

 

NMichRocks
Level 2

Depreciation and Fixed Assets

This looks like a fantastic solution that I was not aware of!  Can you tell me more about how to import existing fixed assets into the FAM?

ShyMae
QuickBooks Team

Depreciation and Fixed Assets

Hi there, @NMichRocks. I'm here to guide you on importing existing fixed assets into FAM. 

 

You can transfer information from third-party applications to FAM if they can export data as a Comma Separated Value (.CSV) file. 

 

  1. Open Fixed Asset Manager.
  2. From the File menu, select Import.
  3. Select Comma Separated (CSV) to start the Import Wizard.
  4. Follow the prompts to complete the import.

 

For more detailed information, check out this article: Manage fixed assets using Fixed Asset Manager (FAM)

 

Moreover, you can generate a report to get a comprehensive business overview. With this information at your fingertips, you can make informed decisions and adjust your strategy to improve your operations. 

 

Whenever you need my assistance importing fixed assets, I'm here to help you further. Best regards!

Need to get in touch?

Contact us