How QuickBooks and Fixed Asset Manager Share Data: A Bookkeeper's Guide

When QuickBooks and a fixed asset register live in separate files, the two must agree. Synchronization is the mechanism that keeps them in step. Understanding what moves, and in which direction, is the difference between a depreciation schedule you can audit and one you quietly distrust.

What synchronization actually does?

By default, QuickBooks and Fixed Asset Manager keep separate data files in separate locations. Nothing is merged. Synchronization is a controlled copy of specific fields between the two, on a schedule you set.

You can leave it manual, or set it to automatic. In automatic mode, asset data is pulled from the QuickBooks fixed asset item list when Fixed Asset Manager opens. It also refreshes when a change is made in QuickBooks while Fixed Asset Manager is open and you switch back to it. You designate how often and when the sharing happens.

What flows from QuickBooks into the fixed asset register?

The register receives the company-level context and the asset detail you have already posted:

• Company name, address and phone numbers
• Income tax form used
• Federal Tax ID
• Chart of accounts
• Detailed asset information from the fixed asset item list

This direction matters at year-end. If the tax form or the chart of accounts has changed in QuickBooks, the register should pick that up before you calculate depreciation, not after.

What flows back to QuickBooks?

Fixed Asset Manager pushes back the results of your depreciation work:

• Asset numbers
• Detailed asset information
• Assets added within Fixed Asset Manager itself
• Year-end accumulated depreciation

The accumulated depreciation figure is the one to watch. It is the number your general ledger must match, and the reconciliation between the two is a working paper in its own right.

Where this touches the close

Treat the register as a subsidiary ledger. Each period, the accumulated depreciation per the register should tie to the accumulated depreciation account in QuickBooks, and the period's depreciation expense should agree to your journal entry. If they do not, the usual causes are timing (a sync that has not run since the last posting) or an asset recorded on one side only.

Distinguish the two before adjusting. A timing gap closes after a synchronization. A one-sided asset means someone added it in Fixed Asset Manager but never posted the purchase in QuickBooks, or the reverse. Fix the underlying record, not just the difference.

Judgement calls worth making deliberately

Decide, in writing, which side is authoritative for each data type. In practice the general ledger should win on cost and accumulated depreciation; the register wins on method, life and disposal dates. Agree this with the accountant before the first year-end, not during it.

Run a synchronization immediately before closing the period, and archive the register report as at that date. That snapshot is your evidence that the two files agreed when you closed.

If the two files stop agreeing after repeated syncs, or the fixed asset item list itself looks damaged, stop posting. Preserve a backup of both files and take the discrepancy to a specialist in QuickBooks data repair before anyone edits records to force a match.