ABCDEFGHIPQRSTUVWXYZ
1
The Vivid Accounting System
2
Business Setup
3
4
Business Name<Insert business name>
5
Business TypeSole TraderFixed, will update
6
Owner's Name<Insert your name>
7
Start Date1/4/2022Format: DD/MM/YY
8
End Date30/6/2022Format: DD/MM/YY
9
JurisdictionAustralia
Locked for now, will upate.
10
ABN/ID number
11
Date FormatDD/MM/YYLocalsied
12
CurrencyAUD - $0.00 (show cents)Localsied
13
GST/VAT?Yes - registered for GST/VATGST in Aust, VAT elsewhere
14
Goods sold?Yes, Show Gross ProfitLocked, will update
16
VersionTypeCommercial (SME/Charity)
17
Version#0.3.35BetaFixed
18
19
20
21
22
23
24
25
Notes for Instructors & Users
26
27
What do the colours mean?
28
YouTube guideyoutu.be/Rf2FcUyafss 
29
Download: PDF Poster the accounting process
30
Websitetetracarbon.com/excel-accounting-app
31
32
FAQ:
33
Q: Can I add rows?
34
A: NO! Adding rows will break the code.
35
Ask me to modify the software if you need more accounts or rows.
36
Q: Why can't I just add rows?
37
A: You will break the auto-posting code. Don't do it.
38
Q: What is the password (so I can use your source code)?
39
A: This is a finished product. Source code is not publicly available.
40
Please email me if you would like specific tweaks.
41
42
What this spreadsheet does:
43
▪ This is the student version (Free)
44
▪ A complete double entry accounting software written in Excel, zero VBA or macros.
45
▪ Full functioning model built for education
46
▪ General journal limited to 1000 lines
47
▪ Allows for GST: ABN on reports, GST on purchases & sales
48
▪ Journals narrations included
49
50
The business version is still in development. It will include:
51
▪ CSV import from bank records
52
▪ Invoice generation
53
▪ Price lists for goods & services offered
54
▪ Expanded accounts: 30 expenses
55
Enough for monthly accounts for a micro business or community club
56
57
University Edition (for teachers and institutions):
58
▪ Dynamically generate individual questions using student numbers as a unique seed
59
▪ Automate marking and feedback - programming required
60
▪ Generates source documentation for students to process
61
▪ Allows different business entities (Companies, Partnerships Trusts, Super Funds)
62
▪ Manual posting allowing students to learn the accounting process
63
▪ Include special journals and or subsidiary ledgers
64
▪ Includes OCI & revaluations
65
▪ Allow for group consolidation worksheets
66
Other versions written in MS Access are also in development.
67
68
Email me for other versions
69
Systems can be customised to your specific needs
70
71
Who made this?
72
Find Phillip on:
73
YouTubeyoutube.com/c/tetracarbon
74
My Websitetetracarbon.com/
75
LinkedIn linkedin.com/in/tetracarbon/
76
Facebookfacebook.com/economista
77
Twittertwitter.com/Tetracarbon
78
EmailPhillip@tetracarbon.com
79
80
Sharing & Learning
81
Feel free to share this with anyone who can benefit!
82
Terms and Conditions of use below
83
In using this product you agree to the following
84
1
I (Phillip Wong) retain all rights to this work. You will acknowledge Phillip as the original creator. You will not pass this off as your own.
85
2
You are welcome to use this product to prepare accounts for commercial clients. 
86
3
The product itself is free. This means:
87
You are welcome to share this product with anyone.
88
You will not sell this product or charge for the provision of this product.
89
You CAN charge for your time in preparing accounts using this product. 
90
You CAN charge for accounting advice based on accounts prepared using this product.
91
4
You will not attempt to: modify locked aspects of the product, reverse engineer the product, or develop a competitor product. 
92
5
Phillip retains full copyright to the specific colours as a method for teaching accounting. The colours are trademarked. 
93
94
95
96
97
98
99
100
101