Excel Based Accounting Software (100% FREE!)

  Рет қаралды 246,911

Tetracarbon (Phillip Wong)

Tetracarbon (Phillip Wong)

Күн бұрын

DOWNLOAD HERE:
www.tetracarbon.com/excel-acc...
The education edition is available now.
The small business edition will be released soon!
Both will remain free, for everyone, forever.
== ASK PHILLIP A QUESTION ==
- Facebook / economista (Please post publicly on my wall)
- Tweet @tetracarbon / tetracarbon
- LinkedIn / tetracarbon
-------------------------
Happy Studies!
-Phillip

Пікірлер: 403
@IsabelRodriguez-nv2ue
@IsabelRodriguez-nv2ue Жыл бұрын
This is pure GOLD ! Thanks for sharing your system for the benefit of all ! Truly helpful!
@bori1977
@bori1977 Жыл бұрын
Phillip, you tough me more in 15 Min. in accounting that my college professor did in 2 semesters!!!! YOU ARE THE MAN!!! Thank You!!! I can't wait for the what else you come up with.
@4tun8nanette
@4tun8nanette Жыл бұрын
I actually understood some of this. Thank you. I have a very small business and I only have 1 client and will only ever have the one client. In the US I'm considered a sole proprietor. I mainly concerned with tracking income and expenses with categories to present to my tax preparer at tax time. Your spreadsheet looks amazing and well thought out.
@CV-gX
@CV-gX 5 ай бұрын
Woooowww when I read books I can't understand but after see this I know the whole process Thankk you very much
@user-ej8jn5jy3i
@user-ej8jn5jy3i 7 ай бұрын
Thank you for your valuable time and knowledge sharing to some of us who does not know how or have the ability to create an excel software to assist us with our small business and importantly without being paid same as others on other platforms..Stay blessed always👍👍 ..
@bman8363
@bman8363 4 ай бұрын
Phil. I've subscribed. Simply because you've been able to colour code the 'DEALER' accounts. This is an Absolutely brilliant way to represent this concept.. Bravo👏 Thanks mate
@emilmisih651
@emilmisih651 2 жыл бұрын
Mr Wong, thank you for effort on this. Appreciate your help. God bless you always.
@lynnmercado1087
@lynnmercado1087 3 жыл бұрын
This is FANTASTIC! Thank you so much for sharing this amazing tool.
@Tetracarbon
@Tetracarbon 3 жыл бұрын
It will get better too! Right now I’m snowed in with research and study, but I have an update soon. If you let me know specifically what you want to see in the next version I can adjust it to be more useful to you. But you need to let me know what’s on your mind.
@desiiaviator
@desiiaviator 2 жыл бұрын
It's a beautiful effort... Hope to see the commercial version soon...
@tharindurathnayake9345
@tharindurathnayake9345 Жыл бұрын
Great content mate. Would love if you can guide the way you automated general ledger postings from the general journal. Keep up the good work 👍👍
@inavlas3270
@inavlas3270 22 күн бұрын
Thank you for making peoples life easier🤗.
@LaneBurdett
@LaneBurdett 3 жыл бұрын
Great stuff as always Phil!!!!
@kramerranch5044
@kramerranch5044 2 жыл бұрын
I'm excited to try this! Thank you!
@sayamoriyasu
@sayamoriyasu Жыл бұрын
Thank you so much. Looks like a great option. You should start at the end and say that you need Excel and it doesn't work with Google sheets.
@moshawqy
@moshawqy 3 ай бұрын
Hey mate, you’re a legend
@104Tomcat
@104Tomcat Жыл бұрын
It looks great to me! My CPA is yelling at me to NOT get QUICKBOOKS, MYOB or ZERO. She advocates EXCEL but I no idea of where to start. You solved that problem for me. Look forward to using it to get started!
@Tetracarbon
@Tetracarbon Жыл бұрын
Remember. This was intended for educational use rather than seriously supporting a real business.
@tamajoseph
@tamajoseph Жыл бұрын
You' re a legend Phillip thanks
@eoindale1966
@eoindale1966 2 жыл бұрын
Philip - tried 3 times to download mithout success - pity cause its great
@aravindr8673
@aravindr8673 Жыл бұрын
Great Video!!! It helped me a lot to put things together. Thank you for your effort
@davidogan
@davidogan Жыл бұрын
Dear Mr. Wong. Thank you very much for developing an Excel-based accounting software that is practical and giving it away for free for the benefits of others, myself included. I appreciate it very much. I live in Europe and am opening a micro business, and after covid not many people have money and things are so expensive that it is crucial to keep track of income and expenses. This is really great. I don't know accounting at all and I hope your Excel software will be able to help me keep the books. I am sure it will. I also hope to learn accounting basics like you stated and perhaps move on to other software. I will learn to use it and give you feedback if there are any. Thank you very much.
@UgwuaduEphraim
@UgwuaduEphraim Жыл бұрын
Hello guys am about review sure fire system of making atleast 100k -200k monthly as affiliate marketer , affiliate marketing is a process of selling digital product online and get commission ,you don't need laptop to start only your smart phone can do that ,I we give my free mentorship to 20 people that is read to start
@accmasmali
@accmasmali Жыл бұрын
i really liked this, this is wonderful
@peterashley4234
@peterashley4234 Жыл бұрын
Well done, will certainly have a good look at your work!
@haruka9545
@haruka9545 6 ай бұрын
the free template is very helpful! thank you so much for this!
@ZEYCO_1337
@ZEYCO_1337 2 ай бұрын
Thank you for your help and explanation
@marcomedina8833
@marcomedina8833 Ай бұрын
Impressive, sir! 🫡
@karenbuchert3377
@karenbuchert3377 4 ай бұрын
Wow! This looks great! Thanks!
@jcolddeep
@jcolddeep 2 жыл бұрын
Great work simple and best
@omsorg4alle
@omsorg4alle 5 ай бұрын
Thank you so much! This is amazing, I am helping a small church and they were on quicken. This is so much better. I like what you intend to add, are you thinking about the ability to reconcile? You are a wonderful person to do this😊
@SorcerersApprentice-qn7ig
@SorcerersApprentice-qn7ig 11 ай бұрын
`You can tell a master at something because they can simplify and explain things easier than the others. You're a master! This is absolutely great and sincere thanks for all you efforts. I'm setting up a charitable trust and have one question ... could you please add a sales tax accounting capability to your accounts system?
@Vloggereyenewsandcharity
@Vloggereyenewsandcharity 3 ай бұрын
I want to learn basic of accounting but most of accounting software is too expensive that I can't afford anyway tnx for this vedio it serves a great help to me🎉
@johnreanernocum6355
@johnreanernocum6355 Жыл бұрын
Very impressive! Thank you!
@swagman9203
@swagman9203 2 жыл бұрын
Great work Phillip. I started working on something in Excel to try and replace the ATO's e-record software after they withdrew it and left a lot of small businesses and not for profits in the lurch. Sadly other commitments put a stop to that. This looks really interesting, thank you.
@Tetracarbon
@Tetracarbon 2 жыл бұрын
There is a lot more that needs to be done to get this to the ATOs level of functionality. But I’m working towards that direction
@Tetracarbon
@Tetracarbon Жыл бұрын
Lol. It’s set up as a sole proprietorship. You are talking about corporate accounting. But you go ahead trash talking about my knowledge while spreading missinformation.
@maryamabubakar1175
@maryamabubakar1175 2 ай бұрын
NIce piece i wasnt able to add more rows to my charts of accounts. thank you
@anthonysantamaria4213
@anthonysantamaria4213 Жыл бұрын
A lot of small businesses especially those with simple payroll will benefit from this simplified app. I will be interested in a version with no limit on entries so I can import old records for longitudinal study. CSV import should be simple but if an import destroys cells with formulas may be a problem. There is little joy in reinventing the wheel so it would be great to know when a commercial version will appear?
@mariaelenamorinigo3411
@mariaelenamorinigo3411 Жыл бұрын
Hello. This is great! I have developed something similar for my personal finance.
@SeaOtter65
@SeaOtter65 Жыл бұрын
Thanks you sir are just to kind thanks for the download
@chanthyum6825
@chanthyum6825 Ай бұрын
Thank you, you have share a very good accounting system in Excel. I will use it. I propose you link it to cash flow statement too
@vijayakumar-sb2he
@vijayakumar-sb2he 2 жыл бұрын
EXCELLLENT WORK SIR YOU ARE GREAT
@philippusschutte3093
@philippusschutte3093 2 жыл бұрын
Sounds very good I will go for it.
@Tetracarbon
@Tetracarbon 2 жыл бұрын
If you have questions or whatever, find me on Facebook. I sometimes check Twitter also.
@joseacobo4302
@joseacobo4302 Жыл бұрын
Thanks a lot Philip
@SherAliKhanPK
@SherAliKhanPK Жыл бұрын
Great work
@hassaanalwani9472
@hassaanalwani9472 Жыл бұрын
Hi sir, Congrats on this successful project of yours! Can you pls guide us on adding more accounts , that would be great .
@caqol
@caqol 2 жыл бұрын
Thank you from SA.
@shabib9127
@shabib9127 Жыл бұрын
Well done! Phillip. When is your next edition coming up? Looking forward to it
@ablefabian536
@ablefabian536 10 ай бұрын
Hi phil, great work! when are we going to get version 2?
@nerenlakhraj5252
@nerenlakhraj5252 Жыл бұрын
Hi Phillip ... thank you for this great awesome template as well as your explanation of how to learn Excel Accounting
@nerenlakhraj5252
@nerenlakhraj5252 Жыл бұрын
@Michael Heath ... Not a problem ... Please send your email address
@bingyou2567
@bingyou2567 Жыл бұрын
Hi Neren. I have a small community group to look after and need something exactly like this excel file. Unfortunately, as mentioned a lot on this thread, the normal email software download method is not working - and hasn't for some time. If I provide an email address, would you be able to send it to me?
@Tetracarbon
@Tetracarbon Жыл бұрын
Hey folks. I have had a lot on my plate recently on my personal life. Terminal illness mostly (not me). This project cost me $130 a month to keep the email server going and so I gave up. I promised for free but it cost me a fortune with no source of revenue to pay for it. I will get back to you all soon. I’m sorry. I’ll releases video when it’s back up with improvements.
@reellyfetalk
@reellyfetalk Жыл бұрын
@@nerenlakhraj5252 @Michael health Hey guys can anyone of you email it to me?
@reellyfetalk
@reellyfetalk Жыл бұрын
@Michael Heath You as well Michael if you can send I would greatly appreciate it
@marklavan4083
@marklavan4083 2 жыл бұрын
hi Phil so excited to try this but when I tried to open on excel on a Mac it was broken, looks amazing
@Tetracarbon
@Tetracarbon 2 жыл бұрын
Try using Excel online. Also, there is no VBA. So Mac should work. It might be that you just have an older version of Excel perhaps?
@matthewfoo6095
@matthewfoo6095 4 ай бұрын
Dear Phillip, Firstly, thank you for your generosity in offering the software for free =) My questions are: 1. How do I add rows without affecting all the macros and behind the scene stuff? 2. In the journal entries, is it possible to sort according to dates? 3. Is there a small business version that you have fully developed? Thank you.
@SamiUllah-ty1zz
@SamiUllah-ty1zz 2 жыл бұрын
Excellent
@KaaftoonPss-jy5dr
@KaaftoonPss-jy5dr 10 ай бұрын
Good idea
@NM-gy9jk
@NM-gy9jk Жыл бұрын
Thank you very much for this tool. I appreciate the amount of detail and time that it likely tool you to create it. Any idea when the updated version, including the Bank CSV import feature + code up → automatically journaled and posted, may be made available? Thank you again.
@SuperMoriarty
@SuperMoriarty Жыл бұрын
Thank you so much
@wisdomattram1270
@wisdomattram1270 Жыл бұрын
This is great content
@aneesrashdi9633
@aneesrashdi9633 2 жыл бұрын
Thanks... This is Cool
@piclic199
@piclic199 Жыл бұрын
This is awesome Phillip, do you have a version for eCommerce to track Inventory, Sales and Purchases ???
@ConamaraCounty
@ConamaraCounty 3 жыл бұрын
Can't wait for the more commercial version for VAT registered businesses in Ireland, we have three rates and sometimes four rates and they change ! I like to batch all my paperwork and do it quarterly.
@Tetracarbon
@Tetracarbon 3 жыл бұрын
Hi Chris. Give me an email or chat to me on Facebook. So I don't know the Irish tax system as I'm an Aussie accountant, but I'm happy for the system to adapt. In Australia our GST (VAT) is only 10%. It's either 10% or 0%. The education version as you have it is really to teach student's the mechanics of debits and credits. A system that does exactly want will need some modification. It's possible, but I'd have to think about how to implement it. =)
@Tetracarbon
@Tetracarbon 3 жыл бұрын
Hi Chris. I’m about to email you the Beta Commercial version.
@allikamordeen7021
@allikamordeen7021 2 жыл бұрын
Pls kindly do a version that can work for microfinance institutions like banks with example pls, thanks for the great job u are doing Philip.
@Tetracarbon
@Tetracarbon 2 жыл бұрын
If you are running a bank from an Excel spreadsheet, you are just a little bit crazy.
@ArmanChy-iz9il
@ArmanChy-iz9il 11 ай бұрын
very Helpful
@sathyanarayanansatagopan9069
@sathyanarayanansatagopan9069 2 жыл бұрын
Thank you sir. Please explain how to use standard formula for totalling date-wise debit and credit columns and balance in next line, like cash book in tally.
@tesfalemzekarias8723
@tesfalemzekarias8723 Жыл бұрын
Sir. please how to use standard formula for totaling data wise debit and credit columns and balance.
@vinshar688
@vinshar688 2 жыл бұрын
Thanks
@thomashajicek2747
@thomashajicek2747 Жыл бұрын
Thanks for this video and software. I'm pretty good with Excel and could mimic a lot of what you did to customize for my needs like enough rows and accounts to accommodate the amount I need. The only thing I can't get is what formulas you used to make a journal entry automatically add to the ledgers. Can you share how you did that part? Thanks!
@kevindopson8791
@kevindopson8791 Ай бұрын
Hi Phillip. Thank you so much for your video. Is there a UK version please
@bonniecurrie5452
@bonniecurrie5452 Жыл бұрын
I love the look of your double entry accounting software and would like to start using it. How do I get the program and when is the Small Business edition going to be released? Thanks so much.
@charlesm5390
@charlesm5390 2 жыл бұрын
GAD this is so good very simple to use its all that i need in my business. may i ask if you have any plans to make it editable?
@rajeshs.arolkar1222
@rajeshs.arolkar1222 Ай бұрын
thanks budy
@Scientificandresearch
@Scientificandresearch Жыл бұрын
Very powerful
@louveingreen4952
@louveingreen4952 Ай бұрын
Hi Philip, I just took a look at your video. This is exactly what I was looking for. I am Mortgage broker and Financial Security Advisor in Quebec Canada. I am paying for Quickbooks online and I have to be honest I have it for a year and I still I am not clear on how to use it. I need something simple and I think I can actually use this for my service business. I need to track my income, my expenses, the bills I have to pay and any purchase I have to make relating to my services and I need to track daily and monthly. I am going to give it a try. I hope there have been improvements since this video what put out 3 years ago. 🤔
@threefeet8990
@threefeet8990 Ай бұрын
How did you get on? I'm also thinking about downloading and trying this
@lornesmith1963
@lornesmith1963 2 жыл бұрын
Great and interesting work. Have you update the system yet or still working on this first session. I have seen the good things about the first session and would like to see the latest one. I am helping my son, an the chart of accounts is larger so I hope it works. is there any reason that some of some exerence csn look st your work. I am over 70 an just like to see things.
@stefanfel
@stefanfel Жыл бұрын
You are awsome!
@maxcharlesaddo5507
@maxcharlesaddo5507 Жыл бұрын
GREAT WORK PHILLIP... but couldnt download the software
@lunaRdeltaY
@lunaRdeltaY 2 жыл бұрын
THX!
@rajdruk
@rajdruk 5 ай бұрын
Good explanations. Please share business accounting excel sheets
@rofiqulislam7544
@rofiqulislam7544 Жыл бұрын
Nice video ❤️❤️❤️
@erpaccountingsoftware-pwho1169
@erpaccountingsoftware-pwho1169 Жыл бұрын
Great
@RelaxingMusic-dk5tt
@RelaxingMusic-dk5tt Жыл бұрын
Interesting
@sherriklennert1368
@sherriklennert1368 6 ай бұрын
I am not new to accounting or Excel and I LOVE how you set this up. I AM new to the treasurer position for our school PTO and am excited to use your system. However, when I downloaded your link, it opened in a Read-only file. What do I need to do to gain access? Thank you.
@Tarenja50
@Tarenja50 2 жыл бұрын
Hi Phillip. Looks good. Looking forward to the next version. Phillip if I adopt this it will be used mostly to record my business purchases of raw materials and sales of processed product. Will your next version be ably to generate a reports based on a what I purchase from a supplier and sales to a customer? For instance a report of all my transactions with "Supplier 01" from January to June (or any other time period) and a report of the same for a customer.
@accountingentrymaster5445
@accountingentrymaster5445 2 жыл бұрын
We provide accounting services. If you really need services click kzfaq.info/get/bejne/b8eChql_qtm5gWQ.html
@bingyou2567
@bingyou2567 Жыл бұрын
Hi Tony, I have a small community group to look after and desperately need something exactly like this to manage the very small amount of in's-and-out's. As mentioned a lot on this thread, unfortunately, the normal email software download method is not working - and hasn't for some time. If I provide an email address, would you be able to send it to me?
@DeSeriousSquid
@DeSeriousSquid 2 ай бұрын
Hi Phillip I was just wondering when the business version will be available on your website?
@rahulsuenarine4061
@rahulsuenarine4061 Жыл бұрын
Very great initiative, thank you. How would you end a financial period?
@sansdents7559
@sansdents7559 Жыл бұрын
Have you received the mail with the link? (It doesn't work for me) If yes, could you share it, please? Many thanks
@muhammadyasinshaikh6419
@muhammadyasinshaikh6419 Жыл бұрын
Great work, can I use this software to implement pension accounting
@eddiepaterson1583
@eddiepaterson1583 4 ай бұрын
Great system. We have a 90 person seniors community group. Can you keep payments from the 'individuals' for fees and 'outings' etc without running out of journal entry space or do you need to bulk entry each time. What are the entry limits at this stage. How do you move from 1 period to the next and keep the detail. Do you copy the Spread sheet then erase the journal entries - can't see this part in my mind. Thankyou for this system. Sorry if the questions are fiddly.
@AdeelKhan-km7ge
@AdeelKhan-km7ge 2 жыл бұрын
HI, sir your Accounting System is very use full. so i have one question in terms of how to insert chart of accounts rows or new account add please simplify for me thanks and appreciated
@NanNan-kp9tf
@NanNan-kp9tf Ай бұрын
It is gold. I want to know journal to ledger step.
@dattamarkad3181
@dattamarkad3181 Жыл бұрын
Hi Phillip< Thank you for making this excel software. I have not received the downloading link after filling the details.
@cliveknott
@cliveknott 7 ай бұрын
Excellent software, but how do I include carried forward numbers from the previous year into the current period Balance Sheet
@tallyerptutorials
@tallyerptutorials 11 ай бұрын
Sir , can you please make a video about Google sheets for multiple shops (locations) sales with inventory?
@waleeswaleed4104
@waleeswaleed4104 2 жыл бұрын
Good job man when you will release commercial system
@Tetracarbon
@Tetracarbon 2 жыл бұрын
I will email updates when they are released. That's why I got people to sign up to an email list. If this was the App Store or Google Play, I could just push updates to users. But on this platform that's not possible, so, email.
@tundeodebunmi6333
@tundeodebunmi6333 Жыл бұрын
Thank you Philip for the free accounting software. Please I desire more rows in n the file and I'll appreciate if you can help with this. Many thanks for your anticipated response. Rgds
@Tetracarbon
@Tetracarbon Жыл бұрын
This was written for educational use. If you’re using it to run a business, you might want something a little bit more robust
@CCAFO
@CCAFO Жыл бұрын
That you!
@shamimahmed9425
@shamimahmed9425 2 жыл бұрын
its great Phillip. its a matter of sorrow that the download link is not showing in my mail
@johnchristopher2403
@johnchristopher2403 Жыл бұрын
wow!!!! wow!
@vickirae247
@vickirae247 8 ай бұрын
Could you include invoicing and receivables?
@pedroandaverez9073
@pedroandaverez9073 2 жыл бұрын
What a simple and effective tool, is there a chance to add the Cashflow Statement to it?? If so, please let me know, I can pay you some more for the upgraded version I am asking for. Thank you so much Philip!
@Tetracarbon
@Tetracarbon 2 жыл бұрын
Find me on Facebook. We can talk more. I think you need something very straightforward. Shouldn’t be hard to point you in the right direction.
@rishirajsharma5337
@rishirajsharma5337 2 жыл бұрын
Hi phillip I filled out the form but, didn't receive the download link. Thank you
@gnidilo
@gnidilo Жыл бұрын
Great work Phillip, this looks very neat however I didn't receive the link in my email, I tried with two emails, checked spam folders...but nothing :-(
@advertisingspire
@advertisingspire Жыл бұрын
Hello Phillip, thank you for the great video. do you have any template for service business like digital marketing agency?
@Tetracarbon
@Tetracarbon Жыл бұрын
What do you mean by template? Like a chart of accounts?
@peterdavis9403
@peterdavis9403 2 ай бұрын
I keep looking for something like his that is like Microsoft Money used to be with a cash flow projection, Stock transactions with Capital Gains/Losses, Dividends with their tax distribution breakdowns, and entered in a spreadsheet to project US taxes including quarterly estimated taxes for an individual.
@shaeryshaikh1111
@shaeryshaikh1111 5 ай бұрын
can you please tell me how you put the warning conditions???
@mdariful7506
@mdariful7506 2 жыл бұрын
Great work.....I am from Bangladesh. I am trying to customiszed the system but I can't. Like I want to Insert rows. How can I will do this? May I also get commercial version?
@EdwardTilley
@EdwardTilley 6 ай бұрын
Great tools. I notice that Expenses in Chart of Accts is too small (I need to add expenses) but the table is locked down and I can't add expenses like meals.
@Tetracarbon
@Tetracarbon 6 ай бұрын
It’s the education version which is more than enough for a school class. Too many accounts can confuse students and doesn’t add to their understanding.
Learn Accounting in 1 HOUR  First Lesson: Debits and Credits
22:05
Executive Finance
Рет қаралды 3,5 МЛН
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 345 М.
1❤️
00:17
Nonomen ノノメン
Рет қаралды 11 МЛН
Дибала против вратаря Легенды
00:33
Mr. Oleynik
Рет қаралды 4,5 МЛН
Excel for Finance and Accounting
19:54
Sele Training
Рет қаралды 95 М.
FREE Bookkeeping Spreadsheet Template - Excel and Google Sheets
9:43
The Bookkeeping Channel
Рет қаралды 50 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 86 М.
Practical Excel for Accounting: Pivot Tables, Drop-down Lists, and VLOOKUP
32:17
Excel Features You NEED to KNOW (If you work in Accounting)
16:36
Leila Gharani
Рет қаралды 456 М.
Accounting Spreadsheet  [Excel Template] Create it in 15 minutes
17:08
Mr.SpreadSheet
Рет қаралды 227 М.
Master Data Analysis on Excel in Just 10 Minutes
11:32
Kenji Explains
Рет қаралды 1,8 МЛН
Create a Bookkeeping Spreadsheet in Excel in 10 minutes
13:39
Mr.SpreadSheet
Рет қаралды 218 М.