%5cpdf%5caccountinggl

  • Uploaded by: Dana A Daspit Conte
  • 0
  • 0
  • April 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View %5cpdf%5caccountinggl as PDF for free.

More details

  • Words: 4,188
  • Pages: 17
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

More Documents from "Dana A Daspit Conte"

Travel Expense
April 2020 24
General Journal
April 2020 17
Year-end Tax Plan1
April 2020 18
Sema4 Reimbursement Form
April 2020 13
%5cpdf%5caccountinggl
April 2020 18