{"id":67958,"recorded_at":"2026-10-26T14:37:45.456893Z","observed_at":"2026-10-26T14:37:45.456830Z","subject_kind":"source_record","subject":"x402_bazaar:https://api.paidpilot.io/v1/receivables-report","kind":"listing","method":"baseline/1","body":{"endpoints":[["x402","https://api.paidpilot.io/v1/receivables-report"]],"name":"PaidPilot Invoice API","owner_address":"0x2daf658b01e257206375798a15832e9f547d65dd","raw":{"accepts":[{"amount":"1000000","asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","extra":{"name":"USD Coin","version":"2"},"maxTimeoutSeconds":120,"network":"eip155:8453","payTo":"0x2dAF658B01e257206375798a15832E9f547D65dD","scheme":"exact"}],"description":"Analyze accounts receivable aging from an invoice CSV or JSON export. $1 USDC on Base per call. Takes up to 1000 open invoices (QuickBooks, Xero, FreshBooks, Wave, Stripe or custom). Returns an A-F health grade, 0-100 score, aging buckets, overdue %, DSO and a collection priority list. Don't use this for a single invoice; use /v1/reminder-draft or /v1/late-fee.","extensions":{"bazaar":{"info":{"input":{"body":{"as_of":"2026-10-13","csv":"Invoice Number,Customer,Invoice Date,Due Date,Total,Amount Paid,Status,Paid Date\nINV-1001,Blue River Bakery,2026-06-02,2026-07-02,2400.00,0,Open,\nINV-1002,Hill & Co Dental,2026-08-05,2026-09-04,1850.00,0,Open,\nINV-1003,Blue River Bakery,2026-08-20,2026-09-19,960.00,400.00,Partial,\nINV-1004,Maple Street Realty,2026-09-15,2026-10-15,3200.00,0,Open,\nINV-1005,Hill & Co Dental,2026-07-01,2026-07-31,1200.00,1200.00,Paid,2026-08-12\nINV-1006,Prairie Auto Repair,2026-09-01,2026-10-01,725.50,0,Open,\nINV-1007,Maple Street Realty,2026-08-01,2026-08-31,3200.00,3200.00,Paid,2026-09-03","currency":"USD"},"bodyType":"json","method":"POST","type":"http"},"output":{"example":{"aging":{"1_30":{"amount":1285.5,"count":2,"display":"$1,285.50","percent":14.7},"31_60":{"amount":1850,"count":1,"display":"$1,850.00","percent":21.2},"61_90":{"amount":0,"count":0,"display":"$0.00","percent":0},"current":{"amount":3200,"count":1,"display":"$3,200.00","percent":36.6},"no_due_date":{"amount":0,"count":0,"display":"$0.00","percent":0},"over_90":{"amount":2400,"count":1,"display":"$2,400.00","percent":27.5}},"as_of":"2026-10-13","collection_priority":[{"balance":2400,"bucket":"over_90","customer":"Blue River Bakery","days_overdue":103,"display":"$2,400.00","due_date":"2026-07-02","invoice_number":"INV-1001","next_action":{"detail":"Send a final notice with a date, then decide on a payment plan, collections or small-claims court.","step":"final_notice","tool":"POST /v1/reminder-draft with tone=final"}},{"balance":1850,"bucket":"31_60","customer":"Hill & Co Dental","days_overdue":39,"display":"$1,850.00","due_date":"2026-09-04","invoice_number":"INV-1002","next_action":{"detail":"Send a firm reminder and add the late fee your terms allow.","step":"firm_reminder_and_late_fee","tool":"POST /v1/reminder-draft with tone=firm; POST /v1/late-fee"}},{"balance":725.5,"bucket":"1_30","customer":"Prairie Auto Repair","days_overdue":12,"display":"$725.50","due_date":"2026-10-01","invoice_number":"INV-1006","next_action":{"detail":"Send a friendly reminder with the payment link.","step":"friendly_reminder","tool":"POST /v1/reminder-draft with tone=friendly"}},{"balance":560,"bucket":"1_30","customer":"Blue River Bakery","days_overdue":24,"display":"$560.00","due_date":"2026-09-19","invoice_number":"INV-1003","next_action":{"detail":"Send a friendly reminder with the payment link.","step":"friendly_reminder","tool":"POST /v1/reminder-draft with tone=friendly"}}],"currency":"USD","customers":[{"customer":"Maple Street Realty","display":"$3,200.00","invoices":1,"oldest_days_overdue":0,"open_balance":3200,"overdue_balance":0,"share_percent":36.6},{"customer":"Blue River Bakery","display":"$2,960.00","invoices":2,"oldest_days_overdue":103,"open_balance":2960,"overdue_balance":2960,"share_percent":33.9},{"customer":"Hill & Co Dental","display":"$1,850.00","invoices":1,"oldest_days_overdue":39,"open_balance":1850,"overdue_balance":1850,"share_percent":21.2},{"customer":"Prairie Auto Repair","display":"$725.50","invoices":1,"oldest_days_overdue":12,"open_balance":725.5,"overdue_balance":725.5,"share_percent":8.3}],"input_report":{"csv_columns_used":{"amount":"Total","amount_paid":"Amount Paid","customer":"Customer","due_date":"Due Date","invoice_number":"Invoice Number","issue_date":"Invoice Date","paid_date":"Paid Date","status":"Status"},"default_terms":"Net 30","due_dates_assumed_from_terms":0,"rows_excluded_void_draft_or_future":0,"rows_read":7,"rows_skipped":[]},"notes":["Pure calculation on the data you sent: nothing is stored or sent anywhere.","Days overdue and buckets use the due date; rows without one use the invoice date plus the row's terms (or default_terms).","Not accounting, legal or credit advice."],"recommendations":["Start with the 1 invoice over 60 days ($2,400.00): the older an invoice gets, the less likely it is to be paid.","Send reminders on the 2 invoices 1-30 days late ($1,285.50) this week, before they age.","Maple Street Realty is 36.6% of your receivables. Ask for a deposit or shorter terms on new work, and watch this account weekly.","Customers take 38 days to pay on average. Offer card/ACH payment links, send invoices the day work is done, and consider 2/10 Net 30 to reward fast payment."],"report":"receivables_health","summary":{"average_days_to_pay":38,"customers_with_open_balance":4,"dso_days":79,"dso_note":"Open balance / amount invoiced in the last 90 days x 90. Needs every invoice from that window (paid ones too) in the input to be accurate.","grade":"F","headline":"$5,535.50 of $8,735.50 owed to you is past due (63.4%), across 4 invoices.","open_balance":8735.5,"open_display":"$8,735.50","open_invoices":5,"over_60_percent":27.5,"overdue_balance":5535.5,"overdue_invoices":4,"overdue_percent":63.4,"paid_invoices_measured":2,"score":48,"score_reasons":["63.4% of open receivables are past due (-32).","27.5% are more than 60 days past due, the part least likely to be collected (-18).","Maple Street Realty holds 36.6% of what you are owed (-2)."],"top_customer_share_percent":36.6,"weighted_days_outstanding":68}},"type":"json"}},"schema":{"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"body":{"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false,"properties":{"as_of":{"description":"Report date, default today (UTC)","pattern":"^\\d{4}-\\d{2}-\\d{2}$","type":"string"},"csv":{"description":"CSV export (QuickBooks, Xero, FreshBooks, Wave, Stripe or your own). Header row required. Recognized columns: invoice number, customer, amount/total, amount paid, balance/open balance, invoice date, due date, terms, paid date, status.","maxLength":60000,"type":"string"},"currency":{"default":"USD","type":"string"},"default_terms":{"default":"Net 30","description":"Used when a row has no due date and no terms","maxLength":40,"type":"string"},"invoices":{"description":"Or JSON rows instead of CSV","items":{"additionalProperties":false,"properties":{"amount":{"maximum":10000000000,"minimum":0,"type":"number"},"amount_paid":{"maximum":10000000000,"minimum":0,"type":"number"},"balance":{"maximum":10000000000,"type":"number"},"customer":{"maxLength":120,"minLength":1,"type":"string"},"due_date":{"pattern":"^\\d{4}-\\d{2}-\\d{2}$","type":"string"},"invoice_number":{"maxLength":60,"minLength":1,"type":"string"},"issue_date":{"pattern":"^\\d{4}-\\d{2}-\\d{2}$","type":"string"},"paid_date":{"pattern":"^\\d{4}-\\d{2}-\\d{2}$","type":"string"},"status":{"maxLength":30,"type":"string"},"terms":{"maxLength":40,"type":"string"}},"required":["invoice_number","customer","amount"],"type":"object"},"maxItems":1000,"type":"array"},"revenue_window_days":{"default":90,"description":"Window for DSO: invoiced amount in the last N days","maximum":365,"minimum":30,"type":"integer"}},"type":"object"},"bodyType":{"enum":["json","form-data","text"],"type":"string"},"method":{"enum":["POST"],"type":"string"},"type":{"const":"http","type":"string"}},"required":["type","method","bodyType","body"],"type":"object"},"output":{"properties":{"example":{"type":"object"},"type":{"type":"string"}},"required":["type"],"type":"object"}},"required":["input"],"type":"object"}}},"lastUpdated":"2026-10-24T14:46:15.613Z","quality":{"l30DaysTotalCalls":1,"l30DaysUniquePayers":1,"lastCalledAt":"2026-10-24T14:46:15.476Z"},"resource":"https://api.paidpilot.io/v1/receivables-report","serviceName":"PaidPilot Invoice API","tags":["accounts-receivable","ar-aging","dso","collections","quickbooks"],"type":"http","x402Version":2},"source":"x402_bazaar","summary":"Analyze accounts receivable aging from an invoice CSV or JSON export. $1 USDC on Base per call. Takes up to 1000 open invoices (QuickBooks, Xero, FreshBooks, Wave, Stripe or custom). Returns an A-F health grade, 0-100 score, aging buckets, overdue %, DSO and a collection priority list. Don't use this for a single invoice; use /v1/reminder-draft or /v1/late-fee."},"body_sha256":"d72ee9252b8c957d5c96e585c9427ea6c02863aec4f7b826dca02e79abdadfd8","prev_id":null,"leaf":"0xd4b01a63d7f859b2e5995006a2f42375b9f05b674adad341dd28d94e04324c19","leaf_text":"{\"body\":\"d72ee9252b8c957d5c96e585c9427ea6c02863aec4f7b826dca02e79abdadfd8\",\"id\":67958,\"kind\":\"listing\",\"method\":\"baseline/1\",\"observed_us\":1793025465456830,\"prev\":null,\"subject\":\"x402_bazaar:https://api.paidpilot.io/v1/receivables-report\",\"subject_kind\":\"source_record\"}","day":{"day":"2026-10-26","leaves":296695,"root":"0xf43e8dcc3d451a4788b26be904c55e8c4c0fa75c9666796c51db38d37e2c0df8","chained":"0x702d5ac508f08b0d1accf36af25822d8e5660367494edd17a642fb61e158a57a","anchor_chain":"eip155:5042002","anchor_tx":"0x495162f8936e19f0039918feebe6c307f327cd6bf8c37219620b1970041fa9ae","anchor_block":69251483},"proof":["0xd4b009643e62edfb7b810b5d0d0a7f8093ea79800e344f8e037c75c0006dc9d7","0x4be931f02a049a89f4d459dcd0c5887075b3e79394a9e149fe69ef04dcb0d452","0x1906810d9a8f255314658f074cdb71479070ac03091a222675791609024abea1","0x7dabaa0b84e30a941aa1e512a17aa7d2c1035c6d0d52ac52b1323608f63ee570","0x1fd9567bea053c26bd357e5776922e584dd8feaa0da8b5a822436745f5ef6a1a","0xdec664d017f4e486eaf2628b24f491f9e7e27d5a13d06d06ba1a849cdec238a0","0x161d3b88a29e38c228abd44006d8b6f03526780ed27e11ead86cc0ad5c41a69b","0x4bb1f29a765aa2660cef4713eae1ebd25621995f55675d05a60f92d4ed7581e7","0xe68852d059df1a2763d9eb9e407ab688f37fed3121a3f760478f3f9ea3d2d8a0","0x692eeb197968cd5781b6a621b2983348b30fee6c6aea503398abf2207d9af77b","0x13af2618b202e3256bff92107d30a646eb897d2992ea1f3e08e75bf4bef84c31","0x7026808261896a203198354548e5e8cabce4a06e89d077c172084841b47ae119","0x3199db04c2c73c3483386a86bf503eafde5af103465608156e2e5f42e72a6fbe","0x6b927d53caa5125cdba9255612d524976c691f8672796c3f0885ba2c5b3af1ad","0x6dc40f983a3840a0ad927a9ca17f4ff1e3b649a6c735e2a09b140db7c2caf13b","0x703f95866af09c5e5d6ead7411e9a10f964a41a2aff64d4a55ff0053c023a023","0xd0651cb9bc8155eb52b5247d506e74b8a935057dc190ba52091702ac25ed3a40","0x9a9024edb5069d88a324facb310a5ce8e495214bbaa968f077bede437390194f","0x9b9ce5b74b9bab5121612ef6b64920a8d453cbf311096a423eef9702747e868a"]}