Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Check the Distributor's Monthly Statement Against What We Expected to Be Paid?
Problems We Solve

How Do We Check the Distributor's Monthly Statement Against What We Expected to Be Paid?

The distributor's statement nets sales, returns, fees and charges into one payment. We build publishers a reconciliation that explains every line of it.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

A distributor's monthly statement combines sales at various discounts, returns, distribution fees, carriage, storage and other charges into a single payment, and small publishers often accept it because checking it takes too long. We build a reconciliation that imports the statement and its detail, checks fees against your agreement's rates as you enter them, and posts a clear summary to Xero or QuickBooks.

A single figure on the remittance

The payment arrives in the bank with a statement attached: gross sales, less returns, less the distribution fee, less carriage and storage and a few other charges with codes you only half recognise. The finance person posts it to the accounts as one line, 'distributor receipt', because breaking it down would take all afternoon.

At the end of the year, the accountant asks what storage cost the business, and nobody knows without going through twelve statements. Nobody has ever checked whether the fee percentage charged matches the agreement, or whether the carriage lines are for your orders at all.

Why the statement goes unchecked

The statement is built for the distributor's accounting, not yours. It nets many things together and the detail sits in a separate report, if you download it.

  • Fees are charged as percentages of different bases (invoiced value, net receipts), depending on the agreement.
  • Returns in the month relate to sales from earlier months.
  • Service charges have codes rather than descriptions.
  • The detail report and the summary do not always arrive together.
  • Posting everything as one figure hides the cost of distribution in your accounts.

What going unchecked means

Unchecked itemWhy it matters
Fee percentageA wrong rate compounds every month
Storage chargesSlow backlist quietly costs more than it earns
Carriage and small order chargesSome accounts cost more to serve than they bring in
ReturnsNet income overstated in good months
Single-line postingYour accounts show sales but not the cost of distribution

Whether a charge is correct under your agreement is for you and the distributor to settle. The reconciliation shows you where to ask.

Our method for the reconciliation

  1. Import of the monthly statement and the detail report, in the formats your distributor provides.
  2. Your agreement's fee rates and charge types entered once, from the agreement, by you.
  3. Recalculation of the main fees from the detail, and a list of any line that does not match your entered rates.
  4. Charges grouped into categories you choose (distribution fee, carriage, storage, other) with the codes mapped once.
  5. A journal posted to Xero or QuickBooks through its API, splitting the receipt into sales, returns and each cost category, for finance to review.
  6. Monthly and yearly views of distribution costs, by title where the data allows, including storage on slow stock.

Month end with the reconciliation in place

When the statement arrives, the reconciliation runs and the finance person sees a short summary: receipts match, fee calculated at the expected rate, two service charges with codes not seen before. They look into the two lines, ask the distributor about one, and approve the journal. The accounts now show what distribution costs you each month.

At a title level, you can see which slow-moving backlist is costing more in storage than it earns, and decide with the publisher whether to pulp, remainder or move it to print on demand. Those are publishing decisions, and now they come with figures.

When the distribution agreement comes up for review, you have a year of detail to talk about rather than a feeling.

Take a month with a large returns credit from a chain. On a single-line posting, it just looks like a bad month. In the reconciliation, the returns sit on their own line, matched to the titles they relate to, and the fee on the sales side is checked separately from the credit on the returns side. Finance can explain the month to the publisher in two sentences, and the royalty run later uses the same returns figures, so the two never disagree.

Checklist: is your distributor statement a black box?

  • The distributor receipt is posted as one figure.
  • Nobody has checked the fee rate against the agreement recently.
  • You do not know what storage costs per year.
  • Service charge codes are unfamiliar and unchallenged.
  • Returns make monthly income unpredictable and hard to explain.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Will this work with our distributor?

Almost certainly, as long as they provide the statement and detail as files. We build the importer for their format.

Does it tell us the distributor has overcharged?

It shows lines that do not match the rates you entered. Whether a line is wrong is for you to confirm with the distributor.

Can it post to our accounts automatically?

It prepares the journal, and a person approves it before it posts to Xero or QuickBooks.

Is this only useful for larger publishers?

The statements are just as complex for small lists. If your volume is low enough that a manual check is quick, we will tell you.

What do you need from us to start?

A few months of statements and detail reports from your distributor, the fee and charge schedule from your agreement, and access to your accounts package. We reconcile those months first and walk through any differences with you.

Keep reading

More on Problems We Solve

Start here

Tell us which publishing chore eats your week

Describe the task as it runs today: the spreadsheet, the portal, the email thread and who does it. We will tell you what we would build and what we would leave alone, and if your distributor or a tool you already pay for can do it, we will point you there instead.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →