Designing an Automated Journal
A journal entry sheet that checks the entry balances and the accounts are valid before saving.
Course contents
- 1The structure of the journal table
- 2The entry screen
- 3Checking the entry balances
- 4Compound entries
- 5Entry numbering and dates
What you gain from the course
You can build a journal that rejects an unbalanced entry or a non-existent account.
Other courses in the same track
Stage 2: Building the core
Ledger and Trial Balance with Dynamic Formulas
Producing the ledger and trial balance straight from the journal using dynamic array formulas.
Automated Posting with AI Assistance
Building automatic posting of entries to accounts, with formulas or code written with AI assistance.
Automated Financial Statements: Income, Balance Sheet and Cash Flow
Financial statements that update automatically from the trial balance when the period is selected.