Accounting Information Systems 99.3% – (Bookkeeping) (Sarah’s Design Excel)

One of my last classes at Devry was ‘Accounting Information Systems ‘ which was a full course on bookkeeping. The semester project was called ‘Sarah’s Design’.

Accounting information systems was a bookkeeping course (Jan – Feb 2022). Over the Christmas/Hanukah/New year’s 2-week break, investigating this upcoming class, stumbled across the semester project, a 1-month full business cycle for (Sarah’s Design) to be done in MS Excel. Spending my two-week holiday doing the term project. When class Started in January, I had completed 80% of the project, before being told “its a Group Project!” The Project was to be done in Excel, using formulas throughout.

Sarah’s Design Excel Project

Bookkeeping Course

The list of transactions Sarah made during her 1st month of business before hiring a bookkeeper.

Sarah’s list converted to Journal Entries.

Chart of Accounts

Key to Chart of Accounts

From this point on, every single yellow cell is an ‘Imbedded Formula’ computer programing.