- Home
- Skills
- Trading & Investing
- bizpilot finance review
Works with the AI Agents you already use
bizpilot finance review
Automated financial reviews and margin analysis from business CSVs to track profit, cash flow, and break-even points.
$12
bizpilot finance review
Example session with this skill installed
Run a financial review for the last 30 days using my files in bizpilot/data. I want to know about my margins and if I can afford my upcoming bills.
- Read your context and instructions
- Compiled the bizpilot finance review
- Generated the data export
I have processed your sales and expense data for the last 30 days. The full review has been saved to bizpilot/outputs/2023-11-01/finance/review.md.
Net profit RM2,450.50 this month, up 15% on last month.
Monthly Financial Review
| Metric | Actual Value | vs. Previous Period |
|---|---|---|
| Net Sales | RM 12,400.00 | +8% |
| Gross Profit | RM 5,820.00 | +12% |
| Gross Margin | 46.9% | +1.5 pts |
| Net Profit | RM 2,450.50 | +15% |
| Net Margin | 19.8% | +2.1 pts |
Product Margins
- Top Performer: "Classic Tee" (62% margin).
SELLING BELOW COST: "Blue Ceramic Mug" - Real margin is -5% after shipping. Action: Increase price to RM 32.00 to reach 20% target.
- Slow Mover: "Phone Case V1" - No sales in 30 days. RM 850.00 in capital tied up.
Cash and Bills
- Cash Available: RM 3,200.00
- Total Due (14 days): RM 4,100.00
- WARNING: Bills exceed available cash by RM 900.00.
Findings & Actions
1.
Shipping subsidies are eating margins: You spent RM 450 more on shipping than last month. Action: Increase the minimum order value for free shipping.
2.
Subscription bloat: Software expenses rose 20%. Action: Cancel the unused CRM trial before the next billing cycle.
3.
Inventory drag: Slow movers are blocking cash needed for bills. Action: Run a 20% off bundle for Phone Case V1 to liquidate stock.
This report is for planning help, not accounting or financial advice.
Next steps
- Review the
report.jsonfor a full breakdown of marketplace fees. - Update
business_profile.jsonif you decide to implement the suggested price for the Ceramic Mug. - Check the
data/expenses.csvto ensure all recent bills are logged.
expenses.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
Stop guessing how much profit remains after marketplace fees and shipping costs. This skill processes raw sales and expense CSVs to give small business owners a plain-language financial review. It identifies products selling below cost, calculates real margins, and flags cash flow risks before they become crises.
What it does
- Financial performance review calculates revenue, gross profit, and net profit compared to the previous period.
- Product margin analysis flags items selling below cost or target margins and calculates the specific price needed to fix them.
- Inventory optimization identifies slow-moving stock and calculates the total capital tied up in unsold items.
- Break-even calculation determines the exact unit volume required to cover fixed operating costs.
- Cash flow monitoring tracks unpaid bills against available cash to provide early warnings for upcoming deficits.
How it works
- Prepare data by placing sales and expense CSVs into the workspace and configuring the business profile with unit costs.
- Execute script using the internal Python utility to process the raw data for a specific weekly, monthly, or yearly period.
- Review findings via a structured report that translates technical JSON output into actionable business advice.
Frameworks & tools
The skill uses a dedicated Python engine finance_report.py for all calculations to ensure mathematical accuracy. It requires JSON configuration for business profiles and standard CSV formats for transaction data.
Why this beats prompting it yourself
LLMs frequently hallucinate math and struggle to track complex fee structures across multiple spreadsheets. This skill offloads all arithmetic to a localized script, ensuring every percentage and margin is calculated by code, not probability.
Use cases
- Generate a monthly P&L review to see if a business is actually profitable.
- Perform a margin audit to find which products are losing money after shipping fees.
- Check break-even points before committing to new recurring operating expenses.
- Review upcoming bill obligations against current cash reserves.
Known limitations
Requires specific CSV column headers as defined in the provided templates. It provides planning assistance only and is not a substitute for professional accounting, tax, or financial advice.
Requires structured CSV inputs and a JSON profile. Mathematical output is limited to the data provided in files. Does not provide legal tax or formal accounting advice.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 20 days ago