Saving the Account Balances of the Trial Balance as Values

The formulas in worksheet 21 — Trial Balances Data are saved until the Financial Statements reports are finalized. They are automatically updated either when a new adjustment is made, or when one or more adjustments is being updated (if you use the SUMIF formula technique explained on page 39, Chapter 2, Adjusting the Trial Balance or the Consolidating technique on page 40, Chapter 2, Adjusting the Trial Balance).

To delete the formulas after you have finalized the Financial Statements reports, return to worksheet 21 — Trial Balances Data, copy column BX and then paste it back as values only into the same column.

0 0

Post a comment