Caroline Nduku Musyoka
Certified Bookkeeper | Clean Books| Excel& AI| Sharp Reports
New to Contra
Caroline Nduku is building their profile!
QuickBooks Online Bookkeeping — Nonprofit Case Study (Heritage Humane Society)
Set up a complete QuickBooks Online file for a nonprofit organization from scratch. Work included building a full chart of accounts with 47 accounts, importing vendors and donors via CSV, recording 12 months of transactions, applying FASB ASC 958 nonprofit accounting standards with 6 program classes, reconciling bank feeds, posting year-end adjusting entries, and producing all four nonprofit financial statements reconciled to within 1.6% of IRS Form 990 figures
0
5
AI-Assisted Invoice Processing & Data Cleaning
Description: Demonstrated end-to-end invoice processing workflow — taking 12 raw invoices with formatting errors, duplicates, missing categories, and currency mismatches, and producing a clean, audit-ready dataset. Identified and removed 2 duplicate invoices, standardized all date and category formats, flagged USD currency for conversion, and delivered a reconciled summary of KES 909,200. Reflects AI-assisted data cleaning workflow.
0
12
AI-Assisted Invoice Processing & Data Cleaning
Description: Demonstrated end-to-end invoice processing workflow — taking 12 raw invoices with formatting errors, duplicates, missing categories, and currency mismatches, and producing a clean, audit-ready dataset. Identified and removed 2 duplicate invoices, standardized all date and category formats, flagged USD currency for conversion, and delivered a reconciled summary of KES 909,200. Reflects AI-assisted data cleaning workflow.
0
19
Monthly Bookkeeping Report — P&L & Balance Sheet
Description: Prepared a full monthly bookkeeping report for a consulting firm covering Q1 2026. Includes a 3-month Profit & Loss Statement with revenue breakdown, operating expenses, net profit calculation, and profit margin analysis, plus a complete Balance Sheet showing assets, liabilities, and owner's equity. Built using QuickBooks Online and Microsoft Excel.
0
20
Project Title: E-Commerce Order Data: Exploratory Analysis & Business Insights
Description:
Analyzed 1,200 e-commerce orders (Jan 2023 – Jun 2025) to uncover patterns hiding in the data and translate them into business recommendations. Key findings included identifying that 41% of total order value ($519,674) was tied up in cancelled or returned orders — a number that gives leadership a concrete target for recovery — and validating that 8 "statistical outlier" orders were actually the business's highest-value bulk customers, not data errors.
The analysis covered descriptive statistics, outlier detection (IQR and Z-score methods), revenue segmentation by product/payment method/referral source, correlation analysis, and time-trend tracking — all delivered with clear visualizations and an executive summary built for non-technical stakeholders.
Skills/Tags: Data Analysis, Excel, Python, Pandas, Data Visualization, Business Intelligence, Statistical Analysis
0
26