Comprehensive accounts receivable aging analysis for medical spa practices
Showing 30 accounts with total outstanding balance of $161,912
Robert Taylor financing | Wellness Center | $4,365 | $1,910 | $1,234 | $866 | $354 | $203 | $131 | $73 | $0 | $0 | $9,137 | |
Christopher Kim financing | Medical Plaza | $3,698 | $2,345 | $1,153 | $490 | $446 | $292 | $134 | $36 | $0 | $0 | $8,593 | |
Maria Garcia client | Medical Plaza | $3,673 | $2,169 | $1,114 | $579 | $375 | $330 | $147 | $58 | -$246 | $144 | $8,344 | |
Lisa Wong financing | Westside Clinic | $3,159 | $1,494 | $1,818 | $843 | $257 | $209 | $176 | $108 | $0 | $0 | $8,064 | |
Justin Garcia client | Wellness Center | $3,399 | $1,466 | $1,259 | $723 | $183 | $240 | $46 | $33 | -$401 | $735 | $7,684 | |
Ryan Wilson client | Westside Clinic | $2,601 | $1,553 | $1,078 | $1,321 | $444 | $227 | $111 | $46 | $0 | $0 | $7,382 | |
Sarah Johnson financing | Wellness Center | $3,522 | $1,913 | $911 | $376 | $161 | $123 | $48 | $38 | $0 | $0 | $7,092 | |
Matthew Brown financing | Westside Clinic | $2,956 | $2,025 | $886 | $670 | $207 | $263 | $44 | $38 | $0 | $0 | $7,087 | |
Amanda Rodriguez client | Wellness Center | $3,457 | $1,198 | $1,274 | $497 | $254 | $155 | $70 | $7 | $0 | $161 | $7,074 | |
Daniel Park financing | Medical Plaza | $2,737 | $1,157 | $1,281 | $940 | $307 | $261 | $152 | $90 | -$129 | $0 | $6,797 | |
John Smith insurance | Downtown Spa | $2,241 | $1,334 | $1,006 | $565 | $198 | $245 | $172 | $57 | $0 | $975 | $6,795 | |
Stephanie Lee financing | Westside Clinic | $2,778 | $1,523 | $714 | $899 | $445 | $287 | $141 | $74 | -$220 | $0 | $6,642 | |
Christina Wong client | Westside Clinic | $2,549 | $1,076 | $754 | $488 | $187 | $92 | $147 | $19 | -$138 | $888 | $6,062 | |
Jennifer Brown financing | Westside Clinic | $2,435 | $983 | $1,128 | $713 | $159 | $223 | $99 | $91 | $0 | $0 | $5,831 | |
Nicole Williams client | North Branch | $2,477 | $1,165 | $713 | $655 | $105 | $157 | $83 | $37 | $0 | $352 | $5,745 | |
Michael Chen financing | North Branch | $2,045 | $1,349 | $670 | $817 | $154 | $85 | $46 | $45 | $0 | $0 | $5,211 | |
Brian Miller client | Wellness Center | $1,618 | $1,302 | $729 | $503 | $146 | $103 | $72 | $36 | $0 | $460 | $4,969 | |
Andrew Davis client | Westside Clinic | $2,246 | $1,010 | $707 | $604 | $277 | $105 | $65 | $17 | -$100 | $0 | $4,931 | |
Kevin Anderson client | Medical Plaza | $2,560 | $679 | $606 | $335 | $382 | $205 | $124 | $78 | -$326 | $46 | $4,688 | |
Samantha Chen financing | Westside Clinic | $1,987 | $1,283 | $542 | $371 | $286 | $49 | $92 | $60 | -$469 | $77 | $4,278 | |
Mark Johnson financing | North Branch | $1,721 | $750 | $676 | $524 | $164 | $61 | $63 | $24 | $0 | $214 | $4,197 | |
Emily Davis insurance | Downtown Spa | $1,319 | $911 | $712 | $400 | $130 | $188 | $92 | $17 | $0 | $0 | $3,771 | |
Rachel Green client | North Branch | $966 | $571 | $505 | $304 | $164 | $85 | $59 | $19 | -$304 | $922 | $3,289 | |
Jessica Thompson financing | Westside Clinic | $1,026 | $556 | $399 | $260 | $112 | $40 | $50 | $9 | $0 | $785 | $3,236 | |
Ashley Martinez financing | Wellness Center | $1,284 | $628 | $465 | $235 | $178 | $92 | $60 | $13 | $0 | $256 | $3,211 | |
Steven Zhang insurance | North Branch | $1,284 | $783 | $490 | $464 | $109 | $136 | $44 | $45 | -$146 | $0 | $3,210 | |
Lauren Smith financing | Wellness Center | $1,414 | $931 | $479 | $309 | $182 | $82 | $53 | $34 | -$387 | $0 | $3,096 | |
Michelle Liu financing | Wellness Center | $855 | $625 | $301 | $133 | $82 | $63 | $30 | $32 | $0 | $814 | $2,934 | |
David Wilson financing | Wellness Center | $722 | $376 | $209 | $68 | $46 | $45 | $18 | $20 | $0 | $0 | $1,504 | |
James Lee insurance | Downtown Spa | $377 | $225 | $142 | $111 | $58 | $13 | $21 | $5 | -$274 | $382 | $1,061 | |
| TOTALS | 30 accounts | $67,471 | $35,290 | $23,955 | $16,062 | $6,552 | $4,657 | $2,589 | $1,263 | -$3,139 | $7,212 | $161,912 |
Accounts over 90 days require immediate attention for collection efforts
Strong current revenue indicates healthy payment collection processes
Accounts with credit balances that may need refunding or future service credits