Week 15
Focus: Company setup, chart of accounts, bank feeds, recurring transactions.
Key Responsibility: Maintain digital accounting records using software and spreadsheets.
Support my Free Online Educational Resource Center for Accounting Students (LucaPacioli123.com) website!
Thank you,
Salvador Soto Jr, MSA
Overview
Week Overview
Week 15 prepares students for real-world bookkeeping by introducing modern accounting software tools and spreadsheet skills.
Students learn to set up company files, build a chart of accounts, connect bank feeds, automate recurring transactions,
and use Excel/Google Sheets to support reconciliations and schedules.
Objectives
Weekly Learning Objectives
- Set up a company file in bookkeeping software.
- Customize the chart of accounts to fit business needs.
- Connect and manage bank feeds.
- Create recurring transactions such as invoices, bills, and JEs.
- Use Excel to prepare schedules, reconciliations, and data analysis.
- Export/import transactions and reports.
- Perform data cleanup and detect common software setup errors.
Concept 1
Setting Up a New Company File
- Entering business info and fiscal year.
- Choosing cash vs. accrual basis.
- Setting user roles and permissions.
- Configuring system settings and defaults.
Concept 2
Chart of Accounts (COA)
The chart of accounts is the backbone of financial organization.
- Account types: assets, liabilities, equity, income, expenses.
- Using and modifying default COAs.
- Industry-specific account needs.
- How account names affect report presentation.
Concept 3
Bank Feeds & Automation
- Connecting bank and credit card accounts.
- Matching, accepting, and categorizing transactions.
- Creating automation rules.
- Identifying duplicate or miscategorized activity.
Concept 4
Recurring Transactions
- Recurring invoices for subscription services.
- Recurring bills or expenses.
- Memorized journal entries (depreciation, prepaids).
- Automation do’s and don’ts.
Concept 5
Excel & Google Sheets Skills
Essential Formulas
- SUM, SUMIF, SUMIFS
- COUNT, COUNTA
- IF statements
- VLOOKUP / XLOOKUP
- PivotTables introduction
Practical Uses
- Prepaid and accrual schedules
- Reconciliation templates
- AR/AP tracking sheets
- Depreciation schedules
- Data cleanup for imports
Activities
In-Class Activities
1. New Company Setup Lab
Students configure a new company file using sample data.
2. Chart of Accounts Cleanup Exercise
Students merge duplicates, rename accounts, and reorganize categories.
3. Bank Feed Matching
Students match sample bank transactions with invoices and expenses.
4. Excel Mini-Workshop
Students build schedules and simple reconciliations using formulas.
Homework
Homework Assignments
- Assignment 1: Company file setup & screenshots.
- Assignment 2: Categorize bank transactions.
- Assignment 3: Excel schedule creation.
- Assignment 4: Create recurring transactions.
Discussion
Discussion Prompt
Which tasks should be automated and which should remain manual? Why?
Quiz
Quiz Topics for Week 15
- Company file setup steps
- Chart of accounts components
- Bank feed functions & rules
- Recurring transaction setup
- Excel formulas and uses
- Common software setup errors
Summary
Week 15 Summary
Students now understand how to configure accounting software, manage automation tools, and use spreadsheets to support
digital bookkeeping workflows. These technical skills prepare them for entry-level bookkeeping and accounting roles.