Xargaar Tools
Xargaar ToolsTurn a Bandcamp sales report into monthly totals and payout checks.
Tested only on made-up files, never on a real Bandcamp export. Column names come from Bandcamp's help page for the raw data sales report, so the tool stops with a message if a needed one is missing. Dates are UTC and their style is not documented, so you choose it. Sales rows are summarized only; the journal covers payouts, where Bandcamp documents the amounts.
Set these to match your files before you drop them. Nothing is guessed. Limits: 20 files, 40 MB each, 200 MB in total, 60,000 rows per file and 300,000 in total.
What it does
Item total, transaction fee, revenue share and change to payout balance for each month and currency, by item type.
Each payout row must satisfy Bandcamp's own description: the payout less the fee is the amount you received. Type your bank amount to see the difference.
Questions
Which file do I use?
On Bandcamp, open your Tools page and download the sales report (raw data). It is a CSV. Drop one or several files here.
Why are there settings?
Number and date styles are not documented, so you tell the tool. Nothing is guessed. Bandcamp times are UTC, so a month is a UTC month.
Does it prove my payout is right?
No. It checks that each payout row adds up the way Bandcamp describes it, and shows the difference from the bank amount you type. Exchange rates and bank fees can explain a difference.
Is the journal entry accounting advice?
No. It is a starting point built from each payout and the accounts you type. Your accountant decides how Bandcamp payouts are booked. The tool makes no tax or accounting claims.
Is anything uploaded?
No. The file is read on your device.