Excel Based Accounting Software (100% FREE!)
ฝัง
- เผยแพร่เมื่อ 28 มิ.ย. 2024
- 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
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.
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.
This is pure GOLD ! Thanks for sharing your system for the benefit of all ! Truly helpful!
Woooowww when I read books I can't understand but after see this I know the whole process Thankk you very much
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!
Remember. This was intended for educational use rather than seriously supporting a real business.
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
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👍👍 ..
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 👍👍
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.
It's a beautiful effort... Hope to see the commercial version soon...
Great stuff as always Phil!!!!
Mr Wong, thank you for effort on this. Appreciate your help.
God bless you always.
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.
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
This is FANTASTIC! Thank you so much for sharing this amazing tool.
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.
`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?
Well done! Phillip. When is your next edition coming up? Looking forward to it
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.
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?
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😊
I'm excited to try this! Thank you!
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!
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?
Hi phil, great work! when are we going to get version 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.
Great Video!!! It helped me a lot to put things together. Thank you for your effort
This is awesome Phillip, do you have a version for eCommerce to track Inventory, Sales and Purchases ???
Well done, will certainly have a good look at your work!
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.
You' re a legend Phillip thanks
Wow! This looks great! Thanks!
Philip - tried 3 times to download mithout success - pity cause its great
Thank you for your help and explanation
i really liked this, this is wonderful
NIce piece i wasnt able to add more rows to my charts of accounts. thank you
the free template is very helpful! thank you so much for this!
Hi sir,
Congrats on this successful project of yours!
Can you pls guide us on adding more accounts , that would be great .
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.
Sir. please how to use standard formula for totaling data wise debit and credit columns and balance.
Hey mate, you’re a legend
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🎉
Great work simple and best
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.
Thank you for making peoples life easier🤗.
Very impressive! Thank you!
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
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.
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
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.
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
Impressive, sir! 🫡
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.
If you are running a bank from an Excel spreadsheet, you are just a little bit crazy.
hi Phil so excited to try this but when I tried to open on excel on a Mac it was broken, looks amazing
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?
Hello. This is great! I have developed something similar for my personal finance.
Thanks a lot Philip
Thanks you sir are just to kind thanks for the download
Hi Phillip. Thank you so much for your video. Is there a UK version please
Great work, can I use this software to implement pension accounting
Great work
Sir , can you please make a video about Google sheets for multiple shops (locations) sales with inventory?
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.
Thank you from SA.
Hello Phillip, thank you for the great video. do you have any template for service business like digital marketing agency?
What do you mean by template? Like a chart of accounts?
EXCELLLENT WORK SIR YOU ARE GREAT
Excellent software, but how do I include carried forward numbers from the previous year into the current period Balance Sheet
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.
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. =)
Hi Chris. I’m about to email you the Beta Commercial version.
Could you include invoicing and receivables?
Sounds very good I will go for it.
If you have questions or whatever, find me on Facebook. I sometimes check Twitter also.
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.
We provide accounting services. If you really need services click
th-cam.com/video/9aRSFNEsUQ0/w-d-xo.html
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?
GREAT WORK PHILLIP... but couldnt download the software
Hi Phillip<
Thank you for making this excel software.
I have not received the downloading link after filling the details.
Hi Phillip I was just wondering when the business version will be available on your website?
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?
Hello sir i have a restaurant and i want to use this one but i want to add more columns for the journal entry can you help me
This looks great! I am currently using Quick Books for my husbands business. I have a question about entries in the general. Does the system do split entries? I have a weekly payment that has to be split into a dozen or more ledgers. Can your program do that?
Great question on needing to split entries.
Thank you so much
Thanks
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.
Good idea
Very great initiative, thank you. How would you end a financial period?
Have you received the mail with the link? (It doesn't work for me)
If yes, could you share it, please?
Many thanks
Excellent
Great system, but can I change the country and currency?
Hi Philip, I'm retired and would like to do my personal accounting using your software, have you made your commercial version available? Thanks
This is great content
A business that involve bookings online ticket ,I then prepares the invoice for the client what books of account is required?or should I start my accounting record from income statement and how are this accounting record prepared in excel.lastly , how do you link two sheets together so much when you input a data in one it will appear in the other sheet,thank you.
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!
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.
Is the business version out yet? team of 4 we are, want to start a business. I think I could use it for my expense tracking
Hi Phillip, I have a question. Let’s say a business that just started starts out using this system. Then after a few years of growth something a bit more heavy duty is necessary. How do we transfer data?
Thanks... This is Cool
Hi Philip,how can I download your application in accounting system in excel? Thanks
Good explanations. Please share business accounting excel sheets
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.
🤔
How did you get on? I'm also thinking about downloading and trying this
very Helpful
Hi Phillip ... thank you for this great awesome template as well as your explanation of how to learn Excel Accounting
@Michael Heath ... Not a problem ... Please send your email address
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?
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.
@@nerenlakhraj5252 @Michael health Hey guys can anyone of you email it to me?
@Michael Heath You as well Michael if you can send I would greatly appreciate it
It is gold. I want to know journal to ledger step.
Hi, when the period ends do i need to open and start filling a new file for the new period?
Great
can you please tell me how you put the warning conditions???
Good job man when you will release commercial system
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.
Hi phillip I filled out the form but, didn't receive the download link. Thank you
Phillip, there are a few locked cells that I would like to update [jurisdiction, date format, currency]. any chance these can be updated for US users?
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
Muhammad Saqib
For the moment, you are limited to the spaces for account that are already there. Yes, this means you can't insert more accounts. Excel isn't a 'real' programming language or database, so there's not way to do this dynamically without VBA. I've steered clear of VBA in the short term because I wanted to avoid overcomplication.
So, for now, no you can't add accounts if there isn't already space. Sorry!
I'm working on it. =)
Hello, Did you create the small business edition? If so, where can I get it. I really like how this works.
THX!