This one could be difficult, if not impossible.
I am looking to bring a wine vendor under my roof and take a percentage of his profits. The problem I see is breaking down the credit card expense. I use paymentech to process the cards, and the rates vary depending on the card type and transaction type. I do however pay a set rate of $0.12 per credit transaction (and then an additional percentage).
What I would like to be able to do is pull this information off of the jrnl (reg anal report??). I would like to be able to break a transaction down three different ways.
1) food only transaction (wine vender pays nothing) 2) food and wine credit transaction (wine vendor pays $0.6 plus the percentage based on the credit card type). 3) wine only credit transaction (wine vendor pays $0.12 plus the percentage based on the credit card type)I?m not sure if I?m explaining this well, but if so, does anyone have any ideas to generate this type of report (or at least capture the date)?
All input is appreciated!