Buscar

General ledger1

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

YTD Budget Summary
	
	2005 Actual versus Budget YTD
	
	G/L Code	Account Title	Actual	Budget	Remaining $	Remaining %
	
	1000	Advertising	$750.75	$100,000.00	$99,249.25	99.25%
	
	2000	Office Equipment	0.0	$100,000.00	$100,000.00	100.00%
	
	3000	Printers	0.0	$100,000.00	$100,000.00	100.00%
	
	4000	Server Costs	0.0	$100,000.00	$100,000.00	100.00%
	
	5000	Supplies	0.0	$50,000.00	$50,000.00	100.00%
	
	6000	Client Expenses	0.0	$25,000.00	$25,000.00	100.00%
	
	7000	Computers	$2,500.00	$75,000.00	$72,500.00	96.67%
	
	8000	Medical Plan	0.0	$65,000.00	$65,000.00	100.00%
	
	9000	Building Costs	0.0	$125,000.00	$125,000.00	100.00%
	
	10000	Marketing	0.0	$100,000.00	$100,000.00	100.00%
	
	11000	Charitables	$2,500.00	$250,000.00	$247,500.00	99.00%
	
	12000	Sponsorships	$1,000.00	$50,000.00	$49,000.00	98.00%
	
		TOTAL	$6,750.75	$1,140,000.00	$1,133,249.25	99.41%
Monthly Expenses Summary
	
	2005 Monthly Expenses
	
	G/L Code	Account Title	Jan-05	Feb-05	Mar-05	Apr-05	May-05	Jun-05	Jul-05	Aug-05	Sep-05	Oct-05	Nov-05	Dec-05	2005
	
	1000	Advertising	$750.75	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	$750.75
	
	2000	Office Equipment	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
	3000	Printers	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
	4000	Server Costs	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
	5000	Supplies	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
	6000	Client Expenses	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
	7000	Computers	$2,500.00	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	$2,500.00
	
	8000	Medical Plan	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
	9000	Building Costs	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
	10000	Marketing	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
	11000	Charitables	0.0	$2,500.00	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	$2,500.00
	
	12000	Sponsorships	$1,000.00	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	$1,000.00
	
		Total	$4,250.75	$2,500.00	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	$6,750.75
Itemized Expenses
	G/L Code	Invoice Date	Invoice #	Requested by	Check Amount	Payee	Check Use	Method of Distribution	File Date	Constructed Key Field
	1000	1/1/05	100	Andy Teal	$750.75	Consolidated Messenger	Mailer	Mail	1/4/05	1000Jan-05
	7000	1/15/2005	101	Robert Walters	$2,500.00	A. Datum Corporation	2 desktop computers	Credit	1/20/05	7000Jan-05
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
										Jan-00
To edit this list, put cursor in cell A2, goto menu Data, Validation, and update the values in the Source box.
Charitables & Sponsorships
	G/L Code	Date Check Request Initiated	Requested by	Check Amount	Previous Year Contribution	Payee	Used For	Signed Off by	Category	Method of Distribution	File Date	Constructed Key Field
	12000	1/20/05	Susan W. Eaton	$1,000.00	0.0	School of Fine Art	Scholarships	Kim Ralls	Arts	Check	1/30/05	12000Jan-05
	11000	2/15/05	Susan W. Eaton	$2,500.00	0.0	Wingtip Toys	Community	Kathie Flood	Community	Check	3/1/05	11000Feb-05
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
												Jan-00
To edit this list, put cursor in cell A2, goto menu Data, Validation, and update the values in the Source box.

Teste o Premium para desbloquear

Aproveite todos os benefícios por 3 dias sem pagar! 😉
Já tem cadastro?

Outros materiais