Edit the Chart of Accounts and enter opening balances as follows.
Add the following information to the Chart of Accounts.
Account Checking
Account No. 10100
Account Cleaning Supplies
Account No. 13000
Account Type Other Current Asset
Account Description Cleaning Supplies
Tax Line Unassigned
Account Cleaning Equipment
Account No. 14400
Account Type Fixed Asset
Account Description Cleaning Equipment
Tax Line Unassigned
Account Cleaning Equipment Cost
Account No. 14500
Account Type Fixed Asset
Account Description Cleaning Equipment Cost
Subaccount of 14400 Cleaning Equipment
Tax Line Unassigned
Account Cleaning Equipment Acc Depr
Account No. 14600
Account Type Fixed Asset
Account Description Cleaning Equipment Accumulated
Depreciation
Subaccount of 14400 Cleaning Equipment
Tax Line Unassigned
Account Accounts Payable
Account No. 21000
Account Type Accounts Payable
Account Description Accounts Payable
Tax Line Unassigned
Account Supplies Expense
Account No. 64800
Account Type Expense
Account Description Supplies Expense
Tax Line Schedule C: Supplies (not from COGS)
Export to Excel the Chart of Accounts (Account Listing) as of January 1, 2023. (Report Center > List > Account Listing.) When exporting to Excel, remember to select Advanced Excel Options:
1. Uncheck Space between columns
2. Check Row height
3. Uncheck Include QuickBooks Export Guide worksheet with helpful advice
4. Select On printed report and screen