{ "status": "success", "count": 18, "p_and_l_summary": { "gross_revenue": 2811940, "total_expenses": 128595.58, "net_profit": 2683344.42, "profit_margin_percent": 95.4, "category_breakdown": { "Egg Trays, Cartons & Packaging": { "income": 0, "expense": 120000 }, "Egg Sales": { "income": 2805880, "expense": 0 }, "Farm Attendants Wages": { "income": 0, "expense": 1200 }, "Management Stipend": { "income": 0, "expense": 800 }, "Cull Bird Sales": { "income": 1100, "expense": 0 }, "Meat \/ Live Bird Sales": { "income": 3250, "expense": 0 }, "Utilities (Water & Power)": { "income": 0, "expense": 420 }, "Packaging & Crates": { "income": 0, "expense": 380 }, "Veterinary & Medicine": { "income": 0, "expense": 780 }, "Organic Fertilizer": { "income": 450, "expense": 0 }, "Feed & Nutrition Purchase": { "income": 0, "expense": 4500 }, "Feed Purchase": { "income": 0, "expense": 515.58 }, "Egg Commercial Sales": { "income": 1260, "expense": 0 } } }, "data": [ { "id": "fin_1790179466844_407", "local_unique_id": "loc_fin_1790179466844_407", "server_unique_id": "srv_fin_1790179466844_407", "user_id": "usr_bat_001", "farm_id": "farm_001", "flock_id": "flock_003", "type": "Expense", "category": "Egg Trays, Cartons & Packaging", "amount": "120000.00", "date": "2026-09-23", "reference_no": "MM-REF-9921", "payment_method": "Mobile Money", "payee_payer": "N\/A", "notes": "Eggs Trays", "metadata_json": null, "synced": 1, "created_at": "2026-09-23 12:04:31", "updated_at": "2026-09-23 16:04:26", "farm_name": "Sunrise Main Layer Farm", "flock_batch": "BAT-2026-03" }, { "id": "fin_1790179439959_198", "local_unique_id": "loc_fin_1790179439959_198", "server_unique_id": "srv_fin_1790179439959_198", "user_id": "usr_bat_001", "farm_id": "farm_001", "flock_id": "flock_003", "type": "Income", "category": "Egg Sales", "amount": "2800000.00", "date": "2026-09-23", "reference_no": "MM-REF-9921", "payment_method": "Mobile Money", "payee_payer": "N\/A", "notes": "Egg sales dispatch", "metadata_json": null, "synced": 1, "created_at": "2026-09-23 12:04:10", "updated_at": "2026-09-23 16:03:59", "farm_name": "Sunrise Main Layer Farm", "flock_batch": "BAT-2026-03" }, { "id": "fin_009", "local_unique_id": "fin_009", "server_unique_id": "srv_fin_009", "user_id": "usr_bat_001", "farm_id": "farm_001", "flock_id": null, "type": "Payroll", "category": "Farm Attendants Wages", "amount": "1200.00", "date": "2026-09-20", "reference_no": "PAY-2026-001", "payment_method": "Bank Transfer", "payee_payer": "Farm Labor Crew (4 Attendants)", "notes": "Bi-weekly labor distribution and coop maintenance", "metadata_json": null, "synced": 1, "created_at": "2026-09-21 08:15:08", "updated_at": "2026-09-21 08:15:08", "farm_name": "Sunrise Main Layer Farm", "flock_batch": null }, { "id": "fin_010", "local_unique_id": "fin_010", "server_unique_id": "srv_fin_010", "user_id": "usr_bat_001", "farm_id": "farm_001", "flock_id": null, "type": "Payroll", "category": "Management Stipend", "amount": "800.00", "date": "2026-09-20", "reference_no": "PAY-2026-002", "payment_method": "Bank Transfer", "payee_payer": "Samuel Kaggwa (Farm Manager)", "notes": "Monthly operations management stipend", "metadata_json": null, "synced": 1, "created_at": "2026-09-21 08:15:08", "updated_at": "2026-09-21 08:15:08", "farm_name": "Sunrise Main Layer Farm", "flock_batch": null }, { "id": "fin_004", "local_unique_id": "fin_004", "server_unique_id": "srv_fin_004", "user_id": "usr_bat_001", "farm_id": "farm_demo_03", "flock_id": "flock_003", "type": "Income", "category": "Cull Bird Sales", "amount": "1100.00", "date": "2026-09-19", "reference_no": "REC-2026-042", "payment_method": "Cash", "payee_payer": "Jinja Central Market Vendors", "notes": "110 mature heritage birds at end of test cycle", "metadata_json": null, "synced": 1, "created_at": "2026-09-21 08:15:08", "updated_at": "2026-09-21 08:15:08", "farm_name": "Victoria Dual-Purpose Free-Range Station", "flock_batch": "BAT-2026-03" }, { "id": "fin_002", "local_unique_id": "fin_002", "server_unique_id": "srv_fin_002", "user_id": "usr_bat_001", "farm_id": "farm_1786636205864_771", "flock_id": "flock_002", "type": "Income", "category": "Meat \/ Live Bird Sales", "amount": "3250.00", "date": "2026-09-18", "reference_no": "INV-2026-082", "payment_method": "Bank Transfer", "payee_payer": "Lanet Meat Processors Ltd", "notes": "500 processed broiler birds wholesale delivery", "metadata_json": null, "synced": 1, "created_at": "2026-09-21 08:15:08", "updated_at": "2026-09-21 08:15:08", "farm_name": "Highland Broiler & Breeder Farm", "flock_batch": "BAT-2026-02" }, { "id": "fin_007", "local_unique_id": "fin_007", "server_unique_id": "srv_fin_007", "user_id": "usr_bat_001", "farm_id": "farm_001", "flock_id": "flock_001", "type": "Expense", "category": "Utilities (Water & Power)", "amount": "420.00", "date": "2026-09-17", "reference_no": "EXP-2026-103", "payment_method": "Mobile Money", "payee_payer": "National Water & Power Board", "notes": "Monthly coop borehole and automated lighting power", "metadata_json": null, "synced": 1, "created_at": "2026-09-21 08:15:08", "updated_at": "2026-09-21 08:15:08", "farm_name": "Sunrise Main Layer Farm", "flock_batch": "BAT-2026-01" }, { "id": "fin_001", "local_unique_id": "fin_001", "server_unique_id": "srv_fin_001", "user_id": "usr_bat_001", "farm_id": "farm_001", "flock_id": "flock_001", "type": "Income", "category": "Egg Sales", "amount": "5880.00", "date": "2026-09-16", "reference_no": "INV-2026-081", "payment_method": "Bank Transfer", "payee_payer": "Sunrise Wholesale Supermarkets", "notes": "1,680 standard trays commercial Grade A egg delivery", "metadata_json": null, "synced": 1, "created_at": "2026-09-21 08:15:08", "updated_at": "2026-09-21 08:15:08", "farm_name": "Sunrise Main Layer Farm", "flock_batch": "BAT-2026-01" }, { "id": "fin_008", "local_unique_id": "fin_008", "server_unique_id": "srv_fin_008", "user_id": "usr_bat_001", "farm_id": "farm_001", "flock_id": "flock_001", "type": "Expense", "category": "Packaging & Crates", "amount": "380.00", "date": "2026-09-15", "reference_no": "EXP-2026-104", "payment_method": "Mobile Money", "payee_payer": "Standard Packaging Mills", "notes": "2,000 heavy duty molded pulp egg trays", "metadata_json": null, "synced": 1, "created_at": "2026-09-21 08:15:08", "updated_at": "2026-09-21 08:15:08", "farm_name": "Sunrise Main Layer Farm", "flock_batch": "BAT-2026-01" }, { "id": "fin_006", "local_unique_id": "fin_006", "server_unique_id": "srv_fin_006", "user_id": "usr_bat_001", "farm_id": "farm_001", "flock_id": "flock_001", "type": "Expense", "category": "Veterinary & Medicine", "amount": "780.00", "date": "2026-09-14", "reference_no": "EXP-2026-102", "payment_method": "Bank Transfer", "payee_payer": "Highland AgroVet Solutions", "notes": "Lasota Newcastle live vaccines and vitamins", "metadata_json": null, "synced": 1, "created_at": "2026-09-21 08:15:08", "updated_at": "2026-09-21 08:15:08", "farm_name": "Sunrise Main Layer Farm", "flock_batch": "BAT-2026-01" }, { "id": "fin_003", "local_unique_id": "fin_003", "server_unique_id": "srv_fin_003", "user_id": "usr_bat_001", "farm_id": "farm_001", "flock_id": "flock_001", "type": "Income", "category": "Organic Fertilizer", "amount": "450.00", "date": "2026-09-13", "reference_no": "REC-2026-041", "payment_method": "Mobile Money", "payee_payer": "Wakiso Horticultural Cooperative", "notes": "45 bags dry composted poultry manure", "metadata_json": null, "synced": 1, "created_at": "2026-09-21 08:15:08", "updated_at": "2026-09-21 08:15:08", "farm_name": "Sunrise Main Layer Farm", "flock_batch": "BAT-2026-01" }, { "id": "fin_005", "local_unique_id": "fin_005", "server_unique_id": "srv_fin_005", "user_id": "usr_bat_001", "farm_id": "farm_001", "flock_id": "flock_001", "type": "Expense", "category": "Feed & Nutrition Purchase", "amount": "4500.00", "date": "2026-09-11", "reference_no": "EXP-2026-101", "payment_method": "Bank Transfer", "payee_payer": "AgriFeeds Ltd", "notes": "Bulk restocking 10 tonnes layer and broiler mash", "metadata_json": null, "synced": 1, "created_at": "2026-09-21 08:15:08", "updated_at": "2026-09-21 08:15:08", "farm_name": "Sunrise Main Layer Farm", "flock_batch": "BAT-2026-01" }, { "id": "fin_exp_suite_1790597628300", "local_unique_id": "loc_fin_exp_suite_1790597628300", "server_unique_id": "srv_fin_exp_suite_1790597628300", "user_id": "usr_bat_001", "farm_id": "farm_suite_test_1790597628300", "flock_id": null, "type": "Expense", "category": "Feed Purchase", "amount": "171.86", "date": "2026-03-22", "reference_no": "EXP-8300", "payment_method": "Mobile Money", "payee_payer": "", "notes": "", "metadata_json": null, "synced": 1, "created_at": "2026-09-28 08:13:49", "updated_at": "2026-09-28 12:13:49", "farm_name": "Highland Commercial Poultry Estate (Verified)", "flock_batch": null }, { "id": "fin_inc_suite_1790597628300", "local_unique_id": "loc_fin_inc_suite_1790597628300", "server_unique_id": "srv_fin_inc_suite_1790597628300", "user_id": "usr_bat_001", "farm_id": "farm_suite_test_1790597628300", "flock_id": null, "type": "Income", "category": "Egg Commercial Sales", "amount": "420.00", "date": "2026-03-22", "reference_no": "INV-8300", "payment_method": "Bank Transfer", "payee_payer": "", "notes": "", "metadata_json": null, "synced": 1, "created_at": "2026-09-28 08:13:49", "updated_at": "2026-09-28 12:13:49", "farm_name": "Highland Commercial Poultry Estate (Verified)", "flock_batch": null }, { "id": "fin_exp_suite_1790597443019", "local_unique_id": "loc_fin_exp_suite_1790597443019", "server_unique_id": "srv_fin_exp_suite_1790597443019", "user_id": "usr_bat_001", "farm_id": "farm_suite_test_1790597443019", "flock_id": null, "type": "Expense", "category": "Feed Purchase", "amount": "171.86", "date": "2026-03-22", "reference_no": "EXP-3019", "payment_method": "Mobile Money", "payee_payer": "", "notes": "", "metadata_json": null, "synced": 1, "created_at": "2026-09-28 08:10:43", "updated_at": "2026-09-28 12:10:43", "farm_name": "Highland Commercial Poultry Estate (Verified)", "flock_batch": null }, { "id": "fin_inc_suite_1790597443019", "local_unique_id": "loc_fin_inc_suite_1790597443019", "server_unique_id": "srv_fin_inc_suite_1790597443019", "user_id": "usr_bat_001", "farm_id": "farm_suite_test_1790597443019", "flock_id": null, "type": "Income", "category": "Egg Commercial Sales", "amount": "420.00", "date": "2026-03-22", "reference_no": "INV-3019", "payment_method": "Bank Transfer", "payee_payer": "", "notes": "", "metadata_json": null, "synced": 1, "created_at": "2026-09-28 08:10:43", "updated_at": "2026-09-28 12:10:43", "farm_name": "Highland Commercial Poultry Estate (Verified)", "flock_batch": null }, { "id": "fin_exp_suite_1790221198878", "local_unique_id": "loc_fin_exp_suite_1790221198878", "server_unique_id": "srv_fin_exp_suite_1790221198878", "user_id": "usr_bat_001", "farm_id": "farm_suite_test_1790221198878", "flock_id": null, "type": "Expense", "category": "Feed Purchase", "amount": "171.86", "date": "2026-03-22", "reference_no": "EXP-8878", "payment_method": "Mobile Money", "payee_payer": "", "notes": "", "metadata_json": null, "synced": 1, "created_at": "2026-09-23 23:39:59", "updated_at": "2026-09-24 03:39:59", "farm_name": "Highland Commercial Poultry Estate (Verified)", "flock_batch": null }, { "id": "fin_inc_suite_1790221198878", "local_unique_id": "loc_fin_inc_suite_1790221198878", "server_unique_id": "srv_fin_inc_suite_1790221198878", "user_id": "usr_bat_001", "farm_id": "farm_suite_test_1790221198878", "flock_id": null, "type": "Income", "category": "Egg Commercial Sales", "amount": "420.00", "date": "2026-03-22", "reference_no": "INV-8878", "payment_method": "Bank Transfer", "payee_payer": "", "notes": "", "metadata_json": null, "synced": 1, "created_at": "2026-09-23 23:39:59", "updated_at": "2026-09-24 03:39:59", "farm_name": "Highland Commercial Poultry Estate (Verified)", "flock_batch": null } ] }