Monthly Reports - Trial Balance - FY2009.xls

Fund 99 Balance Sheet as of March 31, 2009 Acct No 100-0103 100-0104 100-0105 100-0107 100-0108 100-0109 100-0110 100-0111 100-0112 100-0115 100-0116 100-0118 100-0119 100-0121 100-0122 100-0126 100-0127 100-0128 100-0130 100-0134 100-0140 100-0150 100-0152 100-0155 100-0156 100-0157 100-0158 100-0159 100-0160 100-0161 100-0162 100-0290 100-0291 100-0292 100-0295 100-0406 100-0500 Description Assets (Cash in Bank/Investments) CASH IN OFFICE-SHERIFF CASH IN OFFICE-ANIMAL CONTROL CASH IN OFFICE-TREAS CASH IN OFFICE-SOCIAL SERVICE CASH IN OFFICE-PARKS & RECREATION CASH IN OFFICE-CAFETERIA CITIZENS & FARMER OPERATING C&F DDA-SPECIAL WELFARE 010221130 C&F DDA-SSI RECIPIENTS-0102210501 CITIZENS AND FARMERS-CERT.OF DEPO C&F- SHERIFF FORF. ASSETS ACCOUNT C&F-C/W ATTOR. FORF. ASSETS ACCOUNT C&F - NK SCHOOL NUTIRTION DEPT C & F - CDBG PLUM PT PROGRAM INCOME BANK OF AMERICA - REVENUE RECOVERY EVERGREEN - GENERAL FUND EVERGREEN - GENERAL FUND EVERGREEN - WATER FUND LOCAL GOV'T INVESTMENT POOL (LGIP) RAYMOND JAMES SECURITIES ESCROW DEPOSITS SUNTRUST - BOND CONSTRUCTION FUND BB&T PUB FAC REV BND SER05 SCBUSG SNAP 2006B SUBS (80-14) ELEM PRINC SNAP 2006B SUBS (80-15) ELEM INT SNAP 2007 (80-16) HUMAN SERV BLDG SNAP 2007 (80-17) HUMAN SERV BLDG SNAP 2007 (80-18) HIGH SCHOOL PRIN SNAP 2007 (80-19) HIGH SCHOOL INT SNAP08 (80-20) ROOF/CONV HS. MS PRIN SNAP08 (80-21) ROOF/CONV HS. MS INT ST EDA-SERIES 2006 - PROJECT FUND ST EDA-SERIES 2006 - COST OF ISSUE ST EDA-SERIES 2006 - INT ACCT ST EDA-SERIES 2006 - REBATE FUND USBANK-VRA SERIES 2004- INTEREST SUNTRUST PHASE II & PARHAM IMPROVEMENTS Total Assets (Cash in Bank/Investments) Fund Balances (Cash in Funds/Investments Distributed Among Funds) GENERAL FUND-FUND BALANCE VPA FUND-FUND BALANCE SCHOOL CAPT RENOV FUND BAL ACCOUNT SSI FUND BALANCE SPECIAL WELFARE FUND GRANTS FUND BALANCE CAP IMPROVEMENTS-FUND BALANCE CYSA FUND BALANCE VA WIRELESS E911 FUND BAL ACCOUNT E911 FUND BALANCE SCHOOL FUND-FUND BALANCE LITTER CONTROL FUND BALANCE MEALS TAX-FUND BALANCE DEBT SERVICE-FUND BALANCE AIRPORT - FUND BALANCE WATER FUND BALANCE BOTTOMS BRIDGE SD FUND - FUND BAL ASSET FOREFEITED FUND BALANCE FUND BALANCE-ASSET FORFEIT-COM ATTORNEY CAFETERIA FUND ACCOUNTABILITY SCHOOL CAPITAL FUND UNRESOLVED RECONCILING ITEMS FUND BALANCE ROUTE 155 COMPUTER FUND FUND BALANCE RETURNED CHECK CLEARING BANK RECON BALANCING ENTRY Total Fund Balances (Cash/Investments Distributed Among Funds) Debit Balance 1,000.00 100.00 400.00 100.00 50.00 625.00 19,601,523.23 10,028.38 6,365.95 13,057,274.15 16,457.86 13,678.96 288,837.71 59,187.44 352,783.71 2,421,059.30 389,694.37 313,692.77 3,844.45 227,239.19 614,836.30 255,675.34 148,755.35 102,020.54 82.78 400,536.30 18,980.70 6,068,451.31 73,906.86 2,102.59 80,233.00 0.76 22,513,409.30 67,042,933.60 Credit Balance 300-0001 300-0002 300-0003 300-0004 300-0005 300-0006 300-0007 300-0008 300-0009 300-0010 300-0011 300-0015 300-0020 300-0040 300-0097 300-0098 300-0198 300-0210 300-0220 300-0244 300-0246 300-0300 300-0302 300-0800 300-0801 300-0802 (16,979,028.89) 14,249.75 (5,254,406.52) (6,365.95) (10,028.38) 22,130.70 (9,658,386.40) (80,532.75) (13,173.02) (6,752.78) (838,049.84) (2,333,299.28) 40,185.00 (28,762,060.88) (568,000.72) (16,457.86) (13,678.96) (158,689.81) (82,721.71) (64,705,068.30) Page 1 Fund 99 Balance Sheet as of March 31, 2009 Acct No Description Other Accounts RESERVE FOR PETTY CASH OVERPAYMENTS BANK ACCT ADJUSTMENTS OVER/UNDER PREPAID TAXES TREASURER'S DEFERRED ACCOUNT COMMONWEALTH CURRENT DEBIT ACCOUNT COMMONWEALTH CURRENT CREDIT ACCOUNT RESERVE FOR BOND ACCOUNT RESERVE BEAR ISLAND PROFFERS WATER DEPOSITS ESCROW DEPOSITS PAYABLE RESERVE FOR WATER CHARGES RESERVE FOR SEWER CHARGES RESERVE AIRPORT RENTAL CHARGES CDA TAXES PAID TREAS. UNRECONCILED DIFFERENCES Miscellaneous Holding and Reserve Accounts Miscellaneous Uncollected County Taxes UNCOLLECTED MEALS TAX UNCOLLECTED LODGING TAX UNCOLLECTED ADMISSIONS TAX RESERVE FOR UNCOLLECTED MEALS TAX RESERVE FOR UNCOLLECTED LODGING TAX RESERVE FOR UNCOLLECTED ADMISSIONS TAX UNCOLLECTED FEES -TAX SALE PROPERTY UNCOLLECTED BUSINESS LICENSES RES. FOR UNCOLLECTED BUSINESS LICENSE RES. FOR UNCOLLECTED FEES-LAND SALES RESERVED FOR UNCOLLECTED WATER CHARGE RESERVED FOR UNCOLLECTED SEWER CHARGE RESERVE UNCOLLECTED AIRPORT RENT Uncollected Miscellaneous County Charges Uncollected State Income ES 2007 UNCOLLECTED EST STATE INC ES 2008 UNCOLLECTED EST STATE INC ES 2009 UNCOLLECTED EST STATE INC Uncollected State Income Reserved for Uncollected State Taxes RESERVE FOR UNCOLL STATE TAXES Reserve for Uncollected State Taxes Sheriiff's Fees SHERIFF FEES - STATE RESERVE FOR OTHER STATE COLLECTIONS Sheriff's Fees Possible C/W Reserve From State for PPTRA 2006 COMMONWEALTH REQUEST MADE 2007 COMMONWEALTH REQUEST MADE 2008 COMMONWEALTH REQUEST MADE Possible C/W Reimbursement From State for PPTRA Possible C/W Reserve From State for PPTRA Debit Balance Credit Balance 400-0100 400-0105 400-0106 400-0107 400-0110 400-0115 400-0120 400-0130 400-0140 400-0145 400-0150 400-0155 400-0160 400-0165 400-0170 400-0175 400-9999 (2,268.37) 46.08 30.76 (27,758.00) 30.00 698.00 (57,450.00) (625.00) 9,288,079.53 1,669,422.93 (15,594.35) (2,248,576.78) (1,922.40) 8,604,112.40 500-0010 500-0011 500-0012 500-0019 500-0020 500-0021 500-0040 500-0050 500-0155 500-0158 500-0190 500-0195 500-0200 20,952.09 (12.23) (20,952.09) 12.23 (231.98) 21,197.41 (21,197.41) 231.98 (9,288,149.12) (1,669,422.93) 15,594.35 (10,941,977.70) 502-2007 502-2008 502-2009 (13,076.16) (341,734.48) 487.00 (354,323.64) 503-9999 354,323.64 354,323.64 504-0003 504-9999 8,536.69 8,536.69 (8,536.69) (8,536.69) 511-2006 511-2007 511-2008 (3,117.16) (3,403.36) 2,214,061.21 2,207,540.69 (2,207,540.69) 511-9999 Page 2 Fund 99 Balance Sheet as of March 31, 2009 Acct No Uncollected Real Estate 1987 UNCOLLECTED REAL 1988 UNCOLLECTED REAL 1989 UNCOLLECTED REAL 1990 UNCOLLECTED REAL 1991 UNCOLLECTED REAL 1992 UNCOLLECTED REAL 1993 UNCOLLECTED REAL 1994 UNCOLLECTED REAL 1995 UNCOLLECTED REAL 1996 UNCOLLECTED REAL 1997 UNCOLLECTED REAL 1998 UNCOLLECTED REAL 1999 UNCOLLECTED REAL 2000 UNCOLLECTED REAL 2001 UNCOLLECTED REAL 2002 UNCOLLECTED REAL 2003 UNCOLLECTED REAL 2004 UNCOLLECTED REAL 2005 UNCOLLECTED REAL 2006 UNCOLLECTED REAL 2007 UNCOLLECTED REAL 2008 UNCOLLECTED REAL Taxes ESTATE ESTATE ESTATE ESTATE ESTATE ESTATE ESTATE ESTATE ESTATE ESTETE ESTATE ESTATE ESTATE ESTATE ESTATE ESTATE ESTATE ESTATE ESTATE ESTATE ESTATE ESTATE Description Debit Balance Credit Balance 600-1987 600-1988 600-1989 600-1990 600-1991 600-1992 600-1993 600-1994 600-1995 600-1996 600-1997 600-1998 600-1999 600-2000 600-2001 600-2002 600-2003 600-2004 600-2005 600-2006 600-2007 600-2008 TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX Uncollected Real Estate Taxes 170.56 153.18 153.18 661.74 1,035.66 1,035.66 1,035.66 1,129.96 1,310.36 1,564.56 1,027.81 1,311.67 1,616.23 2,326.55 3,282.68 6,466.87 12,579.10 75,801.93 220,767.56 793,791.87 1,127,222.79 (1,127,222.79) (1,127,222.79) 600-9999 RESERVE/UNCOLLECTED REAL ESTATE TAX Reserve for Uncollected Real Estate Taxes 610-2000 610-2001 610-2002 610-2003 610-2004 610-2005 610-2006 610-2007 610-2008 Uncollected Public Service Taxes PUBLIC SERVICE UNCOLL 2000 PUBLIC SERVICE UNCOLL 2001 PUBLIC SERVICE UNCOLL 2002 PUBLIC SERVICE UNCOLL 2003 PUBLIC SERVICE UNCOLL 2004 PUBLIC SERVICE UNCOLL 2005 PUBLIC SERVICE UNCOLL 2006 PUBLIC SERVICE UNCOLL 2007 PUBLIC SERVICE UNCOLL 2008 Uncollected Public Service Taxes 13.12 1,138.04 2,769.72 3,920.88 (3,920.88) (3,920.88) 569.50 569.50 10,273.70 610-9999 RESERVE FOR UNCOLL PUBLIC SERV TAX Reserve For Uncollected Public Service Taxes 650-2004 650-2005 650-2006 650-2007 650-2008 650-9999 RECEIVABLES UNCOLL TAX-SD B/BRIDGE RECEIVABLES UNCOLL TAX-SD B/BRIDGE RECEIVABLES UNCOLL TAX-SD B/BRIDGE RECEIVABLES UNCOLL TAX-SD B/BRIDGE RECEIVABLES UNCOLL TAX-SD B/BRIDGE RESERVE FOR UNCOLL TAX-SD B/BRIDGE Bottom's Bridge Service District 11,412.70 (11,412.70) (11,412.70) Page 3 Fund 99 Balance Sheet as of March 31, 2009 Acct No 700-2002 700-2003 700-2004 700-2005 700-2006 700-2007 700-2008 Description Uncollected Personal Property Taxes 2002 UNCOLLECTED PERSONAL PROP TAX 2003 UNCOLLECTED PERSONAL PROP TAX 2004 UNCOLLECTED PERSONAL PROPERTY 2005 UNCOLLECTED PERSONAL PROP TAX 2006 UNCOLLECTED PERSONAL PROP TAX 2007 UNCOLLECTED PERSONAL PROP TAX 2008 UNCOLLECTED PERSONAL PROP TAX Uncollected Personal Property Taxes Debit Balance (286.44) 64,637.24 85,844.98 76,888.66 109,937.68 2,488,800.54 2,825,822.66 Credit Balance 700-9999 RESERVE/UNCOLLECTED PERS PROP TAX Total Reserve for Uncollected Pers Prop Tax (2,825,822.66) (2,825,822.66) - 711-0000 711-2000 711-2001 711-2002 711-2003 711-2004 711-2005 711-2006 711-2007 711-2008 711-9999 Request Request Request Request Request Request Request Request Request Request Request C/W C/W C/W C/W C/W C/W C/W C/W C/W C/W C/W Reserve-2000 Reimbursement 2000 Reimbursement 2001 Reimbursement 2002 Reimbursement 2003 Reimbursement 2004 Reimbursement 2005 Reimbursement 2006 Reimbursement 2007 Reimbursement 2008 Reserve-All Years 73,581,713.65 234.94 (3,117.16) (3,403.36) 107,072.06 (100,786.48) (73,581,713.65) Page 4

Related docs
TRIAL BALANCE SHEETS FOR
Views: 83  |  Downloads: 1
IC Trial Balance Reconciliation Certification
Views: 1  |  Downloads: 0
Trust Fund Monthly Reports Draft[955]
Views: 0  |  Downloads: 0
Trust Fund Monthly Reports Draft[502]
Views: 0  |  Downloads: 0
Trust Fund Monthly Reports Draft[614]
Views: 0  |  Downloads: 0
Trust Fund Monthly Reports Draft[964]
Views: 0  |  Downloads: 0
Monthly Financial Reports
Views: 1  |  Downloads: 0
Trust Fund Monthly Reports Draft[482]
Views: 0  |  Downloads: 0
Trust Fund Monthly Reports Draft[629]
Views: 0  |  Downloads: 0
Trust Fund Monthly Reports Draft[456]
Views: 0  |  Downloads: 0
Trust Fund Monthly Reports Draft[191]
Views: 1  |  Downloads: 0
Trust Fund Monthly Reports Draft[206]
Views: 0  |  Downloads: 0
Trust Fund Monthly Reports Draft[600]
Views: 0  |  Downloads: 0
Other docs by james hardy
Bay Area Multimedia Inc Ammendments and By laws
Views: 154  |  Downloads: 0
Letter of Intent for Joint Venture
Views: 2065  |  Downloads: 221
Form I-9 Employment Eligibility Verification
Views: 521  |  Downloads: 9
Agreement-Trademark Assignment
Views: 510  |  Downloads: 20
3-D Scanner Competition
Views: 226  |  Downloads: 1
ADDRESS BOOK
Views: 521  |  Downloads: 16
Halliburton Co Ammendments and Bylaws
Views: 135  |  Downloads: 0
randolph-all
Views: 545  |  Downloads: 1
Estee Lauder Cos Inc Ammendments and Bylaws
Views: 170  |  Downloads: 0
Demand For Payment
Views: 263  |  Downloads: 6
Notice to Officer of Removal By Board
Views: 198  |  Downloads: 3