Accounting System on Excel - journal Entries to Financial Statement - for small Business

The full video is available for members only.
If you use Microsoft 365
I recommend to watch this series

A lot of people are looking for an accounting system for a small business on Excel. And many ask: How can the journal entries be written and posted to the ledger?
How can the trial balance and financial statements be prepared?
Should I use formulas, or macros, or pivot tables?
In this lesson we will answer all of these questions.
We will prepare a small accounting system, without using macros.
This system is for a small service company, as well as you can use it for commercial companies, But without inventory control.
we will define the chart of accounts and write journal entries in the journal with an example, and create a sheet for general ledger, then will get the account balances to use them later in the trail balance and financial statements.

to join the membership

[msteochewmuey]

Hi, I managed to follow your steps well, except for the pivot table for the balance sheet. I couldn’t insert calculate item for the “Total Liabilities and Equity”. I received error message ‘An item name is ambiguous. Another field in the PivotTable report may have an item with the same name.’ I tried googling for solutions. But couldn’t find any. Could you help me with this? Appreciate your time or this. Thank you.

[ViralVital]

Can I love ❤️ the video instead of liking it?! May God shower His blessings on you

[SandeshPoudel-mz]

After creating Pivot Table if I update new value to my COA then it won't be updated in Pivot Table why ? is there way to resolve this ?

[alexrosen]

A precise step by step tutorial. Extremely useful. Thank you 🙏

[ahmedel-btal]

hello ahmed, thank you for our Effort, i'd like to setup meeting with you in person ( if you live in egypt ) or online if you are abroad, please advise

[rajmohanray]

It's not downloading please send link to download your account Excel file please 🙏

[SukhbirWadhwa]

Howcan we get template of Accounting System on Excel

[stevembwana]

how can you incorporate bank Reconciliation into the system?

[ronnie]

One of the best tutorials I have seen when it comes to usage of excel functions to automate reports. Thank you for your efforts Ahmed.

[abdisamadoon]

can i get this template excel for free to practise

[abdiazizibrahim]

Thanks for sharing but just i am having one issue; when use indirect on cell J6, i am getting "Rent Expense" instead of error as you got it, why?

[gdftr]

Mashallah great video brother..luv from india.

[pardeepsangruri]

Great video...why did you use the cash account a default? Can we use it any other account?

[rm]

I can not do the updating of the accounts, I'm following your steps but it won't work with me, can someone help me please?

[md.shamimhossain]

Please sir provide patrice file if possible

[ericng]

how to download the excel sheet. Thank you.

[djyana_projectinsights]

I hope you can create another like this but really from the bottom like beginners using excel. Thank you.

[mosaqib]

From 7:14 second data validation process is not clear to me and I'm unable to understand that, even though I've followed the exact same steps in the web version of MS Excel on my old laptop. Kindly explain to me, please.

[hazemkamalmaz]

ممنونين استاذ.
ممكن رابط قناة التيليجرام من بعد اذنكن لنطلب الملف

[djyana_projectinsights]

Sir.. I don't understand this part, several times I attempted in my excel to practice yet I don't get it right. I hope you help, I'm loving this basics.