The Accountants Excel Toolkit: Mastering Spreadsheets

Learn to import and format data in Excel and master the Xlookup function to retrieve prices across sheets.

Import data with the Getdata function from web, Access, and text sources, then apply conditional formatting to highlight salaries and top earners.

Master sorting, filtering, formatting, and data validation in Excel to turn data into a narrative tableau; create tables, remove duplicates, and save your work.

Master double-entry system by applying debit and credit rules to assets, liabilities, equity, and revenue, and use journal entries to produce the balance sheet, income statement, and cash flow statement.

Learn how journal entries record assets, liabilities, expenses, and income using debits and credits with examples like cash, inventory, accounts payable, rent expense, and sales.

Explore how expenses and income are recorded with debits and credits using San Mart examples, and contrast cash versus accrual accounting.

Explore accrual and cash accounting and learn when to recognize expenses and revenues. Master key journal entries, including accounts receivable, accounts payable, and prepaid expenses.

Explore asset classification into tangible and intangible, including current and fixed assets, and see how depreciation and amortization shape the balance sheet, income statement, and cash flow statement.

Practice journalizing Jan 2023 transactions for San Mart Burgers, including cash transfers, purchases on account, sales with cash and receivable, various expenses, and owner drawings, with t accounts.

Explore the general ledger as the backbone of accounting, recording transactions through double-entry and organizing into assets, liabilities, equity, income, and expense accounts. It supports trial balance and financial statements.

Identify and analyze transactions, record journal entries with debits and credits in the general ledger, balance ledgers with a trial balance, and generate financial statements using QuickBooks online.

Link QuickBooks online with the general ledger by converting an Excel transaction tab to CSV and uploading it to a bank account to consolidate sales, purchases, and third-party entries.

Balance debits and credits across ledger accounts to verify the trial balance. Explain how assets, liabilities, revenues, and expenses harmonize through double-entry and reflect a balanced general ledger.

Master the accuracy check for trial balance and general ledger by applying reconciliation, error prevention, and automation with QuickBooks Online, ensuring precise debit and credit reporting in spreadsheets.

Master adjusting entries to ensure accurate financial reporting and revenue matching, using QuickBooks Online to record debits, credits, and descriptions for reliable statements.

Journalize January transactions for San Mart burgers, post to T accounts, and prepare a trial balance with adjusting entries to deepen practical accounting skills.

Explore the balance sheet as a dynamic financial snapshot of assets, liabilities, and shareholders' equity, guided by the equation assets equals liabilities plus equity, with current and non-current assets.

Explore the income statement, tracing revenue, cost of goods sold, gross profit, operating income, and how expenses, taxes, and net income tell the financial story.

Decode the three pivotal sections operating, investing and financing activities to reveal a company's true cash dynamics and the cash flow story beyond net income.

Master financial reporting in Excel by adding formulas and links across income statements, balance sheets, and cash flow statements, using sum, countif, and sumif to create dynamic, linked financial statements.

Explore ratio analysis as a financial compass that uses liquidity, solvency, profitability, efficiency, coverage, and market prospect ratios to interpret a company's statements and trends.

Apply ratio analysis in Excel to assess profitability, liquidity, efficiency, and solvency using San Martin’s statements, interpreting net revenue growth, margins, receivables turnover, and debt metrics for decisions.

Explore ratio, trend, and common size analysis to reveal a company's financial health, visualize net revenue growth with bar charts and sparklines, and interpret year-over-year changes.

Explore Excel-based financial forecasting, using simple and weighted averages to project pro-forma income statements, guided by grounded assumptions and goal seek to hit target profits.

Convert the trial balance into an income statement and balance sheet, detailing assets, liabilities, and equity, while calculating net income and total equity from revenues and expenses.

Learn to gather bank and company records, and implement timely reconciliations—daily, weekly, or monthly—based on business size to ensure complete, accurate financial statements.

Master the reconciliation process by cross-checking the general ledger with third-party data, addressing discrepancies, and posting journal entries to produce a complete reconciliation report for accurate financial narratives.

Master the reconciliation process in QuickBooks Online by matching bank statements to transactions, addressing discrepancies, using PDF to Excel conversions, and applying clear and reconciled statuses.

Learn to prevent reconciliation issues by using QuickBooks Online to connect bank accounts, bridge payment platforms like Stripe, Square, and Shopify, and auto-categorize transactions with rules for consistency.

Upload a csv to QuickBooks online, import 21 transactions into account 001, classify as cost of labor and third-party sales, and reconcile to a 1509.24 ending balance.

closing reflection highlights mastering Excel tools, importing data, and using Xlookup to analyze financial health, while transitioning to QuickBooks Online for dashboards and ratio analysis.