The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
My role. Balance Sheet Consolidation For 6 Companies
"Consolidated Financial Statement was accurate the balance sheet format was completely re-arranged so you had to hunt around to discover if the numbers were accurate. Can't use this for tax preparation or for sharing with the client or auditors."
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Automated Shopify P&L in Google Sheets
Built a reporting workflow that brings Shopify sales data, Meta Ads spend, and COGS into one automated Google Sheets P&L.
The workflow:
🛍️ Shopify API → Sales, orders, refunds & product data
📣 Meta Ads API → Advertising spend & campaign data
📁 Google Drive → COGS file uploads
⚙️ Google Sheets + Apps Script → Data cleaning, calculations & reporting
The final P&L can track:
• Revenue
• COGS
• Gross Profit & Margin
• Ad Spend
• Net Profit
• Product-level profitability
The goal is simple: reduce manual reporting and give the business a clearer view of actual profitability.
Built by Skillytics Consulting for practical ecommerce analytics and automation.
#Shopify #GoogleSheets #AppsScript #EcommerceAnalytics #PAndL #BusinessAutomation #DataAnalytics
Worked on maintaining a structured Fixed Asset Register covering asset details, acquisition costs, depreciation, useful life, locations, and book values. The focus was on keeping financial records accurate, organised, and easy to track for reporting and reconciliation.
Year-end giving season is about 90 days out — and for most nonprofits, it's when close to a third of annual donations come in, in the space of a few weeks.
That's not the moment to discover your restricted fund tracking is off, or that your board can't get a clean report on short notice. September is when that gets fixed, not December.
If your books aren't ready to handle the year-end push yet, now's the window to close that gap.
