Excel Accounting System

My goal with this is to create an Excel spreadsheet that can help you through the entire accounting cycle. At the moment, all this Excel sheet can do is help you record transactions, post them to your general ledger, view t-accounts, and view other account data. You can easily use the information provided by this worksheet to make financial statements.

I wanted to publish this now because I think it’s at a stage where it can be used for basic Accounting, and I believe it is fairly easy to build upon if you want to add features to it.

In the future, I will add a way to automatically generate the 4 basic financial statements and a Trial Balance. I’d also like to add a feature that automatically creates all the closing entries for an accounting period that the user determines. It would also be nice to add regularly occurring transactions.

I will add more features throughout this semester, but I wanted a way to showcase my knowledge of Accounting and Microsoft Excel.

To use the file, you do not need to enable Macros, but I recommend that you do. It makes it easier to input your journal entries into the Transaction Table.