Hi mister, My master. your teachings are incredible and I am learning a lot. Now I have a question, I would like to add "composite entries" to debit and credit. It's possible? In my country's accounting, we have often had several debits and several credits
YEs for sure we call that also compound or split transactions, You can add an additional table, linked to the original transactions that links all of your composite entries together. I hope this helps and thanks so much.
This is great!! Thank you for all your how-to videos, I've learned and applied a lot of them. Can you also make a how-to video about records and office file manager? Thanks and awesome job!
Hi Rose, thanks so much. I am glad you like it. I have a few videos on my channel to help with records management. you can do a search for "File Manager" and another for "Email Manager" both series will help you organize your files. Thanks so much.
Great work. I am having an issue that the data validation for the first row of a new entry is allowing for a compound entry selection and the second row of the new entry does not. Is there somewhere in the vba when new rows are added to the bottom that the proper data validation rules are applied
When making a free entry It has more than 100 movements, for example, and let it be, for example, 50 debits of the fund, fifty of the bank, fifty debits of expenses, and fifty debtors of commission, and we recorded those with a total of three movements with a total debit of 200. Here I mean that the difference always appears between the transactions and always, and its second value appears. Why is the balance of each account before the movement and the balance of the account after the movement on me, and this is an exception to the entry work Third I saw the details of the movements on the account and the rest of the accounts. A composite entry is running. This entry must be run. Each independent account appears with transactions with a previous balance. And a balance after the movement that shows the total balance of the main account for those sub-accounts, for example in expenses, or customers, or various creditors or various debits. Thank you
Hi and thanks you are welcome to request a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.
HI and thanks. I am creating an entire accounting application from scratch including Invoicing, Inventory, Purchases, Bills, Credits, Charges, Recurring Transactions, General Journal, Chart Of Accounts, Sharing & Sync, Dashboard and a ton more in my Mentorship Program. You can learn more and join us here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
HI and thanks I have the entire accounting application as part of the Mentorship course available here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
Hi Ghaleb, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
I need to use one list only one list from which I can call at any account both of basic account or sub account and automatically transfer transaction to ledger and the balance sheet and the financial lists Also want to Have option if I want make Pick up automatically or manually also want the sheet Has option to ask me what method you want to evaluate the final stock when I press one button to evaluate the final stock when I Start to go to Prepare final lists Too thanks
Hi and thanks for your comment. The application is open and you are welcome to customize this to fit your exact requirements, however I am unable to take on any projects of my own. If you would like some help with this, we have a group with 40,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.
Hi and thanks it would be difficult to write that code into a RUclips comment however I teach that in my Excel For Freelancers Mentorship course in which I design a complete Accounting application here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
5 лет назад+1
Hello Randy. Have you thought of a way to expand all the compound entries in just one click? That would be sooooooooo useful ...
HI Helene, it works in just one click the way it is now (one click to expand, one click to close) IF you mean when we select on the transaction, then that would be super simple, to just check if it contains "[Compound Entry]" then automatically expand it. That is more of a personal choice so it would be just one line of code for you to add if that is what you would like to happen.
5 лет назад+1
@@ExcelForFreelancers I really mean expanding all the compound entries in one click. Let's say I have 8 or 10 compound entries in a given month and I want to see all the details of all the entries at a glance, it would be nice to be able to click on a single icon to "open" all the compound entries, not having to click on 8 or 10 icons. Really a "plus" when you have to review your accounts at the end of the month. Thanks Randy.
Hi Helene, sure that could be completed quite easily with a For/Next Statement along with an If/Then statement. I just worry if the user has selected all dates, there could be a few thousand rows and this would take some time to complete. Thanks very much.
5 лет назад+2
@@ExcelForFreelancers Well, I think that the user will select one month at a time so it wouldn't be such a big issue (that's how I would search). Thanks.
HI and thanks this is the only one I have (part 1/ Part 2) however I have done an Advanced one in the Accounting application that I am developing in the Mentorship Program. You can learn more about that here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Hi Jonas, I use it quote often actually. You will see when you download the workbook it is contained in a module already as part of a StopCalc and StartCalc macros.(along with calculations set to manual as well) I use it to speed up the macros in many macros where i want it to speed things up. Thanks for your comment.
Hello Randy, thank you. I tried to delete all dummy entries and insert fresh ones, but once i click on refresh, everything will reset and all old entries are back. Is there any way I can permanently delete entries?
Hi and tanks. Make sure you clear all the original data and watch the complete video to learn how to locate the original data. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Thank you so very much, I really appreciate that Faisal :)
5 лет назад+1
Hello Randy. There is a problem with the file. Within compound entries, certain accounts and amounts appear twice. And if we correct the entries, close the compound entry and then open it again, the entries are multiplied.
Hi Helene, Thanks very much for alerting me to this. I will be doing a complete Accounting application in which all small issues get fixed. I should launch that program next month so please make sure you get signed up as an Early Bird Member here: bit.ly/MentorshipProgram_EarlyAccess
HI and yes you can change the # to Void if you like it or add additional functionality for that. I am teaching VOID Transactions in the accounting application that I am building inside the Mentorship program here: bit.ly/MentorProgram_YTComment
HI Aamir, thanks very much. I am unable to take on any projects however if you email me a detailed project scope I can refer it to a qualified developer. Randy@ExcelForFreelancers.com Thanks very much
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
Hi mister, My master. your teachings are incredible and I am learning a lot.
Now I have a question, I would like to add "composite entries" to debit and credit. It's possible?
In my country's accounting, we have often had several debits and several credits
YEs for sure we call that also compound or split transactions, You can add an additional table, linked to the original transactions that links all of your composite entries together. I hope this helps and thanks so much.
This is great!! Thank you for all your how-to videos, I've learned and applied a lot of them. Can you also make a how-to video about records and office file manager? Thanks and awesome job!
Hi Rose, thanks so much. I am glad you like it. I have a few videos on my channel to help with records management. you can do a search for "File Manager" and another for "Email Manager" both series will help you organize your files. Thanks so much.
@@ExcelForFreelancers Thank you! I did not expect to receive a reply.
Very good video ❤️❤️❤️
Thank you very much. So nice of you Rofiqul
As always, beautiful work. Loving it. Thanks for the share.
For sure, you are very welcome Syed, I am really glad you enjoyed this training as well.
It's amazing program from amazing teacher. Thanks for your effort.
Thank you so much Hassanin, I am glad you liked it.
Randy, awesome job. Looking forward to the mentor-ship program!
Thanks so much Charlie. I am really looking forward to it as well. I will finally get the chance to dig in deep and create programs from A to Z.
How would you go from journal to create both the balance sheet and statement of financial position
Hi and thanks so much for your comment. I share that with you here: ruclips.net/video/4j9XtiCFsz8/видео.html
I hope this helps and thanks so much.
Great learning
Thank you so very much, I really appreciate that Reza
Great work. I am having an issue that the data validation for the first row of a new entry is allowing for a compound entry selection and the second row of the new entry does not. Is there somewhere in the vba when new rows are added to the bottom that the proper data validation rules are applied
Hi Glen, I saw your post in our group and I added an answer there. Thanks so much.
Woo. I'm excited to watch this....thanks Sir....
Thanks so much. I hope you enjoyed it.
@@ExcelForFreelancers yes of course.... your work is really great.. As an Accountant, I still not get the things what I need.
Good video
Thank you so very much, I really appreciate that.
thank you for your lesson
For sure, you are very welcome
When making a free entry
It has more than 100 movements, for example, and let it be, for example, 50 debits of the fund, fifty of the bank, fifty debits of expenses, and fifty debtors of commission, and we recorded those with a total of three movements with a total debit of 200.
Here I mean that the difference always appears between the transactions and always, and its second value appears. Why is the balance of each account before the movement and the balance of the account after the movement on me, and this is an exception to the entry work
Third
I saw the details of the movements on the account and the rest of the accounts. A composite entry is running. This entry must be run. Each independent account appears with transactions with a previous balance.
And a balance after the movement that shows the total balance of the main account for those sub-accounts, for example in expenses, or customers, or various creditors or various debits.
Thank you
Hi and thanks you are welcome to download this application and customize it however you like. I hope this helps and thanks so much.
Thank you so much sir, but can you help me add compound entries for the debit sides too?
Thank you in advance
Hi and thanks you are welcome to request a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 30,000 Members who would love to help you with this. Thanks so much.
Super amazing. 🙂👍🏻❤️❤️
Thank you so very much, I really appreciate that.
great tutorial, I'll wait
Thaos so much. I am really glad you liked it.
That is amazing and great video
but how i can developed this type of program initially, because i am student of accounts and finance. Guide me
HI and thanks. I am creating an entire accounting application from scratch including Invoicing, Inventory, Purchases, Bills, Credits, Charges, Recurring Transactions, General Journal, Chart Of Accounts, Sharing & Sync, Dashboard and a ton more in my Mentorship Program. You can learn more and join us here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Hi do you have the whole accounting software? where to buy?
HI and thanks I have the entire accounting application as part of the Mentorship course available here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
I hope this helps and thanks so much.
Hi There..it's a great tool ..how can i get it..please advise...thanks
Hi Ghaleb, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
I need to use one list only one list from which I can call at any account both of basic account or sub account and automatically transfer transaction to ledger and the balance sheet and the financial lists
Also want to Have option if I want make Pick up automatically or manually also want the sheet Has option to ask me what method you want to evaluate the final stock when I press one button to evaluate the final stock when I Start to go to Prepare final lists
Too thanks
Hi and thanks for your comment. The application is open and you are welcome to customize this to fit your exact requirements, however I am unable to take on any projects of my own. If you would like some help with this, we have a group with 40,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
I hope this helps and thanks so much.
how can free download this template sheet? is it available or not?
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Where is the defrent number between debit and credit during entry to descover any mistake?
Hi and thanks this double entry will show both Debit & Credits and they must always match. I hope this helps and thanks so much.
Great video! How about if i make compound entry on even rows? what will be the code
Hi and thanks it would be difficult to write that code into a RUclips comment however I teach that in my Excel For Freelancers Mentorship course in which I design a complete Accounting application here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Hello Randy. Have you thought of a way to expand all the compound entries in just one click? That would be sooooooooo useful ...
HI Helene, it works in just one click the way it is now (one click to expand, one click to close) IF you mean when we select on the transaction, then that would be super simple, to just check if it contains "[Compound Entry]" then automatically expand it. That is more of a personal choice so it would be just one line of code for you to add if that is what you would like to happen.
@@ExcelForFreelancers I really mean expanding all the compound entries in one click. Let's say I have 8 or 10 compound entries in a given month and I want to see all the details of all the entries at a glance, it would be nice to be able to click on a single icon to "open" all the compound entries, not having to click on 8 or 10 icons. Really a "plus" when you have to review your accounts at the end of the month. Thanks Randy.
Hi Helene, sure that could be completed quite easily with a For/Next Statement along with an If/Then statement. I just worry if the user has selected all dates, there could be a few thousand rows and this would take some time to complete. Thanks very much.
@@ExcelForFreelancers Well, I think that the user will select one month at a time so it wouldn't be such a big issue (that's how I would search). Thanks.
You're GREAT❤
Thank you so very much, I really appreciate that
Can you share video on Advanced ladger accounts
HI and thanks this is the only one I have (part 1/ Part 2) however I have done an Advanced one in the Accounting application that I am developing in the Mentorship Program. You can learn more about that here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Do you use "application.screenupdating = false" ? if not, you should
Hi Jonas, I use it quote often actually. You will see when you download the workbook it is contained in a module already as part of a StopCalc and StartCalc macros.(along with calculations set to manual as well) I use it to speed up the macros in many macros where i want it to speed things up. Thanks for your comment.
Hello Randy, thank you. I tried to delete all dummy entries and insert fresh ones, but once i click on refresh, everything will reset and all old entries are back. Is there any way I can permanently delete entries?
Hi and tanks. Make sure you clear all the original data and watch the complete video to learn how to locate the original data. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Words is not enough to explain our feelings 😅
Thank you so very much, I really appreciate that Faisal :)
Hello Randy. There is a problem with the file. Within compound entries, certain accounts and amounts appear twice. And if we correct the entries, close the compound entry and then open it again, the entries are multiplied.
Hi Helene, Thanks very much for alerting me to this. I will be doing a complete Accounting application in which all small issues get fixed. I should launch that program next month so please make sure you get signed up as an Early Bird Member here: bit.ly/MentorshipProgram_EarlyAccess
Is there anyway to void an entry?
HI and yes you can change the # to Void if you like it or add additional functionality for that. I am teaching VOID Transactions in the accounting application that I am building inside the Mentorship program here: bit.ly/MentorProgram_YTComment
I want to create vendor tax management software in excel can you help me
HI Aamir, thanks very much. I am unable to take on any projects however if you email me a detailed project scope I can refer it to a qualified developer. Randy@ExcelForFreelancers.com
Thanks very much