How to create a custom report that would separate wholesale (invoices) from retail sales?

[CoolDogSound]

Hello. We are a small publisher with 5 books in our catalog. 

I'm not sure I'm asking in the right community, but my question has to do with reports. 

We sell direct to buyers via our square store, at book events, and wholesale to book and record stores. The wholesale sales are all invoiced with a discount. We also promo books to reviewers.

The problem I am having is that the way reports are set up, the entry for each book's sales combines numbers for direct sales, wholesale sales, and comps. Because our writers receive royalties based on receipts and paid invoices, I basically have to pull every paid invoice and count the number of wholesale books sold for each writer, calculate the discount (and hope it matches the discount total in the report) and books comp'd, and deduct from sales/gross/discount/net totals in order to separate direct and wholesale sales, remove comp numbers, and calculate royalty amounts.

Is there any way that I can create a custom report that would separate wholesale (invoices) from retail sales?

thank you!

Susan

[MayaP]

Hello @CoolDogSound, thanks for reaching out!

I can see how time-consuming this would be and will tag some super sellers who can share their insight! Thanks everyone @TheRealChipA@Candlestore @alexandriak @rtfulk)! 

[alexandriak]

Have you tried looking at the item sales report and calculating off the net sales?

[CoolDogSound]

Unfortunately, the problem is that wholesale and retail sales are combined in each item, with discounts and comps subtracted from gross = net.

Wholesale is where the discounts come from. Direct sales to buyers on our Square site or at readings are not discounted, so I have to back that amount out of the total, count sales from invoices, and resolve any differences. We don't have a huge volume of sales, but it's tedious.

At the very least, I wish I could get a report of just invoice sales, but that's not available, either.

Thanks for the suggestion, but I think I'm just SOL on this one.

[Candlestore]

@CoolDogSound;

In short there is no way Square would let you pull a Report that would do the calculations you would like to do, all sales are grouped together as you mentioned.

The best way you could see what each Writer has sold is, create the Writer as a Vendor and, when adding a new book by that Vendor assign the Vendor to the Item.   Then you could pull a report that would show all items they sold and the Gross and net amounts, but again your % commission would have to be calculated.   I am not sure how to differentiate between Wholesale and Retail sales using Square.  Square just tracks your Sales, where an Accounting software package can sepperate Wholesale and Retail by having different prices for different Groups.  Ususally when I sell Wholesale I create a Invoice in my Accounting package, this keeps my retail and wholesale sales sepperate.  Even if the Wholesaler pays by Credit card, the Invoice is then marked with the Receipt # from Square.  Usually my Wholesale accounts pay by Check or cash.  Some Accounting packages let you offer different pricing based on Wholesale or Retail or based on Customer groups, Square to my knowledge does not have this.

With Square Reports you can see reports through the Square Dashboard on a computer by Vendor to get what was sold by vedors.  This is why I suggest having the Writer as a Vendor.  You log into Square through a Web Browser Like Chrome for example: Dashboard>Reports>Reports>Inventory Reports>Vendor

Link Here : https://app.squareup.com/dashboard/sales/inventory-reports/vendor-sales

let me know if that helps.