Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Can we do complete financial accounting in Excel - From Voucher Entry, Cash Book, Journal, Ledger and trail balance automatically in Excel. Any sampl

0

Hi,

I am tryin to do complete financial accounting in Excel - From Voucher Entry, Cash Book, Journal, Ledger and trail balance automatically in Excel.  Any sample available  anywhere woul be appreciated.

In this without using macro or vb, is it possible to do above using functions, linking, etc.

Like when I make a cash payment, in journal I will enter it, but automatically it should go to cash book posting, purchase book posting and should provide me the trail balance

Any help appreciate, thanks in advance

Answer
Discuss



Answer the Question

You must create an account to use the forum. Create an Account or Login