Personal - Financials - Google Sheets

	A	B	C	D	E	F	G	X	Y	Z	AA
1	No	Group	Ledgers	Dr/Cr	Type	Balance	Document Link	No	Group	Dr/Cr	Type

2	1	Sundry Debtors	Debtor-1	Debit	Balance Sheet	164,280.00		1	Bank Accounts	Debit	Balance Sheet
3	2	Indirect Expenses	Registration expense	Debit	Profit & Loss A/c	252,000.00		2	Bank OCC A/c	Credit	Balance Sheet
4	3	Indirect Expenses	Govt. fee for Registration	Debit	Profit & Loss A/c	30,000.00		3	Bank OD A/c	Credit	Balance Sheet
5	4	Indirect Expenses	Travel expense	Debit	Profit & Loss A/c	16,139.00		4	Branch / Divisions	Credit	Balance Sheet
6	5	Indirect Expenses	Printing & Stationery	Debit	Profit & Loss A/c	500.00		5	Capital Account	Credit	Balance Sheet
7	6	Sales Accounts	Registration Fee	Credit	Profit & Loss A/c	(63,000.00)		6	Cash-in-Hand	Debit	Balance Sheet
8	7	Sales Accounts	Monthly Compliances	Credit	Profit & Loss A/c	0.00		7	Current Assets	Debit	Balance Sheet
9	8	Sales Accounts	Assignment work	Credit	Profit & Loss A/c	(491,000.00)		8	Current Liabilities	Credit	Balance Sheet
10	9	Loans & Advances (Asset)	Prasad	Debit	Balance Sheet	0.00		9	Deposits (Asset)	Debit	Balance Sheet
11	10	Sundry Debtors	Debtor-2	Debit	Balance Sheet	(156,280.00)		10	Direct Expenses	Debit	Profit & Loss A/c
12	11	Cash-in-Hand	Cash	Debit	Balance Sheet	56,774.20		11	Direct Incomes	Credit	Profit & Loss A/c
13	12	Capital Account	Capital	Credit	Balance Sheet	(92,400.00)		12	Duties & Taxes	Credit	Balance Sheet
14	13	Sundry Debtors	Debtor-3	Debit	Balance Sheet	70,000.00		13	Expenses (Direct)	Debit	Profit & Loss A/c
15	14	Investments	Shares	Debit	Balance Sheet	49,542.00		14	Expenses (Indirect)	Debit	Profit & Loss A/c
16	15	Bank Accounts	HDFC Bank	Debit	Balance Sheet	0.00		15	Fixed Assets	Debit	Balance Sheet
17	16	Indirect Expenses	Telephone Expense	Debit	Profit & Loss A/c	1,299.00
18	17	Indirect Expenses	Mis.Expenses	Debit	Profit & Loss A/c	45.80		16	Income (Direct)	Credit	Profit & Loss A/c
19	18	Loans & Advances (Asset)	Loan - N	Debit	Balance Sheet	0.00		17	Income (Indirect)	Credit	Profit & Loss A/c
20	19	Fixed Assets	Laptop	Debit	Balance Sheet	100,000.00		18	Indirect Expenses	Debit	Profit & Loss A/c
21	20	Sundry Creditors	Creditor-1	Credit	Balance Sheet	0.00		19	Indirect Incomes	Credit	Profit & Loss A/c
22	21	Loans & Advances (Asset)	Loan - C	Debit	Balance Sheet	22,000.00		20	Investments	Debit	Balance Sheet
23	22	Indirect Expenses	Written-off expense	Debit	Profit & Loss A/c	100.00		21	Loans (Liability)	Credit	Balance Sheet
24	23	Loans & Advances (Asset)	Loan - B	Debit	Balance Sheet	40,000.00		22	Loans & Advances (Asset)	Debit	Balance Sheet
25								23	Misc. Expenses (ASSET)	Debit	Balance Sheet
26								24	Provisions	Credit	Balance Sheet
27								25	Purchase Accounts	Debit	Profit & Loss A/c
28								26	Reserves & Surplus	Credit	Balance Sheet
29								27	Retained Earnings	Credit	Balance Sheet
30								28	Sales Accounts	Credit	Profit & Loss A/c
31								29	Secured Loans	Credit	Balance Sheet
32								30	Stock-in-Hand	Debit
33								31	Sundry Creditors	Credit	Balance Sheet
34								32	Sundry Debtors	Debit	Balance Sheet
35								33	Suspense A / C		Balance Sheet
36								34	Unsecured Loans	Credit	Balance Sheet
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100