Balance Sheet
Assets
Acc #
1000
xxx
xxx
xxx
xxx
xxx
xxx
Balance Sheet - Formate
Total
Liabilities and Equ
Current Asset
Acc #
Checking Acct (Cash In Bank)
Petty Cash:
Biz Checking:
Internal Dummy Bank:
Chase:
Rock Canyon Bank - Business Checking Account #-:
Chase Bank - Jason Berry Personal Acc. # 7042:
($43,554.08)
($199,064.02)
($780,494.74)
$5,040,868.21
($77,782.67)
($19,855.00)
Total Banks:
($325,552.14)
1140 Accounts Receivables:
1150 Other Receivables:
$1,810,084.36
$1,906.29
Total Accounts Receivable
Stock Inventory
1450 Inventory:
1460 Recon Expenses:
Total Stock Inventory:
Total Current Assets
Total Fixed Assets:
Total Asset:
$1,811,990.65
$9,907,727.21
$465,306.77
$10,373,033.98
-
$11,859,472.49
$0.00
2001
$11,859,472.49
-
xxx-
- Formate
Liabilities and Equity
Total
Current Liability
Credit Card:
Chase CC M. Rodriguez # 6518:
Chase CC Jason Berry # 8823:
Chase CC Jason Berry # 6658:
Chase CC T. Tan # 3796:
Chase CC M. Spencer # 6385:
Chase CC Jason Berry # 8076:
Chase CC D. Turner # 0644:
Chase Gas CC #0458:
Chase CC L. Warby # 9596:
Chase CC M. Sorenson #3210:
Chase CC Jacob Berry # 0777:
Chase CC E. Schofield # 9226:
Chase CC B. Thurgood # 0636:
Chase CC R. Sandmire #6972:
Total Credit Card
A/P Vehicle Purchases:
($2,045.30)
($142,515.97)
($877,227.02)
($125,995.25)
($27,031.20)
($213,424.76)
($32,406.61)
($40,895.73)
($76,386.76)
($2,522.35)
($14,793.47)
($556,113.99)
($15,453.26)
($433.54)
($2,127,245.21)
$1,551,093.41
A/P Vehicle Consignment:
A/P Vendor:
State Tax & DMV Fees:
A/P - Svc Contract & GAP:
Existing Lien Payable:
$90,452.32
$1,396.34
$451,864.38
$241,517.48
$54,187.36
Total Accounts Payable
$2,390,511.29
Total Current Liability
Equity
$263,266.08
Opening Balance Equity
Retained Earnings
Net Income
Total Equity
Total Liability & Equity
Total Difference:
0
$4,450,734.80
$4,654,545.89
$11,495,791.98
$11,759,058.06
Trial Balance
Code-
Name of Accounts
Checking Acct (Cash In Bank)
Accounts Receivables
Other Receivables
Inventory
Recon Expenses
Curtailment Expense
Floorplan Expense
A/P Vehicle Purchases
A/P Vehicle Consignment
A/P Vendor
State Tax & DMV Fees
A/P - Svc Contract & GAP
Existing Lien Payable
Trade-In Adjustment (Trade Allowance - ACV) CGS
Retained Earnings
ADVERTISING
BANK CHARGES
REPAIRS & MAINTENANCE
MEALS & ENTERTAINMENT
OFFICE SUPPLIES
OTHER OFFICE EXPENSES
UTILITIES
TRAVEL & LODGING
DEALERSHIP SUPPLIES
INSURANCE
LEGAL AND PROFESSIONAL FEE
LICENSE AND PERMITS
OUTSIDE SERVICES
PAYROLL TAXES
PAYROLL EXPENSES
REFUND & RETURNS
SOFTWARE & SUPPORT
MISCELLANEOUS EXPENSE
FUEL EXPENSE
OTHER INCOME
INSURANCE - OTHER
LOAN
SMALL TOOLS & OTHER SUPPLIES
TAX FEDERAL
EMPLOYEE BENEFITS
SALARIES, WAGES & COMMISSIONS
ARBITRATED VEHICLES
Sales - Retail
Sales - Wholesale
Account Details
Cash & Bank
A/R
A/R
Inventory
Inventory
Inventory
Inventory
A/P
A/P
A/P
A/P
A/P
A/P
Cost of Goods Sold
Equity
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Income
Income
Debit
$4,976,045.95
$1,906.29
$12,941,442.95
$684,312.02
$12,071.06
$5,027.38
$30,841.12
$670.12
-
-
Sales - Internal
Service Contract
GAP
Optional VSI
VTR
VSC
Other Fee 1 Income
Vehicle Credits
Income - Fees/Tax Overpayment
Dealer Reserve Income
FP Cost
Auto Repairs & Parts
Curtailment Cost
Consignment Cost
RO Part Cost
Write-Off Losses
Write-Off FeeTax Losses
Deal Discounts
Vehicle Purchases
Service Contract
GAP
Optional VSI
VTR
VSC
RO Part Income
RO Service Income
Arbitrated Exepenses
Other Income - Doc Prep Fee
ADVERTISING
BANK CHARGES
REPAIRS & MAINTENANCE
MEALS & ENTERTAINMENT
POSTAGE AND DELIVERY
OFFICE SUPPLIES
OTHER OFFICE EXPENSES
BAD DEBT
UTILITIES
TRAVEL & LODGING
TELEPHONE & CELL
RENT
COMPANY SUBCONTRACTORS & DAILY LABOR
CONTRIBUTIONS
DEALERSHIP SUPPLIES
DUES & MEMBERSHIP
INSURANCE
INSPECTION AND FEES
LEGAL AND PROFESSIONAL FEE
Income
Income
Income
Income
Income
Income
Other Income
Other Income
Other Income
Other Income
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
RO Income
RO Income
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
$281,808.23
$6,802,181.00
$370,606.03
$43,239.78
$1,396.34
$8,809.28
$120.00
$276,559.02
$110,527,685.22
$2,263,200.00
$371,111.05
$11,850.00
$255,819.00
$22,617.00
$37,769.99
$917,562.79
$36,267.74
$116,031.66
$79,227.21
$22,704.25
$85,753.01
$193,629.34
$13.41
$154,640.45
$52,088.12
$8,473.64
$56,710.00
$17,447.94
$500.00
$108,476.91
$14,349.09
$136,056.43
$18,325.15
$51,363.01
-
LICENSE AND PERMITS
OUTSIDE SERVICES
PAYROLL TAXES
PAYROLL EXPENSES
REFUND & RETURNS
SOFTWARE & SUPPORT
MISCELLANEOUS EXPENSE
FUEL EXPENSE
MORTGAGE
OTHER INCOME
TAX - LOCAL GOVT.
COMMISSIONS
INSURANCE - HEALTH
INSURANCE - OTHER
INTEREST - LOAN
LOAN
MEMBERSHIPS, DUES & PUBLICATIONS
SMALL TOOLS & OTHER SUPPLIES
TAX FEDERAL
TAX STATE
TAX - OTHER
TAX - REAL ESTATE
UNIFORMS & LAUNDRY
EMPLOYEE BENEFITS
DATA PROCESSING
DELIVERY EXPENSE
INVESTMENTS
SALARIES, WAGES & COMMISSIONS
ARBITRATED VEHICLES
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
Administrative Expense
$114,474.74
$186,431.58
$1,008,689.39
$5,528,092.59
$1,080,350.29
$279,157.83
$301,525.32
$74,863.81
$254,079.95
$1,612.22
$28,026.34
$9,822.70
$133,920.95
$187,472.27
$39.00
$48,198.78
$13,419.34
$326,443.06
$7.61
$6,506.50
$109,219.42
$32,733.82
$16,668.76
$2,810.11
$1,193.34
$11,503.21
$6,508.80
$1,510,703.62
$400,680.10
Credit
$2,449,644.74
$2,456,713.24
$116,955.32
$1,396.34
$374,912.68
$300,418.48
$106,507.37
$1,011.77
$12,584.26
$1,544.19
$6.13
$233.00
$1,450.45
$145.07
$54.23
$811.00
$29.70
$26.12
$455.00
$165.00
$55.39
$11,137.61
$446,766.50
$25.74
$12,208.52
$56.62
$502,277.71
$480.03
$524.34
$8,574.85
$321.71
$1,183.00
$2,212.34
$343,951.09
$118,892,843.46
$12,257,496.13
$88,001.32
$5,415,024.30
$1,384,596.50
$30,022.00
$1,710,697.38
$66,286.00
$254,991.65
$46,672.17
$2,388.71
$1,578,840.46
$1,396.34
$509.95
$4,132,236.37
-
-
Trial Balance
Code-
Name of Accounts
Checking Acct (Cash In Bank)
Accounts Receivables
Other Receivables
Inventory
Recon Expenses
Curtailment Expense
Floorplan Expense
A/P Vehicle Purchases
A/P Vehicle Consignment
A/P Vendor
State Tax & DMV Fees
A/P - Svc Contract & GAP
Existing Lien Payable
Trade-In Adjustment (Trade Allowance - ACV) CGS
Retained Earnings
ADVERTISING
BANK CHARGES
REPAIRS & MAINTENANCE
MEALS & ENTERTAINMENT
OFFICE SUPPLIES
OTHER OFFICE EXPENSES
UTILITIES
TRAVEL & LODGING
DEALERSHIP SUPPLIES
INSURANCE
LEGAL AND PROFESSIONAL FEE
LICENSE AND PERMITS
OUTSIDE SERVICES
PAYROLL TAXES
PAYROLL EXPENSES
REFUND & RETURNS
SOFTWARE & SUPPORT
MISCELLANEOUS EXPENSE
FUEL EXPENSE
OTHER INCOME
INSURANCE - OTHER
LOAN
SMALL TOOLS & OTHER SUPPLIES
TAX FEDERAL
EMPLOYEE BENEFITS
SALARIES, WAGES & COMMISSIONS
ARBITRATED VEHICLES
Account Details
Cash & Bank
A/R
A/R
Inventory
Inventory
Inventory
Inventory
A/P
A/P
A/P
A/P
A/P
A/P
Cost of Goods Sold
Equity
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Other Income
Debit
$4,976,045.95
$1,906.29
$12,941,442.95
$684,312.02
$12,071.06
$5,027.38
$30,841.12
$670.12
-
-
Sales - Retail
Sales - Wholesale
Sales - Internal
Service Contract
GAP
Optional VSI
VTR
VSC
Other Fee 1 Income
Vehicle Credits
Income - Fees/Tax Overpayment
Dealer Reserve Income
FP Cost
Auto Repairs & Parts
Curtailment Cost
Consignment Cost
RO Part Cost
Write-Off Losses
Write-Off FeeTax Losses
Deal Discounts
Vehicle Purchases
Service Contract
GAP
Optional VSI
VTR
VSC
RO Part Income
RO Service Income
Arbitrated Exepenses
Other Income - Doc Prep Fee
ADVERTISING
BANK CHARGES
REPAIRS & MAINTENANCE
MEALS & ENTERTAINMENT
POSTAGE AND DELIVERY
OFFICE SUPPLIES
OTHER OFFICE EXPENSES
BAD DEBT
UTILITIES
TRAVEL & LODGING
TELEPHONE & CELL
RENT
COMPANY SUBCONTRACTORS & DAILY LABOR
CONTRIBUTIONS
DEALERSHIP SUPPLIES
DUES & MEMBERSHIP
INSURANCE
Income
Income
Income
Income
Income
Income
Income
Income
Other Income
Other Income
Other Income
Other Income
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
Cost of Goods Sold
RO Income
RO Income
$281,808.23
$6,802,181.00
$370,606.03
$43,239.78
$1,396.34
$8,809.28
$120.00
$276,559.02
$110,527,685.22
$2,263,200.00
$371,111.05
$11,850.00
$255,819.00
$22,617.00
$37,769.99
$917,562.79
$36,267.74
$116,031.66
$79,227.21
$22,704.25
$85,753.01
$193,629.34
$13.41
$154,640.45
$52,088.12
$8,473.64
$56,710.00
$17,447.94
$500.00
$108,476.91
$14,349.09
$136,056.43
-
INSPECTION AND FEES
LEGAL AND PROFESSIONAL FEE
LICENSE AND PERMITS
OUTSIDE SERVICES
PAYROLL TAXES
PAYROLL EXPENSES
REFUND & RETURNS
SOFTWARE & SUPPORT
MISCELLANEOUS EXPENSE
FUEL EXPENSE
MORTGAGE
OTHER INCOME
TAX - LOCAL GOVT.
COMMISSIONS
INSURANCE - HEALTH
INSURANCE - OTHER
INTEREST - LOAN
LOAN
MEMBERSHIPS, DUES & PUBLICATIONS
SMALL TOOLS & OTHER SUPPLIES
TAX FEDERAL
TAX STATE
TAX - OTHER
TAX - REAL ESTATE
UNIFORMS & LAUNDRY
EMPLOYEE BENEFITS
DATA PROCESSING
DELIVERY EXPENSE
INVESTMENTS
SALARIES, WAGES & COMMISSIONS
ARBITRATED VEHICLES
$18,325.15
$51,363.01
$114,474.74
$186,431.58
$1,008,689.39
$5,528,092.59
$1,080,350.29
$279,157.83
$301,525.32
$74,863.81
$254,079.95
$1,612.22
$28,026.34
$9,822.70
$133,920.95
$187,472.27
$39.00
$48,198.78
$13,419.34
$326,443.06
$7.61
$6,506.50
$109,219.42
$32,733.82
$16,668.76
$2,810.11
$1,193.34
$11,503.21
$6,508.80
$1,510,703.62
$400,680.10
Reconciliation of Reports (Draft working)
Credit
$2,449,644.74
$2,456,713.24
$116,955.32
$1,396.34
$374,912.68
$300,418.48
$106,507.37
$1,011.77
$12,584.26
$1,544.19
$6.13
$233.00
$1,450.45
$145.07
$54.23
$811.00
$29.70
$26.12
$455.00
$165.00
$55.39
$11,137.61
$446,766.50
$25.74
$12,208.52
$56.62
$502,277.71
$480.03
$524.34
$8,574.85
$321.71
$1,183.00
$2,212.34
$343,951.09
Other Income
2729 - REFUND & RETURNS:
2734 - OTHER INCOME:
9070 - Other Income - Doc Prep Fee:
2728 - PAYROLL EXPENSES:
2744 - INSURANCE - OTHER:
2749 - LOAN:
3760 - Other Fee 1 Income:
2707 - OFFICE SUPPLIES:
2711 - TRAVEL & LODGING:
2727 - PAYROLL TAXES:
2730 - SOFTWARE & SUPPORT:
2755 - SMALL TOOLS & OTHER SUPPLIES:
2770 - SALARIES, WAGES & COMMISSIONS:
2703 - REPAIRS & MAINTENANCE:
2704 - MEALS & ENTERTAINMENT:
2757 - TAX FEDERAL:
2701 - ADVERTISING:
2708 - OTHER OFFICE EXPENSES :
2731 - MISCELLANEOUS EXPENSE:
2732 - FUEL EXPENSE:
3870 - Dealer Reserve Income:
2702 - BANK CHARGES:
2710 - UTILITIES:
2718 - DEALERSHIP SUPPLIES:
2721 - INSURANCE:
2724 - LEGAL AND PROFESSIONAL FEE:
3821 - Vehicle Credits:
3822 - Income - Fees/Tax Overpayment:
$118,892,843.46
$12,257,496.13
$88,001.32
$5,415,024.30
$1,384,596.50
$30,022.00
$1,710,697.38
$66,286.00
$254,991.65
$46,672.17
$2,388.71
$1,578,840.46
$1,396.34
$509.95
$4,132,236.37
-
-
$339,343.36
$452,207.75
$2,734,841.99
$10,732.49
$480.03
$524.34
$254,991.65
$233.00
$54.23
$55.39
$25.74
$5,564.81
$2,212.34
$1,544.19
$1.00
$321.71
$1,011.77
$1,450.45
$8,279.43
$56.62
$1,047,410.13
$12,584.26
$145.07
$811.00
$29.70
$26.12
$23,210.60
$342.96
$4,898,492.13
2702 - BANK CHARGES:
2710 - UTILITIES:
2718 - DEALERSHIP SUPPLIES:
2721 - INSURANCE:
2724 - LEGAL AND PROFESSIONAL FEE:
3821 - Vehicle Credits:
3822 - Income - Fees/Tax Overpayment:
2728 - PAYROLL EXPENSES:
2744 - INSURANCE - OTHER:
2749 - LOAN:
3760 - Other Fee 1 Income:
2703 - REPAIRS & MAINTENANCE:
2704 - MEALS & ENTERTAINMENT:
2757 - TAX FEDERAL:
2701 - ADVERTISING:
2708 - OTHER OFFICE EXPENSES :
2731 - MISCELLANEOUS EXPENSE:
2732 - FUEL EXPENSE:
3870 - Dealer Reserve Income:
2729 - REFUND & RETURNS:
2734 - OTHER INCOME:
9070 - Other Income - Doc Prep Fee:
2707 - OFFICE SUPPLIES:
2711 - TRAVEL & LODGING:
2727 - PAYROLL TAXES:
2730 - SOFTWARE & SUPPORT:
2755 - SMALL TOOLS & OTHER SUPPLIES:
2770 - SALARIES, WAGES & COMMISSIONS: