JWillum productsStripeClear Journal
How to reconcile Stripe payouts into a bookkeeping journal (QuickBooks-ready)
Reconcile Stripe payouts in QuickBooks with a clearing account and a journal entry built from a Stripe export. Step-by-step guide.
Free guides
How to do each job by hand, step by step. Each guide links to the tool that does it faster.
Event QR Badges
How to make QR code name badges for an event from a spreadsheet
Make QR code name badges from an Excel or Google Sheets attendee list, plus the printing mistakes that ruin whole sheets.
Etsy Listing CSV Fixer
Etsy listing CSV errors: how to check and clean your listings export
Common Etsy listings CSV errors (long titles, price formats, Excel SKUs, image links) and how to check and clean your export.
Whatnot Seller Profit Calculator
How to calculate your real profit per Whatnot sale after fees
Work out your real profit per Whatnot sale after commission, processing, COGS and shipping, step by step with worked examples.
Shopify CSV Densifier
How to fill the blank rows in a Shopify orders CSV export (for pick and pack lists)
Why a Shopify orders CSV has blank rows for multi-item orders and how to fill them for pick lists, pack slips and 3PL files.
BooksExport Clean
How to clean a QuickBooks Online or Xero export before sending it to your accountant
Clean a QuickBooks Online or Xero transaction export before sending it to your accountant: headers, totals, -Split-, payees, dates.
Shopify Customers MailMerge
How to turn a Shopify customer export into a mail merge address list
Turn a Shopify customer export into a clean mail merge address list for US, UK, Canadian or Australian postcards and labels.
Tracker Invoice Lines
How to turn Toggl, Clockify or Harvest time entries into Xero or Wave invoice lines
Turn Toggl Track, Clockify or Harvest time entries into Xero or Wave invoice lines, one line per client and project.
Faire Wholesale Fee & Profit Calculator
How to calculate your Faire wholesale fees and real profit per order
Calculate Faire wholesale fees, payout and real profit per order for new, reorder and Faire Direct orders, with a worked example.
Bandcamp Sales Clean
How to get Bandcamp sales into Xero or Wave (and why "amount you received" shows 0)
Get Bandcamp sales into Xero or Wave, and learn why "amount you received" shows 0 since Enhanced Payments. Step-by-step guide.
StripeClear Journal
How to reconcile Shopify Payments payouts to bank deposits
Reconcile each Shopify Payments payout to its bank deposit: export transactions, pivot per payout, add a difference column, and handle Capital repayments.
Tracker Invoice Lines
How to convert Toggl or Clockify durations to decimal hours for invoicing
Convert Toggl or Clockify durations (hh:mm:ss, mmm:ss min) to decimal hours in Excel, and round to quarter hours for invoicing.
Tracker Invoice Lines
How to bill flat-fee plus hourly work from Toggl time entries
Bill a flat fee plus hourly prep from Toggl: tag prep and event time, total and round once, and build one hourly and one flat invoice line.