📊 Financial Report

\n\n

🎵 Artist Earnings

\n \n \n \n \n \n \n \n \n \n \n {processingResult.artistSummary.map((artist) => (\n \n \n \n \n \n \n ))}\n \n

Artist	Total Sales	Tracks	Albums
{artist.name}	${artist.totalSales.toFixed(2)}	{artist.totalTracks}	{artist.totalAlbums}

\n\n

📆 Monthly Breakdown

\n \n \n \n \n \n {processingResult.monthlyBreakdown[0]?.artistSales\n && Object.keys(processingResult.monthlyBreakdown[0].artistSales).map(\n (artist) => ,\n )}\n \n \n \n {processingResult.monthlyBreakdown.map((month) => (\n \n \n \n {Object.entries(month.artistSales).map(([artist, sales]) => (\n \n ))}\n \n ))}\n \n

Month	Total Sales	{artist}
{month.month}	${month.totalSales.toFixed(2)}	${sales.toFixed(2)}

\n\n

💿 Release Details

\n \n \n \n \n \n \n \n \n \n \n {processingResult.artistSummary.flatMap((artist) =>\n artist.releases.map((release, idx) => (\n \n \n \n \n \n \n ))\n )}\n \n

Artist	Release	Type	Sales
{artist.name}	{release.name}	{release.type}	${release.sales.toFixed(2)}

\n )}\n

\n );\n}\n\n// ---- Some Basic Styles ----\nconst dropZoneStyle: React.CSSProperties = {\n border: \"2px dashed #cccccc\",\n borderRadius: \"4px\",\n padding: \"20px\",\n textAlign: \"center\",\n transition: \"background-color 0.3s\",\n minHeight: \"200px\",\n display: \"flex\",\n flexDirection: \"column\",\n justifyContent: \"center\",\n cursor: \"pointer\",\n};\n\nconst errorStyle: React.CSSProperties = {\n color: \"red\",\n marginBottom: \"10px\",\n};\n\nconst resultStyle: React.CSSProperties = {\n marginTop: \"20px\",\n padding: \"10px\",\n backgroundColor: \"#f0f0f0\",\n borderRadius: \"4px\",\n};\n\nconst tableStyle: React.CSSProperties = {\n width: \"100%\",\n borderCollapse: \"collapse\",\n marginBottom: \"20px\",\n marginTop: \"10px\",\n};\n\n// ---- Main App ----\nfunction App() {\n return (\n

Bandcamp CSV Processor

Export raw data Bandcamp Sales Report and upload here.

\n \n

Disclaimer: I have no idea if this is accurate, it is entirely untested.

\n );\n}\n\n// ---- Client Entry Point ----\nfunction client() {\n const rootEl = document.getElementById(\"root\");\n if (rootEl) {\n createRoot(rootEl).render();\n }\n}\n\n// ---- Export for Valtown or Node-like Env ----\nif (typeof document !== \"undefined\") {\n client();\n}\n\nexport default async function server(request: Request): Promise {\n return new Response(\n `\n \n \n Bandcamp CSV Processor\n \n \n \n

\n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}","createdAt",["D",1738989668630],"version",53,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_129":130,"_131":132},"handle","geordie","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yajZPVDRYVHJFeUNkUFRIY01hMW1JckMxa0oifQ","forkedVal","interval","slug","geordie/bandcampcsvprocessor","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[141,144,148,152,156,160,164,168,172,176,180,184,188,192,196,200,204,208,212,216,220,224,228,232,236,240,244,248,252,256,260,264,268,272,276,280,284,288,292,296,300,304,308,312,316,320,324,328,332,336,340,344,347,351],{"_118":119,"_142":-5,"_116":143,"_113":111},"prId",["D",1738989668630],{"_118":145,"_142":-5,"_116":146,"_113":147},52,["D",1738989613194],"c9254a6e-e5d6-11ef-84ed-e6cdfca9ef9f",{"_118":149,"_142":-5,"_116":150,"_113":151},51,["D",1738989609184],"c6c07b54-e5d6-11ef-ad26-e6cdfca9ef9f",{"_118":153,"_142":-5,"_116":154,"_113":155},50,["D",1738989445032],"64e7e2aa-e5d6-11ef-8bf4-e6cdfca9ef9f",{"_118":157,"_142":-5,"_116":158,"_113":159},49,["D",1738989413526],"52200bb6-e5d6-11ef-a735-e6cdfca9ef9f",{"_118":161,"_142":-5,"_116":162,"_113":163},48,["D",1738989385476],"41681eee-e5d6-11ef-b27a-e6cdfca9ef9f",{"_118":165,"_142":-5,"_116":166,"_113":167},47,["D",1738989382269],"3f7ef8e6-e5d6-11ef-a735-e6cdfca9ef9f",{"_118":169,"_142":-5,"_116":170,"_113":171},46,["D",1738989376639],"3c2391b6-e5d6-11ef-a735-e6cdfca9ef9f",{"_118":173,"_142":-5,"_116":174,"_113":175},45,["D",1738989278550],"01acc03e-e5d6-11ef-8793-e6cdfca9ef9f",{"_118":177,"_142":-5,"_116":178,"_113":179},44,["D",1738989277176],"00dcd2a2-e5d6-11ef-827f-e6cdfca9ef9f",{"_118":181,"_142":-5,"_116":182,"_113":183},43,["D",1738989267919],"fb597218-e5d5-11ef-ba89-e6cdfca9ef9f",{"_118":185,"_142":-5,"_116":186,"_113":187},42,["D",1738989257153],"f4ebfb1c-e5d5-11ef-9121-e6cdfca9ef9f",{"_118":189,"_142":-5,"_116":190,"_113":191},41,["D",1738989239100],"ea294b12-e5d5-11ef-bcab-e6cdfca9ef9f",{"_118":193,"_142":-5,"_116":194,"_113":195},40,["D",1738989225697],"e22d0dea-e5d5-11ef-bcab-e6cdfca9ef9f",{"_118":197,"_142":-5,"_116":198,"_113":199},39,["D",1738989216866],"dce8b406-e5d5-11ef-84e5-e6cdfca9ef9f",{"_118":201,"_142":-5,"_116":202,"_113":203},38,["D",1738989165099],"be0e598c-e5d5-11ef-811b-e6cdfca9ef9f",{"_118":205,"_142":-5,"_116":206,"_113":207},37,["D",1738989136212],"acd6e738-e5d5-11ef-81cd-e6cdfca9ef9f",{"_118":209,"_142":-5,"_116":210,"_113":211},36,["D",1738988870405],"0e66e526-e5d5-11ef-ad0a-e6cdfca9ef9f",{"_118":213,"_142":-5,"_116":214,"_113":215},35,["D",1738988863840],"0a7d5fd0-e5d5-11ef-9df7-e6cdfca9ef9f",{"_118":217,"_142":-5,"_116":218,"_113":219},34,["D",1738988844967],"ff3e3dd8-e5d4-11ef-ae8f-e6cdfca9ef9f",{"_118":221,"_142":-5,"_116":222,"_113":223},33,["D",1738988691233],"a39c5636-e5d4-11ef-ab48-e6cdfca9ef9f",{"_118":225,"_142":-5,"_116":226,"_113":227},32,["D",1738988636164],"82ca1916-e5d4-11ef-bbee-e6cdfca9ef9f",{"_118":229,"_142":-5,"_116":230,"_113":231},31,["D",1738988498950],"30ff5830-e5d4-11ef-9e6e-e6cdfca9ef9f",{"_118":233,"_142":-5,"_116":234,"_113":235},30,["D",1738988492968],"2d6eedca-e5d4-11ef-b3cd-e6cdfca9ef9f",{"_118":237,"_142":-5,"_116":238,"_113":239},29,["D",1738988433598],"0a0bb1ba-e5d4-11ef-af68-e6cdfca9ef9f",{"_118":241,"_142":-5,"_116":242,"_113":243},28,["D",1738988403783],"f845969e-e5d3-11ef-980c-e6cdfca9ef9f",{"_118":245,"_142":-5,"_116":246,"_113":247},27,["D",1738988385494],"ed600a2a-e5d3-11ef-980c-e6cdfca9ef9f",{"_118":249,"_142":-5,"_116":250,"_113":251},26,["D",1738988372310],"e58445fa-e5d3-11ef-bd39-e6cdfca9ef9f",{"_118":253,"_142":-5,"_116":254,"_113":255},25,["D",1738988366175],"e1db4214-e5d3-11ef-bbc4-e6cdfca9ef9f",{"_118":257,"_142":-5,"_116":258,"_113":259},24,["D",1738988328029],"cb1e5372-e5d3-11ef-8e05-e6cdfca9ef9f",{"_118":261,"_142":-5,"_116":262,"_113":263},23,["D",1738988313869],"c2ae54e4-e5d3-11ef-9cee-e6cdfca9ef9f",{"_118":265,"_142":-5,"_116":266,"_113":267},22,["D",1738988291818],"b5897186-e5d3-11ef-b3b0-e6cdfca9ef9f",{"_118":269,"_142":-5,"_116":270,"_113":271},21,["D",1738988285026],"b17dde7e-e5d3-11ef-8c06-e6cdfca9ef9f",{"_118":273,"_142":-5,"_116":274,"_113":275},20,["D",1738988262225],"a3e57006-e5d3-11ef-8429-e6cdfca9ef9f",{"_118":277,"_142":-5,"_116":278,"_113":279},19,["D",1738988010807],"0e0b3f34-e5d3-11ef-8bc5-e6cdfca9ef9f",{"_118":281,"_142":-5,"_116":282,"_113":283},18,["D",1738987940477],"e41ea288-e5d2-11ef-924b-e6cdfca9ef9f",{"_118":285,"_142":-5,"_116":286,"_113":287},17,["D",1738987387141],"9a4fb65c-e5d1-11ef-a869-e6cdfca9ef9f",{"_118":289,"_142":-5,"_116":290,"_113":291},16,["D",1738987336057],"7bdbb55e-e5d1-11ef-8c46-e6cdfca9ef9f",{"_118":293,"_142":-5,"_116":294,"_113":295},15,["D",1738987263373],"508ac1f6-e5d1-11ef-bec4-e6cdfca9ef9f",{"_118":297,"_142":-5,"_116":298,"_113":299},14,["D",1738987077367],"e1abad54-e5d0-11ef-879d-e6cdfca9ef9f",{"_118":301,"_142":-5,"_116":302,"_113":303},13,["D",1738986876261],"69cdf990-e5d0-11ef-956b-e6cdfca9ef9f",{"_118":305,"_142":-5,"_116":306,"_113":307},12,["D",1738986856785],"5e319ab0-e5d0-11ef-a68e-e6cdfca9ef9f",{"_118":309,"_142":-5,"_116":310,"_113":311},11,["D",1738986826384],"4c13153e-e5d0-11ef-9422-e6cdfca9ef9f",{"_118":313,"_142":-5,"_116":314,"_113":315},10,["D",1738986730551],"12f7e496-e5d0-11ef-baec-e6cdfca9ef9f",{"_118":317,"_142":-5,"_116":318,"_113":319},9,["D",1738986710194],"06d0f266-e5d0-11ef-8bb1-e6cdfca9ef9f",{"_118":321,"_142":-5,"_116":322,"_113":323},8,["D",1738986569615],"b3065748-e5cf-11ef-a22d-e6cdfca9ef9f",{"_118":325,"_142":-5,"_116":326,"_113":327},7,["D",1738986513738],"91b900ae-e5cf-11ef-bbdb-e6cdfca9ef9f",{"_118":329,"_142":-5,"_116":330,"_113":331},6,["D",1738986409406],"53883e94-e5cf-11ef-bbdb-e6cdfca9ef9f",{"_118":333,"_142":-5,"_116":334,"_113":335},5,["D",1738986343011],"2bf560e6-e5cf-11ef-bbdb-e6cdfca9ef9f",{"_118":337,"_142":-5,"_116":338,"_113":339},4,["D",1738986307959],"1711ae64-e5cf-11ef-bbdb-e6cdfca9ef9f",{"_118":341,"_142":-5,"_116":342,"_113":343},3,["D",1738986258542],"f99d2836-e5ce-11ef-9870-e6cdfca9ef9f",{"_118":91,"_142":-5,"_116":345,"_113":346},["D",1738986063594],"856a7ee6-e5ce-11ef-b244-e6cdfca9ef9f",{"_118":348,"_142":-5,"_116":349,"_113":350},1,["D",1738985844514],"02d40344-e5ce-11ef-8f4f-e6cdfca9ef9f",{"_118":32,"_142":-5,"_116":352,"_113":353},["D",1738985012544],"12f1c2c2-e5cc-11ef-9099-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_94":361,"_362":363,"_95":364},"single","redirect","/v/geordie/bandcampcsvprocessor/versions",{"_113":183,"_114":365,"_118":181,"_116":366,"_367":100,"_101":102,"_108":109,"_129":130,"_11":97,"_368":-5,"_369":-5,"_370":-5,"_358":26,"_135":136},"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport Papa from \"https://esm.sh/papaparse@5.4.1\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport React, { useCallback, useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface SalesRecord {\n date: string;\n artist: string;\n itemType: string;\n itemName: string;\n itemPrice: number;\n quantity: number;\n netAmount: number;\n // currency: string;\n}\n\ninterface ArtistSummary {\n name: string;\n totalSales: number;\n totalTracks: number;\n totalAlbums: number;\n releases: Array<{ name: string; type: string; sales: number }>;\n}\n\ninterface MonthlyBreakdown {\n month: string;\n totalSales: number;\n artistSales: Record;\n}\n\nfunction CSVUploader() {\n const [file, setFile] = useState(null);\n const [processingResult, setProcessingResult] = useState<\n {\n artistSummary: ArtistSummary[];\n monthlyBreakdown: MonthlyBreakdown[];\n } | null\n >(null);\n const [error, setError] = useState(null);\n\n // ---- Drag and Drop Handlers ----\n const handleDragOver = useCallback((e: React.DragEvent) => {\n e.preventDefault();\n e.stopPropagation();\n }, []);\n\n const handleDrop = useCallback((e: React.DragEvent) => {\n e.preventDefault();\n e.stopPropagation();\n const droppedFile = e.dataTransfer.files[0];\n\n if (droppedFile && droppedFile.type === \"text/csv\") {\n setFile(droppedFile);\n setError(null);\n } else {\n setError(\"Please drop a valid CSV file\");\n }\n }, []);\n\n // ---- Local CSV Parsing (No server) ----\n const handleFileUpload = useCallback(() => {\n if (!file) return;\n setError(null);\n setProcessingResult(null);\n\n Papa.parse(file, {\n header: true,\n skipEmptyLines: true,\n complete: (results) => {\n // If there's an error in parsing, handle it\n if (results.errors && results.errors.length > 0) {\n console.error(results.errors);\n setError(`Papa Parse encountered ${results.errors.length} errors.`);\n return;\n }\n\n // results.data is an array of row objects\n const parsedRows: any[] = results.data || [];\n\n // Filter out rows that don't have an \"artist\" field (like payout lines)\n // Then map them into a consistent SalesRecord structure\n const salesRecords: SalesRecord[] = parsedRows\n .filter((row) => row.artist && row.artist.trim() !== \"\")\n .map((row) => ({\n date: row.date,\n artist: row.artist,\n itemType: row[\"item type\"],\n itemName: row[\"item name\"],\n itemPrice: parseFloat(row[\"item price\"] || \"0\"),\n quantity: parseInt(row.quantity || \"0\", 10),\n netAmount: parseFloat(row[\"net amount\"] || \"0\"),\n // currency: row.currency,\n }));\n\n // Summarize per artist\n const artistSummary: ArtistSummary[] = Object.entries(\n salesRecords.reduce(\n (acc: Record, record: SalesRecord) => {\n if (!acc[record.artist]) {\n acc[record.artist] = {\n name: record.artist,\n totalSales: 0,\n totalTracks: 0,\n totalAlbums: 0,\n releases: [],\n };\n }\n\n console.log(\"netAmount\", netAmount);\n acc[record.artist].totalSales += record.netAmount;\n\n if (record.itemType === \"track\") {\n acc[record.artist].totalTracks++;\n } else if (record.itemType === \"album\") {\n acc[record.artist].totalAlbums++;\n }\n\n // Accumulate release sales\n const existingRelease = acc[record.artist].releases.find(\n (r) => r.name === record.itemName,\n );\n if (existingRelease) {\n existingRelease.sales += record.netAmount;\n } else {\n acc[record.artist].releases.push({\n name: record.itemName,\n type: record.itemType,\n sales: record.netAmount,\n });\n }\n\n return acc;\n },\n {},\n ),\n ).map(([, summary]) => summary);\n\n // Summarize per month\n const monthlyBreakdown = salesRecords.reduce(\n (acc: MonthlyBreakdown[], record: SalesRecord) => {\n const month = new Date(record.date).toLocaleString(\"default\", {\n month: \"long\",\n year: \"numeric\",\n });\n let monthEntry = acc.find((m) => m.month === month);\n\n if (!monthEntry) {\n monthEntry = {\n month,\n totalSales: 0,\n artistSales: {},\n };\n acc.push(monthEntry);\n }\n\n monthEntry.totalSales += record.netAmount;\n monthEntry.artistSales[record.artist] = (monthEntry.artistSales[record.artist] || 0) + record.netAmount;\n\n return acc;\n },\n [],\n );\n\n setProcessingResult({\n artistSummary,\n monthlyBreakdown,\n });\n },\n });\n }, [file]);\n\n return (\n

\n {error &&

{error}

}\n\n {!file ?

Drag and drop a CSV file here

: (\n

Selected file: {file.name}

\n \n

\n )}\n\n {processingResult && (\n

📊 Financial Report

\n\n

🎵 Artist Earnings

\n \n \n \n \n \n \n \n \n \n \n {processingResult.artistSummary.map((artist) => (\n \n \n \n \n \n \n ))}\n \n

Artist	Total Sales	Tracks	Albums
{artist.name}	AUD {artist.totalSales.toFixed(2)}	{artist.totalTracks}	{artist.totalAlbums}

\n\n

📆 Monthly Breakdown

Month	Total Sales	{artist}
{month.month}	AUD {month.totalSales.toFixed(2)}	AUD {sales.toFixed(2)}

\n\n

💿 Release Details

\n \n \n \n \n \n \n \n \n \n \n {processingResult.artistSummary.flatMap((artist) =>\n artist.releases.map((release, idx) => (\n \n \n \n \n \n \n ))\n )}\n \n

Artist	Release	Type	Sales
{artist.name}	{release.name}	{release.type}	AUD {release.sales.toFixed(2)}

\n )}\n

🎧 Bandcamp Financial Analyzer

\n \n

\n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}",["D",1738989267919],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

bandcampcsvprocessor

Version 43