Drake Tax - Balance Sheet and Auto-balance
Article #: 14952
Last Updated: October 18, 2024
Overview
Drake Tax provides an auto-balance feature to assist in completing the Balance Sheet of business returns. This feature affects the following lines, according to business type:
Form | Line # | Line Name |
---|---|---|
1120 | 25 | Retained earnings - Unappropriated |
1120-C | 25 | Retained earnings - Unappropriated |
1120-S | 24 | Retained earnings |
1065 | 21 | Partner's capital accounts |
990 | 33 | Total net assets or fund balances |
990-EZ | 27 | Net assets or fund balances |
990-PF | 29 | Total net assets or fund balances |
When a difference exists between the total assets and the total liabilities and capital of the Balance Sheet, the auto-balance feature will automatically adjust the respective line to account for the difference.
For example, if the assets entered on the balance sheet totaled $5,000, and the liabilities and capital entered on the balance sheet totaled $2,000, the auto-balance feature would adjust the applicable line by $3,000, in order to make the total assets and total liabilities equal, or balanced.
Changes
If the amount needs to be changed use the following options.
Turn off the auto-balance feature:
-
There is a global setup option to turn off auto-balance. If you want to turn off auto-balance globally for all returns, go to Setup > Options > Calculation & View/Print tab > Turn off auto-balance of the balance sheet. If this is not checked, turn off the auto-balance on a single return by going to the PRNT screen and checking the box Reverse autobalance setup option.
Return to View/Print mode, and review the totals of the assets section and the liabilities and capital section of the balance sheet. Once you have determined which of the two totals, or if both of the totals, are incorrect:
-
Review the individual line items on the Schedule L in order to determine what line item(s) need to be corrected or added in Data Entry (you may need to consult the organization’s books for confirmation of the amounts to be reported). A few of the more common factors that could result in unexpected amounts on the Schedule L line items include, but are not limited to:
-
Amounts overridden or removed from screen L (in the 1120-S and 1065 return), L2 (in the 1120 return), or 10B (in the 990 return), in Data Entry.
-
An asset may have been deleted from screen 4562, instead of being reported as sold;
-
Inventory amounts reported incorrectly on the Schedule A.
-
-
Determine the correct amount to report on the “Unappropriated retained earnings,” “Retained earnings,” or “Partners’ capital accounts” line(s), as appropriate for the return being prepared. Once you have determined the correct amount, return to Data Entry, and use the balance sheet screen to enter the amount:
-
1120: use screen L2
-
1120-S: use screen L
-
1065: use screen L
-
990/990-EZ/990-PF: use screen 10B
Tip The amount of "total net assets or fund balances" on the 990 Balance Sheet is the total of items reported on either: line 27-29, or lines 30-32. There is no direct entry or override field for line 33.
-
Caution When the auto-balance feature is active, the above lines cannot be overridden in Data Entry of the business return. The auto-balance feature must be turned off in order to directly enter an amount for those lines.
Note 303 generates on the NOTES page in View/Print mode of the 1120, 1120-S, and 1065 returns when the auto-balance feature makes an automatic adjustment.