Logos Accounting Sample Reports General Ledger Reports printed from the GL Reports menu are useful in monitoring the financial status of your organization.
Chart of Accounts April 11, 2006 Page 1 GL Account Number 1000-000-00 1010-000-00 1010-000-01 1090-000-00 1100-000-00 1100-000-01 1105-000-00
Account Description (* Prefix if Title) * Checking Accounts Checking Account Checking Account - Building Fund * Petty Cash Accounts Petty Cash Petty Cash - Building Fund Petty Cash2
Type Subtotal ActiveSummaryPayroll A 10 Yes No No A 10 Yes Yes No A 10 Yes No No A 20 Yes No No A 20 Yes No No A 20 Yes No No A 20 Yes No No
1200-000-00 1210-000-01 1210-000-00
* Savings Accounts Savings - Building Fund Savings Account
AL AL AL
30 Yes 30 Yes 30 Yes
No No No
No No No
1270-000-00 1850-000-00
Certificates of Deposit Securities
AO AO
30 Yes 30 Yes
No No
No No
No No No No No No No No No No No No No No Yes No
Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No
2000-000-00 2010-000-00 2090-000-00 2100-000-00 2110-000-00 2140-000-00 2150-000-00 2160-000-00 2170-000-00 2180-000-00 2190-000-00 2191-000-00 2195-000-00 2200-000-00 2300-000-00 2400-000-00
* Payroll Liabilities Accrued Payroll Miscellaneous Withholding Federal Payroll Taxes State Payroll Taxes FICA Medicare FUTA SUI SDI STT Workers Comp Ins TSA * Other Liabilities Accounts Payable Other Current Liabilities
L L L L L L L L L L L L L L L L
40 40 40 40 40 40 40 40 40 40 40 40 40 42 42 42
Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
2500-000-00 2510-000-00 2550-000-00
* Long Term Liabilities Mortgage Loan for Bus
LL LL LL
45 Yes 45 Yes 45 Yes
No No No
No No No
2600-000-00 2610-000-01 2620-000-02 2630-000-03 2640-000-04 2650-000-05
* Funds Building Fund Camp Mission Cemetery Preschool
LF LF LF LF LF LF
48 48 48 48 48 48
Yes Yes Yes Yes Yes Yes
No No No No No No
No No No No No No
2660-000-06
Homeless Shelter
LT
48 Yes
No
No
3000-000-00
General Fund Balance Account
F
0 Yes
No
No
I I I
50 Yes 50 Yes 50 Yes
No No No
No No No
4000-000-00 4010-000-03 4010-000-00
* Contributions Offerings - Missions Offerings
Trial Balance Summary Logos Fiscal Year 2006, Period 4 (04/01/2006) to 4 (04/30/2006) Gl Account #
Description
1010-000-00
Checking Account
1010-000-01
Checking Account - Building Fund
1100-000-00
Petty Cash
1210-000-00
Savings Account
1270-000-00
Certificates of Deposit
1850-000-00
Securities
2100-000-00
Federal Payroll Taxes
2110-000-00
Page 1
Begin Balance
Debit
Credit
End Balance
16,620.00
2,500.00
35,787.67
-16,667.67
0.00
0.00
48.32
-48.32
125.00
0.00
0.00
125.00
9,500.00
300.00
0.00
9,800.00
25,000.00
0.00
0.00
25,000.00
100,000.00
0.00
0.00
100,000.00
-120.00
634.21
1,472.27
-958.06
State Payroll Taxes
0.00
75.67
194.42
-118.75
2140-000-00
FICA
0.00
971.44
2,138.18
-1,166.74
2150-000-00
Medicare
0.00
227.18
500.04
-272.86
2160-000-00
FUTA
0.00
62.05
136.44
-74.39
2170-000-00
SUI
0.00
85.33
187.63
-102.30
2180-000-00
SDI
0.00
69.82
153.53
-83.71
2190-000-00
STT
0.00
7.76
67.06
-59.30
2191-000-00
Workers Comp Ins
0.00
0.00
27.00
-27.00
2195-000-00
TSA
0.00
0.00
136.70
-136.70
2300-000-00
Accounts Payable
2400-000-00
Other Current Liabilities
2510-000-00 2550-000-00
-280.00
1,577.10
1,297.10
0.00
-9,500.00
0.00
0.00
-9,500.00
Mortgage
-69,720.00
0.00
0.00
-69,720.00
Loan for Bus
-25,000.00
0.00
0.00
-25,000.00
2610-000-01
Building Fund
-16,000.00
0.00
0.00
-16,000.00
2620-000-02
Memorials Fund
-13,550.00
0.00
0.00
-13,550.00
2630-000-03
Missions Fund
1,050.00
0.00
0.00
1,050.00
2650-000-05
Designated Missions Fund
-10,000.00
0.00
0.00
-10,000.00
3000-000-00
General Fund Balance Account
-4,585.00
0.00
0.00
-4,585.00
4010-000-00
Offerings
-4,450.00
0.00
2,500.00
-6,950.00
5120-000-00
Domestic Missions
610.00
495.80
0.00
1,105.80
5130-000-00
World Missions
0.00
280.00
0.00
280.00
5510-000-00
Salaries
0.00
25,118.34
50.00
25,068.34
5520-000-00
Employer FICA/Medicare -
0.00
654.02
0.00
654.02
5530-000-00
Employer FICA/Medicare - Workers
0.00
1,006.22
0.00
1,006.22
5600-000-00
Employee Benefits
5710-000-00
Office Supplies
5740-000-00
0.00
2,300.00
75.00
2,225.00
300.00
624.25
0.00
924.25
Bulletins
0.00
200.00
0.00
200.00
5750-000-00
Resources/Curriculum
0.00
48.32
0.00
48.32
5830-000-00
Building Maintenance
0.00
347.85
0.00
347.85
6200-000-00
Miscellaneous Expenses
0.00
7,186.00
0.00
7,186.00
0.00
44,771.36
44,771.36
0.00
Grand Total
37 Records Selected
Trial Balance Detail Logos Fiscal Year 2006, Period 4 (04/01/2006) to 4 (04/30/2006) GL Account # Date 1010-000-00
Description Jrnl Acct Check/Deposit # Checking Account
1010-000-01 04/10/2006
Checking Account - Building Fund AP
1100-000-00
2 1
Certificates of Deposit
1850-000-00
Securities
2100-000-00 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 2110-000-00 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006
1572 1573 1574 1575 1576 1578 1579 1581 1583 EFT 41 902000401830001 5702 5703 5704 5705 5706 5708 5709 5711 5713
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1572 1574 1576 1578 1579 1581 1583 EFT 42 902000401830001 5702 5704 5706 5708 5709 5711 5713
1 1 1 1 1 1 1 1
1572 1573 1574 1575 1576 1577 1578 1579
-48.32 -48.32
0.00
0.00
125.00
300.00
0.00
9,800.00 300.00
25,000.00
0.00
0.00
25,000.00
100,000.00
0.00
0.00
100,000.00
634.21
1472.27
-958.06
-120.00 Bertram Bascom Chauncey C Calderwood Fred Foster Gabriel Galliano Harriet H Harrison Jeremy J Johnson Katherine Kleghorn Melanie Mueller Oscar O Orozco Citzens State Bank Barbara Baker Bertram Bascom Chauncey C Calderwood Fred Foster Gabriel Galliano Harriet H Harrison Jeremy J Johnson Katherine Kleghorn Melanie Mueller Oscar O Orozco
Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit Fed Pit 0.00
Bertram Bascom Fred Foster Harriet H Harrison Jeremy J Johnson Katherine Kleghorn Melanie Mueller Oscar O Orozco EDD Barbara Baker Bertram Bascom Fred Foster Harriet H Harrison Jeremy J Johnson Katherine Kleghorn Melanie Mueller Oscar O Orozco
FICA PR PR PR PR PR PR PR PR
48.32
Transfer from Checking
State Payroll Taxes PR PR PR PR PR PR PR AP PR PR PR PR PR PR PR PR
2140-000-00 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006 04/11/2006
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
0.00
9,500.00
Federal Payroll Taxes PR PR PR PR PR PR PR PR PR AP PR PR PR PR PR PR PR PR PR PR
Credits
Miscellaneous
1 4-1-2002
1270-000-00
35787.67
End Balance Amount -16,667.67
125.00
Savings Account CD
Debits Reference 2500.00
0.00
Ralph's Record Mart
Petty Cash
1210-000-00 04/01/2006
Begin Balance Vendor/Employee 16,620.00
Page 1
75.67
194.42
State Pit State Pit State Pit State Pit State Pit State Pit State Pit State Pit State Pit State Pit State Pit State Pit State Pit State Pit State Pit State Pit 0.00
Bertram Bascom Chauncey C Calderwood Fred Foster Gabriel Galliano Harriet H Harrison Isabel Irene Ingram Jeremy J Johnson Katherine Kleghorn
-136.06 -2.44 -85.10 -49.77 -26.62 -106.06 -125.60 -32.56 -70.00 634.21 -203.85 -136.06 -2.44 -85.10 -49.77 -26.62 -106.06 -125.60 -32.56 -70.00
971.44 Fica Fica Fica Fica Fica Fica Fica Fica
-118.75 -30.59 -7.41 -1.11 -18.59 -15.16 -1.90 -0.91 75.67 -43.08 -30.59 -7.41 -1.11 -18.59 -15.16 -1.90 -0.91
2138.18
-1,166.74 -148.80 -29.96 -148.80 -79.06 -59.52 -20.46 -124.00 -186.00
Monthly Budget Planning Report Page 1 Account Number
Account Description Budget 2005
Actual 2005
Budget 2006
67,462.30) 58,620.45) 71,349.80) 65,233.00) 64,824.29) 55,330.00) 3,550.00) 1,136.00) 285.00) 870.00) 0.00 0.00 388,660.84)
( 68,212.50) ( 68,212.50) ( 68,212.50) ( 68,212.50) ( 68,212.50) ( 65,212.50) ( 64,212.50) ( 64,212.50) ( 65,212.50) ( 68,212.50) ( 68,212.50) ( 68,212.50) ( 804,550.00)
REVENUE
4010-000-00 January February March April May June July August September October November December 4010-000-01 January February March April May June July August September October November December 4010-000-03 January February March April May June July August September October November December
04/11/2006 10:37:48
Offerings ( ( ( ( ( ( ( ( ( ( ( ( Total for Year ( Offerings - Building Fund ( ( ( ( ( ( ( ( ( ( ( ( Total for Year ( Offerings - Missions ( ( ( ( ( ( ( ( ( ( ( ( Total for Year (
65,212.50) 65,212.50) 65,212.50) 65,212.50) 65,212.50) 60,212.50) 60,212.50) 60,212.50) 65,212.50) 65,212.50) 65,212.50) 65,212.50) 767,550.00)
( ( ( ( ( ( ( ( ( (
(
20,000.00) 20,000.00) 20,000.00) 20,000.00) 20,000.00) 20,000.00) 20,000.00) 20,000.00) 20,000.00) 20,000.00) 20,000.00) 20,000.00) 240,000.00)
( 19,205.50) ( 26,377.00) ( 20,720.00) ( 20,355.70) ( 22,056.00) ( 18,442.00) ( 17,485.00) ( 18,620.25) ( 23,710.50) ( 20,730.00) ( 24,365.00) ( 27,310.00) ( 259,376.95)
21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 252,000.00)
( ( ( ( ( ( ( ( ( ( ( (
(
23,325.75) 21,824.60) 26,140.00) 20,825.00) 22,344.00) 19,423.00) 20,000.00) 22,130.75) 22,120.30) 29,560.00) i 23,268.00) 26,775.00) 277,736.40)
(
( ( ( ( ( ( ( ( ( ( ( (
21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 21,000.00) 252,000.00)
( 22,500.00) ( 22,500.00) ( 22,500.00) ( 22,500.00) ( 22,500.00) ( 22,500.00) ( 22,500.00) ( 22,500.00) ( 22,500.00) ( 22,500.00) ( 22,500.00) ( 22,500.00) ( 270,000.00)
Current Year Budget Planning Report Logos Fiscal Year 2006
Account Number
Page 1
Account Description
Budget
REVENUE
4010-000-00 4010-000-01 4010-000-03 4210-000-00 4250-000-00 4400-000-00
Offerings Offerings - Building Fund Offerings - Missions Rental of Facilities Designated Ministries Sundry Income
( ( (
SubTotal
829,503.00) 254,400.00) 286,200.00) ( 2,544.00) ( 3,180.00) ( 3,021.00) ( 1,378,848.00)
Domestic Missions World Missions Salaries Employer FICA/Medicare - Administration Employer FICA/Medicare - Workers Employer MIsc. Taxes Employee Benefits Office Supplies Office Supplies - Worship Office Supplies - Music Printing Printing - Education Postage Bulletins Resources/Curriculum Resources/Curriculum - Worship Resources/Curriculum - Music Resources/Curriculum - Education Kitchen Supplies Worship Supplies Insurance Taxes Building Maintenance Equipment Maintenance Custodial Supplies Electricity Gas Water Christmas Activities Easter Activities Conferences Miscellaneous Expenses Miscellaneous Expenses - Building Fund SubTotal
98,580.00 203,520.00 557,083.00 38,160.00 50,880.00 57,240.00 49,290.00 9,063.00 2,544.00 1,272.00 4,452.00 1,590.00 6,678.00 1,590.00 1,908.00 954.00 2,544.00 12,720.00 1,272.00 2,226.00 2,544.00 1,272.00 73,140.00 1,590.00 1,908.00 6,996.00 3,021.00 4,452.00 1,484.00 1,272.00 3,551.00 38,160.00 85,860.00 1,328,816.00
EXPENDITURES
5120-000-00 5130-000-00 5510-000-00 5520-000-00 5530-000-00 5540-000-00 5600-000-00 5710-000-00 5710-100-00 5710-200-00 5720-000-00 5720-300-00 5730-000-00 5740-000-00 5750-000-00 5750-100-00 5750-200-00 5750-300-00 5760-000-00 5770-100-00 5810-000-00 5820-000-00 5830-000-00 5840-000-00 5850-000-00 5910-000-00 5920-000-00 5930-000-00 6140-000-00 6150-000-00 6160-000-00 6200-000-00 6200-000-01
04/11/2006 13:55:20
Current Monthly Budget Planning Report Logos Fiscal Year 2006
Account Number
January July
Account Description
Page 1
February August
March September
April October
May November
June December
4010-000-00 -69,125.25 -69,125.25
Offerings -69,125.25 -69,125.25
-69,125.25 -69,125.25
-69,125.25 -69,125.25
-69,125.25 -69,125.25
-69,125.25 -69,125.25
4010-000-01 -21,200.00 -21,200.00
Offerings - Building Fund -21,200.00 -21,200.00 -21,200.00 -21,200.00
-21,200.00 -21,200.00
-21,200.00 -21,200.00
-21,200.00 -21,200.00
4010-000-03 -23,850.00 -23,850.00
Offerings - Missions -23,850.00 -23,850.00
-23,850.00 -23,850.00
-23,850.00 -23,850.00
-23,850.00 -23,850.00
-23,850.00 -23,850.00
4210-000-00 -212.00 -212.00
Rental of Facilities -212.00 -212.00
-212.00 -212.00
-212.00 -212.00
-212.00 -212.00
-212.00 -212.00
4250-000-00 -265.00 -265.00
Designated Ministries -265.00 -265.00
-265.00 -265.00
-265.00 -265.00
-265.00 -265.00
-265.00 -265.00
4400-000-00 -251.75 -251.75
Sundry Income -251.75 -251.75
-251.75 -251.75
-251.75 -251.75
-251.75 -251.75
-251.75 -251.75
8,215.00 8,215.00
8,215.00 8,215.00
8,215.00 8,215.00
8,215.00 8,215.00
REVENUE
EXPENDITURES
5120-000-00 8,215.00 8,215.00
Domestic Missions 8,215.00 8,215.00
5130-000-00 16,960.00 16,960.00
World Missions 16,960.00 16,960.00
16,960.00 16,960.00
16,960.00 16,960.00
16,960.00 16,960.00
16,960.00 16,960.00
5510-000-00 46,423.57 46,423.57
Salaries 46,423.57 46,423.57
46,423.57 46,423.57
46,423.57 46,423.57
46,423.57 46,423.57
46,423.57 46,423.62
5520-000-00 3,180.00 3,180.00
Employer FICA/Medicare - Administration 3,180.00 3,180.00 3,180.00 3,180.00
3,180.00 3,180.00
3,180.00 3,180.00
3,180.00 3,180.00
5530-000-00 4,240.00 4,240.00
Employer FICA/Medicare - Workers 4,240.00 4,240.00 4,240.00 4,240.00
4,240.00 4,240.00
4,240.00 4,240.00
4,240.00 4,240.00
5540-000-00 4,770.00 4,770.00
Employer MIsc. Taxes 4,770.00 4,770.00
4,770.00 4,770.00
4,770.00 4,770.00
4,770.00 4,770.00
4,770.00 4,770.00
5600-000-00 4,107.50 4,107.50
Employee Benefits 4,107.50 4,107.50
4,107.50 4,107.50
4,107.50 4,107.50
4,107.50 4,107.50
4,107.50 4,107.50
04/11/2006 13:56:57
Traditional Balance Sheet - Consolidated (Statement of Financial Position) Page 1
Fiscal Year 2006, Period 4 (04/01/2006 to 04/30/2006)
ASSETS Current Assets Checking Accounts Petty Cash Accounts
27,483.76 140.00
Total Current Assets
27,623.76
Long Term Assets Savings Accounts
9,490.00
Total Long Term Assets
9,490.00
Other Assets Certificates of Deposit
125,000.00
Total Other Assets
125,000.00
TOTAL ASSETS
162,113.76
LIABILITIES AND FUND BALANCES Current Liabilities Payroll Liabilities Other Liabilities
(
270.00) 5,030.65
Total Current Liabilities
4,760.65
Long Term Liabilities Long Term Liabilities
94,720.00
Total Long Term Liabilities
94,720.00
TOTAL Liabilities
99,480.65
Permanently Restricted Fund Funds
63,670.00
Total Permanently Restricted Fund Liabilities Fund Balance General Fund Balance Account Current Surplus (Deficit) Total Fund Balance TOTAL Fund Balances TOTAL LIABILITIES AND FUND BALANCES
TOTAL LIABILITIES AND FUND BALANCES
04/11/2006 11:17:27
63,670.00
(
15,570.00 16,606.89) (
1,036.89) 62,633.11 162,113.76
1,500,861.42
Standard Balance Sheet - Consolidated (Statement of Financial Position) Page 1
Fiscal Year 2006, Period 4 (04/01/2006 to 04/30/2006)
ASSETS Current Assets Checking Accounts Petty Cash Accounts
27,483.76 140.00
Total Current Assets
27,623.76
Long Term Assets Savings Accounts
9,490.00
Total Long Term Assets
9,490.00
Other Assets Certificates of Deposit
125,000.00
Total Other Assets
125,000.00
TOTAL ASSETS
162,113.76
LIABILITIES AND FUND BALANCES Current Liabilities Payroll Liabilities Other Liabilities
(
Total Current Liabilities
270.00) 5,030.65 4,760.65
Long Term Liabilities Long Term Liabilities
94,720.00
Total Long Term Liabilities
94,720.00
TOTAL Liabilities
99,480.65
Permanently Restricted Fund Funds
63,670.00
Total Permanently Restricted Fund Liabilities Fund Balance General Fund Balance Account Current Surplus (Deficit) Total Fund Balance TOTAL Fund Balances TOTAL LIABILITIES AND FUND BALANCES
04/11/2006 11:18:45
63,670.00 15,570.00 16,606.89)
( (
1,036.89) 62,633.11 162,113.76
I & E Report Basic Logos Page 1
Fiscal Year 2006, Period 4 (04/01/2006) to 4 (04/30/2006)
Gl Account Number
Account Description
Current Period(s)
Current Ytd
21,988.65
114,888.85
5,713.05
11,069.75
Revenue 4000-000-00 4010-000-00 4200-000-00 4400-000-00
Contributions Offerings Other Income Sundry Income Total
27,701.70
125,958.60
495.80 280.00
3,505.80 4,480.00
25,068.34 654.02 1,006.22 2,225.00
51,425.85 1,308.04 2,137.90 4,375.00
624.25 0.00 0.00 0.00 0.00 0.00 200.00 48.32 0.00 0.00 0.00 0.00 0.00
3,174.25 600.00 300.00 1,110.00 3,000.00 1,650.00 590.00 498.32 225.00 600.00 3,000.00 300.00 540.00
0.00 0.00 347.85 0.00 0.00
600.00 330.00 18,347.85 405.00 480.00
0.00 0.00 0.00
1,680.00 705.00 1,095.00
Expenditures 5000-000-00 5120-000-00 5130-000-00 5500-000-00 5510-000-00 5520-000-00 5530-000-00 5600-000-00 5700-000-00 5710-000-00 5710-100-00 5710-200-00 5720-000-00 5720-300-00 5730-000-00 5740-000-00 5750-000-00 5750-100-00 5750-200-00 5750-300-00 5760-000-00 5770-100-00 5800-000-00 5810-000-00 5820-000-00 5830-000-00 5840-000-00 5850-000-00 5900-000-00 5910-000-00 5920-000-00 5930-000-00 6000-000-00 6200-000-00
Missions Domestic Missions World Missions Salaries and Wages Salaries Employer FICA/Medicare - Administration Employer FICA/Medicare - Workers Employee Benefits Supplies Office Supplies Office Supplies - Worship Office Supplies - Music Printing Printing - Education Postage Bulletins Resources/Curriculum Resources/Curriculum - Worship Resources/Curriculum - Music Resources/Curriculum - Education Kitchen Supplies Worship Supplies Plant & Property Insurance Taxes Building Maintenance Equipment Maintenance Custodial Supplies Utilities Electricity Gas Water Other Expenses Miscellaneous Expenses Total
7,186.00 38,135.80
16,186.00 122,649.01
I & E Report Budget Comparison (Total Budget) Sample Reports Page 1
Fiscal Year 2006, Period 4 (04/01/2006) to 4 (04/30/2006) Current Period(s)
Account Description
Budget Same Period(s)
Current YTD
Budget YTD
Total Years Budget
Revenue Contributions Rental of Facilities Total
84,555.65 5,713.05
114,175.25 728.75
201,555.10 11,069.75
456,701.00 2,915.00
1,370,103.00 8,745.00
90,268.70
114,904.00
212,624.85
459,616.00
1,378,848.00
27,275.80 28,953.58 872.57 347.85 0.00 7,186.00
25,175.00 62,721.07 4,067.75 6,704.50 1,205.75 11,819.00
34,485.80 59,246.79 15,587.57 20,162.85 3,480.00 16,186.00
100,700.00 250,884.31 16,271.00 26,818.00 4,823.00 44,732.00
302,100.00 752,653.00 48,813.00 80,454.00 14,469.00 130,327.00
64,635.80
111,693.07
149,149.01
444,228.31
1,328,816.00
Expenditures Missions Salaries and Wages Supplies Plant & Property Utilities Other Expenses Total Grand Total Total Revenue Total Expenditures Net Revenue over Expense
(
90,268.70 64,635.80) 25,632.90
(
114,904.00 111,693.07) 3,210.92
(
212,624.85 149,149.01) 63,475.84
(
459,616.00 444,228.31) 15,387.68
1,378,848.00 ( 1,328,816.00) 50,032.00
GL Checks by Date Written Date Written from 04/11/2006 to 04/11/2006 and Include Eft's
Page 1
Checking Account:1 Check numbers flagged with '*' are Voided Check Number Invoice
5829
Eft
Date Written
GL Account
q
04/11/2006
5710-000-00
5830 499TRW
5831 TRG456
5832
q
04/11/2006
5760-000-00
q
04/11/2006
5930-000-00
q
04/11/2006
2190-000-00 2195-000-00 5120-000-00 5530-000-00 5600-000-00
5833
q
04/11/2006
5130-000-00
5834
q
04/11/2006
5710-000-00
5835 4567
5836 4356
5837 38921
5838
q
04/11/2006
5710-000-00
q
04/11/2006
5120-000-00
q
04/11/2006
5750-300-00
q
04/11/2006
5710-000-00 5710-100-00 5710-200-00
5839
q
04/11/2006
5710-000-00 5710-100-00 5710-200-00
5840 8923
5841
q
04/11/2006
5710-100-00
q
04/11/2006
5130-000-00 6200-000-00
5842
q
04/11/2006
6160-000-00
5843 2937
5844 A238941
5845
q
04/11/2006
5830-000-00
q
04/11/2006
5760-000-00
q
04/11/2006
2010-000-00
Payee
Amount
Reference
Debit (+)
Acme Stationers
50.00
Paper and Binders for Finance Comm.
50.00
Bach's Distributors
45.00
Water Bottles for Workrook Cooler
45.00
Barney's Bulletins
70.00
Bulletin Stock
70.00
Independent Insurance Inc.
239.35
PR Deductions PR Deductions PR Deductions PR Deductions PR Deductions
25.00 84.35 100.00 15.00 15.00
Knesset,Kenneth
40.00
Consulting re Web Site
40.00
Smith,Arthur
15.00
Adjustment
15.00
Thomas Typesetting
15.00
Business Cards for Al
15.00
Thompson, Todd
10.00
Refund
10.00
Able Paper Company
75.00
Construction Paper for Children's Classes
75.00
Able Paper Company Office Supplies Supplies for Worship Supplies for Music Ed
450.00 150.00 150.00 150.00
Acme Stationers Notebooks for Committees Usher Folders Music Class Charts
300.00 100.00 100.00 100.00
Brown's Bakery Donuts for Finance Committee
35.00 35.00
Building Better Bosnia Missions Support Missions Support
50.00 45.00 5.00
Camp Cachuma Deposit for Middle School Camp
150.00 150.00
Carl's Cleaning Service Cleaning
200.00 200.00
Cathy's Catering Women's Luncheon
250.00 250.00
Citizens State Bank Loan Repayment
300.00 300.00
Total for Checking Account GRAND TOTALS 04/11/2006 11:56:43
Credit (-)
2,294.35 2,294.35
Journal Reports Sample Reports Page 1
Journal: CD From Period: 4 (04/01/2006) to 4 (04/30/2006) Date
GL Account
Reference
Check #
04/01/2006 162 1010-000-00 162 1210-000-00
Transfer to Savings Transfer from Checking
4-1-2002 4-1-2002
1 1
(
300.00) 300.00
04/10/2006 162 1010-000-00 162 6200-000-00
Bank Charges Bank Charges
4-10-2002 4-10-2002
1 1
(
15.25) 15.25
04/11/2006 163 1010-000-00 163 6200-000-00
Fiddle with Bank Rec Fiddle with Bank Rec
4-11-2002 4-11-2002
1 1
Debits
7,486.00
Credits
(
Acct
7,486.00)
Vendor/Employee
Amount
( Totals
7,170.75) 7,170.75 0.00
View Accounts (By Period) Sample Reports An asterisk before Description indicates Inactive Account
Page 1
From Period: 1 (01/01/2006) to 4 (04/30/2006) GL Account #
Description
4400-000-00
Sundry Income
Date 01/31/2006 02/28/2006 03/31/2006 04/11/2006
Jrnl Acct Check/Deposit # CR 1 10310 CR 1 10311 CR 1 10312 CR 1 10309
Begin Balance
Debits
Credits
End Balance
0.00
0.00
11069.75
-11,069.75
Vendor/Employee
Reference January February March April
Beginning Budget YTD Ending Budget Total Annual Budget Remaining Budget Balance 5 Records Selected
Amount -3233.20 -1470.25 -653.25 -5713.05
( (
0.00 1,007.00) 3,021.00) 8,048.75
Sample Export to Spreadsheet account 4000-000-00 4010-000-00 4010-000-01 4010-000-03 4150-000-00 4200-000-00 4210-000-00 4250-000-00 4400-000-00 5000-000-00 5120-000-00 5120-000-06 5130-000-00 5500-000-00 5510-000-00 5520-000-00 5530-000-00 5540-000-00 5600-000-00 5700-000-00 5710-000-00 5710-100-00 5710-200-00 5720-000-00 5720-300-00 5730-000-00 5740-000-00 5750-000-00 5750-100-00 5750-200-00 5750-300-00 5760-000-00 5770-100-00 5800-000-00 5810-000-00 5820-000-00 5830-000-00 5840-000-00 5850-000-00 5900-000-00 5910-000-00 5920-000-00 5930-000-00 6000-000-00 6140-000-00 6150-000-00 6160-000-00 6200-000-00 6200-000-01
description per_1 per_2 per_3 per_4 per_5 per_6 per_7 per_8 per_9 per_10 per_11 per_12 per_13 budget_1 Contributions 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Offerings -21665 -31042 -40193.2 -44835.65 0 0 0 0 0 0 0 0 0 -69125.25 Offerings - Building F 0 0 0 -15800 0 0 0 0 0 0 0 0 0 -21200 Offerings - Missions -6983.4 -7644 -9471.85 -23920 0 0 0 0 0 0 0 0 0 -23850 Memorials 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Income 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Rental of Facilities 0 0 0 0 0 0 0 0 0 0 0 0 0 -212 Designated Ministries 0 0 0 0 0 0 0 0 0 0 0 0 0 -265 Sundry Income -3233.2 -1470.25 -653.25 -5713.05 0 0 0 0 0 0 0 0 0 -251.75 Missions 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Domestic Missions 800 1300 910 8995.8 0 0 0 0 0 0 0 0 0 8215 Missions Projects 0 0 0 0 0 0 0 0 0 0 0 0 0 0 World Missions 1400 1400 1400 18280 0 0 0 0 0 0 0 0 0 16960 Salaries and Wages 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Salaries 4629.17 8419.17 13309.17 25068.34 0 0 0 0 0 0 0 0 0 46423.58 Employer FICA/Medi 144.15 182.86 327.01 654.02 0 0 0 0 0 0 0 0 0 3180 Employer FICA/Medi 301.06 251.84 578.78 1006.22 0 0 0 0 0 0 0 0 0 4240 Employer MIsc. Taxe 0 0 0 0 0 0 0 0 0 0 0 0 0 4770 Employee Benefits -50 1100 1100 2225 0 0 0 0 0 0 0 0 0 4107.5 Supplies 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Office Supplies 750 750 1050 624.25 0 0 0 0 0 0 0 0 0 755.25 Office Supplies - Wo 200 200 200 0 0 0 0 0 0 0 0 0 0 212 100 100 100 0 0 0 0 0 0 0 0 0 0 106 Office Supplies - Mus Printing 370 370 370 0 0 0 0 0 0 0 0 0 0 371 Printing - Education 1000 1000 1000 0 0 0 0 0 0 0 0 0 0 132.5 Postage 550 550 550 0 0 0 0 0 0 0 0 0 0 556.5 Bulletins 130 130 130 200 0 0 0 0 0 0 0 0 0 132.5 Resources/Curriculu 150 150 150 48.32 0 0 0 0 0 0 0 0 0 159 Resources/Curriculu 75 75 75 0 0 0 0 0 0 0 0 0 0 79.5 Resources/Curriculu 200 200 200 0 0 0 0 0 0 0 0 0 0 212 Resources/Curriculu 1000 1000 1000 0 0 0 0 0 0 0 0 0 0 1060 Kitchen Supplies 100 100 100 0 0 0 0 0 0 0 0 0 0 106 Worship Supplies 180 180 180 0 0 0 0 0 0 0 0 0 0 185.5 Plant & Property 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Insurance 200 200 200 0 0 0 0 0 0 0 0 0 0 212 Taxes 110 110 110 0 0 0 0 0 0 0 0 0 0 106 Building Maintenance 6000 6000 6000 347.85 0 0 0 0 0 0 0 0 0 6095 Equipment Maintena 135 135 135 0 0 0 0 0 0 0 0 0 0 132.5 Custodial Supplies 160 160 160 0 0 0 0 0 0 0 0 0 0 159 Utilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Electricity 560 560 560 0 0 0 0 0 0 0 0 0 0 583 Gas 235 235 235 0 0 0 0 0 0 0 0 0 0 251.75 Water 365 365 365 0 0 0 0 0 0 0 0 0 0 371 Other Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Christmas Activities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Easter Activities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Conferences 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Miscellaneous Expen 3000 3000 3000 7186 0 0 0 0 0 0 0 0 0 3180 Miscellaneous Expen 0 0 0 0 0 0 0 0 0 0 0 0 0 7155
Current Cleared Checks/Deposits Sample Church Data File April 11, 2006 Reconciled Statement Report for Account 1: Page 1 Check\Deposit # Date
Payee/Reference
Amount
Cleared Checks 13384 13386 13389 13390 13391 13392 13393 13394 13435 13440
01/30/2006 01/30/2006 01/30/2006 01/31/2006 01/31/2006 01/31/2006 02/04/2006 02/04/2006 02/11/2006 03/11/2006
Palmer,Paula Scotty Custodial Supply Co. The Paper Zone Board of CE Lazerquick Tusant,Todd Evangelizing Youth Alderson's Apple Farm Mutual of Piru Verizon Wireless Totals for Cleared Checks
72.73 126.90 246.73 200.00 198.00 287.15 1,442.00 176.18 1,673.57 102.12 4,525.38
Bank Reconciliation Sample Reports April 30, 2006 Reconciled Statement Report for Account 1: Checking Account Community State Bank 123456789 Cleared Batch:21
Page 1
Summary Statement Period: Starting 01/01/2006 Ending Statement Balance: (+) Outstanding Deposits: (-) Outstanding Checks: Adjusted Bank Balance Opening General Ledger Balance: (-) Interest Adjustment: (+) Bank Charges: Adjusted General Ledger Balance: Check\Deposit # Date
( (
(
Ending: 04/30/2006
$775.47 $2,500.00 $13,777.89 $10,502.42) $10,502.42) $0.00 $0.00 $10,502.42) GL Account Number: 1010-000-00
Payee/Reference
Amount
Deposit
2,500.00
Outstanding Deposits 0411
04/11/2006
Totals for Outstanding Deposits
2,500.00
Outstanding Checks 1582 5702 5703 EFT 175 EFT 176 EFT 177 EFT 178 EFT 179 EFT 180 EFT 181 EFT 182 EFT 183 EFT 184 EFT 185 EFT 186 EFT 187 EFT 188 EFT 190 EFT 191 EFT 192 EFT 193 EFT 194 EFT 195 EFT 196
04/11/2006 04/11/2006 04/11/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/28/2006 04/29/2006 04/30/2006
Nolan Neathery Bertram Bascom Chauncey C Calderwood Able Paper Company Acme Stationers Acme Stationers Thomas Typesetting Thomas Typesetting US Postal Service Living Word Bookstore Living Word Bookstore Living Word Bookstore Living Word Bookstore Bach's Distributor Virtual Sermon Service Fred Foster Fiduciary Fellows Citzens State Bank Luke's Local Plumbing Carl's Cleaning Service Gas Company Electric Company Werner's Wonderful Water Systems Citzens Bank EDD
2,750.00 930.75 218.57 750.00 200.00 100.00 1,000.00 130.00 550.00 150.00 75.00 200.00 1,000.00 100.00 180.00 200.00 110.00 135.00 160.00 235.00 560.00 365.00 3,313.85 364.72