How To Create A Dynamic General Journal & Accounts Register In Excel

How to get this project

Hello 👋, what is the difference between general journal and transaction sheet ?

I'm an absolute beginner. Can you guide me on how to start in Excel Accounting field?

What version of excel are you required to have?

Hi, is there a first part to this tutorial where you show set up, as I wasn't really able to follow along

Hi Randy do you just have the template of this amazing work that we can customize Available?

after i download and opened when i try to click something it says "no add-in" what does it mean

How fix dynamic rows within counifs function
For eg countifs($a$1:Lastrow, criteria 1, criteria range2, criteria2)
My question is what I can use in place of Lastrow nd if we use .end (xlup). count here how can we fix this dynamic row that work with different source data like some of 80 row so in different file may be it have more or less. Thanks

I need this file please can you share.

How to delete already posted data?

thank you sir

Need this file plzzz

I think bill gates didn't expect that Microsoft excel can do that 👍👍

Hi Randy, do you have a workbook out there that's all-in one? For example, it has the dynamic general ledger where you input your transaction. Then from the general ledger have a sheet that automatically pulls the info from the general ledger to make the profit/loss, balance sheet, trial balance and some informational dashboards?

Hi Randy,
Another of your good program and so well explained.
Thank you for your time.
I have a question. How would you takled it if I have for some account taxes..??
Could I have more columns, one for Net Amount, one for taxes and one for Amount including taxes??
Thank you for your support and your ideas.

Hello

Please create Complaint software with mobile application,,✅

The downloaded file dont call the calendar and dont have the button to save records

I really Appreciate your work.
May God Bless you
For sharing Such Great videos with us
Sir kindly tell me which MicroSoft Office Version you're using mean
Ms Office 2010 ,2013 or which one?

tnx sir

Sir we want school result management tutorial

Nice video 😊😊😊

You know your amizing than

Nice video please explain everything deeply in all don't do early

Hi Randy,
I see here lot of views, who have enjoy and learn from your post. but I am sorry to say you, I cann't understand. May be I am new learner. But I must say this journal is unique. I want to learn and make like that dynamic g. gernal. This video can help me for my goal achieve ?pls help me.

Hello please make full automatic accounting software In excel

Wow I might actually be able to use this...but I'd love to reach out to enquire about other potential scenarios for identifying mismatched transactions and discrepancies

hi randy how can i get this

What's the password? for downloading the file

Please prepare all sheet as new then we can understand easily but you have worked provided data. That's why I am not able to understand properly

Please publish from start

Hi! Up to how many entries can your Dynamic General Journal take in? And will it still run fast if it already as about 100,000 entries?

hi do u have accounting software as a whole? from GL to Financial statements?

I want to get your email or contact number to install this system in my computer

Hello Randy,
I have entered my name and email address to get the Accounting Template but I have not received anything from you. what is the issue ?

HI Sir, I want to develop a account register for cargo business. plz help me for this

This is everything I've been looking for. You did an amazing job.

I have been watching this video and it is absolutely just wonderful seeing what you have created here. you are definately a guru in all things excel. I was curious as to if there was a video on how you built the dynamic general ledger from scratch?

Thank you sir, It is a very interesting presentation. How can we make the such type statement. if any course arrange please inform me.

How do I get this specific workbook?

Dear sir if u can make a video on currency exchange business accounting software please

Hi Sir,
How can i get the work book?

It would be helpful if the chart of accounts was in the standard accounting order: Assets, Liabilities, Equity, Revenue, CoGS, Expenses

its excellent but not helping in entry with more then one line , salaries , petty cash , , and many other entry which has more then 2 line

Peace, mercy and blessings of God be upon you
First, I only need one file that contains everything
1- The purchase invoice is made automatically by two things: the free accounting entry and the permission to add
2- Likewise, the sales invoice is made in an automatic way, two things: the free leader, the accountants, and the permission to exchange
In addition to taxes, their percentage and value, the same applies to employees and fixed assets that need to be depreciated by a percentage and value

Looks great but in your demonstration each transaction has only 2 line: 1 line debit and 1 line credit. It seems it doesn't work when you want to enter an transaction with more than 2 lines.

Great video. I'm even more grateful he switched to starting from a blank sheet

dear from this how to create trial balance profit and loss balance sheet and also cashflow statement can you create a video on this