GENERAL LEDGER BLANK
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

Comment only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This workbook is still in progress! Automation changes are being made and hopefully will make the system easy to use.
2
3
4
Eventually each month will have a sheet associated with it. In these sheets you can input your itemized income or expenses.
5
This data will populate the Income Statement sheet which will give you an overall view of your company.
6
You may need to change some of this data depending on what you need to keep track of but this is a basic framework that you can copy and play with.
7
8
If you want a custom spreadsheet developed for your business/company please feel free to email EdibleCarnival@gmail.com! We can talk about what you need
9
and I can get you a quote.
10
11
I hope this is helpful in your accounting! I was really nervous to start this whole journey but am feeling more confident now that i've spent some time working
12
with it!
13
14
15
If you want to help support the Edible Carnival in its various endeavors such as the generation of this free workbook consider donating to our Patreon!
16
https://www.patreon.com/EdibleCarnival
17
18
19
IMPORTANT
20
The data is queried based on the types of data you are collecting. If you want to change any of your income sources or expense types use the formula below
21
= QUERY(INSERT DATA TO SEARCH, "select DATA YOU WANT TO SELECT where (COLUMN WHERE PARAMETER EXISTS = 'PARAMETER')")
22
INSERT DATA TO SEARCH
This is where you put the range of data you are searching (Usually when you start typing this formula you will be able to navigate to the data and select it)
23
DATA YOU WANT TO SELECT
This is the data that you want to grab if you find the search parameter you select
24
COLUMN WHERE PARAMETER
This is the location of the data where your chosen parameter exists
25
PARAMETER
This is the term you have selected to represent the data you want to find
26
27
28
So far the best way I have found to change this stuff is manually. Hopefully when I finish our spreadsheet for Edible Carnival ledger I can just import all that data here for you guys so
29
you don't have to do it all over again. Please feel free to leave notes and suggestions on this document I would love to hear your feedback!
30
31
32
33
34
35
36
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
Loading...