An all Excel Accounting Solution with complete chart of accounts, journal, ledger, trial balance, Income statement and Balance sheet that update dynamically as the record of journals is populated.
This education version solution has been developed for Student and macro business. It’s designed to be small enough for students to understand the entire accounting process. No VB; no macros.
Requires Excel 2019 or greater.
Step 1: On the Set Up Tab, change :
the Business Name,
ABN (optional) and
Start and End dates of operation.
Step 2: Set up your Chart of Accounts in the Chart of Accts tab.
You can NOT add new accounts if there is not space (limitations of Excel without VBA).
If you want more accounts, tell me. Business version should have +30 expense accounts.
Step 3: Enter your opening balances in the “Open TB” tab (Trial Balance).
Step 4: Journal entries go in the Gen Jnl tab.
Journal references are simply whole numbers (“GJ” is automatically added).
Dates MUST be within the accounting period on the Set Up tab.
Accounts can be selected using the drop down box.
(Shortcut key Alt + ↓ )
Post refs are entered automatically.
Enter Dr/Cr value. Formula are ok! =)
Hint: Avoid pasting over cells.
You can paste over the formatting and this can break functionality.
Note that Paste-as-values will always work!
Step 5: Gen Ledger tab is 100% automated.
You can’t edit it, but you can copy-paste from this tab to either MS Word or a new Excel spreadsheet.
Step 6: The Trial Balance tab is also fully automated.
You can copy-paste from this tab too!
Step 7: Reports are on Income Statement and Balance Sheet.
You can edit the accounts and the values that appear on the balance sheet and Income Statement.
You can not add or delete rows. You can’t change the overall format (again, an Excel limitation)
- Excel based Accounting Software
- 14 minutes Tutorial Video