Question

Fixed asset & depreciation tracking

Forum|Forum|7 years ago
January 7, 2019
5 replies
57 views

I have 2018 quickbooks desktop pro. Is there an add on module or something to record fixed assets and calculate the associated depreciation schedules? Everything I have come across looks like I would need to buy quickbooks accountant premier version, which is $$$ every year. I am an accountant, but I don't handle other clients, just my husband's S-corp; so I know what I'm doing as far was recording FA and the depreciation. I guess I'm hoping there is another solution besides the expensive yearly fee for the accountant premier version. Thanks!

QuickBooks Desktop

qbteachmt

Level 11

You can use any tool, but what you are asking about is FAM = Fixed Asset Manager that is included when you buy QB Accountant Edition. FAM doesn't do anything but act as "smart" index cards; it connects to the data file to place Entries for you, instead of you making them. Only you know if the amount of FA you need to track makes this worthwhile, as well as Changing that QB data file to using the Fixed Asset Item type; that provides the connectivity.

And the FA regulations changed with the TCJA, making all of this much less hassle.

D

dkirkjohnson

When will QuickBooks Online support a Fixed Asset Manager tool? It is very cumbersome to track it in separately in Excel.

Fiat Lux - ASIA

Level 14

@dkirkjohnson

You need an additional app to integrate with QBO.

F

FTech

There's a new book out called Simple/Smart Fixed Asset Handling in QuickBooks, for the desktop editions. It shows how to set up Inventory Part Items in a special way to work with fixed assets.

It also has a link to a free spreadsheet for calculating depreciation (not tax depreciation, but methods like SL, 1.5DB, DDB, SOYD) and shows a procedure for getting depreciation transactions prepared by the spreadsheet imported into QuickBooks as a batch. (If you have 50 assets you'll have an imported transaction with 50 lines, because the entire fixed asset list is maintained in QuickBooks, in detail.)

There's no software cost beyond the cost of QuickBooks itself--and the price of the book, of course. I think the book's method is a big improvement over using Fixed Asset Items *if* you don't want to buy Accountant or pay the $300+ cost to add FAM to Pro or Premier.

Rustler

Level 15

@FTech

Premier has an name limit of 14,500, for some this does not impact them at all, but down the road you never know.
I played with this same thing back in 08, I have not read the book, hell didn't know there was one

in your screen shot you have "house" and a check for depreciation, what type account is house?
since a depreciation entry is paper, not real, where does the 6K come from?

to get the negative value for the depreciation item, I had to use a vendor credit, for that - it worked. BUT, a/p was wrong on the balance sheet due to the massive vendor credit

Inventory asset on the balance sheet will be correct, but inventory valuation summary will include both the fixed asset item and the depreciation item - big difference in total valuation. You could of course customize the inventory valuation report to include only inventory items you want, but if you add new ones, then you have re-customize the report.

and then there is the item list, even if you preface the FA parent item with zz-, all those inventory items for fixed assets show up in the middle of the item list, making it longer than hell, and harder to select an different type of item. Type ahead will probably find the FA item before it finds the discount or other item.

Back then I did not think about creating a second a/p account for the vendor and the depreciation credit, you could do that in desktop, and then customize the balance sheet to not include that second a/p account. But again if you add or change an account you have to re-customize the report.

more work than it is worth, and too prone to clerical errors IMO

As it stands all my FA are under the parent account, a balance sheet allows me to collapse the sub accounts showing just the sum total as fixed assets. I would much rather have a long account list that I rarely use as opposed to a long item list I use all the time.

Once a year I bring up a memorized journal entry, and if necessary edit any values that need it, and save. Compound journal entry, depreciation expense, and then all accumulated depreciation accounts. Quick and easy.

Out of curiosity, are you the author of the book?

L

ljfdAuthor

@FTech

your right I did not consider a zero dollar check, nice approach.

inventory valuation summary is used a lot by most everyone I run across, keep in mind that users are not well versed in (usually) accounting or QB. Yes you could do the math to insure that your system total for inventory asset matches the balance sheet, but few will do it.

I use the IRS tables for depreciation, I believe in keeping the books on a tax basis, since I am not publicly listed and subject to the SEC regulations nor do I have the requirements of government contracting.

We'll agree to disagree on how handy using an inventory item would be, I can report on an asset account just as easily, and a fleet of vehicles can be handled the same way.

well since I am a CPA, we don't hire one for our S-corp, but I don't actively prepare other clients books/taxes so I don't purchase the expensive bookkeeping software that would have depreciation calculations. I just don't understand why calculating depreciation is so "exclusive" and isn't included in basic accounting software such as quickbooks, given that almost every business has fixed assets that need to be depreciation (though I realize depreciation is much less of an issue with the new tax laws).

Rustler

Level 15

@ljfd wrote:

I have 2018 quickbooks desktop pro. Is there an add on module or something to record fixed assets and calculate the associated depreciation schedules? Everything I have come across looks like I would need to buy quickbooks accountant premier version, which is $$$ every year.

When you go to purchase premier in the US, down at the bottom in pricing is this statement

Want to buy QuickBooks Accountant Desktop without a ProAdvisor membership,
or need to purchase for multiple desktop users? Call [removed]

What you did was buy a subscription, joined the pro advisor program which includes an annual update to QB, a newer version in other words

if you call and order it withOUT the pro advisor membership it is a flat price, and will be supported for 3 years for incremental updates. After 3 years it still works fine, with the exception of any online connections to banking, payroll, etc. So at worst, you buy it every 3 years

all my FA are under the parent account, a balance sheet allows me to collapse the sub accounts showing just the sum total as fixed assets. Once a year I bring up a memorized summary journal entry, and if necessary edit any values that need it, and save. Compound journal entry, depreciation expense, and then all accumulated depreciation accounts. Quick and easy.

john-pero

Level 12

My previous CPA and my current CPA both use a separate program for depreciation and enter one annual number from the 4562, I don't lift a finger. I also do not adjust fixed asset value by deducting depreciation from each asset inside of QuickBooks. Our accumulated depreciation account includes it all. But since the CPA has current values for each asset there is no problem when disposing of those assets.

Excel with manual calculations also works.

Rustler

Level 15

@john-pero wrote:

My previous CPA and my current CPA both use a separate program for depreciation and enter one annual number from the 4562, I don't lift a finger. I also do not adjust fixed asset value by deducting depreciation from each asset inside of QuickBooks. Our accumulated depreciation account includes it all. But since the CPA has current values for each asset there is no problem when disposing of those assets.

Excel with manual calculations also works.

A lot of people do it that way, I have a problem with it though, so as food for thought.

if there is a catastrophic event and the cpa's records/computer/data is lost, how long will it take to get the offsite back up (assuming there is one), or if the cpa dies and the estate goes into probate. Or you part ways, and want your detailed data - we have seen folks, on the other better site, asking what to do when requests for the release of the their data are ignored.

B

Bobby Chiggins

Exactly...

What do you think is the best solution?

Rose-A

Level 10

Hi, Bobby Chiggins.

I'm by no means an accounting professional, but I do have some insight to provide that can help get you with depreciation tracking.

To track the depreciation of an asset that you’ve already purchased (and added to the Chart of Accounts), you need two new accounts in QuickBooks:

Fixed Asset type of account called something like Accumulated Depreciation.
Expense type of account called something like Depreciation Expense.

After you set up these two accounts, you can record the asset depreciation with a journal entry.

Here's how:

From the QuickBooks Company menu, choose Make General Journal Entries.
(Optional) In the Make General Journal Entries window, change the Date field.
The Entry No. should automatically populate. If not, type a number for your journal entries. QuickBooks Desktop will automatically number subsequent journal entries.
Enter the General Journal Entry details.
1. Enter or select the first account in your transaction. If you are using an A/R (accounts receivable) or A/P (accounts payable) account, the first account in the General Journal transaction should be the AR or AP account.
2. Enter the debit or credit amount for the account you selected in step a.
3. (Optional) Type a memo describing the transaction. This memo will appear on reports and will include the General Journal entry.
4. Enter or select the Customer, Vendor, Employee, or Other name associated with the transaction. This is required if you use A/R or A/P accounts.
5. (Optional) If you selected an Expense account along with a customer or job, you can make the amount billable to the customer by checking the Billable column.
6. (Optional) Assign a class to the amount.
7. Repeat steps 4a through 4e to enter distribution lines until the transaction reaches a zero balance. The total in the Debit column should be equal to the total in the Credit column.
Click Save & Close.

However, I'd suggest consulting an accountant to help and guide on which account to debit and credit. Your accountant can provide more expert ways of dealing with this situation.

You can get more information about journal entry: https://quickbooks.intuit.com/community/Help-Articles/Record-a-journal-entry/td-p/203691.

Also, you may find these articles helpful:

You can always get back to us if you have more questions in tracking depreciation. Have a great weekend.