More for other Pros, How do you do accounting for sales?

The Scribe of Light

I'm trying to figure out the best method for tracking my sales with my accounting software.

What I'd like to do, is enter the actual sale as an invoice so I can see what my customers buy over time. However based on the way things are paid, I don't think I can do it.

For example I'd like to create an invoice that has my pricing listed for each item, but I can't figure out a way to 'pay' that invoice once SmugMug pays me because the payment is lower than the invoice because of their comission/costs.

Has anyone tried to track this that way? Or do you just do journal entries for sales out and cost of goods sold and not track it in your own software?

Thanks

Tom Boucher
The Scribe of Light Photography, LLC

PictureThis!

When you apply payment from SmugMug, you can set up a column for discount (or commissions paid) and insert a formula to calculate the commission. Are you doing this in Excel?