Thanks Stephen, I like the database way of going about this... it's detailed. Fortunately, I don't have a requirement for the taxes and shipping info, these are simply invoices for my service business, so that makes life a little easier.
I didn't consider that multiple deposits in one day might be a problem so I'm glad you mentioned that. thanks rob Stephen M. Butler wrote > Rob, > > I have a small Squarespace business that uses Stripe for processing the > CC payments. I have automated the download of the orders and load those > up into a SQLite3 database so I know the tax and shipping charges per > order. I manually download the payments from Stripe to add in the > processing fees. Several payments may be on each daily deposit (if I > were only that lucky to have daily orders). I record in GnC the > following: > > Asset:Bank:Checking -- Net amount deposited (Debit) > Expense:Fees:Stripe -- Total Processing fees Stripe chaged for all sales > that deposit (Debit) > Expense:Cost-of-Goods-Sold -- My total cost of items sold (see Inventory > side) (Debit) > Income:Sales -- Gross sold amount (not including shipping and taxes) > (Credit) > Income:Shipping -- Amount collected for Shipping/Handling (Credit) > Liability:State Sales Tax -- State portion of sales taxes collected > (Credit) > Liability:Local Sales Tax -- Local portion of sales taxes collected > (Credit) > Asset:Inventory -- COGS to deduct from Inventory (Credit) > > Note that this is per Stripe deposit and not per order. Several orders > may be summed up for each deposit. I thought of summing up the entire > week into one entry but that would get messy when the bank issues a > statement mid-week. > > I wrote a sql statement to get all of these numbers from the database. > I manually enter these into GnC. You could dump the output as a CSV and > import it into GnC to further automate it. When I get to several orders > each day, then I'll make that effort (including the automatic download > of the payment file from Stripe). > > -- > Stephen M Butler, PMP, PSM > Stephen.M.Butler51@ > > kg7je@ > 253-350-0166 -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.