Mock-up Company
Mock-up Company
Embedded Files
Ascend Digital Solutions
Ascend Digital Solutions is a mock digital marketing agency I created to demonstrate my full bookkeeping workflow. From initial setup to financial analysis. This project simulates a real-world client using QuickBooks Online, Google Sheets, and Excel over a 6-month period.
Company Overview
Company Overview
Here is the company overview for Ascend Digital solutions
Bookkeeping Setup in QuickBooks Online
Bookkeeping Setup in QuickBooks Online
Chart of Accounts
Chart of Accounts
Created a custom Chart of Accounts with 120+ accounts in Google Sheets.
Downloaded as CSV and then imported to Quickbooks Online
Class Tracking
Class Tracking
Enabled Class Tracking in Quickbooks Online for profitability by service
Opening Balances
Opening Balances
Entered Opening Balances for bank, A/P, equity and liabilities via Journal Entry in Quickbooks
Invoicing Workflow
Invoicing Workflow
Expense Management
Expense Management
Expense Tracking & Vendor Bills
Created realistic monthly operating expenses
Included payroll, contractors, software, and office costs
Matched revenue > expenses monthly to reflect profitability
Used Spreadsheet Sync in Microsoft Excel to upload Expenses to Quickbooks online
Bank Reconciliation
Bank Reconciliation
January Bank Reconciliation
Imported mock bank transactions
Performed month of January reconciliation
Ensures transactions are accurate and balanced
Bank Recon of ADS (1 31 2024).pdfQBO Bank Reconciliation Screenshot and Mock-up Wells Fargo Bank Statement
QBO Bank Reconciliation Screenshot and Mock-up Wells Fargo Bank Statement
Financial Reports & Business Insights
Financial Reports & Business Insights
Generated Balance Sheet, P&L and Cash Flow Statement
Generated P&L by Class (to show service profitability)
Performed basic financial analysis: Net Profit Margin, Expense Ratio
BalanceSheet.pdfStatementofCashFlows.pdfProfitandLoss.pdfProfitandLossbyClass.pdfFinancial Analysis and Reporting
Financial Analysis and Reporting
Tools Used
Tools Used
Page updated
Report abuse