When you view an asset placed in service in the same fiscal year, FAM displays an incorrect dollar value on the prior depreciation. This corrupts the depreciation figures which results to the specific error. This error may also caused by selecting Post Entry to QuickBooks.

Possible reason:

The Accumulated Depreciation account in QuickBooks Desktop must be equal to Prior Depreciation in FAM. If an asset has been tracked in QuickBooks Desktop and FAM from the time it was acquired, this journal entry should be in balance. If it is out of balance, it may be caused by one of the following:

  • The asset was entered in QuickBooks FAM mid-life without entering the accumulated depreciation from its acquisition date.Example: An item was purchased and entered into the Fixed Asset Item List in QuickBooks Desktop Pro (which does not have QuickBooks FAM). The file is then used in QuickBooks Desktop Premier Accountant by the company’s accountant in order to calculate asset depreciation. If FAM is opened without first creating a correcting journal entry in QuickBooks, then FAM will read $0 as the amount of accumulated depreciation for the asset.
  • The calculated amount for prior depreciation was changed in FAM.Example: FAM is rolled back to a previous fiscal year (possibly due to printing a report for that fiscal year). This can cause any value in the prior depreciation field to remain the same number it was prior to changing the dates.
  • The asset is marked as disposed and the asset value and accumulated depreciation value has not been cleared in QuickBooks Desktop.

Solution 1: Make an adjustment using a General Journal Entry in QuickBooks, then update FAM assets from QuickBooks Desktop

  1. From the Reports menu of your FAM > Display Reports > Depreciation Schedule by G/L Account Number.
  2. Select the appropriate Basis for your report (i.e. Federal, State, AMT, etc.). If you are not sure which Basis is appropriate, consult your accountant.
  3. In the Date field, enter the date that is the of beginning of your current fiscal year.
  4. On the report, make note of the total in the first Accumulated Depreciation column (the date below this should be the beginning of your current fiscal year).
  5. From the Lists menu of QuickBooks Desktop, select Chart of Accounts.
  6. Right-clickthe Accumulated Depreciation account and select Quick Report Accumulated Depreciation.
    1. Change the date to the end of the previous fiscal year, then make note of the total amount.
    2. If there are multiple subaccounts, make note of all the total amounts and add them together.
  7. Subtract the amount in step 4 from the amount in step 6. This is the amount that you must enter as an adjustment via a General Journal Entry in QuickBooks Desktop.
  8. From the Company menu of your QuickBooks Desktop, select Make a General Journal Entry.
    1. Change the Date to the end of the previous fiscal year and select Adjust entry.
    2. In the Account field, select the Depreciation Expense account. Enter the amount from step 7 in the Debit field.
    3. In the Memo field, type Adjust entry to match QB to FAM.
    4. On the next line, select Accumulated Depreciation account, then enter the same amount in the Credit field.
    5. Select Save & Close.
    6. If necessary, repeat the process for the subaccounts.
  9. In FAM, go to the QuickBooks menu and select Update Assets from QuickBooks, then select OK > Yes to All.

Solution 2: Roll FAM back to the appropriate fiscal year, recalculate assets and depreciation in FAM, correct reports as necessary, then roll FAM forward to the current or appropriate fiscal year

  1. Open FAM. From the File menu, select Backup.
  2. Leave the default location and select Backup.
  3. From the File menu, select Client Information.
  4. Go to the Dates tab.
  5. Change the current year to the fiscal year that you are rolling back to and select OK.
  6. From the Tools menu, select Recalculate All Assets > Recalculate all prior depreciation values.
  7. Select OK, then Yes on the backup prompt.
  8. From the Tools menu, select Prepare for next year.
  9. Select Yes. This will roll the program forward one fiscal year.
  10. Continue with steps 8 through 10 until the current fiscal year is displayed.

We are here to help you to rectify all issue with our Pro Advisor’s which are very fast and expert of QuickBooks Support application with our 24×7 support service.

Journal Entry is out of Balance. The Debit and Credit totals must be equal.

Leave a Reply

Your email address will not be published. Required fields are marked *