Since Shopify opened wholesale to every paid plan, plenty of small brands are now lending to their stockists on net 30, with nothing but the order list to judge them by. This worksheet reads your Shopify order export and shows what each stockist owes, how late they really pay, and a credit limit with the arithmetic behind it. It is free, and your file never leaves your computer.
Download the worksheet Open it in your browser
| For each stockist | How |
|---|---|
| What they owe, and how late | Every open order aged against its due date: not yet due, 1-30, 31-60, 61-90 and over 90 days. |
| How they really pay | Days beyond terms on the orders they have paid, weighted by order size, and the share paid on time. |
| A credit limit | Built from what they buy each month and how promptly they pay, with every step written out so you can disagree with it. |
| What to do now | Good, watch, hold new orders, or prepay only, with the reason in plain words. |
| What a default would cost | The goods you would have given away, and how many of their orders it takes to earn that back. |
It also writes you a one-page credit policy from your settings, and the notice to send a stockist you turn down.
The worksheet is a single web page that runs in your browser. It does not upload your export anywhere, and it cannot: the page carries a security policy that forbids its code from sending or fetching anything over the network. You can open it with your internet switched off, and you can read every line of the method in its source.
The full set, for $49: an editable credit policy, a credit application for stockists, the letters (approval, limit change, hold, decline, and the statement of reasons with the Equal Credit Opportunity Act (ECOA) notice) and a reminder email sequence. To buy it, write to jhaney0214@gmail.com.
The policy and the letters follow Regulation B, which treats net terms as trade credit: a stockist you turn down must hear the decision, and, if they ask in writing within 60 days, the reasons.
Jordan Haney. I work in credit-union finance, where lending without a policy is not allowed, and wrote this for brands that suddenly find themselves lending. It is not legal advice, and the limits are suggestions for you to judge. Questions or corrections: jhaney0214@gmail.com.