Enter 12/31/2020 Balances in Trial Balance Excel Worksheet
Budget: $250 – $750 USD
1. Zero out all of the amounts entered on each of the GL accounts under the "UNADJ 12/31/2020" column. Don't erase/change the amounts in the subtotals cells (they have formulas needed to balance the trial balance).
2. Enter the 12/31/2020 balance from one trial balance template into a new excel trial balance template.
Note:
Note: There are new GL accounts in 2020 TB provided by client that are not in my 2020 working TB. Do not enter the new accounts in the 2020 working trial balance template, just highlight them.
2. Enter the 12/31/2020 balance from one trial balance template into a new excel trial balance template.
Note:
Note: There are new GL accounts in 2020 TB provided by client that are not in my 2020 working TB. Do not enter the new accounts in the 2020 working trial balance template, just highlight them.